MCMIS Catalog and Documentation

Crash File - Record Layout

IMPORTANT: Fields marked with an asterisk (*) will not be published in your File Extract. Due to privacy regulations, these fields are not disseminated to the general public. Fields marked with double asterisks (**) will not appear in your File Extract. For security reasons, these fields are not released to the general public. Fields marked with plus sign (+) will not appear in your file extract. These fields are no longer used in public dissemination.
Crash Master Table| Crash Carrier Table | Crash Driver Table | Crash Event Table
Note: Fields in Place Since 2014. Last Updated: 2014
CRASH MASTER TABLE
Field(s) Data Element Len Typ Contents
CRASH_ID CRASH ID 8 N  
REPORT_STATE REPORT STATE 2 A FIPS PUB 5-2 (See Appendix A [Opens in New Window] )
REPORT_NUMBER REPORT NUMBER 12 A State Abbreviation + 10 characters. No Blank spaces.
REPORT_DATE REPORT DATE 8 A/N YYYYMMDD
REPORT_TIME REPORT TIME 4 N  
REPORT_SEQ_NO CRASH SEQUENCE NUMBER 2 N  
DOT_NUMBER CENSUS NUMBER 8 A  
CI_STATUS_CD STATUS CODE 1 A U = Initial Upload
T = Sent to Census Search
C = Complete
N = Non-Match
H = FMCSA Hold
I = Intrastate
FINAL_STATUS_DATE FINAL STATUS DATE 8 A/N YYYYMMDD
LOCATION LOCATION 50 A/N  
CITY_CODE CITY CODE 5 A Can be blank (See FIPS PUB 55-3)
CITY CITY 25 A  
STATE STATE 2 A FIPS PUB 5-2 (See Appendix A [Opens in New Window] )
COUNTY_CODE COUNTY CODE 3 N FIPS PUB 6-4 (See County Code State [Opens in New Window] )
TRUCK_BUS_IND TRUCK/BUS 1 A T = Truck, B = Bus
TRAFFICWAY_ID TRAFFICWAY 8 A 1 = Two-way, not divided
2 = Two-way, divided, unprotected median
3 = Two-way, divided, positive median barrier
4 = One-way, not divided
98 = Not reported
99 = Unknown
ACCESS_CONTROL_ID ROAD ACCESS CONTROL 8 A 1 = Full Access Control
2 = Partial Access Control
3 = No Access Control
ROAD_SURFACE_CONDITION_ID ROAD SURFACE CONDITION 8 A 1 = Dry
2 = Wet
3 = Water (standing, moving)
4 = Snow
5 = Slush
6 = Ice
7 = Sand, Mud, Dirt, Oil or Gravel
8 = Other
9 = Unknown or Blank
CARGO_BODY_TYPE_ID CARGO BODY TYPE 8 A 1 = Bus (seats for 9-15 people, including driver)
2 = Bus (seats more than 15 people, including driver)
3 = Van/Enclosed Box
4 = Cargo Tank
5 = Flatbed
6 = Dump
7 = Concrete Mixer
8 = Auto Transporter
9 = Garbage/Refuse
10 = Grain, chips, gravel
11 = Pole
12 = Not applicable
13 = Intermodal
14 = Logging
15 = Vehicle Towing another Vehicle
98 = Other
GVW_RATING_ID GROSS VEHICLE WEIGHT RATING ID 8 A  
VEHICLE_IDENTIFICATION_NUMBER VEHICLE IDENTIFICATION NUMBER (VIN) 17 A  
VEHICLE_LICENSE_NUMBER VEHICLE LICENSE NUMBER 9 A  
VEHICLE_LIC_STATE VEHICLE LICENSE STATE 2 A FIPS PUB 5-2 (See Appendix A [Opens in New Window] )
VEHICLE_HAZMAT_PLACARD VEHICLE HAZMAT PLACARD 1 A "Y" or "N"
WEATHER_CONDITION_ID WEATHER CONDITION 8 A 1 = No Adverse Condition
2 = Rain
3 = Sleet, Hail
4 = Snow
5 = Fog
6 = Blowing Sand, Soil, Dirt, or Snow
7 = Severe Crosswinds
8 = Other
9 = Unknown or Blank
VEHICLE_CONFIGURATION_ID VEHICLE CONFIGURATION 8 A 1 = Passenger Car (Only if Vehicle displays HM Placard)
2 = Light Truck (Only if Vehicle displays HM Placard)
3 = Bus (Seats for 9-15 People, Including Driver)
4 = Bus (Seats for > 15 People, Including Driver)
5 = Single-Unit Truck (2-Axle, 6-Tire)
6 = Single-Unit Truck (3 or More Axles)
7 = Truck/Trailer
8 = Truck Tractor (Bobtail)
9 = Tractor/Semitrailer
10 = Tractor/Double
11 = Tractor/Triple
99 = Unknown Heavy Truck > 10000 lbs, Cannot Classify
LIGHT_CONDITION_ID LIGHT CONDITION 8 A 1 = Daylight
2 = Dark-Not Lighted
3 = Dark-Lighted
4 = Dark-Unknown Roadway Lighting
5 = Dawn
6 = Dusk
8 = Other
9 = Unknown or Blank
HAZMAT_RELEASED RELEASE OF HAZARDOUS MATERIALS CARGO 1 A "Y" or "N"
AGENCY REPORTING AGENCY 35 A  
OFFICER_BADGE OFFICER BADGE NUMBER 5 A  
VEHICLES_IN_ACCIDENT VEHICLES IN ACCIDENT 2 N  
FATALITIES NUMBER OF FATALITIES 3 N  
INJURIES NUMBER OF INJURIES 3 N  
TOW_AWAY TOW AWAY 1 A "Y" or "N"
FEDERAL_RECORDABLE FEDERALLY RECORDABLE 1 A "Y" or "N"
STATE_RECORDABLE STATE RECORDABLE 1 A "Y" or "N"
SNET_VERSION_NUMBER SAFETYNET VERSION NUMBER 10 A  
SNET_SEQUENCE_ID SAFETYNET SEQUENCE ID 10 A  
TRANSACTION_CODE TRANSACTION CODE 1 A A = Add, or C = Change
TRANSACTION_DATE TRANSACTION DATE 8 A/N YYYYMMDD
UPLOAD_FIRST_BYTE UPLOAD CENSUS FIRST BYTE 1 A  
UPLOAD_DOT_NUMBER UPLOAD USDOT NUMBER 8 A  
UPLOAD_SEARCH_INDICATOR UPLOAD SEARCH INDICATOR 1 A  
UPLOAD_DATE DATE UPLOADED 8 A/N YYYYMMDD
CENSUS_SEARCH_DATE CENSUS SEARCH DATE 8 A/N YYYYMMDD
ADD_DATE ADD DATE 8 A/N YYYYMMDD
CHANGE_DATE LAST CHANGE DATE 8 A/N YYYYMMDD
CHANGE_BY_USER CHANGED BY USER 30 A/N  
CHANGE_BY_APPL CHANGED BY APPLICATION 61 A  
SNET_INPUT_DATE SAFETYNET INPUT DATE 8 A/N YYYYMMDD

