ArizonaCyclistFatalities.xls
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBG
1
Please send updates to: cazbikeweb@cazbike.org
2
2018 Arizona Cyclists Killed
3
BicyclistMotoristFARS (prelim file --- light yellow background ASDM ----- (light green backgound) ------LOCATION
4
# DateTimeNameAgeCity / CountyLocationAgeVehicle/infocommentslinkST_CASEsUrbanRuralsLightingsModelBikeDirBikePosBikeLocCrashGroupCrashTypeIncidentIDlink
IncidentDateTime
CountyCityOncicEncic
eCollisionManner
eLightConditionTotalUnits
TotalNonMotorists
Hit&RunOnRoad
CrossingFeature
LatitudeLongitudemap link
eTrafficWayType
eIntersectionType
eJunctionRelation
eWeatherb_UnitNumber
eNonMotoristLocation
b_Sexb_Ageb_Violation1b_SafetyDeviceb_PersonTypeb_Laneb_Directionb_Actionc_UnitNumberc_Sexc_Agec_Violation1c_Lanec_Directionc_Action
5
6
11/20/2018
found thru datafile only...
7
21/31/2018~ 10AMNRmale / NRPima / PimaRiver Roadmore on azbikelaw
8
32/2/2018
found thru datafile only...
9
43/10/2018~ 330aNRNR
Phoenix / Maricopa
Baseline near I-10
more on azbikelaw
10
53/29/2018~ 9pmCleon Baker
Glendale / Maricopa
Camelback nr 48th Ave
hit and runwhite ford econoline vanmore on azbikelawmissing from asdm as of 10/19
11
64/5/20181105amStefan Ganster39 / Mkingman1200 Beale Stdodge pickupmore on azbikelaw
12
74/22/2018show low
found thru datafile only...
13
84/24/2018uninc maricopa co
found thru datafile only...
14
94/28Phx
found thru datafile only...
15
105/8/20181336David Alva71
Sierra Vista / Pima
Buffalo Soldier Trail near Garden Ave
dui driver arrestedmore on azbikelaw
16
116/4/2018Tucson
found thru datafile only...
17
126/10/2018i10?
found thru datafile only...
18
136/12/2018Tucson
found thru datafile only...
19
147/3/2018Sahuarita
found thru datafile only...
20
157/16/2018scottsdale
found thru datafile only...
21
169/4/2018"early morn."Cody Nielsen20/M
El Mirage / MAricop[a
hit and runno description(?)more on azbikelaw
22
179/12/20181843Mesa
found thru datafile only...
23
189/13/2018~ 7PMNR
Gilbert / Maricopa
Baseline, e of Lindsey
suvmore on azbikelaw
24
199/26/2018~4pmDaniel Clark24/MChandlerGermann & Airportmore on azbikelaw
25
2010/11/2018morningRick Ellwanger71/MTucsonA mntn20/Fhead-on; driver arrested;more on azbikelaw
26
21
27
28
29
30
31
Incidents below this line are not (statistically-speaking) "Pedalcyclist" collisions for one reason or another:
32
33
1/16/2018
unconfirmed / unknown. This was on the AP wire
MISSING MAN-DEAD: A man who was reported missing after he didn't return from a bicycle ride in Sun City West has been found dead in a canal.
34
2/22/20186:15 PMBryan Blair
murdered while cycling,
not a traffic crash
(no MV involved)
more on azbikelaw
35
8/13/2018
Ben A. Rensvold
died in Tucson, AZ, after suffering a severe injury following a cycling accident; This was a fall, in a park or trail; no MV involved.
https://www.legacy.com/obituaries/tucson/obituary.aspx?n=ben-a-rensvold&pid=190057680
36
37
38
39
40
query:
41
SELECT i.IncidentID, i.IncidentDateTime, i.IncidentYear, LOVCounty.name County,LOVCity.name City,
OffNcic.name Oncic,ExtNcic.name Encic, i.OfficerId, i.OfficerNcic, i.ExtendedNcic,
i.eCollisionManner, i.eLightCondition, i.TotalUnits, i.TotalNonMotorists, i.eInjurySeverity, i.HitAndRunFlag,
i.OnRoad, i.CrossingFeature, i.Latitude, i.Longitude, i.eTrafficWayType, i.eIntersectionType, i.eJunctionRelation, i.eWeather,
p_bike.UnitNumber b_UnitNumber, p_bike.eNonMotoristLocation, p_bike.eSex b_Sex, p_bike.Age b_Age, p_bike.eViolation1 b_Violation1,
p_bike.eSafetyDevice b_SafetyDevice, p_bike.ePersonType b_PersonType, u_bike.eLane b_Lane, u_bike.eTravelDirection b_Direction, u_bike.eUnitAction b_Action,
p_car.UnitNumber c_UnitNumber, p_car.eSex c_Sex, p_car.Age c_Age, p_car.eViolation1 c_Violation1, u_car.eLane c_Lane, u_car.eTravelDirection c_Direction, u_car.eUnitAction c_Action
FROM (((( 2018_incident AS i JOIN 2018_person AS p_bike ON i.IncidentID = p_bike.IncidentID) JOIN 2018_unit AS u_bike ON p_bike.UnitID = u_bike.UnitID) JOIN 2018_person AS p_car ON i.IncidentID = p_car.IncidentID) JOIN 2018_unit AS u_car ON p_car.UnitID = u_car.UnitID ) LEFT OUTER JOIN LOVCounty ON i.CountyId = LOVCounty.id LEFT OUTER JOIN LOVCity ON i.CityId = LOVCity.id LEFT OUTER JOIN LOVNcic AS OffNcic ON i.OfficerNcic = OffNcic.id LEFT OUTER JOIN LOVNcic AS ExtNcic ON i.ExtendedNcic = ExtNcic.id WHERE p_bike.eInjuryStatus = 'FATAL' AND p_bike.ePersonType = 'PEDALCYCLIST' AND p_car.ePersonType='DRIVER' ORDER BY i.IncidentDateTime;
42
43
44
asdm 2018 temporary query:
45
SELECT IncidentID,IncidentDateTime,CityId, LOVCity.name,Onroad,CrossingFeature FROM 2018_incident i LEFT OUTER JOIN LOVCity ON i.CityId = LOVCity.id WHERE InjurySeverity=5 AND sF_Bicycle ORDER BY IncidentDateTime ;
46
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
Loading...
Main menu