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 CHI91LA215Accident · No injuriesLimited investigationFinal reportCessna 182A · Menomonee Falls, WIThe fatigue induced propeller blade failure. A related factor was the operator's delayed propeller overhaul.NTSB CHI91LA214Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Sparta, MIInadequate preflight by the pilot and the pilot's failure to reach a proper touchdown point.NTSB CHI91LA210Accident · 2 fatalLimited investigationFinal reportCessna 150F · Faulkton, SDAn inadvertent stall. A factor related to the accident was the pilot's failure to maintain airspeed.NTSB CHI91DER12Accident · Serious injuriesFinal reportLacey B D4 · Albert Lea, MNThe pilot's failure to take adequate remedial action. Related factors are the tall grass runway conditions, and the inadequate airspeed.NTSB BFO91LA064Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Berlin, MDThe unsuitable placement of two banners (improper planning) by other personnel causing an unintentional pickup of both banners.NTSB ANC91LA096Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · King Salmon, AKThe forced landing on the rough terrain and the engine power loss due to the failure of the engine collector intermediate bearings.NTSB SEA91LA155Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R · Milford, UTFuel exhaustion, and the pilot's misjudgment of proper descent rate. Factors include inadequate preflight planning, poor in-flight decision, becoming lost/disoriented, and a fence.NTSB SEA91LA154Accident · 1 fatalLimited investigationFinal reportJerrell RV-4 · Yellowstonepark, WYA collapsed induction air duct. Factors include inadequate design by the manufacturer/builder, and a misjudged rate of descent by the pilot.NTSB SEA91LA153Accident · Minor injuriesLimited investigationFinal reportDerego Avid Flyer/B · Myrtle Creek, ORLoss of engine power for an undetermined reason.NTSB SEA91LA150Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Riverton, WYThe pilot did not maintain adequate terrain clearance. A factor to the accident was: poor inflight planning/preparation.NTSB NYC91LA170Accident · No injuriesLimited investigationFinal reportCessna 152 · Rutland, VTThe student pilot improper recovery from a bounced landing which resulted in the collapsing of the nose gear. A factor related to the accident was the student pilot's lack of total flight experience.NTSB NYC91LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Tunkhannock, PAImproper use of the flight controls by the pilot which resulted in an inadvertent stall on takeoff with insufficient altitude for recovery. Factors related to the accident was the failure of the pilot to properly set the elevator trim prior to takeoff and the…NTSB LAX91LA286Accident · No injuriesLimited investigationFinal reportCessna 150K · Flagstaff, AZThe pilot-in-command's improper preflight planning of fuel requirements to accomplish the intended flight which resulted in an inadequate fuel supply and subsequent loss of engine power. A factor was the fence.NTSB FTW91LA116Accident · No injuriesLimited investigationFinal reportCessna 172P · Lakeview, AR(1) The pilot's failure to properly flare the airplane for landing and (2) his subsequent improper recovery from a bounced landing.NTSB FTW91DRA05Accident · 1 fatalFinal reportDaniel La Lee Miget Mustang M-1 · Santa Fe, TXThe pilot's performance of an aerobatic maneuver at an altitude inadequate to allow for safe recovery.NTSB FTW91DQG01Accident · 1 fatalFinal reportLGS CGS Hawk · Crane, TXThe inadvertent stall.NTSB DEN91LA096Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Colorado Spring, COThe pilot attempting to operate the helicopter outside the design operating envelope. Factors were: high altitude, high temperature, and high density altitude.NTSB CHI91LA209Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Hill City, SDPoor preflight planning by the pilot and over confidence in the aircrafts ability. Factors related to the accident were a high density altitude and a proper climb rate not attained.NTSB CHI91LA207Accident · No injuriesLimited investigationFinal reportHughes 300C · Whitehall, MIThe pilot's failure to maintain adequate clearance from the water. A factor was the dark night light condition.NTSB CHI91DEX04Accident · Minor injuriesFinal reportWilbur D. Batman Challenger II · Lebanon, INFailure to maintain stall airspeed while executing a forced landing. A factor related to the accident is failure of the engine starter clutch.NTSB BFO91LA063Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · New Market, VAThe pilot's inadequate inflight decision that resulted in VFR flight into IMC.NTSB BFO91LA062Accident · Minor injuriesLimited investigationFinal reportCessna 172 · South Boston, VAThe lost of engine power for undetermined reasons and the lack of suitable terrain to make a forced landing.NTSB ATL91LA123Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Alma, GATurbulence in clouds, which was associated with a dissipating thunderstorm.NTSB ANC91LA089Accident · No injuriesLimited investigationFinal reportCessna 170B · Prospect Creek, AKContinued VFR flight into instrument meteorological conditions (IMC) by the pilot, and his delay in reversing course (remedial action). The terrain and weather conditions were related factors.NTSB ANC91GA087Accident · No injuriesFinal reportPiper PA-18 · King Salmon, AKThe pilot inadvertently switched the magnetos off during the flight. Contributing to the accident was the rough, uneven terrain with loose gravel.NTSB SEA91LA152Accident · No injuriesLimited investigationFinal reportCessna 172N · Waldron, WAVisual lookout was not maintained, and diverted attention.NTSB SEA91LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Richland, WAPartial engagement of the parking brake (locking the right brake) for an undetermined reason.NTSB FTW91LA115Accident · No injuriesLimited investigationFinal reportCessna 172P · El Paso, TXThe power loss due to carburetor icing and the pilot's failure to use carburetor heat. Factors were the icing conditions, lack of suitable terrain for the forced landing, and the gusty tail wind.NTSB CHI91LA206Accident · No injuriesLimited investigationFinal reportCessna 150 · Carlos, MNThe pilot's failure to use adequate carburetor heat. Factors to the accident were the carburetor icing conditions and the wires.NTSB ANC91LA082Accident · No injuriesLimited investigationFinal reportCessna 185F · Farewell, AKThe pilot-in-command's failure to maintain directional control during the landing roll. Factors relating to the accident were the collapsed left main landing gear, failed left brake, and the low level of hydraulic brake fluid.NTSB SEA91LA151Accident · No injuriesLimited investigationFinal reportBeech C33A · Brookings, ORThe pilot's improper flare for touchdown, and her improper recovery from a bounced landing.NTSB NYC91LA167Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Rhinebeck, NYThe pilot did not calculated the airplane's performance data to insure that he had enough runway to clear an obstacle at the end of the field, which resulted in the airplane's landing gear striking high hedges, subsequently the pilot elected to land in a…NTSB NYC91LA166Accident · Minor injuriesLimited investigationFinal reportCessna C-172 · Clarence Center, NYFailure of the pilot to maintain airspeed during a heavy weight takeoff, resulting in a stall and landing in rough terrain.NTSB NYC91LA164Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-300-605R · Newark, NJThe inadvertent encounter with in-flight turbulence, resulting in serious injuries to a crewmember and a passenger.NTSB NYC91LA163Accident · No injuriesLimited investigationFinal reportLearjet LR25B-XR · Columbus, OHThe failure of the pilot to maintain visual reference with the runway during a landing, which resulted in a loss of directional control. Also causal to the accident was the pilot's failure to initiate a go-around, after he lost sight of the runway during the…NTSB NYC91IA165Incident · No injuriesIncident investigationFinal reportBoeing 727-254 · Buffalo, NYChaffing fire detector loop on the number one engine.NTSB FTW91LA114Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus CM · Marfa, TXThe pilot misjudged the approach. Factors were the high density altitude, the downdraft, and the dteriorted climb performance.NTSB CHI91LA205Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Savoy, ILThe pilot's failure to maintain tail rotor clearance from the ground. A related factor is the pilot's lack of total experience in helicopters.NTSB ATL91LA122Accident · No injuriesLimited investigationFinal reportLearjet 23 · Columbia, TNThe pilot's premature decision to turn off the anti-skid during landing roll. Factors to this accident were hydroplaning conditions.NTSB ATL91LA121Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Lebanon, TNThe pilot's excessive touchdown speed, his failure to maintain a proper touchdown point, and his failure to execute a go-around when a safe landing could not be made. Factors in the accident were: the wet runway conditions at the airport and the crosswind…NTSB ANC91LA088Accident · No injuriesLimited investigationFinal reportCessna 170B · Cordova, AKThe pilot's failure to maintain directional control during the takeoff ground run and the intentional ground loop by the pilot. The crosswind was a factor in the accident.NTSB SEA91LA147Accident · No injuriesLimited investigationFinal reportLet L-13 · Driggs, IDThe pilot misjudged his distance and altitude to the runway during the approach and failed to attain the proper touchdown point for landing. His lack of experience in the make and model of glider was a related factor.NTSB NYC91LA162Accident · No injuriesLimited investigationFinal reportMaule M6-235 · Arcade, NYThe failure of the pilot to attain the proper lift-off speed during a takeoff on a grass runway, resulting in a loss of control and collision with power lines. A factor related to the accident was the pilot's lack of understanding of the airplane's…NTSB NYC91LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Nayville, NYFailure of the pilot to attain adequate airspeed to climb, which resulted in a stall/mush. The trees were a related factor.NTSB NYC91DFJ01Accident · 1 fatalFinal reportSterns Sterns Longster · Mayville, NYThe failure of the pilot to maintain airspeed, which resulted in a stall and spin at a low altitude. Also causal to the accident was the lack of experience of the pilot in this make and model airplane.NTSB LAX91LA284Accident · No injuriesLimited investigationFinal reportBeech E-55 · Bakersfield, CAThe pilot's improper use of the landing gear retraction by selecting gear up instead of flaps up during the landing roll-out. Contributing to the accident was the lack of familiarity with the airplane.NTSB DEN91LA095Accident · No injuriesLimited investigationFinal reportBell 412 · Grand Junction, COThe pilot's failure to maintain adequate main rotor RPM prior to touchdown. Factors were: the disconnected engine to transmission drive shaft and the inadequate inspection by company maintenance personnel.NTSB DEN91LA094Accident · No injuriesLimited investigationFinal reportCessna 172P · Watkins, COThe pilot's failure to maintain directional control of the aircraft. A factor was the pilot misjudging his flare.NTSB CHI91LA204Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Dexter, MIThe pilot's delay in aborting the landing. A factor in the accident was his excessive speed on final approach.NTSB BFO91FA061Accident · 1 fatalField investigationFinal reportMooney M20J · Waynesboro, VAThe pilots failure to maintain aircraft control which resulted in overstress of the airplane. Contributing was VFR flight into IMC and thunderstorms.