A US Air Force serviceman has died after falling from the roof of the Alamodome in San Antonio during a pregame rappelling stunt before a college football game.