NTSB investigations, 2022, ID
6 cases where the sequence of events included Runway excursion.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 7 |
| 2010 | 12 |
| 2011 | 3 |
| 2012 | 8 |
| 2013 | 3 |
| 2014 | 5 |
| 2015 | 4 |
| 2016 | 2 |
| 2017 | 9 |
| 2018 | 8 |
| 2019 | 7 |
| 2020 | 1 |
| 2021 | 5 |
| 2022 | 6 |
| 2023 | 2 |
| 2024 | 4 |
| 2025 | 1 |
| 2026 | 2 |
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\" = '300' 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" = '300' 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 WPR22LA324Accident · No injuriesClass 3 · LimitedFinal reportChampion 7GCBA · Athol, IDThe failure of the right brake due to a disconnected master cylinder piston rod, which led to the departure of the airplane from the runway surface. Contributing to the accident was the mechanic’s failure to adequately inspect the connection between the…NTSB WPR22LA315Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Donnelly, IDThe pilot’s improper decision to takeoff from a wet grass runway which did not allow for adequate braking traction when the pilot aborted the takeoff, which resulted in a runway excursion.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 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 WPR22LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · Nampa, IDThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB WPR22LA103Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-65 · Murphy, IDThe pilot's failure to maintain directional control during the landing roll.