NTSB investigations, 2022, TN
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 | 2 |
| 1964 | 74 |
| 1965 | 56 |
| 1966 | 58 |
| 1967 | 58 |
| 1968 | 51 |
| 1969 | 57 |
| 1970 | 56 |
| 1971 | 58 |
| 1972 | 56 |
| 1973 | 62 |
| 1974 | 39 |
| 1975 | 56 |
| 1976 | 53 |
| 1977 | 43 |
| 1978 | 40 |
| 1979 | 38 |
| 1980 | 41 |
| 1981 | 43 |
| 1982 | 28 |
| 1983 | 41 |
| 1984 | 35 |
| 1985 | 34 |
| 1986 | 36 |
| 1987 | 37 |
| 1988 | 36 |
| 1989 | 26 |
| 1990 | 29 |
| 1991 | 26 |
| 1992 | 25 |
| 1993 | 26 |
| 1994 | 27 |
| 1995 | 38 |
| 1996 | 33 |
| 1997 | 34 |
| 1998 | 21 |
| 1999 | 28 |
| 2000 | 26 |
| 2001 | 25 |
| 2002 | 23 |
| 2003 | 35 |
| 2004 | 27 |
| 2005 | 22 |
| 2006 | 19 |
| 2007 | 23 |
| 2008 | 24 |
| 2009 | 21 |
| 2010 | 25 |
| 2011 | 23 |
| 2012 | 29 |
| 2013 | 17 |
| 2014 | 24 |
| 2015 | 24 |
| 2016 | 25 |
| 2017 | 20 |
| 2018 | 13 |
| 2019 | 24 |
| 2020 | 24 |
| 2021 | 20 |
| 2022 | 26 |
| 2023 | 26 |
| 2024 | 29 |
| 2025 | 29 |
| 2026 | 15 |
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\") = 2022
AND c.\"eventStateOrRegion\" = 'TN' 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") = 2022 AND c."eventStateOrRegion" = 'TN' 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 ERA23LA085Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Knoxville, TNThe pilot’s loss of directional control during engine start.NTSB ERA23LA059Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA-1A · Sparta, TNA total loss of engine power due to an accumulation of carburetor ice, resulting in an off-airport landing and substantial damage to the airplane.NTSB ERA23FA025Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32-300 · Brentwood, TNA total loss of engine power due to the catastrophic failure of the crankshaft resulting from the improper installation of the crankshaft for this application.NTSB ERA23LA032Accident · No injuriesClass 4 · LimitedFinal reportHoward DGA-15P · Lawrenceburg, TNThe pilot’s failure to maintain directional control during landing in gusting wind conditions.NTSB ERA23LA019Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5A · Knoxville, TNThe student pilot’s loss of directional control on landing.NTSB ERA23LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Morristown, TNThe solo student pilot’s improper flare, which resulted in a hard landing.NTSB ERA22LA431Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R-22 Beta · Nashville, TNA loss of tail rotor effectiveness while hovering in crosswind conditions resulting in the student pilot's loss of control of the helicopter, impact with terrain, and dynamic rollover.NTSB ERA22LA424Accident · Minor injuriesClass 3 · LimitedFinal reportRockwell International 700 · Sevierville, TNThe total loss of engine power to the twin-engine airplane during final approach due to fuel exhaustion. Contributing to the accident was the pilot’s failure to maintain aircraft control during the approach to land, which resulted in a runway excursion and…NTSB ERA22LA413Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Chattanooga, TNA total loss of engine power due to of carburetor ice. Contributing to the accident was the pilot’s failure to apply carburetor heat.NTSB CEN22FA406Accident · 2 fatalClass 3 · FieldFinal reportCessna 182 · Cleveland, TNThe pilot’s loss of airplane control while operating in instrument meteorological conditions.NTSB ERA22FA391Accident · 1 fatalClass 3 · FieldFinal reportAeronca 7AC · Jacksboro, TNThe pilot's exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall and loss of control.NTSB ERA22FA383Accident · 2 fatalClass 3 · FieldFinal reportBell 206B · Whiteside, TNThe pilot’s failure to maintain clearance from the powerlines.NTSB ERA22LA311Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · Livingston, TNThe pilot’s improper flare, which resulted in a hard landing.NTSB ERA22LA296Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Knoxville, TNThe inadequate maintenance of the left main landing gear through bolt, which resulted in a left main landing gear collapse and subsequent runway excursion during landing.NTSB ERA22LA295Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-260 · Lewisburg, TNThe pilot’s loss of control during the takeoff roll, which resulted in a runway excursion.NTSB CEN22FA217Accident · 1 fatalClass 3 · FieldFinal reportCessna 162 · Memphis, TNPilot incapacitation due to an acute cardiac event.NTSB ERA22LA249Accident · Minor injuriesClass 3 · LimitedFinal reportAeronca 7AC · Melrose, TNA total loss of engine power due to carburetor icing.NTSB ERA22LA230Accident · No injuriesClass 4 · LimitedFinal reportBeech C24 · Gallatin, TNA landing gear collapse due to the failure and/or separation of the pin in the right main landing gear.NTSB ERA22LA224Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT-301 · Somerville, TNThe inadequate inspection and maintenance of the engine exhaust system, which resulted in an in-flight fire.NTSB ERA22LA186Accident · Serious injuriesClass 3 · LimitedFinal reportHenry L Berrier JR Arion Lightning LS-1 · Mountain City, TNA total loss of engine power due to intermittent operation of both the engine-driven fuel pump and the electric boost pump. Contributing was the pilot’s delay in rejecting the takeoff, after the initial loss of engine power, which resulted in a collision with…NTSB ERA22LA185Accident · No injuriesClass 4 · LimitedFinal reportPF Cub Flyers CCK-2000 · Collegedale, TNThe pilot's failure to maintain directional control of the airplane during landing, which resulted in a runway excursion and a subsequent nose-over.NTSB ERA22LA171Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Sparta, TNMaintenance personnel’s failure to properly affix left main landing gear components, which led to the failure of the left main landing gear during the accident flight.NTSB ERA22LA139Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · Madisonville, TNA partial loss of engine power for undetermined reasons.NTSB ERA22LA106Accident · No injuriesClass 4 · LimitedFinal reportCharles C Menger JR Safari 400 · Gallatin, TNA reported stuck throttle for reasons that could not be determined during postaccident examinations and subsequent loss of control during hover.NTSB ERA22LA103Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Knoxville, TNThe pilot of the Cessna 150’s failure to avoid the taxiing Cessna 172.NTSB ERA22LA101Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Lebanon, TNThe failure of the certified flight instructor to attain the proper glidepath which resulted in a collision with a fence and terrain.