When an investigator’s hit points drop to zero or negative, he or she dies at the end of the following combat round.  During those few seconds a friend might intervene.  See the Healing section for the potential result.
The loss of a well-loved friend is a sorrowful occasion.  It calls for  consolation during play, and acknowledgement and recognition when play is over.