Spreadsheet: 09ae7a7e-fc8e-4eba-b5c4-1e2036a9c697
Sheet: 5 - Collision History

ATTACHMENT 5:  Collision History
Collision Reports
Vasco Road Safety Improvements - Phase 2
Source: Statewide Integrated Traffic Records System (SWITRS), California Highway Patrol (CHP)
 |  | Injury | Fatal |  |  |  |  |  | Injury | Fatal |  |  |  |  |  | Injury | Fatal
1996 | Collisions | Collisions | Collisions | Injuries | Fatalities |  | 1997 | Collisions | Collisions | Collisions | Injuries | Fatalities |  | 1998 | Collisions | Collisions | Collisions | Injuries | Fatalities
1996-01-01 00:00:00 | 2 | 0 | 0 | 0 | 0 |  | 1997-01-01 00:00:00 | 1 | 1 | 0 | 2 | 0 |  | 1998-01-01 00:00:00 | 2 | 0 | 0 | 0 | 0
1996-02-01 00:00:00 | 7 | 4 | 0 | 4 | 0 |  | 1997-02-01 00:00:00 | 1 | 0 | 0 | 0 | 0 |  | 1998-02-01 00:00:00 | 4 | 0 | 0 | 1 | 0
1996-03-01 00:00:00 | 1 | 1 | 0 | 1 | 0 |  | 1997-03-01 00:00:00 | 0 | 0 | 0 | 0 | 0 |  | 1998-03-01 00:00:00 | 1 | 1 | 0 | 1 | 0
1996-04-01 00:00:00 | 1 | 1 | 0 | 3 | 0 |  | 1997-04-01 00:00:00 | 1 | 1 | 0 | 2 | 0 |  | 1998-04-01 00:00:00 | 0 | 0 | 0 | 0 | 0
1996-05-01 00:00:00 | 1 | 1 | 0 | 2 | 0 |  | 1997-05-01 00:00:00 | 3 | 1 | 0 | 2 | 0 |  | 1998-05-01 00:00:00 | 2 | 1 | 0 | 1 | 0
1996-06-01 00:00:00 | 2 | 0 | 0 | 0 | 0 |  | 1997-06-01 00:00:00 | 5 | 3 | 0 | 3 | 0 |  | 1998-06-01 00:00:00 | 1 | 1 | 0 | 3 | 0
1996-07-01 00:00:00 | 5 | 3 | 0 | 5 | 0 |  | 1997-07-01 00:00:00 | 1 | 1 | 0 | 5 | 0 |  | 1998-07-01 00:00:00 | 3 | 0 | 0 | 0 | 0
1996-08-01 00:00:00 | 1 | 1 | 0 | 2 | 0 |  | 1997-08-01 00:00:00 | 0 | 0 | 0 | 0 | 0 |  | 1998-08-01 00:00:00 | 2 | 1 | 0 | 2 | 0
1996-09-01 00:00:00 | 1 | 0 | 0 | 0 | 0 |  | 1997-09-01 00:00:00 | 2 | 2 | 0 | 5 | 0 |  | 1998-09-01 00:00:00 | 7 | 3 | 0 | 3 | 0
1996-10-01 00:00:00 | 1 | 0 | 0 | 0 | 0 |  | 1997-10-01 00:00:00 | 0 | 0 | 0 | 0 | 0 |  | 1998-10-01 00:00:00 | 1 | 0 | 0 | 0 | 0
1996-11-01 00:00:00 | 4 | 3 | 0 | 6 | 0 |  | 1997-11-01 00:00:00 | 2 | 2 | 0 | 3 | 0 |  | 1998-11-01 00:00:00 | 2 | 2 | 0 | 4 | 0
1996-12-01 00:00:00 | 0 | 0 | 0 | 0 | 0 |  | 1997-12-01 00:00:00 | 2 | 1 | 0 | 4 | 0 |  | 1998-12-01 00:00:00 | 2 | 2 | 0 | 2 | 0
Total |  |  |  |  |  |  | Total |  |  |  |  |  |  | Total
 |  | Injury | Fatal |  |  |  |  |  | Injury | Fatal |  |  |  |  |  | Injury | Fatal
