Footballer Tyler Fairman, who played for Woodthorpe Park Rangers, died in hospital after being hit by a Vauxhall Astra following an awards night.