Number and Severity of Arizona bike-MV crashes

TL;DR? Here’s the bottom line:
Something suspicious is happening in 7 larger cities in Arizona ( ‘Chandler’, ‘Flagstaff’, ‘Glendale’, ‘Gilbert’, ‘Mesa’, ‘Scottsdale’, ‘Tempe’). That’s mostly the largest cities in AZ, excluding Phoenix and Tucson. In these 7 places, reported low-severity bike-MV crashes have decreased dramatically comparing before versus after 2014; suggesting some sort of policy change.

It’s been noted that the number of reported Bike-MV crashes reported by police in Arizona have seen a mysterious sharp decrease; even as the number of MV crashes in general has risen. In round numbers through the 2009-2016 period, Bike-MV crashes have fallen by about a third, while crashes overall have increased by 20%. This time period covers the economic downturn following the Financial Crisis of 2008 and subsequent recovery. That trend has been used to explain the MV crash rate; but it doesn’t seem to have anything to do with Bike-MV rates; which would logically rise with more traffic and more (MV) traffic crashes.

Fewer crashes would be a good thing of course, but it feel like there’s something else going here. Also, the number of fatalities, while statistically small,  remained relatively flat but above their longer-term trend of 24 (rolling 10 yr average 2007-2016; refer to internal spreadsheet \crashReports\asdm\AZstats.xls)

Chandler,  Flagstaff, Gilbert, Glendale, Mesa

Number of Arizona bike-MV crashes 2009-2016

Year Bike-MV all MV
2009 2000 107095
2010 1912 106301
2011 1910 103423
2012 2121 103176
2013 2039 107374
2014 1742 109553
2015 1434 116609
2016 1476 126845

 

The large drop-off in Bike-MV figures came in a significant drop in 2014, followed by another signicant drop in 2015. Later on I’m going to refer to the “before-time” as 2009-2013, and the “after-time” as 2015 & 16. The was a yearly drop of 543 cases/yr in the after-time compared to the before-time.

The crash reporting system recognizes a 5 step injury severity scale: No Injury, Possible Injury, Non-incapacitating Injury, Incapacitating Injury, and Fatality. Except for Fatality, the categories are somewhat subjective, and it represents a snap-judgement of the officer filling out the crash report.

Unpacking the Bike-MV by injury severity reveals that there were significant drops in the number of  least-serious (No Injury, Possible, and Non-Incapacitating Injury) crashes, and the more severe category of Incapacitating Injury generally didn’t change much. (Fatals are difficult to intuit because they are very small in absolute numbers, and aren’t useful statistically). Here are the 5 severity categories by year (TODO: collapsed into one table)


IncidentYear Bike-No Injury
2009 330
2010 326
2011 301
2012 376
2013 340
2014 255
2015 140
2016 113

 


IncidentYear Bike-Poss Injury
2009 567
2010 545
2011 544
2012 609
2013 649
2014 581
2015 433
2016 419

IncidentYear Bike-Injury
2009 853
2010 804
2011 808
2012 916
2013 835
2014 720
2015 651
2016 699

IncidentYear Bike-Incap Injury
2009 225
2010 218
2011 234
2012 202
2013 185
2014 158
2015 182
2016 214

IncidentYear Bike-Fatal
2009 25
2010 19
2011 23
2012 18
2013 30
2014 28
2015 28
2016 31

 


Smoking Gun?

If we divide the time period into two epochs with 2014 as the dividing line, the before-time (2009-2013) compared to the after-time (2015 & 2016)  saw a drop (or missing?) of 543 crashes/yr on average.

There are 9 jurisdictions that contribute about 3/4ths of all reported crashes across the state, the other 1/4th comes from dozens of smaller jurisdictions (comfortingly, this hews closely to the Pareto principle of 80/20). Each of the Big 9 is broken out separately in the next section.

Something suspicious is happening in 7 of those 9 places, so in ‘Chandler’, ‘Flagstaff’, ‘Glendale’, ‘Gilbert’, ‘Mesa’, ‘Scottsdale’, ‘Tempe’ (the big 9 excluding Phoenix and Tucson);

— Concern & Disclaimer: is this “Data Mining”? & I almost failed statistics in college —

The number of lesser severity crashes in the before-time is several hundred less per year (392/yr using averages, nearly a 50% reduction!) than in the after-time. This suggests in at least several of these 7 jurisdictions some sort of policy change occurred around the year 2014 that discourages or otherwise doesn’t result in a crash report being filed for lesser severity crashes. There was a drop in serious+fatal but those numbers are both far smaller (question statistical significance) and the drop was fractionally small (that data is not presented below, but it’s readily available upon request).

