Final NTSB investigations, TN
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 | 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 | 27 |
| 2025 | 17 |
| 2026 | 5 |
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 c.\"eventStateOrRegion\" = 'TN' AND c.\"eventCountry\" = 'USA'
AND c.\"completionStatus\" = 'Completed'
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 c."eventStateOrRegion" = 'TN' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Completed' 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 ERA26LA327Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · McMinnville, TNThe flight instructor’s delayed remedial action during a practice autorotation, which resulted in a hard landing.NTSB ERA26LA255Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Lafayette, TNThe passenger’s abrupt manipulation of the flight controls during takeoff, which resulted in a loss of directional control and collision with a fence.NTSB ERA26LA194Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 206L-4 · Chapmansboro, TNFailure of the volunteer fire department personnel to properly monitor and secure a stretcher, which resulted in it rolling into the helicopter’s tail rotor.NTSB ERA26LA128Accident · Minor injuriesClass 4 · LimitedFinal reportBeech C23 · Knoxville, TNThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion and collision with a ditch.NTSB ERA26LA099Accident · No injuriesClass 4 · LimitedFinal reportFrankewich Walter S-21 Outbound · Madisonville, TNThe pilot’s failure to compensate for gusty crosswind conditions during the landing roll, which resulted in a loss of control and subsequent runway excursion.NTSB ERA26LA048Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Cookeville, TNThe pilot’s failure to maintain an appropriate decent rate during approach, resulting in a hard landing.NTSB ERA26LA028Accident · No injuriesClass 4 · LimitedFinal reportConsolidated Vultee 28-5ACF · Dayton, TNThe collapse of the left main landing gear due to the fatigue fracture of the lower landing gear actuator bolt.NTSB ERA25LA371Accident · Minor injuriesClass 4 · LimitedFinal reportNorth American T-6G · Rossville, TNThe pilot’s failure to adequately monitor the airplane’s path during takeoff toward the setting sun. Contributing was the undetected worn and fractured tailwheel locking pin.NTSB ERA25LA351Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Smyrna, TNThe pilot’s failure to extend the landing gear before landing.NTSB ERA25LA317Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Knoxville, TNThe pilot’s failure to maintain directional control during landing roll in a crosswind, which resulted in a runway excursion and a subsequent ground loop.NTSB ERA25LA295Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Memphis, TNFailure of the left main landing gear due to the loss of the protective paint coating and a change in the local surface finish from impermissible grinding, which resulted in fatigue cracking.NTSB ERA25LA291Accident · Minor injuriesClass 4 · LimitedFinal reportBeech 35-C33 · Kingston, TNThe pilot’s failure to maintain directional control during takeoff roll, which resulted in a runway excursion and collision with haybales.NTSB ERA25LA238Accident · No injuriesClass 3 · LimitedFinal reportCessna 310 · Fayetteville, TNThe pilot’s decision to operate the airplane with known discrepancies.NTSB DCA25LA239Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320 · Nashville, TNThe airplane’s encounter with moderate convective turbulence during descent.NTSB ERA25LA226Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Murfreesboro, TNThe pilot’s mismanagement of available fuel, which resulted in fuel starvation and a subsequent loss of total engine power.NTSB ERA25LA233Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Knoxville, TNA collision with a deer during the landing roll.NTSB ERA25LA213Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Murfreesboro, TNThe pilot’s failure to maintain directional control of the airplane while attempting to take off in a gusty crosswind, which resulted in a runway excursion.NTSB DCA25LA197Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737 · Centerville, TNAn encounter with hail during descent.NTSB ERA25LA138Accident · No injuriesClass 4 · LimitedFinal reportCessna 172I · Knoxville, TNThe student pilot’s failure to maintain clearance from a truck while taxiing.NTSB ERA25LA135Accident · Minor injuriesClass 4 · LimitedFinal reportIcon A5 · Smithville, TNThe pilot’s failure to retract the landing gear prior to landing in water. Contributing to the accident was the pilot’s failure to use the manufacturer’s provided checklist.NTSB ERA25LA114Accident · No injuriesClass 3 · LimitedFinal reportCessna 172P · Clarksville, TNThe flight instructor’s inadequate preflight inspection of the airplane, which allowed the partially secured engine cowl to separate in flight.NTSB ERA25LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Smyrna, TNThe pilot’s failure to maintain an appropriate approach path, resulting in the airplane contacting a tree during a landing approach at night.NTSB ERA25LA077Accident · No injuriesClass 4 · LimitedFinal reportWolstenholme Dennis Pietenpol AIR Camper · Tullahoma, TNThe pilot’s failure to adequately secure the airplane before hand-propping the engine. Contributing was the pilot’s lack of training in hand-propping procedures.NTSB ERA25LA052Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Chattanooga, TNA partial loss of engine power due to a fouled spark plug in engine’s the No. 4 cylinder. Contributing was the flight instructor’s failure to maintain aircraft control during an attempted go-around following an unsuccessful landing approach in IMC, which…NTSB ERA25LA046Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Mariner · Parrottsville, TNThe pilot’s failure to maintain control of the helicopter during a precautionary, off-airport landing to sloping terrain.NTSB ERA25LA043Accident · No injuriesClass 4 · LimitedFinal reportCessna 310K · Alcoa, TNThe failure of the left engine throttle control shaft bushing during taxi, resulting in a full asymmetric power condition and a taxiway excursion.NTSB ERA25FA037Accident · 1 fatalClass 3 · FieldFinal reportCessna 150F · Wilder, TNThe student pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions at night, which resulted in controlled flight into terrain.NTSB ERA25LA022Accident · No injuriesClass 4 · LimitedFinal reportTextron T206H · Blountville, TNThe pilot’s failure to maintain directional control during takeoff and subsequent rejected takeoff, which resulted in a runway excursion. Contributing to the accident was the pilot’s failure to verify rudder trim setting prior to takeoff.NTSB ERA24FA391Accident · 1 fatalClass 3 · FieldFinal reportAviat S-1-11B · Chapmansboro, TNThe pilot’s loss of airplane control while performing an aerobatic maneuver, which resulted in the airplane entering an inverted flat spin at an altitude too low for recovery.NTSB ERA24LA385Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Dyersburg, TNFailure of the tailwheel strut, which resulted in a loss of directional control during landing roll and a runway excursion.NTSB ERA24LA375Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802 · Hickory Valley, TNA partial loss of engine power due to a leak in the fuel control unit bellows, which resulted in the fuel valve moving to minimum fuel flow.NTSB ERA24LA346Accident · 1 fatalClass 4 · LimitedFinal reportPiper J3 · Mooresburg, TNThe pilot’s intentional flight into a building as an act of suicide.NTSB ERA24LA296Accident · Serious injuriesClass 4 · LimitedFinal reportMissoula Super Drifter · Lafayette, TNThe pilot's failure to maintain control of the airplane during a go-around in gusting wind conditions.NTSB ERA24LA255Accident · Minor injuriesClass 3 · LimitedFinal reportTitan T51 · Madisonville, TNThe failure of the right main landing gear weldment due to fatigue cracking.NTSB ERA24LA254Accident · Minor injuriesClass 3 · LimitedFinal reportNorth American Navion · Tullahoma, TNA total loss of engine power during takeoff as a result of fuel starvation.NTSB ERA24LA253Accident · No injuriesClass 4 · LimitedFinal reportDavis Lightning · Jamestown, TNThe non-certificated pilot’s failure to maintain control of the airplane during landing, which resulted in an aerodynamic stall and subsequent hard landing.NTSB ERA24LA252Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182 · Telford, TNThe pilot’s failure to maintain control of the airplane while performing a go-around, which resulted in an inflight collision with trees.NTSB ERA24LA234Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Fayetteville, TNA collision with a deer during the takeoff roll.NTSB ERA24FA217Accident · 3 fatalClass 3 · FieldFinal reportBeech V35 · Franklin, TNThe pilot’s flight into convective weather, which resulted in a loss of control due to spatial disorientation and a subsequent inflight breakup of the airplane. Contributing to the accident was the lack of accurate weather intensity depiction on the…NTSB ERA24LA181Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Shelbyville, TNThe student pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control and subsequent runway excursion.NTSB ERA24FA176Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-301 · Knoxville, TNThe pilot’s decision to depart into an area of instrument meteorological and icing conditions, which resulted in loss of airplane control and a subsequent in-flight breakup.NTSB ERA24LA155Accident · Minor injuriesClass 4 · LimitedFinal reportSouth Central Searey · Knoxville, TNThe pilot’s failure to retract the landing gear of the amphibious airplane prior to a water landing.NTSB DCA24LA130Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-800 · Paris, TNAn encounter with convective turbulence.NTSB ERA24FA127Accident · 5 fatalClass 3 · FieldFinal reportPiper PA32RT · Nashville, TNThe pilot’s failure to ensure the proper placement of the fuel selector during the approach and landing, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB ERA24LA131Accident · No injuriesClass 4 · LimitedFinal reportFairchild SA227-AT · Smyrna, TNThe airplane encountered a sink hole while taxiing.NTSB ERA24LA106Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Smyrna, TNAn in-flight collision with a bird during initial climb.NTSB ERA24LA095Accident · No injuriesClass 3 · LimitedFinal reportCessna 210D · Paris, TNThe disruption of torque to the No 4 connecting rod journals, which resulted in a spun bearing and the subsequent total loss of engine power.NTSB ERA24LA087Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Hohenwald, TNThe pilot’s failure to use carburetor heat in conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power due to fuel starvation. Contributing to the outcome was her failure to attain a proper touchdown point…NTSB ERA24LA082Accident · No injuriesClass 3 · LimitedFinal reportMooney M20K · Tullahoma, TNA total loss of engine power for undetermined reasons.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.