NTSB investigations, ID
28 cases where NTSB found Mountainous/hilly terrain.
Cases per year
| 2009 | 3 |
|---|---|
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 3 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 4 |
| 2020 | 3 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2026 | 1 |
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 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\", '03021010'))
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", '03021010')) 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 WPR26LA234Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Dixie, IDThe pilot's delayed decision to initiate a go-around and subsequent failure to maintain clearance from rising terrain.NTSB WPR24FA190Accident · 1 fatalClass 3 · FieldFinal reportCessna 177B · Elk River, IDThe pilot’s failure to maintain clearance from terrain while climbing in mountainous terrain during moderately high density altitude conditions, and conditions conducive to severe carburetor icing.NTSB WPR23FA296Accident · 1 fatalClass 3 · FieldFinal reportCessna T206H · Yellow Pine, IDThe pilot’s decision to perform a go-around into rising mountainous terrain. Contributing to the accident was the pilot’s failure to follow published airport guidance about go-arounds, and landings and takeoffs with unfavorable winds.NTSB WPR22LA238Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA20 · Challis, IDThe pilot's turn towards rising terrain with limited climb performance and his subsequent failure to maintain clearance from terrain that resulted in an impact with terrain.NTSB WPR21FA330Accident · 2 fatalClass 3 · FieldFinal reportCessna TU206F · Bernard, IDThe pilot’s decision to continue the flight into a canyon that exceeded the performance capabilities of the airplane, which resulted in an impact with trees an terrain.NTSB WPR21LA107Accident · Serious injuriesClass 3 · LimitedFinal reportHughes OH-6A · Horseshoe Bend, IDA partial loss of engine power due to a leak in the fuel cell outlet valve.NTSB WPR21LA056Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Howe, IDThe pilot’s failure to maintain clearance from mountainous terrain after an encounter with a downdraft, which resulted in a collision with terrain.NTSB WPR20LA315Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-802A · Emmett, IDThe pilot’s descent below surrounding terrain and his delayed decision to initiate a climb which resulted in impact with terrain. Contributing to the accident were terrain and lighting conditions that affected the pilot’s ability to accurately assess terrain…NTSB WPR20LA330Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Stanley, IDThe pilot's failure to maintain terrain clearance after flying into the wrong canyon in mountainous terrain which resulted in a collision with trees and terrain.NTSB WPR18FA276Accident · 3 fatalClass 2 · FieldFinal reportCessna T210 · Silver City, IDThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack while making a turn in gusting wind conditions while flying through hilly terrain, which resulted in an aerodynamic stall.NTSB WPR18LA227Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182 · Salmon, IDThe pilot’s inadvertent encounter with downdraft conditions, which resulted in a loss of altitude, and the pilot’s subsequent decision to conduct a precautionary landing into a stand of trees.NTSB WPR18LA176Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 18-150 · Yellow Pine, IDThe pilot’s failure to maintain adequate airspeed while conducting a go-around and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall/spin at too low of an altitude to recover. Contributing to the accident were…NTSB WPR18FA141Accident · 1 fatalField investigationFinal reportCessna 182G · Cascade, IDThe non-instrument-rated pilot's improper decision to initiate a visual flight rules flight into an area with low ceilings due to mountain obscuration, which resulted in controlled flight into terrain.NTSB WPR17LA195Accident · 1 fatalLimited investigationFinal reportWalker Edgar E Glastar · Cascade, IDThe pilot's inadequate flight planning, preparation, and navigation, which resulted in the airplane entering a canyon that the pilot was unable to exit by climbing the airplane. Also causal were his in-flight decision-making and his execution of the course…NTSB GAA17CA202Accident · Minor injuriesData collectionFinal reportCessna 182 · Mackay, IDThe pilot's decision to maneuver the airplane over mountainous terrain in high-density altitude conditions, which resulted in the airplane’s inability to maintain altitude or establish a climb.NTSB WPR16FA131Accident · 1 fatalField investigationFinal reportCessna A185F · Coeur d'Alene, IDThe pilot's failure to maintain clearance from trees while maneuvering at low altitude in mountainous terrain.NTSB WPR16FA006Accident · 3 fatalField investigationFinal reportCessna 182 · Hope, IDThe pilot's selection of an inadequate altitude to cross mountainous terrain and her subsequent failure to maintain terrain clearance. Contributing to the accident was the pilot's inadequate preflight evaluation of the weather conditions and flight plan.NTSB WPR14FA330Accident · 2 fatalField investigationFinal reportDavid Fitzgerald Zenith · Warren, IDThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while climbing to avoid terrain while operating at a high density altitude, which resulted in a stall at too low an altitude to allow recovery.NTSB WPR14FA316Accident · 1 fatalField investigationFinal reportMeyer Legacy · Lolo Pass, IDThe fatigue fracture of an engine connecting rod, which resulted in a catastrophic engine failure and a forced landing in unsuitable terrain.NTSB WPR12CA429Accident · Minor injuriesData collectionFinal reportPiper PA-14 · Emmett, IDThe pilot’s failure to maintain clearance from terrain.NTSB WPR12FA255Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Mountain Home, IDThe noninstrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.NTSB WPR12LA231Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Silver City, IDThe pilot‘s failure to maintain airspeed while maneuvering in mountainous terrain with reduced visibility, which resulted in an aerodynamic stall.NTSB WPR12LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Hailey, IDThe pilot's failure to maintain course heading and terrain clearance because he was distracted by efforts to engage the autopilot shortly after takeoff on a dark night in mountainous terrain.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 WPR10FA459Accident · 2 fatalField investigationFinal reportCessna T210N · Coeur d'Alene, IDThe pilot’s continued flight into instrument meteorological conditions and failure to maintain clearance with mountainous terrain while maneuvering in an area of low cloud ceilings.NTSB WPR10CA089Accident · No injuriesData collectionFinal reportCessna 172M · Albion, IDThe pilot's failure to maintain clearance from mountainous terrain while maneuvering in gusting winds.NTSB WPR09FA379Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Saint Charles, IDThe pilot’s failure to maintain terrain clearance while maneuvering.NTSB WPR09FA282Accident · 1 fatalField investigationFinal reportCessna 182M · Atlanta, IDThe pilot's failure to maintain terrain clearance during cruise flight.