NTSB investigations, 1973, WI

31 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 1973, 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\") = 1973
    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 CHI74DEP27Accident · No injuriesClosedCessna 172 · Kenosha, WIDec 29, 1973 · N7120G · Substantial damageNTSB CHI74FEP20Accident · No injuriesClosedHelio Acft H-391B · Eau Claire, WIOct 17, 1973 · N8750R · Substantial damageNTSB CHI74DER03Accident · No injuriesClosedCessna 150L · Durand, WIOct 14, 1973 · N17295 · Substantial damageNTSB CHI74FEP18Accident · No injuriesClosedBeech V35G · Manitowish W, WIOct 6, 1973 · N4647D · Substantial damageNTSB CHI74FEP17Accident · No injuriesClosedPiper PA-22 · Arena, WISep 22, 1973 · N6838B · Substantial damageNTSB CHI74FEP15Accident · Minor injuriesClosedErco 415C · Portage, WISep 20, 1973 · N2244H · Substantial damageNTSB CHI74FEP07Accident · Serious injuriesClosedCessna 150D · Crandon, WISep 8, 1973 · N4537U · Substantial damageNTSB CHI74DEP16Accident · No injuriesClosedPiper PA-28 · Elkhorn, WISep 2, 1973 · N3498K · Substantial damageNTSB CHI74DEP13Accident · Minor injuriesClosedBolkow 150FF · Bristol, WIAug 20, 1973 · N209AJ · Substantial damageNTSB CHI74DEP14Accident · Minor injuriesClosedCessna 177 · Shawano, WIAug 15, 1973 · N2957X · Substantial damageNTSB CHI74FEP08Accident · Minor injuriesClosedBeech D50 · Walworth, WIAug 9, 1973 · N4977B · DestroyedNTSB CHI73DEP69Accident · No injuriesClosedCessna 140A · Milwaukee, WIJun 29, 1973 · N1116D · Substantial damageNTSB CHI73DEP68Accident · Minor injuriesClosedPiper PA-24 · Tigerton, WIJun 26, 1973 · N9287P · DestroyedNTSB CHI73FEP67Accident · No injuriesClosedFairchild F-24 · Portage, WIJun 24, 1973 · N77697 · Substantial damageNTSB CHI73DEP65Accident · Minor injuriesClosedPiper PA-22 · Kenosha, WIJun 15, 1973 · N7316D · Substantial damageNTSB CHI73FEP64Accident · No injuriesClosedCessna 310Q · Viroqwa, WIJun 12, 1973 · N6292Q · Substantial damageNTSB CHI73FEP62Accident · No injuriesClosedPiper PA-28 · Elkhorn, WIMay 30, 1973 · N3498K · Substantial damageNTSB CHI73FEP59Accident · No injuriesClosedLuscombe 8A · Middleton, WIMay 20, 1973 · N71318 · Substantial damageNTSB CHI73FEP58Accident · No injuriesClosedCessna 182M · Burlington, WIMay 20, 1973 · N91835 · Substantial damageNTSB CHI73DEP57Accident · No injuriesClosedCessna 172G · Wilmot, WIMay 17, 1973 · N5767R · Substantial damageNTSB CHI73FEP55Accident · No injuriesClosedCessna 310C · Burlington, WIMay 9, 1973 · N55KM · Substantial damageNTSB CHI73FEP54Accident · No injuriesClosedTaylorcraft BC1265 · Waunakee, WIMay 5, 1973 · N36466 · Substantial damageNTSB CHI73DEP42Accident · No injuriesClosedCessna 150 · Sheboygan, WIMay 3, 1973 · N18690 · Substantial damageNTSB CHI73FEP50Accident · Serious injuriesClosedBeech 35-A33 · West Bend, WIApr 30, 1973 · N563T · Substantial damageNTSB CHI73FEP52Accident · No injuriesClosedMaule M-4 · Batavia, WIApr 29, 1973 · N4622T · Substantial damageNTSB CHI73DEP48Accident · No injuriesClosedCessna 150K · Rhinelander, WIApr 13, 1973 · N6243G · Substantial damageNTSB CHI73DEP46Accident · No injuriesClosedPiper PA-22 · Phillips, WIMar 30, 1973 · N7814D · Substantial damageNTSB CHI73DEP45Accident · No injuriesClosedPiper PA-28 · Middleton, WIMar 30, 1973 · N686FL · Substantial damageNTSB CHI73DEP44Accident · No injuriesClosedPiper PA-22 · Middleton, WIMar 26, 1973 · N2849P · Substantial damageNTSB CHI73DEP36Accident · No injuriesClosedCessna 182M · Waukesha, WIJan 28, 1973 · N70938 · Substantial damageNTSB CHI73DEP37Accident · No injuriesClosedPiper PA-28 · Shawano, WIJan 7, 1973 · N8700N · Substantial damage