Collision Analysis Tool

Collision Analysis Tool - Help

Collision Analysis Data Dictionary

Collision Analysis Lookup Tables

How to Use the Collision Analysis Tool

Frequently Asked Questions

How to use the Collision Analysis Tool

Collision Date

Use these options to specify a data range for your search.
1. Start Date/Time (Required) - Enter the starting date or click on the calendar icon to select a date from the date picker. You may also select a starting hour from the list, this is optional, the default is 12:00 AM (Midnight). NOTE: There is no data available prior to November 14, 2013.
2. End Date/Time (Required) - Enter the ending date or click on the calendar icon to select a date from the date picker. You may also select an ending hour from the list, this is optional, the default is 12:00 AM (Midnight). The ending date must be later than or equal to the starting date.
3. Day of Week - This allows you to limit your search to specific days of the week, all days are selected by default.
4. Time of Day From/To - These selections allow you to limit your search to a specific timeframe within each day. By default there is no limit. If you select a Time of Day From you must also select a Time of Day To which must be later than Time of Day From.
Collision Location

Use these options to specify location criteria for your search.
1. Roadway Type - Select the jursidiction, this is the category of roadway.
  - State Road: State Routes and Interstates
  - County Road: Roads outside of a city limit within a county
  - City Street: Roads within city limits
  - Miscellaneous Trafficway: Parking lots, private driveways, trails and parks
2. Agency Type - This allows you to limit your search to a specific law enforcement agency type. This is optional, if you do not make a selection then all agency types are included in the search.
3. County, City or Statewide (Required) - These selections allow you to limit your search to a specific geographical area. You must select at least one option. Checking Statewide will override any County and/or City selections.
4. Primary Trafficway - To limit your search to a specific roadway, enter the name of the roadway. There are a wide variety of ways in which officers/agencies may enter this data, Interstate 5 may be entered as 005, I-5, I5, Interstate 5, SB I-5, NB 5, etc. To accomodate these variances, this field allows the use of wildcards to refine your search. The wildcard character is an asterisk (*) and is used to substitute for zero or more characters in a search expression. For example: entering I*5 will search for "I5", "I 5" or "I-5". You may use multiple wildcards in this field.
5. Secondary Trafficway - Use this field to limit your search to a specific intersection or near a specific area. This field allows the use of wildcards to refine your search, the wildcard character is an asterisk (*).
6. Block/Milepost Begin - Use this field to limit your search to a specific block or milepost. Entries must be numeric. For State Roads, you can enter mileposts. For City Streets, you can enter block numbers. County Roads can be searched using either mileposts or block numbers.
7. Milepost End - Use this field to limit your search to collisons within a specific range of mileposts. Entries must be numeric. If you enter Milepost End you must also enter Milepost Begin. Milepost End must be a value greater than Milepost Begin. This entry is ignored if the Block option is selected.
8. Block/MilePost - Use this option to specify whether you are searching based on a Block or Milepost, Block is the default selection.
9. School Zone - Check this box to limit your search to only collisions which occured within a school zone.
10. Intersection Related - Check this box to limit your search to only collisions which occured at an intersection of two or more roadways.
Collision Situation

