NTSB investigations, 2017, GA
9 cases where the sequence of events included Runway excursion.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 5 |
| 2010 | 8 |
| 2011 | 4 |
| 2012 | 8 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 7 |
| 2016 | 8 |
| 2017 | 9 |
| 2018 | 5 |
| 2019 | 4 |
| 2020 | 9 |
| 2021 | 10 |
| 2022 | 5 |
| 2023 | 5 |
| 2024 | 8 |
| 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\") = 2017
AND c.\"eventStateOrRegion\" = 'GA' 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") = 2017 AND c."eventStateOrRegion" = 'GA' 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 ERA18LA044Accident · No injuriesLimited investigationFinal reportPiper PA34 · Thomasville, GAA stone becoming lodged in a left main landing gear (MLG) drag link, which resulted in the failure of the left MLG to extend and lock.NTSB GAA18CA011Accident · No injuriesData collectionFinal reportDehavilland DHC 1 · Cedartown, GAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA535Accident · No injuriesData collectionFinal reportMooney M20J · Whitesburg, GAThe pilot’s unstabilized approach while landing with a tailwind and his subsequent failure to go around, which resulted in a hard landing.NTSB ERA17LA324Accident · No injuriesLimited investigationFinal reportCessna 195 · Newman, GAThe improper rigging of the tailwheel assembly, which resulted in a loss of directional control during takeoff. Contributing to accident was the pilot’s decision to operate the airplane despite knowing it required excessive right rudder inputs for it to move…NTSB GAA17CA459Accident · No injuriesData collectionFinal reportRockwell International S 2R · McRae, GAThe pilot’s failure to maintain directional control during the landing roll in tailwind conditions.NTSB GAA17CA428Accident · Minor injuriesData collectionFinal reportPiper L 21B · Cartersville, GAThe pilot’s loss of directional control during the landing roll and subsequent excessive brake application, which resulted in a nose-over.NTSB ERA17LA217Accident · No injuriesLimited investigationFinal reportBarnes Richard B/Howe Michael Vans RV 10 · Blairsville, GAThe pilot’s loss of directional control upon landing.NTSB GAA17CA201Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Atlanta, GAThe pilot’s use of excessive airspeed during the approach, which resulted in a bounced, hard landing and subsequent loss of directional control during an attempted go-around.NTSB GAA17CA115Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Bainbridge, GAThe student pilot's exceedance of the airplane’s critical angle of attack during final approach, which resulted in an aerodynamic stall, and his subsequent loss of directional control after touchdown.