That 392/yr drop in these 7 places constitutes the lion’s share of the statewide drop of 543/yr. [there’s some remarks below about per city population as a proxy for expected crash rates]

It’s possible, of course, that there could have been a dramatic decrease around 2014 in the number of such crashes in these 7 communities. Statistics can’t tell us whether a drop is a crash that didn’t happen, or merely one that wasn’t reported.

IncidentYear No + Possible + Non-Incap Injuries in selected jurisdictions
2009 753
2010 731
2011 760
2012 853
2013 769
2014 644
2015 376
2016 387

.

The Big 9

The nine jurisdictions, ‘Chandler’, ‘Flagstaff’, ‘Glendale’, ‘Gilbert’, ‘Mesa’, ‘Phoenix’, ‘Scottsdale’, ‘Tempe’, ‘Tucson’ account for around 3/4ths of all reported crashes.

Population-wise the Big 9 are 55% of the state’s population, while the Big 9 excluding Phoenix and Tucson is only 24%. Note that Peoria is high population, 154,065 just a bit fewer than Tempe, with relatively few bike crashes. (2010 census data; there’s a worksheet in the spreadsheet crashReports/asdm/cityTraffic.xls not necessarily online)

 

IncidentYear Bike-MV in Big 9 Jurisdictions
2009 1551
2010 1492
2011 1479
2012 1669
2013 1535
2014 1297
2015 1079
2016 1118

IncidentYear Bike-MV All Other Jurisdictions
2009 449
2010 420
2011 431
2012 452
2013 501
2014 445
2015 355
2016 358

Below are results by each of the nine cities, along with overall counts per city, as well as counts by injury severity.

 

The non-Nine jurisdictions were very consistent.

IncidentYear Jurisdiction count(1)
2009 Chandler 80
2010 Chandler 93
2011 Chandler 98
2012 Chandler 111
2013 Chandler 105
2014 Chandler 69
2015 Chandler 47
2016 Chandler 57
2009 Flagstaff 68
2010 Flagstaff 65
2011 Flagstaff 71
2012 Flagstaff 81
2013 Flagstaff 60
2014 Flagstaff 64
2015 Flagstaff 32
2016 Flagstaff 31
2009 Gilbert 57
2010 Gilbert 71
2011 Gilbert 75
2012 Gilbert 67
2013 Gilbert 72
2014 Gilbert 49
2015 Gilbert 19
2016 Gilbert 23
2009 Glendale 105
2010 Glendale 100
2011 Glendale 96
2012 Glendale 98
2013 Glendale 83
2014 Glendale 72
2015 Glendale 42
2016 Glendale 23
2009 Mesa 227
2010 Mesa 195
2011 Mesa 214
2012 Mesa 237
2013 Mesa 190
2014 Mesa 170
2015 Mesa 134
2016 Mesa 180
2009 Phoenix 469
2010 Phoenix 449
2011 Phoenix 496
2012 Phoenix 536
2013 Phoenix 502
2014 Phoenix 439
2015 Phoenix 453
2016 Phoenix 481
2009 Scottsdale 83
2010 Scottsdale 86
2011 Scottsdale 67
2012 Scottsdale 97
2013 Scottsdale 88
2014 Scottsdale 73
2015 Scottsdale 31
2016 Scottsdale 24
2009 Tempe 205
2010 Tempe 195
2011 Tempe 222
2012 Tempe 236
2013 Tempe 236
2014 Tempe 202
2015 Tempe 127
2016 Tempe 121
2009 Tucson 257
2010 Tucson 238
2011 Tucson 140
2012 Tucson 206
2013 Tucson 199
2014 Tucson 159
2015 Tucson 194
2016 Tucson 178

