It depends on which specific comic series or storyline you're referring to. In some, Archie's dad does die, but not in all. The fate of his character can change based on the creative direction of the writers.
Well, Hellboy's dad passes away due to a combination of factors. There's a series of events involving dark magic and an ancient curse that ultimately leads to his death.
In the comics, Jonathan Kent's death was often depicted as a result of a sudden and severe heart condition. This event had a significant impact on Clark's character development and his sense of responsibility.