A tragic death underwater was initially shrouded in mystery — with the end explanation revealing suicide as the cause