Majid Mahmood was the city's transport boss when the then-Labour administration declared a road safety emergency in 2024