NTSB investigations
329 cases where NTSB found Mountainous/hilly terrain.
Cases, newest first
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.\"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."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 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 CEN21FA007Accident · 2 fatalClass 3 · FieldFinal reportBeech S35 · Telluride, COThe pilot’s loss of control during the climb to cruise flight resulting in the airplane’s impact with terrain. Contributing to the accident was the pilot’s decision to not climb to a higher altitude before proceeding over high 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 WPR20LA245Accident · 1 fatalClass 3 · LimitedFinal reportCessna 337 · Ennis, MTThe pilot-in-command’s failure to maintain sufficient airspeed while attempting an evasive maneuver from a boxed canyon, which resulted in an aerodynamic stall/spin and impact with mountainous terrain. Contributing to the accident was the pilot-in-command’s…NTSB WPR20CA218Accident · No injuriesClass 4 · Data collectionFinal reportRans S6 · Richland, WAThe pilot's inability to arrest a descent rate or maintain altitude after encountering a downdraft while maneuvering at low altitude near mountainous terrain that resulted in a hard landing.NTSB CEN20LA273Accident · Serious injuriesClass 3 · LimitedFinal reportAerospatiale AS355 · Rifle, COA loss of tail rotor effectiveness, the pilot’s subsequent loss of helicopter control, and collision with terrain.NTSB WPR20LA203Accident · 4 fatalClass 3 · LimitedFinal reportCessna 172 · Alpine, UTThe pilot’s exceedance of the airplane’s critical angle-of-attack while maneuvering in a canyon, which resulted in a loss of airplane control.NTSB WPR20LA169Accident · 3 fatalClass 3 · LimitedFinal reportCessna 175 · Redlands, CAThe noncertificated pilot’s visual flight rules flight into instrument meteorological conditions and subsequent impact with terrain.NTSB ANC20CA052Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT802 · Unalakleet, AKThe pilot's failure to maintain terrain clearance during the departure, which resulted in a collision with terrain..NTSB WPR20CA125Accident · Minor injuriesData collectionFinal reportCessna 172 · Yakima, WAThe pilot's failure to attain sufficient altitude during a go-around, which resulted in impact with hilly terrain.NTSB ANC20CA041Accident · No injuriesData collectionFinal reportPiper PA 18A · Chickaloon, AKThe pilot's selection of unsuitable terrain for landing, which necessitated a go-around, and her subsequent failure to maintain clearance from rising mountainous terrain.NTSB WPR20FA079Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Payson, AZThe pilot's decision to fly into a canyon with rising terrain, and his subsequent loss of aircraft control while maneuvering away from rising terrain.NTSB WPR20FA077Accident · 2 fatalClass 3 · FieldFinal reportStinson V77 · Auburn, CAA total loss of engine power due to a combination of mechanical engine anomalies. Contributing to the accident was inadequate maintenance that failed to identify the engine anomalies.NTSB WPR20FA034Accident · 3 fatalClass 3 · FieldFinal reportCirrus SR-22 · North Las Vegas, NVThe pilot’s failure to maintain clearance from terrain during cruise flight in dark night conditions.NTSB WPR20LA007Accident · Minor injuriesClass 3 · LimitedFinal reportHiller UH 12E · Susanville, CAA partial loss of engine power due to multiple overtemperature events and a hot start event, which resulted in thermally damaged internal components of the engine. Contributing to the accident was the lack of suitable terrain on which to perform the forced…NTSB WPR19FA266Accident · 2 fatalClass 3 · FieldFinal reportAmerican AA5 · Cowles, NMThe pilot's decision to fly into terrain that exceeded the performance capabilities of the airplane, which resulted in failure to maintain clearance from trees and terrain.NTSB WPR19FA263Accident · 2 fatalField investigationFinal reportCessna 182 · Nixon, NVA loss of airplane control while maneuvering due to spatial disorientation after inadvertently entering instrument meteorological conditions (IMC). Contributing to the accident was the pilot's inexperience in IMC conditions.NTSB WPR19FA250Accident · 2 fatalClass 3 · FieldFinal reportCessna 210 · Henefer, UTThe pilots’ decision to enter a canyon at low altitude, which resulted in controlled flight into terrain while attempting to exit the canyon.NTSB WPR19FA244Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · McKenzie Bridge, ORThe pilot's delayed climb and misjudgment of the airplane’s performance and the runway distance needed to clear obstacles at the end of the runway, which resulted in a collision with trees and subsequent impact with terrain. Contributing to the accident was…NTSB WPR19FA183Accident · 2 fatalClass 3 · FieldFinal reportSchempp Hirth Arcus · Ephraim, UTThe pilot's decision to maneuver in close proximity to terrain while attempting to remain in an area of lift, which resulted in a collision with trees.NTSB WPR19FA182Accident · 2 fatalClass 3 · FieldFinal reportCub Crafters CCK-1865 · Moab, UTThe pilots failure to maintain clearance from terrain while maneuvering at a low altitude in mountainous terrain.NTSB WPR19FA175Accident · 1 fatalClass 3 · FieldFinal reportRobinson R44 · Two Harbors, CAThe pilot's continued visual flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB GAA19CA278Accident · Minor injuriesData collectionFinal reportBell 206 · Pittsfield, ILThe pilot's failure to maintain clearance from rising terrain during agricultural application operations.NTSB WPR19FA146Accident · 1 fatalClass 3 · FieldFinal reportAviat A1 · Santa Ynez, CAThe pilot’s failure to maintain clearance from mountainous terrain during cruise flight in low visibility and mountainous obscuration conditions.NTSB ANC19TA017Accident · Serious injuriesClass 3Final reportCessna A185 · Nome, AKThe pilot's decision to continue a visual flight rules flight into an area of mountainous terrain and instrument meteorological conditions, which resulted in spatial disorientation and controlled flight into terrain. Contributing to the accident was the…NTSB WPR19FA086Accident · 3 fatalClass 3 · FieldFinal reportBeech D55 · Stallion Springs, CAThe pilot’s continued visual flight into instrument meteorological conditions associated with mountain obscuration conditions, which resulted in controlled flight into rising terrain. Contributing to the accident was the pilot’s failure to obtain a weather…NTSB GAA19CA144Accident · No injuriesData collectionFinal reportMooney M20J · Ridgeland, SCThe flight instructor's failure to retract the flaps during an attempted go-around and his failure to maintain the runway heading, which resulted in a collision with terrain left of the runway.NTSB GAA19CA139Accident · No injuriesData collectionFinal reportAirbus A350 · Eureka, AKThe pilot's selection of unsuitable terrain for landing on snow-covered mountainous terrain with steep rocks above, which resulted in loose rocks damaging the main rotor blades and the subsequent loss of helicopter controllability.NTSB WPR19FA084Accident · 2 fatalClass 2 · FieldFinal reportCirrus SR22 · Ely, NVThe pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions and icing conditions which resulted in a high rate of descent and impact with terrain. Contributing to the accident was the inaccurate weather reporting…NTSB WPR19FA080Accident · 2 fatalClass 2 · FieldFinal reportCessna 172 · Desert Hot Springs, CAThe pilot's inadequate and/or improper preparation for the flight in which he selected an altitude too low to assure terrain clearance and resulted in an impact with terrain in turbulent downdraft conditions.NTSB WPR19FA077Accident · 1 fatalClass 2 · FieldFinal reportRockwell 112 · Mt Hood, ORThe pilot's decision to fly the airplane in close proximity to mountainous terrain in an area of mountain wave activity that exceeded the performance capabilities of the airplane. Contributing to the accident was the pilot's degraded decision making and…NTSB CEN19FA024Accident · 3 fatalField investigationFinal reportBell 206 · Uvalde, TXThe pilot's controlled flight into terrain during night visual meteorological conditions. Contributing to the accident was the pilot improper decision to inhibit the helicopter's terrain warning systems and flight at low altitude.NTSB GAA19CA039Accident · Minor injuriesData collectionFinal reportBell OH 58A · Carson City, NVThe pilot's failure to maintain clearance from power lines while maneuvering at a low altitude in hilly terrain. Contributing to the accident was the pilot’s inability to determine the airplane’s altitude due to sun glare.NTSB WPR19TA005Accident · Serious injuriesFinal reportBalloon Works Firefly 7 · Placitas, NMThe pilot’s failure to properly estimate the height of terrain while descending the balloon, which resulted in the balloon impacting a hill and passengers sustaining serious injuries.NTSB ERA19FA003Accident · 1 fatalField investigationFinal reportPiper J3C · Fancy Gap, VAThe non-instrument-rated pilot's improper decision to undertake a flight into forecast instrument meteorological conditions (IMC) and his subsequent decision to continue the flight after encountering IMC, which resulted in controlled flight into 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 WPR18LA263Accident · Serious injuriesClass 3 · LimitedFinal reportCessna A185 · Bullhead City, AZThe pilot’s diverted attention during takeoff initial climb, which resulted in a collision with rising terrain.NTSB GAA18CA538Accident · No injuriesData collectionFinal reportAvid Avid Magnum · Carrabassett Valley, METhe pilot’s improper decision to initiate the flight in marginal visual flight rules over mountainous terrain, which resulted in an inadvertent encounter with instrument meteorological and downdraft conditions and the subsequent controlled flight into trees…NTSB GAA18CA535Accident · No injuriesData collectionFinal reportPiper PA 12 · Talkeetna, AKThe pilot’s failure to maintain pitch control on uneven terrain during the landing roll, which resulted in a nose-over.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 WPR18FA228Accident · 2 fatalClass 3 · FieldFinal reportPietenpol Aircamper · Camp Verde, AZLoss of control for reasons that could not be determined because postaccident examination of the airframe and engine revealed no mechanical anomalies that would have precluded normal operation.NTSB GAA18CA512Accident · No injuriesClass 4 · Data collectionFinal reportBell 206 · Battle Mountain, NVThe pilot's failure to maintain the proper altitude and airspeed while flying in a canyon in gusting wind conditions.NTSB WPR18FA186Accident · 1 fatalClass 3 · FieldFinal reportCessna 320 · Eagle Mountain, UTThe pilot's exceedance of the airplane's critical angle of attack and the airplane experiencing an aerodynamic stall at too low an altitude to recover.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 GAA18CA366Accident · No injuriesData collectionFinal reportRobinson R66 · Cordova, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in impact with brush and a loss of helicopter control.NTSB CEN18LA226Accident · Serious injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Arrey, NMThe pilot's failure to maintain clearance from a hillside during an agricultural application flight while facing the sun.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 WPR18FA139Accident · 3 fatalField investigationFinal reportBeech 76 · Julian, CAThe pilot's failure to maintain sufficient altitude above mountainous terrain while maneuvering during night conditions in an area prone to turbulence, which resulted in a collision with terrain. Contributing to the accident was the flight instructor's…NTSB GAA18CA248Accident · Minor injuriesData collectionFinal reportCessna 172 · Port Angeles, WAThe pilot’s exceedance of the airplane’s critical angle of attack during a turn away from terrain, which resulted in an accelerated stall. Contributing to the accident was the pilot’s decision to delay the turn to avoid terrain.