NTSB investigations, IL
10 cases where the sequence of events included Aircraft maintenance event.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2014 | 1 |
| 2016 | 1 |
| 2022 | 2 |
| 2024 | 1 |
Where
Open the mapLatest 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '040' 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.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '040' 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
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 CEN25FA056Accident · Serious injuriesClass 3 · FieldFinal reportZenith Zodiac CH601 · Columbia, ILThe pilot’s failure to secure the engine oil filter following maintenance, which resulted in oil starvation, a total loss of engine power, and impact with terrain.NTSB CEN23LA025Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Greenville, ILThe mechanic’s failure to inspect and clean the entire fuel nozzle assembly in accordance with the engine maintenance manual, which resulted in fuel starvation and a partial loss of engine power, an autorotation, and a hard landing.NTSB CEN22FA298Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24-250 · St. Jacob, ILThe inadequate maintenance of the airplane fuel system that resulted in fuel exhaustion and a loss of engine power.NTSB CEN16LA387Accident · Minor injuriesLimited investigationFinal reportPahnke Vernon A Vans RV 9A · Newark, ILThe pilot's failure to properly assemble the fuel pump, which resulted in the loss of fuel pressure and the subsequent partial loss of engine power.NTSB CEN15IA076Incident · No injuriesIncident investigationFinal reportCessna 182S · Springfield, ILThe improper installation of a doubler patch, which prevented the right flap from actuating and moving properly and led to the subsequent interference with the aileron.NTSB CEN13LA103Accident · Serious injuriesLimited investigationFinal reportAuman JL T-51 · Dekalb, ILThe improper engine overhaul by the airplane kit manufacturer, which resulted in a catastrophic engine failure.NTSB CEN12LA577Accident · No injuriesLimited investigationFinal reportJones Kitfox III · Rockford, ILThe pilot's improper installation of a spark plug, which led to a partial loss of engine power after takeoff and the resultant forced landing.NTSB CEN11IA369Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145 · Chicago, ILThe overheat and failure the brake during landing due to oxidation of the brake rotors, which went undetected by maintenance personnel. Contributing to the accident was maintenance personnel’s lack of familiarity with detailed brake oxidation inspection…NTSB CEN09IA456Incident · No injuriesIncident investigationFinal reportCessna 172R · West Chicago, ILA partial loss of engine power due to the detachment of the throttle control cable from the throttle assembly during a landing approach. Contributing to the accident was the lack of a redundant means to preclude the detachment of the cable from the throttle…NTSB CHI08IA200Incident · No injuriesIncident investigationFinal reportEclipse EA500 · Rockford, ILThe improper installation of the forward edge of the left-hand wing-to-body panel, causing the fairing to separate from the airplane during an in-flight encounter with light turbulence. Contributing to the event was the use of small-head screws and grommets…