NTSB investigations, IL
86 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 2 |
| 1984 | 5 |
| 1985 | 5 |
| 1986 | 5 |
| 1987 | 2 |
| 1988 | 5 |
| 1989 | 4 |
| 1990 | 7 |
| 1991 | 3 |
| 1992 | 6 |
| 1993 | 4 |
| 1994 | 7 |
| 1996 | 3 |
| 1997 | 4 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 4 |
| 2003 | 3 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 3 |
Where
Open the mapLatest cases
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\" = 220)
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" = 220) 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 CHI07LA207Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Wyoming, ILThe pilot's failure to maintain clearance with the power lines during the aerial application flight. Contributing to the accident were the power lines and the low altitude.NTSB CHI07CA188Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Walkerville, ILThe altitude/clearance not maintained by the pilot during the aerial application flight. The corn was a contributing factor.NTSB CHI07LA093Accident · No injuriesLimited investigationFinal reportBoeing 767-300 · Chicago, ILThe contained fan blade tip separation following the ingestion of several birds into the left engine during takeoff and the lack of an adequate response time available to crew to avert the bird strike.NTSB CHI07CA075Accident · No injuriesData collectionFinal reportBombardier BD-100-1A10 · Waukegan, ILThe bird strike during initial climb after takeoff from the departure airport.NTSB CHI05CA151Accident · No injuriesData collectionFinal reportKirby Christen Eagle · Wheeling, ILThe pilot's inadequate compensation for the wind conditions, and his failure to maintain obstacle clearance, which resulted in the airplane drifting during the landing flare and impacting the taxiway light.NTSB CHI04IA260Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Chicago, ILAn in-flight collision with a flock of birds during climb out after takeoff, which damaged the left engine fan module and ruptured a fuel line to the fuel-oil cooler causing an engine fire.NTSB CHI04LA254Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Ancona, ILThe pilot became incapacitated (unconscious) for undetermined reasons which resulted in his inability to maintain altitude.NTSB CHI04LA016Accident · Serious injuriesLimited investigationFinal reportOostdik M-18-X · Pana, ILThe pilot's attention was diverted to a person on the ground which resulted in his failure to maintain altitude/clearance with trees . A contributing factor to the accident were trees.NTSB CHI03LA212Accident · No injuriesLimited investigationFinal reportCessna 172P · Pinckneyville, ILThe planned approach not maintained by the pilot and the delayed remedial action by the certified flight instructor. A contributing factor to the accident was the approach light.NTSB CHI03IA108Incident · No injuriesIncident investigationFinal reportPiper PA-31T1 · Wheeling, ILThe pilot's failure to maintain obstacle clearance and the inadequate glidepath which resulted in a collision with a utility pole. Contributing factors were the lack of experience in the incident airplane by the left seat pilot, the visual illusion of a…NTSB CHI03LA040Accident · No injuriesLimited investigationFinal reportCessna 172M · Moline, ILThe pilot's failure to maintain altitude clearance during a base to final turn on approach. Contributing factors to the accident were the night conditions and the trees.NTSB CHI02LA295Accident · No injuriesLimited investigationFinal reportCessna 172R · Greenwood, ILThe CFI's poor inflight planning/decision to allow the airplane to get to too low of an altitude to assure a safe recovery from the simulated forced landing. Factors associated with the accident were the student pilot's delay initiating the go around and the…NTSB CHI02CA201Accident · Minor injuriesData collectionFinal reportSchweizer 1-26B · New Douglas, ILThe probable cause of this accident was a failure to maintain the proper glide path and sufficient obstacle clearance while on final approach.NTSB CHI02LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Christopher, ILThe in-flight collision with a Canadian goose, which caused substantial damage to the airplane's right wing. A factor to the accident was the dark night light condition.NTSB CHI02LA007Accident · 1 fatalLimited investigationFinal reportWoodrow Stolp-Adams Starduster SA-100 · Millstadt, ILThe pilot not maintaining altitude/clearance from the tree line. Factors to the accident were the pilot attempting the low altitude flight/maneuver and the presence of the tree line.NTSB CHI01FA312Accident · Serious injuriesField investigationFinal reportPiper PA-32R-301T · Downers Grove, ILthe improper preflight planning/preparation and the short field take off/procedure not followed by the pilot. Contributing factors were the airplane's forward center of gravity, the variable gusting wind and improper weight and balance calculations by…NTSB CHI00LA270Accident · Minor injuriesLimited investigationFinal reportRaven AS-55A · Lincoln, ILThe pilot failed to maintain clearance with the power lines. Factors associated with the accident were the pilot's attention was diverted and the power lines which the balloon contacted.NTSB CHI99FA278Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Grayslake, ILthe pilot not maintaining altitude and clearance. Factors were the light condition of night, the pilot's lack of recent experience in night operations, and the transmission wire.NTSB CHI98FA082Accident · 1 fatalField investigationFinal reportBeech 95-55 · Pinckneyville, ILThe pilot descent below minimum descent altitude and his intentional operation with known deficiencies in equipment. Factors were the dark night, fog, rain, and the trees.NTSB CHI98LA044Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Woodstock, ILthe pilot's failure to see-and-avoid the powerlines on short final. The location of the powerlines was a related factor.NTSB CHI98LA029Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Robinson, ILthe pilot's improper decision to continue flight into adverse weather conditions The low ceiling and the heavy rain were factors.NTSB CHI97LA227Accident · Minor injuriesLimited investigationFinal reportKearns RV-6 · Harrisburg, ILThe pilot's failure to maintain adequate clearance. A factor was the marked transmission wire.NTSB CHI97LA150Accident · Serious injuriesLimited investigationFinal reportGrumman G164 · Illinois City, ILfailure of the pilot to see and maintain clearance from a static wire. The proximity of the wire was a related factor.NTSB CHI96LA310Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Galesburg, ILfailure of the pilot to maintain clearance from trees that protruded into the field that he was spraying.NTSB CHI96TA260Accident · No injuriesFinal reportSchweizer SGS 2-33AK · Mattoon, ILthe pilot's failure to maintain directional control of the glider. Factors were the runway sign and the failure of the pilot to maintain a visual lookout.NTSB CHI96LA156Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Crystal Lake, ILthe pilot not flying a proper glidepath for the displaced runway threshold.NTSB CHI95LA037Accident · Minor injuriesLimited investigationFinal reportBeech G35 · Frankfort, ILFailure of the pilot to see-and-avoid the vehicle, and the vehicle driver's disregard for the need to remain clear of the aircraft's approach path. A factor related to the accident was: the proximity of a parked airplane to the runway.NTSB CHI95LA005Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Carbondale, ILthe pilot's inadequate visual lookout, and improper altitude.NTSB CHI94LA289Accident · No injuriesLimited investigationFinal reportCessna 172 · Plato Center, ILThe pilot's attempt to take off on a short runway with a gross weight which exceeded the maximum allowable weight and an improper flap setting. A factor was the location of obstructions (trees) at the departure end of the runway.NTSB CHI94LA292Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Clifton, ILthe pilots failure to keep visual contact with and to avoid unmarked powerlines adjacent to the crop field he was spraying.NTSB CHI94LA246Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Lomax, ILthe pilot's failure to maintain clearance from a transmission wire, and the pilot's failure to maintain an appropriate altitude. A factor associated with the accident is the transmission wire.NTSB CHI94FA209Accident · Serious injuriesField investigationFinal reportCameron CAN-56 · West Chicago, ILthe pilots failure to maintain vertical clearance above powerlines which bordered the field in which he intended to land. A factor associated with the accident were the powerlines.NTSB CHI94LA161Accident · No injuriesLimited investigationFinal reportBell 206B · Winnebago, ILa wire strike due to failure to maintain proper altitude, and improper visual lookout by the pilot-in-command.NTSB CHI94LA046Accident · No injuriesLimited investigationFinal reportCessna 550 · West Chicago, ILthe collision with birds/geese shortly after takeoff. Reduced visibility in fog was a factor.NTSB CHI93DEE05Accident · Serious injuriesFinal reportWeatherly 620 · Mendota, ILThe pilot-in-command's failure to maintain clearance fom powerlines during an aerial application manuever.NTSB CHI93LA209Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Newark, ILThe pilot's premature liftoff.NTSB CHI93LA183Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Flora, ILthe delayed remedial action by the flight instructor. A factor related to the accident was the lack of total experience in this type operation by the flight instructor.NTSB CHI93LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Manhattan, ILInadequate compensation for wind conditions by the pilot.NTSB CHI93FA029Accident · 2 fatalField investigationFinal reportCessna 150L · Elwood, ILThe pilot-in-command's failure to maintain a proper adequate altitude to avoid obstructions. Factors contributing to the accident was the pilot's impairment of efficiency and judgement due to alcohol, and the dark night condition.NTSB CHI92LA288Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Belvidere, ILThe pilot's failure to maintain adequate clearance from obstacles during the aborted landing. Related factors are the failure to maintain directional control, and the pilot's lack of total experience in the type of operation.NTSB CHI92LA203Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Harvard, ILThe pilot's failure to understand wind information as presented by the windsock, selecting the wrong runway for landing, and delaying the aborted landing.NTSB CHI92LA192Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Erie, ILThe pilot's failure to maintain a proper glidepath.NTSB CHI92LA155Accident · No injuriesLimited investigationFinal reportCessna 172RG · Dekalb, ILThe pilot not maintaining a proper glidepath to the landing runway.NTSB CHI91LA219Accident · No injuriesLimited investigationFinal reportSchweizer 2-32 · Plainfield, ILPilot's failure to attain proper alignment with the runway. A factor related to the accident was the high vegetation/crop in which the landing was made.NTSB CHI91FA216Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Seneca, ILProper glidepath not maintained, and inadequate altitude and visual lookout by the pilot in command.NTSB CHI91DEE06Accident · No injuriesFinal reportRobinson R22B · Mineral, ILFailure of the pilot to maintain clearance from the power line.NTSB CHI90LA256Accident · Serious injuriesLimited investigationFinal reportBoeing B75N1 · Marseilles, ILThe pilot-in-command's failure to maintain adequate visual outlook to avoid collision with a wire while conducting intentional low level flight.NTSB CHI90LA241Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Schaumburg, ILThe pilot's failure to attain a proper climb rate after takeoff. Factors related to the accident are misjudgement of the aircraft takeoff weight, and overconfidence in the ability of the aircraft.NTSB CHI90DEV09Accident · 1 fatalFinal reportPietenpol AIR Camper · Minonk, ILThe pilot's inattention to visual lookout.NTSB CHI90LA220Accident · No injuriesLimited investigationFinal reportSchleicher ASK-21 · Plainfield, ILThe glider pilot's improper aircraft handling at low atitude.