Use these options to specify general collision detail criteria for your search.
1. Motor Vehicles Involved - Check this box to limit your search to collisions which involve motor vehicles. This option is selected by default. If this box is not checked your search will be limited to only those collisions which DO NOT involve motor vehicles.
2. Number of Vehicles Involved - Use this selection to limit your search to collisions involving a specific number of motor vehicles. This selection is ignored if the Motor Vehicles Involved option is not checked.
3. Passenger Involvement - Use this selection to limit your search to only those collisions where passengers are or are not involved. If no selection is made the search will return results regardless of whether or not passengers are involved. This selection is ignored if the Motor Vehicles Involved option is not checked.
4. Commercial Carrier Involvement - Use this selection to limit your search to only those collisions where commercial carriers are or are not involved. If no selection is made the search will return results regardless of whether or not commercial carriers are involved. This selection is ignored if the Motor Vehicles Involved option is not checked.
5. School Bus Involvement - Use this selection to limit your search to only those collisions where school buses are or are not involved. If no selection is made the search will return results regardless of whether or not school buses are involved. This selection is ignored if the Motor Vehicles Involved option is not checked.
6. Pedestrian(s) Involved - Check this box to limit your search to only collisions where pedestrians are involved. If this box is not checked your search will be limited to only those collisions which DO NOT involve pedestrians.
7. Pedal Cyclist(s) Involved - Check this box to limit your search to only collisions where cyclists are involved. If this box is not checked your search will be limited to only those collisions which DO NOT involve cyclists.
8. Weather Condition - Use this selection to limit your search to collisions which occurred when specific weather conditions were present.
9. Lighting Condition - Use this selection to limit your search to collisions which occurred when specific lighting conditions were present.
10. Injury Severity - Use this selection to limit your search to collisions where the most severe injury incurred by any involved person matches the specific selection.
11. Collision Type - Use this selection to limit your search to collisions of a specific type such as turning, backing, sideswipe, etc.
12. Object Struck - Use this selection to limit your search to collisions which involved striking a specific object.
13. Damage Threshold Met - Check this box to limit your search to only collisions meeting the minimum state threshold criteria for reporting a collision. This option is selected by default. If this box is not checked your search will be limited to only those collisions which DO NOT meet the damage threshold.
Motor Vehicle

Use these options to enter specific criteria for your search regarding motor vehicles, drivers and passengers.
1. Vehicle Style - Use this selection to limit your search to collisions involving a specific type of motor vehicle such as passenger car, truck, motorcycle, etc.
2. Vehicle Action - Use this selection to limit your search to collisions involving a specific motor vehicle action such as turning, backing, changing lanes, etc.
3. Driver Age From - Use this field to limit your search to collisions involving drivers of a specific age. Entries must be a numeric value between 15 and 100 inclusive.
4. Driver Age To - Use this field to limit your search to collisons involving drivers within a specific age range. Entries must be a numeric value between 15 and 100. If you enter Age To you must also enter Age From. Age To must be a value greater than Age From.
5. Driver Gender Male/Female - Use these options to limit your search to collisons involving drivers of a specific gender. You must select at least one option.
6. Driver Restraint Type - Use this selection to limit your search to collisions involving drivers using a specific type of restraint such as shoulder belt, lap belt, none, etc.
7. Driver Air Bag Type - Use this selection to limit your search to collisions involving drivers with a specific type of air bag such as front, side, other, etc.
8. Driver Helmet Used - Use this selection to limit your search to only those collisions where drivers were or were not wearing a helmet. If no selection is made the search will return results regardless of whether the driver was wearing a helmet or not.
9. Driver Contributing Circumstance(s) - Use these selections to limit your search to collisions which involve a specific set of circumstance(s). A collision report may contain up to three contributing circumstances, however most collision reports only contain one contributing circumstance. You may use the Ctrl+Click keys to select more than one circumstance.
10. Circumstances And / Or - When selecting multiple circumstances you may select the And option for collision reports containing ALL of the selected circumstances. Selecting the Or option will return collisions that match ANY one of the selected circumstances. The OR option is the default choice. These choices have no effect when only one circumstance is selected.
11. Driver Injury Severity - Use these selections to limit your search to collisions which involve a specific injury severity to a driver. You may use the Ctrl+Click keys to select more than one injury severity.
12. Driver Alcohol Involved - Check this box to limit your search to only collisions where the driver was under the influence of alcohol. This option is not selected by default. If this box is not checked the search will ignore this option and include collisions regardless of whether the driver was impaired.
13. Driver Cannabis Involved - Check this box to limit your search to only collisions where the driver was under the influence of cannabis/marijuana. This option is not selected by default. If this box is not checked the search will ignore this option and include collisions regardless of whether the driver was impaired.
14. Driver Drugs Involved - Check this box to limit your search to only collisions where the driver was under the influence of drugs (other than cannabis/marijuana). This option is not selected by default. If this box is not checked the search will ignore this option and include collisions regardless of whether the driver was impaired.
15. Passenger Age From - Use this field to limit your search to collisions involving passengers of a specific age. Entries must be a numeric value between 15 and 100 inclusive.
16. Passenger Age To - Use this field to limit your search to collisons involving passengers within a specific age range. Entries must be a numeric value between 15 and 100. If you enter Age To you must also enter Age From. Age To must be a value greater than Age From.
17. Passenger Gender Male/Female - Use these options to limit your search to collisons involving passengers of a specific gender. You must select at least one option.
18. Passenger Restraint Type - Use this selection to limit your search to collisions involving passengers using a specific type of restraint such as shoulder belt, lap belt, none, etc.
19. Passenger Seating Position - Use this selection to limit your search to passengers occupying a specific location within the motor vehicle such as Right Front, Left Rear, Outside of Vehicle, etc.
20. Passenger Helmet Used - Use this selection to limit your search to only those collisions where the passengers were or were not wearing a helmet. If no selection is made the search will return results regardless of whether the passenger was wearing a helmet or not.
21. Passenger Injury Severity - Use these selections to limit your search to collisions which involve a specific injury severity to passenger(s) in the vehicle. You may use the Ctrl+Click keys to select more than one injury severity.
Pedestrian

