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.

NTSB MIA94LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Osprey, FLUnsuitable terrain encountered during the forced landing following fatigue failure of the crankshaft during cruise flight.Jan 21, 1994 · N68411 · Substantial damageNTSB 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.Jan 21, 1994 · N777BE · DestroyedNTSB 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.Jan 21, 1994 · N6374M · Substantial damageNTSB BFO94LA033Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Georgetown, DEThe failure of ground personnel to maintain clearance from the engine propeller.Jan 21, 1994 · N95537 · No damageNTSB LAX94LA099Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Davis, CAwas that the pilot misjudged the airplane's altitude during the swath run.Jan 20, 1994 · N8649H · DestroyedNTSB 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.Jan 20, 1994 · N5795X · DestroyedNTSB 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.Jan 20, 1994 · N3211K · Substantial damageNTSB 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.Jan 20, 1994 · N123AH · Substantial damageNTSB BFO94LA028Accident · No injuriesLimited investigationFinal reportMitsubishi MU-3 · Teterboro, NJThe pilot selected unsuitable terrain for landing. The runway conditions were factors.Jan 20, 1994 · N306P · Substantial damageNTSB 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.Jan 20, 1994 · N6191N · Substantial damageNTSB FTW94IA070Incident · No injuriesIncident investigationFinal reportBoeing 737-2H4 · Little Rock, ARWas the landing gear separation due to an undetermined cause.Jan 19, 1994 · N53SW · Minor damageNTSB CHI94IA066Incident · No injuriesIncident investigationFinal reportBritish Aerospace ATP · South Bend, INan internal failure of the auxiliary power unit.Jan 19, 1994 · N857AW · No damageNTSB 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.Jan 18, 1994 · N77190 · Substantial damageNTSB 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.Jan 18, 1994 · N56811 · DestroyedNTSB 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.Jan 18, 1994 · N4558U · Substantial damageNTSB BFO94LA027Accident · Serious injuriesLimited investigationFinal reportCessna 425 · London, KYLoss of engine power due to fuel contamination.Jan 18, 1994 · N303MC · Substantial damageNTSB SEA94LA050Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Burns, ORThe student pilot in command's application of excessive braking during the landing roll.Jan 17, 1994 · N95169 · Substantial damageNTSB MIA94LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Boynton Beach, FLPartial loss of engine power for undetermined reasons.Jan 17, 1994 · N2338T · DestroyedNTSB 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.Jan 17, 1994 · N345KJ · Substantial damageNTSB 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.Jan 17, 1994 · N6574L · DestroyedNTSB 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.Jan 16, 1994 · N59528 · Substantial damageNTSB 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.Jan 16, 1994 · N193HC · Substantial damageNTSB 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.Jan 16, 1994 · N6522P · DestroyedNTSB 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.Jan 16, 1994 · N41826 · Substantial damageNTSB 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.Jan 16, 1994 · N930T · Substantial damageNTSB 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.Jan 16, 1994 · N69046 · Substantial damageNTSB ATL94LA039Accident · No injuriesLimited investigationFinal reportAir & Space 18A · Atlanta, GAA loss of control for undetermined reasons.Jan 16, 1994 · N6118S · Substantial damageNTSB 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.Jan 16, 1994 · N8994F · Substantial damageNTSB 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.Jan 15, 1994 · N1416R · DestroyedNTSB 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…Jan 15, 1994 · N86CE · DestroyedNTSB 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.Jan 15, 1994 · N5211V · Substantial damageNTSB BFO94LA024Accident · Serious injuriesLimited investigationFinal reportCessna P210N · New Castle, DELoss of partial engine power due to undetermined reasons.Jan 15, 1994 · N5088W · Substantial damageNTSB LAX94LA094Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Warner Springs, CAa loss of engine power for undetermined reasons.Jan 14, 1994 · N140KT · Substantial damageNTSB 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.Jan 14, 1994 · N1346P · Substantial damageNTSB 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.Jan 13, 1994 · N931KC · DestroyedNTSB 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.Jan 13, 1994 · N902BA · DestroyedNTSB LAX94LA093Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Rubidoux, CAthe pilot's inadequate compensation for the existing cross wind condition.Jan 13, 1994 · N8286K · Substantial damageNTSB 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.Jan 13, 1994 · N2974W · DestroyedNTSB 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.Jan 13, 1994 · N5329B · Substantial damageNTSB 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.Jan 13, 1994 · N8117Z · Substantial damageNTSB BFO94WA031Accident · Minor injuriesForeign investigationBeech BE-90 · FranceJan 13, 1994 · N46WA · DestroyedNTSB 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.Jan 12, 1994 · N8044Y · Substantial damageNTSB 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.Jan 11, 1994 · N82166 · Substantial damageNTSB 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.Jan 11, 1994 · N6323Q · Substantial damageNTSB 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.Jan 10, 1994 · N3999Z · Substantial damageNTSB 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.Jan 10, 1994 · N29404 · Substantial damageNTSB 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…Jan 10, 1994 · N5384W · DestroyedNTSB 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.Jan 10, 1994 · N4288L · Substantial damageNTSB 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.Jan 10, 1994 · N9355A · Substantial damageNTSB ATL94LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Jasper, ALLoss of engine power for undetermined reasons.Jan 9, 1994 · N14CL · Substantial damage