‘Carson was a fierce competitor in everything he did,’ the school’s assistant football coach said of the teen