IncidentYear Jurisdiction eInjurySeverity count(1)
2009 Chandler NO_INJURY 28
2010 Chandler NO_INJURY 23
2011 Chandler NO_INJURY 19
2012 Chandler NO_INJURY 21
2013 Chandler NO_INJURY 25
2014 Chandler NO_INJURY 7
2015 Chandler NO_INJURY 5
2016 Chandler NO_INJURY 10
2009 Flagstaff NO_INJURY 17
2010 Flagstaff NO_INJURY 24
2011 Flagstaff NO_INJURY 19
2012 Flagstaff NO_INJURY 25
2013 Flagstaff NO_INJURY 17
2014 Flagstaff NO_INJURY 16
2015 Flagstaff NO_INJURY 7
2016 Flagstaff NO_INJURY 4
2009 Gilbert NO_INJURY 9
2010 Gilbert NO_INJURY 15
2011 Gilbert NO_INJURY 21
2012 Gilbert NO_INJURY 23
2013 Gilbert NO_INJURY 27
2014 Gilbert NO_INJURY 12
2015 Gilbert NO_INJURY 3
2016 Gilbert NO_INJURY 3
2009 Glendale NO_INJURY 28
2010 Glendale NO_INJURY 32
2011 Glendale NO_INJURY 28
2012 Glendale NO_INJURY 27
2013 Glendale NO_INJURY 16
2014 Glendale NO_INJURY 11
2015 Glendale NO_INJURY 8
2016 Glendale NO_INJURY 7
2009 Mesa NO_INJURY 38
2010 Mesa NO_INJURY 28
2011 Mesa NO_INJURY 27
2012 Mesa NO_INJURY 42
2013 Mesa NO_INJURY 19
2014 Mesa NO_INJURY 25
2015 Mesa NO_INJURY 2
2016 Mesa NO_INJURY 2
2009 Phoenix NO_INJURY 34
2010 Phoenix NO_INJURY 36
2011 Phoenix NO_INJURY 42
2012 Phoenix NO_INJURY 58
2013 Phoenix NO_INJURY 59
2014 Phoenix NO_INJURY 47
2015 Phoenix NO_INJURY 34
2016 Phoenix NO_INJURY 34
2009 Scottsdale NO_INJURY 14
2010 Scottsdale NO_INJURY 11
2011 Scottsdale NO_INJURY 8
2012 Scottsdale NO_INJURY 18
2013 Scottsdale NO_INJURY 11
2014 Scottsdale NO_INJURY 6
2015 Scottsdale NO_INJURY 4
2016 Scottsdale NO_INJURY 3
2009 Tempe NO_INJURY 34
2010 Tempe NO_INJURY 44
2011 Tempe NO_INJURY 43
2012 Tempe NO_INJURY 62
2013 Tempe NO_INJURY 43
2014 Tempe NO_INJURY 46
2015 Tempe NO_INJURY 17
2016 Tempe NO_INJURY 11
2009 Tucson NO_INJURY 37
2010 Tucson NO_INJURY 33
2011 Tucson NO_INJURY 12
2012 Tucson NO_INJURY 15
2013 Tucson NO_INJURY 34
2014 Tucson NO_INJURY 20
2015 Tucson NO_INJURY 19
2016 Tucson NO_INJURY 4
2009 Chandler POSSIBLE_INJURY 21
2010 Chandler POSSIBLE_INJURY 23
2011 Chandler POSSIBLE_INJURY 34
2012 Chandler POSSIBLE_INJURY 36
2013 Chandler POSSIBLE_INJURY 33
2014 Chandler POSSIBLE_INJURY 33
2015 Chandler POSSIBLE_INJURY 13
2016 Chandler POSSIBLE_INJURY 13
2009 Flagstaff POSSIBLE_INJURY 15
2010 Flagstaff POSSIBLE_INJURY 12
2011 Flagstaff POSSIBLE_INJURY 19
2012 Flagstaff POSSIBLE_INJURY 20
2013 Flagstaff POSSIBLE_INJURY 16
2014 Flagstaff POSSIBLE_INJURY 17
2015 Flagstaff POSSIBLE_INJURY 6
2016 Flagstaff POSSIBLE_INJURY 11
2009 Gilbert POSSIBLE_INJURY 22
2010 Gilbert POSSIBLE_INJURY 16
2011 Gilbert POSSIBLE_INJURY 13
2012 Gilbert POSSIBLE_INJURY 11
2013 Gilbert POSSIBLE_INJURY 14
2014 Gilbert POSSIBLE_INJURY 15
2015 Gilbert POSSIBLE_INJURY 4
2016 Gilbert POSSIBLE_INJURY 4
2009 Glendale POSSIBLE_INJURY 42
2010 Glendale POSSIBLE_INJURY 39
2011 Glendale POSSIBLE_INJURY 37
2012 Glendale POSSIBLE_INJURY 45
2013 Glendale POSSIBLE_INJURY 44
2014 Glendale POSSIBLE_INJURY 35
2015 Glendale POSSIBLE_INJURY 19
2016 Glendale POSSIBLE_INJURY 8
2009 Mesa POSSIBLE_INJURY 79
2010 Mesa POSSIBLE_INJURY 76
2011 Mesa POSSIBLE_INJURY 72
2012 Mesa POSSIBLE_INJURY 80
2013 Mesa POSSIBLE_INJURY 71
2014 Mesa POSSIBLE_INJURY 57
2015 Mesa POSSIBLE_INJURY 57
2016 Mesa POSSIBLE_INJURY 71
2009 Phoenix POSSIBLE_INJURY 156
2010 Phoenix POSSIBLE_INJURY 155
2011 Phoenix POSSIBLE_INJURY 148
2012 Phoenix POSSIBLE_INJURY 174
2013 Phoenix POSSIBLE_INJURY 175
2014 Phoenix POSSIBLE_INJURY 147
2015 Phoenix POSSIBLE_INJURY 166
2016 Phoenix POSSIBLE_INJURY 151
2009 Scottsdale POSSIBLE_INJURY 16
2010 Scottsdale POSSIBLE_INJURY 18
2011 Scottsdale POSSIBLE_INJURY 18
2012 Scottsdale POSSIBLE_INJURY 22
2013 Scottsdale POSSIBLE_INJURY 19
2014 Scottsdale POSSIBLE_INJURY 19
2015 Scottsdale POSSIBLE_INJURY 3
2016 Scottsdale POSSIBLE_INJURY 4
2009 Tempe POSSIBLE_INJURY 57
2010 Tempe POSSIBLE_INJURY 55
2011 Tempe POSSIBLE_INJURY 72
2012 Tempe POSSIBLE_INJURY 72
2013 Tempe POSSIBLE_INJURY 80
2014 Tempe POSSIBLE_INJURY 67
2015 Tempe POSSIBLE_INJURY 24
2016 Tempe POSSIBLE_INJURY 21
2009 Tucson POSSIBLE_INJURY 37
2010 Tucson POSSIBLE_INJURY 51
2011 Tucson POSSIBLE_INJURY 31
2012 Tucson POSSIBLE_INJURY 36
2013 Tucson POSSIBLE_INJURY 51
2014 Tucson POSSIBLE_INJURY 56
2015 Tucson POSSIBLE_INJURY 52
2016 Tucson POSSIBLE_INJURY 47
2009 Chandler NON_INCAPACITATING_INJURY 26
2010 Chandler NON_INCAPACITATING_INJURY 40
2011 Chandler NON_INCAPACITATING_INJURY 37
2012 Chandler NON_INCAPACITATING_INJURY 40
2013 Chandler NON_INCAPACITATING_INJURY 39
2014 Chandler NON_INCAPACITATING_INJURY 23
2015 Chandler NON_INCAPACITATING_INJURY 23
2016 Chandler NON_INCAPACITATING_INJURY 24
2009 Flagstaff NON_INCAPACITATING_INJURY 30
2010 Flagstaff NON_INCAPACITATING_INJURY 22
2011 Flagstaff NON_INCAPACITATING_INJURY 26
2012 Flagstaff NON_INCAPACITATING_INJURY 33
2013 Flagstaff NON_INCAPACITATING_INJURY 20
2014 Flagstaff NON_INCAPACITATING_INJURY 30
2015 Flagstaff NON_INCAPACITATING_INJURY 14
2016 Flagstaff NON_INCAPACITATING_INJURY 11
2009 Gilbert NON_INCAPACITATING_INJURY 23
2010 Gilbert NON_INCAPACITATING_INJURY 34
2011 Gilbert NON_INCAPACITATING_INJURY 33
2012 Gilbert NON_INCAPACITATING_INJURY 26
2013 Gilbert NON_INCAPACITATING_INJURY 25
2014 Gilbert NON_INCAPACITATING_INJURY 19
2015 Gilbert NON_INCAPACITATING_INJURY 6
2016 Gilbert NON_INCAPACITATING_INJURY 8
2009 Glendale NON_INCAPACITATING_INJURY 24
2010 Glendale NON_INCAPACITATING_INJURY 21
2011 Glendale NON_INCAPACITATING_INJURY 25
2012 Glendale NON_INCAPACITATING_INJURY 21
2013 Glendale NON_INCAPACITATING_INJURY 20
2014 Glendale NON_INCAPACITATING_INJURY 22
2015 Glendale NON_INCAPACITATING_INJURY 9
2016 Glendale NON_INCAPACITATING_INJURY 7
2009 Mesa NON_INCAPACITATING_INJURY 89
2010 Mesa NON_INCAPACITATING_INJURY 75
2011 Mesa NON_INCAPACITATING_INJURY 84
2012 Mesa NON_INCAPACITATING_INJURY 94
2013 Mesa NON_INCAPACITATING_INJURY 81
2014 Mesa NON_INCAPACITATING_INJURY 61
2015 Mesa NON_INCAPACITATING_INJURY 58
2016 Mesa NON_INCAPACITATING_INJURY 81
2009 Phoenix NON_INCAPACITATING_INJURY 202
2010 Phoenix NON_INCAPACITATING_INJURY 193
2011 Phoenix NON_INCAPACITATING_INJURY 225
2012 Phoenix NON_INCAPACITATING_INJURY 244
2013 Phoenix NON_INCAPACITATING_INJURY 212
2014 Phoenix NON_INCAPACITATING_INJURY 193
2015 Phoenix NON_INCAPACITATING_INJURY 189
2016 Phoenix NON_INCAPACITATING_INJURY 216
2009 Scottsdale NON_INCAPACITATING_INJURY 50
2010 Scottsdale NON_INCAPACITATING_INJURY 39
2011 Scottsdale NON_INCAPACITATING_INJURY 33
2012 Scottsdale NON_INCAPACITATING_INJURY 43
2013 Scottsdale NON_INCAPACITATING_INJURY 48
2014 Scottsdale NON_INCAPACITATING_INJURY 41
2015 Scottsdale NON_INCAPACITATING_INJURY 18
2016 Scottsdale NON_INCAPACITATING_INJURY 9
2009 Tempe NON_INCAPACITATING_INJURY 91
2010 Tempe NON_INCAPACITATING_INJURY 84
2011 Tempe NON_INCAPACITATING_INJURY 92
2012 Tempe NON_INCAPACITATING_INJURY 92
2013 Tempe NON_INCAPACITATING_INJURY 101
2014 Tempe NON_INCAPACITATING_INJURY 82
2015 Tempe NON_INCAPACITATING_INJURY 76
2016 Tempe NON_INCAPACITATING_INJURY 75
2009 Tucson NON_INCAPACITATING_INJURY 147
2010 Tucson NON_INCAPACITATING_INJURY 114
2011 Tucson NON_INCAPACITATING_INJURY 77
2012 Tucson NON_INCAPACITATING_INJURY 118
2013 Tucson NON_INCAPACITATING_INJURY 87
2014 Tucson NON_INCAPACITATING_INJURY 58
2015 Tucson NON_INCAPACITATING_INJURY 102
2016 Tucson NON_INCAPACITATING_INJURY 101
2009 Chandler INCAPACITATING_INJURY 5
2010 Chandler INCAPACITATING_INJURY 7
2011 Chandler INCAPACITATING_INJURY 8
2012 Chandler INCAPACITATING_INJURY 13
2013 Chandler INCAPACITATING_INJURY 7
2014 Chandler INCAPACITATING_INJURY 6
2015 Chandler INCAPACITATING_INJURY 6
2016 Chandler INCAPACITATING_INJURY 8
2009 Flagstaff INCAPACITATING_INJURY 5
2010 Flagstaff INCAPACITATING_INJURY 6
2011 Flagstaff INCAPACITATING_INJURY 6
2012 Flagstaff INCAPACITATING_INJURY 2
2013 Flagstaff INCAPACITATING_INJURY 7
2014 Flagstaff INCAPACITATING_INJURY 1
2015 Flagstaff INCAPACITATING_INJURY 5
2016 Flagstaff INCAPACITATING_INJURY 5
2009 Gilbert INCAPACITATING_INJURY 3
2010 Gilbert INCAPACITATING_INJURY 6
2011 Gilbert INCAPACITATING_INJURY 7
2012 Gilbert INCAPACITATING_INJURY 7
2013 Gilbert INCAPACITATING_INJURY 6
2014 Gilbert INCAPACITATING_INJURY 3
2015 Gilbert INCAPACITATING_INJURY 6
2016 Gilbert INCAPACITATING_INJURY 6
2009 Glendale INCAPACITATING_INJURY 10
2010 Glendale INCAPACITATING_INJURY 8
2011 Glendale INCAPACITATING_INJURY 6
2012 Glendale INCAPACITATING_INJURY 4
2013 Glendale INCAPACITATING_INJURY 3
2014 Glendale INCAPACITATING_INJURY 4
2015 Glendale INCAPACITATING_INJURY 4
2016 Glendale INCAPACITATING_INJURY 1
2009 Mesa INCAPACITATING_INJURY 19
2010 Mesa INCAPACITATING_INJURY 13
2011 Mesa INCAPACITATING_INJURY 29
2012 Mesa INCAPACITATING_INJURY 19
2013 Mesa INCAPACITATING_INJURY 18
2014 Mesa INCAPACITATING_INJURY 23
2015 Mesa INCAPACITATING_INJURY 16
2016 Mesa INCAPACITATING_INJURY 24
2009 Phoenix INCAPACITATING_INJURY 69
2010 Phoenix INCAPACITATING_INJURY 57
2011 Phoenix INCAPACITATING_INJURY 71
2012 Phoenix INCAPACITATING_INJURY 54
2013 Phoenix INCAPACITATING_INJURY 46
2014 Phoenix INCAPACITATING_INJURY 42
2015 Phoenix INCAPACITATING_INJURY 57
2016 Phoenix INCAPACITATING_INJURY 72
2009 Scottsdale INCAPACITATING_INJURY 3
2010 Scottsdale INCAPACITATING_INJURY 16
2011 Scottsdale INCAPACITATING_INJURY 8
2012 Scottsdale INCAPACITATING_INJURY 12
2013 Scottsdale INCAPACITATING_INJURY 9
2014 Scottsdale INCAPACITATING_INJURY 6
2015 Scottsdale INCAPACITATING_INJURY 6
2016 Scottsdale INCAPACITATING_INJURY 8
2009 Tempe INCAPACITATING_INJURY 23
2010 Tempe INCAPACITATING_INJURY 10
2011 Tempe INCAPACITATING_INJURY 15
2012 Tempe INCAPACITATING_INJURY 10
2013 Tempe INCAPACITATING_INJURY 11
2014 Tempe INCAPACITATING_INJURY 6
2015 Tempe INCAPACITATING_INJURY 10
2016 Tempe INCAPACITATING_INJURY 13
2009 Tucson INCAPACITATING_INJURY 34
2010 Tucson INCAPACITATING_INJURY 40
2011 Tucson INCAPACITATING_INJURY 18
2012 Tucson INCAPACITATING_INJURY 36
2013 Tucson INCAPACITATING_INJURY 25
2014 Tucson INCAPACITATING_INJURY 20
2015 Tucson INCAPACITATING_INJURY 18
2016 Tucson INCAPACITATING_INJURY 23
2012 Chandler FATAL 1
2013 Chandler FATAL 1
2016 Chandler FATAL 2
2009 Flagstaff FATAL 1
2010 Flagstaff FATAL 1
2011 Flagstaff FATAL 1
2012 Flagstaff FATAL 1
2011 Gilbert FATAL 1
2016 Gilbert FATAL 2
2009 Glendale FATAL 1
2012 Glendale FATAL 1
2015 Glendale FATAL 2
2009 Mesa FATAL 2
2010 Mesa FATAL 3
2011 Mesa FATAL 2
2012 Mesa FATAL 2
2013 Mesa FATAL 1
2014 Mesa FATAL 4
2015 Mesa FATAL 1
2016 Mesa FATAL 2
2009 Phoenix FATAL 8
2010 Phoenix FATAL 8
2011 Phoenix FATAL 10
2012 Phoenix FATAL 6
2013 Phoenix FATAL 10
2014 Phoenix FATAL 10
2015 Phoenix FATAL 7
2016 Phoenix FATAL 8
2010 Scottsdale FATAL 2
2012 Scottsdale FATAL 2
2013 Scottsdale FATAL 1
2014 Scottsdale FATAL 1
2010 Tempe FATAL 2
2013 Tempe FATAL 1
2014 Tempe FATAL 1
2016 Tempe FATAL 1
2009 Tucson FATAL 2
2011 Tucson FATAL 2
2012 Tucson FATAL 1
2013 Tucson FATAL 2
2014 Tucson FATAL 5
2015 Tucson FATAL 3
2016 Tucson FATAL 3

