NTSB investigations, 1968, IL

89 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 1968, IL per year, 1964–2026: 1,788 cases
196491
196578
1966103
1967120
196889
196971
197073
197163
197252
197359
197453
197547
197653
197742
197860
197944
198038
198140
198238
198340
198434
198516
198622
198722
198822
198922
199021
199113
199219
199312
199413
19958
199616
199711
199812
199915
200012
200115
200210
200322
200410
20059
20068
20079
200815
20099
201014
201118
20128
20132
20146
201510
20169
20178
20188
20198
20209
20214
202210
20238
20246
20257
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\") = 1968
    AND c.\"eventStateOrRegion\" = 'IL' 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 CHI69D0456Accident · No injuriesClosedPiper PA-24 · Wheeling, ILDec 26, 1968 · N8702P · Substantial damageNTSB CHI69D0437Accident · No injuriesClosedCessna 150G · Streator, ILDec 24, 1968 · N6227S · Substantial damageNTSB CHI69D0458Accident · No injuriesClosedBeech B-35 · Granite City, ILDec 18, 1968 · N3331V · Substantial damageNTSB CHI69D0436Accident · No injuriesClosedLuscombe 8A · Waukegan, ILDec 16, 1968 · N45630 · Substantial damageNTSB CHI69F0420Accident · No injuriesClosedBeech E35 · Roselle, ILDec 14, 1968 · N3259C · Substantial damageNTSB CHI69I0062Incident · No injuriesClosedBoeing 720 · Chicago, ILDec 13, 1968 · N7217U · Minor damageNTSB CHI69D0505Accident · No injuriesClosedPiper PA-28 · Sheldon, ILDec 11, 1968 · N9353W · Substantial damageNTSB CHI69A0060Accident · No injuriesClosedBeech C-45G · Chicago, ILDec 11, 1968 · N7697C · Substantial damageNTSB CHI69A0058Accident · No injuriesClosedCessna 150E · Sandwich, ILDec 8, 1968 · N3984U · 2 aircraft · Substantial damageNTSB CHI69D0388Accident · No injuriesClosedCessna P206 · Ottawa, ILDec 6, 1968 · N2568X · Substantial damageNTSB CHI69D0407Accident · No injuriesClosedBeech C35 · Chicago, ILDec 3, 1968 · N740D · Substantial damageNTSB CHI69D0383Accident · No injuriesClosedBeech A23-19 · Oswego, ILDec 1, 1968 · N5662S · Substantial damageNTSB CHI69D0646Accident · No injuriesClosedMooney M-20 · Carthage, ILNov 28, 1968 · N852B · Substantial damageNTSB CHI69A0057Accident · Minor injuriesClosedDouglas A-26B · Chicago, ILNov 26, 1968 · N919P · Substantial damageNTSB CHI69F0390Accident · No injuriesClosedCessna 140A · Lincoln, ILNov 24, 1968 · N9454A · Substantial damageNTSB CHI69D0372Accident · No injuriesClosedPiper PA-24 · Roselle, ILNov 24, 1968 · N7668P · Substantial damageNTSB CHI69D0374Accident · No injuriesClosedCessna 310C · Wheeling, ILNov 23, 1968 · N1883H · Substantial damageNTSB CHI69D0394Accident · No injuriesClosedPiper PA-28 · Wheeling, ILNov 10, 1968 · N6494J · Substantial damageNTSB CHI69D0366Accident · No injuriesClosedPiper PA-24 · Midlothian, ILNov 5, 1968 · N5167P · Substantial damageNTSB CHI69D0325Accident · No injuriesClosedCessna 320 · Rockford, ILOct 23, 1968 · N3062T · Substantial damageNTSB CHI69D0320Accident · No injuriesClosedBeech 35 · Huntley, ILOct 20, 1968 · N3745N · Substantial damageNTSB CHI69D0324Accident · No injuriesClosedCessna 182 · Morris, ILOct 13, 1968 · N2692F · Substantial damageNTSB CHI69D0265Accident · No injuriesClosedCessna 210D · Northbrook, ILOct 5, 1968 · N3939Y · Substantial damageNTSB CHI69D0312Accident · No injuriesClosedStinson 108-1 · Northbrook, ILOct 2, 1968 · N8849K · Substantial damageNTSB CHI69F0246Accident · Minor injuriesClosedCessna 150 · Wheeling, ILSep 28, 1968 · N2099Z · Substantial damageNTSB CHI69D0305Accident · No injuriesClosedPiper PA-18 · Lansing, ILSep 28, 1968 · N1232A · Substantial damageNTSB CHI69D0330Accident · No injuriesClosedPiper PA-23 · Northbrook, ILSep 24, 1968 · N1064P · Substantial damageNTSB CHI69F0261Accident · No injuriesClosedCessna 320D · Rockford, ILSep 19, 1968 · N4183T · Substantial damageNTSB CHI69F0288Accident · No injuriesClosedBeech J50 · Springfield, ILSep 15, 1968 · N95A · Substantial damageNTSB CHI69F0511Accident · Serious injuriesClosedPiper PA-28 · Monticello, ILSep 12, 1968 · N9114W · Substantial damageNTSB CHI69F0203Accident · Minor injuriesClosedCessna 150 · Alton, ILSep 7, 1968 · N22959 · Substantial damageNTSB CHI69F0315Accident · No injuriesClosedPiper PA-23 · Danville, ILSep 5, 1968 · N524PR · Substantial damageNTSB CHI69F0342Accident · No injuriesClosedPiper PA-31 · Paris, ILSep 4, 1968 · N9088Y · Substantial damageNTSB CHI69F0194Accident · No injuriesClosedCessna 337B · Chicago, ILSep 3, 1968 · N5438S · Substantial damageNTSB CHI69F0234Accident · No injuriesClosedBeech D35 · Bloomington, ILSep 2, 1968 · N4666D · Substantial damageNTSB CHI69D0309Accident · No injuriesClosedLuscombe 8A · Lombard, ILSep 2, 1968 · N71373 · Substantial damageNTSB CHI69D0353Accident · No injuriesClosedPiper PA-16 · Crescent City, ILSep 1, 1968 · N6806K · Substantial damageNTSB CHI69F0224Accident · No injuriesClosedPiper PA-28 · Kilbourne, ILAug 29, 1968 · N5326L · Substantial damageNTSB CHI69D0260Accident · No injuriesClosedNavion A · Park Forest, ILAug 26, 1968 · N8520H · Substantial damageNTSB CHI69D0198Accident · No injuriesClosedBeech E33 · Kankakee, ILAug 18, 1968 · N7135N · Substantial damageNTSB CHI69F0196Accident · No injuriesClosedSmith Mini · Hillsboro, ILAug 17, 1968 · N4694T · Substantial damageNTSB CHI69D0187Accident · No injuriesClosedCessna 150 · Streator, ILAug 15, 1968 · N2440J · Substantial damageNTSB CHI69D0173Accident · No injuriesClosedPiper PA-28 · Northbrook, ILAug 4, 1968 · N4709L · Substantial damageNTSB CHI69D0145Accident · No injuriesClosedBeech A23 · Chenoa, ILJul 28, 1968 · N6935Q · Substantial damageNTSB CHI69F0146Accident · No injuriesClosedCessna 182D · Macomb, ILJul 27, 1968 · N8980X · Substantial damageNTSB CHI69D0184Accident · No injuriesClosedCessna 150 · Wheeling, ILJul 27, 1968 · N8022S · Substantial damageNTSB CHI69D0161Accident · No injuriesClosedCessna 210E · Northbrook, ILJul 24, 1968 · N2356F · Substantial damageNTSB CHI69F0115Accident · No injuriesClosedBeech 95-A55 · Springfield, ILJul 23, 1968 · N511JL · Substantial damageNTSB CHI69F0183Accident · No injuriesClosedCessna 150 · Rockford, ILJul 22, 1968 · N4560U · DestroyedNTSB CHI69D0137Accident · No injuriesClosedCessna 170B · Rochelle, ILJul 18, 1968 · N6095V · Substantial damage