College football player dies in tragic accident