IncidentYear injSeverity other than the Big 9 count(1)
2009 NO_INJURY 91
2010 NO_INJURY 80
2011 NO_INJURY 82
2012 NO_INJURY 85
2013 NO_INJURY 88
2014 NO_INJURY 65
2015 NO_INJURY 41
2016 NO_INJURY 35
2009 POSSIBLE_INJURY 122
2010 POSSIBLE_INJURY 100
2011 POSSIBLE_INJURY 100
2012 POSSIBLE_INJURY 113
2013 POSSIBLE_INJURY 146
2014 POSSIBLE_INJURY 135
2015 POSSIBLE_INJURY 89
2016 POSSIBLE_INJURY 89
2009 NON_INCAPACITATING_INJURY 171
2010 NON_INCAPACITATING_INJURY 182
2011 NON_INCAPACITATING_INJURY 176
2012 NON_INCAPACITATING_INJURY 205
2013 NON_INCAPACITATING_INJURY 201
2014 NON_INCAPACITATING_INJURY 191
2015 NON_INCAPACITATING_INJURY 156
2016 NON_INCAPACITATING_INJURY 167
2009 INCAPACITATING_INJURY 54
2010 INCAPACITATING_INJURY 55
2011 INCAPACITATING_INJURY 66
2012 INCAPACITATING_INJURY 45
2013 INCAPACITATING_INJURY 52
2014 INCAPACITATING_INJURY 47
2015 INCAPACITATING_INJURY 54
2016 INCAPACITATING_INJURY 54
2009 FATAL 11
2010 FATAL 3
2011 FATAL 7
2012 FATAL 4
2013 FATAL 14
2014 FATAL 7
2015 FATAL 15
2016 FATAL 13


