NTSB investigations, UT
27 cases where the sequence of events included Controlled flight into terr/obj (CFIT).
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 3 |
| 2010 | 3 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2017 | 4 |
| 2018 | 2 |
| 2019 | 2 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 2 |
| 2025 | 2 |
| 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\" = 'UT' 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\" = '120' 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" = 'UT' 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" = '120' 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 WPR26FA232Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172 · Willard, UTOn June 23, 2026, at about 2247 mountain daylight time, a Cessna 172S, N387AF, was destroyed when it was involved in an accident near Willard, Utah. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB WPR25FA269Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-28R-200 · Alta, UTOn August 31, 2025, about 1720, mountain daylight time a Piper PA28-200R, N1147X, was substantially damaged when it was involved in an accident near Alta, Utah. The pilot was seriously injured, and the passenger sustained fatal injuries. The airplane was…NTSB WPR25FA232Accident · 1 fatalClass 3 · FieldPreliminary reportSchleicher ASW27-18 · Morgan, UTOn August 1, 2025, about 1358 mountain daylight time, a Schleicher ASW27-18, N929JK, was involved in an accident near Morgan, Utah. The pilot was fatally injured. The glider was operated as a Title 14 Code of Federal Regulations Part 91 personal flight. A…NTSB WPR24FA024Accident · 1 fatalClass 3 · FieldFinal reportCessna T206H · Orangeville, UTThe pilot's controlled flight into mountainous terrain for reasons that could not be determined.NTSB WPR24FA002Accident · 4 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Moab, UTThe pilot’s loss of visual reference to the horizon while departing during dark night, which resulted in the pilot experiencing spatial disorientation and subsequent controlled flight into terrain.NTSB WPR22FA164Accident · 4 fatalClass 3 · FieldFinal reportDiamond Aircraft Ind DA 40 · Cedar City, UTThe pilot’s failure to maintain obstacle clearance, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s decision to operate the airplane above its maximum gross weight.NTSB WPR21FA231Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Rush Valley, UTThe pilot’s misidentification of a mountain pass at night, which resulted in controlled flight into terrain. Contributing to the accident were the pilot’s overconfidence based on her previous aviation experience and fatigue due to both the time of the flight…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 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 CEN18FA326Accident · 1 fatalField investigationFinal reportCessna 525 · Payson City, UTThe pilot's intentional flight into his residence.NTSB WPR18FA095Accident · 4 fatalField investigationFinal reportPiper PA32R · Monticello, UTThe noninstrument-rated pilot's continued flight into a region of deteriorating ceiling and visibility conditions, which resulted in controlled flight into terrain event.NTSB WPR18FA063Accident · 2 fatalField investigationFinal reportCessna 172M · Ogden, UTThe pilot's failure to maintain clearance from the water while flying over a lake with glassy surface conditions. Contributing to the accident was the pilot's use of three impairing medications.NTSB GAA17CA371Accident · No injuriesData collectionFinal reportAero Commander Callair A 9 · Morgan, UTThe pilot’s failure to see and avoid transmission wires.NTSB WPR17FA065Accident · 3 fatalField investigationFinal reportCessna 172 · Panguitch, UTThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's inadequate preflight weather planning and his poor decision-making.NTSB GAA17CA117Accident · No injuriesData collectionFinal reportAir Tractor AT 802 · Vernon, UTThe pilot’s failure to maintain clearance from mountainous terrain.NTSB WPR15FA082Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Tooele, UTThe non-instrument rated pilot’s decision to depart into low visibility conditions, which resulted in spatial disorientation and a loss of control. Contributing to the accident was the pilot’s impaired performance due to his use of the sedating antihistamine,…NTSB WPR13FA095Accident · 2 fatalField investigationFinal reportCessna 140 · Boulder, UTThe pilot’s improper decision to maneuver at a low altitude and failure to adequately monitor the environment to maintain clearance from power lines.NTSB WPR12FA098Accident · 2 fatalField investigationFinal reportCessna 210 · Morgan, UTThe non-instrument-rated pilot’s poor planning and continued visual flight rules flight into instrument meteorological conditions and failure to maintain clearance from mountainous terrain.NTSB WPR11LA315Accident · No injuriesLimited investigationFinal reportBeech V35B · Oljato, UTThe pilot’s failure to follow the airplane manufacturer’s mixture setting guidance while landing in high density altitude conditions.NTSB WPR11LA180Accident · Minor injuriesLimited investigationFinal reportWilliam Wright Avid Flyer · Cedar City, UTA loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal a specific anomaly that would have precluded normal operation.NTSB WPR11FA073Accident · Serious injuriesField investigationFinal reportCessna T210M · Ogden, UTThe pilot did not maintain clearance from obstacles after descending below the published approach decision height when visibility was less than published approach minimums due to heavy ground fog and he did not execute a missed approach after failing to…NTSB WPR10CA337Accident · Minor injuriesData collectionFinal reportCessna 150M · Neola, UTA partial loss of engine power for undetermined reasons and the pilot's failure to maintain clearance from a power line.NTSB WPR10LA292Accident · 1 fatalLimited investigationFinal reportAir Creation GTE · Springville, UTThe pilot's inadequate preflight planning and his failure to maintain clearance from obstacles during takeoff. Contributing to the accident was the pilot's lack of experience.NTSB WPR10LA021Accident · Serious injuriesLimited investigationFinal reportAerotrike Naked Cobra · Virgin, UTA loss of engine power during cruise flight for undetermined reasons.NTSB WPR09FA320Accident · 1 fatalField investigationFinal reportPiper PA-46-350P · St George, UTThe pilot's failure to maintain terrain clearance during descent for undetermined reasons.NTSB WPR09GA216Accident · 3 fatalFinal reportLockheed P2V-7 · Stockton, UTThe flight crew's failure to maintain terrain clearance during low altitude flight in low ceiling and visibility conditions. Contributing to the accident was the flight crew's failure to adequately monitor their location with respect to the rising terrain…NTSB WPR09LA043Accident · 1 fatalLimited investigationFinal reportCessna 170B · Hanna, UTThe flight's encounter with adverse tailwinds and downdrafts in mountainous terrain that exceeded the airplane's climb capability.