1999 | Collisions | Collisions | Collisions | Injuries | Fatalities |  | 2000 | Collisions | Collisions | Collisions | Injuries | Fatalities |  | 2001 | Collisions | Collisions | Collisions | Injuries | Fatalities
1999-01-01 00:00:00 | 4 | 2 | 0 | 5 | 0 |  | 2000-01-01 00:00:00 | 3 | 1 | 0 | 1 | 0 |  | 2001-01-01 00:00:00 | 2 | 1 | 0 | 3 | 0
1999-02-01 00:00:00 | 4 | 1 | 0 | 2 | 0 |  | 2000-02-01 00:00:00 | 9 | 1 | 0 | 3 | 0 |  | 2001-02-01 00:00:00 | 0 | 0 | 0 | 0 | 0
1999-03-01 00:00:00 | 2 | 0 | 0 | 0 | 0 |  | 2000-03-01 00:00:00 | 2 | 1 | 0 | 1 | 0 |  | 2001-03-01 00:00:00 | 3 | 3 | 0 | 3 | 0
1999-04-01 00:00:00 | 3 | 1 | 0 | 1 | 0 |  | 2000-04-01 00:00:00 | 3 | 0 | 0 | 0 | 0 |  | 2001-04-01 00:00:00 | 2 | 1 | 0 | 1 | 0
1999-05-01 00:00:00 | 0 | 0 | 0 | 0 | 0 |  | 2000-05-01 00:00:00 | 1 | 1 | 0 | 2 | 0 |  | 2001-05-01 00:00:00 | 3 | 2 | 0 | 10 | 0
1999-06-01 00:00:00 | 2 | 1 | 0 | 1 | 0 |  | 2000-06-01 00:00:00 | 2 | 1 | 0 | 1 | 0 |  | 2001-06-01 00:00:00 | 1 | 0 | 0 | 0 | 0
1999-07-01 00:00:00 | 3 | 0 | 0 | 0 | 0 |  | 2000-07-01 00:00:00 | 1 | 0 | 0 | 0 | 0 |  | 2001-07-01 00:00:00 | 2 | 0 | 0 | 0 | 0
1999-08-01 00:00:00 | 3 | 2 | 0 | 2 | 0 |  | 2000-08-01 00:00:00 | 0 | 0 | 0 | 0 | 0 |  | 2001-08-01 00:00:00 | 1 | 1 | 0 | 1 | 0
1999-09-01 00:00:00 | 1 | 0 | 0 | 0 | 0 |  | 2000-09-01 00:00:00 | 5 | 3 | 0 | 8 | 0 |  | 2001-09-01 00:00:00 | 2 | 0 | 0 | 0 | 0
1999-10-01 00:00:00 | 3 | 2 | 0 | 2 | 0 |  | 2000-10-01 00:00:00 | 3 | 1 | 0 | 2 | 0 |  | 2001-10-01 00:00:00 | 1 | 1 | 0 | 2 | 0
1999-11-01 00:00:00 | 3 | 0 | 0 | 0 | 0 |  | 2000-11-01 00:00:00 | 5 | 1 | 0 | 3 | 0 |  | 2001-11-01 00:00:00 | 2 | 1 | 0 | 1 | 0
1999-12-01 00:00:00 | 1 | 0 | 0 | 0 | 0 |  | 2000-12-01 00:00:00 | 1 | 0 | 0 | 0 | 0 |  | 2001-12-01 00:00:00 | 4 | 2 | 0 | 3 | 0
Total |  |  |  |  |  |  | Total |  |  |  |  |  |  | Total
 |  | Injury | Fatal |  |  |  |  |  | Injury | Fatal |  |  |  |  |  | Injury | Fatal
