Below are the first 10 and last 10 pages of uncorrected machine-read text (when available) of this chapter, followed by the top 30 algorithmically extracted key phrases from the chapter as a whole.
Intended to provide our own search engines and external engines with highly rich, chapter-representative searchable text on the opening pages of each chapter.
Because it is UNCORRECTED material, please consider the following text as a useful but insufficient proxy for the authoritative book pages.
Do not use for reproduction, copying, pasting, or reading; exclusively for search engines.
OCR for page 73
Database Analysis 73
In terms of uses relating specifically to the hazmat data in TIFA, over time, FMCSA has pub-
lished data about the scope of hazmat crashes. In addition, FMCSA has requested data about fatal
hazmat crashes to monitor trends.
4.5 Large Truck Crash Causation Study (LTCCS)
LTCCS was designed as a one-time study to compile a comprehensive set of accident data
for approximately 1,000 large truck accidents. The data compilation began in 2001 and was
completed in 2003, although analysis of the data is still ongoing.
4.5.1 Database Description
The LTCCS database is a series of tables that can be run in several relational databases. For pur-
poses of this assessment, the tables were imported into the Microsoft Access database. The mas-
ter table is the Crash file and contains 1,070 records representing the number of discrete accidents
that were investigated. There were 107 of these accidents that were eliminated for one reason or
another because they did not meet the analysis criteria. Thus, the LTCCS evaluates 963 discrete
accidents. The next table is the CRASHASSESSMENT Table, containing a total of 2,284 records
representing the data for the number of vehicles involved in the 1,070 accidents. Although all of
these accidents involved at least one heavy truck, the second vehicle in many of the accidents was
a passenger vehicle. Because the purpose of the study was to collect sufficient data to identify the
causes of the accidents as well as to collect information on the drivers, vehicles, and environment
present at the time of the accident, a lot of supporting information is provided.
The dataset contains a total of 43 separate tables summarizing the many factors that, in total,
represent a comprehensive set of data for each accident (see Table 4-21). Table 4-21 includes
Table 4-21. LTCCS tabular structure arranged by category.
Vehicle or Environment or
Overall Driver Carrier
Packaging Situational
SAFER Authority
Crash Driver Assessment Air Bags Environment
Status
Crash Driver Decision Factor
Brakes SAFER Carrier
Assessment Aggression Assessment
Events Driver Drugs Cargo Shift SAFER Insurance
Injuries Health Crush SAFER Review
SAFER Inspection Driver Recognition
General Vehicle SAFESTAT Rating
Summary Distraction
Hazardous Carrier Interviews
Jackknife PAR Violations
Material (1 Table)
Non-Motorist Sleep Hazmat Inspection
Driver Interviews
Occupants Truck Exterior
(14 Tables)
SAFER Crash
Truck Inspection
Report
SAFER Driver
Overview
Inspections
SAFER Driver
Truck Units
Violations
MCMIS Driver Vehicle Events
MCMIS Violations Vehicle Exterior
Note: Safety and Fitness Electronic Records (SAFER) System; Safety Status (SAFESTAT) Management System.