Ohio.gov State Agencies  |  Online Services
Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In
Division of Planning
Systems Planning & Program Management
Safe Routes to School Crash Statistics

Instructions for use of Ohio School Crash Statistics:

  1. Use link to the right to Open Excel 2007 Document.
  2. Click on arrow in Column F and choose County. This will narrow results by  the county you are researching.
  3. Click on arrow in Column G and choose City, Village or Township by name. This will further narrow the results by jurisdiction (there will be some overlap with this selection).
  4. Click on arrow in Column C and choose School by name. This will further narrow results by school.
  5. Select and Copy all visible fields.
  6. Open new book in Excel.
  7. Paste Special and select formulas to paste information (including map links) into new book (This step is crucial.  If you do not paste into new book, all statewide information will be accessed during the next step).
  8. Save the new book to your computer.  
  9. The result will be the accidents for the specific school you are researching.
  10. The procedure may have to be repeated for multiple schools. (Note: Crashes are unique by school.  If looking for all crashes in a school district, it will be likely that duplicates exist).

Remember to further narrow results to areas students actually use, or have the potential to use, to travel back and forth to school.

The following table contains statewide crash data for the number of Bicycles and Pedestrians involved in a crash within 2 miles of a k-8 school.

2011 - 2013 Crashes (All Ages)
Pedestrian Involved Bicycle Involved Totals
No Injury 448 No Injury 714 1,162
Possible Injury 1,894 Possible Injury 1,278 3,172
Non-Incapacitating Injury 2,929 Non-Incapacitating Injury 2,080 5,009
Incapacitating Injury 1,362 Incapacitating Injury 570 1,932
Fatal Injury 254 Fatal Injury 42 296
Unknown Injury 238 Unknown Injury 164 402
2011-2013 Total 7,125 2011-2013 Total 4,848 11,973
2010-2012 Total 6,987 2010-2012 Total 4,905 11,866
Percent Change 1.98% Percent Change -1.16% 0.90%

2011 - 2013 Crashes (Ages 5 to 14)
Pedestrian Involved Bicycle Involved Totals
No Injury 78 No Injury 174 252
Possible Injury 280 Possible Injury 355 635
Non-Incapacitating Injury 525 Non-Incapacitating Injury 563 1,088
Incapacitating Injury 237 Incapacitating Injury 127 364
Fatal Injury 13 Fatal Injury 5 18
Unknown Injury 34 Unknown Injury 28 62
2011-2013 Total 1,167 2011-2013 Total 1,252 2,419
2010-2012 Total 1,187​ ​2010-2012 Total 1,358​ 2,542​
​Percent Change -1.44%​ ​Percent Change -7.81%​ -4.84%​


For the Crash Report Help File: Click Here

For the Ohio Department of Public Safety Statewide Crash Statistics: Click Here  

Instructions to obtain specific OH-1 Reports from ODPS:

  1. In Excel, sort crashes by year.
  2. Copy Document Numbers by Year in groups of 100 records.
  3. Only one year can be searched at a time.
    1. If a specific year has more than 100 records, view the records in multiple groups not exceeding the 100 record limit. 
  4. Paste Document Numbers into the "Document Number" field.
  5. Fill in the "Code" in the yellow box, and select the "Submit" button.
  6. Click the "Get Report Date" button.
  7. Click "Select Report" hyperlink next to each specific crash record to view the OH-1 Report Document.



Cory Hopwood
(614) 387-5164


 Crash Statistics

Crashes by School 2007-2009.xlsb
Crashes by School 2008-2010.xlsb
Crashes by School 2009-2011.xlsb
Crashes by School 2010-2012.xlsb
Crashes by School 2011-2013.xlsb