1. Attachments are working again! Check out this thread for more details and to report any other bugs.

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
    27,373
    15,513
    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