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 LAX87LA292Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · El Monte, CAAn instructor (CFI) was giving an airline transport plt (ATP) a check-out in the PA-34. The ATP checked the fuel quantity & questioned the CFI about the lvl in the left tank. The CFI acknowledged that the fuel tank was not full. The ATP stated the fuel gauges…NTSB LAX87FA291Accident · Minor injuriesField investigationFinal reportNavion A · Hawthorne, CADuring a pleasure cross country flt, the eng sputtered then regained full pwr. The plt turned toward a nearby arpt and was cleared to land. En route to the arpt the engine lost full power. When the pilot thought he could make the rwy he extended the landing…NTSB LAX87FA290Accident · No injuriesField investigationFinal reportde Havilland DHC-6 · Palmdale, CAA Dehavilland DHC-6, N931MA, operating as transworld express flt 7591 (twe 7591) & a Cessna 172N, N737EV, collided abt 10 miles west/southwest of Palmdale, CA at abt 5500 ft MSL. Twe 7591 was descending on a 355 deg mag heading; N737EV was level and was…NTSB DEN87LA209Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Taos, NMThe plt attempted to land on rwy 22 with a left quartering x-wind. Drg the landing, the acft bounced twice, then veered to the right & went off the rwy. The plt applied power & initiated a go-around. The acft became airborne, but its right wing struck the…NTSB DEN87LA208Accident · No injuriesLimited investigationFinal reportCessna 180 · Broomfield, COPlt was conducting test flt following maint on tailwheel due to shimmy. On final landing acft control was lost at apx 20 KTS due to tailwheel jam. Acft departed side of rwy and left main gear collapsed causing substantial damage to airframe. Tailwheel jam was…NTSB DEN87DTG01Accident · No injuriesFinal reportCessna 188 · Valley City, NDThe plt rprtd the eng lost pwr drg a swath run & the acft was dmgd drg a forced lndg in a field of mature sunflowers. An exam of the acft revealed that both fuel tanks & the gascolater contained fuel. Subsequently, the eng was started at the acdnt site & it…NTSB DEN87DTE03Accident · No injuriesFinal reportGrumman-Schweizer G-164A · Springfield, COThe plt rprtd the eng lost pwr drg an aerial application flt & the acft nosed over drg a forced lndg in a soft, wet, terraced fld. There had been hvy rain on the previous day. An investigation revealed the acft had been refueled from a fuel tank mounted on a…NTSB MKC87LA155Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-300 · Swea City, IAThe acft was engaged in ag spray operations near Swea City, Iowa. The PIC stated that he was making a procedure turn after a swath run. The PIC further stated that the acft stalled in the turn and the acft descended into the fld he had been spraying. The PIC…NTSB MKC87LA154Accident · No injuriesLimited investigationFinal reportPiper PA-32RT · Oelwein, IADuring a personal night x-c flt, the plt noticed a glowing condition in the engine compartment and also a loss of manifold pressure. The plt shut the fuel off, pulled the mixture to cutoff, and declared an emergency. The acft made an emergency landing in a…NTSB FTW87LA187Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Hereford, TXThe acft was taking off from a state hwy with a truck blocking traffic at the end of a 2,500 foot stretch. The plt elected to tkof toward the truck, however, during the tkof run, he realized that he could not clear the truck and pulled up sharply. Drng the…NTSB DEN87LA206Accident · No injuriesLimited investigationFinal reportBell 206B · Albuquerque, NMDuring cruise flt a partial power failure occurred requiring a full emerg autorotative landing to be conducted to an uneven dirt area. Following touchdown the acft slid forward and the tail rose causing the main rotor to contact the tail boom severing the…NTSB DEN87IA207Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300-B4-203 · Denver, COAs coplt accelerated acft through 128 KTS for takeoff, electrical malfunction occurred resulting in unreliable instrument indications. Capt rejected takeoff. Acft went off end of 12000-FT rwy. Post-incident examination disclosed no. 1 constant speed drive…NTSB CHI87LA182Accident · No injuriesLimited investigationFinal reportPiper J3 · Vermillion Lake, MNWhile attempting to return to land after the loss of power, the right wing tip hit the water and the aircraft flipped upside down into the lake. According to a mechanic who inspected the aircraft after the accident, the coils and condensers on both magnetos…NTSB CHI87IA183Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Chicago, ILAfter ldg the co B727 was directed to make two right turns and follow an acft that had landed in front of him. The pilot made one right turn and taxied down an empty runway. This taxi route crossed an active runway. An aa#DC-10 on takeoff roll, at 110 knots,…NTSB SEA87FA152Accident · 4 fatalField investigationFinal reportCessna 172 · Pahrump, NVThe pilot entered a box canyon and attempted to either outclimb the terrain or reverse course. The aircraft's airspeed was allowed to decrease below vs and the aircraft stalled. A density altitude of approximately 9500 feet existed at the time. Insufficient…NTSB NYC87LA218Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Newport, NHOn takeoff the aircraft failed to gain sufficient airspeed to maintain flight. The takeoff was aborted after reaching 200 feet altitude and the aircraft was landed on the runway. The aircraft continued off the end of the runway and collided with a sandbank.…NTSB NYC87LA217Accident · No injuriesLimited investigationFinal reportRobinson R22 · Sterling, MABefore flying solo, the student plt & his instructor (CFI) practiced autorotations for about 1/2 hr. The CFI deplaned & the student took off on a solo flt. He flew to a reservoir area for more practice. After descending from about 1000' to 500', the eng lost…NTSB MIA87LA221Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · St.Augustine, FLDuring the water takeoff run the plt's forward visibility was momentarily lost as he rotated the acft onto the step. When visibility was regained he realized that the acft was headed towards the shoreline & turned to avoid it during which the rt wing tip was…NTSB FTW87LA186Accident · No injuriesLimited investigationFinal reportLet L-13 · Hempstead, TXAcft landed short of threshold following a low release shortly after t/o. release was low due to tow plane's being unable to climb above 200' AGL due to the glider's spoilers being deployed inadvertently during the t/o. the plt stated that he executed a 270…NTSB CHI87LA184Accident · No injuriesLimited investigationFinal reportCessna 172Q · Belleville, MIAlthough the plt saw a dark wx area apch the arpt he elected to shoot a touch and go before terminating the flt. After touchdown and during taxi twr advised wind was 270 degrees at 40 KTS. The pilot continued taxi to the south and the wind nosed the acft down.NTSB CHI87DEV03Accident · No injuriesFinal reportPiper PA-22 · Roanoke, ILAfter developing an oil leak the pilot elected to make a precautionary landing. The aircraft encountered rough terrain on touchdown and collapsed the nose gear and nosed over. The pilot and one passenger reported no injuries, however the aircraft was…NTSB BFO87FA050Accident · Minor injuriesField investigationFinal reportCessna 172P · Whitemarsh, MDThe pilot stated that he touched down near the end of the 22OO foot runway. However, witnesses said he landed so FAR down the runway that they did not believe he could stop on the runway. The pilot delayed his go around attempt to the point where it was not…NTSB NYC87LA216Accident · No injuriesLimited investigationFinal reportPiper PA-18S · Brewster, MAThe instructor (CFI) said that shortly after takeoff, the student was given a simulated power failure. At aprx 75' AGL, the student initiated a steep turn to head into the wind, which terminated in nearly a 90 deg heading change. The CFI stated the wind was…NTSB NYC87FA215Accident · 4 fatalField investigationFinal reportCessna 182Q · Sparta, NJThe acft was observed to fly near power lines, then roll inverted, crash & burn in a wooded area. The 4 occupants rcvd multiple impact injuries which were fatal. The acft was destroyed by the impact & post crash fire. Svrl witnesses rprtd the eng power was…NTSB MIA87FA220Accident · 1 fatalField investigationFinal reportBuccaneer XA-430 · Lk Buena Vista, FLThe accident occurred while the acft was flying at an EST 800 to 1000 ft. persons on the grnd heard a bang, then looked up and saw the acft in a spin to the rt with the rt wing folded back over the fuselage. The acft hit the grnd in a near vertical attitude.…NTSB LAX87FA286Accident · 2 fatalField investigationFinal reportLuscombe 8A · Oakdale, CAThe plt & his plt-rated wife (flying in their Luscombe) & another couple (in a rented Mooney) had dinner & drank wine. By about 0015 the couples had taken off in their respective acft for a return flt home and they had each other in sight. The couple in the…NTSB FTW87FA184Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Imperial, TXAfter takeoff, the plt elected to fly low over a reservoir. He stated that as he began a pass, not FAR from the water's edge, the acft enctrd a sink. He said he ' . . . Checked power, all ok, plane just seemed to lose all lift . . .' Subsequently, the acft…NTSB FTW87FA183Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Kokomo, INThe plts preflt wx briefing revealed marginal VFR & IFR wx along his proposed route, with a precaution for thunderstorms. An IFR flt plan was filed and the acft departed. Later during flt the plt was radioed info about a convective SIGMET that contained a…NTSB DEN87LA205Accident · No injuriesLimited investigationFinal reportCessna 172C · Cut Bank, MTThe plt stated that she radioed the Cut Bank fss and was told that the wind was 060 degrees at 41 knots. She then landed the acft uneventfully. However, while turning 90 degrees off the rwy onto a taxiway, the acft nosed over.NTSB DEN87DTE02Accident · No injuriesFinal reportNord Stampe SV4C · Englewood, COThe plt reported that the eng lost power at about 100 ft AGL after takeoff and the forced landing resulted in substantial damage. Examination of the aircraft and engine after the accident did not reveal any evidence of pre-impact failure or deficiency.NTSB SEA87LA153Accident · No injuriesLimited investigationFinal reportCessna 182A · Sunnyside, WAThe plt rprtd that when he was lndg on rwy 25, the sun was just above the horizon & shining directly down the rwy. He said he misjudged the distance to the ground & lndd hard on the nose gear. Subsequently, the nose gear collapsed, the acft veered off the…NTSB SEA87LA151Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Plymouth, WADrg a swath run, a total loss of power occurred when the eng's #9 cylinder failed. The plt made a forced lndg in a soft potato field, but the acft nosed over after it slowed to about 20 KTS.NTSB NYC87LA228Accident · No injuriesLimited investigationFinal reportCessna 172 · Groton, CTThe aircraft was taxiing to the ramp after landing. While the pilot was maneuvering the aircraft into a parking space, the aircraft was positioned in such a way that the sun had blinded him temporarily. As the pilot turned the aircraft the left wing contacted…NTSB NYC87LA212Accident · Serious injuriesLimited investigationFinal reportLake LA-4-250 · Westport, NYDrg the takeoff run on a Lake, the amphibian enctrd rough water & became airborne prematurely. The acft then settled onto the water in a slightly nose high attitude & touched down in front of a large wave. The acft's nose crashed head-on into the wave which…NTSB MKC87LA153Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Widener, ARThe ag airplane was making the final swath run over a cottonfield when the engine lost power. After touchdown in a ricefield, the airplane flipped forward to the inverted position. The reason for the power loss could not be determined.NTSB MKC87LA152Accident · No injuriesLimited investigationFinal reportAero Commander Callair A9-B · Osgood, MODuring an aerial application operation, pilot experienced partial power loss and vibration, followed by a loud explosive sound and total loss of power. An emergency ldg was made followed by a nose over. Postaccident inspection revealed the entire propeller…NTSB MKC87LA151Accident · No injuriesLimited investigationFinal reportCessna 150F · Bono, ARThe pilot said he had glided down to 500 feet AGL with the throttle reduced to idle trying to locate a landing strip. He said he applied power and the engine responded too late to avoid hitting a levee in the rice field and he flipped to the inverted position.NTSB MKC87LA150Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Columbus, NEThe PIC was positioning his ag acft for a spray job when he thought he had a pblm with the eng. A precautionary lndg was decided on, but the lndg resulted in substantial dmge to the acft. A spray pump, posnd beneath the eng cowling which rotates by means of a…NTSB LAX87LA288Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Selma, CAA Luscombe 8A collided with two parked airplanes after a hand propped start. The student pilot started the aircraft engine without the brakes set, with no chocks, and with no one in the cockpit. Once the engine started, the aircraft subsequently collided with…NTSB FTW87LA185Accident · No injuriesLimited investigationFinal reportCessna 150M · Sallisaw, OKThe acft impacted the terrain near the Sallisaw, Oklahoma airport. Visual meteorological conditions prevailed at the time of the accident. The pilot stated that the engine quit and he attempted a forced landing to a field. However, the pilot stated that the…NTSB DEN87LA202Accident · No injuriesLimited investigationFinal reportRushton Sophwith Camel · Carrington, NDThe canadian private plt made an unscheduled fuel stop while on a cross country flight. During taxi from landing, the aircraft encountered a strong gusting crosswind. The left wing lifted and the aircraft nosed over.NTSB DEN87FA203Accident · 1 fatalField investigationFinal reportCessna A188B · Kalispell, MTA Cessna ag wagon, N731SH, hit an electrical pwr line during a climbing turn while crop spraying. The acft was observed plummeting to the ground. The acft was substantially damaged and the plt received fatal injuries. The plt was climbing into the sun which…NTSB CHI87LA181Accident · No injuriesLimited investigationFinal reportCessna 182J · Lansing, ILWhile landing on runway 27, the pilot overshot the runway and rolled into a shallow ditch.NTSB BFO87DIG08Accident · Minor injuriesFinal reportPiper PA-28 · Mitchellville, MDDuring takeoff, the acft hit the tops of trees near the departure end of the rwy. The plt stated that after clipping the treetops, he knew the acft was 'going in,' so he pulled the yoke back to slow it as much as possible. Also, the plt stated that during…NTSB ANC87FA112Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Anchorage, AKTwo certificated flight instructors intended to practice landings in a tail wheel airplane. Shortly after the first take off, the PIC stated that there was an abrupt loss of power. The airplane was unable to return to the airport and crashed on a residential…NTSB NYC87LA270Accident · No injuriesLimited investigationFinal reportRockwell 112A · No Kingstown, RIThe aircraft bounced on landing and directional control was lost. The airplane veered to the left side of the runway and struck a pile of rubble and continued into the bay.NTSB MKC87LA149Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Benton, KSWhile practicing soft field take offs, student plt with CFI over rotated acft causing premature flt before attaining vxse airspeed. CFI attempted to correct the situation, but acft settled in uncontrolled descent beyond the airport boundary. Acft struck the…NTSB MIA87LA218Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Pope, MSThe plt stated that after he made a swath run he was turning back for another run when the eng coughed & quit. He then landed in a field & on rollout he was closing in on some trees so he applied the brakes & the acft nosed over & came to rest inverted. Post…NTSB FTW87LA182Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Benito, TXDrg the landing roll, the acft's left wing struck a tv camera man, who was standing at the left edge of the rwy, aprx 1200' from the threshold. The acft then veered off the left side of the rwy & the right main gear collapsed. Witnesses stated the camera man…NTSB DEN87LA204Accident · No injuriesLimited investigationFinal reportBell 47J-2 · Canon City, COThe ATP plt was flying sightseeing rides. There were two adults and two children in the four passenger helicopter. Density altitude was 10000 feet. The acft lost pwr and the plt aborted takeoff and landed. After an eng runup the plt took off again and the…