Skip to content

NTSB investigations, IL

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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'
  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'
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 CHI88LA229Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Schaumburg, ILDuring an attempted night landing at an airport with inoperative pilot-controlled runway lights, the pilot made a series of low passes (approximately 6 passes) before trying to land. The aircraft collided with the top of a tree located slightly to the left of…Sep 2, 1988 · N28774 · Substantial damage NTSB CHI88LA228Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Fox Lake, ILThe plt had just completed a course at the Lake acft factory school, but had not yet obtained a seaplane rating. After he flew home, he landed on local lakes. He reported that drg a landing on calm water, he expected to hear a 'slush sound' as the hull…Sep 1, 1988 · N8012A · Destroyed NTSB CHI88FA223Accident · Minor injuriesField investigationFinal reportBoeing 727-31 · Chicago, ILImproper procedural checklist in which a critical step was not listed.Aug 27, 1988 · N852TW · Substantial damage NTSB CHI88FA214Accident · 3 fatalField investigationFinal reportHughes 269B · Hampton, ILAug 21, 1988 · N9499F · Destroyed NTSB CHI88LA208Accident · No injuriesLimited investigationFinal reportBeech C55 · Cahokia, ILWhile on a maintenance test hop after annual inspection, the pilot failed to insure that the landing gear was extended before touchdown. The pilot stated that the gear handle was placed in the gear down position, and that no gear warning horn sounded during…Aug 15, 1988 · N19RE · Substantial damage NTSB CHI88IA200Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILAug 12, 1988 · N426MQ · No damage NTSB CHI88LA196Accident · No injuriesLimited investigationFinal reportCessna 320E · Springfield, ILDrg a night arrival, the plt failed to get a down & locked indcn for the nose gear. He made svrl low passes over the rwy for observation. Tower & fire/rescue personnel rprtd the nose gear appeared to be extended, so the plt made a normal landing. As the nose…Aug 8, 1988 · N222L · Substantial damage NTSB CHI88LA199Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Crestwood, ILAug 7, 1988 · N2098R · Substantial damage NTSB CHI88DEV04Accident · No injuriesFinal reportGrumman G164A · Chenoa, ILUnavailability of suitable terrain on which to accomplish a forced landing.Aug 3, 1988 · N8980H · Substantial damage NTSB CHI88FA190Accident · 2 fatalField investigationFinal reportMcdonnell Douglas 269B · Braceville, ILConducting maneuvering flight the PIC failed to monitor the helicopter systems and allowed the main rotor RPM to decay to the point where it would not produce enough lift to sustain flight.Aug 2, 1988 · N9522F · Destroyed NTSB CHI88LA180Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · St. Jacob, ILDuring the initial climbout the student pilot failed to attain sufficient altitude to clear the power lines located off of the departure end of the runway. When the pilot realized that he would not be able to clear the power lines, he elected to attempt to…Jul 31, 1988 · N9291T · Substantial damage NTSB CHI88FA183Accident · No injuriesField investigationFinal reportBoeing B75N1 · Wonder Lake, ILJul 31, 1988 · N4408N · Substantial damage NTSB 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 damage NTSB CHI88DEV03Accident · No injuriesFinal reportHughes 369HS · Ashland, ILAs the helicopter was taking off, there was a loss of rotor RPM which was accompanied by a loss of fuel flow to the eng. The plt aborted the takeoff, but during touchdown, the main rotor blades flexed downward & severed the . Tail boom. An inspn of the eng…Jul 28, 1988 · N9033F · Substantial damage NTSB CHI88LA175Accident · No injuriesLimited investigationFinal reportBeech 35R · Manito, ILDrg arrival, the plt experienced an electrical prblm with the landing gear & had to use manual extension procedures. He stated that when he selected the flaps for landing, he heard the motor run, but did not visually check that the flaps were extended. Just…Jul 26, 1988 · N3016V · Substantial damage NTSB CHI88DEE07Accident · No injuriesFinal reportHughes 269C · Sandwich, ILThe plt rprtd that while he was conducting spraying opns, he noted a significant loss of eng power. He made a run-on landing in a bean field. As he landed, the left skid dug into a furrow & the helicopter rolled over. During the investigation, which included…Jul 21, 1988 · N7425F · Substantial damage NTSB CHI88LA170Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Chicago, ILDuring climbout after takeoff, the pilot experienced an engine fire and diverted to Chicago's midway airport for an emergency landing. The pilot executed emergency procedures, shut down the engine, the fuel supply, and all electrical load. When the pilot knew…Jul 20, 1988 · N8069S · Substantial damage NTSB CHI88DEV02Accident · No injuriesFinal reportGrumman G-164A · Cape Girardeau, ILThe plt was applying chemicals to a field with 3 radio transmission towers along one side. He rprtd that as he was finishing the field, he circled one of the towers, them made a final swath run across the end of the field. He stated that as he pulled up from…Jul 18, 1988 · N677U · Substantial damage NTSB CHI88DEE06Accident · No injuriesFinal reportPiper PA-25 · Chebanse, ILThe acft had been refueled with pilot's stated quantity of 20 gals of fuel. After completing his spray operation and returning to base he stated 'ran out of gas'. Acft had been airborne 1 + 15 plus taxi and engine runup.Jul 17, 1988 · N8807L · Substantial damage NTSB CHI88IA165Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD80 · Chicago, ILJul 14, 1988 · N253A · No damage NTSB CHI88DEE05Accident · No injuriesFinal reportWeatherly 620 · Dekalb, ILAn on ground encounter with weather.Jul 11, 1988 · N4605P · Substantial damage NTSB CHI88LA161Accident · No injuriesLimited investigationFinal reportCessna 170B · Rockford, ILJul 8, 1988 · N8048A · Substantial damage NTSB CHI88IA141Incident · No injuriesIncident investigationFinal reportSwearingen SA226-TC · Chicago, ILFailure of the front motor bearing in the sas servo motor assembly, and the resultant 'jamming' of the elevator control cables. The pilot aborted the takeoff as a result of the vibration in the yoke.Jun 22, 1988 · N329BA · No damage NTSB CHI88LA135Accident · No injuriesLimited investigationFinal reportCessna 152 · Urbana, ILWhile landing at the completion of his first solo cross country instructional flight, the student pilot landed long and was unable to stop before the end of the runway. The student pilot stated that he selected the sod runway instead of the 2,550' x 29'…Jun 19, 1988 · N49207 · Substantial damage NTSB CHI88LA137Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Mattoon, ILUpon return from a local aerial photography flight, the pilot failed to ensure that the aircraft landing gear was extended, down and locked. When the aircraft touched down, the gear was only extended approximately 10%; it collapsed fully when it contacted the…Jun 16, 1988 · N8226P · Substantial damage NTSB 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 NTSB CHI88LA126Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Aledo, ILDuring takeoff roll the pilot reported he experienced a loss of directional control and elected to lift the aircraft off the ground prematurely in an effort to avoid running into a cornfield. Unable to establish the proper rate of climb, and unable to clear…Jun 4, 1988 · N95061 · Destroyed NTSB CHI88LA124Accident · No injuriesLimited investigationFinal reportBeech B-19A · Lacon, ILA hard landing made by the student pilot after attempting to recover from a bounced landing.May 31, 1988 · N4306S · Substantial damage NTSB CHI88LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Romeoville, ILMay 30, 1988 · N68312 · Substantial damage NTSB CHI88LA121Accident · No injuriesLimited investigationFinal reportCessna R172K · Aurora, ILThe pilot said that on final apch, 'a rapid descent took place.' The aircraft touched down on the rwy and bounced. The pilot said he added pwr and lowered the nose, but the nose gear and propeller hit the rwy. The acft bounced again and sustained substantial…May 29, 1988 · N736AF · Substantial damage NTSB CHI88LA113Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Nauvoo, ILThe pilot was making a 'fast low approach' to a private airstrip near his home when he realized he was coming too close to a row of trees. The pilot stated he became so preoccupied with trying not to hit the trees that he did not notice how close the aircraft…May 12, 1988 · N757ZY · Destroyed NTSB MIA88IA168Incident · No injuriesIncident investigationFinal reportPiper PA-42-720 · Chicago, ILCondor flt 610 (Mcdonnell Douglas DC-10, german registration: dadso) was aprx 2 hrs late as the flt crew members were preparing to takeoff. Subsequently, flt 610 was clrd for takeoff with instructions to cross the 5 DME (on the standard instrument…May 11, 1988 · N900MP · 2 aircraft · No damage NTSB MIA88IA167Incident · No injuriesIncident investigationFinal reportBeech 200 · Chicago, ILMidway flt 172 (Mcdonnell Douglas DC-9, N1065T) was on an IFR departure from Chicago midway arpt at the same time that Beech 200, N981LL, was on an IFR arrival for a visual apch to merrill c meigs arpt, although both were in VMC. Previously, o'hare TRACON had…May 10, 1988 · N981LL · 2 aircraft · No damage NTSB CHI88FA110Accident · No injuriesField investigationFinal reportBoeing 747-136 · Chicago, ILFailure of the number three flap track due to stress corrosion cracking. Factors contributing to this failure are insufficient design of the member and inadequate inspection and maintenance procedures to detect cracks before they propagate to a critical…May 9, 1988 · GAWND · Substantial damage NTSB CHI88DEE04Accident · Minor injuriesFinal reportCessna 205 · Moline, ILDuring initial climb on a pleasure flight the airplane experienced a loss of fuel pressure and then total engine failure. The airplane nosed over during the subsequent off airport landing. Post accident examination of the engine driven fuel pump revealed…May 7, 1988 · N647MA · Destroyed NTSB CHI88LA099Accident · No injuriesLimited investigationFinal reportCessna 150M · Zeigler, ILUpon completion of a practice emergency landing procedure during an instructional flight, the engine started to run rough and then quit. The instructor was able to regain partial power, and made forced landing in freshly plowed field. The aircraft nosed over…Apr 21, 1988 · N9410U · Substantial damage NTSB CHI88LA100Accident · No injuriesLimited investigationFinal reportCessna 182D · Mt. Vernon, ILAfter electing to go-around on his first approach, the student pilot ballooned the aircraft as he passed over the runway on the second approach. Remedial action was attempted, but the pilot overcontrolled and the aircraft struck the runway slightly nosewheel…Apr 16, 1988 · N8891X · Substantial damage NTSB CHI88IA097Incident · Minor injuriesIncident investigationFinal reportFairchild SA-226-TC · Bloomington, ILPhysical incapacitation due to an organic pathogen. Contributing factors are anxiety and self-induced pressure.Apr 11, 1988 · N332BA · No damage NTSB CHI88LA094Accident · No injuriesLimited investigationFinal reportCessna 172M · Champaign, ILThe pilot had just landed at the airport for refueling and was instructed by the tower to do a 180 degree turn on the runway and then make a left turn on the first taxiway. The pilot executed the 180 degree turn and while attempting to turn left (crosswind)…Apr 6, 1988 · N64508 · Substantial damage NTSB 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 · Destroyed NTSB CHI88LA084Accident · No injuriesLimited investigationFinal reportCessna 152 · Salem, ILWhile attempting to land with a quartering tailwind, the student experienced a loss of directional control and elected to G0-around. On climbout he was unable to maintain the proper rate of climb, and once out of ground effect the aircraft started to descend.…Mar 26, 1988 · N96010 · Substantial damage NTSB CHI88LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Mendota, ILDuring the landing roll, in gusty, crosswind conditions the upwind wing of the aircraft lifted and the aircraft experienced a noseover.Mar 26, 1988 · N35407 · Substantial damage NTSB CHI88FA079Accident · Serious injuriesField investigationFinal reportBell 206L-1 · Taylorville, ILThe helicopter experienced a loss of control while in slow flight out of ground effect. The helicopter impacted the ground in a black plowed field during a period of low visibility due to snow. The occurrence happened in a remote area with few ground…Mar 18, 1988 · N5759H · Destroyed NTSB CHI88DEE03Accident · No injuriesFinal reportPiper PA-22-150 · West Chicago, ILThe plt rprtd that just after leveling off, the eng started to sputter. He initiated emergency procedures, but was unable to restore power. During an emergency landing at dusk, the acft hit a ditch & nosed over. An investigation revealed the #3 exhaust valve…Mar 18, 1988 · N2758P · Substantial damage NTSB CHI88LA076Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Dixon, ILMar 10, 1988 · N4072D · Substantial damage NTSB CHI88DCA01Accident · No injuriesFinal reportBell 206B · Cahokia, ILThe instructor was giving a pilot an employment evaluation in the helicopter when during the startup the pilot prematurely added full power causing the helicopter to rotate rapidly to the right. The helicopter had been positioned on a trailer. During the…Mar 10, 1988 · N13Q · Substantial damage NTSB CHI88IA074Incident · No injuriesIncident investigationFinal reportSwearingen SA226T · Chicago, ILThe TRACON supervisor failed to comply with the established visual minima criteria and his incorrect issuance of a visual approach to an arriving aircraft.Mar 7, 1988 · N600TA · 2 aircraft · No damage NTSB CHI88LA068Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Kankakee, ILFeb 24, 1988 · N4917K · Substantial damage NTSB CHI88LA066Accident · No injuriesLimited investigationFinal reportCessna 150L · Springfield, ILThe aircraft experienced a hard landing followed by collapse of the nose gear. The student pilot stated that he bounced on his first attempt to land and the second touchdown was nose first which resulted in the collapse of the nose gear.Feb 21, 1988 · N18225 · Substantial damage NTSB CHI88IA073Incident · No injuriesIncident investigationFinal reportBoeing 747-227B · Chicago, ILFailure of the tower cab supervisor to assure that coordination between the south local controller and north local controller had been completed. A factor is the failure of FAA tower management to insure there were personnel manning the cab coordinator…Feb 19, 1988 · N635US · 2 aircraft · No damage