Betrayal at House on the Hill scenario where a hero dies after using a haunt-related item
In general, the heroes work toward a communal goal with a communal pool of successes.

I can't comment on the specific haunt you were playing, because I am not familiar with it, but as a general rule the successes that a hero achieves are shared, and the death of a hero does not invalidate the progress they made.