NTSB investigations, IL
4 cases where NTSB found Planning/preparation, general.
Cases per year
| 2009 | 1 |
|---|---|
| 2011 | 1 |
| 2013 | 1 |
| 2016 | 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\", '02061000'))
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", '02061000')) 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 CEN16LA284Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH 13H/M74A · Minonk, ILFailure of the truck driver to ensure that he had adequate clearance to pass under the helicopter and the failure of the loader to park in a safer area for reloading operations.NTSB CEN13LA425Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Steward, ILThe pilot's failure to maintain clearance from the guy wires during an aerial application maneuver. Contributing to the accident was the pilot's failure to identify potential obstructions in the area before beginning low-altitude maneuvers.NTSB CEN11CA400Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Charleston, ILThe pilot's selection of unsuitable terrain to take off after making a precautionary landing.NTSB CEN09CA303Accident · No injuriesData collectionFinal reportAirborne XT912 · Newark, ILThe pilot's inadequate preflight preparation, which led to the inability to accelerate to takeoff speed after encountering wet and soft runway conditions.