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 WPR23LA356Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Eatonville, WAThe pilot's failure to maintain directional control during the takeoff roll, in gusty wind conditions, which resulted in a runway excursion.NTSB WPR23FA351Accident · 1 fatalClass 3 · FieldFinal reportGolden Circle T Bird · Arlington, WAA failure of the forward left wing spar due to an improper repair, which resulted in an inflight separation of the left wing. Contributing to the accident was improper maintenance by splicing the wing spar.NTSB WPR23FA344Accident · 1 fatalClass 3 · FieldFinal reportSeawind 3000 · Bellevue, WAThe pilot’s loss of airplane control after encountering a lake swell and skipping during takeoff.NTSB WPR23LA339Accident · No injuriesClass 4 · LimitedFinal reportEurocopter France AS350B2 · Silverton, WAThe pilot’s failure to maintain visual reference and altitude while maneuvering over a lake during dusk conditions, which resulted in the helicopter impacting water.NTSB WPR23LA326Accident · No injuriesClass 4 · LimitedFinal reportHenry Steven J JA 30 Superstol · Leavenworth, WAThe pilot's failure to maintain airplane control during taxi, which resulted in a nose over.NTSB WPR23LA295Accident · Serious injuriesClass 3 · LimitedFinal reportFish Larry W Lancair 360 · Renton, WAA loss of electrical power due to low battery voltage, which resulted in an inflight shut down of the capacitor discharge ignition system and a loss of engine power. Contributing to the accident was the pilot’s failure to switch batteries after the electrical…NTSB WPR23LA294Accident · No injuriesClass 3 · LimitedFinal reportCessna 195 · Ravensdale, WAPartial loss of power for undetermined reasons. Contributing to the accident was the siphoning of fuel from the left-wing fuel filler port due to wear on the fuel filler cap.NTSB WPR23LA293Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Port Angeles, WAThe pilot’s inadequate fuel monitoring, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR23LA291Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Friday Habor, WAThe pilot’s loss of directional control during landing, which resulted in a ground loop.NTSB WPR23LA285Accident · Minor injuriesClass 3 · LimitedFinal reportMaule M-5-235C · Eastsound, WAThe pilot’s improper in-flight fuel management, which led to fuel starvation and a total loss of engine power.NTSB WPR23LA276Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Chelan, WAThe pilot's loss of directional control during the landing roll, which resulted in a ground loop and subsequent nose over.NTSB WPR23LA271Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-1 · Burlington, WAThe pilot’s failure to maintain directional control during the landing roll with a quartering tailwind.NTSB WPR23LA268Accident · No injuriesClass 4 · LimitedFinal reportVickers-Armstrong Spitfire IX · Deer Park, WAThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB WPR23LA248Accident · No injuriesClass 4 · LimitedFinal reportFound FBA2C · Moses Lake, WAThe pilot’s failure to maintain directional control during landing.NTSB WPR23LA273Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Metaline Falls, WAThe pilot’s loss of directional control during landing due to impact with a concrete ring embedded in the grass runway.NTSB WPR23LA231Accident · Minor injuriesClass 4 · LimitedFinal reportJohnson Gary L Fisher Horizon 1 · Chelan, WAThe pilot’s improper selection of a touchdown point and delayed recognition, which resulted in an impact with an obstacle.NTSB WPR23LA222Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Wishram, WAThe pilot’s improper fuel management, which resulted in fuel exhaustion and a total loss of engine power.NTSB WPR23LA215Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Belfair, WAThe total loss of engine power due to the fatigue failure of the crankshaft accessory drive gear.NTSB WPR23LA213Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Tacoma, WAA fatigue failure of the left main landing gear hydraulic actuator, which resulted in a loss of hydraulic fluid that prevented the pilot from lowering the landing gear to the fully extended position and maintaining directional control after landing.NTSB WPR23LA226Accident · No injuriesClass 3 · LimitedFinal reportCessna 310I · Sunnyside, WAThe failure of the side brace lock assembly of the right main landing gear due to overstress as a result of a hard landing.NTSB WPR23LA196Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172H · Seattle, WAA stuck exhaust valve that resulted in a partial loss of engine power and a forced water ditching.NTSB WPR23LA189Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Twisp, WAThe pilot’s loss of directional control during landing, which resulted in a runway excursion and ground loop.NTSB WPR23LA186Accident · Serious injuriesClass 3 · LimitedFinal reportAviat A-1C-180 Husky · Lakewood, WAAn erroneous landing gear warning that led to the pilot’s decision to abort the landing, which resulted in a collision with trees during a go-around.NTSB WPR23LA180Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Ariel, WAThe pilot’s failure to maintain aircraft control during the landing roll, resulting in a nose over.NTSB WPR23LA177Accident · No injuriesClass 3 · LimitedFinal reportCessna 210M · Pasco, WAImproper maintenance on the fuel outlet line to the fuel servo, which resulted in the line partially separating from the fuel outlet fitting and the subsequent fuel starvation and total loss of engine power.NTSB WPR23LA157Accident · No injuriesClass 3 · LimitedFinal reportBeech 95 · Bremerton, WAFailure of the down limit and down indicator switch and the warning horn switch assemblies, which prevented the landing gear from extending and at the same time providing a false indication that the landing gear was extended.NTSB WPR23FA143Accident · 1 fatalClass 3 · FieldFinal reportCessna T182T · Queets, WAThe pilot’s failure to maintain clearance from terrain for undetermined reasons.NTSB WPR23LA105Accident · No injuriesClass 4 · LimitedFinal reportHughes 269C · Yakima, WAThe pilot's failure to see and avoid a powerline while flying at low altitude over a river.NTSB WPR23LA101Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC18-180 · Dallesport, WAThe flight instructor’s failure to see and avoid a channel marker during a step taxi in preparation for takeoff on the water.NTSB WPR23LA089Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-C55 · Yelm, WAThe pilot’s failure to attain a proper touchdown point during landing with a tailwind which resulted in a runway over run. Contributing to the accident was a wet runway.NTSB WPR23LA086Accident · Serious injuriesClass 3 · LimitedFinal reportQuad City Challenger · Kent, WAThe pilot’s inflight loss of airplane control. Contributing to the accident was the pilot’s decision to fly the airplane without receiving training in its operation and flight characteristics.NTSB WPR23FA034Accident · 4 fatalClass 2 · FieldFinal reportTextron 208B · Snohomish, WAThe pilot’s improper recovery following a departure from controlled flight after an intentional aerodynamic stall, which resulted in an exceedance of airspeed limitations, airframe overstress, and a subsequent inflight breakup.NTSB WPR23LA042Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 180 · Kahlotus, WAThe pilot’s failure to check the fuel selector position before takeoff and his improper fuel management, which resulted in fuel starvation and a total loss of engine power. Also causal was the pilot’s loss of airplane control which resulted in an aerodynamic…NTSB WPR23LA026Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Puyallup, WAThe pilot’s inadequate fuel management that resulted in the loss of engine power due to fuel exhaustion.NTSB WPR23LA019Accident · No injuriesClass 4 · LimitedFinal reportProgressive Aerodyne SeaRey · Lake Isabel, WAThe pilot’s loss of airplane control after an encounter with windshear during takeoff which, resulted in a hard water landing.NTSB WPR23LA010Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Burlington, WAThe pilots improper landing flare and remedial action which resulted in a hard, bounced landing.NTSB WPR22LA360Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Lyman, WAThe pilot’s delayed decision to exit the valley with rising terrain and failure to maintain clearance from trees.NTSB WPR22LA353Accident · No injuriesClass 3 · LimitedFinal reportCessna 525B · Pasco, WAThe failure of the pilot to ensure the landing gear was extended before landing. Contributing was the pilot’s failure to fly a stabilized approach, and his configuration of the airplane that prevented activation of the landing gear not extended warning system…NTSB WPR22LA339Accident · Minor injuriesClass 3 · LimitedFinal reportBell 205A-1 · Cougar, WAThe helicopter’s encounter with downdrafts during a low-altitude hovering maneuver while dipping for water.NTSB DCA22MA193Accident · 10 fatalClass 1 · MajorFinal reportDehavilland DHC-3 · Freeland, WAThe in-flight unthreading of the clamp nut from the horizontal stabilizer trim actuator barrel due to a missing lock ring, which resulted in the horizontal stabilizer moving to an extreme trailing-edge-down position rendering the airplane’s pitch…NTSB WPR22LA374Accident · No injuriesClass 4 · LimitedFinal reportIca Brasov IS-28B2 · Deer Park, WAThe pilot’s improper landing flare which resulted in a hard landing.NTSB WPR22FA298Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Blyn, WAThe pilot’s continued operation of the airplane with known mechanical malfunctions with the flight displays, and his continued flight into instrument meteorological conditions, which resulted in an inflight collision with terrain while maneuvering.NTSB WPR22LA294Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-160 · White Salmon, WAThe pilot’s failure to attain a proper touchdown point, and his delayed decision to go around which, resulted in a collision with trees.NTSB WPR22LA263Accident · Serious injuriesClass 3 · LimitedFinal reportZenith CH701 · Bothell, WAA loss of engine power due to the fatigue failure of the engine’s flywheel screws that were likely overloaded when the engine was involved in a previous accident.NTSB WPR22FA255Accident · 1 fatalClass 3 · FieldFinal reportAeronca 7BCM · Lake McMurray, WAThe pilot’s decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of visual reference and subsequent controlled flight into terrain.NTSB WPR22LA272Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-60-601P · Scappoose, WAThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot’s failure to utilize a prelanding checklist.NTSB WPR22LA260Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Kelso, WAThe student pilot’s inadequate flare resulting in a loss of airplane control during landing with gusting wind conditions.NTSB WPR22LA245Accident · Serious injuriesClass 4 · LimitedFinal reportHiller UH-12E · Wenatchee, WAThe pilot’s failure to maintain clearance from power lines during low-level operations in light rain conditions.NTSB WPR22FA239Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-602 · Lind, WAThe pilot's exceedance of the airplane's critical angle of attack during a steep turn, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB WPR22LA247Accident · Serious injuriesClass 3 · LimitedFinal reportBeech H35 · LaCrosse, WAThe pilot’s failure to monitor and manage the fuel supply, which resulted in a loss of engine power due to fuel starvation.