2002 | Collisions | Collisions | Collisions | Injuries | Fatalities |  | 2003 | Collisions | Collisions | Collisions | Injuries | Fatalities |  | 2004 | Collisions | Collisions | Collisions | Injuries | Fatalities
2002-01-01 00:00:00 | 3 | 0 | 0 | 0 | 0 |  | 2003-01-01 00:00:00 | 2 | 0 | 0 | 0 | 0 |  | 2004-01-01 00:00:00 | 1 | 1 | 0 | 1 | 0
2002-02-01 00:00:00 | 4 | 2 | 0 | 2 | 0 |  | 2003-02-01 00:00:00 | 1 | 0 | 0 | 0 | 0 |  | 2004-02-01 00:00:00 | 2 | 1 | 0 | 2 | 0
2002-03-01 00:00:00 | 1 | 0 | 0 | 0 | 0 |  | 2003-03-01 00:00:00 | 2 | 1 | 0 | 2 | 0 |  | 2004-03-01 00:00:00 | 5 | 2 | 0 | 3 | 0
2002-04-01 00:00:00 | 4 | 0 | 0 | 0 | 0 |  | 2003-04-01 00:00:00 | 3 | 1 | 0 | 1 | 0 |  | 2004-04-01 00:00:00 | 4 | 1 | 0 | 1 | 0
2002-05-01 00:00:00 | 3 | 1 | 0 | 1 | 0 |  | 2003-05-01 00:00:00 | 1 | 1 | 0 | 1 | 0 |  | 2004-05-01 00:00:00 | 2 | 1 | 0 | 1 | 0
2002-06-01 00:00:00 | 3 | 1 | 0 | 1 | 0 |  | 2003-06-01 00:00:00 | 7 | 4 | 1 | 9 | 3 |  | 2004-06-01 00:00:00 | 2 | 0 | 0 | 0 | 0
2002-07-01 00:00:00 | 5 | 3 | 0 | 6 | 0 |  | 2003-07-01 00:00:00 | 5 | 0 | 0 | 0 | 0 |  | 2004-07-01 00:00:00 | 3 | 1 | 0 | 1 | 0
2002-08-01 00:00:00 | 4 | 1 | 0 | 2 | 0 |  | 2003-08-01 00:00:00 | 7 | 3 | 1 | 6 | 1 |  | 2004-08-01 00:00:00 | 4 | 3 | 0 | 9 | 0
2002-09-01 00:00:00 | 1 | 1 | 0 | 1 | 0 |  | 2003-09-01 00:00:00 | 4 | 1 | 0 | 1 | 0 |  | 2004-09-01 00:00:00 | 3 | 2 | 1 | 3 | 4
2002-10-01 00:00:00 | 3 | 1 | 1 | 1 | 1 |  | 2003-10-01 00:00:00 | 2 | 0 | 0 | 0 | 0 |  | 2004-10-01 00:00:00 | 2 | 0 | 0 | 0 | 0
2002-11-01 00:00:00 | 4 | 1 | 0 | 1 | 0 |  | 2003-11-01 00:00:00 | 3 | 0 | 0 | 0 | 0 |  | 2004-11-01 00:00:00 | 1 | 0 | 0 | 0 | 0
2002-12-01 00:00:00 | 0 | 0 | 0 | 0 | 0 |  | 2003-12-01 00:00:00 | 4 | 2 | 0 | 3 | 0 |  | 2004-12-01 00:00:00 | 5 | 1 | 0 | 1 | 0
Total |  |  |  |  |  |  | Total |  |  |  |  |  |  | Total
 |  | Injury | Fatal |  |  |  |  |  | Injury | Fatal |  |  |  |  |  | Injury | Fatal
2005 | Collisions | Collisions | Collisions | Injuries | Fatalities |  | 2006 | Collisions | Collisions | Collisions | Injuries | Fatalities |  | 2007 | Collisions | Collisions | Collisions | Injuries | Fatalities
2005-01-01 00:00:00 | 7 | 3 | 0 | 4 | 0 |  | 2006-01-01 00:00:00 | 3 | 1 | 0 | 1 | 0 |  | 2007-01-01 00:00:00 | 1 | 0 | 0 | 0 | 0
2005-02-01 00:00:00 | 1 | 1 | 0 | 1 | 0 |  | 2006-02-01 00:00:00 | 0 | 0 | 0 | 0 | 0 |  | 2007-02-01 00:00:00 | 0 | 0 | 0 | 0 | 0
2005-03-01 00:00:00 | 4 | 2 | 0 | 2 | 0 |  | 2006-03-01 00:00:00 | 1 | 1 | 0 | 1 | 0 |  | 2007-03-01 00:00:00 | 1 | 0 | 0 | 0 | 0
2005-04-01 00:00:00 | 3 | 0 | 0 | 0 | 0 |  | 2006-04-01 00:00:00 | 3 | 0 | 0 | 0 | 0 |  | 2007-04-01 00:00:00 | 1 | 0 | 0 | 0 | 0
2005-05-01 00:00:00 | 2 | 1 | 0 | 2 | 0 |  | 2006-05-01 00:00:00 | 2 | 1 | 0 | 1 | 0 |  | 2007-05-01 00:00:00 | 2 | 0 | 0 | 0 | 0
2005-06-01 00:00:00 | 4 | 2 | 1 | 6 | 1 |  | 2006-06-01 00:00:00 | 4 | 2 | 0 | 3 | 0 |  | 2007-06-01 00:00:00 | 3 | 1 | 0 | 1 | 0
2005-07-01 00:00:00 | 1 | 1 | 0 | 1 | 0 |  | 2006-07-01 00:00:00 | 2 | 2 | 0 | 4 | 0 |  | 2007-07-01 00:00:00 | 0 | 0 | 0 | 0 | 0
2005-08-01 00:00:00 | 3 | 1 | 0 | 1 | 0 |  | 2006-08-01 00:00:00 | 6 | 2 | 2 | 2 | 5 |  | 2007-08-01 00:00:00 | 3 | 2 | 0 | 2 | 0
2005-09-01 00:00:00 | 0 | 0 | 0 | 0 | 0 |  | 2006-09-01 00:00:00 | 3 | 1 | 0 | 1 | 0 |  | 2007-09-01 00:00:00 | 0 | 0 | 0 | 0 | 0
2005-10-01 00:00:00 | 6 | 1 | 0 | 1 | 0 |  | 2006-10-01 00:00:00 | 3 | 0 | 0 | 0 | 0 |  | 2007-10-01 00:00:00 | 6 | 3 | 0 | 3 | 0
2005-11-01 00:00:00 | 0 | 0 | 0 | 0 | 0 |  | 2006-11-01 00:00:00 | 1 | 0 | 1 | 0 | 1 |  | 2007-11-01 00:00:00 | 1 | 0 | 0 | 0 | 0
2005-12-01 00:00:00 | 2 | 0 | 0 | 0 | 0 |  | 2006-12-01 00:00:00 | 3 | 1 | 0 | 2 | 0 |  | 2007-12-01 00:00:00 | 2 | 2 | 0 | 2 | 0
Total |  |  |  |  |  |  | Total |  |  |  |  |  |  | Total
 |  | Injury | Fatal
