NTSB investigations, 2023, 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\") = 2023
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") = 2023 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 ERA24LA076Accident · No injuriesClass 3 · LimitedFinal reportBell Helicopter Textron 206L-1 · Walland, TNThe improper installation of the No. 8 bearing spanner nut, which resulted in the No. 8 bearing’s failure, and the subsequent total loss of engine power.NTSB ERA24FA058Accident · 2 fatalClass 3 · FieldFinal reportBeech 35-C33 · Pulaski, TNThe pilot’s failure to maintain airplane control, which resulted in pilot-induced oscillations and a subsequent loss of control and impact with terrain.NTSB ERA24LA054Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32-260 · Millington, TNThe pilots’ fuel mismanagement during the cross-country flight and incorrect fuel tank selection for the landing approach, which resulted in fuel starvation, a momentary loss of engine power, and collision with terrain short of the runway.NTSB ERA24FA038Accident · 2 fatalClass 3 · FieldFinal reportXtremeair XA42 · Union City, TNThe pilot receiving instruction’s loss of airplane control while performing aerobatics, which resulted in a stall/spin at an altitude too low for recovery. Contributing to the accident was the flight instructor’s inadequate supervision.NTSB ERA24LA032Accident · Minor injuriesClass 3 · LimitedFinal reportTaylorcraft BC12-65 · Columbia, TNA partial loss of engine power due to an accumulation of carburetor ice, resulting in an off-airport landing and substantial damage to the airplane.NTSB ERA24LA018Accident · No injuriesClass 3 · LimitedFinal reportRoth Frank Ronald Avid Aircraft · Knoxville, TNA total loss of engine power due to a seized piston in the power take-off cylinder.NTSB ERA24LA020Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Jackson, TNThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a runway excursion.NTSB ERA24LA017Accident · No injuriesClass 4 · LimitedFinal reportAviat A1 · Tellico Plains, TNThe pilot's overapplication of brakes after landing long on a constrained runway and with a tailwind, which resulted in a nose-over.NTSB ENG24FA003Incident · No injuriesClass 3 · FieldFinal reportBoeing 767-300F · Memphis, TNA high-pressure fuel leak from a gap in the bolted flange interface between the main fuel pump’s fuel crossover supply tube and the hydromechanical unit idler adapter pad, which resulted in the crossover tube flange bolts partially pulling out and allowing…NTSB DCA24FA002Accident · No injuriesClass 2 · FieldFinal reportBoeing 757-236 · Chattanooga, TNThe failure of the alternate gear extension system, which prevented the landing gear from being lowered. The cause of the system failure was a broken wire, due to tensile overload, between the alternate gear extend switch and the alternate extension power…NTSB ERA23LA372Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182P · Prospect, TNA loss of engine power due to the fatigue failure of the No. 6 cylinder exhaust valve rocker boss.NTSB ERA23LA361Accident · No injuriesClass 3 · LimitedFinal reportBeech V35 · Rutledge, TNA total loss of engine power due to the fatigue failure of a retaining circlip in one of the No. 2 crankshaft cheek counterweights, which resulted in liberation of the counterweight.NTSB CEN23LA358Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Sevierville, TNThe flight instructor’s improper flight control inputs during the practice hovering autorotation that resulted in a loss of control and impact with terrain.NTSB ERA23LA347Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Knoxville, TNAn in-flight fire that resulted from an inadequate 100-hr inspection, which failed to detect and correct improper electrical cable routing in the engine compartment.NTSB ERA23LA314Accident · Serious injuriesClass 4 · LimitedFinal reportMooney M20R · Chattanooga, TNThe pilot’s failure to maintain the proper glidepath during final approach, which resulted in a collision with the approach lights short of the runway. Contributing was the pilot’s distraction due to the cabin door opening.NTSB ERA23LA271Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Seymore, TNThe flight instructor’s failure to properly configure the wing flaps for a soft-field takeoff on a short runway, which resulted in a runway overrun and collision with trees.NTSB ERA23LA264Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Lancaster, TNThe fatigue failure of an exhaust valve, resulting in a partial loss of engine power.NTSB ERA23LA242Accident · Minor injuriesClass 4 · LimitedFinal reportGary R Brearley RV-9A · Kingston, TNThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing which resulted in a nose over.NTSB ERA23FA219Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Reliance, TNThe pilot’s decision to continue an instrument flight into an area of forecast weather with severe to extreme turbulence associated with a line of thunderstorms, which resulted in an in-flight breakup. Contributing was the pilot’s operation of the airplane in…NTSB ERA23LA227Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5A · Knoxville, TNThe pilot’s failure to maintain directional control during takeoff in gusting wind conditions.NTSB ERA23LA205Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C · Springfield, TNA partial loss of engine power for undetermined reasons.NTSB ERA23LA172Accident · Minor injuriesClass 4 · LimitedFinal reportHelicopteres Guimbal Cabri G2 · Clarksville, TNThe flight instructor’s inadequate remedial action following an abrupt control input by the student pilot, which resulted in abnormal contact with the ground and a dynamic rollover.NTSB ERA23LA166Accident · No injuriesClass 4 · LimitedFinal reportBeech C35 · Cleveland, TNThe retraction of the landing gear after landing for unknown reasons.NTSB ERA23LA145Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Knoxville, TNThe pilot's failure to maintain directional control during the takeoff roll where a gusting and shifting crosswind prevailed.NTSB ERA23LA115Accident · Minor injuriesClass 4 · LimitedFinal reportEiriavion PIK-20D · Benton, TNThe pilot’s decision to turn toward a mountain ridge in a thermal, which resulted in a collision with terrain.NTSB ERA23LA111Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-160 · Somerville, TNBased on available evidence, the reason for the damage to the airplane’s propeller and engine cowling could not be determined.