NTSB investigations, 2009, TN
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\") = 2009
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") = 2009 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 ERA10LA082Accident · 1 fatalLimited investigationFinal reportPiper PA-32RT-300 · Memphis, TNThe pilot's failure to execute a timely missed approach and subsequent failure to maintain aircraft control, after he was unable to establish the airplane on the instrument approach. Contributing to the accident was the pilot's possible impairment due to his…NTSB ERA10CA061Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Clarksville, TNThe pilot’s failure to maintain directional control during the takeoff roll. Contributing to the accident was his decision to take off with a left quartering tailwind.NTSB ERA10FA027Accident · 2 fatalField investigationFinal reportCessna U206G · Elizabethton, TNThe pilot’s failure to remain clear of rising terrain while maneuvering at low altitude.NTSB ERA10FA020Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Oliver Springs, TNThe pilot's loss of directional control while landing on a wet turf runway, which resulted in a runway excursion and collision with a tree.NTSB ERA10CA006Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Gainesboro, TNThe pilot's failure to maintain clearance from trees. Contributing to the accident were the rising terrain and night light conditions.NTSB ERA09LA498Accident · Serious injuriesLimited investigationFinal reportHahn R-W22 Tiger Moth Rep · Symrna, TNA loss of engine power for undetermined reasons.NTSB ERA09CA479Accident · No injuriesData collectionFinal reportJonker JS-1B · Tullahoma, TNThe pilot's failure to maintain a proper glidepath while on approach, resulting in landing short of the runway.NTSB ERA09LA450Accident · 2 fatalLimited investigationFinal reportStump Bradley Kolb · Calhoun, TNThe pilot’s decision to perform aerobatics at a low altitude and his failure to maintain control of the airplane while performing aerobatics.NTSB ERA09LA446Accident · No injuriesLimited investigationFinal reportLobb Kenneth CH 701 · Murfreesboro, TNA total loss of engine power due to the improper installation of the alternator drive gear.NTSB ERA09LA407Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Morristown, TNThe partial loss of engine power for undetermined reasons.NTSB ERA09LA383Accident · Minor injuriesLimited investigationFinal reportRans S5 Coyote · Greeneville, TNThe pilot's failure to maintain airspeed during a forced landing. Contributing to the accident was the loss of engine power due to fuel starvation resulting from the pilot's inadequate preflight inspection.NTSB ERA09LA325Accident · 2 fatalLimited investigationFinal reportSmith Bret B Searey · Knoxville, TNThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall and uncontrolled descent.NTSB ERA09CA327Accident · No injuriesData collectionFinal reportMeuer Mark SA900 V ST · Winchester, TNThe malfunction of the right brake during landing rollout.NTSB ERA09CA313Accident · Minor injuriesData collectionFinal reportPensinger Zodiac 601 · Greeneville, TNAn encounter with wind shear on initial climb after takeoff.NTSB ERA09CA292Accident · No injuriesData collectionFinal reportCessna 152 · Memphis, TNThe pilots' decision to fly at a low altitude and their inadequate visual lookout while maneuvering.NTSB ERA09CA255Accident · Serious injuriesData collectionFinal reportMartin Edward H Fire Star II · Church Hill, TNThe pilot's failure to maintain adequate airspeed to avoid an aerodynamic stall during final approach.NTSB ERA09LA239Accident · Serious injuriesLimited investigationFinal reportDiamond DA20 · Shelbyville, TNA partial loss of engine power for an undetermined reason.NTSB ERA09CA162Accident · Minor injuriesData collectionFinal reportDavis Sonex · Crossville, TNA total loss of engine power during initial climb due to the failure of the ignition power supply as a result of the improper installation of the electronic control unit.NTSB ERA09CA155Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Sevierville, TNThe flight instructor's improper remedial action following the student pilot's loss of control. Contributing to the accident was the student pilot's loss of control.NTSB ERA09LA147Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Moscow, TNThe pilot's initiation of a low altitude maneuver followed by an uncontrolled descent into terrain.NTSB ERA09LA123Accident · 2 fatalLimited investigationFinal reportPiper PA-28-151 · Powder Springs, TNThe non-instrument rated pilot's decision to continue under visual flight rules into an area of instrument meteorological conditions, which resulted in an in-flight collision with terrain.