How old was Dean when John died?

26 or 27. Dean was born in the year 1979, John died in the first episode of Season 2, so, yeah, Dean was about 27.

He was 27 when John died. In the Pilot Dean says that he's currently 26, and since each season is a year long he would have turned 27 by season 2 episode 1.