NTSB investigations, WA
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 WPR10CA322Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · Sequim, WAThe pilot’s failure to maintain directional control during landing due to an encounter with sun glare.NTSB WPR10LA313Accident · Minor injuriesLimited investigationFinal reportDe Havilland DHC-1 · Port Orchard, WAA loss of engine power during initial climb due to water contamination in the fuel.NTSB WPR10CA290Accident · No injuriesData collectionFinal reportWaco UKC-S · Seattle, WAThe pilot’s inadequate compensation for the crosswind condition, resulting in a loss of directional control during the landing roll.NTSB WPR10CA283Accident · No injuriesData collectionFinal reportBell 47G-4A · Shaw Island, WAThe passenger's inadvertent movement of the mixture control during climb, resulting in a loss of engine power.NTSB WPR10FA277Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Spokane, WAA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation and the student pilot's failure to maintain main rotor rpm.…NTSB WPR10LA272Accident · No injuriesLimited investigationFinal reportEagle Eagle DW-1 · Waterville, WAA worn wire in the magneto system, which allowed intermittent grounding and a loss of engine power.NTSB WPR10CA257Accident · No injuriesData collectionFinal reportCessna 180A · Kettle Falls, WAThe pilot's failure to maintain clearance from obstacles during the landing roll. Contributing to the accident was the reduced visibility due to precipitation.NTSB WPR10CA246Accident · No injuriesData collectionFinal reportCessna 180K · Renton, WAThe pilot's inadequate compensation for the wind conditions, resulting in the loss of directional control during the landing roll.NTSB WPR10LA235Accident · No injuriesLimited investigationFinal reportBeech 35 · South Bend, WAA loss of engine power during takeoff for undetermined reasons, which resulted in a runway overrun.NTSB WPR10LA198Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. G-1159 · Seattle, WAThe failure of the pilot to maintain adequate clearance/distance from the fuel truck during taxi.NTSB WPR10LA196Accident · No injuriesLimited investigationFinal reportCessna P210N · Leavenworth, WAThe failure of the number two cylinder exhaust and intake valves for undetermined reasons, which resulted in a loss of engine power.NTSB WPR10LA182Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Anacortes, WAThe pilot’s inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR10FA163Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Morton, WAThe failure of maintenance personnel to properly secure a fitting cap on the throttle and metering assembly inlet after conducting a fuel system pressure check, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was…NTSB WPR10LA171Accident · No injuriesLimited investigationFinal reportCarr RV-4 · Arlington, WAThe failure of both main landing gear's drag link bolts in overstress and the subsequent collapse of the landing gear during landing rollout.NTSB WPR10LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Eliza Island, WAThe total loss of engine power during cruise flight due to the failure of maintenance personnel to tighten a fitting on the propeller governor oil line, which resulted in a loss of engine oil and catastrophic engine failure.NTSB WPR10CA167Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Okanogan, WAThe pilot's failure to maintain clearance from a fence at the end of the runway.NTSB WPR10CA151Accident · No injuriesData collectionFinal reportTarantola Leonard RV-6A · Onalaska, WAThe pilot's bounced landing on a soft turf runway, resulting in a collapsed nose landing gear.NTSB WPR10LA150Accident · Serious injuriesLimited investigationFinal reportMuffett Quickslvr Sprnt II · Buena, WAA loss of engine power due to fuel exhaustion as a result of the student pilot’s inadequate fuel planning.NTSB WPR10LA139Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Colfax, WAA partial loss of engine power due to carburetor ice as a result of the pilot's failure to use carburetor heat.NTSB WPR10CA132Accident · No injuriesData collectionFinal reportLeza Lockwood Air Cam · Everett, WAThe pilot's inadvertent encounter with the rotor downwash from a hovering heavy-lift helicopter.NTSB WPR10LA122Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Pullman, WAA partial loss of engine power during takeoff due to a bird's nest being sucked into the induction air ducting.NTSB WPR10LA103Accident · 2 fatalLimited investigationFinal reportLarson RV8 · Sequim, WAThe pilot's failure to maintain adequate airspeed while maneuvering in the traffic pattern, which resulted in an aerodynamic stall.NTSB WPR10CA099Accident · No injuriesData collectionFinal reportCessna 182J · Metaline Falls, WAThe pilot's decision to land on a closed, snow-covered runway.NTSB WPR10CA096Accident · No injuriesData collectionFinal reportStinson SR-8B · Auburn, WAThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR10LA091Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Camas, WAThe left magneto's broken p-lead, which led to the engine inadvertently starting while the pilot was turning the propeller by hand.NTSB WPR10LA090Accident · No injuriesLimited investigationFinal reportCessna 310 · Pasco, WAThe failure of the right main landing gear up-lock.NTSB WPR10CA073Accident · No injuriesData collectionFinal reportCessna 172M · Diamond Point, WAThe pilot's inadequate compensation for the variable and unfavorable wind conditions.NTSB WPR10LA069Accident · Serious injuriesLimited investigationFinal reportMahre Starduster SA300 · Zillah, WAThe pilot’s failure to maintain aircraft control during a low-altitude maneuver.NTSB WPR10FA223Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D1 · Skokomish, WAThe pilot's failure to maintain clearance from trees while flying over hilly, forested terrain.NTSB WPR10FA009Accident · 1 fatalField investigationFinal reportPiper PA-12 · Burlington, WAThe pilot's in-flight loss of control due to his failure to correctly connect the elevator control cables during the restoration/rebuild of the airplane. Contributing to this accident was the pilot's decision to perform a high-speed taxi test prior to having…NTSB WPR10CA008Accident · No injuriesData collectionFinal reportCessna 172P · Renton, WAThe failure of the student pilot to maintain directional control during the takeoff portion of a touch-and-go landing resulting in a collision with a sign.NTSB WPR09CA474Accident · No injuriesData collectionFinal reportCessna T182T · Granite Falls, WALanding in rugged terrain for undetermined reasons.NTSB WPR09CA473Accident · No injuriesData collectionFinal reportAviat A-1B · Toledo, WAThe pilot's failure to maintain clearance from a tree while taxiing. Contributing to the accident was the pilot's distracted attention.NTSB WPR09CA433Accident · No injuriesData collectionFinal reportSwalley Mark H CH 701 SP · Bremerton, WAThe pilot's inadequate compensation for the gusty wind conditions and failure to maintain aircraft control.NTSB WPR09LA423Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Ballard, WAThe pilot's precautionary water landing with partially extended landing gear. Contributing to the accident was the unidentified anomaly with the airplane's electrical system, which rendered the gear position indicator system inoperative.NTSB WPR09LA408Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tacoma, WAThe pilot's improper landing flare in crosswind conditions resulting in a gear leg collapse.NTSB WPR09CA416Accident · No injuriesData collectionFinal reportMorgan James E Morgan RV6 · Everett, WAThe pilot’s failure to maintain clearance from objects during taxi. Contributing to the accident was the inadequate marking of the taxiway and obstacles.NTSB WPR09CA403Accident · No injuriesData collectionFinal reportRockwell 690 · Wenatchee, WAThe pilot’s failure to maintain situational awareness, and thus clearance from objects, while operating at low altitude.NTSB WPR09LA390Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Eatonville, WAThe loss of engine power due to fuel starvation as a result of the pilot's inadequate in-flight fuel management. Contributing to the accident was the airplane's lack of an interconnected fuel vent system.NTSB WPR09LA371Accident · No injuriesLimited investigationFinal reportSikorsky S-55 · Chelan, WAFailure of a seal in the hydraulic system resulting in a loss of hydraulic pressure while maneuvering at low altitude.NTSB WPR09LA364Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Washougal, WAA loss of engine power during initial climb due to a stuck exhaust valve.NTSB WPR09CA368Accident · Minor injuriesData collectionFinal reportSchweizer SGU 2-22CK · Ephrata, WAThe premature launch signal given by the wing walker.NTSB WPR09CA363Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Metaline Falls, WAThe pilot’s failure, during the landing roll, to identify the end of the runway and stop the airplane within the space available.NTSB WPR09LA372Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Walla Walla, WAA tripped landing gear motor circuit breaker, which prevented the gear from fully locking in the down position, and subsequent collapse during landing. Contributing to the accident was the disabled landing gear warning horn.NTSB WPR09LA362Accident · 1 fatalLimited investigationFinal reportMooney M20C · Elma, WAA total loss of engine power during cruise flight due to the fatigue failure of the number 4 cylinder connecting rod.NTSB WPR09LA350Accident · Minor injuriesLimited investigationFinal reportBielawa Rotorway E · Sequim, WAThe failure (disbonding) of a composite main rotor blade for undetermined reasons, leading to an immediate loss of control in flight during hover.NTSB WPR09CA349Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Snohomish, WAA complete loss of engine power due to the failure of the airplane's engine-driven fuel pump.NTSB WPR09CA342Accident · No injuriesData collectionFinal reportMid-South Custom Craft SH-2R · Sequim, WAThe total loss of engine power due to fuel starvation as a result of the pilot's failure to reposition the fuel selector to the main tank. Contributing to the accident was the pilot's failure to properly complete the pre-takeoff checklist.NTSB WPR09CA338Accident · No injuriesData collectionFinal reportBell 206B · Burlington, WAThe pilot’s failure to maintain control of the helicopter while attempting to lift off from a trailer. The helicopter subsequently impacted the ground and rolled over.NTSB WPR09CA331Accident · Minor injuriesData collectionFinal reportBell 47G-3B-2 · Ocean Shores, WAThe pilot's failure to maintain clearance from the water while maneuvering due to the pilot's diverted attention.