The Secret Service agent who leaped onto the back of President John F. Kennedy's limousine after the president was shot has died