City of Phoenix

As a related corollary, I had pulled together figures for the most recent 5-year period (2012-2016) for City of Phoenix only; and made a table of motorist / Peds / Bicyclists killed and injured…

City of Phoenix PD All Arizona
— KILLED — — INJURED — — KILLED — — INJURED —
Motorist Ped Bicyclist Motorist Ped Bicyclist Motorist Ped Bicyclist Motorist Ped Bicyclist
2009 91 37 8 11,245 493 432 659 122 25 47,804 1,310 1,653
2010 64 46 8 11,068 472 407 587 154 19 47,382 1,241 1,584
2011 63 34 10 11,256 474 448 648 154 23 46,693 1,254 1,605
2012 77 39 6 11,262 471 472 673 132 18 46,594 1,347 1,745
2013 75 53 10 11,476 536 434 655 159 30 47,260 1,358 1,679
2014 73 70 10 12,533 535 382 589 157 28 48,077 1,349 1,469
2015 96 62 7 13,424 563 412 704 161 29 51,043 1,237 1,277
2016 101 88 8 13,399 692 442 734 197 32 53,832 1,449 1,351
Notes for Phoenix table:
Source ADOT Crash Database
This is a person count, the number of crashes of a given type would be slightly to somewhat smaller
Because of the way the numbers are reported, MV crashes involving both a ped and a bike (very rare) are overcounted.
All counts here are only those reported by/to Phoenix PD. This generally excludes freeway crashes (they are investigated by DPS); but this typically omits crashes occurring at freeway interchanges
… counts of motorists, in particular are much higher if other-than Phoenix PD is included. Counts of bicyclists/peds would be marginally higher

