NTSB investigations, 2012, ID
12 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\") = 2012
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") = 2012 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 WPR12CA336Accident · No injuriesData collectionFinal reportPiper PA28-150 · Yellow Pine, IDThe pilot's failure to attain and maintain an appropriate glide path, failure to perform a go-around, and failure to maintain directional control during the landing roll.NTSB WPR12CA322Accident · No injuriesData collectionFinal reportCubCrafters CC 11-160 · Stanley, IDThe pilot’s excessive use of the brakes during the landing roll.NTSB WPR12LA325Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Gooding, IDThe pilot’s failure to maintain airplane control after encountering an unexpected wind gust during landing.NTSB WPR12CA355Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Rexburg, IDThe student pilot's failure to maintain directional control and subsequent excessive braking during the landing roll with a tailwind, which resulted in a noseover.NTSB WPR12LA289Accident · No injuriesLimited investigationFinal reportCox PA 18 · Soldier Bar, IDThe pilot’s failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and the airplane nosing over.NTSB WPR12CA308Accident · No injuriesData collectionFinal reportCessna 180A · Cascade, IDThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR12CA202Accident · No injuriesData collectionFinal reportPiper PA-12 · Idaho Falls, IDThe pilot’s improper landing flare, inadequate recovery from a bounced landing, and subsequent failure to maintain directional control.NTSB WPR12CA194Accident · No injuriesData collectionFinal reportCessna 207A · Grangeville, IDThe pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a loss of airplane control.NTSB WPR12CA170Accident · No injuriesData collectionFinal reportCessna 180F · McCall, IDThe pilot did not maintain directional control during the landing roll.NTSB WPR12CA137Accident · No injuriesData collectionFinal reportCessna 182 · Caldwell, IDThe pilot did not properly secure the airplane before starting the engine by manually rotating the propeller, which resulted in the inadvertent movement of the airplane.NTSB WPR12CA112Accident · No injuriesData collectionFinal reportRockwell International S-2R · Yellow Pine, IDThe pilot did not maintain directional control while landing on a snow-contaminated runway.NTSB WPR12CA086Accident · No injuriesData collectionFinal reportCessna 180 · Cascade, IDThe pilot's inadequate compensation for a wind gust during landing, which resulted in a runway excursion. Contributing to the accident was a windsock partially sheltered by trees that provided inaccurate wind information.