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 ANC84FAMS3Accident · 1 fatalMissing aircraftFinal reportCessna U206G · AKPlt received 2 wx briefings before the one hour fourty five minute flt. Plt was advised of adverse wx conditions in mountains with high winds and frequent low visibility. Icing conditions were also forecast btw 9,000 and 13,000 ft. the acft is still missing…NTSB CHI84LA401Accident · No injuriesLimited investigationFinal reportBell 47G-3B1 · Miss.Pal.St.Pk, ILThe helicopter experienced a total loss of power aprx 2 minutes after takeoff. The plt performed an autorotation into trees as no suitable landing area was available. The 2 passengers on board stated the plt did not visually check the fuel quantity before…NTSB BFO84FA008Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Bayse, VAAccording to witnesses, the acft became airborne after rolling only about 1500 ft. it was described a being 'behind the power curve' for a considerable distance before climbing abruptly. The acft then banked steeply to the left & collided with a ridge at aprx…NTSB ATL84LA294Accident · No injuriesLimited investigationFinal reportHughes 269B · Saluda, SCThe acft crashed during an attempted practice autorotation after power was applied to effect a recovery. The CFI, on theflt, stated that he noticed that the student was going to overshoot and instructed him to make a power recovery at 100 ft AGL. He said that…NTSB ANC84LA188Accident · No injuriesLimited investigationFinal reportMaule M-4 · King Salmon, AKThe plt stated that after he lifted the tail off the rwy the acft encountered a gust of wind and he lost control swerving into a ditch adjacent to the rwy.NTSB NYC84LA320Accident · No injuriesLimited investigationFinal reportAerospatiale SA-360C · New York, NYDuring approach to heliport, the plt heard two loud 'pops' from the engine. The plt activated the emergency floats and continued the approach. The plt stated that the 'popping', recognized as a compressor stall started again on final. He lowered the…NTSB NYC84FA319Accident · Serious injuriesField investigationFinal reportSikorsky S-76A · Unionville, PAOn approach, acft yawed right. Plt reduced power and executed emerg lndg. Before shutdown, it was noted the t/r was stationary while the main rotor continued to turn. Investigation revealed t/r drive shaft had separted due to thermal/mechanical damage…NTSB MKC84LA283Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Slater, MOPlt quickly pulled excessive collective while attempting takeoff from a hover. Rotor RPM decreased and the acft touched down hard on the right skid. A post accident engine run revealed no discrepancies.NTSB MKC84LA282Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Breckenridge, MOOn a VFR x-country flt the acft experienced an eng failure and the plt executed a night emergency landing into a soy bean field. Investigation revealed that a counterweight pin came out of the crankshaft counterweight due to a failure of a lock ring resulting…NTSB LAX84LA497Accident · No injuriesLimited investigationFinal reportChampion 7FC · Merced, CADuring takeoff the plt lost control of the acft. It veered off the rwy & collided with a dirt bank. The plt indicated that his wife may have unknowingly been applying pressure to the heel brakes during the attempted takeoff.NTSB LAX84LA492Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-36 · Marana, AZThe plt delayed his descent/approach to his destination due to wx. He was unable to reach his destination because of downdrafts encountered in the descent. During the approach (off airport) the right wing tip contacted the ground resulting in a collision with…NTSB LAX84LA491Accident · No injuriesLimited investigationFinal reportRyan-Navion NAV-4-1908 · Milpitas, CAThe acft made a forced landing immediately after takeoff when the engine quit at about 220 ft AGL. The acft was landed in a garbage dump. Post accident investigation revealed no discrepancies in the acft to account for the engine stoppage. The reported…NTSB LAX84LA490Accident · No injuriesLimited investigationFinal reportCessna 411 · Dolan Springs, AZAfter lndg, the plt was taxiing back up the rwy to a parking area when the nose wheel 'fell into' a sand filled depression in the surface, collapsing the nose gear. County maintenance personnel had graded the rwy surface after heavy rains but no compaction…NTSB FTW84LA406Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Sand Springs, OKAcft was on final apch to land on return leg of x-country when eng began running rough and subsequently quit. Acft contacted trees short of the rwy. Plt stated a ttl of 5 gallons of fuel were drained from both fuel tanks collectively after the accident.…NTSB FTW84LA405Accident · No injuriesLimited investigationFinal reportCessna 152 · Ponder, TXPlt acknowledged initiation of flight into low ceiling and visibility conditions with no wx briefing. Shortly after takeoff, conditions deteriorated even more and acft entered thick fog. Breaking out momentarily, plt elected a precautionary lndg on a road.…NTSB FTW84FU009Accident · 2 fatalFinal reportMitchell T-10R263 · Mckinney, TXAccording to a person who helped assemble the ultralight vehicle for flt, the base of the clouds were at about 200 ft AGL, when the plt took off. The helper expected the plt to return & land due to the wx; however, the vehicle crashed in a wooded area. There…NTSB FTW84FA404Accident · 2 fatalField investigationFinal reportCessna T210M · Colleyville, TXPlt and wife had flown to dallas (addison arpt) and spent evening with friends. Return flt initiated after midnight intolow clng and drizzle, about 12 mins later, wife contacted dallas (love fld) twr on emerg freq 121.5 and reported plt was sick and unable to…NTSB DEN84LA306Accident · No injuriesLimited investigationFinal reportCessna 182 · Salt Lake City, UTAccording to the plt the southerly wind was gusting to an unknown intensity and wind shear was encountered during landing. Ground contact occurred in a nose down attitude on the nose landing gear.NTSB CHI84LA406Accident · No injuriesLimited investigationFinal reportBeech B33 · Willshire, OHDuring the landing flare the acft floated and drifted left. The left wing contacted corn stalks planted up to the edge of the runway.NTSB CHI84LA403Accident · No injuriesLimited investigationFinal reportCessna 150H · Indianapolis, INThe plt stated that during the takeoff roll, the window popped open. At about that time, the acft began traveling to the left side of the rwy, but the plt elected to continue the takeoff. While in a nose high attitude to takeoff, the aft fuselage contacted a…NTSB CHI84LA399Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lake Elmo, MNPilot stated that he landed near the approach end of runway 13 and 'right side of aircraft collapsed.' The investigation revealed that the aircraft landed 50 feet to the right side of runway 13. The pilot recorded only a total of 4 hours of night time, 2…NTSB CHI84LA398Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Richmond, INThe acft collided with power lines and crops after a loss of power while on a training flt. The CFI and student plt were practicing in cruise, single eng simulation by leaning the rt eng and setting a 'zero' thrust condition. The student was then to set the…NTSB CHI84FA396Accident · 1 fatalField investigationFinal reportRobert Eggebrecht Sonerai 2L · Plato Center, ILThe acft stalled & spun to the ground from about 200 ft AGL after an abrupt pull-up to aprx 45 degree deck angle during a premature liftoff. The plt had been observed making high speed taxi runs 'to get the feel of the acft'. After a run resulted in a…NTSB ANC84LA187Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Cairn Mountain, AKThe acft crashed during a takeoff from a remote airstrip. The plt stated that he walked the strip prior to starting the takeoff. He said that immediately after liftoff the acft began to drift left. Before he was able to make a correction the tail of the acft…NTSB ANC84FA189Accident · No injuriesField investigationFinal reportCessna 188 · Chugiak, AKThe plt stated the acft was covered with ice but he removed the majority of it before taking off. The acft contained a 200 gal load of fuel in the hopper. The plt stated the acft accelerated slower than normal and the takeoff ground run was long. He stated…NTSB MIA84LA257Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe flt experienced eng failure and made a forced landing in a field, substantially damaging the aircraft. Post crash examination of the engine revealed the number three connecting rod separated from the crankshaft when the connecting rod bolts failed.…NTSB LAX84LA489Accident · Minor injuriesLimited investigationFinal reportCessna 182D · Lincoln, CAAfter a descent from 11,000 ft, the eng lost power at 3500 ft & would not restart. At that time, the plt noted that the fuel gages indicated the right tank was about 1/4 full & the left tank was empty. He landed in a rice field at night where the nose gear…NTSB FTW84LA409Accident · No injuriesLimited investigationFinal reportCessna 172P · Lancaster, TXWitnesses reported that the acft was taxiing fast and failed to clear the row of parked acft. The left wing contacted the tail of a parked Cessna 177, which was destroyed by impact and propeller damage as the taxiing acft swung into it.NTSB FTW84LA407Accident · Minor injuriesLimited investigationFinal reportBeech 95-C55 · Dallas, TXThe acft received subst damage during an emerg landing after loss of power in both left & right engines. The plt landed the acft in a river bed with the gear retracted during the hours of darkness. The acft was serviced with 10 gals of 100LL prior to…NTSB FTW84LA403Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Plainview, TXThe CFI stated that at the time of the accident the private plt, in preparation for his commercial certificate, was flying a power off 'spot landing' with a desired touchdown point at the second centerline stripe. In an effort to reach the landing point with…NTSB DEN84LA297Accident · No injuriesLimited investigationFinal reportWindecker Research Eagel AC7 · Deming, NMThe acft collided with the rwy gear up after takeoff. The plt said he encountered a microburst which forced the acft to the rwy. There were reported thunderstorms in the area. The plt also said he is going to alter his takeoff proceduresto raising the landing…NTSB DEN84FA300Accident · 3 fatalField investigationFinal reportBeech V35 · Missoula, MTOn sept 21, 1984, a Beech 35, N3736Q crashed into the side of a mountain 16 miles NE of Missoula, MT while on a VOR/DME8INSTRUMENT approach. The plt reported icing, turbulence, and intermittant vor-dme reception. The last reported altitude by the plt was 8500…NTSB DEN84FA295Accident · 3 fatalField investigationFinal reportCessna 205 · Highwood, MTAt 0053 MDT, the plt radioed great falls fss & requested wx info. He was advised of IFR conditions & was provided the latest observation. The plt requested & was provided a special VFR clearance to depart to the east. He took off at 0100 MDT & reported over…NTSB CHI84LA400Accident · Minor injuriesLimited investigationFinal reportSteen Skybolt · Valparaiso, INThe acft dragged a wing and flipped over after the plt made a hard landing and lost control. The plt attempted a go-around in an uncontrolled situation. The acft was destroyed.NTSB CHI84LA397Accident · No injuriesLimited investigationFinal reportBeech D 35 · Alexandria, MNThe acft was started with the throttle open after refueling. The plt said the acft collided with a gas hose before he could get the throttle reduced.NTSB CHI84LA395Accident · No injuriesLimited investigationFinal reportCessna 182P · Chicago, ILThe plt reported to gnd control after the accident that he had a flat tire. Several witnesses stated the pilot made a hard landing after which he lost directional control. The plt did not complete an NTSB pilot/operator aircraft accident report.NTSB ATL84LA284Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Henderson, KYThe acft was damaged in an off arpt forced landing after the engine lost oil pressure, overheated and quit running. The plt said she checked the oil quantity at 7 1/2 qts before takeoff for the local flt. The engine overheated after about one hour of flt…NTSB ANC84LA191Accident · No injuriesLimited investigationFinal reportCessna 185 · Mt Plummer, AKThe plt stated that while landing in a crosswind, he ground looped the airplane. The acft departed the airstrip surface and rolled off the mountainside backward.NTSB NYC84LA318Accident · No injuriesLimited investigationFinal reportCessna 182P · West Mifflin, PAOn arrival at airport, plt received wind information from twr as varying from 230 to 250 degrees at 15 KTS gusting to 20 and was offerred a choice of rwy 28 or rwy 23. Rwy 23 is 100 ft wide and 2380 ft long. Plt chose rwy 28. At landing flare, acft…NTSB LAX84LA488Accident · Serious injuriesLimited investigationFinal reportBell 206B · Paso Robles, CAPlt stated that after receiving a special VFR clearence he took off to spray a nearby field. He continued to state that he 'made a couple of circuits over the field, observed the telephone wires and began spraying. After performing 2 or 3 passes I hit some…NTSB LAX84LA486Accident · No injuriesLimited investigationFinal reportCessna 414A · Carlsbad, CAThe acft was on IFR departure in minimal weather conditions. On takeoff roll, a pwr loss occurred on the rt eng and the acft veered to the rt. PIC (owner) in left seat initiated aborted takeoff, but rt seat plt took control, continued takeoff and feathered…NTSB DEN84LA296Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Carrington, NDAccording to the plt, the landing gear were extended on base leg but he did not recall seeing the green light indicating a down and locked configuration. As the acft touched down some resistance was felt by the plt as all 3 gear collapsed and the acft settled…NTSB DEN84FU011Accident · 1 fatalFinal reportEipper Quicksilver MX · Brighton, COThe ultralight was turning in a spiral turn to the right when witnesses heard the engine stop. The acft went into a spinand crashed. Witnesses said the plt had been doing this before with a pull out at about 50 ft AGL and a restart of the engine. The height…NTSB DEN84FA294Accident · 1 fatalField investigationFinal reportCessna A185F · Fort Peck, MTPlt attempted to takeoff from a calm part of reservoir. The wave heights were estimated to be 4 to 6 feet. The arft struck several waves during the takeoff run. The rt wing tip dragged in the water causing the acft to nose over. The acft came to rest…NTSB ATL84LA299Accident · No injuriesLimited investigationFinal reportCessna 182H · Murray, KYThe pilot stated that during taxi from landing, the left wing tip of the aircraft struck the corner of the main hangar building. Daylight hours, clear weather and dry ramp area conditions existed at the time.NTSB SEA84LA231Accident · No injuriesLimited investigationFinal reportDrake Quickie II · Twin Falls, IDThe plt said that the acft porpoised 2 or 3 times after initial touchdown. After bouncing, the acft veered to the rt, ground looped and nosed over after contacting the soft ground off the side of the rwy.NTSB SEA84LA230Accident · No injuriesLimited investigationFinal reportCessna R-182 · Mountain Home, IDThe pilot was landing on a road to visit friends when the acft collided with a gate during the roll. The pilot had originally intended to land at a nearby municipal arpt after flying over the friends house. Due to the close proximity of Mountain Home air…NTSB NYC84LA325Accident · No injuriesLimited investigationFinal reportPiper J-3 · Durham, CTThe plt attempted to land on a grass strip. The wind was reported to be from 270 degrees at 10 KTS. The plt stated that he experienced a change in wind direction and a gust. The acft then veered and collided with a stone wall.NTSB NYC84LA317Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Medford, NJDuring engine run-up, right magneto had excessive RPM drop. Plt leaned mixture for burn-out and inavvertently shut down engine. After restart, plt ran engine with lean mixture; subsequent magneto check was within limits. At 300 ft AGL on initial climb, engine…NTSB NYC84FNE07Accident · 1 fatalFinal reportFuller/Findlay Varieze · Worcester, MAWitnesses stated, after what appeared to be a longer then normal takeoff roll, acft rotated to a very steep climb angle. Estimates regarding climb angle vary from 'slightly nose up' to vertical. Acft climbed to 100-150 ft AGL and rotated to an extremely nose…