NTSB investigations, UT
17 cases where NTSB found Rough terrain.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 3 |
| 2014 | 3 |
| 2015 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2024 | 1 |
| 2025 | 2 |
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\" = 'UT' 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\", '03021015'))
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" = 'UT' 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", '03021015')) 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 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 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 WPR24LA127Accident · No injuriesClass 3 · LimitedFinal reportSchleicher Alexander ASH 26 E · Heber, UTReduced takeoff performance for reasons that could not be determined, which resulted in a forced landing.NTSB WPR21LA325Accident · No injuriesClass 3 · LimitedFinal reportStout Garry V Europa - Trigear · Hanksville, UTThe pilot’s installation of a non-original equipment manufactured radiator cap, which resulted in the loss of coolant and the engine’s exceedance of the maximum admissible cylinder head temperature. Contributing to the accident was the lack of suitable…NTSB WPR21LA051Accident · Minor injuriesClass 4 · LimitedFinal reportMaule MX7 · Moab, UTThe pilot's failure to maintain airplane control during takeoff from an unimproved airstrip, which resulted in a nose-over.NTSB WPR15LA185Accident · No injuriesLimited investigationFinal reportCessna 182A · Moab, UTThe pilot’s inadequate preflight fuel planning and inflight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR14LA346Accident · No injuriesLimited investigationFinal reportBoeing 737 7H4 · Salt Lake City, UTThe disconnection of baggage carts that subsequently collided with the parked airplane following the tug driving over a dip in the roadway.NTSB WPR14CA321Accident · Minor injuriesData collectionFinal reportCentrair 101A · Nephi, UTThe pilot's failure to identify the proper landing surface which resulted in an off airstrip landing and collision with rough terrain.NTSB WPR14FA158Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Green River, UTA loss of engine power due to fuel contamination while maneuvering at a low altitude and the pilot's inadequate preflight inspection, which failed to detect the contamination.NTSB WPR12CA398Accident · No injuriesData collectionFinal reportLake John K MA-5 Charger · Eagle Mountain, UTThe airplane’s encounter with a large hole in the runway during the landing roll, which resulted in a loss of control and subsequent runway excursion.NTSB WPR12LA198Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Hanksville, UTThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude in high density altitude conditions, which resulted in the airplane’s inability to climb or maintain clearance from terrain.NTSB WPR12LA190Accident · Serious injuriesLimited investigationFinal reportCessna T210 · Elberta, UTA loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR11CA486Accident · No injuriesData collectionFinal reportSchleicher ASW-27 · Brigham City, UTThe glider pilot did not take timely action to locate a safe outlanding area after entering an area where atmospheric lift was not sufficient to maintain soaring flight.NTSB WPR10LA232Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Mendon, UTA loss of engine power due to a failure of the magnetos as a result of inadequate maintenance.NTSB WPR09LA167Accident · No injuriesLimited investigationFinal reportCessna 180G · Wendover, UTA loss of directional control during landing as a result of the binding in one main landing gear brake assembly due to incorrect maintenance procedures. Contributing to the accident was the pilot's failure to correctly reconfigure the airplane during an…NTSB SEA08CA211Accident · No injuriesData collectionFinal reportCessna 180 · Bluff, UTThe pilot's encounter with the rough, uneven, and eroded condition of the airstrip.NTSB LAX08CA248Accident · No injuriesData collectionFinal reportBristol Titan Tornado II · Green River, UTThe encounter with rough terrain during an off-field precautionary landing.