NTSB investigations, WA
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 WHERE c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA' 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 WHERE c."eventStateOrRegion" = 'WA' AND c."eventCountry" = 'USA' 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 SEA89LA146Accident · No injuriesLimited investigationFinal reportAbbott Gyroplane · Newport, WAThe pilot's selection of unsuitable terrain and the delay in aborting the takeoff.NTSB SEA89LA140Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Vashon, WAThe pilot's inadequate preflight planning/preparation. Factors related to the accident were: unfavorable wind conditions, high obstructions (trees), and soft terrain where the aircraft touched down during the aborted takeoff.NTSB SEA89LA136Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Albion, WAThe pilot failed to see and avoid a wooden utility pole while cruising at a low level. A contributing factor was the dusk light conditions.NTSB SEA89LA134Accident · No injuriesLimited investigationFinal reportMirsepasy 3Q2 · Arlington, WAFuel starvation due to a blocked fuel line which resulted in the pilot having to land on unsuitable terrain.NTSB SEA89LA128Accident · No injuriesLimited investigationFinal reportBell 206B · Longview, WAThe pilot inadvertently turning off the engine fuel supply instead of the external load fuel supply. Contributing to the accident was the pilot's failure to jettison the external load during the autorotation.NTSB SEA89LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Snoqualmie Pass, WAImproper in-flight planning/descision by the pilot, which resulted in the aircraft entering a box canyon with insufficient speed and altitude to maneuver out of the confined area. Factors related to the accident were: the pilot's continued flight into known…NTSB SEA89LA123Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Orchards, WAThe failure of the pilot to align the aircraft with the landing runway on touchdown and his failure to maintain directional control during landing ground roll, resulting in a ground loop.NTSB SEA89LA125Accident · No injuriesLimited investigationFinal reportMaule M4-210 · Lopez, WAThe pilot did not maintain directional control of the airplane during the landing roll.NTSB SEA89LA121Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Colfax, WAImproper installation of the cylinder assembly. The terrain was not suitable for a successful forced landing.NTSB SEA89LA120Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Centralia, WAThe pilot misjudged his clearance over trees, which resulted in an in-flight tail rotor strike with the trees and loss of tail rotor control. The trees were a related factor.NTSB SEA89LA119Accident · No injuriesLimited investigationFinal reportBeech B35 · Dallesport, WAThe premature rotatiion and liftoff by the pilot, which resulted in an inadvertent stall. A factor related to the accident was: the tailwind.NTSB SEA89FA118Accident · 1 fatalField investigationFinal reportColonial C-1 · Bremerton, WAMalfunction of both magnetos due to deterioration of the coils, which resulted in the loss of engine power. Factors related to the accident were: an inadequate airworthiness directive (no calendar time limits), and the lack of suitable terrain (rough/uneven)…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB SEA89FA099Accident · 2 fatalField investigationFinal reportCushing 4 · Mansfield, WAFailure of the left wing main spar due to overload for undetermined reasons.NTSB SEA89LA102Accident · No injuriesLimited investigationFinal reportBeech 19A · Cashmere, WAThe pilot used poor starting procedures. The airplane was inadequately secured resulting in a collision with an object when the airplane broke free of the tiedown ropes.NTSB SEA89LA098Accident · Serious injuriesLimited investigationFinal reportBell 47G-2 · Buena, WAThe pilot's failure to maintain an adequate visual lookout and clearance to avoid the power lines.NTSB SEA89LA093Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Black Diamond, WAPower loss due to magneto failure. Contributing to the accident were lack of suitable terrain for forced landing and the presence of obstacles.NTSB SEA89LA091Accident · Minor injuriesLimited investigationFinal reportPazmany PL-4A · Concrete, WAAn improper low pass and clearance with trees misjudged by pilot.NTSB SEA89LA089Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Copalis Beach, WAThe pilot's failure to perform the necessary preflight planning and preparation which resulted in the selection of unsuitable terrain for landing. Contributing to the accident was the soft sand bar.NTSB SEA89LA082Accident · No injuriesLimited investigationFinal reportCessna 172 · Woodland, WAThe pilot's poor planning and inadequate calculation of fuel consumption which resulted in fuel exhaustion.NTSB SEA89LA080Accident · Minor injuriesLimited investigationFinal reportMccoy Super Koala · Kelso, WAThe pilot's failure to adequately compensate for wind conditions, and the pilot's delay in initiating a go-around. Contributing to the accident were crosswind gusts, and lack of total pilot experience.NTSB SEA89LA079Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lacey, WAFailure of the pilot to maintain proper alignment during landing.NTSB SEA89LA078Accident · No injuriesLimited investigationFinal reportCessna 172 · Lynden, WAThe pilot delayed in aborting the landing and failed obtain or maintain sufficient airspeed to keep the aircraft from mushing after lift-off. Factors related to the accident were: obstructions near the approach end of the runway, failure of the pilot to…NTSB SEA89LA073Accident · No injuriesLimited investigationFinal reportDonner/Parton Avid Flyer · Stanwood, WAAn ignition lead became disconnected from one cylinder, which resulted in a partial power loss. A factor related to the accident was: soft terrain in the touchdown area.NTSB SEA89LA072Accident · No injuriesLimited investigationFinal reportBeech A55 · Arlington, WAA premature/improper retraction of the landing gear by the second pilot (aircraft owner), who was occupying the right front seat.NTSB SEA89FA068Accident · 2 fatalField investigationFinal reportLake LA-4-200-EP · Bellevue, WALoss of engine power for an undetermined reason and failure of the instructor pilot (CFI) to maintain control of the aircraft, which resulted in a stall/spin.NTSB SEA89FA186Accident · 1 fatalField investigationFinal reportAmerican AA-1A · Enumclaw, WAAttempted flight into known adverse weather conditions. Factors include clouds, downdrafts, high winds.NTSB SEA89LA065Accident · No injuriesLimited investigationFinal reportCessna 150K · Seattle, WAThe decision of a student pilot to continue to land the aircraft with a crosswind that exceeded his ability level.NTSB SEA89LA060Accident · No injuriesLimited investigationFinal reportCessna 180 · Tacoma, WAThe pilot's improper flare and improper recovery from the bounced landing. Contributing factors were the pilot's low total flight time and his inexperience in the Cessna 180 airplane.NTSB SEA89LA062Accident · No injuriesLimited investigationFinal reportCessna 185 · Everett, WAThe failure of the pilot to maintain directional control of the tailwheel aircraft during landing roll.NTSB SEA89LA059Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Rosalia, WAA loss of engine power due to a supercharger failure. Contributing to the accident was the soft terrain on which the forced landing was made.NTSB SEA89FA057Accident · 1 fatalField investigationFinal reportCessna T210L · Longmire, WAPhysical incapacitation of the pilot.NTSB SEA89LA067Accident · No injuriesLimited investigationFinal reportCessna TU206 · Anacortes, WAThe pilot diverted his attention during the landing, which resulted in an improper flare & hard landing. His lack of recent flying experience was a related factor.NTSB SEA89LA056Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Seabeck, WAA fatigue failure of the engine crankshaft. Contributing to the accident was the lack of suitable landing area.NTSB SEA89LA054Accident · No injuriesLimited investigationFinal reportCessna 185 · Bellingham, WAThe pilot's failure to compensate for the loss of lift due to ice accumulation on the wings, his failure to control the rate of descent, and poor inflight decision making. Contributing to the accident was the pilot's fatigue.NTSB SEA89LA061Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35J · Spokane, WAThe failure of the pilot to maintain directional control and runway alignment during the landing roll. Factors related to the accident were: light conditions at dawn, snow and ice on the runway, and the runway lights.NTSB SEA89LA044Accident · No injuriesLimited investigationFinal reportCessna 182 · N. Bonneville, WASome form of carburetor malfunction or failure which resulted in a loss of engine power. Contributing to the accident was the planned forced landing approach by the plt which resulted in the airplane landing short of the desired landing site.NTSB SEA89LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Puyallup, WAFailure on the part of the student pilot to maintain directional control of the aircraft. Contributing to the accident were poor approach and flare technique and lack of recent experience.NTSB SEA89IA042Incident · No injuriesIncident investigationFinal reportFairchild SA-227-AC · Seattle, WAInoperative nosewheel steering due to improper maintenance. Contributing to the incident was the lack of adequate maintenance information available in the aircraft manuals.NTSB SEA89LA037Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Port Townsend, WAImproper approach and flare technique on the part of the pilot, resulting in a hard landing. Contributing to the accident were tall trees surrounding the airstrip.NTSB SEA89LA038Accident · No injuriesLimited investigationFinal reportCessna 180A · Arlington, WAThe pilot attempted to hand-prop the engine without properly securing it.NTSB SEA89LA035Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Sekiu, WAPilot attempted a landing in adverse weather conditions, rather than postpone the business trip and return to origin or other safe area. Contributing to the accident were turbulence and gusty winds along with the self induced pressure to make the business flt.NTSB SEA89LA031Accident · No injuriesLimited investigationFinal reportBeech 99A · Spokane, WAAcft was left overnight in heavy precip. Plt failed to ensure fuselage drains were clear and water accumulation drained before departing into below freezing flight temps. On lndg at dest, plt unable to achieve flare, resulting in hard lndg. Investigation…NTSB SEA89LA025Accident · No injuriesLimited investigationFinal reportCessna 177RG · Monroe, WAPlt was lndg on unlit strip (center reflectors) at night and allowed acft to drift left on lndg roll. Acft contacted dirt mound adjacent to runway.NTSB SEA89FA021Accident · 2 fatalField investigationFinal reportCessna 335 · Arlington, WADrg a ngt arr, the plt was vectored for a LOC rwy 34 apch. After rchg the final apch fix/outer marker (om), he was clrd for the apch. Abt 5 or 6 min later, the ATC ctlr noticed the acft was aprx 7 mi nw of the arpt, climbing abv 3000' MSL. Missed apch…NTSB SEA89LA018Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Port Gamble, WAForeign national pilot was obtaining helicopter instruction. On solo flt to practice lndgs in unimproved terrain, touched down on stump with one skid and rolled over. Plt cited temporary pwr loss during approach. Investigation found no engine malfunction.