NHTSA improves access to FARS database

Discussion in 'Fred's House of Pancakes' started by bwilson4web, Dec 14, 2023.

  1. bwilson4web

    bwilson4web BMW i3 and Model 3

    Joined:
    Nov 25, 2005
    28,157
    15,934
    0
    Location:
    Huntsville AL
    Vehicle:
    2018 Tesla Model 3
    Model:
    Prime Plus
    NHTSA has opened access to the FARS database. Here is a sample from the 'vehicle.csv' file:

    STATE 6
    STATENAME California
    ST_CASE 61863
    VEH_NO 2
    VE_FORMS 2
    NUMOCCS 2
    NUMOCCSNAME 2
    DAY 26
    DAYNAME 26
    MONTH 8
    MONTHNAME August
    HOUR 4
    HOURNAME 4:00am-4:59am
    MINUTE 50
    MINUTENAME 50
    HARM_EV 8
    HARM_EVNAME Pedestrian
    MAN_COLL 0
    MAN_COLLNAME The First Harmful Event was Not a Collision with a Motor Vehicle in Transport
    UNITTYPE 1
    UNITTYPENAME Motor Vehicle In-Transport (Inside or Outside the Trafficway)
    HIT_RUN 0
    HIT_RUNNAME No
    REG_STAT 6
    REG_STATNAME California
    OWNER 1
    OWNERNAME Driver (in this crash) was Registered Owner
    MAKE 29
    MAKENAME Other Domestic Manufacturers
    MODEL 5
    MAK_MOD 29005
    MAK_MODNAME Other Domestic Manufacturers Tesla
    BODY_TYP 5
    BODY_TYPNAME 5-door/4-door hatchback
    MOD_YEAR 2017
    MOD_YEARNAME 2017
    VIN 5YJSA1E15HF2
    VINNAME 5YJSA1E15HF2
    VIN_1 5
    VIN_2 Y
    VIN_3 J
    VIN_4 S
    VIN_5 A
    VIN_6 1
    VIN_7 E
    VIN_8 1
    VIN_9 5
    VIN_10 H
    VIN_11 F
    VIN_12 2
    TOW_VEH 0
    TOW_VEHNAME No Trailing Units
    J_KNIFE 0
    J_KNIFENAME Not an Articulated Vehicle
    MCARR_I1 0
    MCARR_I1NAME Not Applicable
    MCARR_I2 0
    MCARR_I2NAME Not Applicable
    MCARR_ID 0
    MCARR_IDNAME Not Applicable
    V_CONFIG 0
    V_CONFIGNAME Not Applicable
    CARGO_BT 0
    CARGO_BTNAME Not Applicable (N/A)
    HAZ_INV 1
    HAZ_INVNAME No
    HAZ_PLAC 0
    HAZ_PLACNAME Not Applicable
    HAZ_ID 0
    HAZ_IDNAME Not Applicable
    HAZ_CNO 0
    HAZ_CNONAME Not Applicable
    HAZ_REL 0
    HAZ_RELNAME Not Applicable
    BUS_USE 0
    BUS_USENAME Not a Bus
    SPEC_USE 0
    SPEC_USENAME No Special Use�Noted
    EMER_USE 0
    EMER_USENAME Not Applicable
    TRAV_SP 70
    TRAV_SPNAME 070 MPH
    UNDEROVERRIDE 7
    UNDEROVERRIDENAME Not Applicable
    ROLLOVER 0
    ROLLOVERNAME No Rollover
    ROLINLOC 0
    ROLINLOCNAME No Rollover
    IMPACT1 12
    IMPACT1NAME 12 Clock Point
    DEFORMED 8
    DEFORMEDNAME Not Reported
    TOWED 5
    TOWEDNAME Not Towed
    M_HARM 8
    M_HARMNAME Pedestrian
    FIRE_EXP 0
    FIRE_EXPNAME No or Not Reported
    DR_PRES 1
    DR_PRESNAME Yes
    L_STATE 6
    L_STATENAME California
    DR_ZIP 92054
    DR_ZIPNAME 92054
    L_STATUS 6
    L_STATUSNAME Valid
    L_TYPE 1
    L_TYPENAME Full Driver License
    CDL_STAT 0
    CDL_STATNAME No (CDL)
    L_ENDORS 0
    L_ENDORSNAME No Endorsements required for this vehicle
    L_COMPL 3
    L_COMPLNAME Valid license for this class vehicle
    L_RESTRI 0
    L_RESTRINAME No Restrictions or Not Applicable
    DR_HGT 68
    DR_HGTNAME 68
    DR_WGT 140
    DR_WGTNAME 140 lbs.
    PREV_ACC 0
    PREV_ACCNAME None
    PREV_SUS1 0
    PREV_SUS1NAME None
    PREV_SUS2 0
    PREV_SUS2NAME None
    PREV_SUS3 0
    PREV_SUS3NAME None
    PREV_DWI 0
    PREV_DWINAME None
    PREV_SPD 0
    PREV_SPDNAME None
    PREV_OTH 0
    PREV_OTHNAME None
    FIRST_MO 0
    FIRST_MONAME No Record
    FIRST_YR 0
    FIRST_YRNAME No Record
    LAST_MO 0
    LAST_MONAME No Record
    LAST_YR 0
    LAST_YRNAME No Record
    SPEEDREL 0
    SPEEDRELNAME No
    VTRAFWAY 3
    VTRAFWAYNAME Two-Way, Divided, Positive Median Barrier
    VNUM_LAN 4
    VNUM_LANNAME Four lanes
    VSPD_LIM 65
    VSPD_LIMNAME 65 MPH
    VALIGN 1
    VALIGNNAME Straight
    VPROFILE 1
    VPROFILENAME Level
    VPAVETYP 2
    VPAVETYPNAME Blacktop, Bituminous, or Asphalt
    VSURCOND 1
    VSURCONDNAME Dry
    VTRAFCON 0
    VTRAFCONNAME No Controls
    VTCONT_F 0
    VTCONT_FNAME No Controls
    P_CRASH1 1
    P_CRASH1NAME Going Straight
    P_CRASH2 80
    P_CRASH2NAME Pedestrian in road
    P_CRASH3 6
    P_CRASH3NAME Steering left
    PCRASH4 1
    PCRASH4NAME Tracking
    PCRASH5 1
    PCRASH5NAME Stayed in original travel lane
    ACC_TYPE 98
    ACC_TYPENAME M98-Other Crash Type
    TRLR1VIN 777777777777
    TRLR1VINNAME No Trailing Units
    TRLR2VIN 777777777777
    TRLR2VINNAME No Trailing Units
    TRLR3VIN 777777777777
    TRLR3VINNAME No Trailing Units
    DEATHS 0
    DR_DRINK 0
    DR_DRINKNAME No
    VPICMAKE 441
    VPICMAKENAME Tesla
    VPICMODEL 1685
    VPICMODELNAME Model S
    VPICBODYCLASS 5
    VPICBODYCLASSNAME Hatchback/Liftback/Notchback
    ICFINALBODY 0
    ICFINALBODYNAME Not Applicable
    GVWR_FROM 11
    GVWR_FROMNAME Class 1: 6,000 lbs. or less (2,722 kg or less)
    GVWR_TO 11
    GVWR_TONAME Class 1: 6,000 lbs. or less (2,722 kg or less)
    TRLR1GVWR 77
    TRLR1GVWRNAME No Trailing Units
    TRLR2GVWR 77
    TRLR2GVWRNAME No Trailing Units
    TRLR3GVWR 77
    TRLR3GVWRNAME No Trailing Units

    Bob Wilson