NTSB investigations, 1981, WA

25 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 1981, WA per year, 1964–2026: 1,419 cases
196444
196551
196648
196770
196833
196930
197033
197117
197218
197333
197425
197531
197628
197719
197829
197932
198028
198125
198226
198322
198429
198517
198617
198727
198827
198919
199013
199125
199221
199325
199422
199515
199616
199719
199817
199921
200018
200119
200220
200323
200423
200519
200612
200715
200818
200923
201017
201123
201218
201318
201422
20159
201613
201713
201818
201913
202011
202119
202211
202315
202410
202512
202615

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 = 550)
  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 SEA82DYE03Accident · No injuriesClosedLuscombe 8A · Friday Harbor, WANov 29, 1981 · N45651 · Substantial damageNTSB SEA82FYP03Accident · No injuriesClosedRobinson R22 · Rosalia, WANov 5, 1981 · N9072N · Substantial damageNTSB SEA82DYE02Accident · No injuriesClosedCessna 182 · Everett, WANov 2, 1981 · N42043 · Substantial damageNTSB SEA82DYP01Accident · Minor injuriesClosedBellanca 7ECA · Wapato, WAOct 11, 1981 · N2696Z · Substantial damageNTSB SEA81DYE37Accident · No injuriesClosedCessna 172 · Bremerton, WASep 8, 1981 · N2946E · Substantial damageNTSB SEA81DYP38Accident · No injuriesClosedCessna 150 · Sunnyside, WASep 4, 1981 · N3800V · Substantial damageNTSB SEA81DYM41Accident · No injuriesClosedBeech B23 · Orchards, WASep 4, 1981 · N2362Z · Substantial damageNTSB SEA81DYP36Accident · Serious injuriesClosedCessna P210N · College Place, WAAug 18, 1981 · N4931K · Substantial damageNTSB SEA81DA052Accident · No injuriesClosedPiper PA-34 · Wenatchee, WAAug 10, 1981 · N666HL · Substantial damageNTSB SEA81FYM34Accident · Minor injuriesClosedCessna 170B · Vancouver, WAAug 6, 1981 · N3123A · Substantial damageNTSB SEA81DYP25Accident · No injuriesClosedCessna 180 · Walla Walla, WAJul 3, 1981 · N7828K · Substantial damageNTSB SEA81DYE33Accident · No injuriesClosedCessna 310D · Rochester, WAJun 29, 1981 · N6759T · Substantial damageNTSB SEA81DYE32Accident · No injuriesClosedCessna 152 · Seattle, WAJun 29, 1981 · N6136B · Substantial damageNTSB SEA81DYE34Accident · No injuriesClosedSchweizer SGS233 · Issaquah, WAJun 24, 1981 · N2828H · Substantial damageNTSB SEA82FYE30Accident · No injuriesClosedHelio H-391B · Bellingham, WAMay 29, 1981 · N316HW · Substantial damageNTSB SEA81DYP19Accident · No injuriesClosedAir Tractor AT-301 · Prescott, WAMay 28, 1981 · N8827S · Substantial damageNTSB SEA81FA037Accident · No injuriesClosedPiper PA-28R · Orcas, WAMay 23, 1981 · N6914C · Substantial damageNTSB SEA81DYE28Accident · No injuriesClosedBeech B23 · Ocean Shores, WAMay 12, 1981 · N7608R · Substantial damageNTSB SEA81DYE27Accident · No injuriesClosedPiper PA-18 · Tacoma, WAMay 12, 1981 · N82566 · Substantial damageNTSB SEA81FYE26Accident · No injuriesClosedLuscombe 8F · Index, WAApr 17, 1981 · N1110B · Substantial damageNTSB SEA81FA024Accident · No injuriesClosedCessna 172M · Roche Harbor, WAMar 13, 1981 · N80849 · Substantial damageNTSB SEA81FA022Accident · No injuriesClosedCessna 152 · Kent, WAMar 10, 1981 · N48883 · Substantial damageNTSB SEA81DYP09Accident · No injuriesClosedCessna 182Q · Moses Lake, WAMar 2, 1981 · N94338 · Substantial damageNTSB SEA81DYE14Accident · No injuriesClosedMaule M-5 · Kelso, WAFeb 8, 1981 · N5634M · Substantial damageNTSB SEA81FYP06Accident · No injuriesClosedCessna 320 · Curlew, WAJan 14, 1981 · N9831L · Substantial damage