NTSB investigations, ID
32 cases where the sequence of events included Abnormal runway contact.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2010 | 2 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 6 |
| 2017 | 6 |
| 2018 | 3 |
| 2019 | 2 |
| 2021 | 1 |
| 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '090' 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 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" = '090' 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 WPR26LA117Accident · No injuriesClass 4 · LimitedFinal reportCessna T206H · Lewiston, IDThe pilot’s improper landing flare, which resulted in hard, bounced landing and subsequent tail strike.NTSB WPR21LA241Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Moose Creek Ranger Station, IDThe pilot’s improper landing flare which resulted in a bounced hard landing and subsequent nose over.NTSB WPR20CA048Accident · No injuriesData collectionFinal reportPiper PA22 · Caldwell, IDThe student pilot's failure to establish a positive climb rate during an aborted landing, which resulted in abnormal runway contact, a subsequent loss of directional control, runway excursion, and the right main landing gear collapsing.NTSB GAA19CA381Accident · No injuriesData collectionFinal reportCessna 175 · Coeur d'Alene, IDThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control during landing with a gusting crosswind, which resulted in a ground-loop.NTSB GAA18CA522Accident · No injuriesData collectionFinal reportPiper PA 12 · Rexburg, IDThe pilot's improper landing flare, which resulted in the airplane bouncing and a subsequent loss of directional control, a runway excursion, and impact with a fence.NTSB WPR18LA175Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Lewiston, IDThe failure of a hydraulic line in the landing gear system, which resulted in the pilot's inability to lower the gear and a subsequent gear-up landing.NTSB GAA18CA302Accident · No injuriesData collectionFinal reportTaylorcraft F21 · Payette, IDThe student pilot’s failure to maintain directional control during landing with a crosswind and his subsequent failure to maintain airspeed during an aborted landing, which resulted in a collision with terrain and nose-over.NTSB GAA17CA526Accident · Serious injuriesData collectionFinal reportCessna 172 · Coolin, IDThe pilot's decision to take off in high-density altitude and gusting quartering tailwind conditions, which resulted in a loss of lift and an inability to gain altitude during the initial climb.NTSB WPR17LA181Accident · Serious injuriesLimited investigationFinal reportRans S9 · Athol, IDThe pilot's loss of pitch attitude and ground proximity awareness, which resulted in an unintentionally steep initial climb and an overcorrection into a steep descent and ground impact.NTSB WPR17LA154Accident · No injuriesClass 3 · LimitedFinal reportBeech D55 · Hailey, IDThe pilot’s loss of directional control during landing.NTSB GAA17CA346Accident · No injuriesData collectionFinal reportCessna 305C (0 1E) · Rexberg, IDThe pilot’s failure to maintain directional control during landing in gusting wind conditions.NTSB GAA17CA320Accident · No injuriesData collectionFinal reportCessna 182 · Elk City, IDThe pilot’s failure to maintain adequate airspeed and his exceedance of the wing’s angle of attack while on short final, which resulted in an aerodynamic stall.NTSB GAA17CA245Accident · No injuriesData collectionFinal reportCessna 185 · Marsing, IDThe pilot’s improper landing flare, which resulted in a bounced landing, the failure of the right main landing gear wheel, and a ground loop.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 GAA16CA519Accident · No injuriesData collectionFinal reportBeech G35 · Kooskia, IDThe pilot’s failure to extend the landing gear during landing.NTSB GAA16CA522Accident · No injuriesData collectionFinal reportDieterich Robert A AIR CAM · McCall, IDThe pilot’s improper landing flare, which resulted in a hard landing and the left main landing gear wheel separating from the airplane, followed by an aborted landing, and a subsequent ground loop during the follow-on landing.NTSB GAA16CA459Accident · No injuriesData collectionFinal reportCessna A185 · Gooding, IDThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB GAA16CA446Accident · No injuriesData collectionFinal reportCessna A185 · Caldwell, IDThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop.NTSB GAA16CA420Accident · No injuriesData collectionFinal reportCubcrafters CC11 · Hailey, IDThe flight instructor's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a ground loop.NTSB GAA15CA275Accident · No injuriesData collectionFinal reportCessna 180 · McCall, IDThe pilot's excessive application of brake pressure during the landing roll, which resulted in a nose over. Contributing to the accident was the pilot's decision to continue the landing after noting he was high on final approach.NTSB GAA15CA259Accident · No injuriesData collectionFinal reportCessna T210L · Soda Springs, IDThe pilot's failure to extend the landing gear prior to landing, which resulted in substantial damage to the fuselage during landing.NTSB WPR15LA190Accident · Serious injuriesLimited investigationFinal reportPiper PA 20 · Yellow Pine, IDThe pilot's delayed decision to go around after realizing that the airplane’s airspeed and altitude were too high, which resulted in an inadequate flare and bounced landing and a subsequent go-around in high-density altitude conditions.NTSB WPR14CA211Accident · No injuriesData collectionFinal reportFdr601 Zodiac 601XL · Lewiston, IDThe pilot's improper flare during landing.NTSB WPR13LA111Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Boise, IDThe pilot's failure to maintain a proper glidepath and stabilized approach, which resulted in the airplane touching down short of the runway.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 WPR12CA311Accident · No injuriesData collectionFinal reportCessna T210L · Idaho Falls, IDThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was an uncorrected malfunction of the landing gear warning horn system.NTSB WPR12CA240Accident · No injuriesData collectionFinal reportCessna P337H · Jerome, IDThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot's failure to use the checklist before landing.NTSB WPR10CA362Accident · Minor injuriesData collectionFinal reportPiper/Cub Crafters PA-18-150 · Lucile, IDThe pilot's delayed decision to perform a go-around, which resulted in the airplane colliding with a fence during the initial climb.NTSB WPR10CA323Accident · No injuriesData collectionFinal reportCessna 172M · Twin Falls, IDThe student pilot's improper landing flare.NTSB WPR09CA392Accident · Minor injuriesData collectionFinal reportPiper PA-38-112 · Kamiah, IDThe failure of the student pilot to maintain directional control during landing.NTSB WPR09CA304Accident · No injuriesData collectionFinal reportStucker Virgil A Avid Magnu · Emmett, IDThe pilot's improper landing flare and recovery from a bounced landing.NTSB SEA08CA203Accident · No injuriesData collectionFinal reportSnelling Zodiac · Rexburg, IDThe private pilot's excessive use of the flight controls and improper landing flair, which resulted in a hard landing and subsequent gear collapse.