NTSB investigations, WA
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 SEA95LA124Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Renton, WAThe pilot misjudged the flare.NTSB SEA95FA137Accident · 2 fatalField investigationFinal reportBeech A36 · Brinnon, WAThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain clearance from the terrain. Factors in the accident were the mountains and the clouds.NTSB SEA95LA122Accident · No injuriesLimited investigationFinal reportCessna 177B · Seattle, WAThe pilot's inadequate remedial action when he encountered porpoising after landing on the nosewheel.NTSB SEA95LA116Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Blakely Island, WAAn undetermined loss of engine power and suitable terrain was not available.NTSB SEA95LA107Accident · No injuriesLimited investigationFinal reportCessna 172B · Sinclair Island, WAThe pilot's failure to attain the proper touchdown point. Contributing to the accident were a tailwind, wet grass, and the pilot's inadequate remedial action.NTSB SEA95FA103Accident · 2 fatalField investigationFinal reportCessna 177RG · Kent, WAThe pilot's misjudgment of distance and altitude during the approach. Factors in the accident were the dusk light condition and the shadows.NTSB SEA95IA102Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Spokane, WAA shorted electrical wiring on the elevator trim system.NTSB SEA95LA099Accident · Minor injuriesLimited investigationFinal reportCessna 310K · Sequim, WAFailure of an undetermined aircraft component, which resulted in a severe vibration, and subsequent ditching at sea. A factor relating to the accident was: the pilot's low cruising altitude (over water) of less than 1,000 feet, which limited his ability to…NTSB SEA95LA098Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Vancouver, WACarburetor heat was not used and aircraft control was not maintained. Factors to the accident were: the flight instructor's diverted attention, and carburetor icing conditions.NTSB SEA95LA097Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Lamont, WAUndetermined loss of engine power and an inadequate autorotation.NTSB SEA95LA096Accident · No injuriesLimited investigationFinal reportCessna A185F · Oroville, WAWater contamination in the fuel, and the pilot's inadequate preflight of the aircraft before flight. Factors related to the accident were: deteriorated seal(s) on the fuel tank cap(s), non-compliance with an airworthiness directive to prevent water leaking…NTSB SEA95FA093Accident · 2 fatalField investigationFinal reportCessna 152 · Snoqualmie Pass, WAThe pilot's attempt to continue VFR flight into instrument meteorological conditions, and his failure to maintain clearance with the terrain.NTSB SEA95LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Twisp, WAThe improper installation of a nose landing gear assembly bolt (no cotter key installed) by unknown maintenance personnel. This led to a failure of the nose landing gear steering and subsequent noseover during landing rollout.NTSB SEA95LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Rice, WAThe pilot's failure to maintain the proper climb rate. A factor was trees in the flight path.NTSB SEA95LA084Accident · No injuriesLimited investigationFinal reportBaxter-Wilson CW CHAMP-3 · Forks, WALoss of engine power for undetermined reasons and the lack of suitable terrain for a forced landing.NTSB SEA95LA078Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Walla Walla, WATotal failure of the freewheeling sprag unit. A factor to the accident was: suitable terrain was not available for landing.NTSB SEA95LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Tacoma, WAFuel starvation due to an unlocked mixture control that had not been properly rigged. A factor was the ditch in the emergency landing area.NTSB SEA95LA083Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Cashmere, WALoss of engine power due to undetermined reasons. A factor contributing to the accident was rough terrain.NTSB SEA95IA082Incident · No injuriesIncident investigationFinal reportFairchild SA-227 · Pasco, WAImproper installation of the rudder trim actuator rod by company maintenance personnel which resulted in binding and fracture of the rod.NTSB SEA95FA079Accident · 1 fatalField investigationFinal reportCessna 182P · Index, WAthe pilot's continued flight into known adverse weather, and his improper use of carburetor heat. Factors include: weather conditions conducive to carburetor icing and airframe icing, airframe ice, and mountainous/hilly terrain in the area of the forced…NTSB ANC95GA048Accident · 1 fatalFinal reportCessna 182Q · Bumping Lake, WAA loss of engine power for an undetermined reason. Factors relating to the accident were: lack of suitable terrain for a forced landing in mountains, low ambient temperatures that contributed to hypothermia, the lack of survival equipment, an erratic ELT…NTSB SEA95LA074Accident · Serious injuriesLimited investigationFinal reportMirsepasy VAN'S RV-6A · Renton, WAThe pilot's failure to recover from the bounced landing, and his failure to maintain control of the airplane. Contributing to the accident was the pilot's failure to maintain an adequate descent rate toward the runway.NTSB SEA95LA073Accident · No injuriesLimited investigationFinal reportFleet 7 · Arlington, WAThe pilot-in-command's improper use of the brakes. A factor was the failure to maintain directional control during landing rollout.NTSB SEA95FA072Accident · 1 fatalField investigationFinal reportAeronca 7AC · Brush Prairie, WAUndetermined.NTSB SEA95LA061Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Forks, WAThe loss of power for undetermined reasons and the lack of suitable terrain for a successful forced landing.NTSB SEA95LA058Accident · No injuriesLimited investigationFinal reportMooney M20C · Omak, WAThe elevator push rod separation due to fatigue. Factors contributing to the accident were the pilot in command's failure to insure compliance with the airworthiness directive and the frozen push rod bearing.NTSB SEA95LA056Accident · No injuriesLimited investigationFinal reportPitts S-2B · Spokane, WAFatigue failure of the crankshaft. Factors were the soft terrain and the pilot/owner's failure to conduct recurring crankshaft inspections recommended by the manufacturer.NTSB SEA95LA055Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T34AG · Moses Lake, WAThe pilot-in-command's failure to maintain adequate altitude above the terrain. Factors include his diverted attention and attempted maneuver to avoid obstructions.NTSB SEA95LA051Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58JT · Marblemount, WAFatigue failure of the main rotor driveshaft.NTSB SEA95LA049Accident · No injuriesLimited investigationFinal reportCessna 180 · Camas, WAInadequate remedial action by the flight instructor after the student lost directional control.NTSB SEA95LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Seattle, WAThe pilot misjudging the flare. A factor to the accident was the tailwind.NTSB SEA95LA041Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Auburn, WACarburetor obstruction due to ingestion of part of the induction air ducting. A factor was the lack of suitable terrain for the forced landing.NTSB SEA95FA037Accident · 3 fatalField investigationFinal reportCessna 172N · Blyn, WAThe pilot's VFR flight into instrument meteorological conditions. Factors in the accident were the weather conditions and the dark night.NTSB SEA95LA024Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Auburn, WAThe pilot-in-command's not maintaining clearance from the power lines. A factor was the pilot-in-command's not maintaining the proper VASI glideslope.NTSB SEA95FA029Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Seattle, WAFuel exhaustion, and the pilot's failure to refuel en route. Factors include a dark night and ditching in the waters of puget sound.NTSB SEA95LA026Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Kent, WAFuel starvation due to the unporting of the useable fuel supply, and the pilot's failure to follow the airplane's published engine starting procedures after the loss of fuel flow during descent. Factors contributing to the accident are the pilot's lack of…NTSB SEA95LA022Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Twisp, WAAn unexplained loss of power and the student pilot's delayed application of collective during the landing flare.NTSB SEA95LA013Accident · No injuriesLimited investigationFinal reportHiller UH-12E4 · Morton, WAA leak in the fuel filler cap and water in the fuel system. A factor to the accident was: inadequate preflight.NTSB SEA95FA010Accident · 2 fatalField investigationFinal reportBeech 58 Foxstar · Shaw Island, WAFailure of the pilot to maintain adequate airspeed during takeoff and initial climb, which resulted in a stall and subsequent collision with the ground. Factors related to the accident were: darkness, the pilot's improper decision to take off on an unlighted…NTSB SEA95LA004Accident · No injuriesLimited investigationFinal reportMonocoupe 110 Special · Langley, WACorrosion and subsequent failure of the elevator hinge attach fitting weld. This allowed the elevator to bend and impinge upon the rudder, subsequently jamming it to the full right position and rendering the aircraft impossible to control.NTSB SEA94LA243Accident · No injuriesLimited investigationFinal reportCessna 172N · Orcas, WAThe pilot's improper landing flare.NTSB SEA94LA242Accident · Minor injuriesLimited investigationFinal reportCessna P206D · Lopez, WAA worn throttle control lever.NTSB SEA94LA241Accident · No injuriesLimited investigationFinal reportOestreich Avid Flyer MK IV · Moses Lake, WAProper descent rate was exceeded. Lack of total experience in type operation was a factor.NTSB SEA94LA231Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Paradise, WAProper altitude was not maintained and improper inflight planning/decision. Factors to the accident were mountainous/hilly terrain conditions and lack of total experience.NTSB SEA94LA230Accident · No injuriesLimited investigationFinal reportCessna 182B · Lummi Island, WAInadequate compensation for wind conditions. A factor to the accident was: tailwind.NTSB SEA94LA227Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Everett, WAThe pilot failed to maintain directional control.NTSB SEA94LA229Accident · No injuriesLimited investigationFinal reportBeech E-35 · Everett, WAThe nose gear extension assembly failure.NTSB SEA94LA220Accident · No injuriesLimited investigationFinal reportBeech 23 · Everett, WAThe student pilot's failure to maintain directional control, and his inadequate remedial action. Factors include a fence in the vicinity of the runway.NTSB SEA94FA221Accident · 1 fatalField investigationFinal reportChampion 7FC · Tacoma, WAPilot incapacitation due to a heart attack.NTSB SEA94LA217Accident · Minor injuriesLimited investigationFinal reportAllen D. Potts WAG-A-BOND · Benton City, WAFuel starvation and inadequate compensation for wind conditions. A factor to the accident was soft terrain.