The final episode of Quantum Leap is an emotional roller coaster that drops you off a cliff at the end.
Or the episode "Posse Comitatus" from the West Wing, where Mark Harmon`s character gets shot.