Supernatural foolishly killed off Bobby Singer. Also did it in a really stupid way.
Technically, he was never a lead on the show, but he was very much a regular for quite some time.
He came back due to some kind of multiverse thing. Lame as that is, my wife and I were really happy because we liked Bobby.