NTSB investigations, IL
185 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 7 |
|---|---|
| 1983 | 8 |
| 1984 | 8 |
| 1985 | 7 |
| 1986 | 4 |
| 1987 | 7 |
| 1988 | 10 |
| 1989 | 11 |
| 1990 | 6 |
| 1991 | 8 |
| 1992 | 6 |
| 1993 | 9 |
| 1994 | 8 |
| 1995 | 9 |
| 1996 | 8 |
| 1997 | 7 |
| 1998 | 7 |
| 1999 | 11 |
| 2000 | 3 |
| 2001 | 11 |
| 2002 | 5 |
| 2003 | 8 |
| 2004 | 3 |
| 2005 | 4 |
| 2006 | 3 |
| 2007 | 7 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250)
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.
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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CHI08FA053Accident · 3 fatalField investigationFinal reportBeech V35B · Springfield, ILThe loss of control during an instrument approach due to spatial disorientation.NTSB CHI08LA041Accident · 1 fatalLimited investigationFinal reportHerink H R/Herink R W Challenger · Apple River, ILThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing to the accident was the low altitude and the gusty wind conditions.NTSB CHI08LA040Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Sport Cruiser · Waukegan, ILThe pilot's failure to assure that all of his tools were accounted for prior to takeoff which resulted in the foreign object jamming the control stick and the pilot's inability to maintain control of the airplane. A factor associated with the accident was the…NTSB CHI07CA275Accident · Minor injuriesData collectionFinal reportWeaver, David A Pulsar 912XP · Plato Center, ILthe pilot's failure to maintain airspeed. Factors were the pilot's lack of familiarity with the aircraft and pilot's failure to maintain altitude.NTSB CHI07CA214Accident · Minor injuriesData collectionFinal reportGrumman G-164B · Sheldon, ILThe pilot's inability to maintain a proper rate of climb during takeoff. Factors associated with the accident were the pilot's failure to dump the chemical load and the ditch which the airplane contacted.NTSB CHI07CA165Accident · Minor injuriesData collectionFinal reportWSK PZL Mielec PZL-M-18 · Manito, ILThe pilot's failure to maintain proper airspeed and his decision to attempt flight over maximum gross weight. A factor to the accident was the stall encountered while attempting to avoid obstacles.NTSB CHI07LA157Accident · 1 fatalLimited investigationFinal reportPurvis Rans S6S · Newark, ILThe pilot's failure to maintain control of the airplane which resulted in inadequate airspeed and a subsequent stall. Contributing to the accident were the pilot's improper installation of the altimeter and airspeed indicator which rendered them inoperative…NTSB CHI07FA026Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Wellington, ILSpatial disorientation experienced by the pilot while attempting to visually locate traffic during cruise flight, which resulted in a loss of aircraft control. Contributing factors were the inadvertent overload failure of the wing spar and stabilator, and the…NTSB CHI06LA178Accident · 1 fatalLimited investigationFinal reportMoon Rans S-14 · Berlin, ILThe pilot's failure to maintain control of the airplane for undetermined reasons.NTSB 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.NTSB CHI06CA013Accident · Minor injuriesData collectionFinal reportCessna 152 · Peoria, ILThe student pilot's failure to maintain adequate airspeed during a go-around which resulted in the airplane stalling.NTSB CHI05GA198Accident · Serious injuriesFinal reportBell 206L-3 · Justice, ILThe pilot's improper in-flight decision while maneuvering which resulted in a tailwind during low airspeed helicopter flight and subsequent loss of tail rotor effectiveness. The struck sign and fence were factors in the accident.NTSB CHI05CA126Accident · No injuriesData collectionFinal reportYoung Zodiac 601XL · Mattoon, ILThe pilot's failure to maintain control of the airplane during the landing flare resulting in an in-flight collision with the runway pavement.NTSB CHI05LA122Accident · Serious injuriesLimited investigationFinal reportCessna R182 · Vandalia, ILThe pilot's failure to maintain control of the airplane due to undetermined reasons.NTSB CHI04FA198Accident · 2 fatalField investigationFinal reportMooney M20J · Fox Lake, ILThe flight crew's failure to maintain airspeed which led to an inadvertent stall/spin. An additional cause was the flight instructor's unsuccessful remedial action during the course of the accident sequence. The slow flight performed was a factor.NTSB CHI04LA131Accident · 1 fatalLimited investigationFinal reportZorn EAA Sport Bi-Plane · Mazon, ILThe pilot's failure to maintain airspeed while maneuvering which resulted in a stall. A factor associated with the accident was the pilot's unfamiliarity with the handling characteristics of the airplane.NTSB CHI04CA095Accident · No injuriesData collectionFinal reportBeech C23 · Lake in the Hil, ILThe dual student pilot not maintaining airplane control during the go-around and the flight instructor pilot's inadequate remedial action resulting in the airplane's uncontrolled descent.NTSB CHI04LA013Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Schaumburg, ILThe commercial pilot not maintaining directional control of the helicopter and the improper flare initiated before landing.NTSB CHI04LA010Accident · No injuriesLimited investigationFinal reportWright Redux Association 1903 Wright Flyer · Bolingbrook, ILThe inadequate planning/decision by the pilot to begin a flight in gusting wind conditions, the pilot's lack of experience in the airplane, and the stall encountered by the pilot during takeoff. The wind gusts were a contributing factor.NTSB CHI03FA202Accident · 1 fatalField investigationFinal reportCessna 150L · Schaumburg, ILThe pilot not maintaining airplane control and the inadvertent stall he encountered during initial climb.NTSB CHI03FA181Accident · 3 fatalField investigationFinal reportRobinson R44 II · Coleta, ILThe pilot not maintaining main rotor RPM during cruise flight. The factor in the two passenger's fatal injuries was the pilot not following directives concerning the prohibition of carrying passengers while a student pilot. Other factors were the pilot's use…NTSB CHI03FA150Accident · Serious injuriesField investigationFinal reportCessna 172M · West Chicago, ILThe abrupt pull-up initiated by the pilot during takeoff before airspeed was attained resulting in a stall. Factors contributing to the accident were the pilot's failure to maintain directional control of the airplane on takeoff and the crosswind.NTSB CHI03LA118Accident · 2 fatalLimited investigationFinal reportAir Tractor AT-503A · Pontiac, ILThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin. A factor associated with the accident was the low altitude maneuver.NTSB CHI03FA060Accident · 1 fatalField investigationFinal reportAgusta A109C · West Chicago, ILThe pilot's failure to maintain control of the helicopter while maneuvering, resulting in the excessive descent rate and impact with terrain. Factors to the accident included the dark night, low ceiling and reduced visibility at the time of the accident.NTSB CHI03LA048Accident · 1 fatalLimited investigationFinal reportAir Command Commander Elite · Lansing, ILThe inadvertent pilot induced oscillation. Factor to the accident was the wind gusts.NTSB 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.NTSB CHI03LA001Accident · No injuriesLimited investigationFinal reportMooney M20J · Chicago, ILThe pilot's inadequate compensation for wind, and his failure to maintain directional control.NTSB CHI02FA199Accident · 2 fatalField investigationFinal reportBeech E-90 · Bloomington, ILThe cause of the accident is undetermined.NTSB CHI02CA194Accident · No injuriesData collectionFinal reportGrumman G-164 · Browning, ILthe failure of the pilot-in-command to maintain sufficient airspeed while maneuvering. The initial stages of a stall/mush condition, and the low maneuvering altitude due to the agricultural application pass, were contributing factors.NTSB CHI02LA066Accident · No injuriesLimited investigationFinal reportCessna T210N · Chicago, ILthe pilot's failure to maintain aircraft control after takeoff. Factors relating to the accident were the pilot excessive rotation during takeoff and the crosswind.NTSB CHI02IA050Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Chicago, ILReason for occurrence is undetermined.NTSB CHI02FAMS1Accident · 4 fatalMissing aircraftFinal reportCessna R182 · Lake Michigan, ILThe uncontrolled descent for undetermined reasons.NTSB CHI02FA006Accident · 1 fatalField investigationFinal reportCessna 150L · Union, ILThe pilot not maintaining appropriate airspeed which resulted in an inadvertent stall.NTSB CHI01FA298Accident · 1 fatalField investigationFinal reportSpears RV-6 · Grayslake, ILThe pilot inadvertently stalled the airplane. A factor was the impairment due to marihuana.NTSB CHI01LA272Accident · No injuriesLimited investigationFinal reportCessna 152 · Peru, ILThe pilot's inadequate recovery from a bounced landing. Factors associated with the accident were improper touchdown point, rough terrain, and the nose gear collapse.NTSB CHI01FA234Accident · 3 fatalField investigationFinal reportCessna 177 · Benton, ILThe pilot's failure to maintain adequate airspeed, resulting in a stall.NTSB CHI01FA186Accident · No injuriesField investigationFinal reportBowman Renegade Spirit · Lynn Center, ILthe in-flight deformation of the left wing.NTSB CHI01LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bloomington, ILThe pilot's failure to maintain aircraft control during the visual approach for landing.NTSB CHI01LA149Accident · 1 fatalLimited investigationFinal reportGeertz Zenith CH 200 · Kankakee, ILThe loss of control on initial climbout for undetermined reasons.NTSB CHI01LA133Accident · No injuriesLimited investigationFinal reportCessna 172M · West Chicago, ILThe inadequate compensation for the crosswind by the student pilot. Additional factors included the student pilot's lack of total flight time, the runway sign and the crosswind.NTSB 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.NTSB CHI00FA276Accident · 2 fatalField investigationFinal reportBeech E-55 · Grafton, ILThe pilot not maintaining aircraft control and altitude/clearance from the river. Factors to the accident included the pilot not obtaining an air traffic control clearance prior to departure into instrument meteorological conditions, the pilot becoming…NTSB CHI00FA184Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Quincy, ILThe pilots failure to maintain control of the aircraft and his continued flight into adverse weather. Factors were the fog, and the crops.NTSB CHI00LA169Accident · No injuriesLimited investigationFinal reportCessna 172N · Greenville, ILthe student pilot failed to properly flare the airplane while landing. A factor associated with the accident was the student pilot's lack of total experience.NTSB CHI00FA039Accident · 2 fatalField investigationFinal reportCessna 310N · Danville, ILAircraft control not being maintained by the flight instructor and the flight instructor's inadequate supervision of the flight. Factors to the accident were the flight instructor's VFR flight into IMC weather conditions, the inadequate preflight…NTSB CHI00LA007Accident · No injuriesLimited investigationFinal reportCessna 150M · Wheeling, ILaircraft control not maintained by the pilot. A factor to the accident was the windshear.NTSB CHI99FA342Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Warrensburg, ILAircraft control not being maintained by the private pilot candidate and the inadequate supervision by the FAA Designated Examiner. Factors relating to the accident were the inadvertent spin, the unsuccessful remedial action attempted by the flightcrew, and…NTSB CHI99FA293Accident · 2 fatalField investigationFinal reportHudson Avenger · Lansing, ILthe weight and balance exceeded by the owner/builder. The inadequate preflight planning/preparation by the owner/builder.NTSB CHI99LA288Accident · No injuriesLimited investigationFinal reportCessna 172G · Glenarm, ILthe pilot's selection of the wrong runway for the prevailing winds. Factors were the pilot's misunderstanding of the wind information and the tailwind.NTSB CHI99LA283Accident · No injuriesLimited investigationFinal reportCessna 172P · Waukegan, ILthe pilot's misjudged landing flare and his inadequate recovery from the bounced landing.