NTSB investigations, TN
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, newest first
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' 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' 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 ATL05CA045Accident · Minor injuriesData collectionFinal reportCessna 152 · Nashville, TNA loss of engine power due to fuel starvation as a result of fuel system blockage.NTSB ATL05LA042Accident · 1 fatalLimited investigationFinal reportBeech 35 · Knoxville, TNThe pilot's failure to maintain adequate obstacle clearance, which resulted in the in-flight collision with trees. A factor was dark night.NTSB ATL05FA032Accident · 5 fatalField investigationFinal reportCessna 421B · Apison, TNThe pilot's improper identification of a partial loss of engine power on initial takeoff climb resulting in a collision with trees and the ground. A factor was a partial failure of the left engine starter adapter due to overload.NTSB ATL05LA031Accident · No injuriesLimited investigationFinal reportCessna 172K · Smyrna, TNThe pilot's inadequate preflight planning of fuel required for the flight, and his inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.NTSB ATL05CA028Accident · No injuriesData collectionFinal reportEnstrom F-28A · Smyrna, TNThe loss of engine power for undetermined reasons, and the pilot's improper flare during forced landing, which resulted in an inflight collision into an open field.NTSB ATL05LA026Accident · Serious injuriesLimited investigationFinal reportGolden Circle Air T-Bird II · Dunlap, TNThe pilot's improper flare during forced landing following a loss of engine power for undetermined reasons, which resulted in a hard landing. A factor was the separation of a fuel line, which resulted in fuel starvation to the engine.NTSB ATL05LA023Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Sewanee, TNThe pilot's improper flare during landing, which resulted in the overload and collapse of the nose landing gear and subsequent on-ground loss of control of the airplane (aircraft control not possible) and collision with a parked airplane.NTSB ATL05LA020Accident · Serious injuriesLimited investigationFinal reportFranzreb Loehle 5151 Mustang · Athens, TNThe loss of engine power due to the electrical fuel pump failure, and fuel starvation.NTSB ATL05CA002Accident · Serious injuriesData collectionFinal reportCessna 172K · Knoxville, TNThe pilot's failure to maintain airspeed on initial take off climb resulted in an inadvertent stall and an uncontrolled descent into the ground.NTSB ATL04CA197Accident · No injuriesData collectionFinal reportCessna 150M · Sevierville, TNThe pilot's failure to maintain directional control during an attempted takeoff, which resulted in the on ground collision with high vegetation and a subsequent nose over. Factors were a foggy windshield and windshield defrost not activated.NTSB DCA04MA082Accident · No injuriesMajor investigationFinal reportBoeing MD-11 · Memphis, TNThe pilot's over-rotation during a go-around maneuver initiated because of a bounced landing. The go-around maneuver was initiated at a low speed and high pitch angle, and after reverse thrust was selected, contrary to Boeing and FedEx training guidance.NTSB ATL04CA189Accident · No injuriesData collectionFinal reportBeech D18S · Tullahoma, TNRight tire burst during an attempted takeoff that resulted in loss of directional control and the on ground collision with the ground.NTSB ATL04LA171Accident · Minor injuriesLimited investigationFinal reportHawkins William Searey · Dayton, TNThe delamination of the fiberglass hull of the airplane.NTSB ATL04LA166Accident · 1 fatalLimited investigationFinal reportSidney Freebird · Lexington, TNThe pilot's failure to maintain airspeed, resulting in an inadvertent stall, and collision with the ground. A factor was the pilot's total lack of experience in type of aircraft.NTSB ATL04CA154Accident · No injuriesData collectionFinal reportGlassic Composites SQ-2000 XL · Dayton, TNThe pilot's failure to maintain directional control during landing roll, which resulted in a ground loop and the subsequent collapse of the landing gear.NTSB ATL04CA136Accident · Serious injuriesData collectionFinal reportBeech A23 · Columbia, TNThe pilot's failure to maintain clearance from trees during climb and the pilot's failure to execute a go-around before completing the approach to land.NTSB ATL04FA130Accident · 2 fatalField investigationFinal reportCessna 172F · Madisonville, TNThe pilot's failure to maintain airspeed while maneuvering on a touch and go landing resulting in a stall and collision with the ground.NTSB ATL04CA129Accident · No injuriesData collectionFinal reportCessna 172N · Dover, TNThe certified flight instructor initiated flight into thunderstorm activity that resulted in a loss of control and the subsequent collision with trees.NTSB ATL04LA128Accident · 1 fatalLimited investigationFinal reportGrover J3 Kitten · Mohawk, TNThe pilot's decision to perform aerobatic flight in an airplane with known deficiencies that resulted in the in-flight separation of the airframe and the uncontrolled collision with the ground.NTSB ATL04CA125Accident · Serious injuriesData collectionFinal reportTaylorcraft DC-65 · Savannah, TNThe pilot's inadequate preflight planning of fuel required for the flight, which resulted in fuel exhaustion, and the subsequent loss of engine power.NTSB ATL04IA119Incident · No injuriesIncident investigationFinal reportBeech 200 · Millington, TNThe pilots failure to follow the checklist for emergency landing gear extension resulting in the collapse of the main landing gear on touchdown.NTSB ATL04LA103Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Sale Creek, TNThe pilot's failure to maintain airspeed, and the pilot's alcohol impairment that resulted in an inadvertent stall and collision with the ground.NTSB ATL04LA097Accident · 1 fatalLimited investigationFinal reportDurr Lancair Legacy · Oakland, TNThe pilot loss control of the airplane when he continued flight into known thunderstorm and convective activity. A factor is insufficient information provided by ATC personnel.NTSB ATL04CA095Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Carthage, TNThe pilot's failure to maintain visual lookout and clearance while maneuvering resulting in an in-flight collision with wires and subsequent collision with water.NTSB ATL04LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Knoxville, TNThe CFI's inadequate in-flight planning/decision and his inadequate supervision which resulted in fuel exhaustion. A factor was the inadequate preflight planning/preparation to ensure an adequate fuel supply, and the berm.NTSB ATL04LA081Accident · No injuriesLimited investigationFinal reportCessna 182P · Nashville, TNThe pilot's improper landing flare and his inadequate recovery from a bounced landing resulting in a hard landing and propeller strike of the runway.NTSB ATL04LA080Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Nashville, TNThe pilot's inadequate compensation for wind and his failure to maintain aircraft control which resulted in a hard landing. The pilot's decision to land in wind conditions that exceeded the demonstrated crosswind component, wind gusts, and a crosswind were…NTSB ATL04FA079Accident · 2 fatalField investigationFinal reportCessna 210 · Blountville, TNThe pilot's improper flare, and improper recovery which resulted in a bounced landing, collapse of the left main landing gear, and the pilot's failure to maintain airspeed while maneuvering resulting in a stall, uncontrolled descent, and collision with the…NTSB ATL04LA078Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Collegedale, TNThe pilot's inability to maintain directional control due to the inadequate grounding of the nose wheel steering clutches, as a result of inadequate maintenance inspection by other maintenance personnel to ensure the nose wheel steering clutches were…NTSB ATL04LA057Accident · 1 fatalLimited investigationFinal reportInterplane Skyboy-2 · Covington, TNThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin and collision with the ground. A factor was the unqualified person (pilot).NTSB DCA04MA011Accident · Minor injuriesClass 1 · MajorFinal reportMcDonnell Douglas MD-10-10F · Memphis, TN1) the first officer's failure to properly apply crosswind landing techniques to align the airplane with the runway centerline and to properly arrest the airplane's descent rate (flare) before the airplane touched down; and 2) the captain's failure to…NTSB ATL04LA068Accident · No injuriesLimited investigationFinal reportCessna 182L · Knoxville, TNThe pilot's improper flare and his inadequate compensation for wind conditions. Wind gust was a factorNTSB ATL04FA051Accident · 4 fatalField investigationFinal reportCessna 414 · Greeneville, TNThe pilot's failure to maintain airspeed while maneuvering in icing conditions on a circling approach for landing resulting in an inadvertent stall and collision with trees and terrain. A factor in the accident was a partial loss of engine power due to the…NTSB ATL04LA035Accident · No injuriesLimited investigationFinal reportCessna 210D · Millington, TNThe malfunction of the main hydraulic landing gear system actuator resulting in an emergency gear up landing.NTSB ATL04LA032Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Lawrenceburg, TNThe pilot's failure to maintain directional control on landing rollout resulting in the airplane veering to the right and collapsing the left main landing gear with a side load.NTSB ATL04LA022Accident · No injuriesLimited investigationFinal reportDiamond DA 20-C1 · Murfreesboro, TNThe pilot's failure to attain adequate airspeed, which resulted in a stall mush and collision with a taxiway sign. A factor was the pilot's delay in aborting the landing.NTSB ATL04FA023Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Spencer, TNThe pilot's failure to maintain airspeed while maneuvering resulting in an inadvertent stall and the subsequent collision with the ground.NTSB ATL04LA021Accident · 1 fatalLimited investigationFinal reportGodwin Lancair 360 · Knoxville, TNA total loss of engine power for undetermined reasons and subsequent inflight collision with rocks during forced landing.NTSB ATL04LA008Accident · No injuriesLimited investigationFinal reportCessna 182H · Knoxville, TNThe pilot's inadequate preflight inspection by his failure to secure the left fuel tank cap which resulted in fuel exhaustion, and the loss of engine power.NTSB ATL04LA006Accident · No injuriesLimited investigationFinal reportPiper J-3 -C65 · Jackson, TNThe pilot's improper us of flight controls during an attempted takeoff, which resulted in an collision with the specially equipped automobile.NTSB ATL03LA151Accident · Serious injuriesLimited investigationFinal reportSheppard S-2 · Obion, TNThe failure of the elevator control pushrod, that resulted in an uncontrolled descent and subsequent in-flight collision with ground.NTSB ATL03LA139Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Collegedale, TNA loss of engine power due to oil exhaustion as a result of the installation of the incorrect quick-drain valve that opened during flight.NTSB ATL03LA138Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Seymour, TNThe pilot's failure to maintain clearance during the final approach to land which resulted in an inflight collision with a tree.NTSB ATL03CA135Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Murfreesboro, TNAn on-ground collision with an animal (deer) during an attempted takeoff. .NTSB ATL03FA134Accident · 2 fatalField investigationFinal reportBeech BE-35 · Kingsport, TNThe certified flight instructor's mismanagement of the fuel, resulting in a loss of engine power and his failure to maintain airspeed, which resulted in a stall.NTSB ATL03LA130Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Winchester, TNA maintenance personnel failure to follow propeller inspection procedures that resulted in a fatigue failure of a propeller blade and the subsequent forced landing.NTSB ATL03LA117Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Hendersonville, TNThe total loss of engine power due to loss of oil pressure for undetermined reasons, resulting in a forced landing and nose over on none suitable terrain.NTSB ATL03FA115Accident · 2 fatalField investigationFinal reportBeech 58P · Memphis, TNAn encounter with wake turbulence on approach, which resulted in the pilot's inability to maintain control and subsequent in-flight collision with the ground.NTSB ATL03FA111Accident · 3 fatalField investigationFinal reportMaule M-5-235C · Rockvale, TNLoss of engine power for undetermined reasons.NTSB ATL03FA125Accident · 2 fatalField investigationFinal reportBellanca 7KCAB · Dover, TNThe pilot continued VFR flight into adverse weather conditions including instrument meteorological conditions and turbulence in thunderstorms, which resulted in a loss of control in flight and subsequent collision with terrain.