The most shocking death scene that still stands out to me is the death scene at the beginning of "Ghost Ship."

I don't want to spoil it for anyone who has not seen the movie.