NTSB investigations, IL

5 cases where NTSB found Use of equip/info, general.

Cases per year

20122026
NTSB investigations, IL per year, 2012–2026: 5 cases
20121
20181
20201
20211
20251

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\", '02063000'))
  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 CEN25LA262Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Champaign/Urbana, ILThe ground vehicle operator’s failure to maintain clearance from the airplane.Jun 27, 2025 · N320EB · Substantial damageNTSB CEN21LA212Accident · No injuriesClass 4 · LimitedFinal reportRichards Heavylift Helo UH-1H · Norris City, ILThe pilot’s improper positioning of the helicopter on the landing pad, and his failure to monitor and control the helicopter as fuel and chemical product were loaded, which led to the helicopter tipping and sliding off the landing pad, and subsequently…May 10, 2021 · N567VF · Substantial damageNTSB CEN20CA313Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Dakota, ILThe pilot’s failure to maintain main rotor clearance from a ground obstacle during a landing.Jul 27, 2020 · N570WH · Substantial damageNTSB GAA18CA409Accident · No injuriesData collectionFinal reportCessna 208 · Chicago, ILThe service truck driver’s evasive maneuver to avoid a bag cart tug, which resulted in the truck impacting a parked airplane.Jul 4, 2018 · N208EE · Substantial damageNTSB CEN12FA534Accident · 1 fatalField investigationFinal reportBeech G18 - S · Taylorville, ILThe pilot's failure to maintain adequate airspeed and use the appropriate flaps setting during sport-parachuting operations, which resulted in an aerodynamic stall/spin and a subsequent loss of control. Contributing to the accident was the pilot’s failure to…Aug 11, 2012 · N697Q · Substantial damage