The number of reported bicyclist injuries have been relatively flat throughout the period. Pedestrian injuries are up, and Ped killed is up sharply.

 

Queries

 

select IncidentYear "Year", SUM(sF_Bicycle) "Bike-MV", SUM(sF_Motorist) "all MV" from incident GROUP BY 1;
select IncidentYear, count(*) "Bike-NoInj" from incident WHERE sF_Bicycle AND eInjurySeverity LIKE ('NO_INJURY') GROUP BY 1;
select IncidentYear, count(*) "Bike-PossInj" from incident WHERE sF_Bicycle AND eInjurySeverity LIKE ('POSSIBLE_INJURY') GROUP BY 1;
select IncidentYear, count(*) "Bike-Injury" from incident WHERE sF_Bicycle AND eInjurySeverity LIKE ('NON_INCAPACITATING_INJURY') GROUP BY 1;
select IncidentYear, count(*) "Bike-IncapInj" from incident WHERE sF_Bicycle AND eInjurySeverity LIKE ('INCAPACITATING_INJURY') GROUP BY 1;
select IncidentYear, count(*) "Bike-Fatal" from incident WHERE sF_Bicycle AND eInjurySeverity LIKE ('FATAL') GROUP BY 1;

SELECT IncidentYear, eInjurySeverity "injSeverity in selected jurisdictions", count(1)
FROM ( incident AS i )
LEFT OUTER JOIN LOVNcic ON i.OfficerNcic = LOVNcic.ID
WHERE  sF_Bicycle AND LOVNcic.name IN ('Chandler', 'Flagstaff', 'Glendale', 'Gilbert', 'Mesa', 'Scottsdale', 'Tempe') GROUP BY 2,1 ;

