NTSB investigations, 1978, WI

31 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 1978, 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\") = 1978
    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 CHI79FEP20Accident · No injuriesClosedCessna 207 · Lyndon Station, WIDec 29, 1978 · N1688U · Substantial damageNTSB CHI79DEP17Accident · No injuriesClosedPiper PA-24 · Eau Claire, WIDec 28, 1978 · N6175P · Substantial damageNTSB CHI79DEP15Accident · No injuriesClosedPiper PA-28R · Waupun, WIDec 17, 1978 · N7607J · Substantial damageNTSB CHI79DEP12Accident · No injuriesClosedCessna 210 · Land O'Lakes, WIDec 13, 1978 · N8110G · Substantial damageNTSB CHI79DEP10Accident · No injuriesClosedPiper PA-22 · Middleton, WIDec 2, 1978 · N3666Z · Substantial damageNTSB CHI79DEP11Accident · No injuriesClosedPiper PA-28 · Park Falls, WIDec 1, 1978 · N55845 · Substantial damageNTSB CHI79DEP08Accident · No injuriesClosedMooney M20J · Dodgeville, WINov 19, 1978 · N201SJ · Substantial damageNTSB CHI79DEP05Accident · Minor injuriesClosedCessna 172 · Shawano, WIOct 30, 1978 · N8313X · Substantial damageNTSB CHI79FEP04Accident · No injuriesClosedPiper PA-28 · Tomahawk, WIOct 18, 1978 · N5629W · Substantial damageNTSB CHI79DEP02Accident · Minor injuriesClosedThorp T-18 · Middleton, WIOct 6, 1978 · N493TK · DestroyedNTSB CHI79DEP01Accident · No injuriesClosedPiper PA-23 · Platteville, WIOct 2, 1978 · N555DG · Substantial damageNTSB CHI78FA069Accident · No injuriesClosedPiper PA-28R · Markesan, WISep 7, 1978 · N4508J · Substantial damageNTSB CHI78FEP66Accident · No injuriesClosedCessna 150 · Kenosha, WISep 3, 1978 · N66238 · Substantial damageNTSB CHI78DEP57Accident · No injuriesClosedCessna 185 · Juneau, WIAug 19, 1978 · N2638Z · Substantial damageNTSB CHI78FEP56Accident · No injuriesClosedCessna 172M · Oshkosh, WIAug 3, 1978 · N172TC · 2 aircraft · Minor damageNTSB CHI78FEP58Accident · No injuriesClosedHughes 269C · Stoughton, WIAug 2, 1978 · N7485F · Substantial damageNTSB CHI78FEP53Accident · Minor injuriesClosedCessna 195B · Oshkosh, WIJul 29, 1978 · N2117C · 2 aircraft · Substantial damageNTSB DCA78IA018Incident · No injuriesClosedDouglas DC-9 · Oshkosh, WIJul 21, 1978 · N959N · Minor damageNTSB CHI78DEP42Accident · No injuriesClosedCessna 210M · Mercer, WIJul 7, 1978 · N732UE · Substantial damageNTSB CHI78DER05Accident · No injuriesClosedGrumman AA-5B · Birchwood, WIJun 24, 1978 · N28402 · Substantial damageNTSB CHI78DEP32Accident · Minor injuriesClosedCessna 150 · Baileys Harbor, WIMay 16, 1978 · N60536 · Substantial damageNTSB CHI78DER04Accident · No injuriesClosedCessna 150L · Grantsburg, WIApr 30, 1978 · N150L · Substantial damageNTSB CHI78FEP30Accident · No injuriesClosedCessna 172 · Middleton, WIApr 29, 1978 · N8969B · Substantial damageNTSB CHI78DEP31Accident · No injuriesClosedCessna 172 · Middleton, WIApr 13, 1978 · N73362 · Substantial damageNTSB CHI78DEP27Accident · No injuriesClosedCessna 150 · Black River, WIMar 22, 1978 · N18162 · Substantial damageNTSB CHI78FEP28Accident · No injuriesClosedCessna 177RG · Dodgeville, WIMar 21, 1978 · N2011Q · Substantial damageNTSB CHI78DEP25Accident · No injuriesClosedCessna 152 · Milwaukee, WIMar 12, 1978 · N24337 · Substantial damageNTSB CHI78DEP18Accident · No injuriesClosedCessna 150F · Necedah, WIFeb 20, 1978 · N8617G · Substantial damageNTSB CHI78FEP21Accident · No injuriesClosedCessna 172H · Fond Du Lac, WIFeb 17, 1978 · N2760L · Substantial damageNTSB CHI78FEP11Accident · No injuriesClosedCessna 172L · Waukesha, WIJan 15, 1978 · N7699G · Substantial damageNTSB CHI78DER02Accident · No injuriesClosedPiper PA-28 · Amery, WIJan 9, 1978 · N8005W · Substantial damage