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 FTW92LA225Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Victoria, TXBlocked engine assembly breather tube and the pilot's continued operation with known maintenance discrepancies. Factors were oil on windsheild and reduced visibility due to oil on the windscreen..Sep 18, 1992 · N46084 · Substantial damageNTSB DEN92FA093Accident · 1 fatalField investigationFinal reportCessna 172M · Evanston, WYLoss of control for undetermined reasons.Sep 18, 1992 · N9632H · DestroyedNTSB CHI92DCA05Accident · Serious injuriesFinal reportRettberg Rans S-7 · Charleston, MOThe pilot-in-command's poor weather evaluation which resulted in a takeoff into adverse weather conditions and a loss of airplane control.Sep 18, 1992 · N199KR · Substantial damageNTSB ANC92LA174Accident · No injuriesLimited investigationFinal reportPiper PA-18 · New Stuyahok, AKFuel system contamination by water and poor preflight inspection and preparation by the pilot in command. The lack of suitable terrain for an emergency float plane landing was a factor in this accident.Sep 18, 1992 · N226T · Substantial damageNTSB MIA92LA184Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Poplarville, MSA reported loss of engine power for undetermined reasons resulting in a forced landing and in flight collision with trees.Sep 17, 1992 · N8190K · Substantial damageNTSB LAX92LA392Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Columbia, CAThe failure of the student to maintain directional control of the aircraft during the low speed portion of the landing roll. A factor in the accident was the lack of brake pedals at the instructor's seat position on the right side of the cockpit.Sep 17, 1992 · N39087 · Substantial damageNTSB LAX92LA391Accident · No injuriesLimited investigationFinal reportBeech D17S · Reno, NVThe pilots failure to maintain directional control during landing rollout. Contributing to the accident was a variable tailwind condition and the soft, rough nature of the terrain.Sep 17, 1992 · N9465H · Substantial damageNTSB LAX92IA390Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-11 · Yuma, AZAn unstable interaction between the center body main landing gear and the brake system.Sep 17, 1992 · N90187 · Minor damageNTSB LAX92FA389Accident · 2 fatalField investigationFinal reportBeech 76 · Mount Shasta, CAThe pilot's improper en route decision to alter his course and to proceed over a mountainous area with inadequate altitude to clear the rising terrain.Sep 17, 1992 · N5269M · DestroyedNTSB CHI92FA280Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Pullman, MIThe pilot in command's exceeding the design stress limits of the aircraft.Sep 17, 1992 · N39652 · DestroyedNTSB CHI92FA279Accident · 4 fatalField investigationFinal reportCessna 177 · Manlius, ILThe pilot-in-command's failure to maintain control of the airplane during a forced landing, and his inadequate preflight which resulted in fuel exhaustion and power loss.Sep 17, 1992 · N30076 · DestroyedNTSB BFO92LA155Accident · No injuriesLimited investigationFinal reportTroy Bellah Rotorway Executive · Endicott, NYThe pilot did not attain the proper touchdown point.Sep 17, 1992 · N727TB · Substantial damageNTSB BFO92LA146Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Middle Bass, OHInadequate flare which resulted in a hard landing.Sep 17, 1992 · N7427J · Substantial damageNTSB BFO92LA142Accident · No injuriesLimited investigationFinal reportCessna 172N · Havre De Grace, MDThe pilot's improper use of carburetor heat control resulting in a total loss of engine power. Factors contributing to the accident include the existence of weather conditions conducive to carburetor icing and the rough terrain on which the aircraft was…Sep 17, 1992 · N7396E · Substantial damageNTSB SEA92LA205Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Lopez, WAThe pilot's faiure to obtain proper assistance and to properly set the throttle.Sep 16, 1992 · N21538 · Substantial damageNTSB SEA92LA204Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Packwood, WAThe improper in-flt planning and decision by the student pilot and his failure to maintain terrain clearance. Factors relating to the accident were the box canyon and the rising mountainous terrain.Sep 16, 1992 · N6419S · DestroyedNTSB MIA92LA182Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Belzoni, MSCollapse of the right main landing gear tire due to undetermined reasons.Sep 16, 1992 · N8906Q · Substantial damageNTSB MIA92FA183Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · New Hope, FLPoor in-flight planning and decision and failure of the pilot to maintain aircraft control.Sep 16, 1992 · N1083X · DestroyedNTSB LAX92LA387Accident · No injuriesLimited investigationFinal reportCessna 172RG · Casa Grande, AZThe loss of engine power for undetermined reasons.Sep 16, 1992 · N519PU · Substantial damageNTSB LAX92FA388Accident · 7 fatalField investigationFinal reportAerospatiale AS-350B · Hana, HIThe pilot inadequately evaluating the enroute weather conditions, and the pilot making the inflight decision to continue VFR flight into adverse weather conditions. Factors in this accident were the inability of the pilot to see and avoid the mountainous…Sep 16, 1992 · N350SM · DestroyedNTSB FTW92LA226Accident · No injuriesLimited investigationFinal reportBell 47-J2A · Booneville, ARThe pilot's failure to maintain adequate rotor RPM during autorotative landing. Factors were fuel exhaustion, the pilot's improper fuel consumption calculations, and the pilot not refueling the helicopter.Sep 16, 1992 · N291FW · Substantial damageNTSB ANC92LA173Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Kasilof, AKThe pilot in command's inadvertant power off stall entry resulting in the collision with the terrain.Sep 16, 1992 · N2464M · Substantial damageNTSB ANC92LA170Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot misjudged the weather conditions for float plane operations and failed to maintain control of the airplane during the takeoff run. Factors contributing to the accident were: high gusty winds, the pilot in command's lack of recent experience, and…Sep 16, 1992 · N1299C · Substantial damageNTSB ANC92LA169Accident · No injuriesLimited investigationFinal reportCessna 206 · Chena Marina, AKPilot in commands's poor preflight planning/preparation. Factors contributing to the accident were: lack of understanding of aircraft takeoff performance, lack of recency of PIC experience in type of operation, loss of aircraft performance takeoff…Sep 16, 1992 · N206RK · Substantial damageNTSB MIA92LA181Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Panacea, FLFailure of the nose landing gear push/pull rod end bearing for undetermined reasons.Sep 15, 1992 · N3791X · Substantial damageNTSB LAX92LA398Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Avalon, CAThe pilot's intentional flight at an altitude which provided insufficient clearance from the water.Sep 15, 1992 · N33SM · Substantial damageNTSB CHI92LA278Accident · No injuriesLimited investigationFinal reportCessna 172P · Yipslanti, MIThe pilot's premature flare during landing and not performing a recovery from a bounced landing.Sep 15, 1992 · N96593 · Substantial damageNTSB ATL92LA182Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Jasper, TNThe fractured valve which resulted in a total loss of engine power, while flying over terrain that was not suitable for a forced landing. A factor was the densely wooded, mountainous terrain.Sep 15, 1992 · N8005C · Substantial damageNTSB ATL92FA181Accident · 4 fatalField investigationFinal reportCessna 210B · Andrews, NCThe pilot's attempted takeoff in foggy conditions, and his failure to maintain aircraft control during the initial climbout, which resulted in an inadvertent stall and impact with terrain. Factors were the prevailing fog and the night lighting conditions.Sep 15, 1992 · N9622X · DestroyedNTSB ANC92T#A11Accident · No injuriesClass 3Final reportCessna 185 · Kotzebue, AKSep 15, 1992 · N9395N · Substantial damageNTSB ANC92LA171Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Totatlanika Rvr, AKThe pilot's poor inflight planning/decision in evaluating and selecting unsuitable terrain for the landing area. Factors contributing to the accident were: snow covered terrain, and the pilot's lack of recent experience in this type of operation.Sep 15, 1992 · N1148A · Substantial damageNTSB LAX92LA385Accident · No injuriesLimited investigationFinal reportRobinson R22 · Ojai, CAThe pilot's failure to maintain adequate main rotor RPM to cushion the landing. Contributing to the accident was the loss of engine power for undetermined reasons and the existing high density altitude.Sep 14, 1992 · N4079S · Substantial damageNTSB CHI92DTG06Accident · No injuriesFinal reportCessna 188B · Cogswell, NDLoss of engine power as a result of a complete piston failure.Sep 14, 1992 · N9747G · Substantial damageNTSB BFO92FA141Accident · 1 fatalField investigationFinal reportChampion 7KCAB · East Haddam, CTThe pilot's decision to attempt an aerobatic maneuver without adequate altitude for recovery.Sep 14, 1992 · N561EK · DestroyedNTSB ATL92LA184Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Powellsville, NCThe failure of the no.1 exhaust valve.Sep 14, 1992 · N6953Z · Substantial damageNTSB ATL92LA180Accident · No injuriesLimited investigationFinal reportCessna 320 · Darlington, SCThe improper servicing of the airplane with contaminated fuel by the owner pilot.Sep 14, 1992 · N5754X · Substantial damageNTSB ANC92LA172Accident · Minor injuriesLimited investigationFinal reportPiper PA-12-150 · Upper Yantarni, AKPilot in command inadvertant encounter with aerodynamic stall during low level approach turn. Factor affecting the accident was: the pilot's approach procedure/technique to fly VFR approach pattern at 50 feet AGL.Sep 14, 1992 · N2577M · Substantial damageNTSB SEA92LA198Accident · No injuriesLimited investigationFinal reportSlade H. Holmes SOL Kitfox II · Baker, ORThe engine seized and the airplane encountered unsuitable terrain during the forced landing.Sep 13, 1992 · N7057Y · Substantial damageNTSB SEA92FA197Accident · 4 fatalField investigationFinal reportCessna 170A · Lopez, WAThe pilot's inadvertent stall/spin. Factors include gusty, unfavorable, high velocity winds, and turbulence.Sep 13, 1992 · N9577A · DestroyedNTSB NYC92FA185Accident · 1 fatalField investigationFinal reportCessna 150F · Lake Neepaulin, NJAn inflight collision with trees after the pilot failed to outclimb the terrain. Factors related to the accident were the pilot's improper use of the flaps and the pilot's decision to operate the airplane over the maximum allowable gross weight.Sep 13, 1992 · N8725G · Substantial damageNTSB LAX92LA384Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 Beta · Colfax, CAThe pilot poor in-flight decision to fly at a low altitude and his inadequate visual look-out. The cable (static wire) contributed to this accident.Sep 13, 1992 · N649MB · Substantial damageNTSB DEN92LA092Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Greeley, COTotal loss of engine power due to a deteriorated carburetor float which resulted in engine flooding. A factor was: unsuitable terrain for a forced landing.Sep 13, 1992 · N5703E · Substantial damageNTSB CHI92LA277Accident · No injuriesLimited investigationFinal reportCessna 172N · Geneseo, ILThe pilot's attempted operation of the airplane with a known defficiency in the equipment.Sep 13, 1992 · N738KX · Substantial damageNTSB CHI92LA275Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Caledonia, MIFailure of the pilot in command to maintain directional control during a landing rollout.Sep 13, 1992 · UNREG · Substantial damageNTSB CHI92DEC04Accident · Serious injuriesFinal reportTennessee Engineering & Manf Z-MAX · Manchester, MIAn inadequate design of the rudder control system by the pilot/builder of the airplane, a pullup performed by the pilot, and a total failure of the rudder flight control system.Sep 13, 1992 · UNREG · DestroyedNTSB CHI92DCA04Accident · Serious injuriesFinal reportTinsman RV6 · Foristell, MOThe partial failure of the fuel injection system. Factors related to the accident are the pilot's insufficient altitude to reach the runway from the downwind leg, and the presence of transmission wires in the off airport landing site.Sep 13, 1992 · N42JT · Substantial damageNTSB BFO92LA147Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Rochester, MAThe pilot's abrupt application of the brakes which resulted in the airplane nosing over.Sep 13, 1992 · N1216B · Substantial damageNTSB BFO92LA139Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Shelbyville, KYAn improper flare made by the pilot resulting in a hard landing and main rotor blade tail boom strike.Sep 13, 1992 · N950SC · Substantial damageNTSB BFO92LA138Accident · No injuriesLimited investigationFinal reportPiper PA 22-150 · Greenville, METhe pilot's inadequate flare resulting in a hard landing.Sep 13, 1992 · N4319A · Substantial damageNTSB ANC92LA177Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · North Pole, AKPilot's decision to attempt takeoff without removing snow from aircraft surfaces. Factor related to the accident was the snow contaminated wing and other flight surfaces.Sep 13, 1992 · N3692Z · Substantial damage