Very minor spoilers for - Pushing Daisies, Casino Royale
I hesitate to call these spoilers but for American Beauty & Sunset Boulevard some information is divulged that you may not know; Hamlet -I know it's hundreds of years old but it will be spoiled, and Valkyrie - it's a true story so EVERYONE will know how it ends but this will also be spoiled.
The Trolley Problem is a set of famous thought experiments designed to bring up moral dilemmas and have people examine their ethical decisions. The classic example is to imagine yourself the driver of a runaway trolley (tram) and further down are five people working on the track. The only thing you can do is divert the trolley onto another track but this track has one person on it. Whatever you choose to do at least one person will die. The second part of the thought experiment is to imagine yourself as a doctor with five patients who all need different organs to survive and there is a sixth person who is a donor match for all five people but is perfectly healthy and unwilling to donate their organs. Is it morally right for you as the surgeon to kill the sixth person and give the other patients the organs they need? Most people think it is okay to move the trolley onto another track but wrong for the surgeon to murder one person for their organs but they both have the same outcome - five people alive in exchange for one dead person. These philosophical problems were dealt with adroitly by a programme called Pushing Daisies; it was an odd programme in which the central character, Ned, had the power to bring people back to life, all he needed to do was touch a dead body and they would be resurrected and touching them again would kill them. Ned used this power to help solve murder cases with a private detective he knew and they would split the reward. There are a few strings attached to Ned's power. First, if Ned resurrected someone and touched them again they die and will stay dead. Second, if Ned doesn't touch the person again and allowed them to live somebody else will die in their place. If we compare this to The Trolley Problem most people, I would think, would be of the opinion Ned shouldn't bring someone back from the dead permanently as that would mean another person would die and Ned is taking action that will cause someone's death even if the number of dead and alive people stayed the same. A scenario they never covered with the Trolley Problem was what if one of the people is Anna Friel? Such an oversight is typical of philosophers and when Ned learned of the death of his childhood crush - Chuck played by Anna Friel - he had to decide what to do. Not surprisingly he chose to bring Anna Friel back to life.
There are a lot of deaths in pop culture. Arguably, there should be a lot more, according to the IMDB only five people died on screen in The A-Team despite frequent gunfights, explosions and obligatory car crashes. The A-Team had a similar attitude to Tom & Jerry in regards to death in that no matter what happened the viewer knew that everyone would be okay. Flattened by an anvil? Wait till your body pops back to normal and walk it off. Your car flipped over and crashed upside down? You'll be fine.
Supernatural has so overused the plot of one of the two central characters dying it has taken any tension away from the show and it is even referenced that they have in fact died off-screen many more times. As Supernatural has added angels to their roster of supernatural creatures this issue has only gotten worse. In regards to what happens when you die Supernatural has shown, briefly, both Heaven and Hell and they are distinctly cliched. However, as the show has featured any number of gods outside of Christianity it is possible if you believe in Valhalla that's where you go when you die and so providing endless possible afterlives.
Heroes suffered from this problem as well in regards to Nathan Petrelli dying at the end of every season although admittedly in the first season he is only presumed to be dead but is saved by the popular fiction trope of "magic blood" this not being actually magic but blood somehow imbued with superhuman healing powers and a simple transfusion is enough to undo virtually all damage.
Some characters are entirely immune from whatever happened in the plot - they will return. The two most obvious examples being the Doctor in Doctor Who and James Bond. The Doctor can regenerate and the new run of Doctor Who also seems to have done away with the idea that he has a certain number of lives. Bond is in some ways more interesting in this regard as the character is a human with no special powers. Bond was written as the ultimate Cold War spy but when this ended in the early 90s Bond carried on. In Pierce Brosnan's time as Bond he is referred to as a "cold warrior" and a"dinosaur" meaning that times had moved on and Bond hadn't. To make matters even more complicated Casino Royale is an origins story for Bond as it started with Bond getting his "00" status which he already had in the other films...but Casino Royale is set in the present day and they were in the past...but in those he has his "00" status...so when is this all taking place? This has lead to the curious theory that the name "James Bond" is actually a codename and passed on to new spies. This would explain how Bond has been fighting spies since the 1950s and is still relatively young and radically changed his appearance every few years.
One of the best screen deaths is in Star Trek II: Wrath of Khan. In order to save the ship and everyone on board Spock sacrificed his own life. Using his Vulcan logic he decided that to lose one life to save many made sense. This was genuinely a shocking death when I first saw it. Of course, the next Star Trek film, Search for Spock, had Spock brought back to life. This is a particularly interesting example as in the latest Star Trek film, Star Trek Into Darkness a similar scene played out but in this version it was Kirk who sacrificed his life instead of Spock (again they used "magic blood" to heal him). Now, I hate the JJ Abrams Star Trek films. I hate them with a passion that goes beyond all reasoning. I am very happy to agree with the joke from The Onion Trekkies Bash New Star Trek Film As 'Fun, Watchable' , in the sense that those films don't feel like Star Trek; they feel more like Star Wars. Star Wars is the over the top space adventure with funny robots and magic powers whereas Star Trek has more of an ideology of exploration and cooperation where you learn about alien civilisations. I love Star Wars and Star Trek but they should occupy very different universes. When Kirk died in Star Trek Into Darkness I was happy (even though I knew they would bring him back) and when I watched the film I wanted Khan to win. The "death" of Kirk was nothing compared to the "death" of Spock.
American Beauty and Sunset Boulevard both played with the device of in voiceover at the beginning of the film a character informed the viewer that they are going to die. Usually voiceover in a film would suggest the character is going to survive as they are "telling" you their story. Certainly in American Beauty I was shocked by Lester's death even though I knew it was coming. In Sunset Boulevard there is such a sense of dread I was never able to forget this information. I'm a big fan of the film Valkyrie which is about the plot hatched by German army officers to kill Hitler - the fact that the audience knew Hitler survived did not lessen the tension in the film. The viewer's knowledge of the ultimate failure of their plot only gave more poignancy to their sacrifice. Kenneth Brannagh's character always believed their plot would fail but that it was important to try, if nothing else to show that not everyone in Germany agreed with what Hitler was doing. Inglourious Basterds is a really good film with a couple of terrible bits to it - the first being the message that to deal with Nazis you have to be worse than they are - and secondly, in their Hitler assassination film they do manage to kill Hitler. In fact, they manage to kill him three times as the explosives left by Aldo Raine go off, two of the Basterds shoot Hitler and Shosanna's cinema fire all happen. It is something of a cheat for them to successfully kill Hitler as everyone watching assumed that all the plots failed and so you are hugely surprised when he is killed.
Some things just like to kill everyone and be done with it. In Hamlet only one major character is left alive. If we start with Hamlet's father's then it goes
King Hamlet = ear poison
Polonius = stabbed
Ophelia = suicide (drowned)
Rosencrantz & Guildenstern = killed by King of England
Gertrude = poisoned
Claudius = stabbed and poisoned sword
Laertes = stabbed with poisoned sword
Hamlet = stabbed by poisoned sword.
This death toll may seem excessive until compared to I, Claudius. The classic BBC series based on the books by Robert Graves told the story of Claudius, a minor member of Rome's imperial family who somehow became emperor.
Marcellus = poisoned
Augustus = poisoned
Germanicus = poisoned
Agrippa Postumus = stabbed
Gaius Caesar = poisoned
Lucius Caesar = drowned (murdered)
Sejanus = stabbed
Tiberius = suffocated with a pillow
Caligula = stabbed
Drusilla - murdered by Caligula
Livilla = starved to death (murdered)
Messalina = decapitated
Castor = poisoned
Claudius = poisoned
And I am sure I have missed off some deaths as there are just so many and the amount of poison being splashed about will make even the least paranoid person worry about what is in their food.