Cold Case episode was number 8, series 1 - 'Fly Away'
Other TV episodes that get me EVERY SINGLE TIME I see them;
ER - 'Love's Labor Lost' (Series 1, ep 20) where Greene loses a mother but saves the baby. It enRAB with him crying on the train going home...
NYPD Blue - 'A Death in the family' (Series 3, episode 20 - I'm noticing a pattern here!) where Andy Jnr gets shot during a bar robbery and Andy Snr goes back to the bottle...
Inspector Morse - 'Dead on Time' (Series 6, episode 1) where Morse investigates a murder and meets up with the only woman he ever loved, only for her to commit suicide later on...
Life Support (a little known BBC1 drama from a few years ago) - Episode 6 where the lead character's Dad dies (played by Richard Wilson) from a heart attack and she finally cracks up at the end of the episode, in the car park, in the rain...
that'll do for starters!