NTSB investigations, IL
73 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 8 |
| 1984 | 3 |
| 1985 | 5 |
| 1986 | 4 |
| 1988 | 4 |
| 1989 | 3 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 3 |
| 1995 | 4 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 6 |
| 2001 | 4 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 3 |
| 2007 | 1 |
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\" = 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 CHI08LA046Accident · 1 fatalLimited investigationFinal reportSwearingen T R/Masters W Rand KR 2 · Benton, ILThe reason for this accident is undetermined.NTSB CHI07FA009Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Lawrenceville, ILThe improper judgment by the pilot to conduct a flight to, and execute an approach to, an airport with weather conditions that were below the required minimums. Also causal was the pilot's continued descent below the approach minimum descent altitude.…NTSB CHI06CA252Accident · No injuriesData collectionFinal reportLet Blanik L-13 · Hampshire, ILThe pilot's inadequate approach for landing and his failure to attain a proper descent rate.NTSB CHI06CA214Accident · No injuriesData collectionFinal reportRobinson R-44 · Wadsworth, ILThe pilot inadvertently pulled back on the cyclic when birds flew into the windscreen. A factor associated with the accident were the birds.NTSB CHI05LA125Accident · 1 fatalLimited investigationFinal reportHurley Searey · South Beloit, ILIn-flight collision with the ground for undetermined reasons.NTSB CHI04CA067Accident · No injuriesData collectionFinal reportCessna 172N · Cahokia, ILThe inadequate supervision by the certified flight instructor which lead to the student pilot's failure to maintain clearance from the snowbank during the landing. The snowbank was a factor.NTSB CHI03LA247Accident · Minor injuriesLimited investigationFinal reportTexas Helicopter OH-13E · Byron, ILThe pilot not attaining translational lift during the takeoff. A factor was the high gross weight.NTSB CHI03LA236Accident · 1 fatalLimited investigationFinal reportPolsgrove Bluegrass Express · Grafton, ILUndetermined.NTSB CHI03LA010Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Kincaid, ILThe pilot not maintaining altitude/clearance from the terrain during the aerobatic maneuver. A factor to the accident was the pilot being impaired by alcohol.NTSB CHI02LA249Accident · Minor injuriesLimited investigationFinal reportGoode Acro Sport I · Carbondale, ILThe unsuitable landing area selected by the pilot and his lack of total experience in the accident airplane. The gusting winds were a contributing factor.NTSB CHI01LA321Accident · No injuriesLimited investigationFinal reportBoeing Stearman B75N1 · Carbondale, ILThe pilot misjudged the proper alignment with the landing area. Contributing to the accident was the light conditions.NTSB CHI01LA302Accident · No injuriesLimited investigationFinal reportSwearingen SA226-T · West Chicago, ILthe checklist not followed and the directional control not maintained by the pilot. A contributing factor was the left propeller’s start locks being engaged.NTSB CHI01LA202Accident · No injuriesLimited investigationFinal reportCessna 172N · West Chicago, ILThe instructor pilot's inadequate recovery from the bounced landing and inadequate supervision of the dual students alignment with the runway. A factor was the student pilot not maintaining proper alignment with the runway during landing.NTSB CHI01FA165Accident · Serious injuriesField investigationFinal reportVanderBeek Christen Eagle II · Plainfield, ILthe improper in-flight planning/decision and the aircraft control not maintained by the pilot. The thunderstorm outflow was a contributing factor.NTSB CHI01LA048Accident · Minor injuriesLimited investigationFinal reportSocata TBM 700 · Harrisburg, ILThe pilot not attaining the proper glidepath on the instrument approach. The pilot's decision not to fly to an alternate airport and his decision to continue the approach in weather conditions below the published minimums were contributing factors.NTSB CHI01FA043Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Danville, ILThe pilot's failure to maintain altitude/clearance during the instrument approach. Factors were the low ceilings, the pilot's failure to maintain proper alignment and glidepath during the approach, his lack of recent instrument experience, and his failure to…NTSB CHI01LA007Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Highland, ILthe designated examiner not maintaining clearance from the bank/dike. Factors were the designated examiner's delayed remedial action and the bank/dike.NTSB CHI00LA250Accident · Serious injuriesLimited investigationFinal reportBell 206B · Marengo, ILthe simulated autorotation performed by the pilot at too low an altitude and airspeed.NTSB CHI00FA186Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Capron, ILThe pilot attempting an aerobatic maneuver at a low altitude and the pilot not maintaining clearance from the terrain. A factor to the accident was the pilot disregarding the federal aviation regulations concerning the minimum altitudes required for aerobatic…NTSB CHI00LA093Accident · Serious injuriesLimited investigationFinal reportLockwood Eagle II · Marengo, ILThe pilot's failure to maintain aircraft control.NTSB CHI99LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · Rockford, ILthe failure of the pilot to maintain flying speed and ground clearance while on a night circling approach. Factors were existing icing conditions and the airframe and windshield icing.NTSB CHI99LA033Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B2B · Salem, ILThe simulated emergency procedure by the pilot-in-command. Additional causes were the directional control not obtained/maintained by the pilot-in-command and the inadequate supervision by the Federal Aviation Administration (FAA) Inspector. A contributing…NTSB CHI98LA192Accident · No injuriesLimited investigationFinal reportGrumman G164 · Somonauk, ILthe pilot's misjudgment of distance. Factors were wind gusts and crops.NTSB CHI98LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Waukegan, ILthe pilot's not identifying unsuitable terrain (snowbank) in the landing area, and his not selecting the proper touchdown point. A factor was the snowbank.NTSB CHI98GA025Accident · 2 fatalFinal reportAerospatiale AS350B · Frankfort, ILthe pilot in command misjudged the clearance with the terrain during a dark night maneuvering approach to a runway. A related factor was the dark night conditions.NTSB CHI97LA211Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Springfield, ILfailure of the pilot to maintain safe altitude/clearance from the terrain. Factors relating to this accident were: the hazy weather condition, the resultant difficulty in keeping the other airplane in sight, and the pilot's diverted attention, while looking…NTSB CHI96LA214Accident · No injuriesLimited investigationFinal reportSchweizer 2-33 · Union, ILThe pilots misjudgment of the altitude and distance to the runway.NTSB CHI96FA211Accident · 1 fatalField investigationFinal reportMcDonnell Douglas F/A-18C · Bethalto, ILthe pilot's failure to follow the preflight crew briefing and attain a proper altitude during an aerobatic maneuver. Factors in the accident were: the pilot's previous experience of flying similar airshow routines in a different airplane with substantially…NTSB CHI96LA188Accident · 1 fatalLimited investigationFinal reportGray Miniplane DSA-1-G · Astoria, ILthe pilot's failure to maintain clearance with the terrain while performing an aerobatic maneuver.NTSB CHI95FA301Accident · 1 fatalField investigationFinal reportKiesel Easy Varieze · Dwight, ILinadequate preflight planning by the pilot. A factor associated with this accident was the pilot did not perform an aborted takeoff is sufficient time to safely stop.NTSB NYC95FA105Accident · 2 fatalField investigationFinal reportBeech BE60 · Olney, ILThe pilot's improper IFR procedures by descending below the minimum descent altitude and not executing the published missed approach procedures. A factor in thE accident was the low overcast and fog conditions.NTSB CHI95FA123Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Schaumburg, ILThe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his attempt to perform an apparent aerobatic maneuver at an altitude that was insufficient to assure recovery.NTSB CHI95LA343Accident · 1 fatalLimited investigationFinal reportBeech C23 · Waukegan, ILThe pilot's VFR flight into instrument meteorolical conditions.NTSB CHI95FA012Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Winfield, ILCollision with the ground for an undetermined reason. The pilot's psychological condition was a probable factor.NTSB CHI94LA230Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kankakee, ILThe pilot's poor preflight planning preparation by the improper loading of the airplane.NTSB CHI94LA151Accident · No injuriesLimited investigationFinal reportAeronca 11 AC · Carmi, ILpoor preflight planning/preparation. Factors associated with the accident were the high vegetation (grass) and the ditch.NTSB CHI93LA377Accident · No injuriesLimited investigationFinal reportLanceair 235M · Rockford, ILThe pilot-in-command delayed aborting the landing. Factors were a wet runway and the pilot-in-command's lack of recent experience in this type of airplane.NTSB CHI93LA347Accident · 1 fatalLimited investigationFinal reportWells Pitts S-2-S · Bloomington, ILthe pilot in command continued the aerobatic maneuver too long to effect a safe level off.NTSB CHI93DEE03Accident · Serious injuriesFinal reportMaxair MU532 · Fox Lake, ILthe failure of the pilot to maintain the necessary altitude above the terrain.NTSB CHI92LA212Accident · No injuriesLimited investigationFinal reportCessna 172H · Chenoa, ILInadequate preflight planning and preparation on the part of the pilot. Factors associated with this accident were a lack of recent experience in the type of operation the pilot was undertaking, a proper climb rate not obtained by the pilot and remedial…NTSB CHI92LA154Accident · 1 fatalLimited investigationFinal reportCessna 150H · Robinson, ILPoor judgement by the pilot in intentionally proceeding to the airport in instrument meteorological conditions. The weather conditions were a factor.NTSB CHI91DEV02Accident · No injuriesFinal reportO'Connell Stits SA-3B · Casey, ILThe pilot's failure to maintain a proper rate of climb after takeoff. A factor in the accident was the pilot's lack of experience in model.NTSB CHI91LA205Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Savoy, ILThe pilot's failure to maintain tail rotor clearance from the ground. A related factor is the pilot's lack of total experience in helicopters.NTSB CHI91DEE01Accident · 1 fatalFinal reportPitts Special S1-S · Dekalb, ILThe pilot's attempt to perform aerobatic maneuvers at low altitude.NTSB CHI90DEV02Accident · Serious injuriesFinal reportPiper PA-25-150 · Sullivan, ILThe pilot-in-command's failure to maintain adequate terrain clearance during a turn at low altitude, resulting in ground collision. Contributing to the severity of the pilot's injury was his failure to use the installed shoulder harness.NTSB CHI89DEV06Accident · No injuriesFinal reportHughes 269C · Millersville, ILLoss of rotor RPM for an undetermined reason during a turn to reverse direction while applying agricultural chemicals.NTSB CHI89LA068Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Chicago, ILThe pilot's failure to compensate for the crosswind condition which existed during the landing. Contributing to the accident was the gusty, crosswind which existed and the failure of the aircraft manufacturer to provide crosswind performance data for the…NTSB CHI89LA052Accident · No injuriesLimited investigationFinal reportCessna 172M · Quincy, ILThe pilot's failure to achieve a proper touchdown point and to maintain adequate visual lookout during the landing.NTSB CHI88LA228Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Fox Lake, ILThe plt had just completed a course at the Lake acft factory school, but had not yet obtained a seaplane rating. After he flew home, he landed on local lakes. He reported that drg a landing on calm water, he expected to hear a 'slush sound' as the hull…NTSB CHI88LA113Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Nauvoo, ILThe pilot was making a 'fast low approach' to a private airstrip near his home when he realized he was coming too close to a row of trees. The pilot stated he became so preoccupied with trying not to hit the trees that he did not notice how close the aircraft…