NTSB investigations, 2003, AL
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 | 1 |
| 1964 | 61 |
| 1965 | 92 |
| 1966 | 70 |
| 1967 | 85 |
| 1968 | 68 |
| 1969 | 75 |
| 1970 | 89 |
| 1971 | 73 |
| 1972 | 76 |
| 1973 | 82 |
| 1974 | 67 |
| 1975 | 71 |
| 1976 | 77 |
| 1977 | 82 |
| 1978 | 72 |
| 1979 | 50 |
| 1980 | 50 |
| 1981 | 48 |
| 1982 | 61 |
| 1983 | 60 |
| 1984 | 41 |
| 1985 | 45 |
| 1986 | 48 |
| 1987 | 45 |
| 1988 | 36 |
| 1989 | 33 |
| 1990 | 32 |
| 1991 | 30 |
| 1992 | 40 |
| 1993 | 33 |
| 1994 | 27 |
| 1995 | 42 |
| 1996 | 32 |
| 1997 | 17 |
| 1998 | 27 |
| 1999 | 29 |
| 2000 | 17 |
| 2001 | 25 |
| 2002 | 27 |
| 2003 | 30 |
| 2004 | 27 |
| 2005 | 22 |
| 2006 | 24 |
| 2007 | 29 |
| 2008 | 28 |
| 2009 | 13 |
| 2010 | 8 |
| 2011 | 17 |
| 2012 | 25 |
| 2013 | 10 |
| 2014 | 24 |
| 2015 | 23 |
| 2016 | 12 |
| 2017 | 19 |
| 2018 | 20 |
| 2019 | 15 |
| 2020 | 17 |
| 2021 | 15 |
| 2022 | 21 |
| 2023 | 19 |
| 2024 | 11 |
| 2025 | 18 |
| 2026 | 17 |
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\" = 'AL' 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" = 'AL' 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 ATL04IA067Incident · No injuriesIncident investigationFinal reportSabreliner NA-265-60 · Birminghham, ALThe lack of lubrication of the right main wheel bearing which resulted in the overheating.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 ATL04LA044Accident · Minor injuriesLimited investigationFinal reportCessna 182-K · Birmingham, ALA loss of engine power due to the throttle/power lever cable becoming disconnected in-flight, as a result of maintenance personnel failure to comply with Airworthiness Directive (AD) 86-24-07 and Cessna information letter SE79-6.NTSB ATL04LA034Accident · No injuriesLimited investigationFinal reportHughes 269A · Birmingham, ALThe certified flight instructor's inadequate aircraft control and his improper landing flare resulting in a hard landing and roll over.NTSB ATL04LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Troy, ALThe certified flight instructor's improper fuel management resulting in a loss of engine power due to fuel starvation resulting in a forced landing, in-flight collision with trees and ground.NTSB ATL04LA029Accident · No injuriesLimited investigationFinal reportYakovlev YAK55M · Troy, ALA loss of engine power due to a fractured connecting rod for undetermined reasons.NTSB ATL04LA013Accident · No injuriesLimited investigationFinal reportCessna 172P · Pell City, ALThe pilot's inadequate compensation for wind and his failure to maintain directional control during landing. A factor was the crosswind.NTSB ATL04LA011Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Huntsville, ALThe pilot's failure to maintain obstacle clearance while hovering out of ground effect, which resulted in a collision with a tree and subsequent uncontrolled collision with the ground.NTSB ATL04LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Pell City, ALThe pilot's failure to follow VFR Approach procedures and to maintain visual lookout.NTSB ATL03LA148Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Talladega, ALThe pilot's failure to use carburetor heat when weather conditions were favorable for carburetor icing.NTSB ATL03LA146Accident · Serious injuriesLimited investigationFinal reportAeronca BL-7-AC · Pell City, ALThe pilots failure to maintain airspeed that resulted in the loss of control and the subsequent collision with the ground.NTSB ATL03LA121Accident · Minor injuriesLimited investigationFinal reportLancair 235 · Fort Payne, ALThe pilot's failure to properly reconnect the mixture control cable resulting in a total loss of engine power, and subsequent in-flight collision with the trees.NTSB ATL03LA109Accident · No injuriesLimited investigationFinal reportKeuthan Buccaneer II · Pell City, ALThe failure of the throttle cable due to fatigue resulting in a loss of engine power. Factor were uphill rough and uneven terrain.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 ATL03LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hamilton, ALThe pilot's inadequate preflight inspection by his failure to ensure adequate oil supply, which resulted in oil exhaustion and the failure of the connecting rod cap.NTSB ATL03LA102Accident · No injuriesLimited investigationFinal reportCollier Quickie · Alexander, ALThe loss engine of power due to undetermined reasons.NTSB ATL03LA096Accident · No injuriesLimited investigationFinal reportCessna 150G · Morris, ALThe pilot's selection of unsuitable terrain for a precautionary landing, which resulted in a ground collision with terrain, and subsequent collapse of the nose gear.NTSB ATL03LA086Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Montgomery, ALThe in-flight collision with birds that resulted in a partial loss of engine power, and subsequent in-flight collision with trees while maneuvering for an emergency landing.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 ATL03LA076Accident · No injuriesLimited investigationFinal reportLarry Woods Venture · Fort Payne, ALThe pilot's failure to maintain directional control during the landing roll.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 ATL03IA073Incident · No injuriesIncident investigationFinal reportCessna 182P · Eufaula, ALFatigue failure of end rib for the left canard flap.NTSB ATL03LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Enterprise, ALThe loss of engine power due to oil starvation resulting from a crack in the propeller governor external oil line. A factor was the soft terrain.NTSB ATL03LA059Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Gordo, ALFatigue failure of the crankshaft.NTSB ATL03LA043Accident · Serious injuriesLimited investigationFinal reportPenska Rans S-9 · Dothan, ALThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent inflight collision with the groundNTSB 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.NTSB ATL03LA032Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Geneva, ALThe pilot's failure to achieve takeoff due to a mistrimmed elevator, and his failure to maintain directional control.