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 ATL85FLT01Accident · 2 fatalFinal reportMitchell Ronald A Skybolt · Athens, TNThe acft collided with the ground inverted with the rt wing and nose hitting first. Witnesses said that the acft appeared to be doing aerobatics and entered a flat inverted spin. The plt/owner in the back seat held an ATP certificateand reportedly had over…NTSB ATL84FLT15Accident · No injuriesFinal reportPiper PA-28-181 · Jackson, TNDuring a go-around, the engine lost all power. The pilot was able to land on the rwy. The acft went off the end of the rwy, went through a ditch, struck a fence and came to rest on an adjacent road. Examination disclosed no fuel in the left tank. The right…NTSB ATL84FA286Accident · 1 fatalField investigationFinal reportPiper 602P · Dayton, TNOn arrival at destination, plt found airport obscured by fog, reported by UNICOM as 1 mi visibility. Plt circled to await improvement. 15 min later, visibility improved to 1-1/2 mi. Acft observed briefly through breaks, then heard manuvering to north and seen…NTSB ATL84FA277Accident · Serious injuriesField investigationFinal reportBell 222 · Knoxville, TNThe helicopter was in a hover when a rt pedal turn was initiated and a climb attempted. Plt stated, 'I was unable to climb, and the aircraft began to lose rotor RPM. I increased power to 100% mrtq. The acft was settling.' Unable to sustain flt, a landing was…NTSB ATL84FLT13Accident · Serious injuriesFinal reportPiper PA-22 · Nashville, TNThe engine quit on final apch to the arpt as a result of fuel starvation. Sixteen gallons of fuel remained in the right fuel tank, but the left tank was selected. No fuel was found in the left tank. The acft collided with powerlines during the forced landing…NTSB ATL84LA256Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Adams, TNAfter completing a spray run the plt climbed to 75 ft AGL to fly aprx 2 miles to the next field. The elevation of the destination field was higher than the last one sprayed; no estimate of elevation change was provided. While attempting to climb over a hill…NTSB ATL84IA255Incident · Minor injuriesIncident investigationFinal reportSwearingen SA226TC · Memphis, TNDuring level off at 16,000 ft with a sea level cabin pressure (6 PSI differential pressure), the crew heard a 'pop', then the coplt's window blew out. Debris, including the glareshield, exited the cockpit & injured the copilot. The window was a single…NTSB ATL84LA253Accident · No injuriesLimited investigationFinal reportCessna 152 II · Clarksville, TNThe 13 hour student pilot was on her first supervised solo flight. The wind was reported calm and the student pilot had made two touch and go's. on the third, she added full power for takeoff and the aircraft veered left. She attempted to correct by using the…NTSB ATL84FA251Accident · 3 fatalField investigationFinal reportDouglas DC3C-S1C3G · Memphis, TNMoments after the DC-3 took off, the twr ctlr noted the l eng was torching & asked the flt if it was 'having a problem.'the crew replied 'affirmative,' then the ctlr clrd the flt to lnd on any rwy. The acft began turning left at the end of the rwy & contd…NTSB ATL84LA254Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Nashville, TNThe pilot reportedly set up a high rate of descent on final approach so that he could land the aircraft near the approach end of the rwy to avoid excessive braking on the wet rwy. The pilot descended the aircraft below the glide slope provided by the VASI and…NTSB ATL84LA257Accident · No injuriesLimited investigationFinal reportCessna 177RG · Shelbyville, TNThe acft collided with a parked truck on a taxiway en route to takeoff. The plt said he observed the parked truck on thetaxiway. There was another taxiway available but the plt continued on the congested one with the acft wing overlapping the truck by about 7…NTSB ATL84IA246Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-30 · Nashville, TNDuring the climb-out, a 15% decrease in the right eng epr was noted by the flt crew. This was followed by a loud bang & failure of the #2 eng. The #2 eng was shut down & the acft was flown back to the departure arpt. An initial exam revealed that the right…NTSB ATL85FA039Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Petros, TNThe flt departed ft. lauderdale, FL, on 8-2-84 at aprx 0815 EDT for cincinnati, OH. The acft wreckage was found on 11-17-84 on an up slope of big fodder stack mountain. The acft had contacted a 25 ft tall tree located 200 ft west of the main wreckage. The…NTSB ATL84LA233Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Morrison, TNThe plt was giving free rides to his friends. He was attempting to land on rwy 27 when the 'aircraft lost lift at 15 feet above the rwy.' The acft dropped to the rwy in a three point attitude, the plt added power to regain control. The left wing tip and the…NTSB ATL84LA231Accident · No injuriesLimited investigationFinal reportBeech C23 · Gainesboro, TNThe acft collided with a static wire while flying along a river. The collision occurred at 350 ft AGL about 5 miles NE of the arpt. The left wing hit the wire which cut into the wing and penetrated a fuel cell. Fuel escaped from this cell and when the acft…NTSB ATL84FA218Accident · Serious injuriesField investigationFinal reportHughes 369D · Franklin, TNThe acft landed hard & rolled over during an emergency autorotation lndg after the acft eng experienced a flame-out. Theacft had experienced a low fuel warning light earlier in the flt and the plt had made a precautionary lndg after which he and the passenger…NTSB ATL84FU006Accident · 1 fatalFinal reportRitz A · Tullahoma, TNThe ultralight had been flown for 4 ftls and the plt upon landing mentioned a possible control problem with the owner and builder. The builder then took the vehicle up to show how fast it would go. After about 30 minutes of flt he dove atthe rwy in a full…NTSB ATL84LA209Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Williamsport, TNPilot stated that while departing from a small 2000 foot long private strip the engine appeared to loose power. The aircraft would not climb and collided with a tree at the departure ens of the rwy. The acft then collided with several other trees prior to…NTSB ATL84FLT10Accident · No injuriesFinal reportNorth American T-28 · Loudon, TNThe plt reported that he heard a loud bang in the acft eng & it lost pwr & started emmitting smoke. During a forced landing, the acft went thru 4 fences & hit a ditch, and the nose gear collapsed. A fire, which started in flt, destroyed the cockpit after the…NTSB ATL84FLT09Accident · Minor injuriesFinal reportCessna 177B · Henning, TNThe acft made a forced landing after a power loss. During a post accident exam, no usable fuel was found in the acft. The plt had landed twice en route for fuel, but was not successful in obtaining a sufficient quantity to complete the flt. He elected to…NTSB ATL84LA290Accident · 1 fatalLimited investigationFinal reportGlobe GC-1B · Rockwood, TNThe acft crashed in an area of rising terrain at about the 1800 ft level. About 1 mile away the ridge line rose to an elevation of 2500 ft. when the acft was observed overflying the Rockwood arpt aprx 3 miles from the accident site the ceiling was about 1200…NTSB ATL84LA170Accident · 1 fatalLimited investigationFinal reportCessna 172N · Nashville, TNThe plt reported that after he & his passengers were aboard the acft, the eng was running & ground control had cleared him to taxi when he discovered that the left main wheel was still chocked, preventing forward movement of the acft. He was setting his…NTSB ATL84LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Smyrna, TNThe CFI simulated an engine failure on the right engine during takeoff after having simulated a left engine failure during the landing approach. The left engine failure was simulated with the left throttle retarded during the approach and landing. After the…NTSB ATL84FA151Accident · 5 fatalField investigationFinal reportPiper PA-32-260 · Maynardville, TNThe acft crashed in an uncontrolled state after the airframe failed in flt. Witnesses observed the acft spinning out of the clouds with parts of the airframe separating as it descended. The weather had been described to the plt in 2 wx briefings. At the time…NTSB ATL84FLT07Accident · No injuriesFinal reportWeatherly 201C · South Fulton, TNFive miles after takeoff the acft engine began sputtering and losing power. The plt dumped his load and still could not maintain flight. The acft could not be stopped before colliding with fence and trees during a downwind landing on wet pasture grass.…NTSB ATL84FLT06Accident · Serious injuriesFinal reportCessna 182 · Maryville, TNThe acft crashed during a forced landing after running out of fuel. The plt said he did not visually check the fuel prior to takeoff. After the accident the acft contained 2 gallons in each tank and had about an ounce of fuel in the carburetor which normally…NTSB ATL84LA110Accident · No injuriesLimited investigationFinal reportCessna 337B · Athens, TNThe acft caught fire during landing when a gasoline can overturned and was ignited by a passenger trying to right it with a burning cigar in his hand.NTSB ATL84FLT04Accident · Serious injuriesFinal reportAero Commander 680F · Charleston, TNThe acft crashed during a ferry flight and the plt could not recall the circumstances of the flight. Investigation revealed that the acft had been parked on the service ramp for nearly two years without being used. The last annual inspection was recorded on…NTSB ATL84FLT02Accident · Serious injuriesFinal reportPiper PA-22-150 · Memphis, TNThe acft struck a powerline and crashed 1.5 mi south of Memphis airport while on a ILS localizer app to rwy 36R. The wx at the time of acc was ceiling 200 ft, visibility 3/4 mile with fog. The acft was equipped with a VOR localizer, but no glide sloop…NTSB ATL84FA064Accident · 1 fatalField investigationFinal reportPiper PA-24-260B · Mcdonald, TNThe plt received 2 wx briefings before takeoff & was provided flt precautions of IMC to continue beyond 0900 EST. Also, he was advised that the mountains would be occasionally obscured & icing could be expected to the west below 6000 ft. during both…NTSB ATL84MA063Accident · 4 fatalMajor investigationFinal reportPiper PA-34-200T · Lawrenceburg, TNDuring the descent at Lawrenceburg the acft went into clouds at 3500 ft. at 1709 the acft was cleared for an NDB approach. Minimum alt for the approach is 1560 ft. field elevation is 936 ft. the acft was being tracked on radar and the last contact was about…NTSB ATL84MA052Accident · 4 fatalMajor investigationFinal reportBeech 58TC · Knoxville, TNDuring arrival, the plt checked in with Knoxville apch control & stated that he was proceeding to the downtown arpt for landing. At that time, the wx at mcghee-tyson arpt (aprx 10 mi ssw) was clear with 7 mi visibility. About 10 min later, the plt reported…NTSB ATL84FA054Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Lexington, TNThe acft collided with the ground in a vertical descent during IMC weather on a x-country flt. The plt had filed an IFR flt plan but he was a student with limited experience and was not instrument rated. Also he was carrying a passenger. The controller who…NTSB ATL84FA031Accident · Minor injuriesField investigationFinal reportEmbraer EMB110-P1 · Blountville, TNThe acft was landed with the landing gear up. Post accident tests of the landing gear extension system showed that all operations were normal except for the main gear down-lock indications. When the crew lowered the gear for landing the nose gear and right…NTSB ATL84FLT01Accident · Serious injuriesFinal reportCessna 152 · Clifton, TNAccording to the plt, he was descending from 8500 ft to 2500 ft when the eng quit without warning at aprx 4500 ft. he stated that he made a 'mayday' call & attempted to make an emergency landing in a field. However, the acft hit some trees at the edge of the…NTSB ATL84FA028Accident · 2 fatalField investigationFinal reportCessna TU206G · Brentwood, TNThe acft crashed while the plts were attempting an ILS approach to nashville. One plt was not instrument rated. The other was rated but was limited in experience. The instructions for radar vectoring to the approach were not followed and disorientation with…NTSB ATL84LA027Accident · Minor injuriesLimited investigationFinal reportPiper J5A · Arlington, TNAccording to both occupants, the eng lost power during takeoff at night. Subsequently, the acft was damaged when it hit a fence & metal pole during an emergency landing. No preimpact part failure or malfunction was found. The rear seat occupant, a female plt,…NTSB ATL84FA026Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Lake Hills, TNWhile en route, the acft's radio transmitter became inop; however, the plt could receive transmissions & was provided vectors toward the destination arpt. After starting a descent near the destination, the eng lost power. Subsequently, the acft was ditched in…NTSB ATL84FA017Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Knoxville, TNAcft stalled during a steep climbing turn after takeoff.NTSB ATL84LA003Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Sewanee, TNThe acft collided with trees during landing roll. The plt has recounted several variations of the accident from locked brakes (parking) to a flat left tire with full right rudder to maintain directional control. There was a left tire skid mark from touchdown…NTSB ATL83LA383Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Apison, TNThe acft collided with trees and crashed during takeoff from a short grass strip in a downwind direction. The wind velocity was 9 KTS. The strip was 2300 ft long with 75 ft trees at the end. Under the existing conditions the takeoff could not be accomplished…NTSB ATL83FA365Accident · 2 fatalField investigationFinal reportNorth American SNJ · Millington, TNTh plt was giving free rides to spectators at an air show. The acft was observed making what appeared to be a loop which was initiated at a low altitude. As the acft reached the top of the loop, it was estimated to be 1,000 to 1,200 ft AGL. The nose then…NTSB ATL83LA321Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Jamestown, TNThe acft crashed in trees during a forced landing after takeoff. The pilot said that during climbout the engine failed to develop full power. The pilot reported that the carburetor heat control was in the cold position. The pilot elected to land straight…NTSB ATL83LA318Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Kenton, TNThe pilot stated that while flying low and slow to observe crops, the aircraft stalled during a turn. The nose was lowered which placed the acft on a heading for a large oak tree. A turn was attempted to avoid the tree; the acft stalled again, struck tree…NTSB ATL83FA312Accident · No injuriesField investigationFinal reportSikorsky S-58D · Gatlingurg, TNThe helicopter collided with terrain on a wooded mountainside after liftoff. The plt said a power loss occurred after itwas to late to abort. Takeoff was made from a lot that was 5200 ft MSL. The plt hover-checked at 2500 RPM and 39.5 inches of manifold…NTSB ATL83LKW02Accident · Serious injuriesFinal reportCessna 152 · Nashville, TNThe acft propeller struck a deplaned female passenger as she proceeded to the front of the acft prior to engine shutdown. The plt stated that his attention was primarily on the fact that the idle RPM seemed high to him and he failed to note his passenger exit…NTSB ATL83LA294Accident · Minor injuriesLimited investigationFinal reportBell 206B · Nr Gatlinburg, TNThe plt reported that he was beginning his apch to a landing site at an elevation of 5200 ft when he felt a bump in the tail rotor pedals. The helicopter begun to spin to the right & the plt found he has no tail rotor control. An autorotative landing was made…NTSB ATL83LA280Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Viola, TNThe acft was damaged in a collision with farm equipment during an emergency landing on a grass strip. The student pilot had received a weather briefing by telephone but had inadvertantly encountered a rain shower. Because of the rain the student elected to…NTSB DCA83AA032Accident · Minor injuriesFinal reportGrumman G-159 · Blountville, TNThe coplt stated that when he began the apch to the destination arpt, the weather condition was hazy & he delayed his descent slightly until he located the arpt. When he saw the rwy, he believed that they were a little too close, so he indicated to the…NTSB ATL83LA265Accident · No injuriesLimited investigationFinal reportCessna 152 · Chattanooga, TNThe acft was damaged in an off airport forced landing during a cross-country after the engine failed from fuel exhaustion. The student pilot had departed for the cross-coutry with 24.5 usable gallons on board. He departed at 1240 hrs EDT and at 1620 he made a…