National Academy of Sciences | 150 Year Anniversary

Questions? Call 800-624-6242

| Items in cart [0]

The National Academies Press

Rights & Permissions

topleft topright

HMCRP Report 1: Hazardous Materials Transportation Incident Data for Root Cause Analysis (2009)
Hazardous Material Cooperative Research Program (HMCRP)

Citation Manager

Transportation Research Board. "4.5.1 Database Description." HMCRP Report 1: Hazardous Materials Transportation Incident Data for Root Cause Analysis. Washington, DC: The National Academies Press, 2009.

Please select a format:

BibTeX EndNote RefMan


Page
73
bottomleft bottomright
Page
73
Front Matter (R1-R11)
Summary (1-8)
1.1 Project Purpose (9-9)
1.2.1 Literature Review (10-10)
1.2.3 Analysis of Databases (11-11)
1.3 Effective Methods to Ensure High-Quality Data (12-12)
1.4 Potential Measures to Enhance the Ability of Databases to Identify the Root Causes of Hazmat Crashes (13-13)
2.2.1 Rail Equipment - Train Accident Data (14-14)
2.2.2 Project 5 Overview - Developing Common Data on Accident Circumstances (15-15)
2.2.4 Transportation Research Circular 231: Truck Accident Data Systems: State-of-the-Art Report (16-16)
2.2.6 The Human Factors Analysis and Classification System - HFACS (17-17)
2.2.9 Highway Safety: Further Opportunities Exist to Improve Data on Crashes Involving Commercial Motor Vehicles (18-18)
2.2.11 Comprehensive Safety Analysis 2010: 2006 Listening Session (19-19)
2.2.16 Hazardous Materials Serious Crash Analysis: Phase 2 (20-20)
2.3 Summary of Findings and Implications (21-21)
2.3.2 Solutions Being Implemented or Under Consideration (22-22)
3.1 Introduction (23-23)
3.2 Summary of Responses from Carriers (24-24)
3.2.1 Carrier Satisfaction with HMIRS (25-25)
3.3.1 Shipper 1 (26-26)
3.3.2 Shipper 2 (27-27)
3.4.1 Interviews with Agencies Maintaining Databases (PHMSA) (28-28)
3.4.2 Interviews with Agencies Maintaining Databases (FMCSA) (29-29)
3.4.3 Interviews with Agencies Maintaining Databases (FRA) (30-30)
3.5 Summary of Findings from Interviews (31-31)
4.1.1 MCMIS Database Description (32-32)
4.1.3 Database Format (33-33)
4.1.6 Types of Fields Covered (34-34)
4.1.7 Database Purpose and Function (35-35)
4.1.10 Accuracy and Completeness of Data (36-36)
4.1.11 Identification of Hazmat Incidents in MCMIS (37-41)
4.1.12 Quality Control Process (42-42)
4.1.13 Interconnectivity with Other Databases (43-43)
4.1.14 Analyses Using Database (44-44)
4.1.15 Summary and Potential Measures for Improving Root Cause Analysis (45-45)
4.2 Hazardous Materials Incident Reporting System (HMIRS) (46-46)
4.2.1 Database Description (47-48)
4.2.3 Data Collection (49-49)
4.2.5 Accuracy and Completeness of Data (50-53)
4.2.8 Analyses Using Database (54-59)
4.2.9 Summary and Potential Measures for Improving Root Cause Analysis (60-60)
4.3 Fatality Analysis Reporting System (FARS) (61-61)
4.3.4 Types of Hazmat Data Included (62-62)
4.3.6 Data Quality (63-63)
4.3.7 Additional Fields (64-64)
4.3.9 Compatibility with Other Databases (65-65)
4.4.4 Types of Hazmat Data Included (66-66)
4.4.5 Usefulness of the Data for Determining Root Causes (67-70)
4.4.7 Additional Fields (71-71)
4.4.10 Data Uses (72-72)
4.5.1 Database Description (73-73)
4.5.3 Data Collection (74-74)
4.5.7 Interconnectivity with Other Databases (75-75)
4.5.8 Analyses Using Database (76-77)
4.5.9 Summary and Potential Measures to Improve Root Cause Analysis (78-78)
4.6 Railroad Accident/Incident Reporting System (RAIRS) (79-79)
4.6.1 Track, Roadbed, and Structures (80-80)
4.6.3 Mechanical and Electrical Failures (81-81)
4.6.5 Summary of Causes and Impact (82-83)
4.7.3 Data Collection (84-84)
4.7.5 Accuracy and Completeness (85-85)
4.8.1 Scope of Investigations (86-86)
4.8.2 Approach to Identifying Root Causes (87-87)
4.8.4 Data Quality (88-88)
4.8.5 Probable Cause Findings (89-89)
4.8.6 Summary (90-90)
4.9.1 Introduction (91-91)
4.9.4 Populating Records and Improving Data Quality (92-92)
4.9.6 Database Enhancements and Limitations (93-93)
4.9.7 Summary (94-94)
5.2 Information System Development (95-95)
5.2.1 Develop Framework for Identifying Contributing Causes and Root Causes of Hazardous Material Accidents (96-96)
5.2.3 Add or Modify Inventory Data in Databases (97-97)
5.2.5 Develop a System for Each Database That Will Target About 5% of Hazmat Crashes for More Detailed Investigation (98-98)
5.3.2 Complete Values for All Parameters (99-102)
5.4.1 Potential Measures for MCMIS (103-104)
5.4.2 Potential Measures for HMIRS (105-106)
5.4.3 Potential Measures for TIFA (107-107)
5.4.4 Potential Measures for RAIRS (108-108)
5.6 Follow-On Project (109-109)
References (110-111)
Appendices (112-112)
Abbreviations used without definitions in TRB publications (113-113)

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.