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 SEA91FA019Accident · 1 fatalField investigationFinal reportCessna 206 · Pullman, WAThe pilot displayed inadequate inflight planning and decision making. Factors to the accident were: the weather was obscured, the dark night condition, and a proper altitude not maintained.NTSB SEA91LA015Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1C · Port Townsend, WAThe pilot's failure to use carburetor heat which resulted in a loss of engine power and a forced landing.NTSB SEA91LA013Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B Lama · Trout Lake, WAThe pilot's failure to maintain clearance from an obstacle.NTSB SEA91LA011Accident · No injuriesLimited investigationFinal reportCessna 172G · Anacortes, WAThe pilot poorly compensated for the wind condition.NTSB SEA91LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Pullman, WAThe student pilot's failure to maintain directional control.NTSB SEA91IA003Incident · No injuriesIncident investigationFinal reportCessna 551 · Elma, WAInadequate inspection of the electrical wire bundle assembly by maintenance personnel, and chafing/burning of the wire bundle.NTSB SEA91LA002Accident · No injuriesLimited investigationFinal reportBeech 58 · Seattle, WAThe pilot did not flare the airplane on landing. Factors related to the accident were: the pilot did not adequately recover from a bounced landing and the nose gear assembly failed in overload.NTSB SEA91LA001Accident · Serious injuriesLimited investigationFinal reportCessna T210K · Everett, WAA loss of engine power for undetermined reasons.NTSB SEA90LA199Accident · 2 fatalLimited investigationFinal reportCessna 172N · Neilton, WAThe failure of the crew to maintain adequate clearance from the terrain. Factors to the accident were mountainous and box canyon terrain.NTSB SEA90LA195Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Enumclaw, WAThe pilot did not maintain directional control of the airplane during the landing roll in gusting wind condition.NTSB SEA90LA189Accident · No injuriesLimited investigationFinal reportCessna TR182 · Everett, WAPilot did not maintained an adequate airspeed during the initial climb. The pilot failed to maintain directional control.NTSB SEA90GA180Accident · 1 fatalFinal reportBell 204B · Keller, WAThe total loss of engine power due to turbine blade separation while the pilot was operating in the aircraft at a gross weight that exceeded performance specifications for existing meteorological conditions. Factors include the failure or inability to…NTSB SEA90LA179Accident · No injuriesLimited investigationFinal reportCessna 182P · Lummi Island, WAThe pilot's failure to maintain directional control while applying brakes after landing.NTSB SEA90LA173Accident · No injuriesLimited investigationFinal reportCessna 172P · Granite Falls, WAThe pilot in command's use of excessive flaps for takeoff resulting in loss of climb performance.NTSB SEA90FA167Accident · 2 fatalField investigationFinal reportCessna 150-L · Newman Lake, WAThe pilot's poor judgement in attempting to land at an unlighted airstrip at night and his failure to maintain clearance from terrain during a go around.NTSB SEA90LA162Accident · 1 fatalLimited investigationFinal reportVaden SA102 Cavalier · Tumwater, WAThe pilot's failure to maintain airspeed during takeoff following an engine loss of power. The reason for the loss of power was not determined.NTSB SEA90LA160Accident · No injuriesLimited investigationFinal reportAlfred Stevens KEN Rand KR-2 · Ellensburg, WAThe pilot did not maintain a proper altitude above the terrain or visual lookout which resulted in a collision with a transmission wire.NTSB SEA90LA159Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Wenatchee, WAImproper installation of the oil filter gasket by maintenance personnel resulting in loss of engine oil and seizure of the engine.NTSB SEA90LA157Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Ellensburg, WAThe pilot did not adequately level off the helicopter and collided with the terrain.NTSB SEA90FA158Accident · Serious injuriesField investigationFinal reportAerospatiale SA315B · Cougar, WALoss of power due to contamination in the engine speed governor.NTSB SEA90LA155Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-65 · Chehalis, WAThe pilot's inadequate compensation for wind conditions. The gusty crosswind ws a related factor.NTSB SEA90TL#07Accident · Minor injuriesClass 3Final reportBoeing Vertol 107-11 · Leavenworth, WANTSB SEA90FA149Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Leavenworth, WAThe pilot's misjudgement in preflight planning when departing toward rising terrain. Contributing factors in this accident were his decision to attempt a climb-out with full flaps extended, and the minimal performance data available to him upon which he could…NTSB SEA90LA140Accident · No injuriesLimited investigationFinal reportRockwell S2R · Royal City, WAThe pilot's failure to ensure an adequate supply of fuel, which resulted in fuel exhaustion.NTSB SEA90LA138Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Darrington, WAThe inflight encounter with turbulent downdraft winds that resulted in a vertical descent from which the pilot could not recover with full power applied.NTSB SEA90LA136Accident · No injuriesLimited investigationFinal reportNorth American P-51 · Seattle, WAAn encounter with vortex turbulence while on final approach to landing.NTSB SEA90LA135Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Toutle, WAThe pilot's improper planning/decision by operating and maneuvering the heliocpter in a regime where he could not maintain rotor RPM. The high density altitude and rough terrain were related factors.NTSB SEA90LA132Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Bellingham, WACollision with a submerged object.NTSB SEA90LA131Accident · No injuriesLimited investigationFinal reportCessna TU206G · Roche Harbor, WAThe pilot's failure to maintain directional control after encountering unstable atmospheric conditions during final approach to landing.NTSB SEA90LA127Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Renton, WALoss of engine power due to fuel starvation. The cause of the accident was the pilot displayed poor inflight planning by not adequately following procedures or directives associated with fuel consumption.NTSB SEA90LA126Accident · Minor injuriesLimited investigationFinal reportHardesty/Hays Quickie Q2 · Twisp, WAThe pilot's failure to maintain directional control during the landing roll. Factors related to the accident were: the high weeds on the sides of the grass/dirt strip and the dirt berm.NTSB SEA90FA125Accident · Serious injuriesField investigationFinal reportCessna T210K · Everett, WAInadequate preflight by the pilot by not assuring that the rudder pedals were properly engaged. A factor related to the accident was: the pilot's lack of familiarity with this make and model of aircraft.NTSB SEA90LA124Accident · No injuriesLimited investigationFinal reportPiper J-2 · Concrete, WAThe pilot's improper planning/decisions and failure to maintain clearance from the trees.NTSB SEA90LA121Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Walla Walla, WAA loss of engine power for undetermined reasons.NTSB SEA90FA122Accident · 5 fatalField investigationFinal reportCessna T210L · Ashford, WAThe pilot's continuation of VFR flight into instrument meteorological conditions.NTSB SEA90FA115Accident · 1 fatalField investigationFinal reportAerospatiale AS350B · Glacier, WAPassenger did not follow the procedures associated with the operations in the vicinity of the helicopter.NTSB SEA90LA112Accident · No injuriesLimited investigationFinal reportCessna 177 · Hitchcock, WAThe pilot's loss of control of the airplane during final approach for landing. Sunglare was a factor related to the accident.NTSB SEA90LA108Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Dayton, WALoss of engine power for an undetermined reason.NTSB SEA90LA107Accident · No injuriesLimited investigationFinal reportRobert C. Campbell Quickie · Arlington, WAThe pilot did not maintain directional control of the airplane.NTSB SEA90LA104Accident · No injuriesLimited investigationFinal reportAerofab Lake LA-250 · Spokane, WAThe pilot was taxiing the airplane at an excessive speed which resulted in a loss of directional control.NTSB SEA90TL#03Accident · No injuriesClass 3Final reportBell UH-1B · Yakima, WANTSB SEA90LA106Accident · No injuriesLimited investigationFinal reportHughes 369HS · Randle, WAThe pilot failed to compensate for the wind conditions.NTSB SEA90LA103Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Tekoa, WAFailure of the pilot to maintain clearance between the airplane and tall grass adjacent to the gravel strip.NTSB SEA90LA099Accident · No injuriesLimited investigationFinal reportBriegleb BG-12B · Wenatchee, WAPilot's improper inflight planning which resulted in the aircraft undershooting the runway. Factors in the accident were the high, gusty wind conditions.NTSB SEA90FA171Accident · 3 fatalField investigationFinal reportLake LA-4 · Onalaska, WAImproper in-flight planning/decision by the pilot, and his inadvertent flight into instrument meteorological conditions (IMC). Factors related to the accident were: the adverse weather and terrain conditions.NTSB SEA90LA116Accident · No injuriesLimited investigationFinal reportEnstrom F28C · Camas, WAThe failure of a sprag clutch in the rotor-drive mechanism, at an altitude and position that precluded or limited the possibility of a successful outcome.NTSB SEA90LA094Accident · No injuriesLimited investigationFinal reportCessna A150M · Seattle, WAThe fuel starvation caused by carburetor contaminants blocking the accelerator pump inlet check valve assembly and main nozzle assembly.NTSB SEA90FA091Accident · 1 fatalField investigationFinal reportCessna 172K · Tacoma, WAThe pilot did not adequately maintain a proper glide path for landing which resulted in an inflight collision with a tree.NTSB SEA90LA092Accident · No injuriesLimited investigationFinal reportCessna 182A · Tekoa, WAThe pilot turned off the carburetor heat while descending for landing in conditions conducive to carburetor icing.NTSB SEA90LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA18 · Palouse, WAThe pilots poorly planned approach for landing.