Fatal NTSB investigations, IL

116 cases where the phase of flight was Approach.

Cases per year

19642026
Fatal NTSB investigations, IL per year, 1964–2026: 116 cases
19643
19652
19662
19671
19686
19691
19704
19713
197210
19736
19742
19755
19763
19777
19784
19795
19803
19812
19822
19831
19864
19883
19895
19902
19913
19922
19931
19942
19951
19981
19991
20002
20011
20021
20062
20071
20081
20102
20111
20121
20131
20141
20151
20202
20221
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 = 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 CEN26FA049Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-28R-201 · Pittsfield, ILOn November 23, 2025, about 2137 central standard time (all referenced times are CST), a Piper PA-28R-201 airplane, N47700, was substantially damaged when it was involved in an accident near Pittsfield, Illinois. The pilot was fatally injured, and the 2…Nov 24, 2025 · N47700 · Substantial damageNTSB CEN23FA046Accident · 1 fatalClass 3 · FieldFinal reportExtra EA300 · Wonder Lake, ILThe pilot’s failure to maintain a proper descent path to the runway after he became disorientated by sun glare while on final approach, which resulted in a collision with trees and terrain.Nov 25, 2022 · N361LX · Substantial damageNTSB CEN20LA367Accident · 1 fatalClass 3 · LimitedFinal reportCirrus SR22 · Lawrenceville, ILThe pilot’s controlled flight into terrain as a result of his failure to properly execute an instrument approach and maintain clearance from trees in night instrument meteorological conditions. Contributing to the accident was the pilot’s unfamiliarity with a…Aug 29, 2020 · N607SR · DestroyedNTSB CEN20FA070Accident · 3 fatalClass 3 · FieldFinal reportPiper PA60 · Springfield, ILThe pilot’s failure to follow the instrument landing system (ILS) course guidance during the instrument approach.Jan 28, 2020 · N6071R · DestroyedNTSB CEN15FA190Accident · 7 fatalField investigationFinal reportCessna 414A · Bloomington, ILThe pilot's failure to maintain control of the airplane during the instrument approach in night instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin. Contributing to the…Apr 7, 2015 · N789UP · Substantial damageNTSB CEN15FA048Accident · 1 fatalField investigationFinal reportAero Commander 500 B · Chicago, ILThe pilot's failure to maintain airspeed while attempting to return to the airport after a reported engine problem, which resulted in an aerodynamic stall/spin.Nov 18, 2014 · N30MB · Substantial damageNTSB CEN13FA558Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Bolingbrook, ILThe pilot’s failure to maintain control of the airplane during a go-around.Sep 25, 2013 · N406DC · DestroyedNTSB CEN12FA271Accident · 2 fatalField investigationFinal reportBeech S35 · Lake in the Hills, ILThe pilot's excessive bank angle while on approach to land, which resulted in an inadvertent aerodynamic stall and spin.May 3, 2012 · N176Q · Substantial damageNTSB CEN12FA086Accident · 3 fatalField investigationFinal reportPiper PA-31-350 · Riverwoods, ILThe pilot's inadequate preflight planning and in-flight decision-making, which resulted in a loss of engine power due to fuel exhaustion during approach. Contributing to the accident was the pilot's decision to operate an airplane after using illicit drugs.Nov 29, 2011 · N59773 · Substantial damageNTSB CEN10FA125Accident · 2 fatalField investigationFinal reportPiper PA 46-350P · Belleville, ILThe pilot’s spatial disorientation and subsequent failure to maintain airplane control during the instrument approach.Feb 22, 2010 · N350WF · DestroyedNTSB CEN10MA088Accident · 2 fatalMajor investigationFinal reportGates Learjet 35A · Prospect Heights, ILA loss of control for undetermined reasons.Jan 5, 2010 · N720RA · Substantial damageNTSB CHI08FA196Accident · 1 fatalField investigationFinal reportCzech Aircraft Works Sport Cruiser · Newark, ILThe pilot's failure to maintain control of the airplane in the landing pattern. Contributing to the severity of injuries was the failure of the pilot's shoulder harness.Jul 21, 2008 · N602CF · Substantial damageNTSB CHI08FA053Accident · 3 fatalField investigationFinal reportBeech V35B · Springfield, ILThe loss of control during an instrument approach due to spatial disorientation.Dec 20, 2007 · N17784 · DestroyedNTSB CHI07FA009Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Lawrenceville, ILThe improper judgment by the pilot to conduct a flight to, and execute an approach to, an airport with weather conditions that were below the required minimums. Also causal was the pilot's continued descent below the approach minimum descent altitude.…Oct 27, 2006 · N1832N · Substantial damageNTSB CHI06FA076Accident · 4 fatalField investigationFinal reportCessna 421B · Wheeling, ILThe pilot's failure to maintain airspeed during the landing approach which led to an inadvertent stall and subsequent uncontrolled descent and impact with the ground.Jan 31, 2006 · N920MC · DestroyedNTSB CHI03FA041Accident · 1 fatalField investigationFinal reportCessna 208B · Rockford, ILThe pilot's failure to maintain control of the airplane during the ILS approach. Factors associated with the accident were the low ceilings, high winds, crosswind, and wind shear conditions that existed.Dec 18, 2002 · N277PM · DestroyedNTSB CHI01FA093Accident · 2 fatalField investigationFinal reportCessna 172H · Centralia, ILThe student pilot allowed the airspeed to get too low and inadvertently stalled the airplane, and the CFI delayed in taking remedial action.Feb 21, 2001 · N733SS · DestroyedNTSB CHI01FA043Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Danville, ILThe pilot's failure to maintain altitude/clearance during the instrument approach. Factors were the low ceilings, the pilot's failure to maintain proper alignment and glidepath during the approach, his lack of recent instrument experience, and his failure to…Nov 27, 2000 · N4541J · DestroyedNTSB CHI00MA066Accident · 3 fatalMajor investigationFinal reportMoravan Z242L · Zion, ILClearance not maintained by the pilot of the other airplane. A factor relating to the accident was the airport control tower's local controller's failure to provide effective sequencing.Feb 8, 2000 · N5ZA · 2 aircraft · DestroyedNTSB CHI99FA278Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Grayslake, ILthe pilot not maintaining altitude and clearance. Factors were the light condition of night, the pilot's lack of recent experience in night operations, and the transmission wire.Aug 6, 1999 · N56718 · DestroyedNTSB CHI98FA082Accident · 1 fatalField investigationFinal reportBeech 95-55 · Pinckneyville, ILThe pilot descent below minimum descent altitude and his intentional operation with known deficiencies in equipment. Factors were the dark night, fog, rain, and the trees.Jan 15, 1998 · N54643 · DestroyedNTSB NYC95FA105Accident · 2 fatalField investigationFinal reportBeech BE60 · Olney, ILThe pilot's improper IFR procedures by descending below the minimum descent altitude and not executing the published missed approach procedures. A factor in thE accident was the low overcast and fog conditions.May 9, 1995 · N81TS · DestroyedNTSB CHI94FA307Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Lincoln, ILThe pilot's failure to maintain airspeed while performing a go-around.Sep 2, 1994 · N4362F · DestroyedNTSB CHI94DEE01Accident · 2 fatalFinal reportRemote Sensing Cirrus VK-30 · Lk In The Hills, ILfuel starvation resulting from the modification of the fuel system. A factor was the modification to the fuel system.Apr 19, 1994 · N108P · DestroyedNTSB CHI93FA153Accident · 2 fatalField investigationFinal reportCessna 150L · De Kalb, ILThe failure of the pilot flying the airplane to maintain an airspeed above stall speed.May 1, 1993 · N6783G · DestroyedNTSB CHI92FA169Accident · 1 fatalField investigationFinal reportMooney M20J · Bloomington, ILThe pilot's failure to maintain aircraft control during the turn from base leg to final approach.Jun 11, 1992 · N302FW · DestroyedNTSB CHI92FA067Accident · 1 fatalField investigationFinal reportBeech A-36TC · Pekin, ILThe pilot-in-command's continued flight into icing conditions and his failure to use the airplane's anti-ice/de-ice system resulting in a build-up of ice over the airplane's surface area and resultant loss of control. Factors which contributed to the accident…Jan 5, 1992 · N345CC · DestroyedNTSB CHI91DEV03Accident · 1 fatalFinal reportHocker Dragonfly · Metropolis, ILPilot's failure to maintain airspeed above stall.Aug 30, 1991 · N28P · DestroyedNTSB CHI91FA216Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Seneca, ILProper glidepath not maintained, and inadequate altitude and visual lookout by the pilot in command.Jul 14, 1991 · N7616W · DestroyedNTSB CHI91FA059Accident · 1 fatalField investigationFinal reportCessna 172P · Freeport, ILThe pilot-in-command's failure to maintain airspeed. Factors contributing were the pilot-in-command's misuse of flaps and his lack of total experience in this type of operation.Jan 6, 1991 · N65567 · DestroyedNTSB CHI90FA263Accident · 2 fatalField investigationFinal reportCessna 172N · Paris, ILThe pilot's continuation of VFR flight into instrument meteorological conditions. Factors contributing to the accident were the fog and the dark night.Sep 13, 1990 · N75785 · DestroyedNTSB CHI90DEV07Accident · 2 fatalFinal reportPitts S2B · Springfield, ILThe pilot's failure to maintain flying speed and allowed the aircraft to stall during the break turn to downwind.Aug 5, 1990 · N260RM · Substantial damageNTSB CHI89FA124Accident · 1 fatalField investigationFinal reportCessna 150L · Sugar Grove, ILFailure to maintain airspeed above stall speed, and a stall/spin encountered with inadequate altitude for recovery. Factors related to the accident were: thunderstorm, pre-flight briefing not obtained and poor weather evaluation by the pilot.Jul 2, 1989 · N16004 · DestroyedNTSB BFO89FA027Accident · 1 fatalField investigationFinal reportCessna 152 · West Chicago, ILImproper instruction by the student's flight instructor regarding the execution of s-turns on final approach to increase spacing and the retraction of flaps fully when executing a go-around and the failure of the student pilot to maintain adequate flying…Apr 15, 1989 · N93748 · DestroyedNTSB CHI89FA069Accident · 2 fatalField investigationFinal reportCessna 150M · Kankakee, ILFailure of the instructor pilot (CFI) to maintain control of the aircraft and his failure to maintain sufficient altitude above the ground.Apr 6, 1989 · N3892V · DestroyedNTSB CHI89GA048Accident · 2 fatalFinal reportPiper PA-28-180 · Chicago, ILInadequate preflight of the aircraft by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: high obstructions and retaining wall in the emergency landing area.Jan 21, 1989 · N16375 · DestroyedNTSB CHI89FA038Accident · 2 fatalField investigationFinal reportCessna T210N · Springfield, ILThe pilot's improper IFR procedure during an ILS approach in below minimum conditions, and the pilot's failure to proceed to an alternate destination. Contributing factors were the adverse weather conditions.Jan 1, 1989 · N2305U · DestroyedNTSB CHI88FA090Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Quincy, ILDescent below the dh by the pilot in command during an instrument approach into known adverse weather rather then proceeding to a suitable alternate destination.Apr 2, 1988 · N32076 · DestroyedNTSB CHI88FA046Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Carbondale, ILShortly after reporting the outer marker while executing an ILS runway 18 approach in actual instrument meteorological conditions, the aircraft deviated left of the localizer centerline. At a position approximately 1/2 mile outside the middle marker and about…Jan 18, 1988 · N40265 · DestroyedNTSB CHI88FA039Accident · 1 fatalField investigationFinal reportCessna T210N · Bedford Park, ILDrg an arrival to chicago midway arpt on a cold night, the plt rprtd he was having trouble with a sticky throttle. Subsequently, he made an emergency transmission & said he was 'going in.' Witnesses saw the acft in a descent before it crashed. One witness…Jan 5, 1988 · N4746C · DestroyedNTSB CHI87FA054Accident · 4 fatalField investigationFinal reportBellanca 14-19-3A · West Chicago, ILAt 0850 CST, the plt got a wx briefing for a flt to the dupage arpt. At that time, the current dupage wx was in part: partial obscn, 2 mi vis with fog; also, the plt was given svrl pireps for lgt to mod icing in southern Wisconsin. At 1231, he got a wx…Dec 22, 1986 · N1253R · DestroyedNTSB CHI87FA040Accident · 4 fatalField investigationFinal reportMooney M20E · Hanna City, ILThe aircraft struck power lines and crashed two miles from the end of the runway on final approach ground track after being cleared for an ILS approach. The accident occurred at the end of a three leg cross-country flight from the Bahamas which began aprx 8…Dec 2, 1986 · N9210M · DestroyedNTSB CHI87FA004Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Charleston, ILN8267W was on practice NDB approach to rwy 29 under ATC clrnc with hooded stu at controls in left seat, ip in right seat, proceeding level at mda for low pass. Evidence indicates N30019 had entered downwind for rwy 24 and was in left turn VFR approach for rwy…Oct 15, 1986 · N8267W · 2 aircraft · Substantial damageNTSB CHI86FA100Accident · 2 fatalField investigationFinal reportCessna 172M · Lafox, ILAn instructor plt (cfi/cfii) & his student (pvt single eng rated plt) were on an instructional flt in a Cessna 172, N72MA. The student had rrecently been taking instrument flt training & had a hood for use on this flt. Prior to the acdnt. The Cessna 172 was…Mar 8, 1986 · N72MA · 2 aircraft · DestroyedNTSB CHI83FA075Accident · 3 fatalField investigationFinal reportMooney M-20D · Lindenwood, ILAt 0306 the plt contacted rockford fss requesting local wx. He then requested an ILS apch to rockford & stated he had noapproach plates. After being cleared for an ILS apch to rwy 36, the plt reported he was unable to pick up the ILS & was low on fuel. ARTCC…Jan 5, 1983 · N1968Y · DestroyedNTSB CHI82FA366Accident · 1 fatalField investigationFinal reportCessna 340A · Sugargrove, ILAircraft collided with terrain after a missed approach in a descending turn left wing hit the ground first. Aircraft broke up and caught fire. No malfunctions found.Sep 26, 1982 · N2676A · DestroyedNTSB CHI82FA234Accident · 1 fatalField investigationFinal reportGoans G-5 · Kankakee, ILThe pilot was making his first flight since a special airworthiness certificate was issued. This aircraft was unique in that the rotor controls were cable instead of push-pull rods. The aircraft after takeoff started pitching up and down. This pitching…Jul 4, 1982 · N59CG · DestroyedNTSB CHI81FA089Accident · 5 fatalClosedBalloon WKS 8-24 · Barrington, ILAug 15, 1981 · N4062Z · DestroyedNTSB CHI81FA078Accident · 2 fatalClosedCessna 340A · St Charles, ILJul 18, 1981 · N5416J · DestroyedNTSB CHI80FEE47Accident · 1 fatalClosedVari-Eze Heiman · Huntley, ILSep 1, 1980 · N5021Y · Destroyed