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 ATL86LA095Accident · No injuriesLimited investigationFinal reportCessna 150 · Lafayette, TNThe pilot stated that he had completed a touchdown and was on rollout when he noticed a deer on the runway. He increased the power enough to avoid colliding with the deer, but stalled the aircraft and collided with the runway surface failing the nose gear.…NTSB ATL86LA090Accident · Serious injuriesLimited investigationFinal reportBoeing 727-223 · Memphis, TNAmerican airlines flight 502 experienced a fire warning light illumination on no. 1 engine as the aircraft was climbing through 6000 feet. The pilot declared an emergency and returned to Memphis. Following the landing the pilot ordered a passenger emergency…NTSB ATL86FA085Accident · No injuriesField investigationFinal reportBeech BE-90 · Mount Pleasant, TNOn final approach the crew turned the aircraft cabin environmental control from the auto mode to the off position. Shortly thereafter, the cockpit and cabin began to fill with smoke. The occupant of the copilots seat felt heat around his feet. A normal…NTSB ATL86LLT07Accident · Serious injuriesFinal reportCessna 152 · Dyersburg, TNThe acft collided with trees on the edge of a 5000 ft open field during a precautionary landing after the student plt on his first solo x-country became lost & confused. He landed off arpt even though he still had about 3 hrs fuel. Wx was not threatening and…NTSB ATL86FA081Accident · 1 fatalField investigationFinal reportRobinson R22 · Greenville, TNThe flt was last seen to depart rwy 23 at the Greenville arpt & enter a low cloud layer at ngt. A witness estimated the helicopter entered the clouds at about 300 to 400 ft AGL. No flt plan was filed. The wreckage was found the next day, located about 1/4 mi…NTSB ATL86MA080Accident · 1 fatalMajor investigationFinal reportBeech G18S · Copperhill, TNThe plt was alerted at 0100 for 0200 flt fm kenosha to milwaukee, WI to pick up cargo for a flt to atlanta, GA. At 0310,the acft deptd milwaukee in VFR. En route, the plt obtained wx & an IFR clnc. Some of his rdo xmsns were not standard. At 0433, he complied…NTSB ATL86LA076Accident · Minor injuriesLimited investigationFinal reportPiper J3L-65 · Sevierville, TNDuring takeoff initial climb the engine lost power and a forced landing was initiated. During the descent the aircraft contacted treetops prior to ground impact. Post-crash examination of the engine disclosed that one of the cylinders had broken away from the…NTSB ATL86LA073Accident · No injuriesLimited investigationFinal reportCessna U206B · Columbia, TNSoon after departure the plt experienced a severe vibration throughout the acft. Eng pwr was retarded and the vibration subsided. The plt then noticed aileron control problems and noticed the left wing tip was moving up and down. An emergency landing was made…NTSB ATL86LLT06Accident · Serious injuriesFinal reportPiper PA-22 · Jasper, TNThe acft crashed into a house before striking the ground in an uncontrolled descent. The acft was approaching marion arpt for a landing when the plt lost control. The plt said that the stabilizer adjustment 'stripped'. The pilot was using the trim tab when…NTSB ATL86IA054Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Memphis, TNThe aircrew rprtd that when the landing gear was retracted after takeoff, the l main gear indicated unsafe & there was an unsafe door indication. They recycled the gear, but observed the same indications. The gear handle was then put in the neutral psn & the…NTSB ATL86FA040Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Springfield, TNThe acft collided with the ground inverted. Witnesses stated that the acft was performing loops prior to the accident. Reportedly, the plt was giving a female companion a 'joy ride'. The plt had recently received his commercial cert. Instrument rating & CFI…NTSB ATL86LA024Accident · Minor injuriesLimited investigationFinal reportGary E. Wilson Quickie · Paris, TNThe plt had completed several high speed taxi runs in the homebuilt acft prior to the attempted flt. The acft climbed to about 50-100 ft and reached a speed of apprx 65 mph. It would not accelerate nor climb any further. The plt attempted a turn back to the…NTSB ATL86LLT02Accident · No injuriesFinal reportCessna 152 · Knoxville, TNThe plt was on a personal night proficiency flt. He made 2 stop & go landings without incident. On the 3rd landing, the acft touched down about 50 to 60 ft short of the rwy on upsloping terrain & the nose gear collapsed. The plt stated that he was making a…NTSB ATL86FA020Accident · Serious injuriesField investigationFinal reportHawker Siddeley DH 125-400A · Sparta, TNTen minutes prior to landing heavy rain fell on airport. Acft mad normal touchdown,spoilers & lift dump activated.PIC delayed brake application as usual and did not get thrust levers in idle. After acft passed mid-field taxiway PIC reported brakes became…NTSB ATL86FLT03Accident · Minor injuriesFinal reportCessna 172I · Millington, TNThe acft collaped the nose lndg bear during a forced lndg after the engine failed during takeoff. During post ace eng exam the wires disconnected from the magneto switch. The wires were resting on the 'p' leads. The fastening screw found on the bottom of the…NTSB ATL86LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-201T · Chattanooga, TNThe aircraft lost total power during takeoff initial climb and attempted an forced landing in a shopping center parking lot. During the landing attempt the aircraft collided with a utility pole and slid inverted approximately 250 ft before coming to rest.…NTSB ATL86LLT01Accident · No injuriesFinal reportCessna 150 · Livingston, TNThe plt made a forced landing in rugged tree covered terrain following a loss of pwr due to fuel exhaustion while on a x-country flt. The plt decame lost near Livingston, TN, and contacted the crossville and london fss for assistance. The acft was located 5…NTSB ATL85FLT14Accident · Minor injuriesFinal reportCessna 150H · Lebanon, TNThe acft crashed during a forced lndg after a power loss during takeoff. According to reports the plt took off on a check ride with an instructor. At 150 ft AGL pwr dropped to 2000 RPM. The CFI took over and shortly thereafter the pwr dropped to 1800 RPM. In…NTSB ATL85FLT13Accident · No injuriesFinal reportPiper PA-38-112 · Springfield, TNThe acft was substantially damaged after contacting thres during a landing following a loss of pwr on takeoff. Post accident inspection revealed the carburetor valve ass'y had separated from the lever ass'y allowing the valve to seat flat against the…NTSB ATL85FA280Accident · 1 fatalField investigationFinal reportCessna 172N · Halls, TNThe private pilot had just leveled off at 2500 feet and pointed out the old naval base to his right front seat passenger when he slumped over the yoke. The passenger in the rear seat held the pilot off the controls while her non-pilot husband attempted to…NTSB ATL85LLT11Accident · No injuriesFinal reportCessna T210L · Elizabethton, TNDuring a dual instructional flt the eng stopped due to fuel starvation during a go-around. During the attempted restart, the instructor failed to switch fuel tanks. The acft touched down in a fld and ran into a wooded area which separated both wings from the…NTSB ATL85FLT10Accident · Serious injuriesFinal reportAeronca 7AC · Mcewen, TNThe plt stated the acft stalled during a turn at an alt between 200 and 300 ft AGL. Recovery was not accomplished prior to the acft impacting the terrain.NTSB ATL85LA257Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Portland, TNThe plt made a visual aprch to the wrong airport & attempted to go-around. During the go-around the acft coll ided with trees on the departure end of the rwy.NTSB ATL85LA254Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Spring City, TNThe student was on a solo cross-country training flight when the engine lost total power without warning. The plt made an emergency landing in a field and durning the landing the aircraft collided with trees and was substantially damaged. Post crash…NTSB ATL85LA247Accident · No injuriesLimited investigationFinal reportCessna 188 · Dyersburg, TNDuring the third takeoff the pilot failed to obtain and maintain flying speed and crashed in a field off the departure end of the ag strip.NTSB ATL85FLT09Accident · Serious injuriesFinal reportCessna 152 · Memphis, TNThe acft nosed over during a forced landing following a loss of pwr. Purpose of the flt was to practice night takeoffs and landings. On the fifth takeoff, at aprx 200 ft AGL, a total loss of pwr was experienced. The acft contacted an embankment during the…NTSB ATL85LA184Accident · No injuriesLimited investigationFinal reportCessna T337G · Knoxville, TNThe acft made an emergency gear up landing when both the normal and emergency extension systems failed to function properly. A mechanic was later able to extend the gear with the acft on jacks by repeatedly cycling the selector switch. It was determined that…NTSB ATL85MA177Accident · 2 fatalMajor investigationFinal reportGulfstream G-159 · Nashville, TNThe acft was being operated as general aviation flt 115 & was deptg on a routine night flt. Drg takeoff/initial climb, the left eng lost pwr. The flt crew attempted to cont the climb-out, but following the application of water-methanol, the plt lost drctnl…NTSB ATL85FA157Accident · 3 fatalField investigationFinal reportMooney M20J · Covington, TNAfter takeoff, the flt progressed normally, except one ARTCC controller had difficulty communicating with the plt during the early part of the flt. After cruising at 11,000 ft for aprx 2 hrs, the plt obtained updated wx info & requested clearance to descend…NTSB ATL85LA163Accident · No injuriesLimited investigationFinal reportCessna 182A · Dover, TNThe student plt and his pax, a private plt, flew to another arpt and made several takeoffs and landings. Then returned to the private airstrip where their flight had originated. The student plt was at the controls on this apch. After touchdown the acft became…NTSB ATL85LLT07Accident · Serious injuriesFinal reportBarnes FF-7 · Franklin, TNThe plt noticed a power line extending across the field he had selected for landing at which time air was released from the envelope for an emergency descent. As the basket touched down, the envelope drifted into the line. A passenger was seriously injuried…NTSB ATL85LA151Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Tullahoma, TNThe plt was giving a 15 yr old passenger a local area flt. While in level flt at about 200 ft AGL, the acft hit an unmarked/guyed antenna tower & crashed. The plt reported that he did not see the tower. Although the tower had been there for many years, it was…NTSB ATL85LA205Accident · No injuriesLimited investigationFinal reportMcCulloch J-2 · Union City, TNPilot with 7900 total hours and four hours in gyoplane was on solo cross country training flight. During takeoff at enroute stop rotor blades struck vertical stabilizer. Pilots instructor said witnesses reported that the gyroplane was rotated abruptly during…NTSB ATL85FLT05Accident · Minor injuriesFinal reportPiper PA-28-180 · Arlington, TNThe acft overran the rwy during landing and contacted a ditch. A left quartering tailwind was present at the time of the landing.NTSB ATL85LA139Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Elizabethton, TNPilot lost directional control during landing and skidded of the left side of runway. Pilot reported windshift.NTSB CHI85IA149Incident · Minor injuriesIncident investigationFinal reportBoeing 727-100 · Chattan00gr, TNApproximately 8 hours into his duty day, after flying for approximately 6 hours. The first officer experienced a 20 second episode of simple vaso-vaso syncope (fainting), as diagnosed by the FAA aeromedical standards division manager. This occurred as he was…NTSB ATL85LA121Accident · Minor injuriesLimited investigationFinal reportBell 47G · Erin, TNAfter a power loss at low alt. During approach to touchdown,the pilot bled off rotor RPM attempting to clear power lines across his approach path. This resulted in a lack of rotor energy necessary for an autorotaiton landing. A hard landing resulted.…NTSB ATL85LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Memphis, TNAcft bounced during lndg in 10KT x-wind. The stu plt was on his 3rd unsupvr solo. The acft went off the rwy on the rt side & collapsed the nose lndg gear. The student had 28 hrs total flt time with a logbook restriction entered by his instructor to restrict…NTSB ATL85FA109Accident · Serious injuriesField investigationFinal reportMooney M20J · Chattanooga, TNThe plt was attempting to disengage the starter pinion gear by rocking the prop up & down by hand. The eng inadvertently started & the acft rolled across the ramp at a high rate of speed & collided with two automobiles & a chain link fence before coming to…NTSB ATL85LA105Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Knoxville, TNThe plt had not flown for over 90 days & was practicing landings before flying with passengers. While climbing from a touch-&-go landing, the eng lost power at about 250 to 300 ft AGL. The plt saw only a river ahead, so he attempted to turn & land on the…NTSB ATL85FLT04Accident · No injuriesFinal reportGrumman AG-CAT-G-114 · Madisonville, TNThe acft crashed in an open pasture after loss of power following a takeoff from an adjacent pasture. The acft had expereinced a power loss a few minutes earlier which had forced the plt to make an emergengy lndg. After grnd checking the powerplant the plt…NTSB ATL85LA088Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Hartford, TNThe plt was informed during wx briefing that VFR was not recommended because of low clouds. Plt elected to takeoff and follow I-90, however, wx conditions were poor and plt executed a climb to 10000 ft to clear the cloud layer. While en route the plt tuned to…NTSB ATL85FA079Accident · 3 fatalField investigationFinal reportCessna 340 · Johnson City, TNThe acft was IFR at 17000 ft flying thru wx SIGMET area for severe icing when the plt requested a descent due to airframe ice and turbulence. During the descent the plt reported shutting down the right eng. On final apch for an off-arpt landing attempt the…NTSB ATL85FA077Accident · 4 fatalField investigationFinal reportCessna R182 · Crossville, TNThe acft collided with wooded, rising terrain at an elevation of about 2800 ft MSL on the west slope of hinch mountain. A passenger, who survived the crash, but died later due to burns, reported that light conditions were dark & she could not see anything…NTSB ATL85LA073Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Sparta, TNDual engine stoppage. Fuel tanks topped before takeoff. Plt had filed IFR en route but the wind had shifted to a 30 kt headwind. Plt became concerned about fuel remaining and made an instrument apch which was missed because of low clouds. During course to an…NTSB ATL85FA068Accident · 1 fatalField investigationFinal reportGyrocopter B-8M · Madisonville, TNStudent pilot attempting flight in Gyrocopter loss control cusing main rotor system to contact the rudder system. Pilot was not qualified to conduct this flight. A/c was not assigned an identification number.NTSB ATL85LA057Accident · No injuriesLimited investigationFinal reportCessna 182C · Johnson City, TNThe acft crashed after a loss of eng power occurred when the plt was returning from transporting sky divers to altitude for a jump. The plt reported he ran the rt fuel tank out of fuel & failed to switch tanks.NTSB ATL85LA036Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Eads, TNThe plt stated that he was taking off with full pwr. The acft accelerated to about 60 when it went over a small rise in the rwy, the left wheel assembly seperated from the acft at the pt where it attaches to the landing gear strut. The strut dug into the gnd…NTSB ATL85FLT03Accident · Serious injuriesFinal reportCessna T210N · Soddy Daisey, TNThe acft descended into trees during IFR weather after having a ttl electrical failure. The plt continued navigating by dead reckoning and not finding a break in the clouds decided to descend through the clouds. The tops of trees were struck on a ridge at the…NTSB ATL85LA024Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Lincoln, TNThe acft was making a swath run spraying crops when the engine suddenly lost power with 200 yards of level field remaining for an emergency landing. After touchdown the plt turned the acft to avoid a collision with trees. During the turn the nose of the acft…