# NTSB investigations, WA: Enroute

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 20 · 979 cases

## Latest cases

- [NTSB WPR27FA014](https://openairdocs.org/ntsb/WPR27FA014.md): Piper PA-18-150 · Wauconda, WA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Oct 11, 2026 · N927JS · Destroyed
  > On October 10, 2026, about 2014 Pacific daylight time, a Piper PA-18-150, N927JS, was substantially damaged when it was involved in an accident near Wauconda, Washington. The flight instructor and student pilot were fatally injured. The airplane was operated…
- [NTSB WPR26LA327](https://openairdocs.org/ntsb/WPR26LA327.md): Cessna 150E · Siler, WA · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 1, 2026 · N3037J · Substantial damage
  > On September 1, 2026, at 1220 Pacific daylight time, a Cessna 150E, N3037J, sustained substantial damage when it was involved in an accident near Siler, Washington. The pilot and pilot rated passenger were not injured. The airplane was operated as a Title 14…
- [NTSB WPR26LA203](https://openairdocs.org/ntsb/WPR26LA203.md): Pzl-Swidnik PW-5 · Soap Lake, WA · Accident · No injuries · Class 4 · Limited · Final report · May 23, 2026 · N157AJ · Substantial damage
  > The pilot’s failure to ensure the proper preflight assembly of the glider's wing attachment system, which resulted in substantial damage to the wing structure during flight.
- [NTSB WPR26LA183](https://openairdocs.org/ntsb/WPR26LA183.md): Stinson 108-3 · Quilcene, WA · Accident · No injuries · Class 3 · Limited · Preliminary report · May 12, 2026 · N588C · Substantial damage
  > On May 12, 2026, at about 1049 Pacific daylight time, a Stinson 108-3 airplane, N588C, was substantially damaged when it was involved in an accident near Quilcene, Washington. The pilot was uninjured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR26LA163](https://openairdocs.org/ntsb/WPR26LA163.md): Piper PA30 · Auburn, WA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Apr 18, 2026 · N741TJ · Substantial damage
  > On April 18, 2026, about 1330 Pacific daylight time, a Piper PA-30 Twin Comanche, N741TJ, was substantially damaged when it was involved in an accident near Auburn, Washington. The pilot and pilot-rated passenger sustained minor injuries. The airplane was…
- [NTSB WPR26LA072](https://openairdocs.org/ntsb/WPR26LA072.md): Zenith 750 · Yacolt, WA · Accident · No injuries · Class 4 · Limited · Final report · Dec 23, 2025 · N186BG · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB WPR26LA041](https://openairdocs.org/ntsb/WPR26LA041.md): Bessler Duane Lynn Savannah · Pacific, WA · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 7, 2025 · N358D · Substantial damage
  > On November 7, 2025 at 1331 Pacific standard time, an experimental amateur-built ICP Savannah amphibious airplane, N358D, was substantially damaged when it was involved in an accident near Pacific, Washington. The pilot and the passenger were not injured. The…
- [NTSB WPR26LA006](https://openairdocs.org/ntsb/WPR26LA006.md): Siai-Marchetti SM 1019 · Richland, WA · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 2, 2025 · N3172U · Substantial damage
  > On October 2, 2025, about 1050 Pacific daylight time, a Siai-Marchetti SM 1019, N3172U, sustained substantial damage when it was involved in an accident near Richland, Washington. The pilot and passenger were not injured. The airplane was operated as a Title…
- [NTSB WPR25FA213](https://openairdocs.org/ntsb/WPR25FA213.md): Scott Macwilliam SR3500 Moose · Quinault, WA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 15, 2025 · N80TM · Substantial damage
  > On July 15, 2025, at about 1440 Pacific daylight time, an experimental amateur-built Murphy Moose SR3500 airplane, N80TM, sustained substantial damage when it was involved in an accident near Quinault, Washington. The pilot received minor injuries, one…
- [NTSB WPR25LA184](https://openairdocs.org/ntsb/WPR25LA184.md): Cessna 180E · Rockford, WA · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 20, 2025 · N2680Y · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent landing on rough terrain.
- [NTSB WPR25LA177](https://openairdocs.org/ntsb/WPR25LA177.md): Rolladen Schneider LS-7WL · Tonasket, WA · Accident · No injuries · Class 4 · Limited · Final report · Jun 11, 2025 · N78AW · Substantial damage
  > The glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.
- [NTSB WPR25LA134](https://openairdocs.org/ntsb/WPR25LA134.md): Bell 206B · Amboy, WA · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 15, 2025 · N16671 · Substantial damage
  > On April 14, 2025, about 1800 Pacific daylight time, a Bell 206B, N16671, was substantially damaged when it was involved in an accident near Amboy, Washington. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal Regulations,…
- [NTSB WPR25FA114](https://openairdocs.org/ntsb/WPR25FA114.md): Bell 206B II · Mountain Home Park, WA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 19, 2025 · N23SD · Substantial damage
  > On March 19, 2025, at 1228 Pacific daylight time, a Bell 206B II, N23SD, was substantially damaged when it impacted electrical cables and terrain near Mountain Home Park, Washington. The commercial pilot was fatally injured. The helicopter was operated as a…
- [NTSB WPR25FA108](https://openairdocs.org/ntsb/WPR25FA108.md): Cessna A150L · Renslow, WA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 4, 2025 · N6167F · Destroyed
  > On March 4, 2025, at 1555 Pacific standard time, a Cessna A150L, N6167F, was destroyed when it was involved in an accident near Renslow, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…
- [NTSB WPR24LA319](https://openairdocs.org/ntsb/WPR24LA319.md): Bell 206L · Fern Prairie, WA · Accident · No injuries · Class 3 · Limited · Final report · Sep 26, 2024 · N9984K · Substantial damage
  > An aeroelastic interaction between the helicopter’s main rotor blades and nodal beam system, which resulted in oscillations that exceeded the design limits of the tailboom. Contributing to the accident was the failure of the main rotor blade manufacturer to…
- [NTSB WPR24LA248](https://openairdocs.org/ntsb/WPR24LA248.md): Cessna 150M · Ritzville, WA · Accident · No injuries · Class 3 · Limited · Final report · Jul 15, 2024 · N714PW · Substantial damage
  > Maintenance personnel’s improper installation of the No. 2 cylinder exhaust valve, which allowed the valve to drop into the cylinder and resulted in a total loss of engine power.
- [NTSB WPR24FA226](https://openairdocs.org/ntsb/WPR24FA226.md): Champion 7GCBC · Eatonville, WA · Accident · 2 fatal · Class 3 · Field · Final report · Jul 7, 2024 · N3464D · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to avoid trees, which resulted in an aerodynamic stall.
- [NTSB WPR24LA206](https://openairdocs.org/ntsb/WPR24LA206.md): Cessna 182A · Spokane Valley, WA · Accident · No injuries · Class 3 · Limited · Final report · Jun 24, 2024 · N4059D · Substantial damage
  > The pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR24FA200](https://openairdocs.org/ntsb/WPR24FA200.md): Robinson Helicopter R44 II · Bluestem, WA · Accident · 2 fatal · Class 3 · Field · Final report · Jun 19, 2024 · N323TT · Destroyed
  > The pilot’s failure to manage main rotor rpm during an autorotation, which resulted in a loss of helicopter control. Contributing to the accident was a loss of power for reasons that could not be determined.
- [NTSB WPR24FA156](https://openairdocs.org/ntsb/WPR24FA156.md): Extra Flugzeugbau EA 300/L · Bandera, WA · Accident · 1 fatal · Class 3 · Field · Final report · May 19, 2024 · N22MW · Substantial damage
  > The pilot’s decision to continue flight into icing conditions and inclement weather, which likely led to spatial disorientation when he attempted to divert from the planned course to the destination airport.
- [NTSB WPR23LA294](https://openairdocs.org/ntsb/WPR23LA294.md): Cessna 195 · Ravensdale, WA · Accident · No injuries · Class 3 · Limited · Final report · Jul 30, 2023 · N195JL · Substantial damage
  > Partial 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 WPR23LA222](https://openairdocs.org/ntsb/WPR23LA222.md): Cessna 150F · Wishram, WA · Accident · No injuries · Class 4 · Limited · Final report · Jun 7, 2023 · N7155F · Substantial damage
  > The pilot’s improper fuel management, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB WPR23LA215](https://openairdocs.org/ntsb/WPR23LA215.md): Piper J3C-65 · Belfair, WA · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 4, 2023 · N77583 · Substantial damage
  > The total loss of engine power due to the fatigue failure of the crankshaft accessory drive gear.
- [NTSB WPR23LA196](https://openairdocs.org/ntsb/WPR23LA196.md): Cessna 172H · Seattle, WA · Accident · Minor injuries · Class 3 · Limited · Final report · May 19, 2023 · N2550L · Substantial damage
  > A stuck exhaust valve that resulted in a partial loss of engine power and a forced water ditching.
- [NTSB WPR23FA143](https://openairdocs.org/ntsb/WPR23FA143.md): Cessna T182T · Queets, WA · Accident · 1 fatal · Class 3 · Field · Final report · Mar 7, 2023 · N24289 · Destroyed
  > The pilot’s failure to maintain clearance from terrain for undetermined reasons.
- [NTSB WPR23LA042](https://openairdocs.org/ntsb/WPR23LA042.md): Cessna 180 · Kahlotus, WA · Accident · Serious injuries · Class 4 · Limited · Final report · Nov 15, 2022 · N24227 · Substantial damage
  > The 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 WPR23LA026](https://openairdocs.org/ntsb/WPR23LA026.md): Cessna 150F · Puyallup, WA · Accident · No injuries · Class 4 · Limited · Final report · Oct 26, 2022 · N6492F · Substantial damage
  > The pilot’s inadequate fuel management that resulted in the loss of engine power due to fuel exhaustion.
- [NTSB DCA22MA193](https://openairdocs.org/ntsb/DCA22MA193.md): Dehavilland DHC-3 · Freeland, WA · Accident · 10 fatal · Class 1 · Major · Final report · Sep 4, 2022 · N725TH · Destroyed
  > The 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 WPR22LA263](https://openairdocs.org/ntsb/WPR22LA263.md): Zenith CH701 · Bothell, WA · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 20, 2022 · N8787G · Substantial damage
  > A 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 WPR22FA255](https://openairdocs.org/ntsb/WPR22FA255.md): Aeronca 7BCM · Lake McMurray, WA · Accident · 1 fatal · Class 3 · Field · Final report · Jul 16, 2022 · N2588C · Destroyed
  > The 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 WPR22LA223](https://openairdocs.org/ntsb/WPR22LA223.md): DG Flugzeugbau DG 1000S · Lake Chelan, WA · Accident · No injuries · Class 4 · Limited · Final report · Jun 22, 2022 · N767SS · Substantial damage
  > The glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight. Contributing to the accident was the pilot’s decision to overfly a suitable landing site which resulted in an off-field landing in a lake.
- [NTSB DCA22LA134](https://openairdocs.org/ntsb/DCA22LA134.md): Boeing 737-700 · Tacoma, WA · Accident · Serious injuries · Class 4 · Limited · Final report · May 22, 2022 · N256WN · No damage
  > During cruise flight with no reported turbulence a passenger sustained a serious injury for an unknown reason.
- [NTSB WPR22LA166](https://openairdocs.org/ntsb/WPR22LA166.md): Cessna 170B · Ravensdale, WA · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 24, 2022 · N4398B · Substantial damage
  > A loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.
- [NTSB WPR22LA136](https://openairdocs.org/ntsb/WPR22LA136.md): Downer Bellanca 14-19-2 · Prosser, WA · Accident · No injuries · Class 3 · Limited · Final report · Mar 26, 2022 · N7658B · Substantial damage
  > An inadequately welded elevator attachment lug, which caused the elevator to partially detach from its bellcrank, resulting in flutter and structural damage.
- [NTSB WPR22FA023](https://openairdocs.org/ntsb/WPR22FA023.md): Mooney M20M · Snoqualmie, WA · Accident · 1 fatal · Class 3 · Field · Final report · Oct 28, 2021 · N40KA · Substantial damage
  > The pilot’s decision to fly the airplane into known icing conditions, which resulted in a loss of airplane control and collision with terrain.
- [NTSB WPR22LA017](https://openairdocs.org/ntsb/WPR22LA017.md): Cessna 177 · White Swan, WA · Accident · No injuries · Class 4 · Limited · Final report · Oct 16, 2021 · N3388T · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.
- [NTSB WPR21LA351](https://openairdocs.org/ntsb/WPR21LA351.md): George A. Thiel Just Aircraft Highlander · Monroe, WA · Accident · No injuries · Class 4 · Limited · Final report · Sep 21, 2021 · N488VG · Substantial damage
  > The in-flight malfunction of the throttle control pivot arm, which resulted in a total loss of engine power and the subsequent collision with terrain during the forced landing.
- [NTSB WPR21LA363](https://openairdocs.org/ntsb/WPR21LA363.md): Piper PA-32-300 · Orcas Island, WA · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 17, 2021 · N33022 · Substantial damage
  > The total loss of engine power due to the pilot’s mismanagement of the fuel system which resulted in fuel starvation.
- [NTSB WPR21LA235](https://openairdocs.org/ntsb/WPR21LA235.md): HPH Glasflugel · Winthrop, WA · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 20, 2021 · N974CQ · Substantial damage
  > The glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.
- [NTSB WPR21LA303](https://openairdocs.org/ntsb/WPR21LA303.md): Cessna 172S · Yelm, WA · Accident · No injuries · Class 3 · Limited · Final report · Jun 11, 2021 · N513WF · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB WPR21LA156](https://openairdocs.org/ntsb/WPR21LA156.md): Cessna 182H · Blakely Island, WA · Accident · No injuries · Class 3 · Limited · Final report · Apr 11, 2021 · N2030X · Substantial damage
  > A total loss of engine power during climb for reasons that could not be determined which resulted in a forced water landing.
- [NTSB WPR21LA151](https://openairdocs.org/ntsb/WPR21LA151.md): Piper PA-28-140 · Yacolt, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 29, 2021 · N665FL · Substantial damage
  > A partial loss of power caused by carbon build up in the cylinders, which prevented the exhaust valves from seating properly. Contributing to the accident was flying in moderate icing conditions which resulted in reduced aircraft performance and vibrations.
- [NTSB WPR21LA097](https://openairdocs.org/ntsb/WPR21LA097.md): Cessna 170A · Port Angeles, WA · Accident · 1 fatal · Class 3 · Limited · Final report · Jan 27, 2021 · N9114A · Substantial damage
  > The total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate in-flight fuel planning.
- [NTSB WPR21FA057](https://openairdocs.org/ntsb/WPR21FA057.md): Blevins Kamron Odyssey · Arlington, WA · Accident · 1 fatal · Class 3 · Field · Final report · Nov 20, 2020 · N562TB · Destroyed
  > The pilot’s loss of airplane control for reasons that could be determined based on available evidence.
- [NTSB WPR20LA028](https://openairdocs.org/ntsb/WPR20LA028.md): Cessna 182 · Metaline, WA · Accident · 1 fatal · Class 3 · Limited · Final report · Nov 11, 2019 · N8749T · Destroyed
  > Impact with a lake for reasons that could not be determined.
- [NTSB GAA19CA495](https://openairdocs.org/ntsb/GAA19CA495.md): Flight Design CT2K · Hooper, WA · Accident · Minor injuries · Data collection · Final report · Aug 16, 2019 · N433CT · Substantial damage
  > The pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, an off-airport landing to a field, and a subsequent nose-over.
- [NTSB WPR19LA226](https://openairdocs.org/ntsb/WPR19LA226.md): Cessna 177RG · Fall City, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 27, 2019 · N1828Q · Substantial damage
  > The failure of the No. 3 cylinder intake valve that resulted in a partial loss of engine power and a forced landing on uneven terrain.
- [NTSB WPR19LA125](https://openairdocs.org/ntsb/WPR19LA125.md): Stearman A75N1(PT17) · Sequim, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 28, 2019 · N68825 · Substantial damage
  > The total loss of engine power due to the fatigue failure of the crankshaft.
- [NTSB WPR19LA066](https://openairdocs.org/ntsb/WPR19LA066.md): Piper PA23 · Ellensburg, WA · Accident · 1 fatal · Class 2 · Limited · Final report · Jan 17, 2019 · N14372 · Destroyed
  > The instrument rated pilot’s loss of control due to spatial disorientation.
- [NTSB WPR19LA064](https://openairdocs.org/ntsb/WPR19LA064.md): Beech 35 · Port Hadlock, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Jan 13, 2019 · N5093C · Substantial damage
  > A total loss of engine power due to fuel starvation and the pilot’s mismanagement of the available fuel.

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

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