"Pretty sure that wasn't supposed to happen," said a witness who saw the tourists drive into the water