The suspect who drove a vehicle at high speed into a crowd of revellers in New Orleans on New Year's Day was killed after a firefight with police, law enforcement officials have said.