NTSB investigations, 1981, MN

21 cases where the phase of flight was Enroute.

Cases per year

19642026
NTSB investigations, 1981, MN per year, 1964–2026: 546 cases
196414
196519
196618
196716
196814
196919
197018
197111
197213
19737
197413
197515
197615
197716
197810
197914
198011
198121
198210
198316
19849
198512
198613
19879
198812
198917
199011
199110
19924
19936
19949
19955
199612
19974
199810
19993
20008
20018
20024
20038
20048
20056
20064
20075
20083
20094
20107
20112
20122
20133
20147
20151
20167
20172
20183
20205
20212
20221
20233
20243
20252
20262

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 = 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 CHI82FA014Accident · 3 fatalClosedCessna 172 · Wolf Lake, MNNov 15, 1981 · N733BJ · DestroyedNTSB CHI82FER07Accident · No injuriesClosedCessna 150 · Menahga, MNOct 26, 1981 · N7925U · Substantial damageNTSB CHI82DER05Accident · No injuriesClosedPiper PA-28 · New York Mills, MNOct 20, 1981 · N9714W · Substantial damageNTSB CHI82FER06Accident · Minor injuriesClosedPiper PA-28R · Lynd, MNOct 6, 1981 · N6923J · Substantial damageNTSB CHI81FER71Accident · No injuriesClosedPiper PA-28 · Edgerton, MNSep 24, 1981 · N105WC · Substantial damageNTSB CHI81FER67Accident · No injuriesClosedBeech P35 · Stephen, MNSep 5, 1981 · N1501S · Substantial damageNTSB CHI81FER73Accident · No injuriesClosedHiller UH-12E · Wannaska, MNSep 4, 1981 · N1847 · Substantial damageNTSB CHI81FER55Accident · Minor injuriesClosedSchilling KR-2 · Lake Elmo, MNAug 2, 1981 · N37691 · DestroyedNTSB CHI81FA072Accident · 1 fatalClosedTaylorcraft F19 · Delevan, MNJul 4, 1981 · N3581T · DestroyedNTSB CHI81FA071Accident · 2 fatalClosedBellanca 7GCB · Viking, MNJul 4, 1981 · N8992R · DestroyedNTSB CHI81FER48Accident · No injuriesClosedCessna 172P · Thief River Fa, MNJul 1, 1981 · N52565 · Substantial damageNTSB CHI81FA069Accident · Serious injuriesClosedRockwell 680V · Minneapolis, MNJun 28, 1981 · N161XX · Substantial damageNTSB CHI81DER43Accident · Minor injuriesClosedCessna 188A · Wabasso, MNJun 12, 1981 · N9926G · Substantial damageNTSB CHI81FER38Accident · Minor injuriesClosedMcculloch J-2 · Owatonna, MNMay 21, 1981 · N18804 · DestroyedNTSB CHI81FER37Accident · No injuriesClosedPiper PA-28R · Detroit Lakes, MNMay 19, 1981 · N44767 · Substantial damageNTSB CHI81FER24Accident · No injuriesClosedCessna 210M · Ivanhoe, MNMar 8, 1981 · N6039N · Substantial damageNTSB CHI81DER19Accident · No injuriesClosedWar Corsair · Blue Earth, MNFeb 24, 1981 · N246S · Substantial damageNTSB CHI81FER16Accident · Minor injuriesClosedMooney M20 · Lacrescent, MNFeb 20, 1981 · N2664W · Substantial damageNTSB CHI81FER14Accident · No injuriesClosedPiper PA-23 · St.Michael, MNFeb 10, 1981 · N3478P · Substantial damageNTSB CHI81FA023Accident · No injuriesClosedCessna U206F · Sherburne, MNJan 12, 1981 · N4291Q · Substantial damageNTSB CHI81FEX08Accident · No injuriesClosedBeech F33A · St.Paul, MNJan 3, 1981 · N17702 · Substantial damage