NTSB investigations, IL
5 cases where the sequence of events included Ground handling event.
Cases per year
| 2010 | 1 |
|---|---|
| 2017 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2023 | 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\" = '080' 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" = '080' 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 CEN23FA359Accident · 1 fatalClass 3 · FieldFinal reportVans RV14 · Virden, ILThe pilot/builder’s improper configuration of the canopy latch micro switch, which incorrectly signaled a closed canopy before flight that resulted in an inflight opening of the airplane’s canopy, an upset of the airplane, and a loss of control from which the…NTSB 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…NTSB DCA19CA223Accident · No injuriesClass 4 · Data collectionFinal reportBombardier CL 600 2C10 · Chicago OHare, ILthe tug driver's inability to maintain visual contact with the wing walkers and lack of situational awareness during pushback.NTSB DCA18CA001Accident · No injuriesData collectionFinal reportBoeing 737 7H4 · Chicago, ILthe mechanical failure of the tugs fuel governor, which made it difficult for the ramp agent to stop the tug. Contributing to the accident was the lack of guidance on how ground personnel were to handle vehicle malfunctions.NTSB CEN10LA142Accident · No injuriesLimited investigationFinal reportBombardier BD-100-1A10 · Wheeling, ILThe deicing vehicle operator's not adhering to company procedures and not maintaining clearance between the vehicle's boom and the airplane's empennage during the airplane's deicing operation.