NTSB investigations, 2020, AL
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 2020
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") = 2020 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 ERA21LA068Accident · 1 fatalClass 3 · LimitedFinal reportBeech V35A · Attalla, ALA loss of control inflight and the failure of a component of the up elevator flight control system due to fatigue, which rendered recovery from a right descending turn improbable.NTSB ERA21FA010Accident · 1 fatalClass 3 · FieldFinal reportCzech Sport Cruiser · Waterloo, ALThe improper configuration of the airplane’s fuel system, which resulted in a total loss of engine power due to fuel starvation following the failure of the electric fuel pump.NTSB ERA20LA314Accident · 1 fatalClass 3 · LimitedFinal reportZenair CH750 Cruzer · Boaz, ALThe pilot’s failure to maintain control of the airplane, which resulted in an aerodynamic stall and impact with trees and terrain. Contributing was the pilot’s continued visual flight rules flight into an area of low clouds.NTSB ERA20CA293Accident · Minor injuriesClass 4 · Data collectionFinal reportWag Aero Cubby · Pell City, ALThe flight instructor’s inadequate remedial action following the student pilot’s loss of directional control during landing, which resulted in a runway excursion and subsequent nose over.NTSB ERA20LA272Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Alabaster, ALA loss of control and lack of climb performance shortly after takeoff for reasons that could not be determined based on available evidence, resulting in a collision with terrain.NTSB ERA20LA262Accident · 2 fatalClass 3 · LimitedFinal reportBeech F33 · Malbis, ALThe noninstrument-rated pilot’s decision to depart in deteriorating weather conditions, which led to restricted visibility and the pilot’s loss of airplane control due to spatial disorientation. Contributing to the pilot’s poor decision-making was…NTSB ERA20LA259Accident · No injuriesClass 3 · LimitedFinal reportBeech 400 · Montgomery, ALLanding with the left main landing gear retracted due to the failure of the landing gear control unit, which resulted in substantial damage.NTSB ERA20CA263Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Prattville, ALThe student pilot's failure improper landing flare, which resulted in a hard landing.NTSB ERA20LA217Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT502 · Atmore, ALThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall, spin, and loss of control.NTSB ERA20LA212Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA32RT · Selma, ALThe mechanic’s failure to clean the oil suction screen during the most recent maintenance, which resulted in oil starvation and subsequent total loss of engine power.NTSB ERA20LA197Accident · 1 fatalClass 3 · LimitedFinal reportSchweizer 269C-1 · Ozark, ALA total loss of engine power due to fuel exhaustion. Contributing to the accident was the flight school’s inadequate maintenance of the helicopter’s fuel quantity and caution systems.NTSB ERA20LA194Accident · No injuriesClass 3 · LimitedFinal reportBellanca 8KCAB · Rainbow City, ALThe partial loss of engine power for reasons that could not be determined based on available evidence.NTSB ERA20CA187Accident · No injuriesClass 4 · Data collectionFinal reportAviat A1B · Guntersville, ALThe pilot's failure to retract the amphibious airplane's landing gear wheels prior to a water landing, which resulted in a nose over.NTSB ERA20LA164Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32RT · Meridianville, ALThe pilot's slip maneuver with a less than full fuel tank selected, which resulted in unporting of the fuel supply, and a total loss of engine power due to fuel starvation.NTSB ERA20LA161Accident · No injuriesClass 3 · LimitedFinal reportKeuthan Buccaneer II · Coden, ALA total loss of engine power due to carburetor icing. Contributing to the accident was the lack of a carburetor heat system installed on the engine.NTSB ERA20CA116Accident · Serious injuriesData collectionFinal reportLet L 23 Super Blanik · Huntsville, ALThe pilot's failure to maintain glider control and his exceedance of the glider's critical angle of attack while maneuvering in gusting wind conditions, which resulted in an aerodynamic stall.NTSB ERA20FA063Accident · 2 fatalClass 3 · FieldFinal reportVans Vans RV-6 · Cullman, ALThe pilot’s inadequate planning, which resulted in fuel exhaustion and a total loss of engine power during the initial climb. Also causal was the pilot’s exceedance of the airplane’s critical angle of attack while attempting to return to the runway after…