Contains Spoilers (obviously)
So, I worked out that out of the 55 prominent, female characters that I could recall from Supernatural, 32 of them are definitely dead, (and on 26, of those 32 deaths, we see their death scene, or at least part of it).
I know that there are other females that I have forgotten about but these are the ones that obviously stood out to me as I remembered their stories. Then there’s the fact that I can probably remember the females that appeared in the last season better than the female characters from years ago.
Angels Rachel and Hael are both murdered by Castiel who also kills quite a few of his other Angel siblings, as well as the female vampire Lenore in 7.19 “Mommy Dearest”. In fact, 22 out of the 32 woman characters who have died were murdered by a single male figure, with Lilith, Meg and Abaddon being the only females to kill another prominent female character, (Lilith killing Nancy Fitzgerald in 3.12 “Jus in Belo“, Meg killing the Angel Hester in 7.21 “Reading is Fundamental” and Abaddon killing the Demon Cecily in 9.10 “Road Trip“). The remaining 6 characters were killed by other means, however Kate Milligan was actually killed and eaten by both male and female ghouls.
One of my favourite characters, Jo Harvelle, died from Hellhound wounds which was probably what happened to Bela Talbot as well although we don’t actually see it happen. Jo’s mum, Ellen, dies soon after her daughter by blowing up the remaining Hellhounds with a bomb, committing noble suicide.
I’m going to move onto Dean, who must have killed the majority of the woman on my list: Over the years, he has killed Eve, Demons Ruby and Abaddon, and Reapers April and Tessa whereas for Sam I only have him down as killing Lilith and werewolf Madison, (however you could say he helped out a lot when Dean killed Ruby). Dean also technically kills his cousin Gwen Campbell but he was possessed by the Khan Worm at the time. (So I’m saying that Gwen was killed by the Khan Worm, but people may disagree with me and say that Dean killed her or even Eve as she was the one who created and ordered the Worm to kill, but didn’t physically carry it out herself.)
In terms of villains, the evil Demon Azazel kills three women (Deanna Campbell, Mary Winchester and Jessica Moore), Crowley kills Meg with an Angel blade and Sarah Blake with a hex bag, Metatron kills Naomi and the Archangel Michael kills Anna.
Pamela Barnes and Tara are both killed by a male Demon, the Angel Muriel is killed by a male Angel, Annie Hawkins is killed by a male ghost, and Molly McNamara, even though she technically died due to a car crash, was tortured for years after her death by another male ghost. Similar to the ‘non-supernatural’ death of a car accident, Layla Rourke presumingly died because of an inoperational brain tumor, and Ava was killed by Jake Tulley which was sort of justified because she was murdering a lot of people.
So, I think you can see the pattern that many of the female characters are brutally murdered by men, even if they are innocent. I can understand the deaths of antagonists like Lilith, Eve and Abaddon but Sarah, Pamela, Annie, Muriel, Lenore, Tara (and even Meg a little bit) were all unjustly killed by male figures.
Anyway, female characters who are still currently alive (that we know of) include Angel Hannah, Werewolves Kate, Bess and Violet, Lisa Braedon, Sheriff Jody Mills and Donna Hanscum, Annie Jones, Hunters Krissy Chambers and Tracy Bell, Becky Rosen, Charlie Bradbury, Amelia and Claire Novak, Linda Tran, Missouri Moseley, Cassie Robinson, Marin, Dorothy, Kali, Suzy Lee, Daphne Allen and Amelia Richardson.