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 IAD00LA056Accident · Minor injuriesLimited investigationFinal reportEnstrom F28C · Ravenna, OHthe student pilot's loss of helicopter control after suffering a stroke in flight.NTSB IAD00LA054Accident · Serious injuriesLimited investigationFinal reportRobinson R-22B · East North Port, NYThe pilot's failure to maintain adequate rotor RPM and failure to follow published recovery procedures after the low rotor RPM warning horn and caution light activated.NTSB FTW00LA197Accident · No injuriesLimited investigationFinal reportBushby Midget Mustang · Tulsa, OKThe in-flight separation of the propeller spinner. A factor was the lack of suitable terrain for the precautionary landing.NTSB FTW00LA191Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Godley, TXThe pilot's inadequate preflight planning and his delay in aborting the takeoff.NTSB DEN00IA133Incident · No injuriesIncident investigationFinal reportDiamond Aircraft Industries 20C-1 · Spanish Fork, UTThe company maintenance personnel's inadequate torquing procedures of the propeller attachment bolts which resulted in the fatigue failure of the propeller attachment bolts and the in-flight separation of the propeller.NTSB CHI00LA219Accident · No injuriesLimited investigationFinal reportMcCann Wheeler Express/FT · Fort Wayne, INthe obstructed brake pedals and the unavailable brakes to the pilot. Factors were the parked airplane and the fence.NTSB CHI00LA193Accident · No injuriesLimited investigationFinal reportSchleicher K8B · Manchester, MIthe downdraft experienced during final approach and altitude/clearance from the fence post not being maintained by the pilot. A factor to the accident was the fence post.NTSB CHI00LA179Accident · 1 fatalLimited investigationFinal reportNorton Volksplane VP-1 · Waconia, MNthe inadvertent stall by the pilot. The low attitude at the time of the stall was a contributing factor.NTSB ANC00FA081Accident · 1 fatalField investigationFinal reportCessna 337C · Marshall, AKThe pilot's attempted takeoff with known deficiencies in equipment (an inoperable rear engine) and an inadvertent stall. Factors associated with the accident were the pilot's improper retraction of the landing gear, his over confidence in the airplane's…NTSB SEA00LA119Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kennewick, WAA failure in the engine's number 1 piston, resulting in a total loss of engine power. Factors included the aircraft windshield being covered with oil (restricting forward visibility), a road sign, and a ditch beside the road on which the forced landing was…NTSB MIA00LA199Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Albany, GAThe dual student's failure to purge the fuel lines of air after a fuel tank was run dry on the previous flight and the failure of the electric fuel boost pump on or low position due to a loose wire which resulted in failure of the engine due to air in the…NTSB MIA00LA195Accident · No injuriesLimited investigationFinal reportCessna 402C · Naples, FLan inflight collision with a bird during descent that resulted in substantial damage to the airplane's vertical stabilizer spar.NTSB MIA00LA194Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Montgomery, ALthe student pilot's failure to maintain aircraft control upon encountering variable winds during the landing flare/touchdown and his failure to recover from the resulting bounced landing which resulted in substantial damage to the aircraft.NTSB LAX00LA247Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Chester, CAThe loss of engine power for undetermined reasons.NTSB DEN00LA129Accident · No injuriesLimited investigationFinal reportCessna 172N · Durango, COThe pilot prematurely flaring the airplane for landing, resulting in a hard landing, followed by an inadvertent pilot-induced porpoise and loss of directional control. A factor was the fence.NTSB CHI00LA211Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Saint Vincent, MNthe failure of the engine reduction gear assembly. Factors were the low altitude when the failure occurred and the crops.NTSB CHI00LA178Accident · 1 fatalLimited investigationFinal reportWeatherly 201C · Tolna, NDthe wing spar fatigue and wing separation while maneuvering. A factor was that the fatigue was not detected by the mechanic during the last annual inspection.NTSB SEA00LA118Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Bend, ORImproper preflight preflight planning/preparation by the pilot-in-command. Factors included a worn tailwheel tire and the VASI lighting system.NTSB MIA00LA193Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Winter Haven, FLthe flight instructor's failure to follow procedures/directives and his misjudgment of distance/altitude following a loss of engine power for undetermined reasons, which resulted in the proper touchdown point not being attained, an off airport landing being…NTSB LAX00LA245Accident · 1 fatalLimited investigationFinal reportGarlick HH-1K · Live Oak, CAThe inadequate lubrication of the tail rotor drive shaft coupling by unknown maintenance personnel that resulted in the in-flight failure and separation of the helicopter's tail boom.NTSB LAX00LA244Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Mayer, AZthe total loss of engine power resulting from the mechanic's failure to properly torque the connecting rod bolt nuts during engine overhaul.NTSB FTW00LA223Accident · No injuriesLimited investigationFinal reportEngineering & Research Ercoupe 415-CD · Abbeville, LAThe pilot's misjudged flare and improper recovery from a bounced landing. A factor was the crosswind condition.NTSB FTW00LA190Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Whitney, TXThe partial loss of engine power, which resulted from the worn carburetor.NTSB FTW00LA189Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-285 · Bovina, TXThe pilot's inadequate preflight planning, which resulted in the pilot exceeding the aircraft's takeoff performance. Factors were the high density altitude and the pilot's delayed load jettison.NTSB FTW00LA188Accident · No injuriesLimited investigationFinal reportCessna 172N · San Antonio, TXThe flight instructor's failure to refuel the airplane, which resulted in fuel exhaustion. Contributing factors were the flight instructor's fatigued condition and diverted attention.NTSB CHI00LA183Accident · No injuriesLimited investigationFinal reportCessna 150L · Griffith, INthe failure of the pilot to maintain clearance from the building during taxi.NTSB CHI00LA177Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Portland, NDthe pilot intentionally operated the airplane with known damage on the left wing which resulted in the pilot's inability to maintain control of the airplane during takeoff.NTSB CHI00LA176Accident · Minor injuriesLimited investigationFinal reportBeech B200 · Joliet, ILthe failure of the pilot to obtain fuel and the inadequate preflight planning and preparation by the pilot. Factors to the accident were the fuel exhaustion and the ravine at the end of the runway.NTSB SEA00LA117Accident · No injuriesLimited investigationFinal reportHughes 369D · Heyburn, IDFuel exhaustion and inaccurate fuel management. A false indication on the fuel quantity gage, and an erratic low level fuel warning system were factors.NTSB MIA00LA192Accident · No injuriesLimited investigationFinal reportEuropa Europa XS TRI-GEAR · Lakeland, FLthe flight instructor's inadequate supervision that resulted in the dual student performing an improper landing flare/touchdown which resulted in a hard landing and overload to the nose landing gear assembly.NTSB MIA00IA191Incident · No injuriesIncident investigationFinal reportDassault F2TH Falcon · Fort Lauderdale, FLthe fatigue failure of the rivets used to secure the inner casting forward static seal to the 1st-stage low-pressure turbine support/nozzle assembly. The failure of the rivets allowed the forward static seal to machine a groove into the 2nd-stage…NTSB LAX00LA242Accident · 1 fatalLimited investigationFinal reportWorldwide Aero AEROS-40B · San Bernadino, CAThe ground crew's diverted attention toward the landing airship while trying to catch a mooring rope, which resulted in their failure to detect an immenient collision with each other.NTSB FTW00LA194Accident · No injuriesLimited investigationFinal reportMooney M20R · Talihina, OKthe partial loss of engine power on takeoff, which resulted from incorrect adjustment of the fuel injector system by maintenance personnel.NTSB SEA00LA116Accident · Serious injuriesLimited investigationFinal reportDavis/Crouch Avid MK IV · Concrete, WAFracture of the engine's #1 connecting rod, resulting in a total loss of engine power. Factors were an engine overheat condition experienced at an undetermined time, and no suitable terrain for a forced landing.NTSB FTW00LA186Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hondo, TXThe fuel exhaustion due to the pilot's failure to refuel the airplane. A factor was the lack of suitable terrain for the forced landing.NTSB DEN00FA118Accident · 1 fatalField investigationFinal reportCessna 152 · Karval, COthe pilot's failure to maintain aircraft control while maneuvering. Contributing factors were the pilot's inadvertent flight into the clouds, and his becoming spatially disorientated.NTSB DEN00LA120Accident · No injuriesLimited investigationFinal reportNew Piper PA-46-350P · Spanish Fork, UTFailure by the pilot to maintain control of the aircraft during initial climb following takeoff.NTSB DEN00FA119Accident · 2 fatalField investigationFinal reportCessna 172H · Angel Fire, NMThe pilot's improper inflight decision to prematurely attempt a climb towards rising terrain before sufficient altitude had been attained that would assure adequate obstacle clearance. Factors were high density altitude and trees.NTSB CHI00LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Grant, MIthe pilot's failure to maintain control of the airplane which resulted in a stall/mush condition. Factors associated with the accident were the trees and gusty wind conditions which resulted in turbulence on takeoff.NTSB CHI00LA172Accident · No injuriesLimited investigationFinal reportCessna 172N · Canton, MIthe CFI delayed initiating a go-around during the landing. Factors associated with the accident were the student pilot's inadequate handling of the airplane, the crosswind condition, and the soft terrain on which the airplane touched down.NTSB ATL00LA068Accident · No injuriesLimited investigationFinal reportDouble D Enterprises Rans S-12 · Baneberry, TNThe pilot's inadequate compensation for wind conditions. Factors were the trees, and gusting winds.NTSB ANC00LA080Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nikiski, AKA bear running onto the landing area during the landing flare. A factor associated with the accident was the high vegetation on the edge of the airstrip.NTSB SEA00LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Ephrata, WAThe pilot-in-command's failure to maintain directional control during landing roll.NTSB NYC00LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Robbinsville, NJThe pilot's inadequate compensation for wind conditions, which resulted in a loss of aircraft control. A factor was a crosswind.NTSB LAX00LA243Accident · No injuriesLimited investigationFinal reportCessna A185F · Marana, AZthe pilot's excessive use of wheel brakes during the landing roll resulting in the airplane's nosing over.NTSB CHI00FA171Accident · 1 fatalField investigationFinal reportCessna 210J · Sumner, IAfailure of the pilot to maintain clearance with the terrain after flight into adverse weather. Contributing factors were the thunderstorms and lack of instrument certification by the pilot.NTSB FTW00LA185Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Mckinney, TXThe flight instructor's inadequate supervision of the landing resulting in the loss of directional control by the student pilot.NTSB DEN00LA116Accident · No injuriesLimited investigationFinal reportCessna 310C · Erie, COA sudden and unexpected encounter with a downdraft while on final approach. A factor was the transmission wire.NTSB CHI00WA175Accident · 3 fatalForeign investigationBeech V35B · Stromsnasbruk, SwedenNTSB CHI00LA173Accident · Minor injuriesLimited investigationFinal reportMcclish Funk B85C · Gardner, KSan improper modification to the engine which allowed a bearing to be misaligned, thus restricted the flow of oil through the engine. A factor associated with the accident was the wet field in which the forced landing was made.