NTSB investigations, 2010, ID
11 cases where the sequence of events included Loss of control on ground.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 6 |
| 2010 | 11 |
| 2011 | 4 |
| 2012 | 12 |
| 2013 | 6 |
| 2014 | 6 |
| 2015 | 7 |
| 2016 | 7 |
| 2017 | 10 |
| 2018 | 9 |
| 2019 | 12 |
| 2020 | 7 |
| 2021 | 13 |
| 2022 | 9 |
| 2023 | 12 |
| 2024 | 12 |
| 2025 | 6 |
| 2026 | 3 |
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\" = 'ID' 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" = 'ID' 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 WPR10LA457Accident · No injuriesLimited investigationFinal reportMyers THORP-18 · Jerome, IDThe pilot's failure to maintain directional control during the landing roll in gusty crosswinds.NTSB WPR10CA425Accident · No injuriesData collectionFinal reportChris W Kleen RV-6 · Coeur D'Alene, IDThe pilot’s inadequate compensation for the crosswind that resulted in a loss of directional control.NTSB WPR10LA472Accident · No injuriesLimited investigationFinal reportCessna T188C · Craigmont, IDThe pilot's failure to maintain directional control during the landing roll.NTSB WPR10CA444Accident · Minor injuriesData collectionFinal reportSchweizer 164B · Murtaugh, IDThe pilot’s inadequate compensation for the wind and failure to maintain directional control during the takeoff roll.NTSB WPR10LA421Accident · No injuriesLimited investigationFinal reportCessna U206 · Grangeville, IDThe pilot’s decision to fly with a known defective nosewheel assembly, which resulted in a loss of directional control and nose-over on landing after the assembly shifted out of alignment during the flight.NTSB WPR10CA378Accident · No injuriesData collectionFinal reportPorter James Grant Superior CUB · Caldwell, IDThe pilot’s failure to maintain directional control during landing.NTSB WPR10CA368Accident · No injuriesData collectionFinal reportCessna A185F · Coeur d'Alene, IDThe pilot's inadequate compensation for a wind gust during the landing roll.NTSB WPR10CA301Accident · No injuriesData collectionFinal reportCessna 180 · Big Creek, IDThe pilot’s failure to maintain directional control while taxiing at an unfamiliar airstrip.NTSB WPR10CA291Accident · No injuriesData collectionFinal reportCessna 188B · Blackfoot, IDA loss of directional control during the landing roll as a result of a worn tail wheel locking mechanism.NTSB WPR10LA241Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Caldwell, IDA loss of directional control and runway excursion for undetermined reasons.NTSB WPR10LA160Accident · Serious injuriesLimited investigationFinal reportMigas RV9-A · Twin Falls, IDThe pilot's loss of directional control during landing roll for an undetermined reason.