Use these options to enter specific criteria for your search regarding pedestrians.
1. Pedestrian Age From - Use this field to limit your search to collisions involving pedestrians of a specific age. Entries must be a numeric value between 15 and 100 inclusive.
2. Pedestrian Age To - Use this field to limit your search to collisons involving pedestrians within a specific age range. Entries must be a numeric value between 15 and 100. If you enter Age To you must also enter Age From. Age To must be a value greater than Age From.
3. Pedestrian Gender Male/Female - Use these options to limit your search to collisons involving pedestrians of a specific gender. You must select at least one option.
4. Pedestrian Contributing Circumstance(s) - Use these selections to limit your search to collisions which involve a specific set of circumstance(s). A collision report may contain up to three contributing circumstances, however most collision reports only contain one contributing circumstance. You may use the Ctrl+Click keys to select more than one circumstance.
5. Circumstances And / Or - When selecting multiple circumstances you may select the And option for collision reports containing ALL of the selected circumstances. Selecting the OR option will return collisions that match ANY one of the selected circumstances. The Or option is the default choice. These choices have no effect when only one circumstance is selected.
6. Pedestrian Injury Severity - Use these selections to limit your search to collisions which involve a specific injury severity to a pedestrian involved in a collision. You may use the Ctrl+Click keys to select more than one injury severity.
7. Pedestrian Alcohol Involved - Check this box to limit your search to only collisions where the pedestrian was under the influence of alcohol. This option is not selected by default. If this box is not checked the search will ignore this option and include collisions regardless of whether the pedestrian was impaired.
8. Pedestrian Cannabis Involved - Check this box to limit your search to only collisions where the pedestrian was under the influence of cannabis/marijuana. This option is not selected by default. If this box is not checked the search will ignore this option and include collisions regardless of whether the pedestrian was impaired.
9. Pedestrian Drugs Involved - Check this box to limit your search to only collisions where the pedestrian was under the influence of drugs (other than cannabis/marijuana). This option is not selected by default. If this box is not checked the search will ignore this option and include collisions regardless of whether the pedestrian was impaired.
Pedal Cyclist

