The officer was airlifted to Jackson Memorial Hospital’s Ryder Trauma Center where he succumbed to his injuries