NTSB investigations, 1981, WA

28 cases where the phase of flight was Enroute.

Cases per year

19632026
NTSB investigations, 1981, WA per year, 1963–2026: 979 cases
19631
196421
196520
196627
196716
196823
196927
197028
19719
197225
197315
197434
197533
197623
197731
197831
197936
198030
198128
198226
198329
198416
198515
198630
198719
198817
198919
199021
199119
199214
19938
199412
199523
199614
19979
199813
19999
200016
20019
200217
200315
200411
200510
20066
20079
20087
20099
20108
20117
20126
20135
20143
20157
20164
20174
20185
20196
20201
20219
20229
20235
20246
20259
20265

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 year(c.\"eventDate\") = 1981
    AND 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"

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 LAX82FA030Accident · 2 fatalClosedCessna 150 · Kelso, WADec 19, 1981 · N6043K · DestroyedNTSB SEA82IA009Incident · No injuriesClosedCessna 207 · Belfair, WADec 2, 1981 · N1733U · Minor damageNTSB SEA82IA008Incident · No injuriesClosedPiper PA-31 · Seattle, WANov 30, 1981 · N3533P · No damageNTSB SEA82FA011Accident · 2 fatalClosedCessna 150G · Renton, WANov 26, 1981 · N4737X · DestroyedNTSB SEA82IA004Incident · No injuriesClosedBeech 200 · Seattle, WANov 19, 1981 · N3875F · Minor damageNTSB SEA82DYE01Accident · No injuriesClosedEnstrom 280C · Burke Island, WANov 13, 1981 · N555BT · Substantial damageNTSB SEA81FYP39Accident · No injuriesClosedPiper PA-28R · Republic, WAOct 11, 1981 · N8906C · Substantial damageNTSB SEA81FA054Accident · 3 fatalClosedBeech C24R · Snoqualmie Ps, WAAug 29, 1981 · N6016S · DestroyedNTSB SEA81FA049Accident · 2 fatalClosedCessna 182A · Kingston, WAJul 28, 1981 · N4794D · DestroyedNTSB SEA81DYE35Accident · No injuriesClosedPiper PA-28 · Bellingham, WAJul 17, 1981 · N6497R · DestroyedNTSB SEA81FYP23Accident · Minor injuriesClosedPiper PA-28R · Sunnyside, WAJun 22, 1981 · N3790M · Substantial damageNTSB SEA81FYP22Accident · No injuriesClosedCessna 152 · Pasco, WAJun 13, 1981 · N6259B · Substantial damageNTSB SEA81DYE31Accident · Minor injuriesClosedHiller UN-12D · Castle Rock, WAJun 10, 1981 · N62377 · DestroyedNTSB SEA81FA035Accident · 2 fatalClosedBell 47G-4A · Aberdeen, WAMay 19, 1981 · N9457 · DestroyedNTSB SEA81DYP17Accident · No injuriesClosedSchleicher KA8B · Wenatchee, WAMay 17, 1981 · N4780T · Substantial damageNTSB SEA81DYE29Accident · No injuriesClosedPiper J-3 · Bainbridge Isl, WAMay 12, 1981 · N51565 · Substantial damageNTSB SEA81FA033Accident · Serious injuriesClosedStinson 108-2 · Ellensburg, WAMay 3, 1981 · N9279K · DestroyedNTSB SEA81FA031Accident · 2 fatalClosedPiper PA-28 · Washougal, WAApr 22, 1981 · C-GNVX · DestroyedNTSB SEA81AA030Accident · 1 fatalClosedCessna 172N · Gorst, WAApr 21, 1981 · N2411E · DestroyedNTSB SEA81FA026Accident · 1 fatalClosedMuir RV-3 · Renton, WAMar 28, 1981 · N84763 · DestroyedNTSB SEA81FA025Accident · 1 fatalClosedSchweizer SGS126 · Arlington, WAMar 21, 1981 · N9866E · DestroyedNTSB SEA81FYP11Accident · Minor injuriesClosedPiper PA-28 · Wenatchee, WAMar 20, 1981 · N7226F · Substantial damageNTSB SEA81FYP10Accident · Minor injuriesClosedPiper PA-25 · Oaksdale, WAMar 11, 1981 · N7553Z · Substantial damageNTSB SEA81FYE17Accident · Minor injuriesClosedCessna TU206G · Everett, WAFeb 16, 1981 · N7345N · DestroyedNTSB SEA81FA018Accident · 2 fatalClosedPiper PA-28 · Port Angles, WAJan 28, 1981 · N3062D · DestroyedNTSB SEA81FA017Accident · 2 fatalClosedCessna 150F · Puyallup, WAJan 23, 1981 · N6942F · DestroyedNTSB SEA81FYE15Accident · No injuriesClosedPiper PA-24 · Olympia, WAJan 10, 1981 · N6651P · Substantial damageNTSB SEA81FYE10Accident · Serious injuriesClosedRockwell 114 · Maple Valley, WAJan 4, 1981 · N4723W · Destroyed