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 CHI83LA145Accident · No injuriesLimited investigationFinal reportCessna 152 · Mt. Carmel, ILThe plt stated he landed downwind, the approach was high & fast & when the acft landed there was only 800 ft of rwy remaining. The plt could not stop the acft before it ran off the end of the rwy & nosed over in a plowed field. The plt is blind in one eye &…NTSB CHI83FA138Accident · No injuriesField investigationFinal reportPiper PA-601P · Wheeling, ILAfter making an ILS approach to rwy 16, the plt was cleared to circle and land on rwy 34. As he turned final, he was to the west side of the runway and was too high to land, so he made a left turn-around back to rwy 34. Tower personnel turned the rwy lights…NTSB CHI83LA137Accident · No injuriesLimited investigationFinal reportCessna 152 · Waukegan, ILThe student pilot made a hard landing on his first solo flight. The aircraft bounced several times and damaged the nose landing gear. The student had made four full stop landings with an instructor pilot. Then the instructor deplaned for the student to make…NTSB CHI83FA135Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Danvers, ILThe aircraft crashed at night during IMC weather conditions on the return portion of a cross-country. The pilot had checked the weather outbound, but there was no record of a briefing for the return flight. The outbound flt was in early dusk. The return was…NTSB CHI83LA132Accident · No injuriesLimited investigationFinal reportCessna 210 · Huntley, ILThe pilot stated he was aware of the cross wind so he used only 10 degrees of flaps. The acft began to drift while landing on runway 31. The pilot said he was holding 80 KTS on approach and as he started to flare the acft touched down hard on the rt main gear…NTSB CHI83FA125Accident · 1 fatalField investigationFinal reportDodd Pitts S1S · Harvard, ILThe acft crashed into an open field leaving no ground scars other than the principal impact. One witness saw the acft stall at the top of a loop and go into a spin (tail-down). He stated the acft rotated 6-8 times prior to impact with the engine running. The…NTSB CHI83FA122Accident · No injuriesField investigationFinal reportCessna 150 · Wheeling, ILThe student pilot was making a touch-and-go landing and at about 100 ft AGL the engine stopped. A restart was to no avail. The plt stated that he kept the airspeed near stall speed until ground impact. There was fuel spillage at the accident site and no…NTSB CHI83LA121Accident · No injuriesLimited investigationFinal reportCessna 172 · Galesburg, ILThe plt stated that during cruise, the engine started to run rough. He applied carburetor heat & initiated emergency procedure, and then engine power was restored. However, a short time later, power was lost again. During a forced landing in an open field,…NTSB CHI83LA106Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Vernon, ILThe aircraft ran off the end of a runway and collided with a ditch. The student pilot on his first solo cross country had become disoriented and landed 95 miles off course. He had been flying 2 hours and 30 minutes. He was supposed to reach enroute stop after…NTSB CHI83LA100Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Chicago, ILThe acft collided with a parked acft on the ramp. The student pilot started the acft on a snow covered icy ramp at nightthe parking brakes were set but when the engine started the acft taxied into another acft. After the accident the brakesof the acft were…NTSB CHI83LA095Accident · No injuriesLimited investigationFinal reportCessna 140 · Richview, ILThe acft collised with a ditch and nosed over during a forced landing after the engine stopped in cruise flt. The pilot said he checked the carburetor heat on the ground but did not use it in the air. After the landing the engine was inspected and no…NTSB CHI83FA092Accident · No injuriesField investigationFinal reportObryon Mustang II · West Chicago, ILThe home built acft was on its 1st flt after being constructed. The takeoff was initiated on rwy 33 with the wind from 030 deg at 10 KTS. The plt reported that during the takeoff, the right wing lifted, but the left wing would not come up. When control became…NTSB CHI83FA089Accident · No injuriesField investigationFinal reportCessna 172 · Rockford, ILThe acft collided into the 2nd floor of a building while making an ILS approach to runway 36 at Rockford, IL. The weather was IMC. An IFR flight plan was filed. A pilot weather briefing was not given. The pilot was instrument rated. An approach was attempted…NTSB CHI83LA088Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · St. Jacob, ILThe pilot reported that during the landing roll, he inadvertently retracted the gear.NTSB CHI83LA087Accident · No injuriesLimited investigationFinal reportCessna 150M · Cahokia, ILThe acft collided with a ditch during a forced landing after the engine quit during a takeoff climb. The student pilot was climbing out after a touch and go landing and at about 200 ft AGL the engine quit. The CFI took control of the acft and checked for an…NTSB CHI83LA084Accident · No injuriesLimited investigationFinal reportCessna 182 · Wheaton, ILWhile in cruise flight at 2500' AGL the carburetor ice warning light came on. The pilot applied carburetor heat and the light went out. After the light went out the pilot returned the heat to 'off.' The pilot repeated the above sequence and when the light…NTSB CHI83IA097Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC10-10 · Chicago, ILToo high a deck angle was attained during the flare & the acft floated dragging its tail on touchdown & leaving a 2 ft piece of metal on the rwy. The first officer was at the controls.NTSB CHI83FA080Accident · No injuriesField investigationFinal reportPiper PA-28-140 · Glenview, ILDuring a long final approach to o'hare intl arpt the eng quit at 1,900 ft MSL. The plt was over a residential area but found a short field in which to land. The left main landing gear separated & then the left wing separated. The fuel selector was found…NTSB CHI83LA078Accident · No injuriesLimited investigationFinal reportMooney M20A · Ashkum, ILThe pilot made a precautionary landing in a plowed field during a ferry flight because of lowering ceiling and darkness,during the landing the gear collapsed from overload. The pilot was delayed in his departure for maintenance and service. Increasing clouds…NTSB CHI83FA076Accident · 3 fatalField investigationFinal reportCessna 172M · Hanover Park, ILThe aircraft crashed in an open field about one and one half miles from the departure airport. The weather was IMC with low ceilings and visibilty in fog and snow. There was no record that the pilot received a weather briefing. Ground witnesses near the site…NTSB 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…NTSB CHI83LA073Accident · No injuriesLimited investigationFinal reportCessna 180 · Monee, ILThe acft ran off the right side of the runway during landing on rwy 27. The wind was from 320 to 350 degrees at 12-15 KTS. After the acft left the rwy it encountered soft plowed ground and nosed over. The pilot had only 6 hrs solo in make and model.NTSB CHI83LA071Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Plato Center, ILThe wind at the nearest facility was reported to be from 350 degrees at 12 KTS. The pilot reported the wind sock at the airport was showing wind from 310-320 degrees at 10 KTS or less and gusting. He made two go-arounds because of gusty winds and difficulty…NTSB CHI83LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Ridott, ILThis was the pilot's first operation on the 1320 ft strip. After touchdown, he encountered poor braking action and attempted to go around. When he realized he had insufficient runway remaining, he aborted the go-around. Subsequently, the aircraft collided…NTSB CHI83LA062Accident · 1 fatalLimited investigationFinal reportScorpion Too · Sandwich, ILThe rotorcraft impacted the runway very hard with no flare after the engine quit 100-200 feet AGL. The pilot had no training in this aircraft. No fuel was found in the fuel tank and no fuel odors were present. An examination of the fuelsystem, engine and…NTSB CHI83LA058Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Lacon, ILAfter a normal liftoff to pattern altitude the engine began to miss and backfire. The pilot returned to the airport. The pilot performed a thorough magneto check finding no unusual indications. The pilot tookoff and at approximately 200 ft the engine back to…NTSB CHI83LA053Accident · No injuriesLimited investigationFinal reportCessna T210 · Frankfort, ILAfter touchdown the right wing of the aircraft suddenly lifted, directional control was lost and the aircraft struck a row of trees.NTSB CHI83LA048Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockford, ILThe student pilot with his instructor on board were performing touch and go landings. After the third takeoff the engine quit at approximately 150 ft AGL. The pilot made an emergency landing between the two runways at Rockford. Examination of the engine…NTSB CHI83LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Grayslake, ILDuring arrival, the pilot landed on runway 24 with a left quartering, gusty head wind at 8 to 10 KTS. The pilot reported that during the landing, the aircraft suddenly veered left and went off the runway. After departing the runway, the aircraft hit a…NTSB CHI83LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Schaumburg, ILThe newly purchased aircraft had just been delivered and the pilot elected to fly it a short period to check its operation. He performed one takeoff and landing, then started another takeoff. He reported that during the second takeoff, the engine lost power…NTSB CHI83LA029Accident · No injuriesLimited investigationFinal reportFlagg 13 · Lansing, ILThe pilot stated he took off to the west and just after becoming airborne the engine lost power. The aircraft landed in a bean field. Examination of the fuel system revealed that the inlet fuel line to the fuel pump had rotted and large pieces of the interior…NTSB CHI83LA025Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lansing, ILThe acft had a complete electrical failure & the plt made an emergency landing at Lansing. The plt was unable to lower the flap, & after encountering ground fog landed long, bounced, & ground looped to avoid running off the end of the rwy. Invest of the elect…NTSB CHI83FA022Accident · 1 fatalField investigationFinal reportCessna R182 · Lemont, ILThe pilot took off at 0642 CDT, and at 0645, he reported level at 4000 ft MSL. At 0659:08, he preported that he was encountering icing conditions and requested a climb to 6000 ft. at 0700:16, after changing from TRACON to center frequency, he was cleared as…NTSB CHI83LA011Accident · Minor injuriesLimited investigationFinal reportRand KR2 · Fairview, ILThe pilot overflew his destination and attempted to locate the airport. The pilot realized his fuel supply was low and decided to land in an open field. The aircraft's left wing struck the ground during the landing and the aircraftcartwheeled.NTSB CHI83LA010Accident · No injuriesLimited investigationFinal reportBenson B8M · Sandwich, ILThe aircraft was being flown by a person with no pilot rating and no student or medical certificate. After takeoff, he circled the airport and flew over the edge of a lake. Reportedly, the engine suddenly lost power while he was about 300 ft above the…NTSB CHI83LA009Accident · No injuriesLimited investigationFinal reportCessna 150M · Lawsing, ILOn landing roll the student pilot inadvertently added power, ran off the end of the runway and into a ditch.NTSB CHI83FA007Accident · Serious injuriesField investigationFinal reportCessna T210L · Lansing, ILThe pilot cut short a cross-country flight because of weather, and during a down-wind landing, the aircraft overran runway 36. The aircraft was landed fast about 1600 ft down the 2500 foot runway, went off the end and ran into a deep ditch. The wind was from…NTSB CHI83LA003Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Seneca, ILWhile landing on a 2300 ft runway, the plane touched down about 1000 to 1200 ft beyond the approach end. The pilot felt that there was insufficient room to stop safely, so she initiated a go-around. The pilot was unable to attain enough altitude to clear…NTSB CHI83LA002Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Romeoville, ILThe pilot flew over the airport at night, saw the runway lights and entered the traffic pattern for landing. On final approach, he saw a rotating beacon and thought an aircraft was holding short of the runway. As he continued on final, he saw that the beacon…NTSB CHI82DA367Accident · No injuriesFinal reportCessna 207 · Bedford Park, ILPilot made forced landing at night in railroad yard. Engine had loose fuel line.NTSB 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.NTSB CHI82DA362Accident · No injuriesFinal reportCessna 172 · Park Forest, ILThe pilot stated there was a partial loss of power during the takeoff roll. He reported that there was insufficient runway remaining to stop when the power loss occurred. The available airspeed was used to "hop" over a 3-foot embankment, but the nose gear,…NTSB CHI82DA360Accident · No injuriesFinal reportNavy N3N-3 · Danville, ILUpon arriving at an air show the plt was given advisories for a downwind landing. The acft subsequently ground-looped. Subsequent inspection revealed that the tailwheel lock had also malfunctioned. The centering spring was not strong enough to consistently…NTSB CHI82DA358Accident · Minor injuriesFinal reportTaylorcraft BC12-D · Springfield, ILThe pilot stalled after takeoff and the plane crashed in a bean field. The pilot was making a 180 degree turn to return to the private strip. No reason was reported for returning.NTSB CHI82DA356Accident · Minor injuriesFinal reportCessna 172M · Brimfield, ILThe pilot reported that about 30 minutes after takeoff, a partial loss of power was experienced and was accompanied by the sounds of metal-to-metal contact. He headed toward an airport about 12 miles away, but shortly thereafter, total engine failure…NTSB CHI82DA339Accident · Serious injuriesFinal reportRutan Varieze · Litchfield, ILThe pilot had received 20 minutes of instruction in this aircraft prior to his solo flight. The pilot made 8-10 passes at the runway prior to his landing attempt. On approach the aircraft stalled and impacted the runway causing the main gear to collapse.NTSB CHI82DA343Accident · No injuriesFinal reportCessna 310A · Wheeling, ILThe pilot could not get the gear down green light to come on. Several checks made including a fly-by and a advisory that the gear appeared down. During the landing roll the right gear collapsed. Examination of the landing gear system revealed a bent righthand…NTSB CHI82DA316Accident · No injuriesFinal reportBeech G18S · Chicago, ILDuring takeoff on runway 13R, the aircraft swerved to the left just as it obtained tailwheel lift-off speed. The aircraft then struck a dirt bank and was damaged. Both the pilot and the aircraft operator stated that the left main tire lost pressure, but they…NTSB CHI82DA330Accident · No injuriesFinal reportCessna 172 · Winchester, ILThe pilot elected to land on a 1600 ft grass strip with a crosswind of about 5 KTS. He reported that he crossed the fence at about 60 KTS with 15 deg of flaps, then touched down about 400 ft down the runway. During the landing roll, he saw he would be unable…NTSB CHI82DA318Accident · 2 fatalFinal reportMustang II · Plainfield Twp, ILAircraft came down vertically rolling. Just before ground contact or at about 200 feet rolling slowed and aircraft continued descent to terrain contact. No malfunction noted.