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 ATL94FA137Accident · 2 fatalField investigationFinal reportCessna 150L · Greenville, TNThe failure of the pilot to maintain sufficient terrain clearance, and his inadvertent stall at low altitude.NTSB ATL94LA127Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Finley, TNThe loss of engine power for undetermined reasons. Factors were wet and soft terrain.NTSB ATL94LA126Accident · Serious injuriesLimited investigationFinal reportGreen Starduster TOO · Chattanooga, TNThe pilot's failure to maintain aircraft control, resulting in an inadvertent stall, and collision with terrain.NTSB ATL94LA108Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Williston, TNThe pilot's failure to maintain flying speed which resulted in a stall and a collision with the ground.NTSB ATL94LA104Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Memphis, TNThe pilot's failure to maintain clearance from the earthen dike during the swath run.NTSB ATL94IA097Incident · No injuriesIncident investigationFinal reportDouglas DC-9-32 · Memphis, TNThe fatigue fracture of the combustion chamber outer case. A factor was the manufacturer's inadequate inspection criteria.NTSB ATL94IA092Incident · No injuriesIncident investigationFinal reportSaab-Scania S340B · Nashville, TNEngine ice/slush ingestion that resulted in power interruptions and failure of the air data computer coupled with moisture ingestion of the static system. Factors were the failure of the manufacturer to correct a previously identified design deficiency that…NTSB ATL94LA086Accident · No injuriesLimited investigationFinal reportFerguson Fergy II · Nashville, TNThe pilot's failure to maintain clearance from a utility wire during climbout.NTSB ATL94LA078Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Collegedale, TNThe pilot's failure to compensate for wind conditions during a crosswind landing. The crosswind was a factor.NTSB ATL94LA077Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-30 · Memphis, TNNot Determined.NTSB ATL94FA076Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Elizabethton, TNThe pilot's attempted VFR flight into IMC conditions, and his failure to maintain a proper altitude over mountainous terrain. Factors were the clouds and obscuration at the accident site.NTSB ATL94FA075Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Smithville, TNThe pilot's failure to obtain recent weather information to avoid flight into icing conditions. Factors in the accident were: management-induced pressure and the icing conditions.NTSB ATL94LA067Accident · 1 fatalLimited investigationFinal reportCessna 140 · Celina, TNThe pilot's failure to maintain a proper altitude, and his failure to maintain clearance from the transmission wire.NTSB ATL94LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Lebanon, TNThe student pilot's failure to follow the flight instructor's instructions to abort the takeoff after the airplane failed to develop takeoff power. The student pilot also delayed in relinquishing the flight control of the airplane to the flight instructor. A…NTSB ATL94LA063Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Nashville, TNA loss of engine power for undetermined reasons.NTSB ATL94LA059Accident · No injuriesLimited investigationFinal reportPZL-Bielsko SZD-55-1 · Mcminnville, TNThe failure of the pilot to maintain control of the aircraft during the landing approach.NTSB ATL94LA050Accident · Serious injuriesLimited investigationFinal reportArgo Minimax · Franklin, TNThe pilot's failure to secure cargo in the cockpit.NTSB ATL94LA045Accident · No injuriesLimited investigationFinal reportCessna 310R · Memphis, TNThe failure of the pilot of N2069C to follow the ATC directive to give way to N3844C, and the inadequate visual lookout by the pilot of N2069C. A factor was the dark night lighting condition at the time of the accident.NTSB ATL94LA044Accident · No injuriesLimited investigationFinal reportCessna 310A · Dyersburg, TNThe failure of the pilot to attain a proper touchdown point, which resulted in a long landing and an overrun of the runway. Factors were the weather conditions (sky obscuration, low ceiling, fog and drizzle) at the time of the accident, and the wet runway…NTSB ATL94LA031Accident · 2 fatalLimited investigationFinal reportCarson Piel Emeraude CP305 · Morrison, TNThe pilot's inadvertent flight into instrument meteorological conditions (IMC), and failure to maintain aircraft control after becoming spatially disoriented. Factors related to the accident were: the adverse weather conditions, and the pilot's improper…NTSB ATL94LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Maryville, TNThe pilot's inadequate inflight planning, which resulted in fuel exhaustion prior to reaching the planned destination.NTSB ATL94FA012Accident · 2 fatalField investigationFinal reportMooney M20L · Hohenwald, TNThe pilot's impaired judgement and performance by flying while under the influence of drugs, that resulted in his continuation of VFR flight at night in instrument meteorological conditions (IMC) and his failure to maintain proper altitude (or clearance) from…NTSB ATL94FA006Accident · 2 fatalField investigationFinal reportMooney M20B · Bethpage, TNThe pilot's VFR flight into IMC, and his failure to maintain aircraft control. Factors were the pilot's failure to use a preflight briefing service, and the low ceilings and fog at the accident site.NTSB ATL94LA005Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Maryville, TNFailure of the pilot to maintain airspeed control, which resulted in a low altitude stall.NTSB ATL94LA004Accident · No injuriesLimited investigationFinal reportCessna 172 · Blountville, TNImproper planning/decision by the pilot, which resulted in inadequate fuel and fuel exhaustion.NTSB ATL93LA164Accident · No injuriesLimited investigationFinal reportCessna 210 · Smyrna, TNThe inadequate maintenance of the taxiway.NTSB ATL93LA160Accident · 1 fatalLimited investigationFinal reportCornwell KR-2 · Covington, TNThe pilot's misjudged obstacle clearance on final approach. Factors were, the dark night, and the pilot's defective distant vision.NTSB ATL93FA155Accident · 2 fatalField investigationFinal reportBeech F35 · Jackson, TNThe improper use of old auto fuel for the refueling of the aircraft. Factors in the accident were the deterioration of the octane in the auto fuel being used in the aircraft and the delayed decision by the pilot to choose a suitable area and execute a forced…NTSB ATL93LA148Accident · Minor injuriesLimited investigationFinal reportBeech V35A · Knoxville, TNInadequate annual inspection procedures for the fuel system, which resulted in fuel starvation due to blockage of the fuel floscan transducer. A factor was insufficient FAA inspection standards/requirements.NTSB ATL93LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Cleveland, TNThe pilot's failure to maintain directional control of the airplane while taxiing.NTSB ATL93LA137Accident · 1 fatalLimited investigationFinal reportWard Long EZE · Murfreesboro, TNThe pilot's failure to properly use the carburetor heat control which resulted in the formation of carburetor ice.NTSB ATL93LA123Accident · 1 fatalLimited investigationFinal reportGulfstream G-164B · Selmer, TNThe pilot's failure to maintain adequate clearance from the power lines.NTSB ATL93LA114Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Smyrna, TNThe improper flare and the improper go around procedures used by the pilotNTSB ATL93LA095Accident · No injuriesLimited investigationFinal reportCessna 172 · Athens, TNFailure of the aircraft engine to produce power for unknown reasons.NTSB ATL93LA093Accident · No injuriesLimited investigationFinal reportCessna 152 · Grandview, TNFailure of the aircraft battery.NTSB ATL93LA089Accident · No injuriesLimited investigationFinal reportFairchild 24G · Athens, TNThe pilot's failure to use carburetor heat in weather conditions which were conducive to the formation of carburetor iceNTSB ATL93LA078Accident · 2 fatalLimited investigationFinal reportDobbs VAN'S Aircraft RV-6 · Kingston, TNThe pilot's inadequate compensation for gusty wind conditions. A factor was the wind gust of 20-25 knots.NTSB ATL93LA075Accident · Minor injuriesLimited investigationFinal reportBell UH1F · Gatlinburg, TNThe loss of engine power for unknown reasons.NTSB ATL93LA073Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenville, TNThe pilot's improper procedures in that he landed with excessive flap extension, and his inadequate compensation for the gusting crosswind.NTSB ATL93LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Elizabethton, TNA loss of engine power on one engine for undetermined reasons.NTSB ATL93MA068Accident · 4 fatalMajor investigationFinal reportFairchild SA227-TT · Blountville, TNFailure of the pilot to follow procedures concerning use of the engine inlet anti-ice system and/or continuous ignition while operating in icing conditions, which resulted in probable ice ingestion and loss of engine power; and the pilot's failure to maintain…NTSB ATL93LA063Accident · No injuriesLimited investigationFinal reportBeech 58 · Blountville, TNThe intentional operation of the aircraft with a partial failure of the brake system and the failure of the pilot to attain the proper touchdown point. Factors in the accident were the sunglare and the partial loss of the aircraft brake system.NTSB ATL93FA062Accident · 1 fatalField investigationFinal reportCessna 402B · Tullahoma, TNThe pilot's failure to maintain control of the airplane during takeoff. Factors which contributed to the accident were: the pilot's failure to ensure that the airplane maximum gross takeoff weight was not exceeded, the dark night, and rain.NTSB ATL93FA060Accident · Serious injuriesField investigationFinal reportCessna 337D · Nashville, TNThe pilot's failure to ensure an adequate fuel supply for the flight, which resulted in fuel exhaustion.NTSB ATL93LA049Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Crossville, TNThe pilot's failure to follow checklist procedures in that he did not utilize the alternate gear extension method when electrical power was lost. A factor was his failure to follow the checklist when he failed to turn on the generators prior to flight, which…NTSB ATL93LA043Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Smithville, TNThe failure of the pilot to follow pilot manual procedures by slipping the aircraft with inadequate fuel available, which resulted in fuel starvation. Factors were the inadequate fuel supply on the aircraft and the failure of the pilot to refuel.NTSB ATL93LA037Accident · 1 fatalLimited investigationFinal reportDonald Rhodes Moni 110 · Greenville, TNThe pilot's operation of the aircraft beyond its design stress limits.NTSB ATL93LA029Accident · Minor injuriesLimited investigationFinal reportChampion 7AC · Troy, TNThe pilot's inadequate preflight planning, his failure to attain a proper climb rate, and the inadvertent stalling of the aircraft while attempting to avoid high obstructions (trees). Factors were the rough, uneven runway conditions, the high obstructions,…NTSB ATL93FA021Accident · No injuriesField investigationFinal reportHawker Siddeley DH.125-400A · Nashville, TNThe company mechanic's improper preflight of the aircraft, resulting in a foreign object (flashlight) being left in the nose gear well.NTSB ATL93LA019Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Rives, TNThe pilot's failure to follow instrument procedures while conducting an instrument approach which resulted in the collision with trees; the pilot descended below the minimum descent altitude.