Use these options to enter specific criteria for your search regarding cyclists.
1. Pedal Cyclist Driver Age From - Use this field to limit your search to collisions involving cyclists of a specific age. Entries must be a numeric value between 15 and 100 inclusive.
2. Pedal Cyclist Driver Age To - Use this field to limit your search to collisons involving cyclists within a specific age range. Entries must be a numeric value between 15 and 100. If you enter Age To you must also enter Age From. Age To must be a value greater than Age From.
3. Pedal Cyclist Driver Gender Male/Female - Use these options to limit your search to collisons involving cyclists of a specific gender. You must select at least one option.
4. Pedal Cyclist Driver Helmet Used - Use this selection to limit your search to only those collisions where the cycle drivers were or were not wearing a helmet. If no selection is made the search will return results regardless of whether the cycle driver was wearing a helmet or not.
5. Pedal Cyclist Contributing Circumstance(s) - Use these selections to limit your search to collisions which involve a specific set of circumstance(s). A collision report may contain up to three contributing circumstances, however most collision reports only contain one contributing circumstance. You may use the Ctrl+Click keys to select more than one circumstance.
6. Circumstances And / Or - When selecting multiple circumstances you may select the And option for collision reports containing ALL of the selected circumstances. Selecting the OR option will return collisions that match ANY one of the selected circumstances. The Or option is the default choice. These choices have no effect when only one circumstance is selected.
7. Pedal Cyclist Injury Severity - Use these selections to limit your search to collisions which involve a specific injury severity to a cyclist involved in a collision. You may use the Ctrl+Click keys to select more than one injury severity.
8. Pedal Cyclist Driver Alcohol Involved - Check this box to limit your search to only collisions where the cyclist was under the influence of alcohol. This option is not selected by default. If this box is not checked the search will ignore this option and include collisions regardless of whether the cyclist was impaired.
9. Pedal Cyclist Driver Cannabis Involved - Check this box to limit your search to only collisions where the cyclist was under the influence of cannabis/marijuana. This option is not selected by default. If this box is not checked the search will ignore this option and include collisions regardless of whether the cyclist was impaired.
10. Pedal Cyclist Driver Drugs Involved - Check this box to limit your search to only collisions where the cyclist was under the influence of drugs (other than cannabis/marijuana). This option is not selected by default. If this box is not checked the search will ignore this option and include collisions regardless of whether the cyclist was impaired.
11. Pedal Cyclist Passenger Age From - Use this field to limit your search to collisions involving cycle passengers of a specific age. Entries must be a numeric value between 15 and 100 inclusive.
12. Pedal Cyclist Passenger Age To - Use this field to limit your search to collisons involving cycle passengers within a specific age range. Entries must be a numeric value between 15 and 100. If you enter Age To you must also enter Age From. Age To must be a value greater than Age From.
13. Pedal Cyclist Passenger Gender Male/Female - Use these options to limit your search to collisons involving cycle passengers of a specific gender. You must select at least one option.
14. Pedal Cyclist Passenger Helmet Used - Use this selection to limit your search to only those collisions where cycle passengers were or were not wearing a helmet. If no selection is made the search will return results regardless of whether the cycle passenger was wearing a helmet or not.
15. Pedal Cyclist Passenger Injury Severity - Use these selections to limit your search to collisions which involve a specific injury severity to the passenger on a cycle involved in a collision. You may use the Ctrl+Click keys to select more than one injury severity.
Output Format

Use this options to specify the output format for your search.
1. Tabular - Select this format to display the data on screen in a tabular (Rows and Columns) format. You will be able to drill-down to detailed collision information regarding motor vehicles, drivers, passengers, pedestrians and cyclists by clicking on the links within each record. You can export the data to an Excel spreadsheet where it can be sorted and/or filtered.
2. Map - Select this format to display the data on screen overlayed on a map. You will be able to drill-down to detailed information regarding a specific collision by clicking on a marker on the map.

Frequently Asked Questions

Q: What data is available in the Collision Analysis Database?

A: The Collision Analysis Database contains data from November 14, 2013 onward. All collision reports submitted by law enforcement officers received by the Washington State Patrol will be available for query in the database.
Q: Why can’t I sort the results of my query?

A: You cannot sort the information in your results until you export it into Microsoft Excel.
Q: How do I search for a specific location?

A: When searching for a specific location, you must enter a Jurisdiction and select a County, City or Statewide. After selecting a county, the city list will be filtered to show only the cities within the selected county.
Q: Why do collision reports begin with an E?

A: There are two types of collision reports. Reports completed on the paper Police Traffic Collision Report (PTCR) and mailed to WSP will contain a seven digit report number, i.e. 1234567. Reports submitted electronically will begin with an "E", i.e. E123456.