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 SEA89LA112Accident · No injuriesLimited investigationFinal reportCessna TU206G · Las Vegas, NVThe loss of directional control as a result of gusting wind conditions.Jun 14, 1989 · N4769U · Substantial damageNTSB SEA89FA111Accident · Serious injuriesField investigationFinal reportOregon Helicopters UH-1L · Baring, WAFatigue failure of the tail rotor 42 degree gear box due to pilot induced overstress. Navy data and FAA type certificate limitations were not adhered to.Jun 14, 1989 · N157LC · DestroyedNTSB NYC89LA149Accident · No injuriesLimited investigationFinal reportCessna 180 · Pittsburgh, PALoss of control during landing rollout due to excessive application of brakes by the pilot.Jun 14, 1989 · N3420Y · Substantial damageNTSB MKC89LA133Accident · No injuriesLimited investigationFinal reportCessna 140 · Creve Ceour, MOThe failure of the pilot to plan the approach and maintain alignment with the sod landing strip. The pilot's innattention to the grass strip resulted in a landing in a soft wheat field.Jun 14, 1989 · N89316 · Substantial damageNTSB MKC89DCA01Accident · 1 fatalFinal reportPiper PA-25-235 · Auxvasse, MOThe pilot-in-command's failure to maintain adequate airspeed, resulting in an inadvertant stall.Jun 14, 1989 · N6579Z · DestroyedNTSB FTW89DPJ06Accident · No injuriesFinal reportPiper PA-18A · Eva, OKThe pilot's failure to maintain visual lookout. A factor was the pilot's limited visual perception due to the ground vehicle.Jun 14, 1989 · N6873B · Substantial damageNTSB DEN89LA136Accident · No injuriesLimited investigationFinal reportCessna 150M · Gooding, IDImproper inflight decision of the pilot to continue the flight without refueling which resulted in fuel exhaustion.Jun 14, 1989 · N704AS · Substantial damageNTSB SEA89LA107Accident · No injuriesLimited investigationFinal reportCessna 180F · Reno, NVThe pilot's failure to maintain directional control during landing.Jun 13, 1989 · N72WS · Substantial damageNTSB NYC89LA148Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Dillsburg, PAThe engine stoppage caused by the lack of engine lubricant.Jun 13, 1989 · N9953W · Substantial damageNTSB ATL89LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Jackson, TNThe separation of the mixture cable from the carburetor. Contributing factor(s) was: inadequate maintenance and inspection of the airplane and the soft terrain encountered during the forced landing.Jun 13, 1989 · N24451 · Substantial damageNTSB ANC89FA091Accident · No injuriesField investigationFinal reportde Havilland DHC-2 · Anchorage, AKFailure of the pilot to maintain directional control which resulted in an inadvertent ground swerve.Jun 13, 1989 · N11GA · Substantial damageNTSB SEA89LA110Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Chemult, ORImproper inflight planning/decision by the pilot, which resulted in a sudden altitude deviation, and his delay in initiating remedial action to maintain clearance from the trees. Contributing factors were the downdrafts, high density altitude, the pilot…Jun 12, 1989 · N1365E · DestroyedNTSB SEA89LA108Accident · No injuriesLimited investigationFinal reportCessna 170B · Gerlach, NVThe pilot displayed poor judgement by selecting unsuitable terrain for landing. As a result, the airplane nosed over during the landing roll on the soft terrain.Jun 12, 1989 · N2873C · Substantial damageNTSB SEA89LA106Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Longbranch, WAThe poor in-flight decision by the pilot to land on water, downwind. His failure to compensate for the wind conditions resulted in a loss of control and nose over of the airplane.Jun 12, 1989 · N39976 · Substantial damageNTSB NYC89FA146Accident · 1 fatalField investigationFinal reportCessna T210N · Hubbardston, MAFailure of both pilots to see-and-avoid (attain visual lookout for) conflicting traffic.Jun 12, 1989 · N212FS · 2 aircraft · Substantial damageNTSB CHI89LA107Accident · Serious injuriesLimited investigationFinal reportCessna 172I · New Era, MIThe pilot's misjudgement of the proper touchdown point.Jun 12, 1989 · N35561 · Substantial damageNTSB BFO89LA044Accident · No injuriesLimited investigationFinal reportCessna 172A · Madison Heights, VAStudent pilot's failure to maintain proper airspeed during the landing attempt which resulted in the initiation of a go-around. Contributing factors to the accident were the pilot's poor preflight planning and his becoming disoriented during the flight. Also…Jun 12, 1989 · N7605T · Substantial damageNTSB ANC89LA089Accident · No injuriesLimited investigationFinal reportCessna 150-L · Alexander River, AKThe failure of the pilot to land at the proper touchdown point and the resulting hard landing. Damage to the airplane precluded a go-around and resulted in the intentional swerve into a River to avoid injuries to people on the ground.Jun 12, 1989 · N1612Q · Substantial damageNTSB SEA89LA109Accident · No injuriesLimited investigationFinal reportCessna 177B · Minden, NVThe inadequate maintenance which caused a crack in the fuel pressure line leading into the carburetor.Jun 11, 1989 · N34211 · DestroyedNTSB SEA89FA104Accident · 1 fatalField investigationFinal reportAnderson BD-5 · Everett, WAInadequate maintenance by the pilot/owner/builder, his operation of the aircraft with a known deficiency, and his failure to maintain adequate airspeed during an emergency descent, which resulted in an inadvertent stall.Jun 11, 1989 · N13AT · DestroyedNTSB MKC89LA131Accident · No injuriesLimited investigationFinal reportGlaser-Dirks DG-101 · Stanton, MNFailure of the pilot to maintain control of the glider. Contributing factors were: improper use of flight controls by the pilot and his lack of total experience in the type of glider.Jun 11, 1989 · N83GB · Substantial damageNTSB FTW89LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Kaufman, TXStudent pilot inadvertently becoming lost/disoriented and exhausting the fuel in the fuel system.Jun 11, 1989 · N24258 · Substantial damageNTSB FTW89LA112Accident · Minor injuriesLimited investigationFinal reportSwift GC-1B · Luther, OKFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. The proximity of the trees were a factor.Jun 11, 1989 · N80791 · Substantial damageNTSB DCA89MA058Accident · 11 fatalMajor investigationFinal reportBeech H18 · Waipio Valley, HIThe pilot's improper in-flight planning/decision to maneuver with insufficient altitude over or in a a canyon area. Factors related to the accident were: the terrain conditions and scenic air tour's lack of specific direction to its pilots concerning safety…Jun 11, 1989 · N34AP · DestroyedNTSB CHI89LA108Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Cedar, MIPilot in command attempting to land with too high an aispeed and with insufficient runway remaining to allow either a go around or the ability to bring the airplane to a stop in the space remaining.Jun 11, 1989 · N151C · Substantial damageNTSB ATL89FA158Accident · 3 fatalField investigationFinal reportBalloon Works Firefly 8B · Garner, NCImproper planning/decision by the pilot, and his delay in initiating a climb as the Balloon converged on the tv tower.Jun 11, 1989 · N37141 · Substantial damageNTSB ATL89DKJ05Accident · Minor injuriesFinal reportHadley Teenie TWO · Guntersville, ALUndetermined. Factors related to the accident were: lack of a suitable landing area, high obstructions, and a dirt bank.Jun 11, 1989 · N8203 · DestroyedNTSB SEA89FA103Accident · 1 fatalField investigationFinal reportWhittaker Bushby Mustang 1 · Alderwood Manor, WAPilot's failure to maintain proper airspeed. Contributing factors were the pilot's poor judgement in flying a traffic pattern at tree-top level and a tailwind condition during the steep turn to final.Jun 10, 1989 · N8020E · DestroyedNTSB NYC89LA147Accident · Minor injuriesLimited investigationFinal reportPiper J-3C-65 · Erma, NJFailure of the pilot to maintain airspeed during a banner pickup.Jun 10, 1989 · N46286 · Substantial damageNTSB MIA89FA174Accident · 1 fatalField investigationFinal reportPiper PA-22-160 · St. Augustine, FLThe pilot failed to maintain airspeed during the turn to return to the airport, resulting in the loss of control. Contributing to the accident was his continued takeoff with intermittent engine power.Jun 10, 1989 · N9834D · Substantial damageNTSB MIA89FA173Accident · 2 fatalField investigationFinal reportCessna 170B · Sarasota, FLThe pilot's failure to maintain airspeed while maneuvering to spot cattle for a ground crew.Jun 10, 1989 · N3100B · DestroyedNTSB LAX89FA212Accident · 2 fatalField investigationFinal reportHughes 269C · Rainbow Valley, CAImproper planning/decision by the pilot and his inadequate visual lookout (failure to see and avoid the obstruction). Factors related to the accident were: the adverse weather conditions, the pilot's decision to fly in marginal VFR weather, and the…Jun 10, 1989 · N58323 · DestroyedNTSB FTW89LA111Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Austin, TXThe failure of the aircraft brake system. Factors include high tail wind.Jun 10, 1989 · N655A · Substantial damageNTSB DEN89LA137Accident · No injuriesLimited investigationFinal reportCessna 182 · Moab, UTFailure of the pilot to refuel the aircraft before the flight and company induced pressure by the company/operator management, which resulted in fuel exhaustion from a lack of fuel. The terrain conditions and the tree were considered to be contributing…Jun 10, 1989 · N92299 · Substantial damageNTSB ANC89LA088Accident · Minor injuriesLimited investigationFinal reportPiper PA-24 · Naked Island, AKEngine failure for an unknown reason.Jun 10, 1989 · N9213P · DestroyedNTSB ANC89LA087Accident · No injuriesLimited investigationFinal reportPiper PA-18-100 · Knik River, AKThe failure of the pilot-in-command to maintain control of the airplane on the ground by proper use of the flight controls during gusting winds.Jun 10, 1989 · N7291K · Substantial damageNTSB MIA89FA172Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Ashland, VAImproper go-around by the pilot by not maintaining a climb and obtaining proper altitude before turning. The pilot's poor approach and the trees were considered to be contributing factors.Jun 9, 1989 · N33320 · DestroyedNTSB FTW89LA110Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Midland, TXImproper planning/decision by the pilot, which resulted in a loss of aircraft control. The high, gusty, crosswind condition was a related factor.Jun 9, 1989 · N3937Z · Substantial damageNTSB DEN89LA135Accident · No injuriesLimited investigationFinal reportCessna 210 · Halls Crossing, UTInadequate aircraft handling by the pilot, resulting in a runway overrun.Jun 9, 1989 · N9515Y · Substantial damageNTSB CHI89LA106Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Elyria, OHFailure (shearing) of the right main gear attaching bolts. A contributing factor was: failure of the owner/operator to comply with service bulletin #673B.Jun 9, 1989 · N2529D · Substantial damageNTSB BFO89FA043Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Myersville, MDContinued flight by the pilot into instrument meteorological conditions (IMC) and his inability to maintain control of the aircraft after becoming spatially disoriented. Contributing factors were hilly/mountainous terrain, weather conditions, the pilot's lack…Jun 9, 1989 · N1499X · DestroyedNTSB SEA89LA105Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Skagway, AKThe failure of the pilot to use proper inflight planning to identify wind conditions (downdrafts) during the flight. As a result, the pilot was unable to maintain altitude and the airplane collided with mountainous terrain.Jun 8, 1989 · N7994F · Substantial damageNTSB CHI89DEC05Accident · Serious injuriesFinal reportJob Sonerai II · Fowlerville, MIThe pilot's discontinuing visual lookout to scan gages before clearing a known obstacle on the departure path from the runway. A factor in the accident is the pilot's lack of experience in this model airplane.Jun 8, 1989 · N288LJ · Substantial damageNTSB ANC89FA090Accident · 3 fatalField investigationFinal reportBellanca 17-30 · Near Fairbanks, AKImproper in-flight planning/decision by the pilot, and his failure to maintain sufficient altitude while entering a box canyon and/or crossing mountainous terrain in restricted weather condition. The terrain and weather were related factors.Jun 8, 1989 · CGLJM · DestroyedNTSB MKC89LA130Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Ft Leavenworth, KSThe student pilot's failure to maintain directional control of the aircraft during the landing roll. Contributing to the accident was the student's lack of total experience.Jun 7, 1989 · N9507D · Substantial damageNTSB MKC89LA129Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Wynne, ARUnsuitable terrain selected by the pilot. A contributing factor was the rough/uneven landing area.Jun 7, 1989 · N8063K · Substantial damageNTSB MKC89LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Pine Bluff, ARImproper in-flight planning/decision by the pilot by continuing the approach when the runway lights did not activate. Contributing factors were: dark night and soft terrain.Jun 7, 1989 · N63535 · Substantial damageNTSB DCA89RA056Accident · 174 fatalForeign investigationMcDonnell Douglas DC-8-62 · Paramaribo, SurinameJun 7, 1989 · N1809E · DestroyedNTSB CHI89DET07Accident · No injuriesFinal reportGood Varieze · Spencerville, INThe pilot's failure to maintain proper runway alignment during the soft field landing.Jun 7, 1989 · N79SG · Substantial damageNTSB SEA89LA101Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Vancouver, WAThe pilot's failure to maintain directional control during landing ground roll, resulting in a ground loop and nose over. The crosswind is considered to be a contributing factor to the accident.Jun 6, 1989 · N96202 · Substantial damage