Fatal NTSB investigations, 2003, AL
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
| 1964 | 5 |
|---|---|
| 1965 | 11 |
| 1966 | 10 |
| 1967 | 11 |
| 1968 | 6 |
| 1969 | 7 |
| 1970 | 4 |
| 1971 | 11 |
| 1972 | 15 |
| 1973 | 18 |
| 1974 | 11 |
| 1975 | 12 |
| 1976 | 9 |
| 1977 | 9 |
| 1978 | 10 |
| 1979 | 7 |
| 1980 | 5 |
| 1981 | 8 |
| 1982 | 8 |
| 1983 | 8 |
| 1984 | 12 |
| 1985 | 7 |
| 1986 | 12 |
| 1987 | 6 |
| 1988 | 8 |
| 1989 | 10 |
| 1990 | 11 |
| 1991 | 8 |
| 1992 | 12 |
| 1993 | 6 |
| 1994 | 10 |
| 1995 | 7 |
| 1996 | 8 |
| 1997 | 4 |
| 1998 | 5 |
| 1999 | 7 |
| 2000 | 2 |
| 2001 | 9 |
| 2002 | 4 |
| 2003 | 8 |
| 2004 | 4 |
| 2005 | 5 |
| 2006 | 5 |
| 2007 | 7 |
| 2008 | 5 |
| 2009 | 5 |
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 5 |
| 2013 | 3 |
| 2014 | 4 |
| 2015 | 2 |
| 2016 | 3 |
| 2017 | 2 |
| 2018 | 5 |
| 2019 | 4 |
| 2020 | 8 |
| 2021 | 2 |
| 2022 | 3 |
| 2023 | 5 |
| 2024 | 3 |
| 2025 | 1 |
| 2026 | 2 |
Where
Latest 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\" = 'AL' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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" = 'AL' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' 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 ATL04FA049Accident · 2 fatalField investigationFinal reportCessna 441 · Vestavia Hills, ALThe pilot's failure to maintain adequate airspeed during climb in icing conditions, which resulted in an inadvertent stall / spin of the airplane and subsequent uncontrolled descent and collision with terrain. A factor was the accumulation of airframe ice.NTSB ATL03LA116Accident · 1 fatalLimited investigationFinal reportButler Bowers Fly Baby 1A · Lincoln, ALThe pilot's failure to maintain airspeed while maneuvering resulting in a stall.NTSB ATL03LA113Accident · 1 fatalLimited investigationFinal reportAero Vodochody Aero Works L39C · Gadsden, ALThe loss of engine power during takeoff due to foreign object damage, which resulted in an in-flight collision with terrain during forced landing. Factors were the pilot's inadequate preflight inspection of the airplane, his failure to secure the…NTSB ATL03FA114Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Scottsboro, ALThe pilot's improper fuel management which resulted in a loss of engine power due to fuel starvation and subsequent impact with trees.NTSB ATL03LA152Accident · 2 fatalLimited investigationFinal reportChinook Plus 2 A13-SWB · Elsanor, ALThe loss of engine power for undetermined reasons.NTSB ATL03FA082Accident · 1 fatalField investigationFinal reportSocata TBM 700B · Mobile, ALThe improper installation of the power control linkage on the engine fuel control unit by maintenance personnel which resulted in a loss of power lever control, and the pilot's failure to follow emergency procedures and his intentional engine shutdown which…NTSB ATL03FA075Accident · 2 fatalField investigationFinal reportCessna 180 · Oxford, ALThe pilot's continued VFR flight into IMC conditions and his failure to maintain obstacle clearance. A factor was low ceilings.NTSB ATL03LA037Accident · 1 fatalLimited investigationFinal reportLong 2000 · Brewton, ALThe pilot's improper use of flight controls (cyclic and collective) and failure to maintain rotor RPM while maneuvering that resulted in the separation of the tailboom assembly.