Instructions for use of Ohio School Crash Statistics:

1. Use link to the right to Open Excel 2007 Document (If prompted for a password from the ODOT FTP server, choose "log in anonymously".)
2. Click on arrow in Column B and choose County. This will narrow results by  the county you are researching
3. Click on arrow in Column C 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 E 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 past into new book, all statewide information will be accessed during the next step)
8. Save the new book to your computer
9. Delete duplicate document numbers (Column A)
10. The result will be the accidents for the specific school you are researching
11. The procedure may have to be repeated for multiple schools.

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.

For the Crash Report Help File: Click Here

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

 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 
   1.  Only one year can be searched at a time
   2.  If a specific year has more than 100 records, view the records in multiple groups not exceeding the 100 record limit.
3.  Go to http://www.dps.state.oh.us/ohcrashreports/  
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 Data" button.  
7.  Click "Select Report" hyperlink next to each specific crash record to view the OH-1 Report Docum