Actual records of death, if any, would appear in a soldier's military service file. Any information the family could provide -- normally unconfirmed word-of-mouth accounts -- would be in the widow's pension application. I don't know if such an application exists, but it would be a reasonable source for the story about the soldier's death that you mentioned.