NTSB investigations, 2003, LA
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1962 | 1 |
|---|---|
| 1963 | 3 |
| 1964 | 120 |
| 1965 | 109 |
| 1966 | 108 |
| 1967 | 118 |
| 1968 | 100 |
| 1969 | 100 |
| 1970 | 91 |
| 1971 | 75 |
| 1972 | 75 |
| 1973 | 88 |
| 1974 | 84 |
| 1975 | 105 |
| 1976 | 93 |
| 1977 | 106 |
| 1978 | 108 |
| 1979 | 103 |
| 1980 | 110 |
| 1981 | 95 |
| 1982 | 78 |
| 1983 | 57 |
| 1984 | 72 |
| 1985 | 57 |
| 1986 | 47 |
| 1987 | 33 |
| 1988 | 36 |
| 1989 | 41 |
| 1990 | 40 |
| 1991 | 26 |
| 1992 | 25 |
| 1993 | 32 |
| 1994 | 25 |
| 1995 | 22 |
| 1996 | 40 |
| 1997 | 28 |
| 1998 | 27 |
| 1999 | 28 |
| 2000 | 26 |
| 2001 | 28 |
| 2002 | 26 |
| 2003 | 21 |
| 2004 | 27 |
| 2005 | 32 |
| 2006 | 18 |
| 2007 | 15 |
| 2008 | 13 |
| 2009 | 21 |
| 2010 | 16 |
| 2011 | 28 |
| 2012 | 23 |
| 2013 | 19 |
| 2014 | 19 |
| 2015 | 20 |
| 2016 | 21 |
| 2017 | 17 |
| 2018 | 18 |
| 2019 | 21 |
| 2020 | 23 |
| 2021 | 23 |
| 2022 | 16 |
| 2023 | 16 |
| 2024 | 26 |
| 2025 | 17 |
| 2026 | 10 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE year(c.\"eventDate\") = 2003
AND c.\"eventStateOrRegion\" = 'LA' AND c.\"eventCountry\" = 'USA'
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE year(c."eventDate") = 2003 AND c."eventStateOrRegion" = 'LA' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB FTW04LA063Accident · No injuriesLimited investigationFinal reportCessna 172K · Lake Charles, LAThe disintegration of the piston, which resulted in the catastrophic failure of the engine. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04IA077Incident · No injuriesIncident investigationFinal reportBell BH-212 · Galliano, LAThe loss of tail rotor control due to sheared, loose, and bent bolts which secured the tail rotor pitch control bellcrank support bracket.NTSB FTW04IA043Incident · No injuriesIncident investigationFinal reportBell 206B · Venice, LAThe failure of the forward boost pump while in cruise flight while operating with less than 10 gallons of fuel onboard, which resulted in a loss of engine power. A factor was the inoperative forward fuel boost pump caution light switch.NTSB FTW03FA225Accident · 2 fatalField investigationFinal reportCessna 310J · New Orleans, LAThe pilot's failure to maintain aircraft control of the airplane during a go-around. A contributing factor was the crosswind.NTSB FTW03LA216Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Kisatchie, LAA loss of engine power due to water contamination in the fuel system.NTSB FTW03LA204Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Winnsboro, LAThe pilot's inadequate inflight planning, which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB CHI03FA259Accident · 3 fatalField investigationFinal reportBell 206L-3 · E.I. 276, LAThe inadequate compensation for crosswind conditions and the directional control not obtained/maintained by the pilot during takeoff. Contributing factors were the crosswind and the planned approach to position the helicopter with a crosswind in order to…NTSB FTW03LA166Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Franklinton, LAThe pilot's encounter with dynamic rollover due to his failure to properly remove the tie-down strap on the right skid prior to takeoff. Factors were the pilot's inadequate preflight preparation and failure to abort takeoff.NTSB FTW03TA156Accident · No injuriesFinal reportBell 407 · Franklin, LAThe loss of tail rotor effectiveness due to the inadequate maintenance performed by other company personnel.NTSB FTW03LA135Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Bossier City, LAThe failure of the passenger to follow the pilots landing instructions.NTSB FTW03LA136Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Batchelor, LAThe pilot's failure to abort the takeoff with adequate runway available. A contributing factor was the high density altitude.NTSB FTW03LA122Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Monroe, LAThe pilot's failure to maintain control of the helicopter. A contributing factor was the crosswind.NTSB FTW03FA117Accident · No injuriesField investigationFinal reportBell 407 · Houma, LAThe loss of tail rotor drive and anti-torque control resulting from the fracture and separation of the #5 tail rotor drive segment due to the overtemperature and subsequent failure of the #5 hangar bearing.NTSB FTW03LA106Accident · Minor injuriesLimited investigationFinal reportEurocopter AS350B2 · Venice, LAThe pilot's inability to maintain directional control following a loss of tail rotor drive. A contributing factor was the fog.NTSB FTW03LA102Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Ruston, LAThe separation of the upper tail cone as a result of a fractured bolt due to fatigue.NTSB FTW03LA092Accident · Minor injuriesLimited investigationFinal reportMooney M20J · New Orleans, LAThe loss of engine power as a result of the separation of the magneto assembly due to inadequate maintenance by unknown personnel. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03LA088Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Oak Grove, LAThe pilot's continued flight into adverse weather conditions, and his improper landing flare resulting in a hard landing. A contributing factors was the fog.NTSB FTW03TA087Accident · Serious injuriesFinal reportBeech T-34B · Hammond, LAThe pilot's inadequate inflight planning/decision resulting in fuel exhaustion and the loss of engine power. A contributing factor was the night light conditions.NTSB CHI03FA056Accident · 1 fatalField investigationFinal reportBell 206L-1 · B.S. 53, LAThe improper approach by the pilot and the settling with power encountered by the pilot.NTSB FTW03LA081Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350-BA · Venice, LAThe loss of tail rotor drive as a result of baggage coming in contact with the tail rotor blades after the aft cargo door was not secured. A contributing factor was the passenger's failure to follow the procedures for properly securing the helicopter's doors…NTSB FTW03FA071Accident · 2 fatalField investigationFinal reportGrumman American AA-1A · Shreveport, LAThe pilot's failure to maintain adequate airspeed resulting in a stall.