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 ANC96TA095Accident · Minor injuriesFinal reportCessna 185 · Fairbanks, AKfatigue failure of the engine crankshaft. A factor related to the accident was: the lack of suitable terrain for a forced landing.NTSB MIA96LA174Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Kinston, NCfailure of the pilot to maintain minimum descent altitude (MDA) during approach because of fatigue.NTSB FTW96LA298Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Ardmore, OKThe pilot's inadvertent premature retraction of the landing gear during takeoff roll. A factor was inadequate supervision by the safety pilot/flight instructor.NTSB FTW96LA291Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Castle Rock, COTotal failure of the magneto. A factor was the pilot operating the helicopter with a known deficiency.NTSB ANC96LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cantwell, AKThe pilot's inadequate compensation for the crosswind conditions. A factor in the accident was the crosswind.NTSB SEA96LA141Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Paris, IDthe pilot forgot to extend the landing gear before landing. Factors relating to the accident were: an interuption of the pilot's habit pattern, when he circled to provide time for another airplane to takeoff as he entered the traffic pattern; and his failure…NTSB SEA96LA140Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Jackson, WYAn improper screw installation by an unknown individual into the instrument panel, which restricted movement of the gear handle resulting in premature disengagement of the normal landing gear extension system. A factor was one or more improperly adjusted nose…NTSB NYC96LA139Accident · 1 fatalLimited investigationFinal reportTitan Tornado · Richland, NYfailure of the student pilot to maintain adequate airspeed, during an apparent go-around, which resulted in an inadvertent stall and subsequent collision with the terrain. Factors relating to the accident were: the pilot's lack of certification, and…NTSB NYC96LA138Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Wolfeboro, NHThe pilot's improper flare, which resulted in a hard landing and nose over. The glassy water condition was a related factor.NTSB MIA96LA173Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Knoxville, TNFatigue failure of the blade No. 1 hub arm of the left propeller.NTSB LAX96LA259Accident · Minor injuriesLimited investigationFinal reportBeech 95-B55 · Ramona, CAThe pilot's failure to maintain directional control of the aircraft.NTSB LAX96LA258Accident · 1 fatalLimited investigationFinal reportDavis Challenger I CW · Paso Robles, CAthe owner/builder/pilot's impairment of judgment and performance due to drugs which led to his improper handling of the airplane and failure to maintain an adequate airspeed margin above stall speed, resulting in an inadvertent stall/spin. A factor which…NTSB LAX96LA257Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Redlands, CAthe CFI's delayed remedial action by not preventing the airplane's departure from the runway, and his failure to maintain airspeed sufficient to avoid stalling during an attempted low altitude climbing turn.NTSB IAD96LA106Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Beckley, WVThe pilots decision to continue flying from VFR to IMC conditions which subsequently forced him to make a precautionary landing onto unsuitable terrain.NTSB IAD96LA103Accident · Serious injuriesLimited investigationFinal reportAero Commander Calair A-9B · Cloverdale, OHPowerplant failure due to undetermined reasons. Contributing to the severity of the crash was the unsuitable terrain in which the aircraft landed and post-crash fire.NTSB FTW96TA289Accident · Minor injuriesFinal reportCessna 182RG · Broomfield, COfailure of the pilot to maintain directional control and runway alignment during a go-around, and the lack of power response from the engine for undetermined reason(s). The sudden wind shift was a related factor.NTSB FTW96LA287Accident · No injuriesLimited investigationFinal reportCessna 421B · Stillwater, OKthe failure of the pilots of the Cessna 421B, N450SU, and the Cessna 152, N94532, to maintain visual lookout. Factors were: the inadequate radio communications maintained by both pilots, and the failure of the student pilot of the Cessna 152 to take evasive…NTSB FTW96FA288Accident · 1 fatalField investigationFinal reportAir Tractor AT-400 · Huffman, TXcorroded flight control components, due to the operator's inadequate maintenance and inspection of the airplane; the pilot's failure to follow procedures and directives, by flying the airplane without proper maintenance and annual inspection; and subsequent…NTSB SEA96LA139Accident · No injuriesLimited investigationFinal reportAgusta A109 · Newport, ORthe pilot's failure to adequately compensate for the gusty wind condition during the landing. The gusty wind was a related factor.NTSB NYC96LA135Accident · No injuriesLimited investigationFinal reportBell 206B III · South Carver, MAThe pilot's failure to maintain control of the helicopter during an aerial application maneuver. This put the helicopter in a low slow down wind, high power demand turn, where it encountered a loss of tail rotor effectiveness, and the subsequent collision…NTSB LAX96LA256Accident · No injuriesLimited investigationFinal reportMooney M20E · Rio Linda, CAThe pilot's failure to attain/maintain the proper approach airspeed, his failure to attain the proper runway touchdown point, and his failure to initiate a go-around when a landing overshoot became apparent. A factor in the accident was the airport…NTSB FTW96LA290Accident · No injuriesLimited investigationFinal reportCessna 172L · Johnstown, COfailure of the pilot to maintain proper altitude/clearance from obstructions, while buzzing.NTSB FTW96LA286Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Almyra, ARThe pilot's failure to maintain aircraft control. A factor was the pilot's excessive use of flaps during the maneuver.NTSB FTW96LA285Accident · No injuriesLimited investigationFinal reportHiller UH12 · Franklin, LAloss of engine power for undetermined reasons, and the pilot's failure to maintain rotor RPM. A factor was the unsuitable terrain available for the precautionary landing.NTSB FTW96FA282Accident · No injuriesField investigationFinal reportSaab-Scania SF340B · Dfw Airport, TXThe manufacturer's inadequate procedure for manufacturing the number two turbine disk.NTSB CHI96LA226Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 Viking · Alexandria, MNthe flight instructor's failure to assure a proper fuel tank selector position. Factors associated with the accident were improper preflight preparation and complacency by the flight instructor.NTSB CHI96LA225Accident · Serious injuriesLimited investigationFinal reportSisk BD-5 · Lake Geneva, WIfailure of the pilot to abort the takeoff, while there was sufficient runway remaining. The high temperature and calm wind were related factors.NTSB ATL96LA099Accident · No injuriesLimited investigationFinal reportCessna 188 · Pelham, GAfailure of the pilot to maintain directional control on the takeoff roll, which resulted in the airplane veering off the runway and colliding with a cotton picker (vehicle).NTSB NYC96LA137Accident · No injuriesLimited investigationFinal reportCessna 152 · Mansfield, MAan animal (deer) that wandered onto the runway. The light condition (at dusk) was a related factor.NTSB MIA96LA172Accident · No injuriesLimited investigationFinal reportCharles Raymond Glasair 2SFT · Apalachicola, FLInadequate application of throttle input and up elevator input by the pilot-in-command. Contributing to the accident was the in-flight encounter with a downdraft and inadequate design of the airplane by the kit manufacturer.NTSB LAX96LA261Accident · No injuriesLimited investigationFinal reportRominger Eyas · Santa Rosa, CAan inadequate design change by the pilot/builder of the airplane's canopy; a malfunction of the canopy, which resulted in its separation; and failure of the pilot to flare the airplane during an emergency landing after takeoff, due to the wind blast that…NTSB LAX96LA255Accident · No injuriesLimited investigationFinal reportCessna 172 · Frazier Park, CAthe failure of the pilot to maintain terrain clearance after a misjudged approach and landing that necessitated a go-around and subsequent collision with some wires. Factors were high density altitude and an inadequate evaluation by the pilot-in-command of…NTSB IAD96LA102Accident · Serious injuriesLimited investigationFinal reportBeech 65 · Campbellsville, KYthe pilot's inadequate preflight preparation, his failure to remove the control lock, and his failure to abort the takeoff.NTSB FTW96WA310Accident · 2 fatalForeign investigationAerospatiale SA315B · La Peruanita, PeruNTSB FTW96LA281Accident · No injuriesLimited investigationFinal reportCessna 172H · Pierce, COa loss of engine power for undetermined reasons. A factor was the unsuitable terrain.NTSB FTW96LA280Accident · No injuriesLimited investigationFinal reportCessna 182N · Truth Or Conseq, NMThe loss of engine power due to the fatigue failure of the number one piston. A factor was the lack of suitable terrain for the forced landing.NTSB CHI96LA303Accident · No injuriesLimited investigationFinal reportCessna A188B · Watford City, NDthe pilot's failure to maintain directional control while landing on a road.NTSB CHI96LA223Accident · No injuriesLimited investigationFinal reportBell TH-13T · Mandan, NDthe pilot's failure to maintain clearance from known transmission lines. A factor relating to this accident was the sunglare which hindered the pilot's ability to see the transmission lines.NTSB ATL96LA098Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Calhoun, GAthe pilot's failure to maintain directional control during landing.NTSB SEA96LA138Accident · No injuriesLimited investigationFinal reportCessna A188B · Opheim, MTthe pilot's failure to follow the proper short field takeoff procedure as specified in the Airplane Flight Manual, his improper use of wing flaps during the takeoff, and his failure to abort the takeoff (while there was sufficient runway remainin). A factor…NTSB NYC96LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bridgeport, CTthe student pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing.NTSB MIA96WA170Accident · No injuriesForeign investigationBeech D18S · Rock Sound, BahamasNTSB MIA96LA171Accident · No injuriesLimited investigationFinal reportBeech B35 · Kissimmee, FLthe pilot was operating the airplane at an indicated airspeed that exceeded the design speed for maximum gust intensity (VB), when clear air turbulence was encountered.NTSB LAX96LA254Accident · Minor injuriesLimited investigationFinal reportGray Berkut · Santa Paula, CALoss of engine power during final approach for undetermined reasons. A factor in the accident was the nature of the terrain for the forced landing.NTSB LAX96LA253Accident · Minor injuriesLimited investigationFinal reportCessna P210 · Grand Canyon, AZfailure of the pilot to use his brakes to maintain directional control.NTSB LAX96LA252Accident · No injuriesLimited investigationFinal reportCessna 402A · Grand Canyon, AZFailure of the pilot to properly judge his altitude during final approach resulting in an undershoot. A factor was a downdraft weather condition.NTSB LAX96LA251Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Rosa, CAthe solo student pilot misjudged the landing flare resulting in a hard landing. A factor in the accident was low airspeed.NTSB LAX96LA250Accident · No injuriesLimited investigationFinal reportCessna 172 · Camarillo, CAthe student pilot misjudged the landing flare resulting in a hard landing. A factor in the accident was high airspeed.NTSB FTW96LA283Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tulsa, OKThe student pilot's improper flare during the landing, which resulted in a collapsed nose gear, ground swerve, and collision with an object.NTSB FTW96FA279Accident · 2 fatalField investigationFinal reportPrevatt RV-6 · Boulder, COPoor judgment by the pilot of the RV-6, N194JP, in that he traversed an uncontrolled airport at traffic pattern altitude, failure of the pilots of both airplanes to see and avoid each other, and an inadvertent airplane stall encountered by the pilot of the…