NTSB investigations, 1978, IL

60 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 1978, 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\") = 1978
    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 CHI79DEE24Accident · No injuriesClosedSchuster WAS2 · Ottawa, ILDec 28, 1978 · N9120 · Substantial damageNTSB CHI79DEE22Accident · No injuriesClosedCessna 150 · Naperville, ILDec 26, 1978 · N1294Q · Substantial damageNTSB CHI79FEE19Accident · No injuriesClosedBeech D-50 · S.Barrington, ILDec 22, 1978 · N150V · Substantial damageNTSB CHI79DEE25Accident · No injuriesClosedPiper PA-38 · Schaumburg, ILDec 19, 1978 · N2560A · Substantial damageNTSB CHI79FEE21Accident · No injuriesClosedCessna 150 · Mendota, ILDec 17, 1978 · N23JR · Substantial damageNTSB CHI79FEE16Accident · No injuriesClosedPiper PA-30 · Kankakee, ILDec 16, 1978 · N8143Y · Substantial damageNTSB CHI79DEV09Accident · No injuriesClosedCessna 150 · Danville, ILDec 16, 1978 · N10739 · Substantial damageNTSB CHI79DEE33Accident · No injuriesClosedPiper PA-28 · Elgin, ILDec 15, 1978 · N44105 · Substantial damageNTSB CHI79DEV06Accident · No injuriesClosedCessna 150 · Monmouth, ILDec 9, 1978 · N704PT · Substantial damageNTSB CHI79DEV05Accident · No injuriesClosedCessna 152 · Peoria, ILDec 9, 1978 · N24792 · Substantial damageNTSB CHI79FEE18Accident · No injuriesClosedPiper PA-32 · West Chicago, ILDec 7, 1978 · N4175R · Substantial damageNTSB CHI79FA019Accident · Minor injuriesClosedCessna 401A · Rockford, ILDec 7, 1978 · N6247Q · Substantial damageNTSB CHI79FEE15Accident · No injuriesClosedCessna 411A · West Chicago, ILDec 4, 1978 · N3262R · Substantial damageNTSB CHI79DEV04Accident · No injuriesClosedCessna 310 · Peoria, ILNov 20, 1978 · N7872Q · Substantial damageNTSB CHI79FEE68Accident · No injuriesClosedPiper PA-28 · Elgin, ILOct 25, 1978 · N5163L · Substantial damageNTSB CHI79FEE03Accident · No injuriesClosedBeech 58 · Moline, ILOct 18, 1978 · N9367Q · Substantial damageNTSB CHI78FCA04Accident · No injuriesClosedCessna 172M · Cahokia, ILSep 26, 1978 · N20471 · Substantial damageNTSB CHI79FA008Accident · Minor injuriesClosedPiper PA-32 · Lansing, ILSep 25, 1978 · N44295 · Substantial damageNTSB CHI79FEE72Accident · Minor injuriesClosedEnstrom F-28A · North Chicago, ILSep 20, 1978 · N612B · Substantial damageNTSB CHI78DEE69Accident · No injuriesClosedCessna 172 · Princeton, ILSep 4, 1978 · N1417U · Substantial damageNTSB CHI78DEE71Accident · No injuriesClosedThorp T-18 · Schaumburg, ILSep 1, 1978 · N711RF · Substantial damageNTSB CHI78DEE63Accident · No injuriesClosedPiper PA-32R · Princeton, ILAug 22, 1978 · N101DR · Substantial damageNTSB CHI79FEE59Accident · Minor injuriesClosedGreat Lakes 2T-1A2 · West Chicago, ILAug 13, 1978 · N3725F · Substantial damageNTSB CHI78FA055Accident · Minor injuriesClosedBeech D18S · Chicago, ILAug 8, 1978 · N79R · DestroyedNTSB CHI78FEE60Accident · No injuriesClosedCessna 320C · West Chicago, ILJul 31, 1978 · N3021T · Substantial damageNTSB CHI78FEE47Accident · Minor injuriesClosedBeech 35-B33 · Rockford, ILJul 28, 1978 · N9798Y · Substantial damageNTSB CHI78FEE58Accident · No injuriesClosedPiper PA-30 · Wheeling, ILJul 26, 1978 · N8788Y · Substantial damageNTSB CHI78FEV43Accident · No injuriesClosedCessna 310P · Peoria, ILJul 14, 1978 · N310AM · Substantial damageNTSB CHI78FEE56Accident · No injuriesClosedBeech 65-90 · Chicago, ILJul 12, 1978 · N742UT · Substantial damageNTSB CHI78FEV44Accident · No injuriesClosedCessna 150 · Peoria, ILJul 8, 1978 · N45530 · Substantial damageNTSB CHI78FEE53Accident · Serious injuriesClosedBrantly B2B · Huntley, ILJul 8, 1978 · N2100U · DestroyedNTSB CHI78FEE50Accident · No injuriesClosedPiper PA-28 · Kankakee, ILJul 4, 1978 · N6116H · Substantial damageNTSB CHI78FEE52Accident · No injuriesClosedBeech B19 · Moline, ILJul 1, 1978 · N6507R · Substantial damageNTSB CHI78FEV41Accident · No injuriesClosedPiper PA-20 · Galesburg, ILJun 28, 1978 · N7323K · Substantial damageNTSB CHI78FEV37Accident · No injuriesClosedPiper PA-28 · Bloomington, ILJun 13, 1978 · N2257Q · Substantial damageNTSB CHI78DEV38Accident · No injuriesClosedCessna 188 · Ashmore, ILJun 9, 1978 · N4729R · Substantial damageNTSB CHI78FEE43Accident · No injuriesClosedAerostar 601P · West Chicago, ILJun 5, 1978 · N711NW · Substantial damageNTSB CHI78FEV36Accident · No injuriesClosedPiper PA-28 · Palestine, ILMay 26, 1978 · N3592R · Substantial damageNTSB CHI78DEV35Accident · No injuriesClosedHughes 269C · Maroa, ILMay 26, 1978 · N7473F · Substantial damageNTSB CHI78DEV32Accident · No injuriesClosedPiper PA-28 · Macomb, ILMay 20, 1978 · N9258C · Substantial damageNTSB CHI78FEE37Accident · Minor injuriesClosedCessna 337 · Dupage, ILMay 17, 1978 · N2180X · Substantial damageNTSB CHI78FEE36Accident · No injuriesClosedCessna 152 · Belvidere, ILMay 2, 1978 · N757EE · Substantial damageNTSB CHI78DEE39Accident · No injuriesClosedPiper PA-28 · Mendota, ILApr 30, 1978 · N8765N · Substantial damageNTSB CHI78DEV31Accident · No injuriesClosedMustang P-51 · Gibson City, ILApr 29, 1978 · N37952 · Substantial damageNTSB CHI78FEE31Accident · No injuriesClosedAmateur SA-300 · Dekalb, ILApr 27, 1978 · N2369 · Substantial damageNTSB CHI78DEE32Accident · Minor injuriesClosedCessna 210 · Annawan, ILApr 25, 1978 · N4850U · Substantial damageNTSB CHI78FEV29Accident · No injuriesClosedBeech C-23 · Peoria, ILApr 16, 1978 · N24026 · Substantial damageNTSB CHI78FEV30Accident · No injuriesClosedPiper PA-32 · Urbana, ILApr 9, 1978 · N1BQ · Substantial damageNTSB CHI78FEV23Accident · No injuriesClosedCessna 152 · Monmouth, ILMar 27, 1978 · N24242 · 2 aircraft · Substantial damageNTSB CHI78DEE29Accident · No injuriesClosedCessna 150M · Lansing, ILMar 10, 1978 · N9215U · Substantial damage