He was a member of STS-107 mission crew and he died during Space Shuttle Columbia disaster in 2003 . Ramon was the space shuttle payload specialist of STS-107 , the fatal mission of Columbia , where he and six other crew members were killed in the re-entry accident .