Britain's Olympic sailing gold medallist Andrew Simpson has been killed following a training accident in San Francisco Bay.