NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 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 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 MKC87LA108Accident · No injuriesLimited investigationFinal reportCessna 150L · Harrison, ARThe pilot said he was landing into the wind and when he was 20 feet above the runway, the wind seemed to shift to a tail wind. The airplane stalled, hit the runway hard and bounced. The pilot said he pushed the control wheel forward and the nose wheel hit the…NTSB LAX87FA212Accident · 1 fatalField investigationFinal reportRockwell 114 · Los Gatos, CADrg a preflt wx briefing, the plt was adzd the forecast for oakland (19 mi nnw of his destn) was for a 3000' broken ceiling with occasional 3000' scattered, 5000' broken & a chance of light rain showers. He filed a VFR flt plan & depd. At 1347 PDT, the plt…NTSB FTW87LA128Accident · No injuriesLimited investigationFinal reportMooney M20J · Marietta, OKThe plt attempted takeoff from the 2450 ft rwy at the mcgeehe catfish airport near Marietta, OK. The rwy was soft with a sharp rise in the direction of takeoff. The plt failed to maintain airspeed after liftoff and directional control was lost resulting in…NTSB FTW87LA125Accident · No injuriesLimited investigationFinal reportQuickie Q2 · Sherman, TXThe pilot stated that during the takeoff run the left side of the aircraft appeared to be developing more lift than the right. The right wing tip dragged, causing the aircraft to veer to the right side into the mud where it flipped inverted before stopping.…NTSB DEN87FA134Accident · Serious injuriesField investigationFinal reportPiper PA-28RT-201T · Ogden, UTAcft departed rapid city, SD, en route to elko, NV. While in cruise flt in IMC at 12,000 ft, eng lost all pwr. Acft was over mountainous terrain and ATC issued plt vectors through canyon. Acft broke out of overcast at 8000 ft MSL (about 1500 ft AGL) and 6 mi…NTSB ANC87LA072Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Soldotna, AKThe 280 hour private pilot was observed doing steeply banked turns in excess of 90 degrees, inside loops and other aerobatic maneuvers, prior to entering a spin at an estimated altitude of 1500 to 2000 feet. The airplane completed approximately 8 turns prior…NTSB SEA87LA101Accident · Minor injuriesLimited investigationFinal reportAero Commander AC-100 · Alderwood Manor, WADuring takeoff on a short 1700 foot airstrip under no wind conditions, close to gross weight, the aircraft was not able to clear trees at the departure end of the runway. The pilot recognized this and reduced power for a precautionary landing onto an adjacent…NTSB SEA87FA100Accident · 3 fatalField investigationFinal reportCessna 172 · Ritzville, WAOccupants of both acft were family members traveling in company for holiday. Takeoff was about one min apart with N44726 in trail. Due higher norm crz performance, N44726 overtook N5711A. Plt of N44726 reduced speed and established position about 1/2 mile to…NTSB NYC87LA155Accident · No injuriesLimited investigationFinal reportNorth American SNJ-2 · Farmingdale, NYThe plt was performing touch-&-go landings. On the 3rd landing, the main gear collapsed & the acft received substantial damage. No pre-acdnt part failure or malfunction was reported.NTSB NYC87LA154Accident · No injuriesLimited investigationFinal reportCessna 172 · New Haven, CTDrg a night flt from new bedford to bridgeport, the plt enctrd visibility problems & believed that fuel consumption was higher than normal. He obtained radar vectors to New Haven. After seeing the arpt, he flew over to establish the runway pattern. However,…NTSB LAX87WA216Accident · Minor injuriesForeign investigationPiper PA-30 · Mexicali, MexicoNTSB FTW87LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Port Aransas, TXThe engine lost power while on the downwind leg of the traffic pattern. The pilot made a 180 degree turn and attempted to reach the runway. Touchdown occurred about 15 feet short and the landing gear impacted a sandy embankment. The aircraft then slid to a…NTSB FTW87LA127Accident · No injuriesLimited investigationFinal reportCessna 140 · Waco, TXThe pilot stated that brakes were applied during the landing roll prior to the tailwheel making ground contact causing the aircraft to nose over and come to rest inverted. The aircraft was substantially damaged.NTSB ATL87FA147Accident · 1 fatalField investigationFinal reportHiller UH-12D (H23) · Spartanburg, SCDuring a local pleasure flight above the treetops, the passenger reported that they heard a loud 'pop' over the sound of the engine. The plt told her that they were going down and she noticed the main rotor blades began to turn slower than usual before the…NTSB NYC87LA153Accident · No injuriesLimited investigationFinal reportCessna 182 · Ellington, CTThe pilot stated that while making a standard left traffic pattern, the wind at the north end of the airport shifted from the southeast to the northwest. The acft touched down with excessive ground speed, ran off the end of the rwy and came to rest on a…NTSB NYC87DNC10Accident · 1 fatalFinal reportHuffman Quickie Q2 · Peterborough, NHAt 0939 EDT, the acft departed syracuse, NY, on a flt to nashua, NH. Subsequently, it was rprtd missing. A search was initiated, but the acft was not found until it was discovered by a hiker aprx 2 months later. The acft had crashed below a mtn top near…NTSB NYC87DHD05Accident · Minor injuriesFinal reportPiper PA-36-400 · Mullica Hill, NJThe pilot of the PA-36 was spraying chemicals on trees for control of the gypsy moth. He reported that he was unable to clear power lines and dumped his load. The aircraft settled to the ground. The FAA reported that the weight of the aircraft exceeded the…NTSB MIA87LA162Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Fernandina Bch, FLTail wheel strut was found to be over serviced causing it to be extended higher than normal. This would cause the aircraft to be harder to steer. On landing in a cross wind the pilot experienced vibration of the tail wheel followed by failure due to torsional…NTSB FTW87FA123Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Porter, OKAcft was observed in a rt bank when it experienced an inflt breakup. Both wings, vert stab and rudder, and the horz stab and trim tab separated prior to impact. Wx was dark night with scattered to broken cloud cover, but VFR. Although a wx rpt 33 NM northwest…NTSB FTW87DPA02Accident · No injuriesFinal reportMoni Motor Glider · Terrell, TXThe pilot stated the cockpit canopy opened during initial climb at about 12 feet AGL and that this disrupted the air flow sufficiently that the aircraft became uncontrollable. The aircraft settled back onto the runway with a hard touchdown and then departed…NTSB FTW87DPA01Accident · Serious injuriesFinal reportNorth American SNJ-5 · Mckinney, TXThe pilot reportedly made a normal touchdown in a calm wind condition. During the landing rollout,however, he applied excessive braking. This caused the tail wheel equipped aircraft to nose over into an inverted attitude.NTSB DEN87LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Broomfield, COThe student plt had finished practicing touch and go landings on an unsupervised solo flt. During taxi to parking, a gust of wind lifted the left wing and the acft was pushed off the taxiway to the right. The nose gear dropped off a culvert and the right main…NTSB ATL87LA146Accident · Minor injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Sparta, NCThe plt attempted a precautionary ldg at a private grass airstrip he had located, after being advised of wx at his intended destination by ATC. Just prior to touchdown, he observed a balloon at mid-field and excuted a go-around. During climbout, he lost sight…NTSB ATL87DEI04Accident · Minor injuriesFinal reportButler EAA Biplane 1 · Orrville, OHAcft lost power and was landed in a corn field. Left main gear collapsed and acft flipped onto its back. Mixture cable set screw on carburetor was found loose allowing mixture to vibrate to lean position. Earlier in the day the PIC had replaced the carburetor.NTSB MKC87LA109Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Louis, MOThe pilot stated that he departed St. Louis downtown-parks airport (cps) on a round-robin flight with planned stops at st. clair memorial airport (K39), Missouri, and richland municipal airport (M034), Missouri. The return flight to cps included another stop…NTSB MKC87LA107Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Newport, ARThe pilot stated that he was spraying a rice field in formation with another airplane when his aircraft experienced an inflight upset due to the propwash, or wake turbulence, generated by the other aircraft. The landing gear struck a rice levee and was…NTSB LAX87LA214Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · San Ardo, CADuring a pleasure cross country flight, the engine experienced a partial loss of engine power. The plt made a forced landing where prior to touchdown the acft collided with power lines then contacted the terrain in aprx three ft of water. The acft has history…NTSB LAX87FA213Accident · 4 fatalField investigationFinal reportCessna P206 · Tehachapi, CAAn USAF T-38 aircraft and a Cessna 206 aircraft collided in mid-air during visual flight operations in a military operations area. Radar data revealed that the overtaking T-38 collided with the Cessna 206 from the right. The Cessna was on a local government…NTSB FTW87LA126Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Austin, TXThe plt was unable to retract the landing gear after takeoff. The plt elected to return to the arpt and perform a precautionary landing. The touchdown was normal followed by the right main landing gear collapsing during the landing roll. The acft had…NTSB FTW87DRG02Accident · No injuriesFinal reportAir Tractor AT301 · Weslaco, TXDuring an aerial application flt the eng lost pwr and the plt made a forced lndg. Post acc disassembly of the acft eng revealed the failure of an impeller bearing which resulted in the failure of the eng.NTSB DEN87LA131Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Emerado, NDThe commercial plt was en route on a personal flt. Thirteen miles from his destination, he smelled oil fumes and the cabin filled with oil smoke. The engine oil pressure dropped to zero. The plt shut down the engine, ventilated the cabin, and declared an…NTSB ATL87LA145Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Ozark, ALThe inst plt indicated that during airwork procedures practice in the LCL area, the right wing seemed to be heavy. He indicated that he switched the fuel selector from both to right tank. After about 20-30 minutes, they returned to the airport and entered…NTSB ATL87LA140Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Huntersville, NCThe plt reported that he closed the throttle to simulate an engine failure after takeoff from rwy 06, at about 400-500 ft AGL. He subsequently made a 180 degree turn back toward the arpt to practice a simulated forced ldg, and the acft sink rate increased to…NTSB MKC87LA105Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Knobel, ARThe PIC stated that the acft was struck by a gust of wind, and he lost control. The PIC applied rt rudder towards a 1OFT ditch in an att to get over it. The acft was too heavy to fly over the ditch and the acft impacted into the ditch. A review of wx cond's…NTSB MKC87FA106Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Sioux City, IAThe PIC had telephoned the fss at huron, s.d. for enr wx to Sioux City, IA, fm Sioux falls, s.d., late the evening of may 20. The fcst indicated IFR flt cond's with intermittent trsms along the rte throughout the fcst period. The PIC dptd Sioux falls, s.d. at…NTSB MKC87DPG01Accident · 1 fatalFinal reportCessna A188B · Lake Village, ARAfter completing several spary swaths, the pilot began another turn for another spray swath. A witness stated that during this right turn, the aircraft initiated a left descending turn and crashed into nearby trees and then burned. Examination found no…NTSB LAX87DVA09Accident · No injuriesFinal reportAyres S2R-T34 · Mendota, CADuring an agricultural application flight, the aircraft struck a pole that was located 30 feet within the field boundary. The pilot stated that due to the dawn light and the way the pole blended in with the field along with a light amount of chemical on the…NTSB FTW87LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Mckinney, TXThe student plt rprtd that drg a lndg, the wind shifted from a headwind to a left crosswind. Subsequently, the acft veered off the left side of the rwy & enctrd soft mud, then the nose gear collapsed & the acft nosed over.NTSB FTW87LA121Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Olla, LAShortly after takeoff, witnesses observed the acft in a steep climb. Rprtdly, it then entered a left turn & appeared to stall. The plt stated that after about 180 deg of turn, he rolled out, nose low, leveled the wings, then a vibration started. Rprtdly, the…NTSB CHI87FA132Accident · 1 fatalField investigationFinal reportJauch Coot · Franklin Grove, ILThe plt deptd mendota, IL on a local test flt under a 40 hour time in service restriction in an experimental home built airplane. A witness stated that the airplane was circling over his farm and then turned south. He said the eng stalled and the airplane…NTSB SEA87LA099Accident · No injuriesLimited investigationFinal reportMeyer 77-1 · Bellingham, WAA gusting 90 degree crosswind was present during the takeoff. A gust raised the aircrafts left wing and the pilot over-corrected with left aileron and left rudder. The aircraft then stalled, impacting the runway in a left wing down, nose low attitude. This…NTSB SEA87FA098Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · North Las Vegas, NVA mechanic, who was not rated as a plt, took the acft without permission & elected to takeoff at ngt. A witness saw the acft dep at about 0250 PDT. Subsequently, it crashed aprx 3 mi ene of the arpt in an open undeveloped area. The time of the acdnt was not…NTSB DEN87LA128Accident · No injuriesLimited investigationFinal reportCessna 172I · Taos, NMThe private plt and his CFI rated pax were practicing touch and go landings at the local arpt. During landing a wind gust pushed the acft off the runway centerline to the right. The runway shoulder was soft, a go-around attempt was unsuccessful and the acft…NTSB DEN87FA130Accident · 3 fatalField investigationFinal reportPiper PA-31T-620II · Cody, WYN2336X was on a business flt to Cody, WY. The pilot executed a missed approach on the first attempt of the vor-a approach. A pilot who landed at Cody minutes before the accident said the visibility had decreased to 3/4 of a mi when N2336X made the first…NTSB ATL87DEI03Accident · No injuriesFinal reportBell 47G-2A · Monroeville, OHThe plt was on a normal spray run next to the edge of a field when he misjudged his clearance & the main rotor blades contacted a tree. The helicopter then crashed to the ground in a wheat field.NTSB MKC87LA112Accident · No injuriesLimited investigationFinal reportCessna 150G · Forest City, IAAfter reaching a cruise alt of 1000 ft AGL, the plt noticed a lack of oil pressure. He elected to make a precautionary landing in an unplowed soft field. The plt then reduced pwr to idle and set up for the landing. During the landing roll the acft nosed over.…NTSB MIA87FA160Accident · 1 fatalField investigationFinal reportSchweizer G-164A · Dundee, MSWhile spraying a rice field, the acft was flying across svrl small dirt banks that had been furrowed for water ctl. Drg a swath run, it struck 3 furrowed banks that were close together, flipped over as it crashed, then burned. Witnessesrprtd the eng was…NTSB LAX87DUJ05Accident · No injuriesFinal reportHiller UH-12E · Tolleson, AZThe plt stated that he landed the acft on a platform on top of a chemical tank truck. The truck was parked on a slight slope with its left side six inches lower than the right. The plt reduced power to idle and the loader began to load the helicopter with…NTSB ATL87LA143Accident · 1 fatalLimited investigationFinal reportBeech B100 · Birmingham, ALThe lineman walked into the prop arc of the operating rt engine and was fatally injured after disconnecting a ground power unit (gpu) cable from the rt engine nacelle. The lineman initially approached the nacelle from the rear, but walked forward into the…NTSB ATL87DLQ03Accident · Minor injuriesFinal reportAir & Space 18A · Paducah, KYThe gryoplane had been overhauled to new specifications and was making its first test flight. During takeoff the acft experienced a slight left yaw, and attempts to correct the yaw only increased it. The plt aborted the takeoff and the acft landed in a yawed…