USA Banner

Official US Government Icon

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure Site Icon

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

U.S. Department of Transportation U.S. Department of Transportation Icon United States Department of Transportation United States Department of Transportation

MCMIS Catalog: Crash File Documentation - Data Element Definitions

Crash Master Table | Crash Carrier Table | Crash Event Table  

CRASH MASTER TABLE

Data Element Definition
CRASH ID
(CRASH_ID)
[Max field length 8] This is a unique identifying number assigned to a crash record.
REPORT STATE
(REPORT_STATE)
[Max field length 2] The state that reported the crash. See Appendix A [Opens in New Window]
REPORT NUMBER
(REPORT_NUMBER)
[Max field length 12] The unique report number is designated by the state. The only requirements are that it starts with the two-letter state code and is followed by 10 characters.
REPORT DATE
(REPORT_DATE)
[Max field length 8] The date on which the crash occurred. (YYYYMMDD)
REPORT TIME
(REPORT_TIME)
[Max field length 4] The military time at which the crash occurred.
REPORT SEQUENCE NUMBER
(REPORT_SEQ_NO)
[Max field length 2] This field is used to identify the vehicles in a multiple vehicle crash. If only one commercial motor vehicle was involved the value will be 1. For each additional vehicle involved it will be increased by 1.
CENSUS NUMBER
(DOT_NUMBER)
[Max field length 8] This is the number assigned by MCMIS to a census record. It is sometimes referred to as the USDOT number. Each motor carrier should have only one active census number. The census number has no internal coded structure. Numbers are issued sequentially as carriers are added to the system.
STATUS CODE
(CI_STATUS_CD)
[Max field length 1] Processing status of record. (U = Initial Upload, T = Sent to Census Search, C = Complete, N = Non-Match, H = FMCSA Hold, or I = Intrastate.)
FINAL STATUS DATE
(FINAL_STATUS_DATE)
[Max field length 8] Date the Status Code is set to 'C', 'N', 'H', or 'I' (See STATUS CODE above.) (YYYYMMDD)
LOCATION
(LOCATION)
[Max field length 50] The street address or highway number where the crash occurred.
CITY CODE
(CITY_CODE)
[Max field length 5] The 5-digit code for the municipality (city or township) in which the crash occurred as implemented by FIPS PUB 55-3.
CITY
(CITY)
[Max field length 25] The name of the municipality (city or township) in which the crash occurred.
STATE
(STATE)
[Max field length 2] The state/district in which the crash occurred. (See Appendix A [Opens in New Window])
COUNTY CODE
(COUNTY_CODE)
[Max field length 3] The 3-digit Worldwide Geographical Code for the county in which the crash occurred. FIPS PUB 6-4 (See County Code State [Opens in New Window])
TRUCK/BUS INDICATOR
(TRUCK_BUS_IND)
[Max field length 1] Indication of whether the vehicle involved in the crash was a truck (T) or bus (B).
TRAFFICWAY
(TRAFFICWAY_ID)
[Max field length 8] The degree of trafficway division at the place of the crash.
ROAD ACCESS CONTROL
(ACCESS_CONTROL_ID)
[Max field length 8] The degree that access to abutting land, light, air, or view in connection with highway is fully controlled by public authority.
ROAD SURFACE CONDITION
(ROAD_SURFACE_CONDITION_ID)
[Max field length 8] The condition that affected traction on the road surface at the time and location of the crash.
CARGO BODY TYPE
(CARGO_BODY_TYPE_ID)
[Max field length 8] The cargo body type of the motor vehicle.
GROSS VEHICLE WEIGHT RANGE
(GVWR)
[Max field length 6] Weight range of the vehicle.
GROSS VEHICLE WEIGHT RATING ID
(GVW_RATING_ID)
[Max field length 8] Weight rating of the power unit of the vehicle.
VEHICLE IDENTIFICATION NUMBER
(VEHICLE_IDENTIFICATION_NUMBER)
[Max field length 17] The Vehicle Identification Number (VIN) of the motor vehicle. The VIN is a unique combination of alphanumeric characters formulated by the manufacturer.
VEHICLE LICENSE NUMBER
(VEHICLE_LICENSE_NUMBER)
[Max field length 9] The numeric, alphanumeric, or alphabetic character, exactly as displayed, on the plate or tag affixed to the motor vehicle.
VEHICLE LICENSE STATE
(VEHICLE_LIC_STATE)
[Max field length 2] The state/district issuing the license plate of the motor vehicle. (See Appendix A [Opens in New Window])
HAZARDOUS MATERIALS PLACARDS
(VEHICLE_HAZMAT_PLACARD)
[Max field length 1] Indication of whether the motor carrier had a hazardous materials placard.
WEATHER CONDITION
(WEATHER_CONDITION_ID)
[Max field length 8] The predominant weather condition at the time and place of the crash.
VEHICLE CONFIGURATION
(VEHICLE_CONFIGURATION_ID)
[Max field length 8] The configuration of the motor vehicle.
LIGHT CONDITION
(LIGHT_CONDITION_ID)
[Max field length 8] Light condition at the time and place of the crash.
HAZMAT RELEASED
(HAZMAT_RELEASED)
[Max field length 1] Indicates whether or not Hazardous Material was released as a result of the crash.
REPORTING AGENCY
(AGENCY)
[Max field length 35] The agency that was responsible for investigating and reporting the crash.
VEHICLES IN ACCIDENT
(VEHICLES_IN_ACCIDENT)
[Max field length 2] The total number of vehicles or vehicle combinations involved in the crash. This greater than zero number includes all trucks, buses, and other vehicles, such as cars and pedalcycles, involved in the crash.
FATALITIES
(FATALITIES)
[Max field length 3] Number of persons killed inside or outside a vehicle at the scene of the crash.
INJURIES
(INJURIES)
[Max field length 3] Number of persons injured inside or outside a vehicle at the scene of the crash who were transported to a medical facility for immediate medical attention.
TOW AWAY
(TOW_AWAY)
[Max field length 1] Indication of whether one or more motor vehicles were disabled and transported away from the scene by a tow truck or another vehicle.
FEDERALLY RECORDABLE
(FEDERAL_RECORDABLE)
[Max field length 1] Indication of whether the crash was Federally Recordable. A "recordable" crash has occurred when at least one person dies, or at least one person experiences bodily injury which requires immediate medical treatment away from the scene of the crash, or a vehicle is towed away.
STATE RECORDABLE
(STATE_RECORDABLE)
[Max field length 1] Indication of whether the crash was State Recordable.
ORIGINAL REPORT DATE
(ORIG_REPORT_DATE)
[Max field length 8] Original report date. (YYYYMMDD)
UPLOAD FIRST BYTE
(UPLOAD_FIRST_BYTE)
[Max field length 1] This is the first character of the DOT number the states send up in the Crash Upload in version 10 and before. If the DOT number is valid this will be a zero. If the state is unable to assign a DOT number, they sometimes fill in a number starting with 'F' for a federal number or 'S' for a state number.
UPLOAD DOT NUMBER
(UPLOAD_DOT_NUMBER)
[Max field length 8] This is the rest of the uploaded DOT number. The combined field is used in the Carrier Match Process.
RELATED FACTORS
(RELATED_FACTORS)
[Max field length 16] Relative factors.
SAFETYNET INPUT DATE
(SNET_INPUT_DATE)
[Max field length 8] Date the crash record was in put into SAFETYNET. (YYYYMMDD)

CRASH EVENT TABLE

Data Element Definition
CRASH EVENT ID
(CRASH_EVENT_ID)
[Max field length 8] This is a unique identifying number assigned to an event in the crash record.
CRASH ID
(CRASH_ID)
[Max field length 8] This is a unique identifying number assigned to a crash record.
SEQUENCE NUMBER
(SEQ_NO)
[Max field length 1] Numeric code indicating the sequence of events.
EVENT ID
(EVENT_ID)
[Max field length 8] Indicates the type of event.
EVENT OTHER DECSCRIPTION
(EVENT_OTHER_DESC)
[Max field length 50] Descriptive field to define events other than those indicated on EVENT_ID.