NTSB investigations, 2023, IL

7 cases where the sequence of events included Unknown or undetermined.

Cases per year

20122026
NTSB investigations, 2023, IL per year, 2012–2026: 24 cases
20121
20152
20161
20171
20204
20211
20222
20237
20242
20263

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\") = 2023
    AND c.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 CEN23LA403Accident · No injuriesClass 3 · LimitedFinal reportIsrael Aircraft Industries 1125 Westwind Astra · Wheeling, ILA loss of braking effectiveness during landing for reasons that could not be determined, which resulted in a runway excursion.Aug 21, 2023 · N39TT · Substantial damageNTSB CEN23LA372Accident · No injuriesClass 3 · LimitedFinal reportPietenpol Aircamper · Hanover, ILThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall during an attempted forced landing at low altitude. Contributing to the accident was the loss of engine power for undetermined reasons.Aug 20, 2023 · N929DH · Substantial damageNTSB CEN23FA340Accident · 1 fatalClass 3 · FieldFinal reportRichards Heavylift Helo UH-1H · Oakdale, ILAn in-flight loss of control for undetermined reasons.Jul 31, 2023 · N567VF · Substantial damageNTSB CEN23LA306Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Pocahontas, ILA reported loss of engine power for undetermined reasons.Jul 14, 2023 · N62RK · Substantial damageNTSB CEN23LA295Accident · No injuriesClass 3 · LimitedFinal reportBell UH-1H · Woodlawn, ILThe separation of the tail boom from the fuselage for reasons that could not be determined.Jul 11, 2023 · N900VF · Substantial damageNTSB CEN23LA145Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Lincoln, ILA total loss of engine power during an approach for landing for undetermined reasons.Mar 30, 2023 · N56793 · Substantial damageNTSB CEN23LA106Accident · No injuriesClass 3 · LimitedFinal reportJabiru USA Sport J250-SP · Cortland, ILA total loss of engine power for reasons that could not be determined.Feb 11, 2023 · N592J · Substantial damage