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 ATL90LA138Accident · Minor injuriesLimited investigationFinal reportBell BH-47G · Seagrove, NCFailure of a number four connecting rod bolt for an undetermined reason.NTSB ANC90LA100Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Olson Creek, AKThe pilot's selection of unsuitable terrain.NTSB SEA90LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Reno, NVThe pilot's use of an inappropriate runway. The gusty tailwind and the pilot's lack of experience were factors related to the accident.NTSB MKC90LA139Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Swifton, ARFailure of the engine driven blower assembly. A factor was the lack of suitable terrain for the forced landing.NTSB MIA90LA146Accident · No injuriesLimited investigationFinal reportAyres S-2R · Fort Pierce, FLEngine failure due to failure of the engine driven fuel pump shaft due to undetermined reasons.NTSB DEN90LA145Accident · Minor injuriesLimited investigationFinal reportGrumman AA5B · Monte Vista, COThe pilot's premature rotation and liftoff.NTSB ANC90LA098Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Caribou Lake, AKA power loss caused by the failure of a piston cylinder.NTSB ANC90FA097Accident · Serious injuriesField investigationFinal reportCessna 206 · Fairbanks, AKThe failure of the wristpin caused the separation of the connecting rod from the piston and subsequent seizure of the engine. A factor was unavailability of a suitable forced landing area.NTSB MKC90LA138Accident · No injuriesLimited investigationFinal reportHiller 12-E · Watson, MNPilot misjudged his flare and collided with the terrain.NTSB MKC90LA137Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Goddard, KSFuel starvation due to a loose fuel strainer screen. A factor related to this accident was lack of suitable terrain for a forced landing.NTSB MIA90FA145Accident · 2 fatalField investigationFinal reportPiper PA-31 · Panama City, FLA loss of power on both engines during takeoff as a result of inadequate maintenance. In addition, the pilot failed to abort the takeoff.NTSB LAX90LA231Accident · No injuriesLimited investigationFinal reportCessna 152 · Fillmore, CAThe inadvertent engagement of the starter during flight for undetermined reasons. >NTSB FTW90FA125Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Dallas, TXThe initial partial loss of engine power, followed by the total loss of engine power and the striking of a hidden set of transmission wires.NTSB DEN90LA142Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Durango, COA pilot induced stall. A factor was the pilot's lack of experience.NTSB CHI90MA162Accident · 1 fatalMajor investigationFinal reportPiper PA-46-310P · Lakeville, MIThe pilot's failure to use the airplane's ice protection equipment, which resulted in a performance loss due to induction icing, propeller icing, or both, while flying in convective instrument meteorological conditions (IMC) at and above the freezing level.…NTSB CHI90LA163Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Savoy, ILThe loss of engine power for undetermined reasons and the inadvertent stall during the forced landing.NTSB CHI90DEE07Accident · Minor injuriesFinal reportSchweizer G-164B · Deer Grove, ILThe pilot's inadequate visual lookout, resulting in collision with a power line.NTSB MKC90LA141Accident · No injuriesLimited investigationFinal reportBeech B-60 · Hutchinson, KSEngine failure for undetermined reasons. A factor in the accident was that there was no suitable terrain in which to make a forced landing.NTSB MKC90LA136Accident · No injuriesLimited investigationFinal reportCessna 180 · Tecumseh, NEExcessive taxi speed and directional control not maintained by the pilot in command.NTSB MIA90IA144Incident · No injuriesIncident investigationFinal reportCessna 210L · Fort Lauderdale, FLIncorrect placement of the retaining ring in the left main landing gear door actuator by the mechanic resulting in the loss of hydraulic fluid. This prevented the gear from extending resulting in the gear up landing.NTSB LAX90DUG07Accident · Serious injuriesFinal reportSpark/Acroduster SA/750 · Redlands, CAThe pilots failure to maintain a speed above a stall after experiencing a loss of engine power. Contributing to the accident was the pilot's miscalculation of the fuel supply.NTSB ANC90FA101Accident · 5 fatalField investigationFinal reportCessna 207A · Aialak Bay, AKThe pilot-in-command's attempt to fly under visual flight rules while in instrument meteorological conditions. Contributing factors to the accident were the low ceiling and surrounding mountainous terrain.NTSB SEA90LA112Accident · No injuriesLimited investigationFinal reportCessna 177 · Hitchcock, WAThe pilot's loss of control of the airplane during final approach for landing. Sunglare was a factor related to the accident.NTSB SEA90LA111Accident · Minor injuriesLimited investigationFinal reportCallair A-3 · Burley, IDAn encounter with meteorological conditions that exceeded the aircraft's ability to climb or maintain level flight. The high density altitude and lack of suitable terrain were factors related to the accident.NTSB NYC90LA138Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Lancaster, PAThe pilot's selection of an unsuitable landing site. Contributing to the accident was the pilots decision to land in a field with insufficient space available.NTSB NYC90LA137Accident · Minor injuriesLimited investigationFinal reportBeech BE-23 · West Milford, NJThe failure of the pilot in command to attain the proper touchdown point while making a forced landing following loss of engine power due to fuel exhaustion.NTSB LAX90FA229Accident · No injuriesField investigationFinal reportPiper PA-24-260 · Corona, CASabotage wherein unknown person(s) put sand in the airplane's fuel tank.NTSB FTW90LA123Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Mc Allen, TXLoss of engine power for undetermined reasons. The concrete canal that he impacted was a factor.NTSB DEN90LA144Accident · Serious injuriesLimited investigationFinal reportCessna C-152 · Golden, COThe pilot's disregard for airplane performance data. Contributing to the accident were high density altitude and the fact that airplane climb performance capability was exceeded.NTSB DEN90LA143Accident · No injuriesLimited investigationFinal reportCessna 150 · Bountiful, UTPower loss due to fuel exhaustion. A factor was the pilot's failure to refuel.NTSB DEN90LA141Accident · No injuriesLimited investigationFinal reportBeech 23 · Wheatland, WYPermature liftoff.NTSB CHI90FA161Accident · 1 fatalField investigationFinal reportCessna 152 · Hagerstown, INThe pilot's failure to use all available runway and failure to abort the takeoff.NTSB CHI90DEE06Accident · No injuriesFinal reportPiper PA 28 140 · Savanna, ILThe pilot's misjudgement of the airplane's fuel supply, resulting in fuel exhaustion.NTSB ATL90LA137Accident · No injuriesLimited investigationFinal reportCessna 150L · Blountville, TNThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion.NTSB ANC90LA095Accident · No injuriesLimited investigationFinal reportBell B-47G2A · Dutch Harbor, AKThe pilot in commands continued VFR flight into IMC conditions and his failure to maintain altitude while manuevering to avoid terrain.NTSB SEA90LA110Accident · No injuriesLimited investigationFinal reportCessna 340A · Priest River, IDThe pilot's misjudgement of distance and altitude and his failure to maintain an adequate airspeed during the landing approach.NTSB MKC90LA140Accident · No injuriesLimited investigationFinal reportPiper J-3 · Clarksville, ARFailure of the pilot to maintain flying speed.NTSB MIA90LA143Accident · No injuriesLimited investigationFinal reportCessna 150M · Rockledge, FLThe pilots failure to raise the flaps as required during the go-around and failure to place the carburetor heat in the cold position.NTSB LAX90LA228Accident · No injuriesLimited investigationFinal reportNavion A · Big Bear, CAThe failure of the pilot to adequately compensate for the cross wind on his approach.NTSB LAX90LA227Accident · No injuriesLimited investigationFinal reportRobinson R22A · Pinon Hills, CAThe pilot's failure to maintain adequate rotor RPM during an attempted takeoff. A contributing factor was the high density altitude.NTSB LAX90FA230Accident · No injuriesField investigationFinal reportHughes 369D · Hanapepe, HIFailure of pilot of the photographing helicopter to maintain clearance and avoid collision.NTSB LAX90DVG10Accident · Serious injuriesFinal reportChilds 360 · Davis, CAAn engine failure due to fuel exhaustion after the pilot failed to properly secure the stopper to the fuel tank.NTSB FTW90LA124Accident · No injuriesLimited investigationFinal reportCessna 150L · Tomball, TXStudent pilot's failure to maintain directional control and proper alignment with timely manner after a bounced landing. A factor in the accident was the presence of a right quartering headwind.NTSB FTW90LA122Accident · Serious injuriesLimited investigationFinal reportPiccard P-80 · Peaster, TXAn excessive rate of descent during the approach.NTSB FTW90DQG03Accident · 1 fatalFinal reportNorth American P-51D · Abilene, TXFailure of the pilot to maintain adequate airspeed, while maneuvering after a low pass, which resulted in an inadvertent stall. The high density altitude was a related factor.NTSB DEN90DTG02Accident · 1 fatalFinal reportEugene N. Rausch RV-4 · Erie, NDAn inadvertent stall.NTSB BFO90LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Clinton, MDThe student pilot's failure to maintain directional control of the aircraft and his improper use of the throttle control. Contributing to the accident was the student's lack of total experience.NTSB ANC90LA096Accident · No injuriesLimited investigationFinal reportShort Brothers SH-7 · Kako Mine Strip, AKThe pilot-in-command's failure to maintain control of the airplane through the touchdown and landing phase.NTSB SEA90LA109Accident · No injuriesLimited investigationFinal reportMaule M-5 · Riverside, ORThe pilot's selection of unsuitable terrain for a landing site and his inadequate compensation for the wind condition. Factors related to the accident were: the tailwind and the ditch.NTSB SEA90LA108Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Dayton, WALoss of engine power for an undetermined reason.