Skip to content

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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

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 MIA97LA227Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Tullahoma, TNthe pilot's improper procedure by not placing the fuel selector on the tank with the most fuel, which resulted in fuel starvation, a forced landing, and impact with a tree.Aug 5, 1997 · N9236Q · Substantial damage NTSB MIA97LA223Accident · No injuriesLimited investigationFinal reportBoeing A75 · Dayton, TNThe pilot's failure to maintain directional control on landing rollout resulting in an inadvertent ground loop, and on-ground collision between the left wing and the runway. Contributing to the accident was the pilot's total lack of experience in kind of…Jul 30, 1997 · N450HP · Substantial damage NTSB ATL97LA110Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Portland, TNThe pilot's attempt to perform a short field takeoff in unsuitable terrain. A related factor was the pilot's desire to impress his co-workers.Jul 22, 1997 · N10744 · Substantial damage NTSB ATL97LA111Accident · No injuriesLimited investigationFinal reportAvid IV · Memphis, TNThe pilot's failure to maintain control of the aircraft during takeoff. A factor in the accident was the repositioning of the control stick.Jul 21, 1997 · N913R · Substantial damage NTSB ATL97LA109Accident · No injuriesLimited investigationFinal reportCessna 172M · Athens, TNthe pilot's failure to initiate a go-around. The pilot's misjudged approach was a factor.Jul 20, 1997 · N13428 · Substantial damage NTSB ATL97LA104Accident · No injuriesLimited investigationFinal reportCessna 177RG · Knoxville, TNthe pilot's inadequate preflight by failing to ensure the oil filler cap was secured during his preflight inspection, and loss of engine oil (oil exhaustion), which resulted in subsequent engine failure. A factor relating to the accident was: the lack of…Jul 16, 1997 · N52120 · Substantial damage NTSB MIA97LA210Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Woodeberry, TNin-flight collision with a fence during takeoff. Factors in this accident were the pilot's inadequate pre-flight by not calculating the total weight of the airplane, and high temperatures.Jul 13, 1997 · N7981 · Destroyed NTSB CHI97IA212Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-15 · Memphis, TNthe spoiler cable was misrouted by unknown maintenance personnel.Jul 12, 1997 · N9348 · No damage NTSB ATL97LA100Accident · No injuriesLimited investigationFinal reportBeech 55 · Murfreesboro, TNThe failure of the aircraft braking system due to low brake pressure resulting from the undetermined loss of brake fluid from the brake reservoir.Jul 10, 1997 · N45CW · Substantial damage NTSB ATL97LA094Accident · Minor injuriesLimited investigationFinal reportMaule MX-7-180C · Dyersburg, TNthe pilot's improper planning/decision and failure to insure the that airplane would remain clear of trees during the go-around. Factors relating to the accident included: the high temperature, high density altitude, and the proximity of trees.Jul 1, 1997 · N71VF · Substantial damage NTSB ATL97LA091Accident · Serious injuriesLimited investigationFinal reportBeech E50 · Tullahoma, TNimproper operation of the engine that produced internal damage, and improper servicing of the airplane by the owner/pilot mechanic that resulted in the subsequent mechanical failure of the engine crankshaft counterweight. Contributing to the accident was the…Jun 28, 1997 · N4265R · Substantial damage NTSB ATL97LA088Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402B · Ridgely, TNThe pilot's inadequate preflight planning in that he failed to account for the high temperature and high density altitude, which resulted in an aerodynamic stall and loss of control. Factors were the tall crops and the ditch.Jun 23, 1997 · N6128W · Substantial damage NTSB ATL97LA078Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Sparta, TNA fire in the left engine started by a leak in the fuel pump.May 20, 1997 · N4105Q · Substantial damage NTSB MIA97TA139Accident · No injuriesFinal reportBell 204-B · Calderwood, TNThe inadequate maintenance inspection of the helicopter resulting in loss of lubrication from the main drive shaft going undetected until failure of the drive shaft.Apr 16, 1997 · N4580Y · Destroyed NTSB MIA97LA127Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Tullahoma, TNFuel exhaustion for undetermined reasons and unsuitable terrain encountered during the forced landing. Contributing to the accident was the failure of the pilot to divert to an alternate airport while en route after recognizing that the fuel consumed was…Apr 10, 1997 · N2515G · Substantial damage NTSB MIA97LA125Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC10-30F · Memphis, TNA stall buffet or a high speed buffet event which occurred at an undetermined time.Apr 9, 1997 · N310FE · Substantial damage NTSB MIA97LA101Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Benton, TNThe failure of the pilot to maintain altitude and clearance from the trees on a ridge line.Mar 20, 1997 · N33WP · Substantial damage NTSB ATL97LA050Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Memphis, TNfailure of maintenance personnel to properly inspect (and repair) the brake assembly, which allowed a subsequent brake fluid leak and eventual fire.Mar 16, 1997 · N1102N · Substantial damage NTSB MIA97LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Nashville, TNimproper planning/decision by the pilot, by failing to ensure there was sufficient fuel to reach a suitable landing area, which resulted in fuel exhaustion, loss of engine power, a forced landing, and collision with a tree. The faulty fuel indication was a…Mar 15, 1997 · N2505Q · Substantial damage NTSB MIA97LA090Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Jackson, TNThe pilot's failure to maintain an adequate visual lookout while taxing. The reduced visibility was a factor.Mar 1, 1997 · N98991 · Substantial damage NTSB ATL97LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lebanon, TNThe pilot's improper short, soft field takeof. A factor was the pilot's poor in-flight decision to operate over an overcast until near the airplane's maximum endurance.Jan 9, 1997 · N1434X · Substantial damage NTSB MIA97LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · Knoxville, TNthe student pilot's improper planning/decision, and his failure to maintain proper runway alignment during a crosswind landing. The strong crosswind was a related factor.Dec 8, 1996 · N714LF · Substantial damage NTSB MIA97LA028Accident · 1 fatalLimited investigationFinal reportNorth American T28B · Somerville, TNthe pilot misjudged his altitude/clearance above trees on terrain that was higher than the surrounding terrain, while performing an aerobatic maneuver.Nov 23, 1996 · N3178U · Destroyed NTSB ATL97LA013Accident · Serious injuriesLimited investigationFinal reportLet L-13 · Benton, TNfailure of the flight crew to maintain altitude/clearance above runway obstacles, and inadequate supervision by the flight instructor. Factors relating to the accident were sunglare on the canopy, and the proximity of obstacles (trees) to the runway.Oct 30, 1996 · N15CB · Substantial damage NTSB MIA97FA014Accident · 1 fatalField investigationFinal reportBellanca 14-13-2 · Smithville, TNloss of engine power for undetermined reason(s), shortly after takeoff; and failure of the pilot to maintain adequate airspeed, while turning in an attempt to maneuver back to the airport, which resulted in an inadvertent stall and uncontrolled descent into…Oct 27, 1996 · N74306 · Destroyed NTSB MIA97LA006Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Lexington, TNfailure of the pilot to abort the takeoff after encountering excessive ground roll, and failure (or inability) of the pilot to obtain/maintain adequate airspeed, which resulted in an inadvertent stall. Factors relating to the accident were: restricted…Oct 19, 1996 · N7102F · Substantial damage NTSB MIA96LA220Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Chattanooga, TNclear air turbulence, which was encountered during cruise flight and resulted in injuries to passengers.Aug 29, 1996 · N392US · Minor damage NTSB ATL96LA118Accident · No injuriesLimited investigationFinal reportCessna 172N · Nashville, TNinadequate annual inspection by other maintenance personnel and inadequate pre-flight inspection by the pilot.Aug 9, 1996 · N5291E · Substantial damage NTSB ATL96LA115Accident · No injuriesLimited investigationFinal reportCessna 182 · Smithville, TNRestricted selector valve flow that resulted in fuel starvation. A factor was the automotive fuel that adversely affected an O-ring seal in the fuel selector valve.Aug 3, 1996 · N8584T · Substantial damage NTSB ATL96LA112Accident · No injuriesLimited investigationFinal reportCessna 180 · Memphis, TNInadequate annual inspection that resulted in the in-flight loss of the fuel system strainer and subsequent fuel starvation. A factor was the lack of suitable terrain for a forced landing.Jul 22, 1996 · N3122C · Substantial damage NTSB MIA96LA182Accident · Serious injuriesLimited investigationFinal reportTocholke 1300-Z MAX · Lascassas, TNfailure of the pilot to maintain adequate airspeed, while maneuvering (turning) after takeoff, which resulted in an inadvertent stall at too low of an altitude to allow recovery.Jul 12, 1996 · N398MT · Destroyed NTSB MIA96LA180Accident · Serious injuriesLimited investigationFinal reportBell 206B · Pigeon Forge, TNfatigue failure of the engine PC line, induced by damage from improper installation, which resulted in a loss of engine power and an autorotative landing to unsuitable terrain.Jul 11, 1996 · N999TV · Substantial damage NTSB ATL96FA101Accident · Serious injuriesField investigationFinal reportBoeing 737-200 · Nashville, TNthe captain's improper rejected takeoff, in that the takeoff was rejected after V1, and the flight attendants' improper use of the evacuation procedure, in that an evacuation was independently initiated without the captain's approval, and without assessing…Jul 8, 1996 · N53SW · Minor damage NTSB MIA96LA173Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Knoxville, TNFatigue failure of the blade No. 1 hub arm of the left propeller.Jul 2, 1996 · N3061P · Substantial damage NTSB ATL96LA097Accident · No injuriesLimited investigationFinal reportCessna 140 · Jacksboro, TNloss of engine power for undetermined reason(s), which resutled in a forced landing and subsequent in-flight collision with trees and the terrain.Jun 29, 1996 · N72438 · Substantial damage NTSB ATL96FA094Accident · 1 fatalField investigationFinal reportCessna 172N · Arlington, TNThe pilot's failure to maintain clearance above the trees. A factor was the dark night.Jun 14, 1996 · N73941 · Substantial damage NTSB ATL96LA085Accident · Minor injuriesLimited investigationFinal reportMerle Musson Cozy · Covington, TNThe clogged fuel strainer that resulted in an engine stoppage. A factor was the lack of a suitable landing site.May 7, 1996 · N86LM · Substantial damage NTSB ATL96LA081Accident · No injuriesLimited investigationFinal reportCessna 210 · Knoxville, TNThe pilot's failure to heed known operating information by not correcting the flight attitude to prevent fuel unporting during a prolonged slipped descent.Apr 27, 1996 · N9432T · Substantial damage NTSB ATL96LA082Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Mckenzie, TNThe pilot's improper use of the flight control during a crosswind landing that resulted in a loss of control of the airplane.Apr 26, 1996 · N4090X · Substantial damage NTSB MIA96LA119Accident · Minor injuriesLimited investigationFinal reportAeronca 7BCM · Portland, TNDelay by the pilot-in-command to perform a go-around after the airplane bounced three times during the landing attempt. Contributing to the accident was the failure of the pilot to obtain a preflight weather briefing and his poor in-flight planning decision…Apr 16, 1996 · N2908E · Substantial damage NTSB ATL96LA079Accident · No injuriesLimited investigationFinal reportCessna 172K · Lebanon, TNthe student pilot's failure to maintain directional control during landing.Apr 10, 1996 · N7479G · Substantial damage NTSB MIA96LA107Accident · No injuriesLimited investigationFinal reportBoeing 727-225 · Memphis, TNfailure of the flightcrew to maintain clearance from construction equipment while taxiing after landing. Factors relating to the accident were: failure of operator personnel to supply the flightcrew with current NOTAM information, failure of ATC personnel to…Mar 27, 1996 · N468FE · Substantial damage NTSB ATL96LA069Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Nashville, TNthe failure of the pilot of the Piper PA-28, N26046, to visually clear the intended taxi course.Mar 23, 1996 · N26046 · 2 aircraft · Substantial damage NTSB ATL96LA067Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Kingston, TNThe pilot's inadequate pre-flight inspection, which resulted in fuel exhaustion. A factor relating to the accident was: the lack of suitable terrain for the forced landing.Mar 17, 1996 · N78896 · Substantial damage NTSB ATL96LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Columbia, TNthe student pilot's improper recovery from a bounced landing and his failure to maintain directional control. A factor was the improper level-off.Mar 10, 1996 · N32421 · Substantial damage NTSB ATL96LA058Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Livingston, TNFailure of the pilot to see-and-avoid obstructions (electrical lines), while on final approach to land after encountering icing conditions and diverting to a new destination (alternate airport).Mar 7, 1996 · N7913P · Substantial damage NTSB ATL96LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Arlington, TNthe failure of the pilot of the Cessna 150, N63434, to see and avoid the Cessna 152, N151FC.Feb 24, 1996 · N151FC · 2 aircraft · Substantial damage NTSB ATL96LA045Accident · No injuriesLimited investigationFinal reportPiper PA-32-RT-300 · Blountville, TNInadequate maintenance, and subsequent in-flight separation of the cowling, due to worn cowling components.Feb 7, 1996 · N2200J · Substantial damage NTSB ATL96LA044Accident · Minor injuriesLimited investigationFinal reportBeech C-45G · Blountville, TNthe pilot's improper use of carburetor heat which resulted in a continuing loss of engine power, and the right landing gear's failure to extend during a single engine approach. A factor was the insufficient time available to extend the landing gear via the…Feb 2, 1996 · N204AA · Substantial damage NTSB ATL96FA043Accident · No injuriesField investigationFinal reportDouglas DC-9-32 · Nashville, TNthe failure of the right main landing gear shock strut cylinder due to preexisting fractures. Contributing to the accident was: the failure of the operator to inspect the shock strut cylinder for fractures following a previous failure of the torque links, and…Feb 1, 1996 · N903VJ · Substantial damage