Skip to main content
All CollectionsAgency Specific ArticlesMichigan State Police
MSP - Crash Indicator Logic
MSP - Crash Indicator Logic

The article summarizes the custom filters for MSP and the associated logic.

Greg Olsen avatar
Written by Greg Olsen
Updated over a year ago

Aggressive Driving Involved

The Aggressive Driving Involved filter searches the Crash Table for the following criteria:

Party Type = D

AND

Hazardous Action = 1, 3, 4, 7, 8, 12, 15, or 16

Alcohol Involved

The Alcohol Involved filter searches the Crash Table for the following criteria:

Party Type = D, B, P, E

AND

Alcohol Suspected = Yes

Amish Involved

The Amish Involved filter searches the Crash Table for the following criteria:

Unit Type = P

AND

The Crash Narrative contains any of the following words: AMISH, BUGGY, BUGGIE, or

HORSE

Drug Involved

The Drug Involved filter searches the Crash Table for the following criteria:

Party Type = D, B, P, or E

AND

Drug Suspected = Yes

Bicycle Involved

The Bicycle Involved filter searches the Crash Table for the following criteria:

Unit Type = B

Motorcycle Involved

The Motorcycle Involved filter searches the Crash Table for the following criteria:

Vehicle Type = 5

Distracted Driving Involved

The Distracted Driving Involved filter searches the Crash Table for the following criteria:

Party Type = D

AND

Driver Distracted is between 2 and 8

Elderly Driver Involved

The Elderly Driver Involved filter searches the Crash Table for the following criteria:

Party Type = D

AND

Age > 59

Emergency Vehicle Involved

The Emergency Vehicle Involved filter searches the Crash Table for the following criteria:

Special Vehicle = 1, 2, or 4

Farm Equipment Involved

The Farm Equipment Involved filter searches the Crash Table for the following criteria:

Special Vehicle = 5

Intersection Involved

The Intersection Involved filter searches the Crash Table for the following criteria:

Roadway Area = 7, 8, 9, or 21

No Belts Involved

The No Belts Involved filter searches the Crash Table for the following criteria:

Party Type = D, B, P, or E

AND

Restraint Use = 5

ORV Involved

The ORV Involved filter searches the Crash Table for the following criteria:

Vehicle Type = 9

Pedestrian Involved

The Pedestrian Involved filter searches the Crash Table for the following criteria:

Unit Type = P

Q-Line Involved

The Q-Line Involved filter searches the Crash Table for the following criteria:

Unit Type = E

AND

The Crash Narrative contains any of the following words: Q-LINE, QLINE, or STEETCAR

Red Light Running Involved

The Red Line Running Involved filter searches the Crash Table for the following criteria:

Party Type = D, B, P, or E

AND

Hazardous Action = 4

AND

Roadway Area = 7, 8, 9, or 21

AND

Traffic Control = 1, 2, or 3

Snowmobile Involved

The Snowmobile Involved filter searches the Crash Table for the following criteria:

Vehicle Type = 8

Speeding Involved

The Speeding Involved filter searches the Crash Table for the following criteria:

Party Type = D

AND

Hazardous Action = 1

Train Involved

The Train Involved filter searches the Crash Table for the following criteria:

Unit Type = E

Truck/Bus Involved

The Truck/Bus Involved filter searches the Crash Table for the following criteria:

Vehicle Type = 11

Wrong Way Involved

The Wrong Way Involved filter searches the Crash Table for the following criteria:

Party Type = D

AND

Hazardous Action = 5

Young Driver Involved

The Young Driver Involved filter searches the Crash Table for the following criteria:

Party Type = D

AND

Age is between 15 and 24

Did this answer your question?