NTSB investigations, 1978, IL

21 cases where the phase of flight was Approach.

Cases per year

19632026
NTSB investigations, 1978, IL per year, 1963–2026: 625 cases
19631
196423
196515
196620
196733
196831
196928
197020
197125
197221
197320
197417
197520
197611
197720
197821
197920
198019
198116
19827
198310
198413
19859
198612
19876
198815
19898
19908
19917
199210
19936
19948
19956
19964
19974
19983
19992
20006
20013
20025
20034
20042
20054
20066
20075
200810
20093
20105
20114
20124
20135
20146
20154
20162
20173
20181
20192
20203
20211
20223
20237
20243
20255

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 = 500)
  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 CHI79DEE27Accident · Minor injuriesClosedCessna 172-K · Lansing, ILDec 12, 1978 · N79035 · Substantial damageNTSB CHI79FA018Accident · 3 fatalClosedBeech V35A · Wheeling, ILDec 3, 1978 · N6DF · DestroyedNTSB CHI79DEE23Accident · No injuriesClosedRaven S60A · Fox River Grve, ILOct 24, 1978 · N1918R · Substantial damageNTSB CHI79DEE07Accident · No injuriesClosedBalloon WKS FF7 · Grayslake, ILOct 24, 1978 · N2313H · Substantial damageNTSB CHI79FEE08Accident · No injuriesClosedCessna 182 · Hinckley, ILOct 21, 1978 · N6258A · Substantial damageNTSB CHI78FCA03Accident · No injuriesClosedCessna 150M · Cahokia, ILSep 22, 1978 · N714LV · Substantial damageNTSB CHI78FEE64Accident · No injuriesClosedPiper PA-23 · Frankfort, ILAug 29, 1978 · N303EB · Substantial damageNTSB CHI78FEV48Accident · Minor injuriesClosedCessna U206F · Yates City, ILAug 6, 1978 · N50625 · Substantial damageNTSB CHI78FA052Accident · 2 fatalClosedPiper PA-22 · East Moline, ILAug 6, 1978 · N3217B · 2 aircraft · DestroyedNTSB CHI78FEE51Accident · No injuriesClosedSchweizer SGU222 · Park Forest, ILJul 9, 1978 · N9848E · Substantial damageNTSB CHI78FCA01Accident · Minor injuriesClosedNavion NAV-4 · Bethalto, ILJun 25, 1978 · N4992K · Substantial damageNTSB CHI78FA045Accident · 3 fatalClosedPiper PA-23 · Belleville, ILJun 25, 1978 · N3284P · DestroyedNTSB CHI78DEE55Accident · Serious injuriesClosedSemco AX7 · Mchenry, ILJun 24, 1978 · N35996 · Substantial damageNTSB CHI78DEV39Accident · No injuriesClosedPiper PA-28 · Mclean, ILJun 19, 1978 · N2488M · Substantial damageNTSB CHI78FCA02Accident · Serious injuriesClosedPiper PA-16 · Columbia, ILJun 18, 1978 · N5907H · Substantial damageNTSB CHI78FEE30Accident · No injuriesClosedN American NA265 · West Chicago, ILApr 24, 1978 · N600BP · Substantial damageNTSB CHI78FA031Accident · 3 fatalClosedBeech H18 · Centreville, ILMar 25, 1978 · N58JM · DestroyedNTSB CHI78DEE57Accident · No injuriesClosedPiper PA-30 · Monee, ILMar 6, 1978 · N8665Y · Substantial damageNTSB CHI78DEV21Accident · No injuriesClosedCessna 152 · Peoria, ILMar 5, 1978 · N25038 · Substantial damageNTSB CHI78DEE28Accident · No injuriesClosedCessna 150M · West Chicago, ILMar 5, 1978 · N704LF · Substantial damageNTSB CHI78FEV11Accident · Serious injuriesClosedPiper PA-28 · Savoy, ILJan 5, 1978 · N7784N · Substantial damage