Mary Winchester was only in the beginning of the pilot of Supernatural. She died when Sam and Dean were little. She appears in and out of seasons. She was killed by a demon. Sam and Deans mom. She just came back to life in season 12 and is currently hunting by herself. Sam and Dean do know she is alive. Brought back by God (see page about god).