NTSB investigations, 1985, IL

5 cases where the first occurrence was “In flight collision with terrain/water”.

Cases per year

19822026
NTSB investigations, 1985, IL per year, 1982–2026: 73 cases
19821
19838
19843
19855
19864
19884
19893
19902
19912
19922
19933
19943
19954
19963
19973
19982
19991
20006
20014
20022
20032
20041
20051
20063
20071

Latest 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 year(c.\"eventDate\") = 1985
    AND 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.

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…Jul 5, 1985 · N9909P · Substantial damageNTSB 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…May 15, 1985 · N7485F · DestroyedNTSB 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…Mar 8, 1985 · N4332Q · Substantial damageNTSB 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…Feb 11, 1985 · N978Z · No damageNTSB 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…Jan 9, 1985 · N7513Q · Substantial damage