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.
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' 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 CHI87DCA01Accident · Minor injuriesFinal reportBeech 3NM · Cahokia, ILThe acft experienced a loss of pwr in the rt eng immediately aft tkof. The plt was not able to feather the propeller and was forced to land in a wheat field on arpt property. Conditions were conducive to carburetor icing at the time of the accd. Investigation…NTSB CHI87IA148Incident · No injuriesIncident investigationFinal reportDornier DO-228-201 · Springfield, ILThe flightcrew experienced inflight opening of the aft baggage door and inflight separation of the cabin stairway door. The copilot checked the doors on three occasions before takeoff because the door warning light was illuminated. The captain initiated the…NTSB CHI87LA142Accident · No injuriesLimited investigationFinal reportSchleicher KA-6-CR · Staunton, ILThe plt stated that he climbed to 6000 feet MSL and proceeded on course to Staunton, Illinois. According to the plt in a telephone interview, he was approximately 800-900 feet above willhoit airport when he made a 360 degree turn to enter base. He further…NTSB CHI87IA135Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Chicago, ILAmerican flt 637 was on departure from Chicago-o'hare intl arpt (ord), climbing thru 7300' MSL, when it passed American flt 393 with aprx 500' vertical sepn & 1/4 mi horizontal sepn. This occurred after an air traffic assistant, who was working the clnc…NTSB CHI87FA132Accident · 1 fatalField investigationFinal reportJauch Coot · Franklin Grove, ILThe plt deptd mendota, IL on a local test flt under a 40 hour time in service restriction in an experimental home built airplane. A witness stated that the airplane was circling over his farm and then turned south. He said the eng stalled and the airplane…NTSB CHI87LA130Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Lansing, ILDuring an attempted go-around, the right wing struck a tree, the left wing then contacted a building and the aircraft impacted in a freshly plowed field. Witnesses report the aircraft was high and fast and drifting to the right of runway centerline. Also…NTSB CHI87FA124Accident · 1 fatalField investigationFinal reportCessna 152 · Ina, ILBefore the flt, the plt stated his intentions were to practice ngt lndgs. He took off at 2010 CDT with an estd 1.5 hrs of fuel on board. When the acft did not return, a search was initiated. Subsequently, it was fnd by fishermen, submergedin a lake…NTSB CHI87DEE08Accident · 1 fatalFinal reportBede BD5 A-B · Kankakee, ILThe pilot took off on the first test flight in his homebuilt aircraft and after climbing to approximately 1000 ft. AGL, stalled the aircraft. The aircraft then subsequently entered a spin and collided with the ground. There were reports of the aircraft's…NTSB CHI87LA111Accident · No injuriesLimited investigationFinal reportCessna 150M · Pontiac, ILThe plt lost directional control, swerved off the rwy and struck an acft that was parked approx 80 ft from the rwy. There was no evidence of a system malfunction or failure. The wind as reported by the plt at the time of the accident was calm.NTSB CHI87IA109Incident · No injuriesIncident investigationFinal reportBoeing 727-222 · Chicago, ILA united airlines Boeing 727 domestic passenger flight was holding short of runway 32L at the Chicago-o'hare international airport awaiting clearance for an intersection takeoff. A northwest airlines Boeing 747 international passenger flight was holding in…NTSB CHI87LA108Accident · No injuriesLimited investigationFinal reportCessna 150H · Tinley Park, ILApproximately 3 miles short of the destination arpt the plt stated that the engine quit. The acft was lined up with a road but due to heavy traffic the plt elected to stall the acft into nearby trees. Examination of the acft by the FAA following the accident…NTSB CHI87DEE07Accident · No injuriesFinal reportCessna 172 · Lansing, ILThe pilot stated that due to an RPM fluctuation he had diverted to an alternate arpt. He attempted to land on rwy 27 when the wind was from 020 degrees 14 KTS gusting 30 knots. The flap operation was also erratic according to the plt. The acft ran off the…NTSB CHI87IA110Incident · 1 fatalIncident investigationFinal reportCessna 172L · Plainfield, ILThe pilot decided the weather was not good enough to fly, but he would run the engine and turn the tires. He was discovered in the plane by other pilots and later pronounced dead, from carbon monoxide asphyxiation. The muffler had a 12 inch crack which a…NTSB CHI87FA133Accident · 1 fatalField investigationFinal reportBeech V35-TC · Mount Vernon, ILThe acft was on a test flt after a top-overhaul had just been completed. Mechanics rprtd that before the flt, the eng had been properly rigged & operated normally drg run-up. Drg initial climb after takeoff, witnesses said the eng lost power. The plt…NTSB CHI87FA104Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Frankfort, ILAircraft control was lost as the pilot attempted to descend to his assigned altitude of 5000 feet from excessive climb. He was in IFR conditions at the time. The airframe broke apart, empennage first, during the uncontrolled descent to the ground due to high…NTSB CHI87MA101Accident · Serious injuriesMajor investigationFinal reportMcdonnell Douglas DC-10-10 · Chicago, ILAfter arriving at the gate in Chicago, fumes & smoke were noted in zone c of the cabin, then the cabin lgtg went out & the emerg lgtg came on. Maint psnl fnd the #2 APU had an auto-shutdown due to a malfunction. The APU was placarded as inop & the acft was…NTSB CHI87LA093Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Genoa, ILThe aircraft experienced a loss of power on takeoff, for undetermined reasons, and was forced to make an emergency landing. On impact the nose gear and main landing gear sheared off.NTSB CHI87DEE05Accident · Serious injuriesFinal reportResney Commander 447 · Lansing, ILThe acft made a forced landing in a field due to fuel starvation. The acc plt offered to fly the acft out. He had 30 min of dual flt in this type acft. He sat on the left side of the acft for the flt which resulted in an unbalanced condition. The acft entered…NTSB CHI87DEE06Accident · No injuriesFinal reportSchleicher ASK-21 · Plainfield, ILThe glider plt rprtd that drg takeoff, the tow plt released the tow rope at aprx 15' AGL. Rprtdly, he released the tow rope due to a perceived lack of takeoff & climb performance. After being released, the glider plt made a right turn to avoid unacceptable…NTSB CHI87FA087Accident · No injuriesField investigationFinal reportRockwell NA265-65 · East Alton, ILAfter landing pilot lost directional control of the aircraft during rollout. Aircraft struck taxiway edge and taxiway marker sign causing substantial damage to aircraft. Post accident testing of the anti-skid system did not reveal any functional defects.NTSB CHI87FA085Accident · 2 fatalField investigationFinal reportBeech E18S · Quincy, ILThe acft, at near gross weight (CG unknown), was on initial climb after takeoff. A witness reported that engines soundednormal. At about 400 ft AGL the acft was reported to pitch up about 10 degrees, then level off and enter a left turn. The acft made another…NTSB CHI87DEE04Accident · 1 fatalFinal reportCessna 172 · Plainfield, ILWhile taxiing for takeoff, the aircraft became stuck in a snowbank. The pilot and passenger got out of the aircraft to free it. The passenger walked into the propeller of the running engine and received fatal injuries.NTSB CHI87FA069Accident · 1 fatalField investigationFinal reportCessna 210N · Bedford Park, ILJust bfr tkof fm rwy 22L on a ngt IFR flt, the plt was clrd to clb & maint 2000' & to contact chicago dep ctl (TRACON). About 1 min later, he called TRACON & rprtd he was clbg thru 900' for 2000'. This call was in a normal tone of voice & was the last…NTSB CHI87LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, ILDuring second touch & go landing, plt encountered a crosswind. While attempting a go-around, after bouncing three times,the acft drifted to the left. The acft collided with a snowbank and nosed over.NTSB CHI87LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln, ILAccording to the plt, after landing on rwy 03 at logan county airport, the acft encountered ice on the rwy and the left main gear struck snow that had drifted onto the rwy. The plt stated that the acft then collided with a snowbank and flipped over. The acft…NTSB CHI87LA064Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Decatur, ILFollowing taxi to rwy 36, the plt stated that he completed an engine run-up. On the takeoff roll, the acft swerved to the left before colliding with a snowbank approximately 800 feet from the apch end of the rwy. According to the plt, opposite rudder was…NTSB CHI87FA057Accident · No injuriesField investigationFinal reportPiper PA-32-301 · Wheeling, ILThe pilot attempted flight although pirep's for icing had been issued during weather briefing from fss and aircraft was not equipped for icing conditions. Shortly after takeoff, pilot reported to ATC problems with aircraft flight instruments and then reported…NTSB 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…NTSB CHI87FA050Accident · 1 fatalField investigationFinal reportCessna 182P · Durand, ILStudent pilot collided with terrain while attempting to remain in visual contact with the ground during very low light and in very heavy ground fog during a cross country flight. The pilot rushed his departure in an attempt to get home before dark and there…NTSB CHI87LA041Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Vergenns, ILAccording to the student pilot, while practicing emergency landings, he descended to about 250 feet AGL and then surrendered the controls to the instructor. The student pilot stated that the instructor immediately added full power and banked the acft to the…NTSB 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…NTSB CHI87LA038Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Rockford, ILShortly after takeoff at about 100 feet AGL, pilot reports the engine lost power, aircraft stalled, entered a spin, and collided with the ground. Inspection of the aircraft and magnetos did not disclose any discrepancies other than possible coil deterioration.NTSB CHI87LA027Accident · No injuriesLimited investigationFinal reportCessna T210N · Kankakee, ILThe plt overran rwy 22 after landing downwind during intrument weather conditions. Fss had advised the plt of a NOTAM that rwy 4 ILS was out of service due to construction. However, another acft which landed on rwy 4 about 15 minutes prior to the accident…NTSB CHI87LA019Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bethalto, ILThe pilot attempted an ILS approach into an airfield (runway 29) that was reporting a zero foot obscured ceiling with 1/16 mile visibiltiy and fog. He stated that he became confused during the last portion of the approach and was beginning a missed approach…NTSB CHI87LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Rockford, ILDuring landing roll, plt applied brakes too hard at high speed and nosed over.NTSB CHI87LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Lansing, ILThe plt rprtd he enctrd IFR conds at aprx 400' AGL drg takeoff. He elected to 'fly out of it' & 'was in the clear' afterclbg to 4500' MSL. He elected to return to the arpt & indcd he could see the arpt 'on and off' thru brkn clds. On an apch to lnd, the acft…NTSB CHI87LA033Accident · Serious injuriesLimited investigationFinal reportCessna 182F · Sandwich, ILThe pilot was attempting to hand prop the aircraft due to a low battery. The engine started and the plane began moving. The aircraft struck the pilot and then traveled into a hangar door.NTSB CHI87LA020Accident · No injuriesLimited investigationFinal reportCessna 310R · Belvidere, ILDuring takeoff roll, the acft door popped open at a point too late to abort the takeoff. The PIC tried to hold the door closed while the second plt flew the acft around the traffic pattern. Just prior to touchdown, the door opened wider and the PIC reached to…NTSB CHI87DEV01Accident · No injuriesFinal reportPiper PA-34-200T · Bloomington, ILAccording to the plt, the acft bounced upon touchdown. She attempted to reflare the acft, however, it bounced again and a go-around was performed. The acft was then landed without further incident. Following the landing it was determined the acft had received…NTSB CHI87FA021Accident · 1 fatalField investigationFinal reportCessna 182P · Goreville, ILThe acft crashed and burned following a collision with a guy-wire supporting a micro-wave tower. The plt had initiated the flt in MVFR weather and continued the VFR flt into IMC conditions. The crash site was located adjacent to interstate hwy 57 and…NTSB CHI87DEE03Accident · Serious injuriesFinal reportQuicksilver MX II · Aurora, ILThe pilot was making a precautionary landing in the ultralight, when during the landing flare he stalled the aircraft and subsequently collided with the terrain.NTSB CHI87LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Harrisburg, ILAccording to the plt, the winds at the destination arpt were variable and gusty. During an approach to land, the acft was high. Reportedly, the wind shifted to a tail wind as the plt was landing & the acft continued off the end of the rwy & went thru a fence.NTSB CHI87FA010Accident · Serious injuriesField investigationFinal reportBeech 58 · Chicago, ILThe pilot departed home base with an undetermined amount of available fuel, after being advised by the lineman/refueler of the uncertainty of the amount of fuel onboard. The pilot assumed the aircraft had been refueled the previous evening and departed on…NTSB CHI87FA009Accident · 1 fatalField investigationFinal reportCessna 441 · West Chicago, ILThe plt (a part time employee of the owner) was ferrying the acft for maintenance. Witnesses, who saw the plt bfr take- off, noted that his speech was slurred & that he seemed angry because a tug would not start. One witness characterized him as being 'very…NTSB CHI87LA006Accident · No injuriesLimited investigationFinal reportCessna 120 · Decatur, ILThe pilot stated that he was practicing crosswind landings on runway 24 when the airplane bounced twice. According to the pilot, he immediately added power and then lost directional control of the airplane and ground looped to the left. Following the ground…NTSB 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…NTSB CHI87DEE02Accident · No injuriesFinal reportPiper PA-23-250 · Crestwood, ILThe aircraft was flown without authorization from the owner by unknown person(s). Upon landing, directional control was lost. The aircraft skidded off the runway into an aircraft tie-down area and collided with a parked aircraft.NTSB CHI87LA001Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chicago, ILThe student pilot assumed he had full fuel tanks prior to takeoff. He then proceeded to fly the aircraft for approximately 4.4 hours. Just prior to his final landing he was forced to go around due to an aircraft on the runway. Following this go around he…NTSB CHI87DEE01Accident · Minor injuriesFinal reportCessna 182E · Plainfield, ILAccording to the pilot he performed a 'thorough' fuel system preflight by draining three clear fuel specimens from each wing and the belly drains. Shortly after takeoff the engine quit due to water contamination of the fuel system. Following the accident a…NTSB CHI86FA233Accident · 1 fatalField investigationFinal reportBeech E18S · Chicago, ILThe acft had departed on rnwy 13. He was then directed to climb to 6000 ft. thirty seconds later he advised he had eng trouble and was returning to the arpt. Shortly thereafter he advised he could not maintain alt. The acft, one mile se of the arpt, struck…