ArizonaCyclistFatalities.xls

	A	B	C	D	E	F	G	H	I	J	K	L	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG
1	Please send updates to: cazbikeweb@cazbike.org
2	2018 Arizona Cyclists Killed
3				Bicyclist				Motorist				FARS (prelim file --- light yellow background									ASDM ----- (light green backgound) ------												LOCATION
4	#	Date	Time	Name	Age	City / County	Location	Age	Vehicle/info	comments	link	ST_CASE	sUrbanRural	sLighting	sModel	BikeDir	BikePos	BikeLoc	CrashGroup	CrashType	IncidentID	link	IncidentDateTime	County	City	Oncic	Encic	eCollisionManner	eLightCondition	TotalUnits	TotalNonMotorists	Hit&Run	OnRoad	CrossingFeature	Latitude	Longitude	map link	eTrafficWayType	eIntersectionType	eJunctionRelation	eWeather	b_UnitNumber	eNonMotoristLocation	b_Sex	b_Age	b_Violation1	b_SafetyDevice	b_PersonType	b_Lane	b_Direction	b_Action	c_UnitNumber	c_Sex	c_Age	c_Violation1	c_Lane	c_Direction	c_Action
5
6	1	1/20/2018								found thru datafile only...
7	2	1/31/2018	~ 10AM	NR	male / NR	Pima / Pima	River Road				more on azbikelaw
8	3	2/2/2018								found thru datafile only...
9	4	3/10/2018	~ 330a	NR	NR	Phoenix / Maricopa	Baseline near I-10				more on azbikelaw
10	5	3/29/2018	~ 9pm	Cleon Baker		Glendale / Maricopa	Camelback nr 48th Ave	hit and run	white ford econoline van		more on azbikelaw	missing from asdm as of 10/19
11	6	4/5/2018	1105am	Stefan Ganster	39 / M	kingman	1200 Beale St		dodge pickup		more on azbikelaw
12	7	4/22/2018				show low				found thru datafile only...
13	8	4/24/2018				uninc maricopa co				found thru datafile only...
14	9	4/28				Phx				found thru datafile only...
15	10	5/8/2018	1336	David Alva	71	Sierra Vista / Pima	Buffalo Soldier Trail near Garden Ave			dui driver arrested	more on azbikelaw
16	11	6/4/2018				Tucson				found thru datafile only...
17	12	6/10/2018				i10?				found thru datafile only...
18	13	6/12/2018				Tucson				found thru datafile only...
19	14	7/3/2018				Sahuarita				found thru datafile only...
20	15	7/16/2018				scottsdale				found thru datafile only...
21	16	9/4/2018	"early morn."	Cody Nielsen	20/M	El Mirage / MAricop[a		hit and run	no description(?)		more on azbikelaw
22	17	9/12/2018	1843			Mesa				found thru datafile only...
23	18	9/13/2018	~ 7PM	NR		Gilbert / Maricopa	Baseline, e of Lindsey		suv		more on azbikelaw
24	19	9/26/2018	~4pm	Daniel Clark	24/M	Chandler	Germann & Airport				more on azbikelaw
25	20	10/11/2018	morning	Rick Ellwanger	71/M	Tucson	A mntn	20/F		head-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/2018	6:15 PM	Bryan 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