OpenAirDocs.org

Ongoing NTSB investigations, WA

6 cases where the phase of flight was Takeoff.

Cases per year

20252026

Where

Open the map

Latest cases

Query with SQL
duckdb -csv -c "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.\"completionStatus\" = 'Ongoing'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 300)
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB WPR27FA001Accident · 1 fatalClass 3 · FieldPreliminary reportStoddard Hamilton Glasair · Everett, WAOn 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…Oct 1, 2026 · N314SR · DestroyedNTSB WPR26LA264Accident · Serious injuriesClass 3 · LimitedPreliminary reportTag Aviation PTY Titanium Explorer · Cashmere, WAOn July 16, 2026, about 0930 Pacific daylight time, a Tag Aviation Pty Ltd. Titanium Explorer gyroplane, N498TE, was substantially damaged when it was involved in an accident at Cashmere-Dryden Airport (8S2), Cashmere, Washington. The pilot sustained serious…Jul 16, 2026 · N498TE · Substantial damageNTSB WPR26LA026Accident · No injuriesClass 3 · LimitedPreliminary reportExtra Flugzeugbau EA 300/L · Arlington, WAOn 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…Oct 14, 2025 · N300EX · Substantial damageNTSB WPR25LA307Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172 · Anacortes, WAOn 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…Sep 22, 2025 · N6831A · Substantial damageNTSB WPR25LA259Accident · Serious injuriesClass 3 · LimitedPreliminary reportCzech Aircraft Group Sro Sportcruiser · Puyallup, WAOn 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…Aug 25, 2025 · N538SF · Substantial damageNTSB WPR25FA197Accident · 1 fatalClass 3 · FieldPreliminary reportEvolution Revolt · Mount Vernon, WAOn 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…Jul 2, 2025 · N774RS · Substantial damage