# NTSB investigations, WA: Takeoff

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 7 · 328 cases

## Latest cases

- [NTSB WPR27FA001](https://openairdocs.org/ntsb/WPR27FA001.md): Stoddard Hamilton Glasair · Everett, WA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 1, 2026 · N314SR · Destroyed
  > On October 1, 2026, about 1450 Pacific daylight time, an experimental amateur built Glasair FT airplane, N314SR, was destroyed when it was involved in an accident near Everett, Washington. The pilot was fatally injured. The airplane was operated as a Title 14…
- [NTSB WPR26LA264](https://openairdocs.org/ntsb/WPR26LA264.md): Tag Aviation PTY Titanium Explorer · Cashmere, WA · Accident · Serious injuries · Class 4 · Limited · Investigation open · Jul 16, 2026 · N498TE · Substantial damage
- [NTSB WPR26LA026](https://openairdocs.org/ntsb/WPR26LA026.md): Extra Flugzeugbau EA 300/L · Arlington, WA · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 14, 2025 · N300EX · Substantial damage
  > On October 14, 2025, at about 1030 Pacific daylight time, an EXTRA FLUGZEUGBAU GMBH 300L, N300EX, was substantially damaged when it was involved in an accident near Arlington, Washington. The flight instructor and private pilot receiving instruction were…
- [NTSB WPR25LA307](https://openairdocs.org/ntsb/WPR25LA307.md): Cessna 172 · Anacortes, WA · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 22, 2025 · N6831A · Substantial damage
  > On September 22, 2025, about 1157 Pacific daylight time, a Cessna 172, N6831A, was substantially damaged when it was involved in an accident near Anacortes, Washington. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR25LA306](https://openairdocs.org/ntsb/WPR25LA306.md): Temco GC-1B · Toledo, WA · Accident · No injuries · Class 4 · Limited · Final report · Sep 18, 2025 · N78316 · Substantial damage
  > The pilot’s failure to maintain control of the airplane during takeoff in crosswind conditions..
- [NTSB WPR25LA259](https://openairdocs.org/ntsb/WPR25LA259.md): Czech Aircraft Group Sro Sportcruiser · Puyallup, WA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 25, 2025 · N538SF · Substantial damage
  > On August 25, 2025, about 1456 Pacific daylight time, a Czech Aircraft Group SRO Sportcruiser, N538SF was substantially damaged when it was involved in an accident near Puyallup, Washington. The pilot sustained serious injuries, and the passenger was not…
- [NTSB WPR25FA197](https://openairdocs.org/ntsb/WPR25FA197.md): Evolution Revolt · Mount Vernon, WA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 2, 2025 · N774RS · Substantial damage
  > On July 2, 2025, about 1313 Pacific daylight time, an Evolution Aircraft REVOLT weight shift control aircraft (commonly called a trike), N774RS, was substantially damaged when it was involved in an accident near Mount Vernon, Washington. The pilot was fatally…
- [NTSB WPR25LA199](https://openairdocs.org/ntsb/WPR25LA199.md): Robinson Helicopter R66 · Tukwila, WA · Accident · No injuries · Class 4 · Limited · Final report · Jun 30, 2025 · N23UP · Substantial damage
  > The pilot’s failure to maintain yaw control during a takeoff to a hover in a gusting crosswind, which resulted in a loss of directional control and a subsequent hard landing.
- [NTSB WPR25LA172](https://openairdocs.org/ntsb/WPR25LA172.md): Boeing B75N1 · Spokane Valley, WA · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 15, 2025 · N6848 · Substantial damage
  > The pilot’s failure to maintain directional control during a takeoff roll in quartering tailwind conditions.
- [NTSB WPR23LA356](https://openairdocs.org/ntsb/WPR23LA356.md): Piper PA-12 · Eatonville, WA · Accident · No injuries · Class 4 · Limited · Final report · Sep 22, 2023 · N7955H · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll, in gusty wind conditions, which resulted in a runway excursion.
- [NTSB WPR23FA344](https://openairdocs.org/ntsb/WPR23FA344.md): Seawind 3000 · Bellevue, WA · Accident · 1 fatal · Class 3 · Field · Final report · Sep 15, 2023 · N57TJ · Substantial damage
  > The pilot’s loss of airplane control after encountering a lake swell and skipping during takeoff.
- [NTSB WPR23LA101](https://openairdocs.org/ntsb/WPR23LA101.md): Cub Crafters CC18-180 · Dallesport, WA · Accident · No injuries · Class 4 · Limited · Final report · Jan 29, 2023 · N127DT · Substantial damage
  > The flight instructor’s failure to see and avoid a channel marker during a step taxi in preparation for takeoff on the water.
- [NTSB WPR23LA019](https://openairdocs.org/ntsb/WPR23LA019.md): Progressive Aerodyne SeaRey · Lake Isabel, WA · Accident · No injuries · Class 4 · Limited · Final report · Oct 15, 2022 · N129KB · Substantial damage
  > The pilot’s loss of airplane control after an encounter with windshear during takeoff which, resulted in a hard water landing.
- [NTSB WPR22LA156](https://openairdocs.org/ntsb/WPR22LA156.md): Sawby Scott RV-6A · Richland, WA · Accident · Serious injuries · Class 4 · Limited · Final report · Apr 17, 2022 · N341SS · Substantial damage
  > The pilot’s failure to maintain directional control during the takeoff ground roll.
- [NTSB WPR21LA295](https://openairdocs.org/ntsb/WPR21LA295.md): Cessna 172I · Renton, WA · Accident · No injuries · Class 4 · Limited · Final report · Jul 21, 2021 · N46287 · Substantial damage
  > The boat operator’s failure to remain a safe distance from the floatplane during the takeoff run, which resulted in a collision.
- [NTSB WPR21LA172](https://openairdocs.org/ntsb/WPR21LA172.md): Michael J Robbins Searey · Friday Harbor, WA · Accident · No injuries · Class 4 · Limited · Final report · Apr 22, 2021 · N888MJ · Substantial damage
  > Partial loss of engine power due to the detachment of the throttle cable from the carburetor arm, as a result of the pilot’s inadequate maintenance which resulted in an off-airport landing and impact with vegetation.
- [NTSB WPR21LA140](https://openairdocs.org/ntsb/WPR21LA140.md): Cessna 172S · Everett, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 23, 2021 · N2164Z · Substantial damage
  > A total loss of engine power during climb, for reasons that could not be determined based on available evidence.
- [NTSB WPR19LA249](https://openairdocs.org/ntsb/WPR19LA249.md): Hughes 369 · Asotin, WA · Accident · No injuries · Class 3 · Limited · Final report · Sep 1, 2019 · N54528 · Substantial damage
  > A loss of control for undetermined reasons.
- [NTSB GAA19CA522](https://openairdocs.org/ntsb/GAA19CA522.md): Stinson 108 · Bandera, WA · Accident · No injuries · Data collection · Final report · Sep 1, 2019 · N97699 · Substantial damage
  > The pilot's selection of unsuitable terrain for a simulated rejected takeoff, which resulted in a runway overrun and noseover.
- [NTSB GAA19CA517](https://openairdocs.org/ntsb/GAA19CA517.md): Cessna 180 · Arlington, WA · Accident · Minor injuries · Data collection · Final report · Aug 20, 2019 · N180TB · Substantial damage
  > The pilot's failure to properly secure the seat before takeoff, which resulted in it sliding back during takeoff and rendering him unable to reach the rudder pedals and throttle lever, a subsequent runway excursion, ground loop, and impact with a berm.
- [NTSB WPR19LA221](https://openairdocs.org/ntsb/WPR19LA221.md): AutoGyro Cavalon · Shelton, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 15, 2019 · N477AG · Substantial damage
  > The pilot’s failure to initiate the takeoff roll with inadequate rotor speed, and his failure to follow the published takeoff procedures, which resulted in a loss of control and impact with the ground.
- [NTSB WPR18CA213](https://openairdocs.org/ntsb/WPR18CA213.md): Cessna E162 · Burlington, WA · Accident · No injuries · Data collection · Final report · Jul 14, 2018 · N5202B · Substantial damage
  > The student pilot’s failure to maintain pitch control during an aborted takeoff.
- [NTSB WPR18LA190](https://openairdocs.org/ntsb/WPR18LA190.md): Autogyro Calidus · Tacoma, WA · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 2018 · N623AG · Substantial damage
  > The pilot's failure to properly configure the gyrocopter for takeoff, which resulted in it developing high speed and led to a subsequent loss of control.
- [NTSB GAA18CA336](https://openairdocs.org/ntsb/GAA18CA336.md): Aviat A 1 · Renton, WA · Accident · No injuries · Data collection · Final report · Jun 10, 2018 · N352AM · Substantial damage
  > The pilot’s inadequate crosswind correction, which resulted in the right wing impacting the water’s surface.
- [NTSB GAA18CA290](https://openairdocs.org/ntsb/GAA18CA290.md): Piper PA 14 · Vashon, WA · Accident · No injuries · Data collection · Final report · May 20, 2018 · N1423P · Substantial damage
  > The pilot’s failure to maintain directional control of the airplane during the takeoff roll due to his right foot inadvertently applying pressure to both rudder pedals.
- [NTSB GAA18CA237](https://openairdocs.org/ntsb/GAA18CA237.md): Stinson 108 · Eliza Island, WA · Accident · Minor injuries · Data collection · Final report · Apr 27, 2018 · N6933M · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.
- [NTSB GAA18CA104](https://openairdocs.org/ntsb/GAA18CA104.md): Geldermann Bert E Lancair Legacy · Friday Harbor, WA · Accident · Minor injuries · Data collection · Final report · Jan 15, 2018 · N145JG · Substantial damage
  > The pilot’s inability to maintain the landing flare, which resulted in the airplane landing hard short of the runway. Contributing to the accident was the cockpit canopy opening in flight.
- [NTSB GAA18CA078](https://openairdocs.org/ntsb/GAA18CA078.md): Cessna 172 · Everett, WA · Accident · No injuries · Data collection · Final report · Dec 8, 2017 · N4801D · Substantial damage
  > The pilot’s decision to abort the takeoff following a touch-and-go landing with too little runway remaining, which resulted in a runway overrun.
- [NTSB WPR18LA020](https://openairdocs.org/ntsb/WPR18LA020.md): Cessna 140 · Port Townsend, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 30, 2017 · N72339 · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB GAA18CA014](https://openairdocs.org/ntsb/GAA18CA014.md): Himsl Vincent S Vans RV-8 · Othello, WA · Accident · No injuries · Data collection · Final report · Oct 14, 2017 · N8432 · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll in crosswind conditions.
- [NTSB GAA18CA001](https://openairdocs.org/ntsb/GAA18CA001.md): Piper J3C · Yakima, WA · Accident · No injuries · Data collection · Final report · Oct 3, 2017 · N48694 · Substantial damage
  > The flight instructor's failure to maintain directional control during the takeoff roll.
- [NTSB WPR17LA194](https://openairdocs.org/ntsb/WPR17LA194.md): Paul Gaywood E CH 601 HD · Goldendale, WA · Accident · No injuries · Class 3 · Limited · Final report · Aug 26, 2017 · N9066F · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB GAA17CA509](https://openairdocs.org/ntsb/GAA17CA509.md): Robinson Helicopter R22 · Bremerton, WA · Accident · No injuries · Data collection · Final report · Aug 24, 2017 · N7198J · Substantial damage
  > The student pilot’s improper bank control during takeoff, which resulted in a dynamic rollover.
- [NTSB GAA17CA494](https://openairdocs.org/ntsb/GAA17CA494.md): Aerotechnik L 13 SEH Vivat · Moses Lake, WA · Accident · No injuries · Data collection · Final report · Aug 17, 2017 · N8230S · Substantial damage
  > The pilot's improper takeoff configuration due to his failure to follow the pretakeoff checklist, which resulted in a loss of lift and collision with obstacles.
- [NTSB GAA17CA323](https://openairdocs.org/ntsb/GAA17CA323.md): Air Tractor AT 802 · Prosser, WA · Accident · No injuries · Data collection · Final report · Jun 5, 2017 · N802NB · Substantial damage
  > The pilot’s abrupt maneuver to avoid hay bales during the takeoff roll, which resulted in a loss of directional control.
- [NTSB WPR17LA087](https://openairdocs.org/ntsb/WPR17LA087.md): Titan Tornado I · Spanaway, WA · Accident · Serious injuries · Limited investigation · Final report · Apr 13, 2017 · N5131H · Substantial damage
  > Maintenance personnel’s improper attachment of the aileron system components, which resulted in the pilot's inability to maintain flight control.
- [NTSB GAA17CA158](https://openairdocs.org/ntsb/GAA17CA158.md): Socata TBM700 · Bellingham, WA · Accident · No injuries · Data collection · Final report · Feb 27, 2017 · CGWVS · Substantial damage
  > The pilot’s failure to properly deice the airplane before takeoff, which resulted in an aerodynamic stall during the initial climb.
- [NTSB GAA17CA011](https://openairdocs.org/ntsb/GAA17CA011.md): Fuller Neil H Glasair SH 2 · Bellingham, WA · Accident · No injuries · Data collection · Final report · Oct 5, 2016 · N724NF · Substantial damage
  > The pilot’s failure to maintain directional control during the takeoff roll in crosswind conditions, which resulted in a runway excursion.
- [NTSB GAA16CA485](https://openairdocs.org/ntsb/GAA16CA485.md): Dormaier Monte R Baby Great Lakes · Mazama, WA · Accident · Minor injuries · Data collection · Final report · Sep 3, 2016 · N110MD · Substantial damage
  > The pilot’s failure to maintain directional control during the takeoff roll, which resulted in a runway excursion.
- [NTSB WPR16FA095](https://openairdocs.org/ntsb/WPR16FA095.md): Mooney M20K · Woodland, WA · Accident · 1 fatal · Field investigation · Final report · Apr 21, 2016 · N97119 · Substantial damage
  > The pilot's delay in recognizing that the airplane was not performing as expected and aborting the takeoff, which resulted in collision with a berm beyond the end of the runway. Contributing to the accident were the pilot's exceedance of the airplane's gross…
- [NTSB WPR16LA011](https://openairdocs.org/ntsb/WPR16LA011.md): Christopher Tom Kitfox 5 · Battle Ground, WA · Accident · No injuries · Limited investigation · Final report · Oct 14, 2015 · N533RC · Substantial damage
  > The total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB GAA15CA139](https://openairdocs.org/ntsb/GAA15CA139.md): Randall W Grandpre CH-701 Zenith · Quincy, WA · Accident · Minor injuries · Data collection · Final report · Jun 26, 2015 · N70WG · Substantial damage
  > The pilot's inadequate selection of a take-off area, resulting in a collision with obstacles and a loss of directional control.
- [NTSB WPR15FA181](https://openairdocs.org/ntsb/WPR15FA181.md): Beech F35 · Everett, WA · Accident · 1 fatal · Field investigation · Final report · Jun 10, 2015 · N4224B · Substantial damage
  > The partial loss of engine power during takeoff due to debris within the fuel servo, which restricted fuel flow throughout the engine fuel system and resulted in a partial loss of engine power.
- [NTSB WPR15FA158](https://openairdocs.org/ntsb/WPR15FA158.md): Piper PA 46 350P · Spokane, WA · Accident · 2 fatal · Field investigation · Final report · May 7, 2015 · N962DA · Destroyed
  > The mechanic's incorrect installation of two aileron cables and the subsequent inadequate functional checks of the aileron system before flight by both the mechanic and the pilot, which prevented proper roll control from the cockpit, resulting in the pilot's…
- [NTSB WPR15LA111](https://openairdocs.org/ntsb/WPR15LA111.md): Piper PA46 - 350P · Spokane, WA · Accident · 1 fatal · Limited investigation · Final report · Feb 22, 2015 · CGVZW · Destroyed
  > A total loss of engine power due to the refueler’s incorrect refueling of the airplane. Contributing to the accident was the fixed-base operator’s improper fueling nozzle, which facilitated the use of an incorrect fuel, and the pilot’s inadequate preflight…
- [NTSB WPR14CA383](https://openairdocs.org/ntsb/WPR14CA383.md): American Champion 7GCBC · Rimrock, WA · Accident · No injuries · Data collection · Final report · Sep 20, 2014 · N817DH · Substantial damage
  > The pilot's failure to maintain aircraft control during takeoff from a rough runway surface which resulted in an off-airport forced landing just beyond the runway.
- [NTSB WPR14FA209](https://openairdocs.org/ntsb/WPR14FA209.md): Kenneth A Berger Searey LSX · Electric City, WA · Accident · 1 fatal · Field investigation · Final report · May 24, 2014 · N249PW · Substantial damage
  > The pilot’s failure to maintain pitch control during takeoff after encountering a boat wake, which resulted in the airplane bouncing, impacting the water’s surface, and subsequently becoming submerged.
- [NTSB WPR14LA206](https://openairdocs.org/ntsb/WPR14LA206.md): Williams Helicopter UH 1H · Waitsburg, WA · Accident · Minor injuries · Limited investigation · Final report · May 23, 2014 · N260TA · Substantial damage
  > An extreme vibration immediately after entering forward flight for reasons that could not be determined because postaccident examination of the helicopter did not reveal any anomalies that would have precluded normal operation. Contributing to the accident…
- [NTSB WPR14LA179](https://openairdocs.org/ntsb/WPR14LA179.md): Coulter Hugh Clarke Pulsar XP Series I · Bremerton, WA · Accident · No injuries · Limited investigation · Final report · Apr 30, 2014 · N452PC · Substantial damage
  > Fatigue failure of the nose landing gear retention and pivot shaft, which resulted in the in-flight separation of the nose gear wheel and tire assembly.
- [NTSB WPR14FA137](https://openairdocs.org/ntsb/WPR14FA137.md): Eurocopter AS 350 B2 · Seattle, WA · Accident · 2 fatal · Field investigation · Final report · Mar 18, 2014 · N250FB · Destroyed
  > The loss of helicopter control due to a loss of hydraulic boost to the tail rotor pedal controls at takeoff, followed by a loss of hydraulic boost to the main rotor controls after takeoff. The reason for the loss of hydraulic boost to the main and tail rotor…

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

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