NTSB investigations, 1972, WI

25 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 1972, WI per year, 1964–2026: 950 cases
196428
196528
196631
196744
196832
196932
197025
197122
197225
197331
197429
197517
197619
197719
197831
197926
198022
198130
198211
198313
198413
198523
198621
198711
198811
198913
19908
199111
19929
199312
199413
19957
19968
199710
199811
199913
200010
20016
20028
200311
20048
200515
20066
200714
200810
20098
20108
20115
201216
20133
20147
201510
20168
20178
20186
20195
20208
20218
20229
20239
202412
202517
20266

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\") = 1972
    AND c.\"eventStateOrRegion\" = 'WI' 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 CHI73FEP28Accident · Minor injuriesClosedCessna 172D · Franklin, WINov 4, 1972 · N2841U · Substantial damageNTSB CHI73DEP26Accident · No injuriesClosedCessna 172 · Michicot, WIOct 8, 1972 · N6259E · Substantial damageNTSB CHI73DEP22Accident · No injuriesClosedCessna 150 · Elkhorn, WISep 17, 1972 · N8778G · Substantial damageNTSB CHI73FER04Accident · No injuriesClosedPitts SPL S1C · Osceola, WISep 4, 1972 · N51AC · Substantial damageNTSB CHI73DEP24Accident · No injuriesClosedCessna 150 · Palmyra, WIAug 14, 1972 · N1710Q · Substantial damageNTSB CHI73DEP18Accident · No injuriesClosedCessna 140 · New Glarus, WIAug 14, 1972 · N9461A · Substantial damageNTSB CHI73DEP13Accident · No injuriesClosedCessna 310Q · Necedah, WIAug 14, 1972 · N7588Q · Substantial damageNTSB CHI73FEP12Accident · No injuriesClosedCessna 175 · Kansasville, WIAug 13, 1972 · N9320B · Substantial damageNTSB CHI73FEP07Accident · No injuriesClosedBeech D17R · Milwaukee, WIAug 4, 1972 · N35E · Substantial damageNTSB CHI73DEP15Accident · No injuriesClosedPiper PA-28 · Rio, WIJul 28, 1972 · N5450W · Substantial damageNTSB CHI73FEP09Accident · 1 fatalClosedCessna 150F · Lakewood, WIJul 22, 1972 · N7109F · Substantial damageNTSB CHI73FEP06Incident · No injuriesClosedSiai-Marche 20522R · Juneau, WIJul 22, 1972 · N732W · Minor damageNTSB CHI73FEP11Accident · No injuriesClosedCessna 172G · North Freedom, WIJul 21, 1972 · N5885R · Substantial damageNTSB CHI73FEP01Accident · No injuriesClosedPiper PA-28 · Milwaukee, WIJul 4, 1972 · N4472T · Substantial damageNTSB CHI72DEP52Accident · No injuriesClosedCessna 172 · Sturtevant, WIJun 19, 1972 · N7514X · Substantial damageNTSB CHI72DEP47Accident · No injuriesClosedChampion 7ECA · Dousman, WIJun 6, 1972 · N11852 · Substantial damageNTSB CHI72DEP39Accident · No injuriesClosedPiper PA-28 · Portage, WIMay 7, 1972 · N6218W · Substantial damageNTSB CHI72DEP41Accident · No injuriesClosedMooney M20C · Weston, WIApr 30, 1972 · N6821N · Substantial damageNTSB CHI72DEP40Accident · No injuriesClosedCessna 210 · Withee, WIApr 20, 1972 · N3935Y · Substantial damageNTSB CHI72DEP38Accident · No injuriesClosedCessna 182K · Green Bay, WIApr 6, 1972 · N3135Q · Substantial damageNTSB CHI72DEP36Accident · No injuriesClosedPiper PA-28 · Ashland, WIMar 23, 1972 · N7290F · Substantial damageNTSB CHI72DEP33Accident · No injuriesClosedCessna 177 · Racine, WIMar 11, 1972 · N3134T · Substantial damageNTSB CHI72IC063Incident · No injuriesClosedBeech 95-B55 · Milwaukee, WIFeb 5, 1972 · N48034 · Minor damageNTSB CHI72DEP29Accident · No injuriesClosedCessna 150D · Viroqua, WIJan 18, 1972 · N4178U · Substantial damageNTSB CHI72FEP25Accident · No injuriesClosedCessna 172 · Delavan, WIJan 9, 1972 · N5875A · Substantial damage