NTSB investigations, 1981, MN

22 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 1981, MN per year, 1964–2026: 1,030 cases
196445
196552
196654
196749
196832
196937
197031
197118
197233
197324
197423
197531
197623
197727
197832
197920
198024
198122
198221
198316
198410
198513
19866
19879
198811
198914
199010
199117
199210
199311
19948
19958
199610
199715
19988
199911
200012
200110
200210
20039
20046
200513
200615
20079
200811
200911
20107
20119
201211
201313
20145
20155
20167
20176
20184
20197
202011
20215
20228
202316
20249
20259
20267

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\" = 'MN' 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 CHI82DER11Accident · No injuriesClosedPiper PA-22 · Hastings, MNNov 11, 1981 · N8707D · Substantial damageNTSB CHI82FER08Accident · Minor injuriesClosedCessna 150 · Long Prairie, MNOct 31, 1981 · N19023 · Substantial damageNTSB CHI82DER09Accident · No injuriesClosedPiper PA-20 · Lakeville, MNOct 27, 1981 · N7027K · Substantial damageNTSB CHI82DER03Accident · No injuriesClosedPiper PA-11 · Duluth, MNOct 19, 1981 · N5042H · Substantial damageNTSB CHI82DER04Accident · No injuriesClosedBeech 58 · Owatonna, MNOct 11, 1981 · N6651X · Substantial damageNTSB CHI82DER02Accident · No injuriesClosedPiper PA-22 · Austin, MNOct 9, 1981 · N4533A · Substantial damageNTSB CHI81FER72Accident · Minor injuriesClosedCessna 180 · Corcoran, MNSep 27, 1981 · N3205D · Substantial damageNTSB CHI81FER68Accident · No injuriesClosedBeech B19 · Eden Prairie, MNSep 9, 1981 · N6971R · Substantial damageNTSB CHI81FER70Accident · Minor injuriesClosedCessna 140 · Oklee, MNSep 2, 1981 · N3739V · Substantial damageNTSB CHI81FER57Accident · No injuriesClosedCessna 188B · Pelican Lake, MNAug 9, 1981 · N5273E · Substantial damageNTSB CHI81FER52Accident · No injuriesClosedCessna 152 · White Bear Lk, MNJul 7, 1981 · N757EY · Substantial damageNTSB CHI81DER45Accident · No injuriesClosedPiper PA-28 · Angle Inlet, MNJun 27, 1981 · N5179L · Substantial damageNTSB CHI81DER46Accident · No injuriesClosedCessna 180 · Afton, MNJun 25, 1981 · N4790B · Substantial damageNTSB CHI81DER36Accident · No injuriesClosedGrumman G-164B · Angus, MNMay 6, 1981 · N6698K · Substantial damageNTSB CHI81FER29Accident · No injuriesClosedBeech E-55 · Eden Prairie, MNMar 17, 1981 · N980TK · Substantial damageNTSB CHI81FER28Accident · No injuriesClosedPiper PA-30 · Fosston, MNMar 14, 1981 · N746EM · Substantial damageNTSB CHI81FER17Accident · No injuriesClosedCessna 120 · Frost, MNMar 13, 1981 · N76028 · Substantial damageNTSB CHI81FER26Accident · No injuriesClosedPiper PA-32 · Faribault, MNMar 10, 1981 · N8157R · Substantial damageNTSB CHI81DER25Accident · No injuriesClosedCessna 182RG · Warren, MNMar 8, 1981 · N9950C · Substantial damageNTSB CHI81DER23Accident · No injuriesClosedPiper PA-23 · Roseau, MNMar 6, 1981 · N700KC · Substantial damageNTSB CHI81DER18Accident · No injuriesClosedPiper PA-12 · Kelliher, MNFeb 15, 1981 · N2560M · Substantial damageNTSB CHI81DER11Accident · No injuriesClosedCessna 140A · St Cloud, MNJan 29, 1981 · N53990 · Substantial damage