NTSB investigations, TN
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 ATL83LA264Accident · 1 fatalLimited investigationFinal reportBensen B8M · Somerville, TNThe acft crashed during takeoff while on a pleasure flight. A witness stated that he saw the acft take off and climb outat a gradual climb to about 100 ft and then start a gradual descent to about 30 ft. at which time the acft nosed over and went almost…NTSB ATL83LA243Accident · No injuriesLimited investigationFinal reportSchleicher AS-K13 · Tullahoma, TNThe pilot stated that his approach was too fast and he bounced the acft during the landing. The glider drifted left and collided with a hayroll. The collision caused another swerve and a subsequent collision with another hayroll.NTSB ATL83LA219Accident · No injuriesLimited investigationFinal reportCessna 172M · Kingston, TNThe plt checked the wx conditions before operating on the 1020 ft grass strip. He landed on the strip at 0935 EDT, took off again about 10 min later, then returned & landed again. Aprx 1 hr & 5 min after his 1st takeoff, he started another departure with 20…NTSB ATL83FA215Accident · Serious injuriesField investigationFinal reportCessna 172N · Franklin, TNThe plt stated that aprx 45 min after takeoff, he smelled an odor like something burning,then noted a loss of power. He stated that the eng did not quit, but had lost power to about the 1000 RPM range. Also, he stated that the oil pressure dropped to about 10…NTSB ATL83LA207Accident · No injuriesLimited investigationFinal reportRand KR-2 · Dayton, TNThe acft had been airborne for over 1 hr & was descending onto base leg when the eng quit running as the plt went to add power. A forced landing was made in a grassy area near the rwy. After the acft touched down, it hit a ditch during the roll-out, then…NTSB ATL83IA197Incident · No injuriesIncident investigationFinal reportBoeing B-737-222 · Memphis, TNA malfunctioning relay resulted in overheating of an air conditioning pack causing the evacuation of the acft prior to takeoff.NTSB ATL83LA195Accident · No injuriesLimited investigationFinal reportCessna 182P · Nashville, TNThe acft nosed over during a forced landing after the engine quit during takeoff at about 150 ft AGL. After the engine stoppage the pilot said he applied carburetor heat with no effect. A landing was made in a grain field straight ahead. During the landing…NTSB ATL83LA193Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Nashville, TNThe acft collided with a powerline while on an ILS approach. The weather was VMC but scattered clouds and a dark night necessitated the instrument approach. The pilot stated that he became distracted while re-setting his directional gyro and descended below…NTSB ATL83FA174Accident · 2 fatalField investigationFinal reportPiper PA 32RT-300T · Murfreesboro, TNThe acft crashed in an open field after an in-flt fire. The fire started while the acft was cruising. No emergency callswere made and the engine which was the fire source was not shut down. A rear seat passenger said he tried to open a reardoor to let out…NTSB ATL83LA165Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Adams, TNThe acft nosed over during a forced landing after a power loss. The plt stated he made two swath runs when the acft lost power. Unable to maintain altitude, he dumped the load and prepared for a landing. The landing field was newlyplowed, wet and the acft dug…NTSB ATL83LA153Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Shelbyville, TNThe acft collided with a power line during a forced landing after power loss due to fuel exhaustion. The acft was on thefinal approach. The pilot said he would be landing short of the rwy. When asked the nature of his emergency he said 'I think I am running…NTSB ATL83FA144Accident · 1 fatalField investigationFinal reportKit Built Scorpion 133 · Centerville, TNThe rotorcraft crashed in a steeply descending turn shortly after takeoff from about 100 feet AGL. No mechanical malfunction was found during, the on-site wreckage examination which would have resulted in the abrupt steep left bank and ground impact. The…NTSB ATL83LA146Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-65 · Mountain City, TNThe acft collided with a fence during landing after groundlooping. The pilot stated that during roll-out he experienced a gust of wind on the acft right side. An effort was made by the pilot to control the acft but it left the runway in spite of his efforts…NTSB ATL83FA140Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Crossville, TNThe aircraft crashed into hinch mt at the 2700 foot level during cruise flt in IMC weather. The pilot was informed during the initial and subsequent briefings that VFR flt was not recommended for his route. The first leg of the flight from new orleans to…NTSB ATL83LA120Accident · No injuriesLimited investigationFinal reportCessna 421 · Dayton, TNThe Cessna 421 collided with trees during the landing approach while on a corporate flight. The weather was IMC at the accident site and the acft was on an IFR flight plan. The acft was substantially damaged but the pilot was not injured. The acft contacted…NTSB ATL83FA116Accident · Serious injuriesField investigationFinal reportCessna 172P · Red Bank, TNAt aprx 2200 EST, the acft departed lansing, IL on a flt to columbus, GA. A passenger stated that a refueling stop had been planned for either bowling green or nashville. However, a stop was not made. The passenger indicated that the pilots were unsure of the…NTSB ATL83LA100Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · St. Joseph, TNThe aircraft overran the end of the runway during a night landing in IMC weather. The runway was a private dirt strip. Flight purpose is not known but it is suspected it was a drug smuggling flight. The aircraft landed long on the 2400 foot strip and went off…NTSB ATL83FA099Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Lascassas, TNThe acft crashed in a field about 8 miles after a night takeoff in IMC weather. No flt plan was filed. The pilot had received several briefings. During his final briefing the possibility of icing was discussed. The takeoff time was ABOUT2030 hrs. The…NTSB ATL83LA094Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Dyersburg, TNThe helicopter crashed shortly after takeoff on a solo training flight. The weather was VMC and no flight plan was filed. The pilot was uninjured. The pilot lost directional control at liftoff and started drifting toward parked acft. He attempted to go over…NTSB ATL84LA056Accident · No injuriesLimited investigationFinal reportCessna 172N · Knoxville, TNThe acft recontacted the ground during takeoff and bounced several times before coming to rest. The propeller, nose strut and firewall were damaged. The wind was reportedly from 250 degrees at 14 KTS gusting to 26 KTS. The ATC controllers on duty said the…NTSB FTW83IA086Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Memphis, TNDuring a go-around from an ILS approach, the left wing tip was dragged. This resulted in minor damage to the leading edge slats, trailing edge flaps and outboard flap track housing on the left wing. An uneventful landing was made after the go-around. The…NTSB ATL83LA061Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Nashville, TNDuring an autorotation at about 125 ft AGL the student attempted to apply power for a recovery but noted that the oil pressure light was illuminated & the eng had quit. The CFI took the controls & executed an emergency landing. He maneuvered to avoid power…NTSB ATL83FA024Accident · No injuriesField investigationFinal reportCessna 210E · Chattanooga, TNThe eng lost power passing 4,000 ft during climbout. The plt immediately reversed course & attempted to reach lovell field. He was unable to reach the rwy & landed in a shopping center parking lot 1 mi short of the rwy. The right wing struck a signpost & the…NTSB ATL83IA018Incident · No injuriesIncident investigationFinal reportBeech B99 · Clarksville, TNAs there were no passengers on the flight, the copilot was flying the leg from the left seat. On arrival over Clarksville, the captain instructed the first officer to execute a short field landing. The approach was normal until the aircraft was flared high…NTSB ATL83FA014Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Athens, TNThe plt had not flown for a couple of years. On 10/15/82 he received dual instruction in a C-172 & on the day of the accident was checked out in the PA-28. His certificate was not valid for night flight. At 1716 the plt activated a VFR flt plan. At…NTSB ATL83FKW01Accident · 2 fatalFinal reportCessna 172P · Gallatin, TNCessna 172P, N5313K crashed into a densely wooded area during the initial portion of cross-country flight. The pilot and his wife were killed but an infant son survived. Weather was not a factor.NTSB ATL83FA003Accident · Minor injuriesField investigationFinal reportPiper PA-31-310 · Dyersburg, TNAt 30 mi north of the destination, the inboard side of the right eng cowl popped loose & began vibrating severely, the plt was concerned that the cowling would break loose & strike the vert of horiz stabilizer so he feathered the r eng. Atthis point, the arpt…NTSB ATL82FA285Accident · 2 fatalField investigationFinal reportRobinson R-22 · Nashville, TNWitnesses reported that the helicopter was in cruise flight between 100 and 500 feet AGL at a high speed when slapping and cracking sounds were heard, followed by the in-flight breakup of the helicopter. The wreckage was scattered over 700 ft with the…NTSB ATL82DA264Accident · No injuriesFinal reportPiper PA-28R · Sewanee, TNEnroute the oil pressure dropped to zero & shortly thereafter the prop seized due to oil starvation. Post exam revealed a crack in the prop governor oil line, P/N76157, at the bend about 1 inch away from the "b" nut attaching the line to the elbow fitting at…NTSB ATL82FKW09Accident · 1 fatalFinal reportGrumman AA-1 · Lafayette, TNThe acft crashed while apparently trying to land in a field drg IFR conditions after loss of a top eng cowling. The plt had just made a may day transmission that he had lost his cowling. It could not be determined whether the cowling was lost before or after…NTSB ATL82DA228Accident · No injuriesFinal reportHughes 369HS · Nashville, TNPilot lost control of the helicopter during landing. The landing was hard and the aircraft was damaged. The only pre-existing discrepancy was a "notchieness" in the cyclic trim. The pilot said cyclic trim had run away the previous day. He further stated it…NTSB ATL82FLT05Accident · Serious injuriesFinal reportVarga 2180 · Arlington, TNThe pilot made a precautionary landing during a cross country flight due to low fuel. After deciding he had enough fuel to continue, the pilot elected to takeoff. During the initial climb the engine quit. An emergency landing was made in a cotton field.NTSB ATL82DA206Accident · No injuriesFinal reportPitts S2S · Somerville, TNShortly after touchdown during a formation landing, the wingman's aircraft struck an engine stand that had been placed over a hole in the runway. The hole was located about 900 ft from the approach end and was about 2 ft long, 1 ft wide, and 1 ft deep. It was…NTSB ATL82DA203Accident · No injuriesFinal reportAmerican AA-1 · Covington, TNPrior to landing, the pilot checked his brakes to insure their integrity and noted that the left brake did not hold pressure. He elected to land on runway 01 since the hangar and ramp areas were located at the north end of the field and he didn't want to taxi…NTSB ATL82DA177Accident · Minor injuriesFinal reportPiper PA-22-150 · Hixson, TNThe pilot elected to takeoff on a dark night without runway lights. He stated that the runway lights were not available at the time since the operator was out of town. According to the pilot and other witnesses, at least part of the airport environment was…NTSB ATL82DA176Accident · No injuriesFinal reportBensen B-8M · Parsons, TNThe pilot reported that just prior to touchdown, a gust of wind yawed the gyrocopter which he attempted to control with rudder and increased propeller RPM. He stated that the power increase resulted in a sharp yaw to the left and a loss of control. The…NTSB ATL82FKW07Accident · Serious injuriesFinal reportPiper PA-28 · Hohenwald, TNOriginally, the pilot departed on a flight from olive branch, ms to lawrenceburg, TN. While en route, he became disoriented and landed at lafayette, TN. From there he proceeded to lawrenceburg via lebanon, TN. After departing lebanon, he became disoriented…NTSB ATL82DA150Accident · No injuriesFinal reportBell 47D1 · Blountville, TNThe aircraft lost power at 100 feet above ground level. An autorotation was attempted to a highway. The hard landing resulted in the main rotor severing the tail.NTSB ATL82DA142Accident · Serious injuriesFinal reportDouglas DC-9-15F · Memphis, TNBefore takeoff, the aircrew received weather data that included a forecast for a severe thunderstorm watch. While en route, the captain elected to leave the seat belt sign on for the entire flight. The flight was routine until a descent was started into the…NTSB ATL82DA129Accident · No injuriesFinal reportBeech A23-24 · Kingston, TNDuring takeoff, the engine lost power at about 300 ft AGL and the pilot ditched the plane in a lake. After the ditching, the pilot egressed from the plane and enter a fishing boat that pulled up alongside. Shortly after that, the plank sank. After the…NTSB ATL82DA125Accident · No injuriesFinal reportPiper PA-38-112 · Jonesboro, TNAfter utilizing the southwest runway for takeoff and landing the pilot noted that the limp windsock had shifted to indicate use of the northeast runway. The next takeoff was therefore made to the northeast, with an uphill gradient to the runway. After a…NTSB ATL82DA100Accident · Minor injuriesFinal reportS.N.I.A.S. AS350D Astar · Alcoa, TNWhile preparing to land, the pilot experienced a tail rotor drive failure at a speed of less than 60 knots. At that speed, he was unable to make the necessary right turn from his position to land on the runway. Instead, he climbed about 50 ft in a left turn…NTSB ATL82FLT03Accident · 1 fatalFinal reportCessna 172N · Greenfield, TNWitnesses reported that the aircraft crashed after the pilot had been making low passes for about 15 to 30 minutes. In the vicinity of a 30 ft pole, the pilot made a right turn and the aircraft struck the top of a 45 ft tree. The aircraft continued over a…NTSB ATL82DKW06Accident · No injuriesFinal reportCessna 310 · Nashville, TNThe aircraft collided with a Cessna 310, N5253J at night after both planes had been cleared to the same runway. The other pilot stated that the Beech 95-55 was taxiing without lights. Reportedly, the Cessna pilot did not see the Beech 95-55 approaching from…NTSB ATL82DA067Accident · No injuriesFinal reportPiper PA-28-181 · Murfreesboro, TNThe pilot estimated his fuel consumption to be 10 gal/hr. The actual consumption was about 12 gal/hr. Approximately 20 miles from his destination, he decided to make an enroute stop for fuel. While turning to final approach for landing, the engine quit. From…NTSB ATL82FKW05Accident · Serious injuriesFinal reportCessna 177RG · Kingston, TNDuring cruise flight a gear tooth from the aluminum idler gear in the engine oil pump failed. This locked the oil pump causing failure of the main drive gear. The aircraft landed in rough terrain with gulleys.NTSB ATL82FKW04Accident · Minor injuriesFinal reportCessna 182P · Nashville, TNAfter entering a long final approach for landing, the engine lost power. While attempting to restart the engine, the pilot noted that he had not previously turned on the carburetor heat. He was unable to start the engine and maneuvered the plane to land in a…NTSB ATL82DA048Accident · No injuriesFinal reportBeech C-23 · Nashville, TNThe accident occurred while the pilot was making a touch and go landing on his second supervised solo flight. After touchdown on his first landing, the pilot inadvertently pulled back on the control yoke while adding power and raising the flaps. The nose…NTSB ATL82FKW03Accident · Serious injuriesClosedBeech V35B · Concord, TNNTSB ATL82FKW02Accident · No injuriesClosedCessna 150 · Whitwell, TN