NTSB investigations, ID
15 cases where the defining event was Runway excursion.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 3 |
| 2012 | 2 |
| 2014 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2021 | 2 |
| 2022 | 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 c.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '300')
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 c."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '300') 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 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 WPR21LA304Accident · No injuriesClass 4 · LimitedFinal reportCessna 182C · Coeur D Alene, IDThe pilot’s failure to attain a proper touchdown point due to excessive airspeed, which resulted in a runway excursion and collision with an object near the end of the runway.NTSB WPR21LA131Accident · No injuriesClass 3 · LimitedFinal reportCessna T210M · Leadore, IDThe pilot’s failure to attain the proper touchdown point on a graveled surfaced runway with insufficient landing performance and subsequent loss of control during the landing roll.NTSB GAA19CA325Accident · No injuriesData collectionFinal reportAviat A1 · Pingree, IDThe pilot's improper rudder application during landing on a dirt airstrip, which resulted in a loss of directional control, runway excursion, and subsequent nose-overNTSB WPR18LA275Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32RT · Malad, IDThe pilot’s failure to identify that he was not utilizing the full runway for takeoff, and his delayed decision to abort the takeoff, which resulted in a runway overrun.NTSB GAA17CA500Accident · No injuriesData collectionFinal reportBeech C23 · Rexburg, IDThe pilot's delayed decision to land the airplane with insufficient runway remaining after realizing the airplane wasn't climbing.NTSB GAA17CA497Accident · No injuriesData collectionFinal reportBeech A36 · Loman, IDThe pilot’s inadequate compensation for a tailwind, which resulted in a runway overrun.NTSB WPR14CA294Accident · Minor injuriesData collectionFinal reportThrush S2RHG T65 · Parma, IDThe pilot's decision to take off with a tailwind, which resulted in the airplane not attaining sufficient airspeed for takeoff.NTSB WPR14CA178Accident · Minor injuriesData collectionFinal reportElemdorf 1002 · Rexburg, IDThe pilot's loss of directional control and early rotation during takeoff. Contributing to the accident was the failure of the pilots to exercise adequate communication techniques.NTSB WPR12CA360Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Coolin, IDThe pilot’s failure to attain a touchdown point sufficient to stop the airplane within the length of the runway.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 WPR10CA405Accident · No injuriesData collectionFinal reportCessna T182T · McCall, IDThe pilot's delay in making the decision to abort the takeoff. Contributing to the accident was the condition of the takeoff surface, and the high density altitude.NTSB WPR10CA346Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Yellow Pine, IDThe pilot's delayed decision to abort the takeoff. Contributing to the accident was the wet condition of the grass runway.NTSB WPR10CA329Accident · No injuriesData collectionFinal reportCornett Steven M Glastar · Smiley Creek, IDThe pilot's decision to not use all available runway length and his delay in aborting the takeoff, which resulted in the airplane sliding off the end of the grass strip and colliding with a ditch.NTSB WPR09CA332Accident · Minor injuriesData collectionFinal reportCessna 182M · Wilson Bar, IDThe pilot’s misjudged approach that led to a long landing and his failure to execute a go-around when he realized that he overshot his intended point of landing.