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 MIA91LA145Accident · Serious injuriesLimited investigationFinal reportCorley Hubert KR-2 · Venice, FLThe pilot's improper use of flight controls.NTSB LAX91LA214Accident · Minor injuriesLimited investigationFinal reportGrumman G164B · Yuba City, CAFatigue in the propeller blade which led to its ultimate failure. Factors relating to this accident were the soft terrain conditions on which the airplane landed and a berm across the airplane's ground path.NTSB FTW91DPG07Accident · No injuriesFinal reportCessna A188B · Eudora, ARThe pilot's exceeding the airplane's takeoff performance capability for the climatic conditions.NTSB FTW91DPG06Accident · No injuriesFinal reportGrumman G-164A · Gillett, ARThe windshiled becoming obscured by aerial application spray and the resultant limited vision from the cockpit.NTSB DEN91LA070Accident · Serious injuriesLimited investigationFinal reportPiper PA18-50 · Lordsburg, NMPilot factor in that he allowed the aircraft to enter an inadvertent stall mush at an altitude insufficient to recover.NTSB CHI91LA157Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Eau Claire, WIThe inadequate finishing procedures used by the manufacturer and the failure to comply with the manufacturer's bulletin.NTSB CHI91LA156Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Grand Forks, NDThe pilot's failure to maintain directional control during the landing roll. Related to the accident was the pilot's lack of total experience.NTSB ATL91LA147Accident · No injuriesLimited investigationFinal reportCessna 150J · Greensboro, NCThe pilot's improper flare during the landing. Factors in the accident were the dark night and lack of runway edge lights.NTSB ATL91LA093Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Clanton, ALFailure of the pilot to maintain control of the aircraft during a go-around. The pilot's lack of experience was a related factor.NTSB MIA91LA144Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Tutwiler, MSFatigue failure of one of the propeller blades resulting in the forced landing. Contributing to the accident was lack of suitable terrain.NTSB LAX91FA213Accident · 7 fatalField investigationFinal reportCessna 207A · Grand Canyon, AZDetonation (or pre-ignition) in the number 1 cylinder, which resulted in erosion (burning) of the number 1 piston and subsequent loss of engine power. A factor related to the accident was: the lack of suitable terrain for an emergency landing.NTSB NYC91LA234Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Sanford, METhe pilot's improper procedure by not placing the fuel selector on the tank with the most fuel, which resulted in fuel starvation and a forced landing in trees.NTSB NYC91LA134Accident · Minor injuriesLimited investigationFinal reportTierra II · Cooperstown, NYThe mechanical failure of the flight control system, which resulted in a a loss or airplane control and subsequent forced landing in trees.NTSB NYC91LA132Accident · No injuriesLimited investigationFinal reportRobinson R22 · Groveland, MAImproper use of the flight controls by the pilot and his failure to compensate for the winds.NTSB NYC91LA131Accident · No injuriesLimited investigationFinal reportCessna 185C · New Hanover, PAThe loss of directional control by the pilot during a crosswind takeoff and subsequent collision with rough terrain. A factor related to the accident was the pilot's lack of experience in this make and model airplane.NTSB NYC91LA130Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Ellington, CTThe failure of the pilot to maintain directional control, and his inadequate compensation for winds, while maneuvering close to the ground. A factor relating to the accident was the adverse wind conditions.NTSB MIA91LA143Accident · No injuriesLimited investigationFinal reportCessna 152 · Yazoo City, MSPoor planning decision by the student pilot, improper fuel calculations, resulting in fuel exhaustion due to an inadequate fuel supply. Contributing to the accident was overconfidence in his own personal ability by the student pilot.NTSB LAX91LA212Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Catalina Island, CAThe pilot's inadequate altitude and intentional low flying which resulted in the airplane cruising into the water. A contributing factor related to the pilot's poor judgment.NTSB LAX91LA211Accident · 1 fatalLimited investigationFinal reportGlasflugel Mosquito · Pearblossom, CAThe failure of the pilot to maintain adequate airspeed to avoid stalling the aircraft.NTSB LAX91LA210Accident · No injuriesLimited investigationFinal reportCessna 152 · Banning, CAThe failure of the pilot to utilize the proper technique to recover the airplane from a bounced landing.NTSB LAX91FA209Accident · 1 fatalField investigationFinal reportUniversal Globe GC-1B · Chandler, AZThe pilot-in-command's failure to maintain airspeed in a forced landing resulting in an in flight loss of control, stall, and subsequent in flight colliison with terrain. Factor related to the accident was the pilot's improper procedure which restuled in a…NTSB CHI91LA153Accident · No injuriesLimited investigationFinal reportCessna 177 · Decatur, INFailure to obtain airspeed for positive lift off and climb. Factors related to the accident were a grass/sod runway and a high density altitude.NTSB CHI91LA150Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Hillsbord, WIDirectional control was not maintained by the pilot. A factor related to the accident was a drainage ditch.NTSB SEA91LA103Accident · No injuriesLimited investigationFinal reportCessna 182N · Shelton, WAThe total loss of power due to mechanical failure when the pilot was over unsuitable terrain for a forced landing. Factors include a hard landing after an inadvertent stall prior to touchdown on a highway.NTSB SEA91LA102Accident · Minor injuriesLimited investigationFinal reportBoeing A-75 · Seattle, WAThe pilot did not maintain directional control during the landing roll. The factor to the accident was: the pilot's remedial action was inadequate.NTSB NYC91LA129Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Lumberton, NJThe pilot's failure to maintain airspeed and the resultant inadvertent stall. A factor in the accident was the loose oil filter.NTSB NYC91LA128Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Arcadia, RIInadequate preflight by the pilot, and fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: the lack of a suitable area for a forced landing.NTSB MIA91LA142Accident · No injuriesLimited investigationFinal reportCessna 150J · Lantana, FLFailure of the pilot to perform fuel consumption calculations which resulted in fuel exhaustion due to an inadequate fuel supply. Also, inadvertent stall/mush by the pilot during the forced landing. Contributing to the accident was an incorrect fuel gauge.NTSB MIA91LA141Accident · No injuriesLimited investigationFinal reportBell 47-G · Aguadilla, PRThe improper in flight planning/decision of the pilot-in-command to conduct an out-of-ground-effect hover with a right crosswind. This resulted in an in flight loss of control due to settling with power and in flight collision with terrain.NTSB LAX91LA208Accident · No injuriesLimited investigationFinal reportCessna C172M · Coalinga, CAThe pilot's encounter with a dust devil which resulted in his loss of control during landing rollout.NTSB LAX91FA207Accident · 4 fatalField investigationFinal reportCessna 205 · Fallon, NVThe pilot-in-command's improper handling of the airplane and failure to maintain airspeed on initial takeoff climb resulting in an in flight loss of control, stall/spin, and subsequent in flight collision with terrain.NTSB FTW91LA079Accident · No injuriesLimited investigationFinal reportCessna 150 · Raymondsville, TXOil exhaustion for undetermined reason. A factor was the soft terrain.NTSB CHI91LA155Accident · No injuriesLimited investigationFinal reportPiper J3 · Creston, IAIcing in the induction air control system.NTSB CHI91LA154Accident · No injuriesLimited investigationFinal reportEnstrom F28 · Hampshire, ILAircraft control was not maintained when the aircraft encountered an uncotrolled descent by the pilot. Remedial action by the pilot was inadequate. A factor related to the acident was lack of total experience in type of aircraft by the pilot.NTSB CHI91LA151Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIRecovery from a bounced landing was improper by the pilot. Factors related to the accident were lack of recent experience by the pilot.NTSB CHI91LA149Accident · No injuriesLimited investigationFinal reportCessna 172 · Neosho, WIThe pilot's failure to properly flare the airplane and an improper recovery from a bounced landing.NTSB CHI91FA152Accident · No injuriesField investigationFinal reportShort Brothers SD3-60 · Chicago, ILThe failure of the nose wheel steering hydraulic line during after landing ground operations. A related factor is the manufacturer's inadequate inspection and/or replacement standards.NTSB ATL91LA092Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Statesboro, GAFailure of both pilots to perform a visual lookout sufficiently adequate to avoid a collision at an uncontrolled airport. Factors related to the accident were: failure of the pilot of N95170 to communicate on the common traffic advisory frequency (CTAF) and…NTSB SEA91LA101Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Drewsey, ORThe pilot delayed in going-around.NTSB MIA91FA140Accident · 2 fatalField investigationFinal reportMcdonnell Douglas DC-3C · Aguadilla, PRThe pilot in command's failure to maintain airspeed (vs) after a partial loss of engine power on the left engine due to failure of the no. 8 engine assembly cylinder. This resulted in an in flight loss of control (stall), and in flight collision with terrain.NTSB FTW91LA077Accident · Serious injuriesLimited investigationFinal reportVuncannon Rotoway Exec 152 · Jonesboro, ARThe pilot's inadequate lookout and failure to maintain sufficient clearance from the wires for safe operation.NTSB FTW91DRD04Accident · Serious injuriesFinal reportAir Tractor AT 301 · Lake Providence, LAA loss of engine power for undetermined reasons resulting in a forced landing and nose over on landing.NTSB CHI91LA276Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Monticello, MNThe pilot in command's (CFI) delayed remedial action. Related factors are the gusty crosswind, the student pilot's lack of total experience, inadequate compensation for crosswind conditions, and the cfi's failure to maintain directional control.NTSB CHI91LA148Accident · No injuriesLimited investigationFinal reportCessna 182L · Port Huron, MIThe pilot's inadequate landing flare during the forced landing. The pilot's failure to use carburetor heat was a factor.NTSB MIA91LA139Accident · 1 fatalLimited investigationFinal reportCessna TU-206G · Gulf Of MexicoAn in flight collision with the water for undetermined reasons.NTSB MIA91LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Clearwater, FLInadequate annual inspection of the airplane by maintenance personnel who failed to detect a deteriorated oil line. This resulted in oil exhaustion causing the total loss of engine power due to failure of one of the connecting rods. Also inadvertent…NTSB LAX91LA204Accident · 1 fatalLimited investigationFinal reportAyres S2RT34 · Marysville, CAThe pilots' inadequate visual lookout for other air traffic.NTSB FTW91DRG02Accident · No injuriesFinal reportCessna 188 · La Feria, TXThe pilot exceeded the proper descent rate.NTSB DEN91LA069Accident · 1 fatalLimited investigationFinal reportChallenger II · Silt, COAn in flight encounter with wind conditions which exceeded the aircraft performance capability. A factor was: the pilot's failure to obtain available en route weather information.NTSB CHI91DEM05Accident · Serious injuriesFinal reportGildersleeve RV-4 · Ionia, MIRemedial action not performed by the pilot and the pilot's failure to assure the fuel selector was on the proper tank.