I also remember the qualifications for the Africa Nations Cup 2-3 years ago
South Africa didn't qualify, but they thought they had. Their administrators and coaches didn't know the result they needed on the final day. As I recall, they got a draw. The players started to celebrate on the field, only to find out that in fact they had needed a win to qualify.