Details behind SAS soldier's death revealed