CRASH CARRIER TABLE | Top
Field(s) Data Element Length Type* Contents**
CRASH_CARRIER_ID CRASH CARRIER ID 8 N  
CRASH_ID CRASH ID 8 N  
CARRIER_SOURCE_CODE CARRIER NAME SOURCE 1 A 1 = Side of Vehicle
2 = Shipping Papers (Truck) or Trip Manifest (Bus)
3 = Driver
4 = Log Book or Blank
CRASH_CARRIER_NAME CARRIER NAME 120 A  
CRASH_CARRIER_STREET CARRIER ADDRESS/STREET 50 A  
CRASH_CARRIER_CITY CARRIER ADDRESS/CITY NAME 25 A  
CRASH_CARRIER_CITY_CODE CARRIER ADDRESS/CITY CODE 5 A Can be Blank
CRASH_CARRIER_STATE CARRIER ADDRESS/STATE 2 A FIPS PUB 5-2 (See Appendix A [Opens in New Window] )
CRASH_CARRIER_ZIP_CODE CARRIER ADDRESS/ZIP CODE 10 A  
CRASH_COLONIA CARRIER ADDRESS/MEXICAN COLONIA 25 A/N  
PREFIX PREFIX 2 A MC, MX, FF or Null
DOCKET_NUMBER DOCKET NUMBER 8 N  
CRASH_CARRIER_INTERSTATE INTERSTATE 1 N 0 = No (Intrastate)
1 = Yes (Interstate)
2 = Non Motor Carrier
NO_ID_FLAG NO CENSUS NUMBER 1 A "Y" or "N"
STATE_NUMBER STATE CENSUS NUMBER 12 A/N  
STATE_ISSUING_NUMBER STATE ISSUING STATE CENSUS NUMBER 2 A FIPS PUB 5-2 (See Appendix A [Opens in New Window] )

CRASH EVENT TABLE | Top
Field(s) Data Element Length Type* Contents**
CRASH_EVENT_ID CRASH EVENT ID 8 N  
CRASH_ID CRASH ID 8 N  
SEQ_NO SEQUENCE NUMBER 1 N  
EVENT_ID EVENT ID 8 N 1 = Non collision ran off road
2 = Non collision jackknife
3 = Non collision overturn (rollover)
4 = Non collision downhill runaway
5 = Non collision cargo loss or shift
6 = Non collision explosion or fire
7 = Non collision separation of units
8 = Non collision cross median/centerline
9 = Non collision equipment failure (brake failure, blown tires, etc.)
10 = Non collision other
11 = Non collision unknown
12 = Collision involving pedestrian
13 = Collision involving motor vehicle in transport
14 = Collision involving parked motor vehicle
15 = Collision involving train
16 = Collision involving pedalcycle
17 = Collision involving animal
18 = Collision involving fixed object
19 = Collision with work zone maintenance equipment
20 = Collision with other movable object (Substitutes for previous "Collision involving other object")
21 = Collision with unknown movable object
98 = Other
EVENT_OTHER_DESC OTHER DECSRIPTION 50 A/N  

*CRASH DRIVER TABLE | Top
Field(s) Data Element Length Type* Contents**
*CRASH_DRIVER_ID CRASH DRIVER ID 8 N  
*CRASH_ID CRASH ID 8 N  
*DRIVER_LAST_NAME DRIVER/LAST NAME 20 A  
*DRIVER_FIRST_NAME DRIVER/FIRST NAME 20 A  
*DRIVER _MI DRIVER/MIDDLE INITIAL 1 A  
*DRIVER_DATE_OF_BIRTH DRIVER/DATE OF BIRTH 8 A/N YYYYMMDD
*DRIVER_LICENSE_STATE DRIVER/LICENSE STATE 2 A See Appendix A [Opens in New Window] )
*DRIVER_LICENSE_NUMBER DRIVER/LICENSE NUMBER 25 A  
*VALID_DRIVER_LICENSE_FLAG DRIVER/LICENSE VALID 1 A "Y" or "N"
*DRIVER_LICENSE_CLASS_ID DRIVER/LICENSE CLASS 8 A Letter corresponds to Class-A, B, C, D, M, or blank
*CITATION_ISSUED_CODE_ID CITATION ISSUED 8 A Y = Yes, N = No, P = Pending, U = Unknown