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 MIA94LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Osprey, FLUnsuitable terrain encountered during the forced landing following fatigue failure of the crankshaft during cruise flight.NTSB MIA94FA057Accident · 3 fatalField investigationFinal reportCessna 421C · Titusville, FLFailure of the pilot-in-command to maintain VMC resulting in the inflight loss of control. Contributing to the accident was the fatigue failure of a section of pipe adjacent to a flange which connects to the turbocharger oil outlet of the left engine assembly.NTSB FTW94LA072Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe student pilot's improper braking technique and the resultant failure to maintain directional control. A factor was the pilot not obtaining an ATC clearance prior to takeoff.NTSB BFO94LA033Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Georgetown, DEThe failure of ground personnel to maintain clearance from the engine propeller.NTSB LAX94LA099Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Davis, CAwas that the pilot misjudged the airplane's altitude during the swath run.NTSB LAX94FA100Accident · 2 fatalField investigationFinal reportAerospatiale AS-350D · Lebec, CAThe pilot-in-command's inadequate in-flight planning and inadequate visual lookout. Factors in the accident were mountainous terrain which masked the presence of the wires and the pilot-in-command's lack of familiarity with the geographic area.NTSB FTW94LA071Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Cascade, COThe pilot's improper in-flight planning which resulted in the aircraft's yaw performance being exceeded. A factor was the high density altitude.NTSB FTW94LA068Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Dallas, TXThe pilot's failure to attain the proper touchdown point. A factor was the pilot's disorientation and dark night conditions.NTSB BFO94LA028Accident · No injuriesLimited investigationFinal reportMitsubishi MU-3 · Teterboro, NJThe pilot selected unsuitable terrain for landing. The runway conditions were factors.NTSB ATL94LA041Accident · No injuriesLimited investigationFinal reportCessna T210N · Hayesville, NCThe fatigue failure of no. 2 exhaust valve which resulted from excessive heat and wear to the valve stem. A factor was the dark night.NTSB FTW94IA070Incident · No injuriesIncident investigationFinal reportBoeing 737-2H4 · Little Rock, ARWas the landing gear separation due to an undetermined cause.NTSB CHI94IA066Incident · No injuriesIncident investigationFinal reportBritish Aerospace ATP · South Bend, INan internal failure of the auxiliary power unit.NTSB SEA94FA051Accident · 1 fatalField investigationFinal reportCessna 140 · Lopez, WAThe pilot/owner's improper installation of the oil temperature sensing bulb, the total loss of all engine oil, and the shearing of a connecting rod cap.NTSB LAX94LA098Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Borrego Springs, CAThe pilot's intentional decision to abandon the airplane and allow it to fly unattended.NTSB FTW94LA067Accident · No injuriesLimited investigationFinal reportCessna 150D · Mount Pleasant, TXThe power loss due to carburetor icing and the pilot's delayed use of carburetor heat. Factors were the weather conditions and the lack of suitable terrain for the forced landing.NTSB BFO94LA027Accident · Serious injuriesLimited investigationFinal reportCessna 425 · London, KYLoss of engine power due to fuel contamination.NTSB SEA94LA050Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Burns, ORThe student pilot in command's application of excessive braking during the landing roll.NTSB MIA94LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Boynton Beach, FLPartial loss of engine power for undetermined reasons.NTSB LAX94LA097Accident · No injuriesLimited investigationFinal reportClunis Long EZ · Camarillo, CAthe pilot's improper use of the brake system which resulted in a failure of the right brake due to excessive heat glazing.NTSB ANC94FA029Accident · 1 fatalField investigationFinal reportPiper PA-18-160 · Palmer, AKLoss of engine power for undetermined reasons. A factor in the severity of the accident was the failure of the pilot-in-command to maintain control of the airplane when the engine ceased producing power.NTSB MIA94LA055Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Zellwood, FLInadvertent stall/spin by the pilot-in-command while executing a spiral to landing maneuver during the base to final turn.NTSB MIA94LA054Accident · No injuriesLimited investigationFinal reportRobinson R22B · Gurabo, PRComplete separation of one of the two vee-belts, and complete separation of 1/2 of the remaining belt. Contributing to the accident was the dark night condition and unsuitable terrain encountered during the autorotative landing.NTSB FTW94FA065Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Ratcliff, TXThe pilot failed to maintain control of the airplane and allowed it to exceed its design stress limits, which resulted in overload failure of the stabilators and right outboard wing section.NTSB BFO94LA026Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Middletown, OHA frozen oil line resulting in the starvation of oil to the engine and subsequent loss of engine power. A related factor was the unsuitable terrain for a forced landing.NTSB BFO94LA025Accident · No injuriesLimited investigationFinal reportBeech 33 · Poughkeepsie, NYThe partial loss of engine power due to undetermined reasons. Related to the accident was the lack of suitable terrain to complete a successful forced landing.NTSB ATL94LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Pelion, SCInadequate supervision by the instructor and inadequate compensation for wind conditions by the student pilot. The unfavorable wind condition for supervised solo landing training was a factor.NTSB ATL94LA039Accident · No injuriesLimited investigationFinal reportAir & Space 18A · Atlanta, GAA loss of control for undetermined reasons.NTSB ATL94GA038Accident · Serious injuriesFinal reportHughes 269C · Atlanta, GAThe inadvertent closing of the fuel shutoff valve by the pilot. A factor in the accident was the failure of the pilot to maintain rotor RPM during the autorotation.NTSB SEA94LA049Accident · Minor injuriesLimited investigationFinal reportGrumman American AA1B · Lacey, WAThe pilot in command's failure to attain the proper touchdown point. Factors contributing to the accident were tailwinds and wet terrain.NTSB MIA94FA053Accident · 1 fatalField investigationFinal reportBell 206L3 · Arcadia, FLThe pilot-in-command's improper supervision of an unqualified pilot while attempting a takeoff to a hover. This resulted in an on ground loss of control (dynamic roll over). The improper flight control input (cyclic and collective) by the unqualified pilot…NTSB LAX94LA095Accident · No injuriesLimited investigationFinal reportCessna T210L · California Valy, CAThe pilot's failure to maintain directional control of the aircraft and the instructor's inadequate supervision of the flight.NTSB BFO94LA024Accident · Serious injuriesLimited investigationFinal reportCessna P210N · New Castle, DELoss of partial engine power due to undetermined reasons.NTSB LAX94LA094Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Warner Springs, CAa loss of engine power for undetermined reasons.NTSB CHI94LA064Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Dowagiac, MIwas the pilot not maintaining directional control during the takeoff ground roll. Factors related to the accident were the icy, snow covered runway and poor preflight planning/preparation.NTSB MIA94LA051Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Miami, FLThe pilot-in-command's improper supervision of an unqualified pilot while maneuvering at a low altitude. This resulted in a loss in rotor rpm due to improper flight control input (upward collective pitch), and subsequent in-flight collision with terrain.NTSB MIA94LA050Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS-350 · Lakeland, FLThe pilot-in-command's failure to follow the emergency procedure in the flight manual for governor malfunction. Contributing to the accident was inadequate written procedures in the flight manual by the aircraft manufacturer.NTSB LAX94LA093Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Rubidoux, CAthe pilot's inadequate compensation for the existing cross wind condition.NTSB FTW94LA064Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB-180 · Colo. Springs, COAn inadvertent stall during initial climb following takeoff. A factor was failure by the pilot to maintain directional control.NTSB CHI94LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Casselton, NDthe student's failure to attain proper runway alignment and to maintain directional control. A factor related to the accident was the snow covered runway.NTSB CHI94LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Highland, INAn electrical system failure due to a fractured alternator mounting lug. Factors related to the accident were the rough terrain, and decreasing visibility due to snow and darkness.NTSB BFO94WA031Accident · Minor injuriesForeign investigationBeech BE-90 · FranceNTSB MIA94LA049Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Dorado, PRThe flight instructor's inadequate supervision of the student and failing to follow the procedures in the flight training guide.NTSB SEA94LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Missoula, MTThe pilot/passenger's failure to maintain directional control and the pilot in command's failure to properly supervise the landing.NTSB CHI94LA061Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Dekalb, ILwas an aborted takeoff not performed by the pilot-in-command. Factors related to the accident were the partial power loss for undetermined reasons and the continued operation of the airplane with a deficiency.NTSB NYC94LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Monticello, NYThe pilot allowed the speed of the airplane to get too slow, resulting in an inadvertent stall at too low an altitude to allow recovery.NTSB NYC94LA047Accident · No injuriesLimited investigationFinal reportAeronca 65-TL · Findley Lake, NYthe failure of a weld at the base of the landing gear which resulted in the failure of the left snow-ski assembly.NTSB LAX94LA091Accident · Serious injuriesLimited investigationFinal reportCessna P210N · San Martin, CAthe pilot's improper aircraft preflight inspection, and his failure to use pitot heat during the takeoff in icing conditions, which led to a blocked pitot tube. The blockage resulted in erroneous airspeed indications during the initial climb, which induced…NTSB FTW94LA069Accident · Serious injuriesLimited investigationFinal reportNelson Ford V-6 Stol 262 · San Benito, TXA partial loss of engine power with the cause undetermined. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA066Accident · No injuriesLimited investigationFinal reportCessna 195 · Watkins, COThe loss of directional control by the pilot rated passenger. A factor was inadequate supervision by the pilot in command.NTSB ATL94LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Jasper, ALLoss of engine power for undetermined reasons.