NTSB investigations, 1981, IA

21 cases where the phase of flight was Landing.

Cases per year

19622026
NTSB investigations, 1981, IA per year, 1962–2026: 744 cases
19622
196437
196532
196651
196756
196838
196942
197041
197147
197232
197318
197418
19758
197614
197712
197824
197911
198014
198121
198215
198319
198412
19859
19866
19873
19886
19898
19909
19916
19927
19931
19945
19953
19965
19977
19984
19998
20001
20011
20025
20036
20042
20053
20063
20077
20107
20113
20128
20136
20143
20152
20164
20175
20186
20193
20201
20213
20223
20233
20243
20252
20263

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\" = 'IA' 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 MKC82DCD04Accident · No injuriesClosedPiper PA-28 · Iowa Falls, IADec 4, 1981 · N43098 · DestroyedNTSB MKC82DCD02Accident · No injuriesClosedCessna 182 · Webster City, IAOct 12, 1981 · N3184Q · Substantial damageNTSB MKC81DCD38Accident · No injuriesClosedPiper PA-38 · Burlington, IASep 10, 1981 · N9404T · Substantial damageNTSB MKC81DCD37Accident · No injuriesClosedCessna 150J · Eagle Grove, IASep 5, 1981 · N50469 · Substantial damageNTSB MKC81FCD35Accident · No injuriesClosedAeronca 7AC · Blakesburg, IAAug 16, 1981 · N84486 · Substantial damageNTSB MKC81FCD34Accident · Serious injuriesClosedHughes 269B · Marion, IAAug 13, 1981 · N9357F · Substantial damageNTSB MKC81DCD31Accident · No injuriesClosedPiper PA-22 · Burlington, IAAug 9, 1981 · N9701D · Substantial damageNTSB MKC81DCD30Accident · No injuriesClosedCessna 172M · Oxford, IAAug 9, 1981 · N20029 · Substantial damageNTSB MKC81DCD27Accident · No injuriesClosedCessna 170B · Red Oak, IAJul 22, 1981 · N2356D · Substantial damageNTSB MKC81DCD25Accident · No injuriesClosedCessna T210L · Carson, IAJul 17, 1981 · N8124L · DestroyedNTSB MKC81DCD24Accident · No injuriesClosedLuscombe 8A · Muscatine, IAJul 12, 1981 · N25346 · Substantial damageNTSB MKC81DCD23Accident · No injuriesClosedThorp T-18 · Waterloo, IAJul 11, 1981 · N179RW · Substantial damageNTSB MKC81DCD22Accident · No injuriesClosedCessna 172D · Laurens, IAJun 22, 1981 · N2406Y · Substantial damageNTSB MKC81FCD20Accident · Minor injuriesClosedN American P-51D · Council Bluffs, IAJun 17, 1981 · N5428V · Substantial damageNTSB MKC81FA035Accident · No injuriesClosedCessna 421 · Spencer, IAMay 18, 1981 · N1600B · Substantial damageNTSB MKC81FA034Accident · No injuriesClosedPiper PA-32 · Decorah, IAMay 16, 1981 · N2255M · Substantial damageNTSB MKC81DCD18Accident · No injuriesClosedPiper PA-32 · Holstein, IAApr 26, 1981 · N2835W · Substantial damageNTSB MKC81FCD08Accident · No injuriesClosedPiper PA-32R · Cresco, IAFeb 11, 1981 · N1748H · Substantial damageNTSB MKC81FA016Accident · 1 fatalClosedCessna T210 · Laurens, IAJan 31, 1981 · N972JT · DestroyedNTSB MKC81FCD07Accident · No injuriesClosedPiper PA-38 · Cedar Rapids, IAJan 23, 1981 · N2531C · Substantial damageNTSB MKC81FCD05Accident · No injuriesClosedCessna 177RG · Lamoni, IAJan 19, 1981 · N34309 · Substantial damage