A new council report has shed light on the significant financial impact of road harm, with each fatality costing over £2 million