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 ATL91IA016Incident · No injuriesIncident investigationFinal reportSaab-Scania 340A · Memphis, TNThe pilot's failure to follow approved procedures for troubleshooting inflight maintenance problems and improperly used the flight and engine controls.NTSB ATL91IA014Incident · No injuriesIncident investigationFinal reportBell 412 · Knoxville, TNThe pilot's failure to see and avoid the wires prior to the collision. Factors in the incident were the failure of the ground personnel to adequately inspect the landing zone, the presence of high intensity lights at the lz, and the dark lighting conditions.NTSB ATL91FA013Accident · Serious injuriesField investigationFinal reportBell 47J-2 · Gatlinburg, TNThe accident was inadequate maintenance of the helicopter, allowing a tail rotor drive shaft bearing to exceed wear limits. This resulted in high loads on the tail rotor drive shaft, and the resulting fatigue failure of the drive shaft.NTSB ATL91LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Centerville, TNThe propable cause of the accident was the runway incursion by the deer during the pilot's takeoff roll.NTSB ATL91FA006Accident · 1 fatalField investigationFinal reportOlsen-Gordon Veri EZE · Hohenwald, TNThe failure of the left rudder control cable which rendered the airplane uncontrollable.NTSB ATL91LA004Accident · Serious injuriesLimited investigationFinal reportE TN Plts Starduster Starduster II · Knoxville, TNPilot's inadvertent closing of the fuel shutoff valve, which totally or partially restricted fuel flow to the engine.NTSB ATL90FA183Accident · 2 fatalField investigationFinal reportGrumman AA5B · Gallatin, TNThe pilot's failure to maintain the proper altitude which resulted in the inadvertent descent into the ground, and his diverted attention to another airplane. Factors in the accident were fog, dark night, fatigue from lack of sleep, and a lack of recent night…NTSB ATL90LA180Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Fayetteville, TNThe pilot's premature flare which resulted in a loss of directional control at touchdown.NTSB ATL90LA168Accident · Serious injuriesLimited investigationFinal reportSchleicher ASK-21 · Memphis, TNAn inflight collision with a tree due to misjudging his glidepath.NTSB ATL90FA163Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-36 · Nashville, TNThe company/operator management's decision to operate the aircraft with a known deficiency without further maintenance, the pilot's improper planning/decision and the pilot's failure to abort the takeoff (while there was sufficient runway remaining). Factors…NTSB ATL90LA162Accident · Serious injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Savannah, TNThe pilot's failure to maintain aircraft control during the landing phase of the flight. Factors were: gusting wind conditions and turbulence.NTSB ATL90LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Cleveland, TNThe pilot's failure to properly judge the stopping distance of the airplane and his subsequent failure to perform a go around. Factors in the accident were the tailwind condition at the airport.NTSB ATL90LA151Accident · Minor injuriesLimited investigationFinal reportCessna 172B · Midway, TNTotal failure of the number four exhaust valve, resulting in engine power loss and the subsequent forced landing of the airplane.NTSB ATL90LA142Accident · No injuriesLimited investigationFinal reportCessna T210L · Memphis, TNFuel mismanagement by the pilot which resulted in fuel starvation during final approach.NTSB ATL90LA137Accident · No injuriesLimited investigationFinal reportCessna 150L · Blountville, TNThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion.NTSB ATL90LA133Accident · No injuriesLimited investigationFinal reportCessna 150M · Knoxville, TNPilot's failure to maintain directional control upon landing and subsequent premature rotation of the airplane during the go-around attempt. Contributing to the accident was the pilot's lack of total experience.NTSB ATL90LA102Accident · No injuriesLimited investigationFinal reportCessna 170 · Johnson City, TNThe pilot/mechanic's inadequate preflight inspection of the aircraft fuel system.NTSB ATL90DLT01Accident · No injuriesFinal reportGrumman G-164B · Tiptonville, TNA loss of engine power for undetermined reasons. A factor in the accident was the rough terrain.NTSB ATL90FA089Accident · 1 fatalField investigationFinal reportHiller UH-12D · Soddy-Daisy, TNFatigue induced failure of the collective pitch push rod (adjustable) during flight, and the failure of the pilot to provide routine maintenance. The pilot's lack of expereince and his failure to obtain required training and certification were factors in the…NTSB ATL90LA088Accident · No injuriesLimited investigationFinal reportMooney M20F · Murfreesboro, TNFatigue failure of the propeller blade which resulted in a forced off-airport landing.NTSB ATL90LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Bolivar, TNThe pilot failed to properly select a tank with sufficient fuel prior to takeoff.NTSB ATL90FA074Accident · 1 fatalField investigationFinal reportPiper PA-30 · Dayton, TNThe pilot's intentional use of an autopilot with known deficiencies. The pilot knowingly relied on this autopilot which malfunctioned in flight and resulted in his becoming spatially disorientated.NTSB ATL90FA061Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Norris, TNThe student pilot's misjudged descent which resulted in a collision with trees and the ground. A factor was that the pilot was buzzing when the accident occurred.NTSB ATL90LA053Accident · No injuriesLimited investigationFinal reportMitsubishi MU2B-20 · Nashville, TNInadequate maintenance adjustment of the landing gear system which resulted in the jamming of the left gear door.NTSB ATL90LA052Accident · Serious injuriesLimited investigationFinal reportAero Commander 680E · Knoxville, TNThe pilot's excessive airspeed and delay in initiating a go-around during the landing. Factors related to the accident were: the wet runway condition, the pilot's failure to attain the proper touchdown point for the landing, and his lack of flying experience…NTSB ATL90LA046Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Selmer, TNThe failure of the instructor to place the engine mixture control in the rich position prior to beginning traffic pattern maneuvers. As a result, the engine quit because of the lean fuel mixture at the high power setting required for the go-around and…NTSB ATL90LA034Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Jackson, TNLoss of power in both engines (probable fuel starvation) due to improper planning/decision by the pilot(s), and lack of supervision by the instructor. Soft terrain in the emergency landing area was considered to be a factor.NTSB MIA90FA031Accident · 2 fatalField investigationFinal reportCessna 170A · Rogersville, TNContinued flight into instrument meteorological conditions by a non-instrument rated pilot resulting in spatial disorientation and a loss of aircraft control. Factors contributing to the accident were: the pilot's overconfidence in his ability to fly in…NTSB ATL90LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Dyersburg, TNPilot's temporary physical condition (possible hyperventilation or anxiety attack). Soft terrain in the emergency landing area was considered to be a related factor.NTSB MIA90FA014Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Athens, TNLoss of control of the airplane in instrument flight conditions due to spatial disorientation, which resulted in an inadvertent descending spiral. Lack of total experience in the type of operation (actual instrument conditions) was considered to be a…NTSB ATL89LA216Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Cleveland, TNThe improper handling of the airplane by the pilot in command; a delayed go-around, and the premature retractions of the flaps.NTSB ATL89FA207Accident · 2 fatalField investigationFinal reportCessna 152 · Tiptonville, TNThe pilot's failure to maintain a proper climb rate after takeoff. Factors related to the accident were: darkness, the pilot's lack of visual cues, his habit of making shallow climbs after takeoff, his lack of recent night flying experience, and the trees.NTSB ATL89LA204Accident · Serious injuriesLimited investigationFinal reportBeech A23-19 · Gallatin, TNThe pilot used an unsuitable runway area (terrain) for takeoff. Related factors were: inadequate maintenance of the runway, runway conditions (uneven surface & tall grass), and the fence.NTSB ATL89LA195Accident · Minor injuriesLimited investigationFinal reportCessna 210C · Millington, TNA loss of engine power, due to contamination in the fuel flow manifold. The contamination in the fuel system was due to inadequate maintenance.NTSB ATL89DLT05Accident · 1 fatalFinal reportBratton RB-1 · Springfield, TNImproper planning/decision by the pilot, which resulted in fuel exhaustion at a low altitude, due to an inadequate supply of fuel; and his failure to maintain airspeed, which resulted in an inadvertent stall/spin. Factors related to the accident were: the…NTSB ATL89FA177Accident · Serious injuriesField investigationFinal reportCessna 172 · Townsend, TNImproper in-flight planning/decision by the pilot and his delay in initiating remedial action, when he encountered low ceilings over mountainous terrain, which resulted in his inability to maintain sufficient altitude. Contributing factors were: the pilot's…NTSB ATL89DLT04Accident · Minor injuriesFinal reportPitts S-1 · Butler, TNThe failure of the pilot to maintain clearance from the surface during an impromptu acrobatic maneuver.NTSB ATL89FA174Accident · 1 fatalField investigationFinal reportPiper PA-30 · Springfield, TNThe pilot's decision to continue flight into an area of known adverse weather which resulted in his ability to maintain control of the airplane. Contributing factor(s) was: the adverse weather conditions.NTSB ATL89FA173Accident · 4 fatalField investigationFinal reportCessna 210H · Piney Flats, TNThe pilot's failure to maintain control of the aircraft after becoming spatially disoriented, and his exceeding the design stress limits of the aircraft while attempting to recover from an uncontrolled descent. Factors related to the accident were: darkness,…NTSB ATL89LA162Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Knoxville, TNThe pilot's failure to recognize that the engine was not developing full power and the delay in performing remedial action until it was too late to stop the airplane on the runway.NTSB ATL89FA161Accident · Serious injuriesField investigationFinal reportLockheed L1011-385-1 · Jacks Creek, TNFailure of the passengers to remain seated with their seat belts fastened as the airplane encountered unforecast severe clear air turbulence.NTSB ATL89LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Jackson, TNThe separation of the mixture cable from the carburetor. Contributing factor(s) was: inadequate maintenance and inspection of the airplane and the soft terrain encountered during the forced landing.NTSB ATL89FA150Accident · 2 fatalField investigationFinal reportTaylorcraft BC12-D · Jamestown, TNThe pilot failed to maintain adequate airspeed to avoid an inadvertent stall. The stall occurred at an altitude which precluded recovery prior to ground impact. Contributing to the accident was the pilot's lack of proficiency in the airplane.NTSB ATL89DLT03Accident · No injuriesFinal reportBell 47 · Shelbyville, TNFailure in the rotor drive system for unknown reasons. Contributing to the accident was the pilot's inability to perform an autorotation.NTSB ATL89FA142Accident · 1 fatalField investigationFinal reportEmbraer EMB-110-P1 · Mt. Pleasant, TNPilot attempted to make a VFR landing in instrument conditions that were below minimums for the published instrument approach and collided with trees and the ground after allowing the airplane to descend below the proper altitude.NTSB ATL89LA119Accident · No injuriesLimited investigationFinal reportCessna 152 · Bolivar, TNThe pilot's failure to properly plan required fuel for this flight which resulting in fuel exhaustion and a forced landing in a field.NTSB ATL89FA106Accident · 2 fatalField investigationFinal reportBeech H35 · Knoxville, TNThe pilot's continued operation of the airplane with a known mechanical defect in the engine carburetor/fuel supply system as evidenced by the past history of engine stoppage during ground operation. Contributing to the accident was the pilot's performance of…NTSB ATL89LA096Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Blountville, TNCarburetor ice. The pilot failed to apply carburetor heat in a timely and adequate manner. This failure resulted in the accumulation of ice to a point of failure of the engine which eliminated the heat necessary to remove the ice.NTSB ATL89LA091Accident · No injuriesLimited investigationFinal reportCessna 170B · Cleveland, TNFlight into known adverse weather by the pilot and his delay in diverting to an alternate airport which led to a partial power loss and an emergency landing. The weather conditions and soft terrain were contributing factors.NTSB ATL89FA086Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Jasper, TNThe pilot's improper handling of the airplane flight controls at low altitude which resulted in an excessive rate of descent and collision with a tree.