NTSB investigations, IL
73 cases where the first occurrence was “In flight collision with terrain/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\" = 230)
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' 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" = 230) 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 CHI88DEE02Accident · 1 fatalFinal reportHill Bushby Mustang II · Yorkville, ILPerformance of aerobatic maneuvers with insufficient altitude for recovery.NTSB CHI88FA046Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Carbondale, ILShortly after reporting the outer marker while executing an ILS runway 18 approach in actual instrument meteorological conditions, the aircraft deviated left of the localizer centerline. At a position approximately 1/2 mile outside the middle marker and about…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 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 CHI86FEV03Accident · 1 fatalFinal reportWoodrow Starduster SA-100 · New Baden, ILThe owner of the single seat, home built, acft offered to allow a navy F-14 plt to fly the plane. The owner made a shortflt, then proceeded to give the F-14 plt a cockpit check. The check-out explaination included such things as the flt characteristics,…NTSB CHI86LA154Accident · No injuriesLimited investigationFinal reportGlasflugel Club Libelle 205 · St. Elmo, ILThere was a loss of thermal activity while the glider plt was on a x-country flt. During an off arpt lndg, the wingtip of the sailplane struck weeds. Subsequently, the acft ground looped & was damaged.NTSB CHI85LA274Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Mt. Carmel, ILThe plt stated that his acft was loaded with dry fertilizer. Following takeoff from the sod strip he failed to clear a dirt bank at the south end of the airstrip. After striking the dirt bank he impacted in a cornfield nose down. Following the accident the…NTSB CHI85LA197Accident · No injuriesLimited investigationFinal reportHughes 269 · Stonington, ILAfter completing a swath run, the plt maneuvered the helicopter up over a power line, then made a turn-around for another swath run. He stated that as he started the next run, he 'felt the wind push the tail upward forcing the nose downward...' He applied aft…NTSB CHI85LA132Accident · No injuriesLimited investigationFinal reportCessna 172 · Champaign, ILDuring a practice asr apch using a vision restricting device the plt in command exceeded the mda and crashed in a field aprx 1 mile from the airport. Recommended altitudes were being issued by ATC. The safety plt issued a warning concerning the low alt as the…NTSB CHI85IA118Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9 · Champaign, ILOzark flt #814 momentarily touched down with the left main landing gear 16 ft off the left side of rwy 31. When 50 ft above minimums during the ILS rwy 31 apch the f/o called rwy in sight. Captain asked for landing lights which the f/o turned on. Captain…NTSB CHI85LA086Accident · No injuriesLimited investigationFinal reportCessna 310Q · Plato Center, ILThe acft experienced a nose gear collapse during landing. The plt stated that while on final apch the acft contacted a 3-4 ft high snowbank near the end of the rwy which resulted in the nose gear collapse. He continued to state the snowbank was difficult to…NTSB CHI85LA048Accident · Serious injuriesLimited investigationFinal reportBeech D-45 (T-34) · Bedford, ILThe plt reported that during flt, he proceeded to fly along a river. After a time, he reversed course & began flying along the river in the opposite direction. He said that the flt back was at a lower alt & that the propeller contacted something in the water.…NTSB CHI85LA038Accident · No injuriesLimited investigationFinal reportCessna 310C · Grayslake, ILThe plt reported that the landing was normal but the acft settled to the rwy with the gear up while the selector was in the down position. Post accident examination failed to reveal any malfunction of the retraction/extension assembly.NTSB CHI84LA259Accident · No injuriesLimited investigationFinal reportBeech S35 · Ottawa, ILThe plt said he 'left word' for the Ottawa arpt lights to be left on until 0200 hrs on 6/24. When the flt arrived at Ottawa, the lights were not on. The plt said he 'attempted to make an approach, it failed.' The acft was landed in a nearby field. The arpt…NTSB CHI84FU001Accident · 1 fatalFinal reportQuicksilver MX · Elwin, ILThe plt possessed a student plt & 3rd class medical certificate. After takeoff, he circled over the airfield, then climbed to about 200 ft AGL. A high school classmate stated that the ultralight then entered a nose high attitude & appeared to enter a practice…NTSB CHI84LA011Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Aurora, ILApproaching the destination arpt the plt was advised by Aurora local control that the only available landing area was anunlighted taxiway, designated temporary rwy 9/27, used as a day VFR rwy. Use of the temporary rwy after sunset was not authorized, & the…NTSB CHI83FA387Accident · 2 fatalField investigationFinal reportAerotek Pitts S-2A · Waukegan, ILWhile on a local flt, the acft crashed in lake Michigan about 1/2 mi from the shoreline. According to witnesses, it was flying over the water at about 100 ft, then pulled almost straight up to about 300 ft above the water, nosed over & went almost straight…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 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 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 CHI83LA171Accident · No injuriesLimited investigationFinal reportBeech F33A · Peoria, ILPlt forgot to lower landing gear.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 CHI82DA043Accident · No injuriesFinal reportPiper PA-28R-201 · Mattoon, ILThe pilot tookoff with an inoperative landing light. After arriving at the destination, it was dark and snowing, and the visibility was about one mile. Airport personnel were removing snow from the lights on runway 11/29. Snow had been cleared from the lights…