Ohio.gov State Agencies  |  Online Services
Skip Ribbon Commands
Skip to main content
Sign In

Highway Safety
Safe Routes to School Crash Statistics...

Crash Statistics are used to support School Travel Plans that call for Safe Routes to School funding in support of safer environments for Ohio's bikers and pedestrians especially, but not limited to, school zones. ODOT Highway Safety and Ohio Public Safety work together to collect and analyze crash statistics in support of all efforts toward Every Move You Make...Keep It Safe.

Ohio School Crash Statistics Instructions

  1. Use link to the right to Open Excel 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.


 Ohio School 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
Crashes by School 2014-2016.xlsb

 Public Safety Related Links


Instructions to Obtain Specific
OH-1 Reports from Public Safety

  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.
  4. If a specific year has more than 100 records, view the records in multiple groups not exceeding the 100 record limit.
  5. Paste Document Numbers into the "Document Number" field.
  6. Fill in the "Code" in the yellow box, and select the "Submit" button.
  7. Click the "Get Report Date" button.
  8. Click "Select Report" hyperlink next to each specific crash record to view the OH-1 Report Document.