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 FTW98LA232Accident · Serious injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Eunice, LAThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI98LA171Accident · No injuriesLimited investigationFinal reportStemme S10V · Plymouth, WIthe improper in-flight decision of the pilot in command to initiate a turn at a close proximity to the ground. Factors to the accident were the starting procedures not being followed and the inadequate altitude to initiate the engine restart.NTSB MIA98LA166Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Sumter, SCThe partial failure of the oil cooler bypass valve which resulted in the over-temperature and loss of oil pressure.NTSB FTW98LA222Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Watkins, COThe pilot's failure to maintain visual contact with the taxiway. Factors were the pilot's disabling the electrical system by turning off the master switch, a dark night, and excessive taxi speed.NTSB FTW98FA229Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Guthrie, OKThe designated pilot examiner's decision to execute a single engine go-around which exceeded the airplane's engine out climb capability in the gear down configuration. Factors were the arcing of an electrical wire that grounded the engine starter and the high…NTSB CHI98LA162Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Crookston, MNthe pilot inadvertently stalled the airplane. Factors included the loss of engine power due to fuel exhaustion when the pilot failed to refuel the airplane. Another factor was fatigue.NTSB CHI98LA160Accident · Serious injuriesLimited investigationFinal reportPitts S-2A · Benton, KSthe pilot did not flare the airplane properly during the forced landing. A factor was the engine failure for undetermined reasons.NTSB CHI98IA164Incident · No injuriesIncident investigationFinal reportBoeing 747-123 · Minneapolis, MNthe open shielding on the #2 VHF transceiver coax connector which resulted in electromagnetic interference with the yaw damper system.NTSB CHI98FA159Accident · 4 fatalField investigationFinal reportBell 206L-1 · Arlington Hgts, ILLoss of helicopter control for unknown reasons.NTSB SEA98LA075Accident · No injuriesLimited investigationFinal reportCessna 170 · Auburn, WAThe pilot's inadequate compensation for gusty crosswind conditions. A related factor was gusty crosswinds.NTSB NYC98LA110Accident · 1 fatalLimited investigationFinal reportCessna 337B · Montgomery, NYthe pilot's improper decision to initiate a takeoff with the rear engine inoperative, which resulted in an airplane that could not climb sufficiently to clear obstacles (trees).NTSB MIA98LA165Accident · No injuriesLimited investigationFinal reportCessna 172RG · Roberta, GAThe pilot's inadequate compliance with the emergency procedures for his failure to completely pump the main landing gear into the down and locked position. Contributing to the accident was the reported loss of electrical power for undetermined reasons.NTSB LAX98LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Hollister, CAThe failure of the instructors and dual students in both aircraft to maintain an adequate visual lookout, which resulted in their combined failures to see and avoid each other. Inadequate supervision of the two flights by the respective instructor pilots were…NTSB LAX98LA163Accident · No injuriesLimited investigationFinal reportCessna 172A · Van Nuys, CAThe pilot's failure to maintain obstacle clearance due to his inadequate visual lookout and selection of the wrong taxi route. Contributing factors were the pilot's diverted attention while taxiing in the vicinity of a construction area.NTSB LAX98LA162Accident · No injuriesLimited investigationFinal reportSchweizer G164D · Richvale, CAThe separation of four compressor/turbine blades resulting in a sudden loss of engine power with a subsequent forced landing into unsuitable terrain.NTSB IAD98FA059Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Fort Washington, MDThe pilot's failure to maintain adequate airspeed, which resulted in a stall and collision with trees.NTSB FTW98LA231Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7-B · Longmont, COThe pilot's failure to properly position his foot for a high wind landing. Factors were high winds and windshear.NTSB FTW98LA228Accident · Minor injuriesLimited investigationFinal reportAeronca 65-C · Ozark, ARThe pilot's failure to maintain aircraft control.NTSB FTW98LA225Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Parkin, ARthe pilot's improper planning/decision, which resulted in his failure to maintain sufficient altitude/clearance from trees at the departure end of the airstrip. Related factors were: high density altitude and trees at the departure end of the airstrip.NTSB FTW98LA224Accident · No injuriesLimited investigationFinal reportMooney M20F · Telluride, COThe pilot exceeded the crosswind capability performance of the aircraft, and his delayed response in initiating a go around. Factors were gusty, crosswind and tailwind conditions, and high density altitude.NTSB FTW98LA220Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Monument Valley, UTThe pilot's failure to maintain directional control of the aircraft during landing. Factors were gusty, crosswind conditions, the pilot's lack of experience in type of operation and geographic area, mountainous terrain, and high density altitude.NTSB FTW98LA219Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Albuquerque, NMThe flight instructor's failure to maintain directional control of the aircraft. Factors were crosswind, high wind conditions, insufficient demonstrated crosswind component information provided by the manufacturer, and insufficient aircraft…NTSB CHI98LA161Accident · No injuriesLimited investigationFinal reportGrumman American AA-1C · Manhattan, KSthe pilot did not attain proper flying speed. Factors included the high density altitude and crosswind condition.NTSB CHI98LA157Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Tower, MNthe pilot's inadequate preflight of the airplane's fuel system, and fuel exhaustion, which resulted in a loss of engine power, due to an inadequate supply of fuel.NTSB CHI98LA155Accident · Serious injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Dawson, NDthe pilot's failure to maintain clearance with the telephone pole. Factors associated with the accident were the pole and the glare from the rising sun.NTSB CHI98FA165Accident · 2 fatalField investigationFinal reportCessna 172 · S. Sioux City, NEThe pilot's failure to maintain adequate flying airspeed during the climbing left turn resulting in a stall condition. Contributing factors were the gusty, crosswind conditions, and the pilot's excessively tight turn maneuver during the initial climb.NTSB ANC98LA051Accident · No injuriesLimited investigationFinal reportCessna 182A · Palmer, AKThe pilot's failure to abort the landing. A factor associated with the accident is the presence of a variable wind condition.NTSB ANC98LA049Accident · No injuriesLimited investigationFinal reportCessna U206G · Iliamna, AKThe pilot's inadequate compensation for quartering tailwind conditions. A factor in the accident is the presence of a quartering tailwind.NTSB NYC98LA118Accident · No injuriesLimited investigationFinal reportMorrison Rans S-12 · Gum Spring, VAA loose/partially disconnected engine intake fuel line which resulted in a loss of engine power, and the pilot's delayed (late) flare prior to touchdown.NTSB NYC98FA107Accident · 2 fatalField investigationFinal reportErcoupe ERCO-415C · New Lisbon, NYDetonation within the No. 2 cylinder resulting in melting and breaching of the piston, and the pilot's selection of unsuitable terrain for landing. Contributing factors were the uphill terrain encountered during the landing and the visual perception…NTSB MIA98LA164Accident · No injuriesLimited investigationFinal reportCessna 172P · Fort Myers, FLThe pilot's inadequate inflight decision and her selection of unsuitable terrain to conduct a precautionary landing.NTSB MIA98LA163Accident · Serious injuriesLimited investigationFinal reportNanchang CJ-6A · Pageland, SCWas the inadvertent stall of the airplane by the pilot-in-command while attempting to clear trees beneath the airplane during the descent for the forced landing. Contributing to the accident was the partial loss of engine power due to separation of the No.9…NTSB LAX98LA160Accident · No injuriesLimited investigationFinal reportRobinson R22B · San Jose, CAThe student pilot's failure to maintain adequate rotor rpm, and the flight instructor's inadequate supervision of the flight.NTSB IAD98LA069Accident · No injuriesLimited investigationFinal reportCessna 182L · Marlborough, MAThe pilot's improper flare. A related factor was the crosswind.NTSB IAD98LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Princeton, NJA stuck carburetor float which restricted fuel flow to the engine that resulted in a loss of engine power.NTSB FTW98LA227Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Searcy, ARThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor was the certified flight instructor's inadequate supervision.NTSB FTW98LA223Accident · Serious injuriesLimited investigationFinal reportAS+ AC-4 · Cedar Fort, UTFailure by the pilot to maintain control of the aircraft. A factor was lack of experience in make and model.NTSB FTW98LA221Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260D · Richfield, UTthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power; and his failure to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in an inadvertent stall and collision with the terrain.NTSB FTW98LA218Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Dumas, ARThe pilot's improper activation of the parking brake.NTSB FTW98FA216Accident · 3 fatalField investigationFinal reportBeagle B-206 · Vernon, TXThe pilot's failure to maintain the airplane's minimum controllable airspeed following a loss of left engine power after takeoff, which resulted in a loss of control. Contributing factors were the fractured exhaust valve guide on the left engine's # 2…NTSB CHI98LA163Accident · No injuriesLimited investigationFinal reportButler Tool RAF 2000 · Rensselaer, INthe pilot excessively flared the gyroplane during the landing.NTSB ANC98LA047Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Talkeetna, AKThe pilot selected the wrong runway and intentionally ground looped to stop the airplane. Related factors were the tailwind and whiteout conditions.NTSB NYC98LA109Accident · Minor injuriesLimited investigationFinal reportDeberry Marquart MA-5 · Westminster, MDFailure of a fuel line fitting which led to an engine failure and fire. A factor was the lack of suitable terrain for the forced landing.NTSB NYC98LA108Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Farmingdale, NYThe engine's inability to provide full power, and the pilot's failure to use performance data. Factors in the accident were conditions conductive for carburetor icing at reduced power, and the unsuitable terrain during the forced landing.NTSB LAX98LA159Accident · No injuriesLimited investigationFinal reportBell 206B · Temecula, CAA loss of engine power due to a deteriorated compressor air seal which resulted in the fracture and separation of several stator vanes. Deterioration was not detected as a result of an inadequate maintenance inspection frequency.NTSB LAX98LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Clarksburg, CAA total loss of engine power for undetermined non-mechanical reasons. A contributing factor in the landing nose-over was the presence of the soft terrain.NTSB FTW98LA230Accident · No injuriesLimited investigationFinal reportCessna 180 · Abilene, TXThe pilot's improper compensation for the crosswind conditions resulting in a ground loop. A factor was the crosswind condition.NTSB CHI98FA153Accident · 4 fatalField investigationFinal reportCommander 114-B · Lagrange, WIthe pilot not maintaining aircraft control during cruise flight and exceeding the airplane's design stress limits. Factors in this accident was the pilot's lack of total experience in the airplane and the clouds.NTSB ANC98FA048Accident · 2 fatalField investigationFinal reportCessna 172M · Palmer, AKThe pilot's intentional flight into known adverse weather conditions. Contributing factors were the terrain induced turbulence, clouds, the pilot's overconfidence in his abilities, and mountainous terrain conditions.NTSB MIA98FA162Accident · 1 fatalField investigationFinal reportTaylorcraft BC-12D · Mccalla, ALThe pilot's failure to maintain airspeed, which resulted in a stall.