SELECT IncidentYear, count(1) "No + Possible + Non-Incap Injuries in selected jurisdictions"
FROM ( incident AS i )
LEFT OUTER JOIN LOVNcic ON i.OfficerNcic = LOVNcic.ID
WHERE  sF_Bicycle AND LOVNcic.name IN ('Chandler', 'Flagstaff', 'Glendale', 'Gilbert', 'Mesa', 'Scottsdale', 'Tempe')
AND eInjurySeverity IN ('NO_INJURY', 'POSSIBLE_INJURY', 'NON_INCAPACITATING_INJURY' )  GROUP BY 1 ;

SELECT IncidentYear, count(1) "Bike-MV in Big 9 Jurisdictions"
FROM ( incident AS i )
LEFT OUTER JOIN LOVNcic ON i.OfficerNcic = LOVNcic.ID
WHERE sF_Bicycle AND LOVNcic.name IN ('Chandler', 'Flagstaff', 'Glendale', 'Gilbert', 'Mesa', 'Phoenix', 'Scottsdale', 'Tempe', 'Tucson') GROUP BY 1;

SELECT IncidentYear, count(1) "Bike-MV All Other Jurisdictions"
FROM ( incident AS i )
LEFT OUTER JOIN LOVNcic ON i.OfficerNcic = LOVNcic.ID
WHERE sF_Bicycle AND LOVNcic.name NOT IN ('Chandler', 'Flagstaff', 'Glendale', 'Gilbert', 'Mesa', 'Phoenix', 'Scottsdale', 'Tempe', 'Tucson') GROUP BY 1 ;

