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

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBH
1
Please send updates to: cazbikeweb@cazbike.org
2
2020 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
1/5/2020datafile only3641915click2020-01-05 12:58:00MARICOPAUNSPECIFIED_999
Maricopa County S.O.
Maricopa County S.O.
OTHER_97DAYLIGHT210
07 NORTHERN AVE
177th Ave33.55167071-112.4399309click
TWO_WAY_NOT_DIVIDED
NOT_REPORTED_255
INTERSECTION_4_WAY
1
AT_INTERSECTION_NOT_IN_CROSSWALK
Male86RAN_STOP_SIGNNONE_USEDPEDALCYCLISTLANE_1NORTH
GOING_STRAIGHT_AHEAD
2Female51
NO_IMPROPER_ACTION
LANE_1EAST
GOING_STRAIGHT_AHEAD
6
1/17/2020530pmMario Hernandez Roman25 / M15th and Southernhit/runhttps://azbikelaw.org/phoenix-bicyclist-killed-by-hit-run-suv-driver/(not yet in datafile) as of 5/2020
7
2/25/2020datafile only3637785click2020-02-25 18:35:00NAVAJOSNOWFLAKESnowflakeSnowflakeOTHER_97DUSK210
09N OLD WOODRUFF RD E
E 24th St N34.54239158-110.0527846click
TWO_WAY_NOT_DIVIDED
NOT_AT_INTERSECTION_0
NOT_JUNCTION_RELATED_0
2
SHOULDER_ROADSIDE
Male60
NO_IMPROPER_ACTION
HELMET_USEDPEDALCYCLISTLANE_1SOUTH
GOING_STRAIGHT_AHEAD
1Male24
SPEED_TOO_FAST_FOR_CONDITIONS
LANE_1NORTH
NEGOTIATING_A_CURVE
8
3/30/2020datafile only3640559click2020-03-30 5:50:00COCHISEBENSON
Dept. of Public Safety
BensonOTHER_97
DARK_NOT_LIGHTED
211I 010 0M30631.97370075-110.2864073click
TWO_WAY_DIVIDED_UNPROTECTED_PAINTED_4_FEET_MEDIAN
NOT_AT_INTERSECTION_0
NOT_JUNCTION_RELATED_0
2
NOT_AT_INTERSECTION_ON_ROADWAY_NOT_IN_CROSSWALK
Male59OTHER_97NONE_USEDPEDALCYCLISTLANE_2WESTUNKNOWN_991Unspec119UNKNOWN_99UNKNOWN_99WEST
GOING_STRAIGHT_AHEAD
9
4/1/2020NR61 / FPima co.Manville rd3640096click2020-04-01 18:37:00PIMAUNSPECIFIED_999Pima County S.O.Pima County S.O.
SIDESWIPE_SAME_DIRECTION
DUSK21010 MANVILLE RDAvra Rd32.29173881-111.2489225click
TWO_WAY_NOT_DIVIDED
NOT_AT_INTERSECTION_0
NOT_JUNCTION_RELATED_0
2OTHER_97Female61
NO_IMPROPER_ACTION
NOT_APPLICABLE_0
PEDALCYCLISTLANE_1WEST
GOING_STRAIGHT_AHEAD
1Female27OTHER_97CROSSWALK_20WEST
GOING_STRAIGHT_AHEAD
10
5/6/20202300Anthony Groth61 / MPhoenix7th St and Hatcher26 / Fsedanposs. dui?https://azbikelaw.org/man-on-bike-hit-and-killed-by-car-in-north-phoenix/
11
5/9/2020morning?Ed Rockland70's / MChandlerHunt Highway near Val Vista.distractedhttps://azbikelaw.org/killed-in-bike-lane-by-distracted-driver/
12
5/10/2020around 7pNicole Hicks35 / Fphoenix32nd & Broadwaytruck and horse trailerdriver red light violationhttps://azbikelaw.org/woman-bicyclist-killed-in-collision-w-truck-horse-trailer/
13
5/21/2020around 7p
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
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.InjurySeverity, 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 (((( 2020_incident AS i JOIN 2020_person AS p_bike ON i.IncidentID = p_bike.IncidentID) JOIN 2020_unit AS u_bike ON p_bike.UnitID = u_bike.UnitID) JOIN 2020_person AS p_car ON i.IncidentID = p_car.IncidentID) JOIN 2020_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;
32
33
34
35
36
37
38
39
40
41
42
43
44
45
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...