NTSB investigations, IL

169 cases where the first occurrence was “Loss of control - on ground/water”.

Cases, newest first

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\" = 260)
  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 CHI96LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, ILFailure of the student pilot to maintain directional control of the airplane, which resulted in an inadvertent ground swerve. A factor relating to the accident was: the crosswind condition.Feb 24, 1996 · N6325Q · Substantial damageNTSB CHI95LA280Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Champaign, ILthe pilot's failure to maintain directional control of the airplane during takeoff.Aug 16, 1995 · N381AV · Substantial damageNTSB CHI95LA256Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Naperville, ILThe pilot's failure to maintain directional control during the takeoff roll. Contributing factors were the pilot's lack or recent experience in tailwheel equipped aircraft and failure to abort the takeoff early enough to prevent the accident.Aug 1, 1995 · N5068K · Substantial damageNTSB CHI95LA192Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Peru, ILthe pilot's failure to maintain directional control of the airplane while landing. A factor in the accident was the runway light.Jun 17, 1995 · N21873 · Substantial damageNTSB CHI95LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chicago, ILThe pilot's failure to maintain directional control. A factor was the crosswind.May 1, 1995 · N47331 · Substantial damageNTSB CHI95LA127Accident · No injuriesLimited investigationFinal reportPiper J3C · Poplar Grove, ILThe student pilot's excessive throttle control and the certified flight instructor's inadequate supervision of the student. A factor in the accident was the gusty wind conditions.Apr 15, 1995 · N6673H · Substantial damageNTSB CHI95LA131Accident · No injuriesLimited investigationFinal reportPiper PA-22-20-108 · Kankakee, ILThe pilot's inadequate recovery from a bounced landing.Apr 2, 1995 · N4917Z · Substantial damageNTSB CHI95LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Rochelle, ILthe student pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the student pilot's improper use of the brakes.Nov 11, 1994 · N32196 · Substantial damageNTSB CHI95LA015Accident · No injuriesLimited investigationFinal reportQuestair Venture · Wheeling, ILThe inadvertent deployment of the nosewheel steering. A factor in this accident was the inadequate design of the rudder pedal pivot point height above the cockpit floor by the design personnel.Oct 18, 1994 · N62V · Substantial damageNTSB CHI94LA238Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Harvard, ILthe pilot's excessive taxi speed. A factor in the accident was the wet grass runway.Jul 15, 1994 · N8512C · Substantial damageNTSB CHI94LA150Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Sandwich, ILthe pilot in command's failure to maintain directional control during a crosswind landing and attempted go around.May 8, 1994 · N68135 · Substantial damageNTSB CHI94LA122Accident · No injuriesLimited investigationFinal reportCessna 172P · Wheeling, ILthe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the crosswind.Mar 23, 1994 · N97650 · Substantial damageNTSB CHI94LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Sandwich, ILthe private pilot's failure to maintain directional control of the airplane while landing on a snow and ice covered runway. Factors are the snow on the runway and the snowbank.Feb 14, 1994 · N76SA · Substantial damageNTSB CHI93LA358Accident · No injuriesLimited investigationFinal reportCessna 140 · Trenton, ILFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and subsequent nose over of the airplane.Sep 5, 1993 · N89467 · Substantial damageNTSB CHI93LA227Accident · No injuriesLimited investigationFinal reportCessna 182L · Aurora, ILThe disconnected nose gear upper torque link (landing gear steering). Directional control not possible was a factor.Jun 27, 1993 · N3119R · Substantial damageNTSB CHI93LA198Accident · Serious injuriesLimited investigationFinal reportBeech 200 · Wonder Lake, ILThe failure of the pilot of the Beech 200, N210PH, to maintain sufficient runway alignment to prevent the airplane from departing the runway.Jun 10, 1993 · N210PH · 2 aircraft · Substantial damageNTSB CHI93LA211Accident · No injuriesLimited investigationFinal reportMonnett Sonerai IIL · De Kalb, ILThe pilot in command's inability to maintain directional control due to inadequate compensation for wind conditions.Jun 6, 1993 · N247RJ · Substantial damageNTSB CHI93LA059Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake In The Hls, ILThe student pilot's failure to maintain directional control.Dec 26, 1992 · N4328D · Substantial damageNTSB CHI92LA272Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Ottawa, ILThe pilot-in-command's failure to adequately compensate for wind conditions, and his not maintaining directional control. Factors were the crosswind and wind gusts.Sep 10, 1992 · N55410 · Substantial damageNTSB CHI92LA202Accident · No injuriesLimited investigationFinal reportCessna 172P · Waukegan, ILThe student pilot's failure to maintain airplane directional control. Related factors are the student's lack of total flight experience, and improper aircraft control.Jul 9, 1992 · N98673 · Substantial damageNTSB CHI92LA187Accident · No injuriesLimited investigationFinal reportBeech M35 · Dekalb, ILThe pilot's failure to use proper nose wheel steering which resulted in a loss of directional control.Jun 21, 1992 · N9873R · Substantial damageNTSB CHI92LA159Accident · No injuriesLimited investigationFinal reportBeech 77 · Moline, ILThe student pilot's failure to maintain directional control.May 20, 1992 · N18244 · Substantial damageNTSB CHI92DEE01Accident · No injuriesFinal reportBoeing E75 · Leland, ILThe pilot's excessive application of brakes. A factor in the accident was the pilot's lack of experience in this model aircraft.Apr 7, 1992 · N64955 · Substantial damageNTSB CHI92LA098Accident · No injuriesLimited investigationFinal reportCessna 150L · Peru, ILThe students pilot's inadequate compensation for wind conditions. A factor in the accident was the pilot's lack of experience in the type of operation.Feb 23, 1992 · N6785G · Substantial damageNTSB CHI92LA046Accident · No injuriesLimited investigationFinal reportCessna 421 · Wheeling, ILThe pilot's failure to maintain directional control of the airplane during landing. A factor contributing to the accident was the icy runway.Dec 5, 1991 · N777RA · Substantial damageNTSB CHI92LA041Accident · No injuriesLimited investigationFinal reportCessna 210N · Frankfort, ILThe failure of the fss to notify ATC that the ariport was closed, atc's subsequent approach clearance to the closed airport, and the pilot's inability to maintain directional control on the icy runway. A factor in the accident was the icy runway conditions.Dec 3, 1991 · N5281A · Substantial damageNTSB CHI91LA286Accident · No injuriesLimited investigationFinal reportCessna 170B · Frankfort, ILThe pilot in command's failure to maintain directional control. A contributing factor was a crosswind.Aug 31, 1991 · N8244A · Substantial damageNTSB CHI91LA249Accident · No injuriesLimited investigationFinal reportCessna 172 · Wheeling, ILInadequate compensation for wind conditions and directional control was not maintained by the pilot. Factors related to the accident were a gusty crosswind landing environment and a ditch.Aug 2, 1991 · N97650 · Substantial damageNTSB CHI91LA222Accident · No injuriesLimited investigationFinal reportCessna 172 · West Chicago, ILDirectional control was not maintained by the cfi/pic. Factors related to the accident were a gusty cross wind and an airport facility, VASI light.Jul 20, 1991 · N99515 · Substantial damageNTSB CHI91LA099Accident · No injuriesLimited investigationFinal reportCessna 152 · Wonder Lake, ILFailure of the student pilot to maintain directional control during takeoff. Her lack of flying expereince was a related factor.Feb 26, 1991 · N49485 · Substantial damageNTSB CHI91LA081Accident · No injuriesLimited investigationFinal reportCessna 172N · Lansing, ILInadequate compensation for wind conditions and failure to maintain directional control. A factor related to the accident is the snow covered runway.Jan 22, 1991 · N5345D · Substantial damageNTSB CHI90LA168Accident · No injuriesLimited investigationFinal reportBeech V35B · Lockport, ILThe pilot's failure to maintain aircraft directional control and keep the aircraft on the runway during the landing roll.Jul 5, 1990 · N35TP · Substantial damageNTSB CHI90LA156Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Aurora, ILThe pilot's inadequate compensation for wind conditions, and his not maintaining proper directional control on landing.Jun 17, 1990 · N59448 · Substantial damageNTSB CHI90LA144Accident · No injuriesLimited investigationFinal reportPiper PA23-250 · Carbondale, ILThe pilot's inability to maintain directional control during the touchdown and landing roll.May 31, 1990 · N32AC · Substantial damageNTSB CHI90LA111Accident · No injuriesLimited investigationFinal reportCessna 172RG · Romeoville, ILThe failure of the instructor to correct a loss of directional control during a landing roll in a timely manner.Apr 13, 1990 · N9694B · Substantial damageNTSB CHI90LA110Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Lodge, ILFailure of the pilot to maintain directional control during takeoff. The crosswind and the soft/uneven terrain were factors related to the accident.Apr 8, 1990 · N55JJ · Substantial damageNTSB CHI90LA109Accident · No injuriesLimited investigationFinal reportCessna 172P · Savanna, ILImproper planning/decision by the pilot. The strong/gusty crosswind was a related factor.Apr 8, 1990 · N89594 · Substantial damageNTSB CHI90LA091Accident · No injuriesLimited investigationFinal reportCessna 152 · New Lenox, ILPilot's inability to maintain directional control of the aircraft during the touchdown and landing roll phases of flight, due to deposits of slush frozen on the left landing gear brake.Feb 28, 1990 · N67950 · Substantial damageNTSB CHI90LA082Accident · No injuriesLimited investigationFinal reportCessna T310R · Wheeling, ILPilot's inability to maintain directional during the landing phase of flight. The slippery, snow covered runway, and a twelve knot direct crosswind contributed to the accident.Feb 15, 1990 · N6186X · Substantial damageNTSB CHI90LA069Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · West Chicago, ILFailure of the solo student pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind, the student pilot's lack of total inexperience, and the runway lights.Dec 10, 1989 · N4372S · Substantial damageNTSB CHI89DEE06Accident · Minor injuriesFinal reportHowe Quickie Q2 · Lakeinthehills, ILThe pilot failed to maintain directional control of the airplane during a bounced landing. A factor related to the accident was the pilot's evasive maneuver to avoid rolling into a stone quarry.Sep 28, 1989 · N525LH · Substantial damageNTSB CHI89LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Cahokia, ILInadequate compensation for wind conditions by the student pilot and his failure to maintain directional control. The crosswind and the student's lack of total experience were contributing factors.Apr 25, 1989 · N5498B · Substantial damageNTSB CHI89LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Plainfield, ILDec 30, 1988 · N8369Y · Substantial damageNTSB CHI89LA032Accident · No injuriesLimited investigationFinal reportCessna 152II · Lake In The Hls, ILThe pilot in command failed to maintain directional control of the aircraft while correcting for a crosswind. Contributing to the cause is the pilot's lack of experience.Dec 16, 1988 · N714ZE · Substantial damageNTSB CHI89LA021Accident · No injuriesLimited investigationFinal reportCessna 170A · Springfield, ILThe conventional landing gear equipped airplane was substantially damaged when it nosed down after ground looping during a landing attempt. VMC prevailed and a 90 degree right crosswind, blowing at 12 knots, was present. The pilot relates in his statement…Nov 2, 1988 · N5596C · Substantial damageNTSB CHI89LA007Accident · No injuriesLimited investigationFinal reportCessna 172 · Carbondale, ILThe student pilot, while on the takeoff roll on his first solo flight, experienced a loss of directional control which he failed to correct. The aircraft swerved to the left and departed the runway, striking a VASI installation before coming to a stop. The…Oct 9, 1988 · N98395 · Substantial damageNTSB CHI88DEE08Accident · No injuriesFinal reportTownson Starduster SA100 · Monee, ILPilot failing to maintain control of the airplane during landing touchdown and roll out.Jul 31, 1988 · N9119R · Substantial damageNTSB CHI88DEE05Accident · No injuriesFinal reportWeatherly 620 · Dekalb, ILAn on ground encounter with weather.Jul 11, 1988 · N4605P · Substantial damageNTSB CHI88LA161Accident · No injuriesLimited investigationFinal reportCessna 170B · Rockford, ILJul 8, 1988 · N8048A · Substantial damageNTSB CHI88FA128Accident · No injuriesField investigationFinal reportDornier 228-201 · Chicago, ILThe capt was completing the checklist drg pax loading & the f/o secured the door & came fwd. The capt started the #2 eng& bgn single eng taxi while atmtg a rgt turn to stay clr of a parked Dornier (N264MC). As N259MC bgn rolling fwd, the capt noted the…Jun 5, 1988 · N259MC · Substantial damage