NTSB investigations, IL
4 cases where NTSB found Engine (turbine/turboprop), general.
Cases per year
| 2010 | 1 |
|---|---|
| 2016 | 1 |
| 2018 | 1 |
| 2023 | 1 |
Where
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\", '01057200'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01057200')) 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 CEN23LA317Accident · No injuriesClass 3 · LimitedFinal reportGrumman G-164A · Patoka, ILA partial loss of engine power due to the failure of two compressor turbine blades as a result of the engine operating near or above the engine’s operating limits for an undetermined amount of time beyond the recommended engine’s TBO limit, which led to…NTSB CEN18FA259Accident · Serious injuriesField investigationFinal reportEurocopter Deutschland EC135 P1 · Chicago, ILThe pilot's inadvertent disabling of the No. 1 and No. 2 engines' electronic engine control systems, which resulted in engine and rotor overspeed conditions, a subsequent autorotation, and a hard landing. Contributing to the accident were the pilot's…NTSB CEN16LA335Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Cave-In-Rock, ILA total loss of engine power due to air entering the fuel system for reasons that could not be determined based on available information. Contributing to the accident was the pilot’s inability to restart the engine due to the check valve assembly design.NTSB CEN10LA437Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-602 · Yates City, ILThe loss of engine power for undetermined reasons.