Football player dies following failed goal celebration