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 SEA91FA124Accident · No injuriesField investigationFinal reportBell 206BII · Brewster, WAThe pilot-in-command's selection of unsuitable terrain for the emergency simulation.NTSB SEA91LA136Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Wilson Creek, WAThe loss of engine power in flight due to improper overhaul of the carburetor float assembly fulcrum screw, shutting off fuel flow to the engine.NTSB SEA91LA127Accident · Serious injuriesLimited investigationFinal reportMaxair Ultralight · Toledo, WAThe pilot's inattentiveness. Factors were his performance of a low pass, and a transmission wire in his flight path.NTSB SEA91LA116Accident · Serious injuriesLimited investigationFinal reportGreg Smith KR-2 · Twisp, WAThe loss of engine power in flight due to shorted magneto wires, resulting from inadequate maintenance inspection by the pilot.NTSB SEA91FA119Accident · 2 fatalField investigationFinal reportStinson 108-2 · Gold Bar, WAThe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to remain clear of the obstacles (trees). The adverse weather condition (fog) was a related factor.NTSB SEA91LA109Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Malott, WAAn undetermined failure of the fuel pump casing resulting in an in flight fire and loss of engine power.NTSB SEA91LA107Accident · No injuriesLimited investigationFinal reportCessna 182A · Mead, WACarburetor ice and the pilot not using the carburetor hear. Factors to the accident were: carburetor icing conditions, and the pilot did not adequately evaluate the weather conditions.NTSB SEA91LA108Accident · No injuriesLimited investigationFinal reportLee Bede BD-4 · Elma, WAThe pilot did not maintain an adequate airspeed. Factors to the accident were: proper alignment was not maintained, inadequate remedial action, and the pilot did not identify a stall.NTSB SEA91LA103Accident · No injuriesLimited investigationFinal reportCessna 182N · Shelton, WAThe total loss of power due to mechanical failure when the pilot was over unsuitable terrain for a forced landing. Factors include a hard landing after an inadvertent stall prior to touchdown on a highway.NTSB SEA91LA102Accident · Minor injuriesLimited investigationFinal reportBoeing A-75 · Seattle, WAThe pilot did not maintain directional control during the landing roll. The factor to the accident was: the pilot's remedial action was inadequate.NTSB SEA91FA099Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Ravensdale, WAThe in-flight breakup of the airplane as a result of the pilot exceeding the speed and stress limits for the airplane. A factor relating to the accident was the center of gravity loading that exceeded the aft limits.NTSB SEA91LA100Accident · No injuriesLimited investigationFinal reportCessna A185F · Orting, WAThe pilot's failure to maintain directional control of the aircraft. Contributing to the accident was a vibration in the left main landing gear.NTSB SEA91LA093Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Elma, WAThe pilot used inadequate starting procedures. Factors to the accident were: the pilot did not use proper assistance and the passenger's inadvertent control interference.NTSB SEA91LA092Accident · Minor injuriesLimited investigationFinal reportSmelser KR-2 · Spokane, WAA failure of the fuel drain valve which resulted in fuel exhaustion and a loss of engine power.NTSB SEA91LA091Accident · 1 fatalLimited investigationFinal reportSchwartz Bushby MM-1 · Ephrata, WAThe pilot's loss of control after he initiated a maneuver at low altitude.NTSB SEA91LA090Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Auburn, WAAn improper fuel selector valve handle, improper selection of the fuel selector position, and the pilot's lack of understanding of the fuel selector position.NTSB SEA91FA089Accident · 2 fatalField investigationFinal reportCessna 150L · Mount Vernon, WAThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin at low altitude. His lack of experience was a related factor.NTSB SEA91LA086Accident · No injuriesLimited investigationFinal reportGrumman G-21A · Spokane, WAThe pilot-in-command did not maintain directional control of the airplane. Factors were: the pic's inadequate compensate for the wind, his limited flight expereince in this type of airplane, and the check airman's poor supervision.NTSB SEA91LA084Accident · No injuriesLimited investigationFinal reportCessna C-172N · Ellensburg, WAThe improper maintenance inspection of the airccraft. A factor relating to the accident was a ditch in the ladning area.NTSB SEA91LA083Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Port Orchard, WAThe loss of engine power due to contaminated fuel system.NTSB SEA91IA081Incident · Minor injuriesIncident investigationFinal reportBoeing 737-222 · Seattle, WATurbine blade failure from fatigue. Factors to the incident were inoperative engine fire extinguisher, inadequate service of aircraft and delayed deployment of emergency slide.NTSB SEA91LA079Accident · No injuriesLimited investigationFinal reportGrumman American AA-1C · Wenatchee, WACarburetor ice as a result of the pilot's improper use of carburetor heat.NTSB SEA91LA078Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Kent, WAThe pilot's inadequate remedial action to correct the imminent dynamic rollover. Factors to the accident were: the pilot's poorly planned approach and lack of totoal flight experience.NTSB SEA91LA077Accident · No injuriesLimited investigationFinal reportBell BH-47G2A · Waitsburg, WAThe improper installation of the main rotor mast nut and lock washer by maintenance personnel which resulted in the separation of the main rotor system.NTSB SEA91FA075Accident · 1 fatalField investigationFinal reportRobinson R-22 Beta · Seattle, WAThe loss of control in flight by the pilot due to his improper preflight preparation in failing to secure cargo which shifted in flight and interfered with the movement of the cyclic control stick.NTSB SEA91LA074Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Friday Harbor, WAThe pilot's failure to maintain a proper climb gradient and rate as a result of his inadequate compensation for wind conditions.NTSB SEA91FA076Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Chehalis, WAA loss of engine power due to an improper overhaul.NTSB SEA91LA070Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Everett, WAThe pilot did not maintain control of the airplane during the landing roll. Factors tot he accient were the pilot inadequately planned the approach, and uncontrolled ground-loop, and the pilot's lack of total experience in this type of aircraft.NTSB SEA91FA069Accident · 2 fatalField investigationFinal reportCessna 150G · Kennewick, WAImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel, and his failure to maintain adequate airspeed, while maneuvering to make a forced landing, which resulted in a stall.NTSB SEA91LA068Accident · No injuriesLimited investigationFinal reportCessna 140 · Pullman, WAThe pilot's encounter with wake turbulence shortly before touchdown, resulting in a hard landing.NTSB SEA91LA065Accident · No injuriesLimited investigationFinal reportCessna 172P · Seattle, WAA hard landing due to the pilot's midjudgement of his touchdown.NTSB SEA91LA063Accident · No injuriesLimited investigationFinal reportCessna 120 · Skykomish, WAThe pilot's failure to take appropriate remedial action after landing too FAR down the runway.NTSB SEA91LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Gig Harbor, WAThe pilot's failure to maintain directional control on the ground. Factors include wind gusts.NTSB SEA91FA061Accident · 3 fatalField investigationFinal reportCessna 172M · Bellingham, WAVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude and/or cleareance from the mountainous terrain. Factors related to the accident were: darkness and the adverse weather and terrain conditions.NTSB SEA91FA060Accident · 3 fatalField investigationFinal reportCessna 172N · Bellingham, WAVFR flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude and/or clearance from the mountainous terrain. Factors related to the accident were: darkness and the adverse weather and…NTSB SEA91LA056Accident · No injuriesLimited investigationFinal reportCessna 152 · Port Townsend, WAThe pilot's failure to maintain aircraft directional control during landing roll. Factors relating to the accident were the crosswind weather conditions and the soft terrain beside the runway.NTSB SEA91LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Monroe, WAThe pilot's selection of an unsuitable landing sute after making the decision to attempt a precautionary landing.NTSB SEA91LA052Accident · No injuriesLimited investigationFinal reportCessna 182Q · Anacortes, WAThe pilot improper planning/decisions. The high wind was a factor.NTSB SEA91LA045Accident · No injuriesLimited investigationFinal reportCessna C-150L · Alderwood Manor, WAThe failure of the pilot in command to attain proper clearance from terrain. A factor relating to this accident was the night light conditions.NTSB SEA91FA261Accident · No injuriesField investigationFinal reportBeech 35 · Walla Walla, WAImproper static balance of the ruddervators following rebuilding/repainting, which resulted in empennage flutter. Improper installation of the trim tabs and an encounter with turbulence were related factors.NTSB SEA91LA042Accident · No injuriesLimited investigationFinal reportBeech 58P · Chelan, WAThe pilot's failure to maintain directional control during landing roll. A factor was the patchy ice on the runway.NTSB SEA91FA039Accident · 1 fatalField investigationFinal reportCessna 140 · Port Orchard, WAThe pilot's failure to initiate an aborted takeoff at a time that left adequate runway remaining to bring the aircraft to a stop.NTSB SEA91LA035Accident · No injuriesLimited investigationFinal reportCessna 182-E · Anacortes, WAThe poor inflight decision by the PIC to land on a short grass airstrip in strong gusty tailwind conditions.NTSB SEA91LA034Accident · 1 fatalLimited investigationFinal reportBeech D50C · Snohomish, WAThe obstruction (protruding door support bracket) in the doorway of the aircraft; failure of the company/operator personnel, the pilot, and the skydivers to assure that the doorway was clear of obstructions; and subsequent snagging of the d-ring, which…NTSB SEA91LA030Accident · 1 fatalLimited investigationFinal reportRobinson Wenoso · Olympia, WAThe inadvertant stall/spin and loss of aircraft control by the pilot in command while performing aerobatic maneuvers.NTSB SEA91LA032Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Seattle, WAThe pilot's failure to maintain airspeed while on an instrument approach under instrument meteorlogical conditions, resulting in the aircraft stalling and enter a spin.NTSB SEA91FA027Accident · 5 fatalField investigationFinal reportAero Commander 690A · Ryderwood, WAThe pilot's improper inflight planning and failure to maintain proper altitude in mountainous terrain at night.NTSB SEA91FA025Accident · Serious injuriesField investigationFinal reportPiper PA31 · Enumclaw, WAFuel exhaustion due to inadequate preflight planning and preparations, and poor inflight planning and decisions. The pilot elected to fly into known adverse weather conditions, and did not calculate fuel consumption for the planned flight.NTSB SEA91LA022Accident · No injuriesLimited investigationFinal reportBeech 65-88 · Spokane, WAThe pilot's misjudgement of his touchdown due to disorientation caused by his lack of forward visibility created by an accumulation of ice on the windshield.NTSB SEA91LA018Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Bremerton, WAThe pilot did not maintain altitude.