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 ATL87DLT04Accident · No injuriesFinal reportNord SV4C · Lebanon, TNThe pilot stated while on final approach he allowed the aircraft to get too low and slow. He realized it was too late to recover and the aircraft collided with a tree.NTSB ATL87LA242Accident · No injuriesLimited investigationFinal reportCessna 182 · St. Joseph, TNThe plt took off from an arpt that was aprx 27 mi west of his destn. After takeoff, he rcvd an inflt wx briefing & flew north of a line of thunderstorms (tstms). Before lndg at the destn, he noted tstm activity south of the arpt, but contd the apch & lndd.…NTSB ATL87LA231Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Knoxville, TNThe plt rprtd that drg takeoff, the acft clbd normally for about 100 to 150 ft, then the eng lost pwr w/o warning. He switched fuel tanks & tried to restart the eng, but was unable. The acft was lndd & sank in a river, short of an open fld. When the acft was…NTSB ATL87LA219Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-36A · Winchester, TNThe pilot stated he circled over the airport to check for traffic then made a turn to base. He was too near the runway and too high for a normal approach. The pilot used full flaps and decreased power; however, the aircraft began to descend rapidly. The…NTSB ATL87DLT03Accident · 1 fatalFinal reportBurkhart Grob G102-111B · Memphis, TNGlider tow rope released at about 200FT following t/o. glider made rt turn followed by stall/spiral which continued until ground impact. Tow pilot saw glider pilot's hat falling to ground just after tow rope was released by glider pilot. Glider canopy was…NTSB ATL87DLT02Accident · Minor injuriesFinal reportGulfstream-Schweizer G164B-600 · Union City, TNThe ag-acft lost power while turning, shortly after departure from a field. During the subsequent forced ldg, the acft struck a fence and nosed over. The engine was torn from the acft during the impact sequence. Post-crash examination of the acft engine by an…NTSB ATL87IA191Incident · No injuriesIncident investigationFinal reportSwearingen SA-226TC · Nashville, TNThere was hvy traffic at the Nashville metro arpt when air midwest flt 4530 (Swearingen SA-226TC, N256AM) arrived drg a morning flt. The flt crew made an ILS apch to rwy 31 as another acft (American flt 130) was on an apch to rwy 2L. The 2 rwys intersected nr…NTSB ATL87LA190Accident · No injuriesLimited investigationFinal reportCessna A188B · Dyersburg, TNDrg a spraying opn, the plt returned to land on an asphalt hiway & reload with chemicals. As he flared to lnd, the eng accelerated to aprx '2/3 throttle' with no throttle movement. He believed the throttle was in the off psn when this occurred. A nose hi…NTSB ATL87IA179Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Nashville, TNAt aprx 2211 CDT, delta flt 314 (Boeing 727, N482DA) was clrd to taxi to rwy 31 with info india. Info india indcd rwy 31WAS active. Soon thereafter, southwest flt 715 (Boeing 737, N50SW) reqd & recd taxi clnc to rwy 13 for tkof. To accommo-date incoming…NTSB ATL87FA160Accident · 1 fatalField investigationFinal reportGlobe Globe GC-1A · Pleasant View, TNUpon returning from a short local area flight the aircraft was observed as it buzzed the owners private airstrip, where the passenger waved to his family. The plt pulled up sharply and made another low pass. This pullup was straight ahead. The climb peaked…NTSB ATL87LA154Accident · No injuriesLimited investigationFinal reportCessna T210N · Murfreesboro, TNWhile climbing thru 6,000 ft, the plt heard & felt a 'thud' & then realized the eng had failed. Drg a subsequent emerg landing in a muddy corn field, the nose gear mired in soft terrain & the acft nosed over. A teardown of the eng revealed the crankshaft was…NTSB ATL87FA136Accident · 2 fatalField investigationFinal reportPiper J4A · Collierville, TNIt was reptd that the plt was taking his pax up for a LCL photographic flt at the req of the pax. Witnesses reptd that the acft remained over the apt for two or three circuits and then deptd the area in the dir of Collierville. Witnesses near the crash site…NTSB ATL87LA119Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Clarksville, TNThe pilot lost tail rotor control in cruise flight after the tail rotor drive shaft separated. The tail rotor system had sustained previous damage about 4 years prior to this accident when, while being operated as a public use aircraft, the helicopter skidded…NTSB ATL87LA125Accident · No injuriesLimited investigationFinal reportCessna 150J · Waverly, TNThe plt reported that he was taxiing to the rwy when the 'rudder failed to turn the (airplane) onto the rwy and the left brake failed.' The airplane subsequently ran off the end of the taxiway, traveled approx. 50 ft., went over a steep dropoff and collided…NTSB ATL87DLT01Accident · No injuriesFinal reportSchleicher ASK-21 · Eagleville, TNDuring a landing attempt, N174KS collided with a treeline on final approach to the airport. The instructor reported that the flight was normal until the student encountered a downdraft on final approach. The instructor took control of the controls, but was…NTSB ATL87LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Lebanon, TNThe plt reported that he made a VFR pattern for landing on rwy 18 at his destination. The wind was 'hard' and 'straight down the rwy.' He reported that, 'all of a sudden it seemed as though the wind quit and the airplane started to fall.' The acft hit hard…NTSB ATL87LA103Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Oliver Springs, TNThe plt reported that the acft encountered heavy turbulence and a strong gusty x-wind close to the ground while on short final to his private airstrip. The plt attempted a go-around and encountered 'extremely heavy turbulence' during a turning climbout…NTSB ATL87LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Shelbyville, TNThe acft was being operated from a dirt road that was reportedly only slightly wider than the acft. The plt reported that he had just completed a spraying operation and was about to put out some fertilizer. He stated that he installed the spreader, but left…NTSB ATL87LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Bolivar, TNThe student plt reported that he flared excessively during touchdown while practicing a touch & go landing, causing the airplane to balloon. The airplane subsequently touched down again and headed toward the left side of the rwy. The student plt stated that…NTSB ATL87FA087Accident · 1 fatalField investigationFinal reportCessna 150H · Oneida, TNThe pilot contacted the fss several times during the morning for weather along his proposed route of flight. Shortly after lunch he departed without a flight plan. He reported to one fss that he was VFR only but continued although VFR was not recommended for…NTSB ATL87LA075Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Hixson, TNDuring ldg roll on solo instructional flt, stu plt stated that he applied hand brakes and acft swerved to the left. Skid marks found at the site led from near the rwy centerline to a parked C-172 struck during the sequence. Subsequent inspection of the brake…NTSB ATL87FA074Accident · 2 fatalField investigationFinal reportCessna 182P · Crossville, TNThe rental acft collided with the top of a mountain at substantial airspeed in level flt. VFR flt was not recommended by fss due to low ceilings, rain and fog. No flt plan was filed. The plt had not logged a flt for a five month period prior to the accident.…NTSB ATL87LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Nashville, TNThe plt reported that he conducted an ILS appch behind mixed jet and turboprop traffic; the acft encountered an 'extreme downdraft' while on appch and the acft vertical speed went from about 500 fpm to about 1200 fpm. He attempted to recover by adding full…NTSB ATL87FA064Accident · 2 fatalField investigationFinal reportCessna 310P · Memphis, TNThe plt reported an engine problem inside the outer marker to runway 31. The acft impacted the ground in a nose low attitude. The wreckage examination failed to disclose any system malfunction or failure. The acft was destroyed by impact forces, and a post…NTSB ATL87FA051Accident · 2 fatalField investigationFinal reportBeech 35-33 · Blountville, TNDrg vectors for a ILS rwy 23 apch, the plt allowed the acft to get 400' below the assigned alt of 3700'. The controller (ctlr) queried the plt about his alt & the plt replied he had gotten a little low, but was returning to the assigned alt. After…NTSB ATL87MA035Accident · 4 fatalMajor investigationFinal reportBell 206L-1 · Jamestown, TNThe helicopter was being used in an emerg med svc/med-evac (EMS) opn. At 0230, the plt obtained a partial wx briefing. He was advised of flt prctns for IFR wx thru-out the area with low ceilings, fog, precip & mtns obscd. The flt departed nashville at 0245 &…NTSB ATL87LA024Accident · Minor injuriesLimited investigationFinal reportBeech BE-19A · Waverly, TNThe pilot reported an electrical failure, however the exact reason for the broken alternator belt was not determined. The wreckage examination disclosed that there was no fuel found in the aircraft system. There was also no fuel spillage. The pilot was not…NTSB ATL87IA020Incident · No injuriesIncident investigationFinal reportBoeing 727-227 · Livingston, TNThe braniff and united Boeing 727 jetliners were approaching 'swapp' intersection on converging jetways at their proper assigned alt of 35,000'. The controller was in the process of issuing radar vectors to assure proper lateral separation when the control…NTSB ATL87LA148Accident · 1 fatalLimited investigationFinal reportCessna 150J · Memphis, TNPrior to its discovery on may 20, 1987, this acft had last been seen on x-wind leg on climb out after a touch and go at dewitt spain arpt. Parts of the acft were recovered from the Mississippi river northwest of the arpt. The plt's remains had not been…NTSB NYC87FA023Accident · 1 fatalField investigationFinal reportCessna R172K · Rockwood, TNThe aircraft was observed departing at approx 2010 hours, reversing course and flying over the airport at 300-400 ft AGL. The aircraft crashed 3/4 miles south of the airport in unpopulated, mountainous/hilly terrain at an elevation of 1560 feet, which is 104…NTSB ATL87FA009Accident · Minor injuriesField investigationFinal reportBell 206B III · Nashville, TNThe plt was in a descent toward a building in a downtown area which he wanted aerial photographs of. At about 1700 ft AGL he reported the helicopter jerked hard and yawed to the left. He initiated an autorotation and during the descent to the selected landing…NTSB ATL87FA007Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Nashville, TNThe flight was cleared for the localizer approach to rwy 31. The pilot reported the airport in sight. The flight descended into the cloud layer and crashed about 1000 feet short of the middle marker. The pilot did not report any aircraft problem. The approach…NTSB ATL86LLT09Accident · No injuriesFinal reportBeech 35A · Nashville, TNThe student plt was practicing a soft field takeoff when directional control of the acft was lost. The acft traveled aprx 100' left of the rwy centerline where the right wing struck the ground and the acft cartwheeled. The plt reported he was advised by his…NTSB ATL86LA262Accident · No injuriesLimited investigationFinal reportAlexander AS-K13 · Tullahoma, TNDuring an automobile tow/launch, the auto experienced a loss of power before the glider reached a safe release altitude. The pilot had steered the glider off of the paved rwy and was unable to return to the rwy. The glider pilot was forced to land in high…NTSB ATL86LA246Accident · No injuriesLimited investigationFinal reportBeech 95 · Springfield, TNThe instructional flt had been in the air for about 45 min when the instructor told the plt to return to the arpt and land. Upon entering the traffic pattern the plt was told to make a touch and go landing. He completed two of these maneuvers and was…NTSB ATL86LA245Accident · No injuriesLimited investigationFinal reportCessna 150G · Smithville, TNThe plt reported the acft had 6-7 gallons of fuel at takeoff, enough for about 30 minutes of flight. He flew for aprx 1 hour and on takeoff from a touch and go landing, the eng quit due to fuel exhaustion. The plt stated he had built this acft from several…NTSB ATL86FA227Accident · No injuriesField investigationFinal reportCessna 421C · Nashville, TNDuring a normal takeoff the pilot experienced a dual engine failure about 10 feet above the runway. The pilot stated that he landed on the remaining runway and attempted an 80 degree left turn onto taxiway 'c'. The aircraft failed to negotiate the turn at the…NTSB ATL86LA183Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Memphis, TNWhile returning from an instrument training flight, the aircraft lost total power and the CFI attempted an emergency landing on a road. During the attempted landing the aircraft collided with a road sign and was substantially damaged. The pilot related that…NTSB ATL86LA164Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G103 · Benton, TNThe glider landed short of the rwy. The plt had observed another acft on the rwy apch end and extended his base leg. During the turn to final, he deployed the spoilers. He reported that the acft experienced a high sink rate after the turn, and that he…NTSB ATL86FA147Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Dickson, TNThe acft contacted electrical wires and trees shortly after takeoff. The acft then descended to impact with the terrain. Examination of the wreckage revealed the elevator trim actuator rod was extended 2.5 inches which correlates with a full nose down…NTSB ATL86IA144Incident · No injuriesIncident investigationFinal reportBoeing 727-295 · Nashville, TNThe flight experienced a fire warning light descending through 10500 feet for landing at Nashville. The aircraft landed without incident. The passengers evacuated the aircraft using evacuation slides. Examination of the aircraft disclosed that the detection…NTSB ATL86LA131Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lawrenceburg, TNThe student plt had asked a pvt plt to ride with him while he (the student) took his son in law up for a ride. When approaching the rwy for landing, the student plt allowed the acft to collide with the berm short of the rwy. The acft came to a stop on the…NTSB ATL86FA125Accident · 1 fatalField investigationFinal reportBellanca 17-31ATC · Winchester, TNThe plt made a VFR pattern at an uncontrolled arpt and noted a truck alongside the north end of the rwy. The plt did notsee any persons on the rwy. During the landing flare the plt noticed a man on the rwy near the right wingtip. A jolt was felt as the acft…NTSB ATL86LA115Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Lake City, TNWhile filming for king kong productions, a Cessna 150, flown by the production pilot collided with bowel mountain near Lake City, TN the pilot was flying low over the terrain when the aircraft failed to climb as fast as the pilot anticipated. The aircraft…NTSB ATL86LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNDuring landing roll the student pilot lost directional control of the aircraft and collided with a tree adjacent to the runway.NTSB ATL86LLT08Incident · No injuriesFinal reportPiper PA-34 · Smithville, TNThe acft ran off the departure end of the rwy during landing. The acft reportedly landed 1/2 way down the 3400 ft rwy. The plt stated in a post acc interview that he was 'too high too fast and too long.'NTSB ATL86FA097Accident · 2 fatalField investigationFinal reportRobinson R-22 · Memphis, TNA loss of control in flight for undetermined reasons.NTSB ATL86IA100Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Nasville, TNA nr midair collision occurred aprx 38 mi se of the nashville metro arpt as a Boeing 737, piedmont flt 488, was dscndg thru aprx 12,000' & a flt of 4 F-4'S, call sign peach 41, were joining. Flt 488 was inbnd to nashville on an IFR clnc & memphis ARTCC had…NTSB ATL86FLT05Accident · No injuriesFinal reportPiper PA-14 · Memphis, TNThe acft collided with an air compressor and a hangar door during taxi after the plt hand-propped the unoccupied acft. The ptl said that the thought the 'switches were off'.he was pulling the prop to 'loosen' the oil when the eng started and the acft started…NTSB ATL86LA099Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Crossville, TNOn takeoff the plt saw an oil leak around the prop hub. The acft was returned to the airport and the prop governor oil tube fitting was found to be cracked. The part was replaced and the flt was continued. The part was checked during a later refueling stop…