Fatal NTSB investigations, IL

53 cases where the phase of flight was Uncontrolled descent.

Cases per year

19642026
Fatal NTSB investigations, IL per year, 1964–2026: 53 cases
19641
19652
19666
19672
19681
19693
19703
19714
19723
19733
19742
19753
19763
19772
19783
19795
19802
19813
19831
20251

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 c.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 650)
  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 ERA25FA179Accident · 4 fatalClass 3 · FieldPreliminary reportCessna 180 · Trilla, ILOn April 19, 2025, at 1016 central daylight time, a Cessna 180G, N4679U, was destroyed when it was involved in an accident near Trilla, Illinois. The private pilot and three passengers were fatally injured. The airplane was operated under Title 14 Code of…Apr 19, 2025 · N4679U · DestroyedNTSB CHI83FA148Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Rochester, ILThe acft experienced an in-flt break-up during descent. The pilot had reported on the radio to Kansas city ARTCC that hewas having severe chest pains and shortness of breath. Radar contact with the plane was lost at 1425 CST. The pilot had reported he was…Mar 21, 1983 · N1057Q · DestroyedNTSB CHI81FA085Accident · 2 fatalClosedPiper PA-28R · Chicago, ILAug 2, 1981 · N7631J · DestroyedNTSB CHI81FA082Accident · 2 fatalClosedBellanca 7ECA · Delevan, ILAug 2, 1981 · N86580 · DestroyedNTSB CHI81FA022Accident · 1 fatalClosedCessna 150M · Timewell, ILJan 25, 1981 · N63090 · DestroyedNTSB CHI80FA069Accident · 1 fatalClosedCessna 150J · Akin, ILSep 22, 1980 · N60771 · DestroyedNTSB CHI80FA034Accident · 3 fatalClosedCessna 182 · Alhambra, ILApr 13, 1980 · N6405A · DestroyedNTSB CHI80FEV07Accident · 1 fatalClosedAmerican AA-1B · Charleston, ILNov 22, 1979 · N6245L · DestroyedNTSB CHI79FA061Accident · 1 fatalClosedMooney M20C · Brocton, ILJul 26, 1979 · N6217U · DestroyedNTSB CHI79FA057Accident · 3 fatalClosedPiper PA-22 · St Charles, ILJul 4, 1979 · N3027Z · DestroyedNTSB CHI79FA052Accident · 2 fatalClosedCessna 172M · Chenoa, ILJul 3, 1979 · N64168 · DestroyedNTSB CHI79AA041Accident · 6 fatalClosedBeech 58TC · St.Anne, ILApr 7, 1979 · N17994 · DestroyedNTSB CHI79FA011Accident · 1 fatalClosedPiper PA-24 · Ashton, ILOct 25, 1978 · N8666P · Substantial damageNTSB CHI79FA028Accident · 1 fatalClosedPiper PA-32R · Rock Falls, ILMar 14, 1978 · N7299C · DestroyedNTSB CHI78FA025Accident · 3 fatalClosedCessna T210M · Beecher, ILMar 12, 1978 · N761EJ · DestroyedNTSB CHI77FA073Accident · 2 fatalClosedBeech C90 · Pontiac, ILSep 23, 1977 · N23796 · DestroyedNTSB CHI77FA064Accident · 4 fatalClosedPiper PA-28R · De Witt, ILAug 6, 1977 · N3009Q · DestroyedNTSB CHI77FA014Accident · 3 fatalClosedCessna 172M · Vandalia, ILDec 11, 1976 · N64024 · DestroyedNTSB CHI77FA002Accident · 1 fatalClosedCessna 177B · Manteno, ILOct 3, 1976 · N34434 · DestroyedNTSB CHI76AC093Accident · 3 fatalClosedCessna T210L · Peoria, ILSep 26, 1976 · N732AB · DestroyedNTSB CHI76AC013Accident · 6 fatalClosedPiper PA-32 · Chandlerville, ILAug 14, 1975 · N3287W · DestroyedNTSB CHI75AC091Accident · 5 fatalClosedCessna 177B · Carpentersvile, ILMay 24, 1975 · N30836 · DestroyedNTSB CHI75AC078Accident · 2 fatalClosedPiper PA-28 · Trimble, ILApr 14, 1975 · N95243 · DestroyedNTSB CHI75AC015Accident · 1 fatalClosedCessna 172F · Mayview, ILAug 11, 1974 · N5533R · DestroyedNTSB CHI74AC062Accident · 1 fatalClosedPiper PA-32 · Chicago, ILJan 17, 1974 · N3998W · DestroyedNTSB CHI74AC054Accident · 4 fatalClosedBeech A23A · Cabery, ILDec 28, 1973 · N2303W · DestroyedNTSB CHI74AC029Accident · 1 fatalClosedAerostar 601 · Chicago, ILOct 3, 1973 · N8MW · DestroyedNTSB CHI74AC012Accident · 1 fatalClosedCessna 182J · Chicago, ILAug 6, 1973 · N3147F · DestroyedNTSB NYC73AN081Accident · 4 fatalClosedPiper PA-28 · Grand Tower, ILDec 8, 1972 · N4235T · DestroyedNTSB CHI72AC094Accident · 4 fatalClosedPiper PA-24 · Ramsey, ILMay 28, 1972 · N5796P · DestroyedNTSB CHI72AC071Accident · 3 fatalClosedCessna 172G · Orion, ILMar 12, 1972 · N4246L · DestroyedNTSB CHI72AC009Accident · 2 fatalClosedCessna 182K · Springfield, ILJul 23, 1971 · N7600K · DestroyedNTSB CHI72AC003Accident · 5 fatalClosedPiper PA-24 · Philo, ILJul 4, 1971 · N9120P · DestroyedNTSB CHI71FBD65Accident · 1 fatalClosedPiper PA-28 · Kewanee, ILApr 19, 1971 · N6418R · Substantial damageNTSB CHI71AC064Accident · 5 fatalClosedPiper PA-32 · Geneva, ILMar 13, 1971 · N3955W · DestroyedNTSB CHI71AC042Accident · 3 fatalClosedPiper PA-28 · Effingham, ILDec 17, 1970 · N4253J · DestroyedNTSB CHI71AC016Accident · 4 fatalClosedPiper PA-28 · Manteno, ILAug 22, 1970 · N5684U · DestroyedNTSB CHI70AC074Accident · 2 fatalClosedCessna 336 · Chicago, ILApr 28, 1970 · N3815U · DestroyedNTSB CHI70A0032Accident · 1 fatalClosedPiper PA-32 · Northlake, ILNov 10, 1969 · N3262W · DestroyedNTSB MKC70A0027Accident · 2 fatalClosedCessna 150E · Esmond, ILNov 9, 1969 · N426RA · DestroyedNTSB CHI69A0096Accident · 1 fatalClosedCessna 150G · Ofallon, ILMay 20, 1969 · N3655J · DestroyedNTSB CHI68A0092Accident · 1 fatalClosedPiper PA-23 · Warrensburg, ILApr 19, 1968 · N1007P · DestroyedNTSB CHI68A0030Accident · 2 fatalClosedCessna 310H · Coal Valley, ILSep 26, 1967 · N1148Q · DestroyedNTSB CHI68F0391Accident · 1 fatalClosedPiper J3C-65 · Wheeling, ILJul 9, 1967 · N42978 · DestroyedNTSB CHI67A0076Accident · 2 fatalClosedErco 415C · Pekin, ILDec 16, 1966 · N3725H · DestroyedNTSB CHI67A0068Accident · 1 fatalClosedBeech M35 · Rollg Meadows, ILNov 26, 1966 · N9762R · DestroyedNTSB CHI67A0043Accident · 1 fatalClosedCessna 172 · Sailor Sprngs, ILSep 25, 1966 · N5194A · DestroyedNTSB CHI66A0102Accident · 4 fatalClosedAero Comdr 200D · Chicago, ILJun 29, 1966 · N2911T · DestroyedNTSB CHI66A0098Accident · 6 fatalClosedPiper PA-24 · Alexis, ILJun 15, 1966 · N8929P · DestroyedNTSB CHI66A0078Accident · 3 fatalClosedNavion L-17B · Aroma Park, ILMar 24, 1966 · N6076V · Destroyed