# NTSB investigations, WA: Initial climb

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 11 · 509 cases

## Latest cases

- [NTSB WPR25LA308](https://openairdocs.org/ntsb/WPR25LA308.md): Thomas Graham Teenie Two · Chehalis, WA · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 11, 2025 · N311TS · Substantial damage
  > The pilot's improper decision to take off with the airplane over its maximum allowable gross weight, which degraded its climb performance and led to a subsequent off airport landing.
- [NTSB WPR25LA155](https://openairdocs.org/ntsb/WPR25LA155.md): Piper PA-18-150 · Enumclaw, WA · Accident · No injuries · Class 3 · Limited · Preliminary report · May 10, 2025 · N333TM · Substantial damage
  > On May 10, 2025, about 1412 Pacific daylight time, a Piper PA-18-150, N333TM, was substantially damaged when it was involved in an accident near Enumclaw, Washington. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR24FA103](https://openairdocs.org/ntsb/WPR24FA103.md): Cirrus Design SR22T · Bellevue, WA · Incident · No injuries · Class 3 · Field · Final report · Mar 6, 2024 · N927CS · Minor damage
  > A total loss of engine power due to a fatigue fracture of the crankshaft.
- [NTSB WPR24LA074](https://openairdocs.org/ntsb/WPR24LA074.md): Beck Michael J Sonex · Auburn, WA · Accident · No injuries · Class 3 · Limited · Final report · Jan 16, 2024 · N920MB · Substantial damage
  > Water contamination within the fuel regulator air-reference system, which resulted in improper fuel metering and a loss of engine power during initial climb.
- [NTSB WPR23LA086](https://openairdocs.org/ntsb/WPR23LA086.md): Quad City Challenger · Kent, WA · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 7, 2023 · N528J · Substantial damage
  > The 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 WPR22LA204](https://openairdocs.org/ntsb/WPR22LA204.md): Piper PA-32-300 · Snohomish, WA · Accident · No injuries · Class 3 · Limited · Final report · Jun 4, 2022 · N561PK · Substantial damage
  > The total loss of engine power during takeoff due to fuel starvation and the pilot’s improper fuel tank selection and inadequate preflight inspection.
- [NTSB WPR21LA307](https://openairdocs.org/ntsb/WPR21LA307.md): Cessna 170A · Metaline Falls, WA · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 6, 2021 · N5459C · Substantial damage
  > The pilot’s failure to attain sufficient altitude during the initial climb to clear trees due to an encounter with windshear.
- [NTSB WPR21LA213](https://openairdocs.org/ntsb/WPR21LA213.md): Piper PA-22-150 · Cashmere, WA · Accident · No injuries · Class 3 · Limited · Final report · May 31, 2021 · N7159B · Substantial damage
  > A total loss of engine power shortly after takeoff for reasons that could not be determined based on the available information.
- [NTSB WPR21FA170](https://openairdocs.org/ntsb/WPR21FA170.md): Consolidated Vultee BT-13A · Camas, WA · Accident · 1 fatal · Class 3 · Field · Final report · Apr 21, 2021 · N53331 · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during an aborted landing, resulting in an aerodynamic stall and impact with terrain.
- [NTSB WPR21LA015](https://openairdocs.org/ntsb/WPR21LA015.md): Cessna 152 · South Hill, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 15, 2020 · N6585L · Substantial damage
  > The pilot’s failure to ensure that the fuel supply had been completely drained of water, which resulted in a partial loss of engine power during takeoff due to water contamination.
- [NTSB WPR20LA229](https://openairdocs.org/ntsb/WPR20LA229.md): Costruzioni Aeronautiche Tecna P2004 Bravo · College Place, WA · Accident · No injuries · Class 3 · Limited · Final report · Jul 20, 2020 · N846JM · Substantial damage
  > The pilot’s premature retraction of the flaps which resulted in the airplane settling back onto the runway, contacting it hard, and veering off the runway.
- [NTSB WPR20LA215](https://openairdocs.org/ntsb/WPR20LA215.md): Cessna 150 · Port Orchard, WA · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 8, 2020 · N22393 · Substantial damage
  > The pilot's delayed decision to go around from an unstable approach, which resulted in insufficient airplane performance to climb above rising terrain and a subsequent aerodynamic stall.
- [NTSB WPR20LA180](https://openairdocs.org/ntsb/WPR20LA180.md): Bellanca 7KCAB · Renton, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 12, 2020 · N36339 · Substantial damage
  > Maintenance personnel’s inadequate post-maintenance inspections that resulted in the total loss of engine power due to a blockage in the air intake.
- [NTSB WPR20LA122](https://openairdocs.org/ntsb/WPR20LA122.md): Buckman Bucks Special · Prescott, WA · Accident · No injuries · Class 3 · Limited · Final report · Apr 9, 2020 · N9065F · Substantial damage
  > Diminished engine performance due to carburetor icing conditions and multiple mechanical anomalies that did not allow for the airplane to attain adequate airspeed during takeoff from a planted field and failure to maintain clearance from obstructions.…
- [NTSB WPR19FA133](https://openairdocs.org/ntsb/WPR19FA133.md): Just JA30 Superstol · Chelan, WA · Accident · 1 fatal · Class 2 · Field · Final report · May 6, 2019 · N825PW · Destroyed
  > The pilot’s exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and spin.
- [NTSB WPR19LA171](https://openairdocs.org/ntsb/WPR19LA171.md): Beech 35 · Deer Park, WA · Accident · No injuries · Class 3 · Limited · Final report · May 3, 2019 · N2839V · Substantial damage
  > An empennage flutter event for reasons that could not be determined based on the available information.
- [NTSB WPR18LA204](https://openairdocs.org/ntsb/WPR18LA204.md): Microlites Ptyltd Dragonfly B · Buckley, WA · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 19, 2018 · N7008Z · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB WPR18LA147](https://openairdocs.org/ntsb/WPR18LA147.md): Bell UH 1H · Olympia, WA · Accident · Serious injuries · Class 3 · Limited · Final report · May 25, 2018 · N111DR · Substantial damage
  > A loss of tail rotor thrust due to the improper installation of the tail rotor assembly by maintenance personnel resulted in the pilot’s inability to maintain control of the helicopter as he began transition into forward flight from a hover, which resulted in…
- [NTSB WPR17LA153](https://openairdocs.org/ntsb/WPR17LA153.md): Clark James T Vans RV8 · Spokane, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 14, 2017 · N559JC · Substantial damage
  > An inflight engine fire for reasons that could not be determined based on the available information, which melted the air filter element and obstructed the engine's air intakes, resulting in a total loss of engine power.
- [NTSB WPR17LA096](https://openairdocs.org/ntsb/WPR17LA096.md): Piper PA 32-260 · Mukilteo, WA · Accident · Minor injuries · Limited investigation · Final report · May 2, 2017 · N3457W · Substantial damage
  > The improper maintenance of the carburetor, which resulted in a stuck float and a partial loss of engine power during takeoff.
- [NTSB ENG17IA003](https://openairdocs.org/ntsb/ENG17IA003.md): Airbus A330 223 · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Oct 26, 2016 · N855NW · No damage
  > A No. 1 engine fire caused by a fuel manifold supply line high cycle fatigue crack which led to a fuel leak that subsequently ignited on hot engine case surfaces. The fatigue crack originated and progressed due to elevated fuel manifold assembly vibration…
- [NTSB WPR15FA268](https://openairdocs.org/ntsb/WPR15FA268.md): Cessna 150F · Port Townsend, WA · Accident · Serious injuries · Field investigation · Final report · Sep 28, 2015 · N8529G · Substantial damage
  > The loss of engine power due to the mechanic's inadequate tightening of the crankshaft gear retaining bolts during an engine overhaul, which resulted in fatigue failure of the bolts and the crankshaft gear dowel pin that allowed the crankshaft gear to…
- [NTSB WPR15LA235](https://openairdocs.org/ntsb/WPR15LA235.md): Cleveland Allan B Nieuport 11# · Bellingham, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 2015 · N917AB · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or anomalies that would have precluded normal operation.
- [NTSB GAA15CA175](https://openairdocs.org/ntsb/GAA15CA175.md): Cessna 150J · Renton, WA · Accident · Minor injuries · Data collection · Final report · Jul 9, 2015 · N12MM · Substantial damage
  > The pilot's failure to maintain adequate airspeed, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall/spin.
- [NTSB GAA15LA085](https://openairdocs.org/ntsb/GAA15LA085.md): Destiny 2000 · Eltopia, WA · Accident · Serious injuries · Limited investigation · Final report · May 23, 2015 · N3376 · Substantial damage
  > The flight instructor’s failure to tell the student pilot to abort the takeoff after the powered parachute experienced wing oscillations, which resulted in the student pilot’s loss of aircraft control during initial climb and subsequent impact with terrain.…
- [NTSB GAA15CA062](https://openairdocs.org/ntsb/GAA15CA062.md): Issoire Siren PIK 30 · Deer Park, WA · Accident · No injuries · Data collection · Final report · May 6, 2015 · N350BC · Substantial damage
  > A loss of lift, which precipitated a forced off airport landing, and collision with terrain.
- [NTSB WPR15LA167](https://openairdocs.org/ntsb/WPR15LA167.md): Beech F33A · Puyallup, WA · Accident · No injuries · Limited investigation · Final report · Apr 18, 2015 · N84MD · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of a mechanic’s failure to properly tighten the B-nut to the fuel pump inlet during a recent annual inspection. Contributing to the accident was the pilot's decision to take off despite…
- [NTSB WPR14FA393](https://openairdocs.org/ntsb/WPR14FA393.md): Tifft Kitfox III · Lake Stevens, WA · Accident · 1 fatal · Field investigation · Final report · Sep 27, 2014 · N307KF · Substantial damage
  > The pilot's failure to maintain airspeed during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the inability of the flight instructor to take control…
- [NTSB WPR14FA355](https://openairdocs.org/ntsb/WPR14FA355.md): Thomas C Sikes Loehle 5151 Mustang · Chehalis, WA · Accident · 1 fatal · Field investigation · Final report · Aug 27, 2014 · N73144 · Destroyed
  > The pilot’s failure to maintain adequate airspeed during initial climb, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall/spin. Contributing to the accident was that pilot’s psychiatric disease, which…
- [NTSB WPR14LA298](https://openairdocs.org/ntsb/WPR14LA298.md): Piper PA 30 · Othello, WA · Accident · No injuries · Limited investigation · Final report · Jul 17, 2014 · N7981Y · Substantial damage
  > The partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB WPR14FA286](https://openairdocs.org/ntsb/WPR14FA286.md): Cessna 182 · Fall City, WA · Accident · 1 fatal · Field investigation · Final report · Jul 8, 2014 · N5816B · Substantial damage
  > The pilot’s decision to depart in low-ceiling conditions and his continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.
- [NTSB WPR14CA254](https://openairdocs.org/ntsb/WPR14CA254.md): Maule MX 7-235 · Port Orchard, WA · Accident · No injuries · Data collection · Final report · Jun 20, 2014 · N5665A · Substantial damage
  > The pilot's delayed remedial action and failure to maintain directional control.
- [NTSB WPR14CA136](https://openairdocs.org/ntsb/WPR14CA136.md): Norman Quad City Challenger · Monroe, WA · Accident · No injuries · Data collection · Final report · Mar 13, 2014 · N345MN · Substantial damage
  > The pilot's inadequate construction of the propeller bracket, which resulted in its failure during the initial climb and the propeller subsequently departing the airplane.
- [NTSB WPR14CA019](https://openairdocs.org/ntsb/WPR14CA019.md): Robinson R44 - II · Sedro Woolley, WA · Accident · No injuries · Data collection · Final report · Oct 18, 2013 · N414CC · Substantial damage
  > The non-instrument rated pilot's inadvertent encounter with instrument meteorological conditions during initial climb and his improper decision to continue flight, which resulted in an in-flight impact with a tree and an emergency descent that resulted in a…
- [NTSB WPR12LA356](https://openairdocs.org/ntsb/WPR12LA356.md): Rockwell S2R · Royal City, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 14, 2012 · N8468V · Substantial damage
  > The loss of engine power due to the separation of the No. 2 cylinder exhaust rocker boss housing, which prevented the exhaust valve from opening.
- [NTSB WPR12LA277](https://openairdocs.org/ntsb/WPR12LA277.md): Rehn Kitfox IV · Vancouver, WA · Accident · 1 fatal · Limited investigation · Final report · Jun 27, 2012 · N645GR · Substantial damage
  > The pilot's failure to maintain airspeed during an attempt to return to the runway immediately after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was foreign debris in the right-hand carburetor bowl, which precipitated a loss…
- [NTSB WPR12LA051](https://openairdocs.org/ntsb/WPR12LA051.md): Piper PA-44-180 · Seattle, WA · Accident · Minor injuries · Limited investigation · Final report · Dec 1, 2011 · N2163N · Substantial damage
  > The flight instructor’s failure to maintain airplane control during a go-around.
- [NTSB WPR11LA223](https://openairdocs.org/ntsb/WPR11LA223.md): Czech Aircraft Works Spol Sro Sportcruiser · Arlington, WA · Accident · 1 fatal · Limited investigation · Final report · May 14, 2011 · N282SC · Substantial damage
  > The pilot’s failure to maintain control during the takeoff climb, which resulted in a stall at low altitude and collision with terrain. Contributing to the accident was the pilot’s impaired performance from over-the-counter medications.
- [NTSB WPR11LA209](https://openairdocs.org/ntsb/WPR11LA209.md): Cessna 182B · Colville, WA · Accident · No injuries · Limited investigation · Final report · Apr 23, 2011 · N8435T · Substantial damage
  > The partial loss of engine power during takeoff for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB WPR11CA196](https://openairdocs.org/ntsb/WPR11CA196.md): Cessna T188C · Palouse, WA · Accident · No injuries · Data collection · Final report · Apr 13, 2011 · N4562J · Substantial damage
  > The pilot's inadequate evaluation of the wind conditions at takeoff and failure to maintain an adequate airspeed, which resulted in a stall and collision with terrain during the initial climb.
- [NTSB WPR11LA095](https://openairdocs.org/ntsb/WPR11LA095.md): Piper PA-22-150 · Lopez, WA · Accident · No injuries · Limited investigation · Final report · Jan 9, 2011 · N5850D · Substantial damage
  > A loss of engine power during initial climb for undetermined reasons.
- [NTSB WPR10LA411](https://openairdocs.org/ntsb/WPR10LA411.md): Ercoupe 415 · Leavenworth, WA · Accident · Serious injuries · Limited investigation · Final report · Aug 18, 2010 · N2368H · Substantial damage
  > The pilot's failure to adequately evaluate the airport and its environment in relation to the aircraft’s performance, which resulted in the airplane's failure to attain sufficient altitude to clear trees during the initial climb.
- [NTSB WPR10FA384](https://openairdocs.org/ntsb/WPR10FA384.md): Cessna 172 · Roche Harbor, WA · Accident · Minor injuries · Field investigation · Final report · Aug 6, 2010 · N9730H · Substantial damage
  > The pilot’s failure to attain an adequate climb airspeed due to his use of flaps for takeoff, and his selection of a runway, which resulted in an uphill, and possibly downwind, takeoff and subsequent collision with a known obstacle. Contributing to the…
- [NTSB WPR10FA373](https://openairdocs.org/ntsb/WPR10FA373.md): Marshall CH601 HDS · Kapowsin, WA · Accident · 1 fatal · Field investigation · Final report · Jul 29, 2010 · N18295 · Substantial damage
  > The pilot’s failure to maintain adequate airspeed which resulted in a stall and loss of control during the initial climb.
- [NTSB WPR10LA374](https://openairdocs.org/ntsb/WPR10LA374.md): Lancair 320 · Spokane, WA · Accident · Minor injuries · Limited investigation · Final report · Jul 27, 2010 · N360N · Substantial damage
  > Loss of airplane control due to the asymmetric flap condition.
- [NTSB WPR10FA326](https://openairdocs.org/ntsb/WPR10FA326.md): Cessna 150 · Keller, WA · Accident · 1 fatal · Field investigation · Final report · Jul 6, 2010 · N1053M · Substantial damage
  > The student pilot’s failure to maintain clearance from obstacles during the initial climb.
- [NTSB WPR10LA313](https://openairdocs.org/ntsb/WPR10LA313.md): De Havilland DHC-1 · Port Orchard, WA · Accident · Minor injuries · Limited investigation · Final report · Jun 24, 2010 · N6540C · Substantial damage
  > A loss of engine power during initial climb due to water contamination in the fuel.
- [NTSB WPR09LA364](https://openairdocs.org/ntsb/WPR09LA364.md): Cessna 150H · Washougal, WA · Accident · Serious injuries · Limited investigation · Final report · Jul 24, 2009 · N22278 · Substantial damage
  > A loss of engine power during initial climb due to a stuck exhaust valve.
- [NTSB WPR09CA349](https://openairdocs.org/ntsb/WPR09CA349.md): Evektor-Aerotechnik Sportstar · Snohomish, WA · Accident · No injuries · Data collection · Final report · Jul 15, 2009 · N827EV · Substantial damage
  > A complete loss of engine power due to the failure of the airplane's engine-driven fuel pump.
- [NTSB WPR09CA329](https://openairdocs.org/ntsb/WPR09CA329.md): Nalis Glastar · Arlington, WA · Accident · No injuries · Data collection · Final report · Jul 5, 2009 · N432P · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of the pilot's failure to select the fullest tank prior to takeoff.

Next page: https://openairdocs.org/ntsb-phases/350/cases.md?state=WA&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 350)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/350/cases?state=WA

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.