SELECT IncidentYear, LOVNcic.name "Jurisdiction", count(1)
FROM ( incident AS i )
LEFT OUTER JOIN LOVNcic ON i.OfficerNcic = LOVNcic.ID
WHERE sF_Bicycle AND LOVNcic.name IN ('Chandler', 'Flagstaff', 'Glendale', 'Gilbert', 'Mesa', 'Phoenix', 'Scottsdale', 'Tempe', 'Tucson') GROUP BY 2,1 HAVING count(1) > 1 ;

SELECT IncidentYear, LOVNcic.name "Jurisdiction", eInjurySeverity, count(1)
FROM ( incident AS i )
LEFT OUTER JOIN LOVNcic ON i.OfficerNcic = LOVNcic.ID
WHERE sF_Bicycle AND LOVNcic.name IN ('Chandler', 'Flagstaff', 'Glendale', 'Gilbert', 'Mesa', 'Phoenix', 'Scottsdale', 'Tempe', 'Tucson') GROUP BY 3,2,1 ;

SELECT IncidentYear, eInjurySeverity "injSeverity other than the Big 9", count(1)
FROM ( incident AS i )
LEFT OUTER JOIN LOVNcic ON i.OfficerNcic = LOVNcic.ID
WHERE sF_Bicycle AND LOVNcic.name NOT IN ('Chandler', 'Flagstaff', 'Glendale', 'Gilbert', 'Mesa', 'Phoenix', 'Scottsdale', 'Tempe', 'Tucson') GROUP BY 2,1 ;

Here are queries for City of Phoenix vs. State; note that these are people counts, not crash counts:

SELECT SUM(TotalMotoristsFatalities), SUM(TotalNonMotoristsFatalities),
SUM(TotalMotoristsInjuries), SUM(TotalNonMotoristsInjuries)
FROM ( 2012_incident AS i )
LEFT OUTER JOIN LOVNcic ON i.OfficerNcic = LOVNcic.ID
WHERE LOVNcic.name ='Phoenix' AND i.IncidentYear IN (2012, 2013, 2014, 2015, 2016) ;

SELECT SUM(TotalMotoristsFatalities), SUM(TotalNonMotoristsFatalities),
SUM(TotalMotoristsInjuries), SUM(TotalNonMotoristsInjuries)
FROM ( 2012_incident AS i )
LEFT OUTER JOIN LOVNcic ON i.OfficerNcic = LOVNcic.ID
WHERE LOVNcic.name ='Phoenix' AND i.IncidentYear IN (2012, 2013, 2014, 2015, 2016) AND sF_Pedestrian ;

SELECT SUM(TotalMotoristsFatalities), SUM(TotalNonMotoristsFatalities),
SUM(TotalMotoristsInjuries), SUM(TotalNonMotoristsInjuries)
FROM ( 2012_incident AS i )
LEFT OUTER JOIN LOVNcic ON i.OfficerNcic = LOVNcic.ID
WHERE LOVNcic.name ='Phoenix' AND i.IncidentYear IN (2012, 2013, 2014, 2015, 2016) AND sF_Bicycle ;

SELECT SUM(TotalMotoristsFatalities), SUM(TotalNonMotoristsFatalities),
SUM(TotalMotoristsInjuries), SUM(TotalNonMotoristsInjuries)
FROM ( 2012_incident AS i )
WHERE i.IncidentYear IN (2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016) ;

SELECT SUM(TotalMotoristsFatalities), SUM(TotalNonMotoristsFatalities),
SUM(TotalMotoristsInjuries), SUM(TotalNonMotoristsInjuries)
FROM ( 2012_incident AS i )
WHERE i.IncidentYear IN (2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016) AND sF_Pedestrian ;

SELECT SUM(TotalMotoristsFatalities), SUM(TotalNonMotoristsFatalities),
SUM(TotalMotoristsInjuries), SUM(TotalNonMotoristsInjuries)
FROM ( 2012_incident AS i )
WHERE i.IncidentYear IN (2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016) AND sF_Bicycle ;

.

 

Leave a Reply

Your email address will not be published. Required fields are marked *