NTSB investigations, 1978, IL

24 cases where the phase of flight was Enroute.

Cases per year

19632026
NTSB investigations, 1978, IL per year, 1963–2026: 901 cases
19632
196420
196521
196626
196731
196820
196924
197038
197128
197221
197326
197427
197534
197629
197723
197824
197922
198017
198124
198219
198322
198416
198514
198611
198714
198815
198914
199015
199111
199217
199322
199419
199513
199612
199710
199810
199912
200011
200111
200212
20039
20048
200510
20069
200712
20089
20095
20106
20119
20127
20132
20148
20155
201610
20172
20183
20195
20205
20212
20225
20235
20253
20265

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 = 400)
  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 CHI79FCA02Accident · No injuriesClosedMooney M20J · Belleville, ILDec 28, 1978 · N201RY · Substantial damageNTSB CHI79FA021Accident · 2 fatalClosedCessna 210L · Morton, ILDec 19, 1978 · N4638Q · DestroyedNTSB CHI79DEV08Accident · No injuriesClosedBellanca 7G · Meredosia, ILDec 19, 1978 · N53815 · Substantial damageNTSB CHI79FEV07Accident · No injuriesClosedCessna U206G · Casey, ILDec 9, 1978 · N9544M · Substantial damageNTSB CHI79FEE10Accident · No injuriesClosedBeech B19 · Gurnee, ILNov 9, 1978 · N1922W · Substantial damageNTSB CHI79FA014Accident · 4 fatalClosedCessna 210A · Chicago, ILNov 5, 1978 · N695HP · DestroyedNTSB CHI79FEV03Accident · 1 fatalClosedStarduster TOO · Nhenderson, ILNov 4, 1978 · N762RD · DestroyedNTSB CHI79FEE04Accident · No injuriesClosedErco 415-D · Savanna, ILOct 15, 1978 · N99698 · Substantial damageNTSB CHI79FEV01Accident · No injuriesClosedPiper PA-36 · Metropolis, ILOct 9, 1978 · N57760 · Substantial damageNTSB CHI79FCA01Accident · 2 fatalClosedReplica 1 · Pierron, ILOct 1, 1978 · N1912G · DestroyedNTSB CHI78FEE68Accident · Minor injuriesClosedBeech V35B · Dekalb, ILSep 19, 1978 · N23583 · Substantial damageNTSB CHI78FEV52Accident · No injuriesClosedBeech 23 · Minonk, ILSep 1, 1978 · N2301J · Substantial damageNTSB CHI78IA061Incident · No injuriesClosedLockheed L-1011 · Chicago, ILAug 31, 1978 · N701DA · No damageNTSB CHI78FEE65Accident · Minor injuriesClosedPiper PA-28 · New Lenox, ILAug 24, 1978 · N41503 · DestroyedNTSB CHI78FEV50Accident · No injuriesClosedHughes 269C · Chestnut, ILAug 16, 1978 · N7437F · Substantial damageNTSB CHI78IA057Incident · No injuriesClosedDouglas DC-9 · Springfield, ILAug 12, 1978 · N1273L · No damageNTSB CHI78FEE49Accident · Serious injuriesClosedGrum Amer AA1-A · Hillsdale, ILJul 4, 1978 · N9397L · DestroyedNTSB CHI78FEE46Accident · No injuriesClosedCessna 152 · Chicago, ILJun 2, 1978 · N67564 · DestroyedNTSB CHI78FEE41Accident · Minor injuriesClosedCessna 210 · Kewanee, ILMay 27, 1978 · N1797X · Substantial damageNTSB CHI78FEV33Accident · No injuriesClosedCessna 172A · Chrisman, ILMay 10, 1978 · N7282T · Substantial damageNTSB CHI78FEV18Accident · No injuriesClosedCessna 177 · Matoon, ILFeb 26, 1978 · N30105 · Substantial damageNTSB CHI78FEE21Accident · No injuriesClosedCessna 150J · Wedron, ILFeb 12, 1978 · N60731 · Substantial damageNTSB CHI78IA021Incident · No injuriesClosedCessna 210J · Savanna, ILFeb 8, 1978 · N3339S · Minor damageNTSB CHI78FA015Accident · 2 fatalClosedCessna 337G · Marion, ILJan 6, 1978 · N71947 · Destroyed