Missing Coast Guardsman found dead from self-inflicted gunshot wound