Fatal NTSB investigations, WA

46 cases where the phase of flight was Uncontrolled descent.

Cases per year

19642026
Fatal NTSB investigations, WA per year, 1964–2026: 46 cases
19643
19651
19661
19673
19684
19693
19701
19713
19724
19733
19742
19752
19761
19775
19783
19803
19814

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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 650)
  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 SEA82FA007Accident · 4 fatalClosedPiper PA-28 · Longview, WANov 29, 1981 · N54440 · DestroyedNTSB SEA81FA057Accident · 3 fatalClosedCessna 210A · Woodland, WASep 20, 1981 · N6653X · DestroyedNTSB LAX81FA116Accident · 1 fatalClosedGrum Amer AA-5B · Vancouver, WAAug 13, 1981 · N1565R · DestroyedNTSB SEA81FA020Accident · 2 fatalClosedCessna 182P · Everett, WAMar 3, 1981 · N21002 · DestroyedNTSB SEA81FA012Accident · 2 fatalClosedPiper PA-34 · Stevenson, WADec 21, 1980 · N114PH · DestroyedNTSB SEA81FA013Accident · 1 fatalClosedCessna 210 · Royal City, WADec 3, 1980 · N6508X · DestroyedNTSB SEA81FA009Accident · 6 fatalClosedBeech 58TC · Ellensburg, WANov 27, 1980 · N24AC · DestroyedNTSB SEA79FYP04Accident · 1 fatalClosedCessna R172K · Dayton, WADec 1, 1978 · N736TH · DestroyedNTSB SEA79FA009Accident · 3 fatalClosedCessna P210 · Toutle, WANov 2, 1978 · N3686P · DestroyedNTSB SEA78FA053Accident · 1 fatalClosedStinson 108E · Enumclaw, WAAug 10, 1978 · N4122C · DestroyedNTSB SEA78FA008Accident · 4 fatalClosedCessna 172M · Newport, WANov 13, 1977 · C-GSKO · DestroyedNTSB SEA77FA049Accident · 4 fatalClosedCessna 185 · Hansville, WAAug 21, 1977 · N1738R · DestroyedNTSB SEA77FA027Accident · 3 fatalClosedCessna 182P · Port Orchard, WAApr 10, 1977 · N1282S · DestroyedNTSB SEA77FA019Accident · 1 fatalClosedPiper PA-28R · Port Orchard, WAFeb 12, 1977 · N1529X · Substantial damageNTSB SEA77FA012Accident · 3 fatalClosedBeech C35 · Mckenna, WAJan 14, 1977 · N859M · DestroyedNTSB SEA76AS060Accident · 3 fatalClosedPiper PA-22 · Hoquiam, WAJul 3, 1976 · N9344D · DestroyedNTSB SEA76AS020Accident · 2 fatalClosedPiper PA-24 · Woodland, WAOct 14, 1975 · N6680P · DestroyedNTSB SEA75AS026Accident · 3 fatalClosedCessna TU206D · Palmer, WAJan 5, 1975 · N71972 · DestroyedNTSB SEA75AS022Accident · 1 fatalClosedBell 47G-2 · Kingston, WANov 4, 1974 · N5160B · DestroyedNTSB SEA74AS035Accident · 2 fatalClosedAmer Avco AA1-B · Enumclaw, WAMar 3, 1974 · N6213L · DestroyedNTSB SEA74AS003Accident · 2 fatalClosedCessna 175 · Neah Bay, WAJul 18, 1973 · N7310M · DestroyedNTSB SEA73AS026Accident · 2 fatalClosedN.American T-28A · Gorst, WAMar 24, 1973 · N2800N · DestroyedNTSB SEA73AS025Accident · 3 fatalClosedAero Comdr 680F · Battle Grnd, WAFeb 17, 1973 · N69HE · DestroyedNTSB SEA73ASO13Accident · 1 fatalClosedLuscombe 8A · Ellensburg, WANov 28, 1972 · N1170B · DestroyedNTSB SEA73AS007Accident · 2 fatalClosedBeech D55 · Mansfield, WASep 24, 1972 · N7705R · DestroyedNTSB SEA73AS005Accident · 5 fatalClosedPiper PA-32 · Ryderwood, WASep 8, 1972 · N3600W · DestroyedNTSB SEA72AS048Accident · 3 fatalClosedBellanca 17-31A · Onalaska, WAApr 28, 1972 · N6581V · DestroyedNTSB SEA72AS027Accident · 1 fatalClosedCessna 150G · Kalama, WADec 31, 1971 · N2257J · DestroyedNTSB SEA72AS009Accident · 2 fatalClosedStinson 108-2 · Port Angeles, WASep 3, 1971 · N890D · DestroyedNTSB SEA71AS033Accident · 1 fatalClosedAero Comdr 500 · Carson, WAJan 9, 1971 · N8473C · DestroyedNTSB SEA71AS006Accident · 4 fatalClosedCessna 172K · Westport, WAJul 31, 1970 · N84845 · DestroyedNTSB SEA79FA059Accident · 1 fatalClosedCessna 140 · Lester, WANov 2, 1969 · N2050N · DestroyedNTSB SEA70A0002Accident · 2 fatalClosedGlobe GC-1B · Winlock, WAJul 10, 1969 · N78155 · DestroyedNTSB OAK70A0002Accident · 3 fatalClosedCessna 206 · Hyak, WAApr 29, 1969 · N8714Z · DestroyedNTSB SEA69A0031Accident · 1 fatalClosedCessna 150J · Ralston, WANov 24, 1968 · N50598 · DestroyedNTSB SEA69A0026Accident · 2 fatalClosedStinson 108 · Vancouver, WANov 10, 1968 · N422C · DestroyedNTSB SEA69A0016Accident · 2 fatalClosedErco 415-D · Packwood, WAAug 26, 1968 · N2505H · DestroyedNTSB SEA68A0053Accident · 2 fatalClosedCessna T-210F · Lamont, WAFeb 19, 1968 · N6792R · DestroyedNTSB SEA68A0029Accident · 2 fatalClosedCessna T-210F · Gardiner, WASep 29, 1967 · CF-UDD · DestroyedNTSB SEA68A0025Accident · 2 fatalClosedCessna 180H · Ilwaco, WASep 8, 1967 · N2787X · DestroyedNTSB SEA67A0063Accident · 1 fatalClosedCessna 150 · Bremerton, WAMay 8, 1967 · N7077F · DestroyedNTSB SEA67A0041Accident · 1 fatalClosedCessna 150F · Ndavenport, WADec 6, 1966 · N8888S · DestroyedNTSB SEA65A0064Accident · 1 fatalClosedCessna 182C · Forks, WAMay 26, 1965 · N8536T · DestroyedNTSB UNK65X0132Accident · 2 fatalClosedPiper PA-18 · Waterville, WAOct 3, 1964 · N7221K · DestroyedNTSB SEA76AS001Accident · 2 fatalClosedCessna 182A · Mineral, WAJun 15, 1964 · N4029D · DestroyedNTSB UNK64X1816Accident · 4 fatalClosedBeechraft M-23 · Washougal, WAMay 17, 1964 · N2344J · Destroyed