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 ATL99LA115Accident · No injuriesLimited investigationFinal reportBeech 55 · Nashville, TNThe total failure of the nose gear extension and retraction assembly that resulted in the collapse of the nose gear during landing.NTSB ATL99LA104Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Chuckey, TNThe loss of engine power for undetermined reasons.NTSB MIA99LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Seymour, TNThe failure of the pilot to perform a go-around earlier resulting in a long landing, insufficient runway remaining to stop, and subsequent in flight collision with a marked power line during an aborted landing.NTSB MIA99LA173Accident · Minor injuriesLimited investigationFinal reportCessna 182R · Sevierville, TNA loss of propeller governor control due to oil contamination.NTSB MIA99LA181Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Sevierville, TNThe induced fatigue fracture of a component in the engine-to-transmission rotor drive system resulting in a disconnection of the drive system during cruise flight caused by inadequate inspection processes by the manufacturer and the subsequent autorotative…NTSB ATL99LA094Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Millington, TNLoss of engine power due to undetermined reasons. Factors were weather conditions favorable to carburetor ice and the terrain condition at the forced landing site.NTSB ATL99LA088Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Dickson, TNThe loss of engine power due to undetermined reasons. A factor was uneven terrain.NTSB MIA99LA152Accident · No injuriesLimited investigationFinal reportChristen Industries S-2B · Knoxville, TNa total loss of engine power caused by the failure of the number 6 connecting rod, due to oil starvation for an undetermined reason.NTSB MIA99LA148Accident · No injuriesLimited investigationFinal reportCessna 172N · Eagleville, TNThe dual's student failure to maintain adequate altitude/clearance from the wire during takeoff/initial climb. Also causal was the certified flight instructor's inadequate supervision.NTSB MIA99LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Chattanooga, TNThe failure of the student pilot to maintain directional control during the flare/touchdown.NTSB ATL99LA080Accident · No injuriesLimited investigationFinal reportCessna 182 · Murfreesboro, TNThe pilot's misjudgment of altitude and distance to the runway.NTSB MIA99LA134Accident · Serious injuriesLimited investigationFinal reportDurrwachter Wittman Tailwind · Dover, TNA loss of engine power for undetermined reasonsNTSB ATL99LA069Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Nashville, TNThe pilot's inflight decision to land on a runway with a strong cross wind, rather then on a runway into the wind. A factor was the strong cross wind conditions.NTSB ATL99LA054Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-20 · Knoxville, TNA loss of engine power for undetermined reasons. Contributing to the accident was the failure of the landing gear to extend for undetermined reasons.NTSB ATL99LA051Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Finley, TNThe pilot's inadequate compensation for wind and his failure to maintain directional control. A factor was the gusting winds.NTSB ATL99LA137Accident · No injuriesLimited investigationFinal reportGettis H. Hudson Corban Baby ACE · Pleasant View, TNThe failure of owner of sod runway to properly maintain the runway, the pilots failure to properly preflight the takeoff area before departure.NTSB ATL99LA036Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Murfreesboro, TNThe pilot's inadequate flare and his diverted attention, which resulted in a hard landing.NTSB MIA99LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Knoxville, TNThe engines excessive fuel consumption for undetermined reasons and the pilot's failure to plan the flight with adequate fuel reserves resulting in engine failure due to fuel exhaustion.NTSB ATL99LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Shelbyville, TNWater contamination of the fuel supply, resulting from the pilot's inadequate preflight inspection.NTSB MIA99FA031Accident · Minor injuriesField investigationFinal reportPiper PA-28-151 · Chattanooga, TNThe pilot's inadequate in-flight planning/decision which led to fuel exhaustion.NTSB MIA99LA026Accident · 1 fatalLimited investigationFinal reportSaab-Scania 340A · Memphis, TNThe ground crewmembers inadvertent walking into the path of a rotating propeller resulting in her being struck and fatally injured.NTSB MIA99LA008Accident · 1 fatalLimited investigationFinal reportRyan ST3KR · Rossville, TNThe failure of the pilot to maintain airspeed (VSO) while maneuvering in a recovery from a spin.NTSB MIA98LA255Accident · No injuriesLimited investigationFinal reportCessna A185F · Elizabethton, TNThe failure of the pilot to maintain directional control during the landing roll.NTSB ATL98LA120Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Sewanee, TNThe inadequate visual lookout by the ground pedestrian. A factor was dark night conditions.NTSB ATL98LA114Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Paris, TNThe pilot's improper landing flare that resulted in an overload failure of the left main landing gear.NTSB ATL98FA063Accident · 2 fatalField investigationFinal reportWilliam Sargent Lancair 235 · Newport, TNThe pilot's attempt to operate in instrument meteorological conditions and his failure to maintain clearance with the surrounding terrain. Contributing factors were clouds and the mountainous/hilly terrain.NTSB MIA98LA132Accident · No injuriesLimited investigationFinal reportCessna 150M · Gainesboro, TNThe student pilot's improper flare during landing.NTSB MIA98LA130Accident · 1 fatalLimited investigationFinal reportStarck Auriga · Collegedale, TNA leak in the electric fuel boost pump caused by an improperly sized 'O' ring installation and the pilot's failure to maintain airspeed during an approach to a forced landing resulting in a stall.NTSB MIA98LA124Accident · No injuriesLimited investigationFinal reportDouglas DC-10-10F · Memphis, TNThe tug operator's (maintenance representative) inadequate visual lookout during pushback.NTSB MIA98LA113Accident · No injuriesLimited investigationFinal reportCessna 172M · Kingsport, TNThe dual student's failure to maintain adequate airspeed which resulted in a stall mush. Contributing to the accident were the flight instructor's inadequate supervision and the night conditions.NTSB MIA98LA096Accident · Serious injuriesLimited investigationFinal reportDouglas DC-10-30F · Memphis, TNground personnel (an equipment loader) failed to follow established written procedures (ramp safety policy), resulting in a pressurized entry door being opened before it was fully depressurized, subsequently injurying the equipment loader. The malfunctioning…NTSB MIA98FA091Accident · 1 fatalField investigationFinal reportCessna 208B · Clarksville, TNthe pilot did not maintain control of the airplane due to undetected airframe ice, resulting in an inadvertent stall, and subsequent impact with the ground. Factors in this accident were; flight into clouds, below freezing temperatures, and the inability of…NTSB MIA98LA084Accident · 1 fatalLimited investigationFinal reportWalter J Collie Cumulus · Hillsboro, TNDebonding of the leading edge to spar cap joint, which resulted in inflight separation.NTSB ATL98LA051Accident · Minor injuriesLimited investigationFinal reportPZL-Bielsko SZD-48-3 · Pikeville, TNThe loss of thermal lift.NTSB CHI98IA095Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-320-212 · Memphis, TNthe inadequate (bronze) material used by the fuel pump's manufacturer, which wore and ultimately blocked the fuel filter bypass and partially blocked the fuel nozzles, causing the fuel spray to burn through the low pressure turbine case.NTSB MIA98GA069Accident · 4 fatalFinal reportBell UH-1H · Savannah, TNfailure of the flight crew to maintain sufficient altitude/clearance from the pole and workman. Related factors were: the gusty wind condition, inadequate communication/coordination between the flight crew and ground personnel, and an improper external system…NTSB ATL98LA038Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · Selmer, TNThe loss of control on the ground, due to hydroplaning, and a collision with trees. A factor was the rain.NTSB CHI98LA058Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-50 · Memphis, TNthe flight attendant lost his balance during pushback and struck his head on a galley door.NTSB MIA98FA038Accident · 1 fatalField investigationFinal reportCessna C-182E · Townsend, TNthe pilot's failure to maintain VFR flight conditions in a mountainous area resulting in inflight collision with rising terrain.NTSB MIA98LA033Accident · 1 fatalLimited investigationFinal reportMooney M20C · Sparta, TNThe pilot's inadequate preflight and inflight decision and his inadvertent VFR flight into instrument meteorological conditions. Contributing factors are self induced pressure, mountainous terrain, and low clouds.NTSB MIA98LA024Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Memphis, TNThe pilot-in-command's improper management of fuel resulting in a total loss of engine power on both engines during an instrument approach due to fuel exhaustion.NTSB MIA98FA010Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Knoxville, TNfailure of the pilot to maintain control of the airplane, while climbing after takeoff, which resulted in an uncontrolled descent and impact with the water.NTSB ATL97LA141Accident · No injuriesLimited investigationFinal reportTomlinson Pober Super ACE · Lebanon, TNThe pilot's failure to follow normal checklist procedures that resulted in fuel starvation.NTSB ATL97FA135Accident · 1 fatalField investigationFinal reportCessna 182G · Lexington, TNImproper planning/decision by the pilot, which led to the fuel exhaustion, loss of engine power, and a forced landing. Trees in the emergency landing area were a related factor.NTSB MIA97LA241Accident · No injuriesLimited investigationFinal reportCessna 182B · Paris, TNTemporary loss of engine power for undetermined reasons res ulting in a forced landing on unsuitable terrain.NTSB ATL97LA130Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Murfreesboro, TNThe pilot's excessive airspeed, and improper touch down point during landing, that resulted in the runway end overun. Factors were the wet runway surface, and the embankment at the end of the runway.NTSB MIA97FA239Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Brownsville, TNthe pilot's inadequate preflight, and his improper in-flight planning/decision, which led to fuel exhaustion and a forced landing at night on unprepared terrain. Factors relating to the accident were: darkness, and the lack of a suitable area for an emergency…NTSB ATL97LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Milan, TNThe loss of partial engine power due to undetermined reasons. A factor was the favorable atmospheric conditions for carburetor icing.NTSB ATL97LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Dunlap, TNa loss of engine power for undetermined reasons.NTSB ATL97LA114Accident · No injuriesLimited investigationFinal reportHughes 269A · Dandridge, TNthe pilot's failure to properly plan the approach for landing, which led to a loss of tail rotor authority and directional control, while close to the ground. The tailwind was a related factor.