2008 | Collisions | Collisions | Collisions | Injuries | Fatalities
2008-01-01 00:00:00 | 1 | 1 | 0 | 1 | 0
2008-02-01 00:00:00 | 2 | 0 | 0 | 0 | 0
2008-03-01 00:00:00 | 1 | 1 | 0 | 1 | 0
2008-04-01 00:00:00 | 2 | 0 | 0 | 0 | 0
2008-05-01 00:00:00 | 4 | 0 | 0 | 0 | 0
2008-06-01 00:00:00 | 2 | 2 | 0 | 3 | 0
2008-07-01 00:00:00 | 3 | 1 | 0 | 1 | 0
2008-08-01 00:00:00 | 2 | 1 | 0 | 2 | 0
2008-09-01 00:00:00 | 0 | 0 | 0 | 0 | 0
2008-10-01 00:00:00 | 7 | 6 | 0 | 8 | 0
2008-11-01 00:00:00 | 2 | 0 | 0 | 0 | 0
2008-12-01 00:00:00 | 2 | 0 | 0 | 0 | 0
Total
 |  | Injury | Fatal
 | Collisions | Collisions | Collisions | Injuries | Fatalities
Total           1996-2008
 |  | Actual Accident Rate |  |  |  |  | Statewide Average Rate*
Period | Number of Accidents | Fatal (F) | Injury (I) | F + I | All |  | Fatal (F) | Injury (I) | F + I | All | ADT
1996 | See Appendix B: Truck Traffic. Percent truck traffic includes buses and is based on Truck Traffic Turning Movement Counts taken by the Contra Costa County |  |  | 0.12 |  |  | 0.04 | 0.41 | 0.45 | 0.92 | 16322
1997 | Public Works Department from May 12-15, 2008. |  |  | 0.12 |  |  | 0.04 | 0.41 | 0.45 | 0.92
1998 |  |  |  | 0.12 |  |  | 0.04 | 0.41 | 0.45 | 0.92
1999 |  |  |  | 0.12 |  |  | 0.04 | 0.41 | 0.45 | 0.92
2000 |  |  |  | 0.25 |  |  | 0.04 | 0.41 | 0.45 | 0.92
2001 |  |  |  | 0.25 |  |  | 0.04 | 0.41 | 0.45 | 0.92
2002 |  |  |  | 0.15 |  |  | 0.04 | 0.41 | 0.45 | 0.92
2003 | See Appendix A: Traffic Volumes. Affected drivers assuming straight-line approximation (1.5% annual increase) of future traffic volumes from the Contra Costa |  |  | 0.16 |  |  | 0.04 | 0.41 | 0.45 | 0.92
2004 | Transportation Authority Travel Demand Model, 2012. |  |  |  |  |  | 0.04 | 0.41 | 0.45 | 0.92 | 22118
2005 | See Appendix C: Travel Time Savings. Average travel time saved calculated for peak 15-minute period per Chapter 20 - Two lane Highways, HCM 2000. |  |  |  |  |  | 0.04 | 0.41 | 0.45 | 0.92 | 22118
2006 |  |  |  |  |  |  | 0.04 | 0.41 | 0.45 | 0.92 | 22435
2007 |  |  |  |  |  |  | 0.04 | 0.41 | 0.45 | 0.92 | 21728
2008 |  |  |  |  |  |  | 0.04 | 0.41 | 0.45 | 0.92 | 19888
1996-2008 |  |  |  |  |  |  | 0.04 | 0.41 | 0.45 | 0.92
Period | Number of Accidents | Fatals | Injuries | Property Damage Only
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
1996-2008