# NTSB investigations, WA: Maneuvering

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 14 · 678 cases

## Latest cases

- [NTSB WPR26FA354](https://openairdocs.org/ntsb/WPR26FA354.md): Cessna 172B · Royal City, WA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 24, 2026 · N44P · Substantial damage
  > On September 23, 2026, about 1711 Pacific daylight time, a Cessna 172B, N44P, was substantially damaged when it was involved in an accident near Royal City, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ANC26LA098](https://openairdocs.org/ntsb/ANC26LA098.md): Pitts Model 12 · Lake Stevens, WA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Sep 7, 2026 · N491X · Substantial damage
  > On September 6, 2026, about 1800 Pacific daylight time, an experimental Pitts Model 12 airplane, N491X, was substantially damaged when it was involved in an accident near Lake Stevens, Washington. The pilot sustained serious injuries. The airplane was…
- [NTSB WPR26LA275](https://openairdocs.org/ntsb/WPR26LA275.md): Czech Aircraft Works Mermaid Skeeter 2 · Cougar, WA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 22, 2026 · N42SK · Substantial damage
  > On July 22, 2026, about 1129 Pacific daylight time, an experimental amateur built Czech Aircraft Works Mermaid Skeeter 2 airplane, N42SK, was substantially damaged when it was involved in an accident near Cougar, Washington. The pilot was seriously injured.…
- [NTSB WPR26FA233](https://openairdocs.org/ntsb/WPR26FA233.md): Cessna 195 · Pasco, WA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 24, 2026 · N3877V · Substantial damage
  > On June 24, 2026, about 1428 Pacific daylight time, a float equipped Cessna 195, N3877V, was substantially damaged when it was involved in an accident near Pasco, Washington. The pilot and passenger were fatally injured. The airplane was operated under Title…
- [NTSB WPR25FA294](https://openairdocs.org/ntsb/WPR25FA294.md): Cessna 172F · Battle Ground, WA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 26, 2025 · N8219U · Destroyed
  > On September 26, 2025, about 1306, Pacific daylight time a Cessna 172F, N8219U, was destroyed when it was involved in an accident near Battle Ground, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR25LA290](https://openairdocs.org/ntsb/WPR25LA290.md): Eurocopter EC135 · Whittier, WA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 24, 2025 · N955AL · Substantial damage
  > On September 23, 2025, at 2303 Pacific daylight time, a Eurocopter EC-135 T2+, N955AL, was substantially damaged when it was involved in an accident near Whittier, Washington. The pilot and three medical crew members received minor injuries. The helicopter…
- [NTSB WPR25LA246](https://openairdocs.org/ntsb/WPR25LA246.md): Hiller UH-12E · Fobes Hill, WA · Accident · No injuries · Class 4 · Limited · Final report · Aug 11, 2025 · N703WA · Substantial damage
  > The pilot’s abrupt maneuver to avoid a powerline during an aerial application flight, which resulted in the helicopter’s impact with terrain.
- [NTSB WPR25LA216](https://openairdocs.org/ntsb/WPR25LA216.md): Cessna 172 · Concrete, WA · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 20, 2025 · N6964A · Substantial damage
  > The pilot’s failure to maintain clearance from powerlines, which resulted in a wire strike.
- [NTSB WPR24FA298](https://openairdocs.org/ntsb/WPR24FA298.md): Boeing A75L3 · Yacolt, WA · Accident · 1 fatal · Class 3 · Field · Final report · Sep 6, 2024 · N53466 · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at a low altitude in mountainous terrain in moderately high density altitude conditions, resulting in an aerodynamic stall and subsequent impact with terrain.
- [NTSB WPR24FA184](https://openairdocs.org/ntsb/WPR24FA184.md): Beech A45 · Deer Harbor, WA · Accident · 1 fatal · Class 3 · Field · Final report · Jun 7, 2024 · N268AF · Substantial damage
  > The pilot’s decision to perform an aerobatic maneuver at low level, and his misjudged entry altitude for the maneuver, which resulted in impact with water.
- [NTSB WPR24LA173](https://openairdocs.org/ntsb/WPR24LA173.md): Sikorsky S-55QT · Benton City, WA · Accident · No injuries · Class 4 · Limited · Final report · Jun 3, 2024 · N2302F · Substantial damage
  > The pilot’s failure to maintain clearance from power lines during a low altitude operation.
- [NTSB WPR24LA139](https://openairdocs.org/ntsb/WPR24LA139.md): Robinson Helicopter R22 Beta · Olympia, WA · Accident · Minor injuries · Class 3 · Limited · Final report · May 3, 2024 · N4082J · Substantial damage
  > The flight instructor’s delayed action to arrest the descending, left pedal turn while maneuvering for a low-altitude hover with the helicopter near the maximum gross weight limitation, which resulted in an impact with the ground and a dynamic rollover.
- [NTSB WPR24LA113](https://openairdocs.org/ntsb/WPR24LA113.md): Kitfox S7 Super Sport · Asotin, WA · Accident · Minor injuries · Class 4 · Limited · Final report · Mar 16, 2024 · N295P · Substantial damage
  > Pilot’s failure to maintain clearance from powerlines during low altitude flying.
- [NTSB WPR24LA039](https://openairdocs.org/ntsb/WPR24LA039.md): Cessna 150M · Woodland, WA · Accident · No injuries · Class 3 · Limited · Final report · Nov 18, 2023 · N6266K · Substantial damage
  > The flight instructor’s inadequate preflight planning, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB WPR24LA009](https://openairdocs.org/ntsb/WPR24LA009.md): Stephen D Phillabaum Helicycle · Deer Park, WA · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 1, 2023 · N519SP · Substantial damage
  > A loss of engine power due to fuel starvation resulting from contamination of the fuel system during low-level flight.
- [NTSB WPR23FA351](https://openairdocs.org/ntsb/WPR23FA351.md): Golden Circle T Bird · Arlington, WA · Accident · 1 fatal · Class 3 · Field · Final report · Sep 22, 2023 · UNREG · Substantial damage
  > A 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 WPR23LA339](https://openairdocs.org/ntsb/WPR23LA339.md): Eurocopter France AS350B2 · Silverton, WA · Accident · No injuries · Class 4 · Limited · Final report · Sep 9, 2023 · N350WW · Substantial damage
  > The 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 WPR23LA105](https://openairdocs.org/ntsb/WPR23LA105.md): Hughes 269C · Yakima, WA · Accident · No injuries · Class 4 · Limited · Final report · Feb 6, 2023 · N7452F · Substantial damage
  > The pilot's failure to see and avoid a powerline while flying at low altitude over a river.
- [NTSB WPR23FA034](https://openairdocs.org/ntsb/WPR23FA034.md): Textron 208B · Snohomish, WA · Accident · 4 fatal · Class 2 · Field · Final report · Nov 18, 2022 · N2069B · Substantial damage
  > The 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 WPR22LA360](https://openairdocs.org/ntsb/WPR22LA360.md): Cessna 150L · Lyman, WA · Accident · No injuries · Class 4 · Limited · Final report · Sep 25, 2022 · N7471G · Substantial damage
  > The pilot’s delayed decision to exit the valley with rising terrain and failure to maintain clearance from trees.
- [NTSB WPR22LA339](https://openairdocs.org/ntsb/WPR22LA339.md): Bell 205A-1 · Cougar, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 7, 2022 · N66HJ · Substantial damage
  > The helicopter’s encounter with downdrafts during a low-altitude hovering maneuver while dipping for water.
- [NTSB WPR22FA298](https://openairdocs.org/ntsb/WPR22FA298.md): Cirrus Design SR22 · Blyn, WA · Accident · 1 fatal · Class 3 · Field · Final report · Aug 10, 2022 · N379DH · Substantial damage
  > The 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 WPR22LA245](https://openairdocs.org/ntsb/WPR22LA245.md): Hiller UH-12E · Wenatchee, WA · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 6, 2022 · N130HA · Destroyed
  > The pilot’s failure to maintain clearance from power lines during low-level operations in light rain conditions.
- [NTSB WPR22FA239](https://openairdocs.org/ntsb/WPR22FA239.md): Air Tractor AT-602 · Lind, WA · Accident · 1 fatal · Class 3 · Field · Final report · Jul 3, 2022 · N602GH · Substantial damage
  > The 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 WPR22LA220](https://openairdocs.org/ntsb/WPR22LA220.md): Robinson Helicopter R44 II · Auburn, WA · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 18, 2022 · N944BC · Substantial damage
  > The student pilot’s loss of helicopter control and the flight instructor’s delayed remedial action while providing hover training which resulted in a dynamic rollover.
- [NTSB WPR22LA202](https://openairdocs.org/ntsb/WPR22LA202.md): Fischer Super Koala · Chelan, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 5, 2022 · UNREG · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB WPR21LA332](https://openairdocs.org/ntsb/WPR21LA332.md): Cessna 172P · Wenatchee, WA · Accident · No injuries · Class 4 · Limited · Final report · Aug 29, 2021 · N51547 · Substantial damage
  > The student pilot’s inadequate inflight navigation and the flight instructors delayed remedial action which resulted in a collision with trees.
- [NTSB WPR21LA161](https://openairdocs.org/ntsb/WPR21LA161.md): Rans S12 · Colville, WA · Accident · 2 fatal · Class 3 · Limited · Final report · Apr 17, 2021 · N707PH · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to avoid powerlines, which resulted in an aerodynamic stall and a loss of control. Contributing to the accident was the partial loss of engine power due to improper…
- [NTSB WPR20LA331](https://openairdocs.org/ntsb/WPR20LA331.md): Bell 206 · Randle, WA · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 9, 2020 · N91TA · Destroyed
  > The pilot's failure to maintain clearance from a tree while conducting an external load operation.
- [NTSB WPR20CA274](https://openairdocs.org/ntsb/WPR20CA274.md): Uskoski Ridge Runner IV · Vancouver, WA · Accident · Minor injuries · Class 4 · Data collection · Final report · Aug 14, 2020 · N11752 · Substantial damage
  > The pilot’s failure to maintain airplane control while maneuvering to land which resulted in an aerodynamic stall at a low altitude, which the pilot was unable to recover from.
- [NTSB WPR20CA218](https://openairdocs.org/ntsb/WPR20CA218.md): Rans S6 · Richland, WA · Accident · No injuries · Class 4 · Data collection · Final report · Jul 12, 2020 · N644RS · Substantial damage
  > The pilot's inability to arrest a descent rate or maintain altitude after encountering a downdraft while maneuvering at low altitude near mountainous terrain that resulted in a hard landing.
- [NTSB WPR20CA125](https://openairdocs.org/ntsb/WPR20CA125.md): Cessna 172 · Yakima, WA · Accident · Minor injuries · Data collection · Final report · Apr 20, 2020 · N75765 · Substantial damage
  > The pilot's failure to attain sufficient altitude during a go-around, which resulted in impact with hilly terrain.
- [NTSB WPR20LA118](https://openairdocs.org/ntsb/WPR20LA118.md): Kolb Firestar 2 · La Center, WA · Accident · 1 fatal · Class 3 · Limited · Final report · Apr 6, 2020 · N90KL · Substantial damage
  > A loss of control for reasons that could not be determined based on the available information.
- [NTSB GAA20CA018](https://openairdocs.org/ntsb/GAA20CA018.md): Foxworthy Rick A Sonex · Langley, WA · Accident · Serious injuries · Data collection · Final report · Oct 11, 2019 · N612RF · Substantial damage
  > The pilot's failure to maintain a proper approach path, which resulted in impact with a tree.
- [NTSB GAA19CA509](https://openairdocs.org/ntsb/GAA19CA509.md): Robinson R44 · Cypress Island, WA · Accident · Serious injuries · Data collection · Final report · Aug 21, 2019 · N7186P · Substantial damage
  > The pilot's failure to maintain adequate clearance from a tree while maneuvering at a low altitude.
- [NTSB WPR19FA091](https://openairdocs.org/ntsb/WPR19FA091.md): Bell UH1B · Forks, WA · Accident · 1 fatal · Class 2 · Field · Final report · Mar 8, 2019 · N64RA · Destroyed
  > A total loss of engine power due to the failure of the gas generator sealing disk as a result of the operator’s exceedance of the sealing disk life limits at too low an altitude for the pilot to accomplish a successful autorotation which resulted in the…
- [NTSB WPR18FA261](https://openairdocs.org/ntsb/WPR18FA261.md): Gruber Beelzabub · Rochester, WA · Accident · 2 fatal · Class 3 · Field · Final report · Sep 14, 2018 · N382T · Substantial damage
  > The pilot’s failure to maintain clearance from a tree while maneuvering at a low altitude.
- [NTSB WPR18LA222](https://openairdocs.org/ntsb/WPR18LA222.md): Air Tractor AT802 · Northport, WA · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 14, 2018 · N397AS · Substantial damage
  > A total loss of engine power during a climb due to an accumulation of molten environmental particles, the source of which could not be determined based on the available evidence, which resulted in a forced landing.
- [NTSB WPR18LA214](https://openairdocs.org/ntsb/WPR18LA214.md): Bell 206 · Basin City, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 2018 · N607RA · Destroyed
  > The pilot's improper execution of a slowing and turning maneuver, which resulted in a loss of control at an altitude that was too low for recovery.
- [NTSB WPR18FA195](https://openairdocs.org/ntsb/WPR18FA195.md): Cessna 172 · Deer Park, WA · Accident · 3 fatal · Class 3 · Field · Final report · Jul 13, 2018 · N24442 · Substantial damage
  > An in-flight breakup as a result of the airplane exceeding the structural strength of the airplane during a rapid descent that the flight instructor was unable to recover from following a collision with a large bird.
- [NTSB GAA18CA352](https://openairdocs.org/ntsb/GAA18CA352.md): Bell 206 · Orondo, WA · Accident · No injuries · Data collection · Final report · Jun 17, 2018 · N2762P · Substantial damage
  > The pilot's failure to maintain clearance from power lines while maneuvering at low altitude.
- [NTSB GAA18CA248](https://openairdocs.org/ntsb/GAA18CA248.md): Cessna 172 · Port Angeles, WA · Accident · Minor injuries · Data collection · Final report · May 2, 2018 · N734QQ · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during a turn away from terrain, which resulted in an accelerated stall. Contributing to the accident was the pilot’s decision to delay the turn to avoid terrain.
- [NTSB WPR18FA104](https://openairdocs.org/ntsb/WPR18FA104.md): Piper PA 18-150 · La Center, WA · Accident · 1 fatal · Field investigation · Final report · Mar 11, 2018 · N4511Y · Destroyed
  > The pilot's failure to maintain clearance from trees while maneuvering at a low altitude.
- [NTSB WPR18FA074](https://openairdocs.org/ntsb/WPR18FA074.md): Hughes 369D · Pomeroy, WA · Accident · 1 fatal · Field investigation · Final report · Jan 27, 2018 · N369TH · Substantial damage
  > A loss of control following the gunner's failure to ensure that the net maintained clearance from the tail rotor.
- [NTSB GAA18CA029](https://openairdocs.org/ntsb/GAA18CA029.md): Six Chuter West Legend XL · Mabton, WA · Accident · Serious injuries · Data collection · Final report · Oct 26, 2017 · N781SC · Substantial damage
  > The pilot’s failure to see and avoid transmission wires.
- [NTSB WPR18FA016](https://openairdocs.org/ntsb/WPR18FA016.md): Robinson R22 · Arlington, WA · Accident · 1 fatal · Field investigation · Final report · Oct 24, 2017 · N8537J · Substantial damage
  > The pilot's failure to maintain adequate clearance from the water while maneuvering at low altitude.
- [NTSB WPR17FA139](https://openairdocs.org/ntsb/WPR17FA139.md): North Wing Uum Sport X2 912 · Chelan, WA · Accident · 2 fatal · Field investigation · Final report · Jul 1, 2017 · N492XB · Destroyed
  > The flight instructor's failure to maintain control of the aircraft while demonstrating a spiral dive, which resulted in a loss of control. Contributing to the accident was the instructor's decision to demonstrate a spiral dive maneuver at an altitude that…
- [NTSB GAA17CA369](https://openairdocs.org/ntsb/GAA17CA369.md): Bell 206B · Entiat, WA · Accident · No injuries · Data collection · Final report · Jun 26, 2017 · N183TC · Substantial damage
  > The pilot’s failure to secure a loose item inside the cockpit that interfered with antitorque pedal control and led to a loss of helicopter control due to a loss of tail rotor effectiveness.
- [NTSB WPR17LA084](https://openairdocs.org/ntsb/WPR17LA084.md): Cirrus Design SR22 · Brinnon, WA · Accident · Serious injuries · Limited investigation · Final report · Apr 2, 2017 · N167CB · Substantial damage
  > The flight instructor's decision to fly into a valley without ensuring adequate clearance to avoid the rising terrain.
- [NTSB WPR17LA014](https://openairdocs.org/ntsb/WPR17LA014.md): Aerospatiale AS350 · Starbuck, WA · Accident · No injuries · Limited investigation · Final report · Oct 28, 2016 · N369BD · Substantial damage
  > A total loss of engine power due to fuel exhaustion, which resulted from the pilot’s reliance on the fuel gauge that was displaying an incorrect fuel amount due to the separation of the fuel transmitter float pin guide from the float.

Next page: https://openairdocs.org/ntsb-phases/450/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 = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/450/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.
