NTSB investigations, 1968, WI

32 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 1968, 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\") = 1968
    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 CHI69D0392Accident · No injuriesClosedCessna 310F · Appleton, WIDec 6, 1968 · N5814X · Substantial damageNTSB CHI69D0531Accident · No injuriesClosedCessna 172 · Ridgeland, WINov 29, 1968 · N3910S · Substantial damageNTSB CHI69D0417Accident · No injuriesClosedCessna 195A · Madison, WINov 26, 1968 · N2187C · Substantial damageNTSB CHI69D0411Accident · No injuriesClosedPiper PA-28 · Appleton, WINov 16, 1968 · N9675J · Substantial damageNTSB CHI69D0371Accident · No injuriesClosedCessna 182 · West Salem, WINov 9, 1968 · N2843R · Substantial damageNTSB CHI69D0318Accident · No injuriesClosedCessna 120 · Richland Ctr, WIOct 12, 1968 · N2874N · Substantial damageNTSB CHI69D0301Accident · Minor injuriesClosedCessna 182C · Waunakee, WISep 22, 1968 · N8585T · Substantial damageNTSB CHI69D0308Accident · No injuriesClosedPiper PA-28 · Albion, WISep 21, 1968 · N6114W · Substantial damageNTSB CHI69D0238Accident · No injuriesClosedChampion 7ECA · Grantsburg, WISep 14, 1968 · N11031 · Substantial damageNTSB CHI69D0270Accident · No injuriesClosedPiper PA-22 · Hales Corners, WIAug 18, 1968 · N2175A · Substantial damageNTSB CHI69D0172Accident · No injuriesClosedCessna 210 · Lake Geneva, WIJul 30, 1968 · N2341F · Substantial damageNTSB CHI69D0218Accident · No injuriesClosedEnstrom F-28A · Port Washngtn, WIJul 27, 1968 · N4462 · DestroyedNTSB CHI69D0393Accident · No injuriesClosedCessna 172 · Bellville, WIJul 23, 1968 · N8740U · Substantial damageNTSB CHI69D0171Accident · No injuriesClosedMooney M20 · Lyndon Sta, WIJul 21, 1968 · N5293B · Substantial damageNTSB CHI69D0291Accident · No injuriesClosedCessna 150 · Woodruff, WIJul 19, 1968 · N6127T · Substantial damageNTSB CHI69D0109Accident · No injuriesClosedPiper PA-28 · Sparta, WIJul 12, 1968 · N6613W · Substantial damageNTSB CHI69D0126Accident · No injuriesClosedCessna 150F · Neenah, WIJun 29, 1968 · N6970F · Substantial damageNTSB CHI69D0025Accident · No injuriesClosedPiper PA-24 · Merrill, WIJun 11, 1968 · N7061P · Substantial damageNTSB CHI69D0108Accident · No injuriesClosedPiper PA-22 · Sherry, WIJun 4, 1968 · N2843Z · Substantial damageNTSB CHI69D0119Accident · No injuriesClosedTaylorcraft BC12-D · Reedsburg, WIJun 2, 1968 · N96105 · Substantial damageNTSB CHI69D0015Accident · No injuriesClosedStinson 108-2 · Burkhardt, WIMay 31, 1968 · N9472K · Substantial damageNTSB CHI69D0029Accident · No injuriesClosedMooney M20A · Kenosha, WIMay 22, 1968 · N8390E · Substantial damageNTSB CHI69D0040Accident · No injuriesClosedBeech T-34A · Milwaukee, WIMay 14, 1968 · N2969C · Substantial damageNTSB CHI69D0012Accident · Minor injuriesClosedCessna 172 · Walworth, WIMay 12, 1968 · N8356X · DestroyedNTSB CHI68D0754Accident · No injuriesClosedCessna 337B · Genoa City, WIMay 7, 1968 · N54385 · Substantial damageNTSB CHI68F0692Accident · No injuriesClosedMooney M20F · Oshkosh, WIMar 5, 1968 · N2907L · Substantial damageNTSB CHI68F0618Accident · No injuriesClosedPiper PA-24 · West Bend, WIFeb 13, 1968 · N7523P · Substantial damageNTSB CHI68F0612Accident · Minor injuriesClosedCessna 177 · Walworth, WIFeb 4, 1968 · N3361T · Substantial damageNTSB CHI68F0583Accident · No injuriesClosedCessna 177 · Middleton, WIFeb 3, 1968 · N2893X · Substantial damageNTSB CHI68D0580Accident · No injuriesClosedPiper PA-22 · Platteville, WIFeb 3, 1968 · N4990Z · Substantial damageNTSB CHI68D0579Accident · No injuriesClosedCessna 172 · Brussels, WIJan 30, 1968 · N5520T · Substantial damageNTSB CHI68D0544Accident · No injuriesClosedCessna 150 · Superior, WIJan 13, 1968 · N2707S · Substantial damage