MSP - Crash Indicator Logic

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

Written by Greg Olsen
Updated over a week 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