NTSB investigations, ID
33 cases where NTSB found Runway/land/takeoff/taxi surface.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 1 |
| 2010 | 6 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 3 |
| 2018 | 1 |
| 2019 | 3 |
| 2022 | 3 |
| 2023 | 1 |
| 2024 | 4 |
| 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 c.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030230'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '030230')) 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 WPR26LA184Accident · No injuriesClass 4 · LimitedFinal reportVans RV-6A · Kooskia, IDThe pilot’s collision with a hole in the runway surface during the landing roll, which resulted in a nose over.NTSB WPR25LA035Accident · No injuriesClass 4 · LimitedFinal reportCessna 182E · Priest River, IDThe pilot's failure to attain a proper touchdown point and his inability to stop the landing roll on a wet gras runway, which resulted in a collision with a tree.NTSB WPR25LA036Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Owinza, IDThe pilot’s failure to maintain clearance from the water during a low pass over a lake.NTSB WPR24LA098Accident · No injuriesClass 4 · LimitedFinal reportCessna 182A · Weippe, IDThe pilot’s failure to secure the oil filler cap during the preflight inspection, which resulted in a precautionary landing on the soft surface and subsequent nose over.NTSB WPR24LA079Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Featherville, IDThe pilot's failure to maintain directional control during taxi, which resulted in a runway excursion and impact with terrain.NTSB WPR23LA246Accident · No injuriesClass 4 · LimitedFinal reportBlack Sheep CCX-1865 · Big Creek Ranger Station, IDThe pilot’s failure to identify the wet landing surface and his subsequent inability to maintain directional control and stop during landing on the unimproved grass runway, which resulted in a runway excursion and unintentional ground loop.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 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 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 WPR20CA043Accident · No injuriesData collectionFinal reportJohn Sample Bearhawk · Nampa, IDThe pilot's selection of unsuitable terrain for landing, which resulted in impact with a knoll and a subsequent ground-loop.NTSB GAA20CA011Accident · No injuriesData collectionFinal reportChampion 8GCBC · Henrys Lake, IDThe pilot's decision to land on unsuitable terrain, which resulted in a nose-over.NTSB GAA20CA004Accident · No injuriesData collectionFinal reportReed Mike Smiths Super CUB · Triangle, IDThe pilot's excessive use of brakes during the landing roll, which resulted in a nose-over.NTSB GAA18CA106Accident · No injuriesData collectionFinal reportCessna A185 · Lowman, IDThe pilot’s selection of unsuitable terrain for takeoff, which resulted in a loss of directional control.NTSB GAA17CA076Accident · No injuriesData collectionFinal reportCessna 172 · Salmon, IDThe airplane's encounter with a depression in a dirt runway during takeoff, which resulted in a tail strike.NTSB GAA16CA524Accident · Minor injuriesData collectionFinal reportVan Hoomissen Gerald J Murphy Elite · Nordman, IDThe floatplane pilot's improper landing flare during landing on choppy water with a tailwind, which resulted in a nose-over. Contributing to the accident was the pilot's failure to determine the wind direction before landing.NTSB GAA16CA298Accident · No injuriesData collectionFinal reportCessna 182 · Stanley, IDThe pilot's failure to attain an adequate climb gradient, which resulted in a collision with a tree and subsequent substantial damage to the left wing and aileron.NTSB GAA16CA015Accident · No injuriesData collectionFinal reportMaule M 7-260C · Grace, IDThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over.NTSB WPR15CA017Accident · No injuriesData collectionFinal reportIndus T-211 Thorpedo · Mountain Home, IDThe pilot's failure to maintain clearance with a parked truck while taxiing for takeoff.NTSB WPR13CA271Accident · No injuriesData collectionFinal reportCessna T210N · Salmon, IDThe pilot's decision to land on a wet grass airstrip, which resulted in a main landing gear collapse after a collision with rough terrain.NTSB WPR12CA148Accident · No injuriesData collectionFinal reportStinson 108-1 · Coolin, IDThe pilot’s decision to land on a snow-covered runway.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 WPR12CA060Accident · No injuriesData collectionFinal reportCessna 182C · Lowman, IDThe pilot's misjudgment of the runway surface firmness, which resulted in a nose-over during the landing roll.NTSB WPR12CA041Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Ashton, IDThe student pilot’s poor decision-making when he decided to land on a snowy grass airstrip, which resulted in an encounter with deep snow during the landing roll and a subsequent nose-over.NTSB WPR11CA088Accident · No injuriesData collectionFinal reportFerkin Kitfox IV · Homedale, IDThe pilot's inadequate compensation for the snow-covered terrain during the takeoff ground roll, which resulted in a nose-over.NTSB WPR11CA034Accident · No injuriesData collectionFinal reportCessna U206B · Cascade, IDThe pilot's failure to maintain clearance from terrain during a turn onto the final approach leg of the traffic pattern.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 WPR10CA201Accident · Minor injuriesData collectionFinal reportCessna 150D · Galena, IDThe pilot's encounter with soft, snow-covered terrain while executing a precautionary landing.NTSB WPR10LA155Accident · No injuriesLimited investigationFinal reportKeller FK1 Stol · Dixie, IDThe failure of the experimental FK1 pilot to maintain clearance from a parked airplane while landing.NTSB WPR09CA346Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Sulphur Creek, IDThe pilot's failure to maintain directional control during the landing roll.NTSB WPR09CA066Accident · No injuriesData collectionFinal reportPiper PA-46-350P · Idaho Falls, IDThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident were the icy runway conditions and a snow bank.NTSB SEA08CA154Accident · Minor injuriesData collectionFinal reportUetz, Walter Spitfire II · Kamiah, IDThe total loss of engine power for undetermined reasons, and the pilot's failure maintain the proper descent rate during the last part of his approach to a forced landing in an open hayfield.