NTSB investigations, 2022, ID
9 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
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 year(c.\"eventDate\") = 2022
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") = 2022 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 WPR22LA319Accident · No injuriesClass 4 · LimitedFinal reportCessna 305C (0-1E) · Rexburg, IDThe pilot's failure to maintain airplane control during the landing roll on a wet airstrip.NTSB WPR22LA248Accident · No injuriesClass 3 · LimitedFinal reportCessna T210R · Stanley, IDThe pilot’s failure to provide adequate braking during a tailwind landing, which resulted in a runway excursion.NTSB WPR22LA222Accident · Minor injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Hailey, IDThe pilot's failure to maintain directional control of the airplane during landing, which resulted in a ground loop.NTSB WPR22LA217Accident · No injuriesClass 3 · LimitedFinal reportCub Crafters CC19-215 · McCall, IDA loss of directional control during the landing roll due to a fractured brake line fitting on the brake caliper.NTSB WPR22LA155Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Boise, IDThe pilot receiving instructions failure to maintain directional control during landing. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB WPR22LA139Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1B · Swan Valley, IDThe pilot’s failure to maintain airplane control during the landing roll on a snow-covered runway surface.NTSB WPR22LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · Nampa, IDThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB WPR22LA104Accident · No injuriesClass 4 · LimitedFinal reportChristopher P Gage Shortfield Explorer · Coeur d'Alene, IDThe pilot’s improper landing flare which, resulted in a bounced landing, loss of airplane control and subsequent nose over.NTSB WPR22LA103Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-65 · Murphy, IDThe pilot's failure to maintain directional control during the landing roll.