ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
[year] cost of traffic crashes in [city/area/county]
2
2022 NSC estimated economic cost per traffic crash incident2022 NSC estimated comprehensive cost per traffic crash incidentPeople Impacted by [year city/county/area] traffic crashes[year] estimated economic costs[year] estimated comprehensive costs
3
Total Cost$304,940,484$1,225,468,980
4
Fatalities (Fatal Injury)$1,869,000$13,111,00023$46,425,960$325,677,240
5
Suspected Serious Injuries$162,000$1,066,00081$14,171,760$93,253,680
6
Non-incapacitating injuries (Suspected minor injury)$42,000$232,000906$41,096,160$227,007,360
7
Possible injuries$26,000$126,0001,175$32,994,000$159,894,000
8
No injury observed (not injured or unknown)$7,100$17,50022,203$170,252,604$419,636,700
9
10
Economic Cost Estimate Using NSC Per Death Basis$11,880,00023$273,240,000
11
Total number of people in involved in a crash24,388
12
13
National Safety Council Guide to Calculating Costs of Motor-Vehicle Injuries:
14
https://injuryfacts.nsc.org/all-injuries/costs/guide-to-calculating-costs/data-details/
15
16
Traffic crash data should be retrieved from TXDOT’s Public CRIS Query system:
17
https://cris.dot.state.tx.us/public/Query/app/home
18
19
Instructions:
20
1. Copy this spreadsheet into a new spreadsheet that you can edit.
21
2. Use the CRIS link above to find data on your area (see below).
22
3. Fill in all the blue data points on this chart.
23
4. Change the title to fit what you did and the dates in the column headers and remove all these instructions below.
24
25
How to use CRIS to find data on your area:
26
1. Click "start building a query."
27
2. For "Query Type," select "I want to find Persons that were involved in crashes that meet a certain set of criteria"
28
3. Choose the Date and Time that you are hoping to look at. You can pick a year or a series of years. The NSC estimates above are for 2019.
29
4. Choose your geographic area, which can be a city, county, all of Texas, an MPO, more complex searches, or even drawing on a map.
30
5. The total number of people at the bottom right is what you should type into field D11 above.
31
6. If results are less than 50,000, you can proceed by clicking "View Results" and proceed to 7A below. If not, skip down to 7B below
32
7A. Select Charts and Graph view, and change the Category Field to "Person Injury Severity"
33
8A. These are the numbers to input in the chart above for fatalities, serious injuries, non-incapacitating injuries, and possible injuries.
34
(Hover over the columns in your chart to see column names and data if they're obscured).
35
36
7B. Skip down to the "Additional Filters" tab.
37
8B. Add a filter.
38
9B. Select the "Person Injury Severity" field.
39
10B. Select "Is Equal To" as your operator and then select each data point above as your value, such as "Suspected Minor Injury."
40
41
If you need help with this or with convincing your local government to adopt Vision Zero, please contact jay@farmandcity.org
42
43
Note: This formula includes an adjustment for inflation to compensate for using 2019 NSC estimates of costs and 2018 crash totals.
44
You can obtain the number to use to adjust for inflation between any two years here: https://www.in2013dollars.com/us/inflation/
45
Inflation adjustment:1.08
46
Inflation years2021->2022
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100