NTSB investigations, 2010, IL
6 cases where the sequence of events included Loss of control on ground.
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 6 |
| 2010 | 6 |
| 2011 | 6 |
| 2012 | 5 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 4 |
| 2017 | 5 |
| 2018 | 5 |
| 2019 | 5 |
| 2020 | 5 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 3 |
| 2024 | 4 |
| 2025 | 2 |
| 2026 | 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 year(c.\"eventDate\") = 2010
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\" = '230' 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 year(c."eventDate") = 2010 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" = '230' 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 CEN11CA131Accident · No injuriesData collectionFinal reportCessna 152 · Bolingbrook, ILThe student pilot's failure to maintain directional control during landing.NTSB CEN10LA506Accident · No injuriesLimited investigationFinal reportAshcraft DR107 · Aurora, ILThe low cycle fatigue failure of the tail wheel spring during landing.NTSB CEN10CA452Accident · No injuriesData collectionFinal reportMaule MX-7-180A · Pittsfield, ILThe pilot's loss of directional control during a precautionary off-field landing that he performed after encountering deteriorating weather conditions.NTSB CEN10CA215Accident · No injuriesData collectionFinal reportMurray Starlite · Shelbyville, ILThe corrosion of the left landing gear rotor and brake, which resulted in the loss of directional control during the landing rollout, and the pilot's inadequate preflight inspection.NTSB CEN10CA221Accident · No injuriesData collectionFinal reportPiper PA-24-250 · West Chicago, ILThe pilot's failure to maintain directional control of the airplane during landing.NTSB CEN10CA095Accident · No injuriesData collectionFinal reportCessna 140A · Urbana, ILThe pilot's failure to maintain directional control of the airplane during the crosswind landing.