NTSB investigations, IL

5 cases where NTSB found Wet/muddy terrain.

Cases per year

20092026
NTSB investigations, IL per year, 2009–2026: 5 cases
20091
20101
20141
20191
20201

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 c.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03021035'))
  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 CEN20CA182Accident · No injuriesClass 4 · Data collectionFinal reportCessna 120 · Chatham, ILThe pilot's decision to continue flight in instrument meteorological conditions in an airplane not equipped for instrument flight, which forced her to perform a precautionary landing to a muddy field resulting in the airplane nosing over.May 15, 2020 · N120MZ · Substantial damageNTSB GAA19CA279Accident · No injuriesData collectionFinal reportGuimbal Cabri · St. Louis, ILThe flight instructor's improper emergency procedure instruction to the student pilot, which resulted in the student improperly using the throttle to correct the loss of yaw control, which resulted in ground impact and a dynamic rollover.May 23, 2019 · N369PA · Substantial damageNTSB CEN15LA028Accident · 1 fatalLimited investigationFinal reportHuebbe Sonex HB · Plainview, ILThe loss of engine power during cruise flight due to a fatigue fracture of the crankshaft, which resulted in a forced landing on unsuitable terrain.Oct 26, 2014 · N244HB · Substantial damageNTSB CEN10CA252Accident · No injuriesData collectionFinal reportPiper J3C-65 · Sandwich, ILThe pilot's delay in using carburetor heat resulting in a partial loss of engine power due to carburetor icing.May 15, 2010 · N22394 · Substantial damageNTSB CEN09LA285Accident · Serious injuriesLimited investigationFinal reportRockwell International 112A · Metropolis, ILA total loss of engine power for undetermined reasons.May 10, 2009 · N1348J · Substantial damage