NTSB investigations
1,569 cases where NTSB found Terrain.
Cases per year
| 2008 | 221 |
|---|---|
| 2009 | 134 |
| 2010 | 97 |
| 2011 | 83 |
| 2012 | 87 |
| 2013 | 84 |
| 2014 | 117 |
| 2015 | 88 |
| 2016 | 94 |
| 2017 | 92 |
| 2018 | 98 |
| 2019 | 98 |
| 2020 | 54 |
| 2021 | 56 |
| 2022 | 42 |
| 2023 | 42 |
| 2024 | 31 |
| 2025 | 34 |
| 2026 | 17 |
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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030210')) 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", '030210')) 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 CEN26LA300Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T206H · Marble, COThe pilot's failure to maintain directional control during the final approach in variable and gusting wind conditions. Contributing to the accident were localized wind effects associated with mountainous terrain and with nearby convective activity.NTSB ERA26LA261Accident · No injuriesClass 4 · LimitedFinal reportKodiak Kodiak 100 · New York, NYAn inadvertent collision with a large wave during touchdown on a river, which resulted in a subsequent bounce and hard landing.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 WPR26LA230Accident · No injuriesClass 4 · LimitedFinal reportStephen Aberle Chipper CH-2A · Alva, OKThe pilot's decision to taxi the tailwheel-equipped airplane over uneven terrain while operating with limited forward visibility, which resulted in the left main landing gear entering a hole.NTSB WPR26LA222Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172S · Death Valley, CAThe pilot’s failure to maintain airspeed and encounter with a tailwind while landing on a rough runway, which resulted in a runway overrun and subsequent nose over.NTSB ERA26LA245Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft DCO-65 · Renovo, PAThe pilot’s failure to maintain control during an off-airport landing.NTSB CEN26LA233Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Gregory, MIThe flight instructor’s improper planning during the simulated aborted launch which resulted in a touchdown on unsuitable terrain.NTSB CEN26LA194Accident · No injuriesClass 4 · LimitedFinal reportLockwood AIR CAM · Hutchinson, KSThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA26LA199Accident · No injuriesClass 4 · LimitedFinal reportAlexander Schleicher ASW 27-18 · Greenwood, SCThe glider pilot’s encounter with a strong sink/loss of lift, which resulted in a forced landing to unsuitable terrain.NTSB CEN26LA165Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Peyton, COThe pilots’ inadequate preflight fuel planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion and subsequent forced landing to a field.NTSB WPR26LA146Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206L-1 · Chimney Rock, MTThe pilot’s failure to maintain adequate clearance from the terrain while performing a low altitude circling takeoff maneuver, which resulted in a dynamic rollover.NTSB WPR26LA134Accident · No injuriesClass 4 · LimitedFinal reportZlin Aviation Sro Savage CUB-S · Young, AZThe pilot’s failure to maintain adequate clearance from trees during landing.NTSB WPR26LA123Accident · Serious injuriesClass 4 · LimitedFinal reportBrunner Donald G Kitfox · Rock Crossing, AZAn encounter with a downdraft while maneuvering at a low altitude, which resulted in an impact with terrain.NTSB CEN26LA119Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Graford, TXThe pilot’s failure to maintain sufficient rotor speed during a practice autorotation to soft terrain which resulted in a loss of control and roll over.NTSB WPR26LA095Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Alpine, WYThe pilot’s inadvertent descent while operating in flat light conditions which resulted in controlled flight into terrain.NTSB WPR26LA089Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-23 · Newkirk, NMThe pilots inadequate preflight planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent landing on rough terrain.NTSB WPR26LA087Accident · Serious injuriesClass 4 · LimitedFinal reportKitfox Series 7 · Lemmon Valley-Golden Valley, NVThe pilot’s inability to maintain clearance from terrain during a go-around.NTSB CEN26LA073Accident · Minor injuriesClass 4 · LimitedFinal reportRockwell International 114 · Stroud, OKThe pilot’s inadequate fuel planning, which resulted in a total loss of power due to fuel exhaustion.NTSB CEN26LA019Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Bonilla, SDThe pilot’s inadequate flight planning and his failure to maintain aircraft control during the precautionary off-airport landing.NTSB WPR26LA018Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Imnaha, ORThe pilot’s continued application of brakes during an aborted takeoff in a tailwind on down-sloping terrain, which resulted in a nose-over.NTSB WPR26LA014Accident · No injuriesClass 4 · LimitedFinal reportMaye James A Just Aircraft Escapade · Flanigan, NVThe pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN25LA403Accident · No injuriesClass 4 · LimitedFinal reportAeronca 11AC · Longmont, COThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and the pilot’s improper landing flare which resulted in a hard landing.NTSB WPR25LA298Accident · No injuriesClass 4 · LimitedFinal reportCessna 185A · Ilwaco, WAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ANC25LA121Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4-210C · Lime Village, AKA collision with terrain during takeoff.NTSB WPR25LA284Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US A-225 · Albuquerque, NMThe balloon pilot’s improper landing, which resulted in serious injury to a passenger. Contributing to the accident was the pilot’s failure to brief the proper landing procedure.NTSB ANC25LA102Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Unalakleet, AKThe pilots encounter with an obstructed dip in the landing surface during the landing roll out on a remote airstrip, which resulted in a noseover.NTSB ANC25LA101Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Willow, AKThe pilot’s decision to takeoff from an unsuitable runway due to large puddles of water, which resulted in a nose over.NTSB ANC25LA092Accident · No injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B2 · Juneau, AKThe pilot’s failure to maintain adequate obstacle clearance during takeoff from uneven, snow-covered terrain in flat light conditions.NTSB ANC25LA097Accident · No injuriesClass 4 · LimitedFinal reportAirbus Helicopters AS350B3e · Skwentna, AKThe pilot’s inadvertent entanglement of a lightweight Kevlar long line into the helicopters operating main rotor system, resulting in a severe imbalance and separation of the main rotor gearbox.NTSB ANC25LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 180G · Delta Junction, AKThe pilot’s failure to maintain a rate of climb sufficient to clear obstacles during takeoff, resulting in a collision with tree-covered terrain.NTSB ANC25LA087Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Homer, AKThe failure of the left main landing gear mount due to extensive corrosion while landing in an area of rough terrain.NTSB ANC25LA090Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Willow, AKThe pilot’s loss of control after a rejected takeoff, which resulted in a noseover.NTSB WPR25LA246Accident · No injuriesClass 4 · LimitedFinal reportHiller UH-12E · Fobes Hill, WAThe pilot’s abrupt maneuver to avoid a powerline during an aerial application flight, which resulted in the helicopter’s impact with terrain.NTSB ANC25LA085Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 MK 1 · Soldotna, AKThe pilot’s failure to maintain clearance from rising terrain while maneuvering at low altitude.NTSB ANC25LA083Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1B · Chisana, AKThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude.NTSB WPR25LA226Accident · No injuriesClass 4 · LimitedFinal reportCessna 182L · Tucson Estates, AZThe pilot’s inability to stop the airplane on the runway during a rejected takeoff for undetermined reasons, which resulted in the airplane’s impact with a ditch.NTSB ANC25LA075Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Palmer, AKThe pilot's excessive braking during the landing roll, resulting in a nose over.NTSB ANC25LA074Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Nelson Lagoon, AKThe pilot’s failure to maintain clearance from a creek bank while maneuvering to land.NTSB ANC25LA073Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-135 · Palmer, AKThe pilot’s excessive braking during the landing roll, resulting in a nose over. Contributing to the accident was the pilot’s decision to continue the landing after determining the landing area was unsuitable.NTSB CEN25LA240Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CCK-1865 · La Garita, COThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude in mountainous terrain. Contributing was the pilot’s inadequate preflight planning and aeronautical decision making.NTSB ANC25LA064Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Palmer, AKThe pilot’s diverted attention during takeoff in flat light conditions, which resulted in a loss of visual reference with terrain.NTSB WPR25LA184Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180E · Rockford, WAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent landing on rough terrain.NTSB WPR25LA181Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Heber City, UTThe student pilot’s improper recovery from a bounced landing, which resulted in a nose over.NTSB CEN25LA193Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177B · Columbus, MSThe pilot's inadequate preflight inspection and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent landing on rough terrain.NTSB WPR25LA162Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Monroe, WAThe student pilot’s failure to maintain airplane control during landing, and the flight instructor’s delayed remedial action, which resulted in impact with a ditch.NTSB WPR25LA157Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Fullerton, CAThe pilot’s failure to attain a proper touchdown point, which resulted in a runway overrun and collision with terrain.NTSB CEN25LA112Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Romeo, MIThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the soft, wet grass.NTSB CEN25LA121Accident · No injuriesClass 4 · LimitedFinal reportCessna 150J · Greenville, MSThe pilots’ inadequate fuel planning and failure to monitor the fuel consumption which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing into wooded terrain. Contributing to the accident was the flight…NTSB WPR25FA090Accident · No injuriesClass 3 · FieldFinal reportBeech B24R · Skull Valley, UTThe flight instructor’s improper fuel management, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident were multiple distractions that diverted the flight instructor’s attention from the proper monitoring and…NTSB CEN25LA093Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · Spearman, TXImproperly torqued intake manifold bolts that allowed unmetered air to enter the engine, resulting in an overly lean fuel-air mixture, eventual failure of the No. 3 cylinder intake valve, and a total loss of engine power.