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 CHI83LA384Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Blue Island, ILAcft ran off side of rwy & the left wing collided with corn stalks causing the acft to spin 180 deg.NTSB CHI83LA373Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Wheeling, ILThe pilot stated that he taxied southeast on runway 12L, then turned to taxi northwest on runway 34. During the turn, the left main gear went off the runway and into a hole in the sod. The width of runway 12L is 50 ft and the width of runway 34 is 100 ft. the…NTSB CHI83LA375Accident · No injuriesLimited investigationFinal reportQuickie Q2 · Decatur, ILThe acft made a hard landing and broke the front canard after bouncing on touchdown and dragging the left wing. The pilot had been informed by the tower that black smoke was coming out of the engine. This turned out to be from an excessively rich mixture. The…NTSB CHI83LA374Accident · No injuriesLimited investigationFinal reportCessna 150 · Springfield, ILThe acft made a forced landing in a corn field and nosed down after the engine stopped during flt. During pre-flt the pilot had looked in the tanks and measured the amount of fuel with the tie cap chain. He thought he had enough fuel for the flt even though…NTSB CHI83LA372Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Wheeling, ILThe plt was unable to start the eng using normal procedures. He obtained the use of an APU & still could not make an electrical start. He stated that he turned the magneto & master switches off & rotated the propeller (prop) backwards 1/2 turn (to check for…NTSB CHI83LA364Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Lansing, ILThe acft had just been given an annual inspection & the plt was on the 1st flt back to the home arpt. He reported that before takeoff, he noted that the eng would not idle below 850 RPM. He elected to continue with the flt. During the takeoff roll, he pulled…NTSB CHI83FA365Accident · 1 fatalField investigationFinal reportCessna 182 · Marseilles, ILThe acft was on a parachute jumping mission. After climbing to 9000 ft MSL, 4 sky divers jumped out & the plt began a descent back to the arpt. The acft was seen level at aprx 500 ft AGL & in the aprx position for a downwind leg for a left pattern for runway…NTSB CHI83FA334Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Dwight, ILThe acft crashed in a corn field during a heavy rainstorm while on a cross country flight. The pilot had logged 4 hour of simulated instrument time and was not instrument rated.NTSB CHI83LA352Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Pittsfield, ILThe student plt was on a personal flt with a passenger on board. During arrival, he landed on rwy 25 (1700 ft long) with a x-wind from 160 deg at 8 KTS. He reported that the landing was made on his 2nd attempt, but he did not get on the ground soon enough to…NTSB CHI83FA353Accident · No injuriesField investigationFinal reportGulfstream AA-5B · West Chicago, ILThe plt reported that during a night landing, the acft began to porpoise. He applied power to go around, but the plane went off the left side of the rwy. Subsequently, it collided with brush & a chain link fence & came to rest on residential property. The plt…NTSB CHI83FA346Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Lily Lake, ILThe plt reported that a neighbor had flown the acft earlier in the day & had problems adjusting the elevator trim when airborne. The plt stated that before takeoff, he checked the trim, but it worked normally, so he set it for cruise & made a normal takeoff.…NTSB CHI84LA348Accident · No injuriesLimited investigationFinal reportCessna 152 · Urbana, ILThe student plt stated that when approaching over wires she 'powered up and ended up coming in too fast.' The acft made initial contact on the nose wheel. Subst damage to the eng mount area and the left wing.NTSB CHI83LA342Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Camp Point, ILThe plt had just completed a swath run. As he approached a road he pulled up to avoid a car, then attempted to descend below power lines & in so doing collided with a stop sign. The acft cartwheeled & landed inverted in a bean field.NTSB CHI83LA340Accident · No injuriesLimited investigationFinal reportCessna 150 · East St Louis, ILThe CFI noticed the acft was not climbing & the airspeed was not increasing. He took control of the acft & landed in a bean field. He later stated that the flaps were not retracted by the student after takeoff.NTSB CHI83LEE01Accident · No injuriesFinal reportQuickie Q-2 · Chicago, ILThe plt reported that during an en route stop, the acft landed hard, then bounced & was damaged in the area of the tailwheel. Reportedly, the tailwheel spring separated, the rudder pedals flopped forward & control of the rudder was lost. Subsequently, the…NTSB CHI83IA327Incident · No injuriesIncident investigationFinal reportDouglas DC-8-71 · Chicago, ILOn landing roll the acft rolled forward off the departure end of the landing runway. The crew stated that maximum braking, revers, & spoilers were utilized. The runway was covered wth standing water.NTSB CHI83LA308Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Chandlerville, ILThe acft made a forced landing after losing power at 1500 ft the pilot said the engine ran rough, oil pressure went to zero and the engine stopped. This pilot had been forced to land the same acft 3 days earlier when the engine lost power during takeoff.…NTSB CHI83LA303Accident · No injuriesLimited investigationFinal reportCessna 152 · Peoria, ILThe acft was damaged in a forced landing after a power loss during takeoff. This was a dual instructional flt. The CFI stated that the engine lost power at about 100 ft AGL & he made a forced landing straight ahead. The fixed base operatorstated that…NTSB CHI83LA292Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Wheeler, ILThe plt reported that while he was returning for another load of chemicals, the eng missed a couple of times, then smoothed out for about 1 min. After that, the eng missed again, then quit while the helicopter was at aprx 150 ft AGL. The plt chose to clear…NTSB CHI83IA299Incident · No injuriesIncident investigationFinal reportDouglas DC-8 · Chicago, ILShortly after takeoff during initial climb the no 1 engine failed and an engine fire erupted. The crew discharged 2 firebottles and extinguished the fire. The acft returned to the field and landed without further incident. The no 1 engine 1st stage compressor…NTSB CHI83LA295Accident · No injuriesLimited investigationFinal reportBell 47G2 · Thomasville, ILThe helicopter tail rotor struck the ground during landing. The helicopter was engaged in aerial application and was returning to reload. The plt reported that at touchdown a gust of wind caused the tail rotor to hit the ground. Decatur winds were reported as…NTSB CHI83LA285Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Lockport, ILPlt stated a company acft landed 2-5 min ahead of him on rwy 9 with light winds out of the east. Prior to pattern entry the plt noticed dark clouds to the west with rain. After landing he could not stop the acft & went off the end of the rwy. The acft…NTSB CHI83LA281Accident · No injuriesLimited investigationFinal reportGrumman AA5 · Monee, ILThe acft crashed on the left wing tip into a bean field during a go-around. The pilot stated that the approach was high. The acft ballooned and bounced at touchdown. The pilot thought that there was not enough runway left so she started a go-around. At about…NTSB CHI83LA277Accident · No injuriesLimited investigationFinal reportCessna 188B · Campbell Hill, ILAfter taking off from a haul road, which was being used as an airstrip, the acft began climbing. At about 100 ft AGL, the plt noted a loss of power (thrust) as the eng began to overspeed. The plt lowered the nose to gain airspeed & dumped his load, but was…NTSB CHI83LA270Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Paris, ILThe plt of the Grumman G-164A, N952X, reported that after the acft was loaded & fueled, he started to taxi northbound on a taxiway from the ramp to the rwy. At about the same time, a student plt in a Cessna 152, N67449, had landed on the rwy & turned…NTSB CHI83IA269Incident · No injuriesIncident investigationFinal reportBoeing B-747 · Chicago, ILThe united airlines B747 was standing in the run up area adjacent to the runway. A flying tigers B747 was passing to his left. The crew of the parked B747 opened their overhead escape hatch and indicated to the taxiing B747 with a thumbs up sign that there…NTSB CHI83LA230Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Waukegan, ILThe student was receiving a high performance checkout. During the third landing the acft landed hard.NTSB CHI83FA251Accident · Serious injuriesField investigationFinal reportBoeing 727-222A · Chicago, ILDuring the takeoff roll, the #1 eng failed & the takeoff was aborted at aprx 70 KTS. The aircrew taxied the acft clear of the rwy & stopped on the reverse high speed turnoff. The aircrew of another company acft transmitted that the #1 eng was on fire. There…NTSB CHI83LU002Accident · Serious injuriesFinal reportBarnstormer 1 · Newton, ILDuring takeoff, the right wing collapsed when the ultralight vehicle was climbing thru aprx 100 ft AGL. An investigation disclosed that the right wing spar failed allowing the section, outboard of the strut attach point, to fold upward.NTSB CHI83LA238Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Park Forrest, ILThe acft was being flown on a routine flight check after having completed an annual inspection. The plt stated that after takeoff he climbed to 800 ft, turned downwind, extended flaps to 30 deg, slowed to 70-80, & intended to make a pass over the field to…NTSB CHI83LA237Accident · No injuriesLimited investigationFinal reportCessna 182G · Dongola, ILWhile landing with a x-wind at 10 gusting 20 KTS, the acft encountered a gust & floated almost half way down the 1800 ft sod strip. It became apparent to the plt that braking alone may not be sufficient to stop. He elected not to go-around since there were…NTSB CHI83LA235Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Rockford, ILThe pilot was alone in the basket and was practicing a steep approach to land. The pilot said the reason for his injuries was not the hard landing but lack of preparation for it.NTSB CHI83LA227Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Elgin, ILThe acft collided with the roof of a trailer truck during an approach to land over a toll road. The collision separated the left main gear from the acft and damaged the other two landing gear. The impact left two depressions about 2 inches deep in the edge of…NTSB CHI83FA224Accident · Minor injuriesField investigationFinal reportCessna 172P · Joliet, ILThe acft made a hard landing and nosed over during a forced landing after engine failure on the base leg. The flt was onthe base leg with power at idle and carburetor heat on when the engine lost power. The pilot was unable to restart the engine. The pilot…NTSB CHI83LA217Accident · No injuriesLimited investigationFinal reportCessna 172 · Mchenry, ILThe acft went off the departure end of runway 09 during landing and nosed over. The weather as reported by the operator,was scattered clouds, more than 5 miles visibility and winds calm. Runway 09 had been in use all day. The pilot stated that his approach…NTSB CHI83FA213Accident · 1 fatalField investigationFinal reportMooney M-20-J-201 · Bloomington, ILPrior to the accident, a witness heard the acft, then saw it for a short time thru an opening in the clouds. In his opinion, it was heading directly into a thunderstorm, which concerned him. He said that rain was falling, and about 10 min later, the…NTSB CHI83LA206Accident · No injuriesLimited investigationFinal reportCessna 152 · Chicago, ILThe student plt took off from midway arpt, flew to another arpt to practice landings, then returned to midway to land. While he was on an approach to land on rwy 22R, the tower controller requested that the student make a short approach due to other traffic.…NTSB CHI83FA205Accident · Serious injuriesField investigationFinal reportBeech A36 · Minonk, ILThe plt reported that during takeoff from a private farm strip, he had only 70 KTS as he apchd the end of the rwy. By then, there was not enough room to abort & he believed the acft had insufficient airspeed to clear wires along a roadway about 330 ft from…NTSB CHI83LA198Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Mount Vernon, ILAfter takeoff, the acft was climbing thru about 500 ft AGL when there was a considerable power loss. Subsequently, the acft struck trees while the plt was attempting to return to the rwy. An exam of the eng was made, but the reason for the power loss was not…NTSB CHI83LA194Accident · No injuriesLimited investigationFinal reportMooney M20E · Springfield, ILThe acft ran off the left side of the rwy and collided with the VASI after landing. The plt stated he landed on rwy 22 when approach said the wind favored that rwy. He said that 'just as the wheels touched down a gust of wind pushed the nose to the left and…NTSB CHI83LA193Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Schaumburg, ILThe rated student was on an instructional flt to become a helicopter instructor plt. During an autorotative landing in a farmer's field, the helicopter landed hard & the main rotor hit the tail cone.NTSB CHI83LA190Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Havana, ILThe aircraft collided with the ground during an attempted go around when the pilot stated that he did not see but two ofthe landing gear lights on. The approach was to runway 9 in a crosswind from 170 degrees at 18 KTS with gusts to 24 KTS the pilot described…NTSB CHI83LA186Accident · No injuriesLimited investigationFinal reportAerosport Scamp · Edwardsville, ILThe plt was on a test flt in a homebuilt acft with only 3.7 hrs total flt time. While in a full power climb from 1000 to 2000 ft AGL, he noticed black smoke coming from the left exhaust stacks. The power was reduced to a cruise setting, and reportedly, there…NTSB CHI83LA182Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Champaign, ILThe acft was landed with the gear up. Investigation revealed during a retraction test, that no malfunction of the landing gear system prevented normal operation. Electrical system showed that the warning the horn did not operate. When the cockpit was checked…NTSB CHI83LA183Accident · No injuriesLimited investigationFinal reportCessna 172 · Frankfort, ILThe wind was gusting to 40 KTS. The pilot stated a strong gust of wind lifted the left wing and blew the acft off the runway where a row of trees swung the acft into a plowed field. The pilot said the winds were stronger than reported.NTSB CHI83LA191Accident · No injuriesLimited investigationFinal reportBeech BE-19-180 · Champaign, ILThe acft drifted across the runway in a crosswind and collided with a runway light. The student pilot had taken off on runway 22 for his first solo flight. The tower changed runways according to the pilot and made 04 the active. The wind was 150 degrees at 8…NTSB CHI83LA171Accident · No injuriesLimited investigationFinal reportBeech F33A · Peoria, ILPlt forgot to lower landing gear.NTSB CHI83LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · Kankakee, ILThe student plt was on a round robin, cross-country training flt. His first landing was made on rwy 4 at the greater Kankakee arpt. During touchdown in a strong cross-wind, the acft bounced, then veered off the rwy. The acft then encountered soft terrain and…NTSB CHI83FA161Accident · 2 fatalField investigationFinal reportCessna 182 · Coulterville, ILDuring a wx briefing before takeoff, the non-instrument rated plt was advised that VFR flt was not recommended. However, he departed sheboygan, WI at aprx 1500 CST with no flt plan. At dusk, witnesses (near the crash site) heard the acft maneuvering. One…NTSB CHI83FA148Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Rochester, ILThe acft experienced an in-flt break-up during descent. The pilot had reported on the radio to Kansas city ARTCC that hewas having severe chest pains and shortness of breath. Radar contact with the plane was lost at 1425 CST. The pilot had reported he was…