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 ATL93LA018Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Johnson City, TNThe pilot's improper management of the fuel system.NTSB ATL93LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Knoxville, TNThe pilots poor inflight decision to attempt to land the aircraft in an unsuitable area.NTSB ATL93LA017Accident · No injuriesLimited investigationFinal reportCessna 150 · Powell, TNThe water in the aircraft fuel as a result of the improper preflight by the pilot.NTSB ATL93LA011Accident · No injuriesLimited investigationFinal reportCessna 172RG · Clarksville, TNThe fracture of the section gear in the main landing gear retraction and extension mechanism.NTSB ATL93LA002Accident · No injuriesLimited investigationFinal reportBeech E-55 · Chattanooga, TNThe failure of an unknown person to follow proper procedures/directives by operating a radio-controlled model plane in airport traffic pattern airspace.NTSB ATL92LA186Accident · No injuriesLimited investigationFinal reportCessna 150M · Nashville, TNThe student pilot's inadequate inflight planning, which resulted in fuel exhaustion. A factor was his geographical disorientation.NTSB ATL92LA182Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Jasper, TNThe fractured valve which resulted in a total loss of engine power, while flying over terrain that was not suitable for a forced landing. A factor was the densely wooded, mountainous terrain.NTSB ATL92IA169Incident · No injuriesIncident investigationFinal reportSaab-Scania 340B · Chattanooga, TNThe failure and subsequent seizure of the reduction gear box, and the failure of the propeller control unit as a result of contaminated oil supply which is shared with the gear box.NTSB MIA92LA153Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G103 · Knoxville, TNThe pilot-in-command's failure to properly instruct the passenger on aircraft controls prior to takeoff, resulting in the passenger inadvertently releasing the tow cable as the glider was being towed through 150 feet.NTSB ATL92LA110Accident · 1 fatalLimited investigationFinal reportWicks Bobcat · White House, TNThe pilot/owner's improper design change of the wing spar which resulted in the overload failure of the left wing. A factor was the pilot/owner's failure to perform a periodic inspection.NTSB ATL92LA099Accident · 1 fatalLimited investigationFinal reportCessna 150G · Samburg, TNThe pilot's poor judgement in that he attempted aerobatic maneuvers at an altitude that was too low to recover from the maneuver.NTSB ATL92FA096Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Mt. Pleasant, TNA divergence of the main rotor from its normal plane of rotation for an undetermined reason, which resulted in rotor contact to the cockpit area.NTSB ATL92LA093Accident · 1 fatalLimited investigationFinal reportSchreder RS-15 · Benton, TNThe pilot's misjudged approach to the open field, which resulted in the forced landing on the obstacle lined road.NTSB ATL92FA091Accident · 1 fatalField investigationFinal reportCessna 310R · Gatlinburg, TNThe pilot's continued VFR flight into IMC, and his failure to attain a proper altitude over high, mountainous terrain. Factors were the high terrain, and the fog, clouds, and obscuration at the accident site.NTSB ATL92LA072Accident · No injuriesLimited investigationFinal reportCessna U206G · Lafayette, TNThe pilot's inadequate preflight inspections which resulted in oil starvation and eventual failure of the engine. A factor was the rough terrain where the airplane was force landed.NTSB ATL92LA063Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Mt. Pleasant, TNThe manufacturer's failure to provide adequate torque information which resulted in the loss of torque on the cylinder hold down nuts and the complete loss of engine power.NTSB ATL92FA060Accident · 2 fatalField investigationFinal reportBritish Aerospace BAE-3101 · Alcoa, TNThe pilot's failure to use the airplane checklist which resulted in a gear up landing; and the pilot's failure to maintain flying speed which resulted in an uncontrolled collision with the ground.NTSB ATL92LA043Accident · No injuriesLimited investigationFinal reportCessna 152 · Shelbyville, TNThe improper level off by the student pilot because of misjudging the airplane's altitude above the runway. A factor was her diverted attention by an aircraft behind her in the traffic pattern.NTSB ATL92LA038Accident · No injuriesLimited investigationFinal reportBeech J-35 · Knoxville, TNThe manufacturer's failure to provide adequate torque information which resulted in the loss of torque on the cylinder hold down nuts and the complete loss of engine power.NTSB ATL92LA034Accident · 1 fatalLimited investigationFinal reportCessna 177B · Memphis, TNThe passenger's failure to follow proper procedures to walk behind the airplane. Factors were the dawn light conditions and the light rain.NTSB ATL92LA023Accident · No injuriesLimited investigationFinal reportGeorga L. Atwood Kitfox III · Trezevant, TNThe pilot's improper handling of the airplane which resulted in a noseover.NTSB ATL92LA022Accident · Serious injuriesLimited investigationFinal reportBritish Aerospace 3101 · Memphis, TNThe failure of the ramp agent to position an additional step below the last step of the airstair door and the ground; the agent failed to follow a verbal company procedure.NTSB ATL92FA019Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Darden, TNThe pilot's failure to maintain control of the airplane. The pilot exceeded the design limits of the airframe.NTSB ATL92LA015Accident · No injuriesLimited investigationFinal reportBellanca 8JCAB · Morristown, TNThe pilot's failure to maintain a proper altitude during a low pass. A factor in this accident was the pilot's overconfidence in his personal ability.NTSB ATL91LA184Accident · 1 fatalLimited investigationFinal reportFischer Wagabond · Rossville, TNThe loss of engine power as a result of carburetor icing.NTSB ATL91LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Knoxville, TNThe pilot's failure to accurately evaluate the weather conditions before attempting a takeoff and his delay in aborting the takeoff procedure. A factor was the dark night.NTSB ATL91LA175Accident · No injuriesLimited investigationFinal reportCessna 172K · Greeneville, TNThe inadequate visual lookout by the pilot of N78239, and his failure to accurately judge the distance between the two aircraft. Factors in the accident were the dark night conditions and the resulting visual perception of aircraft lighting in dark conditions.NTSB ATL91LA172Accident · Serious injuriesLimited investigationFinal reportCessna 401 · Jackson, TNThe pilot's failure to select the main fuel tanks prior to the approach, resulting in fuel starvation and engine stoppage.NTSB ATL91LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Tullahoma, TNAn engine power loss for undetermined reasons.NTSB ATL91LA156Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Camden, TNThe student pilot's delayed decision to abort the takeoff, resulting in his inability to stop the airplane in the remaining runway. Factors were the pilot's lack of total flying experience, and the high outside air temperature at the time of the accident.NTSB ATL91LA146Accident · No injuriesLimited investigationFinal reportCessna C172M · Mc Minnville, TNThe failure of the pilot to maintain cleearance from obstacles during the final approach to landing.NTSB ATL91LA135Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Springfield, TNThe PA-24 pilot's failure to maintain proper airspeed while executing a go-around, resulting in the stalling of the airplane. A factor in the accident was the PA-24 pilot's failure to visually detect the J-3 in a timely manner.NTSB ATL91LA131Accident · No injuriesLimited investigationFinal reportCessna 152 · Benton, TNA loss of engine power for undetermined reasons.NTSB ATL91LA122Accident · No injuriesLimited investigationFinal reportLearjet 23 · Columbia, TNThe pilot's premature decision to turn off the anti-skid during landing roll. Factors to this accident were hydroplaning conditions.NTSB ATL91LA121Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Lebanon, TNThe pilot's excessive touchdown speed, his failure to maintain a proper touchdown point, and his failure to execute a go-around when a safe landing could not be made. Factors in the accident were: the wet runway conditions at the airport and the crosswind…NTSB ATL91LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNStudent pilot's failure to maintain directional control during the landing roll.NTSB ATL91IA094Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Nashville, TNThe captain's failure to maintain a proper glide path after disconnection of the autopilot during the final approach. Factors in this accident were: the captain's failure to follow company procedures for category ii approaches, the first officer's failure to…NTSB ATL91LA091Accident · Serious injuriesLimited investigationFinal reportBoeing B767-287ER · Memphis, TNThe delayed inflight decision by the pilot to maneuver the aircraft away from thunderstorm activity.NTSB ATL91LA087Accident · No injuriesLimited investigationFinal reportCessna 150 · Copperhill, TNThe pilot's improper use of carburetor heat. A factor in the accident was the existing of carburetor icing conditions.NTSB ATL91FA084Accident · 2 fatalField investigationFinal reportCessna 172N · Dunlap, TNThe pilot-in-command's inadequate preflight planning/preparation, his attempted VFR flight into IFR conditions, and his subsequent failure to maintain a proper altitude. Factors in the accident were: the mountainous terrain, the foggy, low ceiling conditions…NTSB ATL91FA073Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Franklin, TNThe pilot's failure to select a proper fuel tank for flight, resulting in fuel starvation to the engine, and subsequent engine stoppage. Factors were the pilot's inadequate evaluation of the weather conditions along his route of flight, and his flight into…NTSB ATL91LA065Accident · No injuriesLimited investigationFinal reportHelio H-295 · Dunlap, TNFailure of the pilot to maintain control of the aircraft, which resulted in a ground loop/swerve. The crosswind was a related factor.NTSB ATL91LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNThe inadvertent stall of the aircraft, encountered as a result of the student pilot's inability to maintain the proper compensation for wind and the lack of total experience of the student pilot.NTSB ATL91FA054Accident · 1 fatalField investigationFinal reportCessna 172 · Crossville, TNThe improper flight planning by the noninstrument rated pilot which resulted in his inadvertent flight into instrument meteorological conditions in mountainous terrain.NTSB ATL91FA041Accident · 2 fatalField investigationFinal reportBeech K35 · Lafayette, TNPartial loss of engine for an undetermined reason. The adverse weather conditions, darkness, and radio tower were related factors.NTSB ATL91LA038Accident · Serious injuriesLimited investigationFinal reportPiper PA-23 · Bolivar, TNThe interruption of fuel to the left engine due to contamination of the left fuel tank, resulting in engine stoppage.NTSB ATL91LA028Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Humboldt, TNThe student pilot's failure to maintain directional control during landing. A factor was the student's lack of recent experience.NTSB ATL91LA027Accident · No injuriesLimited investigationFinal reportBeech 23C · Dunlap, TNThe pilot's failure to use the carburetor heat properly, which resulted in the formation of carburetor ice, followed by a complete loss of engine power. Factors to this accident were carburetor icing conditions and the rough and uneven terrain at the crash…NTSB ATL91FA025Accident · 1 fatalField investigationFinal reportCessna 150J · Ripley, TNPerforming a stall maneuver at an altitude below prescribed minimums, and his failure to apply correct flight control inputs to recover from the stall and spin.NTSB ATL91LA021Accident · No injuriesLimited investigationFinal reportCessna 150 · Arlington, TNThe student pilot's failure to maintain directional control during landing. A factor in this accident was gusty winds.