NTSB investigations, UT
33 cases where NTSB found Use of equip/system.
Cases per year
| 2009 | 3 |
|---|---|
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 3 |
| 2018 | 3 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 3 |
| 2022 | 3 |
| 2023 | 2 |
| 2024 | 6 |
| 2025 | 3 |
| 2026 | 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\", '02063015'))
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", '02063015')) 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 WPR26LA311Accident · No injuriesClass 4 · LimitedFinal reportCessna T210M · Logan, UTThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB WPR26LA200Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-260C · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll with gusting crosswind conditions.NTSB WPR25LA227Accident · Minor injuriesClass 4 · LimitedFinal reportHartline J Bon Hartline Kitfox III · Logan, UTThe pilot’s failure to maintain airplane control during takeoff in variable wind and high density altitude conditions.NTSB WPR25LA231Accident · No injuriesClass 4 · LimitedFinal reportGary Weaver CCK-1865 · Wahsatch, UTThe pilot’s inability to maintain directional control following a collision with a boulder during an off airport precautionary landing.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 WPR25LA056Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Marysvale, UTThe pilot’s failure to maintain clearance from snow covered terrain while maneuvering at low altitude.NTSB WPR24FA227Accident · 1 fatalClass 3 · FieldFinal reportFantasy Air Sro Allegro 2007 · Eureka, UTThe pilot’s failure to maintain airplane control during initial climb, which resulted in an in-flight upset and impact with terrain.NTSB WPR24LA168Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-210C · Hooper, UTThe inadvertent application of brakes during landing that resulted in a nose over.NTSB WPR24LA178Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Nephi, UTThe pilot’s incorrect movement of the fuel selector valve to an off or restricted position, which resulted in fuel starvation and a loss of engine power.NTSB WPR24LA088Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32R-301T · Spanish Fork, UTThe pilot's failure to ensure proper placement of the fuel selector, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR24FA083Accident · 2 fatalClass 2 · FieldFinal reportHawker Beechcraft Hawker 900XP · Westwater, UTThe flight crew’s decision to conduct a post-maintenance stall test in an area of icing conditions, which resulted in wing contamination that significantly decreased the airplane’s critical angle of attack. Also causal was the airplane manufacturer’s lack of…NTSB WPR23LA228Accident · No injuriesClass 4 · LimitedFinal reportBenoit Leclair Rans S-7S · Bryce Canyon, UTThe pilot's failure to maintain control of the airplane during the landing roll and subsequent impact with terrain during go-around.NTSB WPR23FA080Accident · 1 fatalClass 3 · FieldFinal reportEmbraer Executive EMB-505 · Provo, UTThe pilot’s failure to deice the airplane before takeoff in weather conditions conducive to ice accumulation, which resulted in an ice-contaminated wing and subsequent stall during takeoff.NTSB WPR22LA267Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Cedar City, UTThe student pilot’s failure to maintain rotor rpm and airspeed and the flight instructor's inadequate remedial action to regain helicopter control during the straight-in autorotation which resulted in a hard landing.NTSB WPR22LA161Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172I · Blanding, UTThe pilot’s improper landing flare which, resulted in a bounced landing and loss of airplane control during an aborted landing in gusty wind conditions.NTSB WPR22LA117Accident · Serious injuriesClass 4 · LimitedFinal reportSix Chuter Legend · Toquerville, UTThe pilot’s improper throttle input which resulted in a loss of engine power and subsequent impact with terrain.NTSB WPR21LA356Accident · Minor injuriesClass 4 · LimitedFinal reportKitfox S7 · Hooper, UTThe pilot’s excessive brake pressure which resulted in the airplane nosing over and coming to rest inverted.NTSB WPR21LA319Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Panguitch, UTThe airplane’s inability to maintain altitude during the initial climb due to a degradation in the airplane’s performance due to high-density altitude conditions. Contributing to the accident was the pilot’s failure to conduct preflight performance planning…NTSB WPR21LA178Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 · Brigham City, UTThe student pilot's unintentional selection of raising the landing gear instead of the flaps during a touch-and-go landing, and the flight instructor's delayed remedial action, which resulted in the landing gear retracting during the landing roll.NTSB WPR20LA099Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182 · Moab, UTThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and the airplane’s subsequent noseover.NTSB WPR20CA036Accident · No injuriesData collectionFinal reportJavron PA-18 Replica · Nephi, UTThe passenger’s inadvertent application of the brakes during landing, which resulted in a nose-over.NTSB WPR20LA032Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Hurricane, UTThe pilot’s failure to ensure that the landing gear was in the fully extended and locked position before landing. Contributing to the accident was the overload of the landing gear circuit for reasons that could not be determined.NTSB ANC18LA049Accident · No injuriesClass 3 · LimitedFinal reportLearjet 60 · Salt Lake City, UTThe flight crew’s failure to fully disengage the parking brake before taxi, which resulted in a brake fire.NTSB GAA18CA477Accident · Minor injuriesData collectionFinal reportDavidson, Ronald A. Avid · Moab, UTThe pilot's excessive brake application and delayed remedial action, which resulted in a nose over.NTSB WPR18LA102Accident · No injuriesClass 3 · LimitedFinal reportMacdonald Craig MAC CUB · Ogden, UTThe pilot’s failure to use carburetor heat during the flight, which resulted in a partial loss of engine power due to carburetor icing.NTSB WPR16FA036Accident · 2 fatalClass 3 · FieldFinal reportBarnett Allen S RV7 · Hurricane, UTThe pilot’s aerobatic maneuver leading to airspeeds above the airplane’s never exceed speed, which resulted in rudder flutter and an in-flight breakup.NTSB GAA15CA258Accident · No injuriesData collectionFinal reportAirbus AS350 · Draper, UTThe ground recovery team member's failure to secure a rescue rope during the helicopter loading process in steep terrain, resulting in the rope fouling the helicopter's main rotor system.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 WPR14CA228Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Leeds, UTThe pilot's failure to confirm the flaps had been retracted during takeoff, which resulted in a loss of lift and subsequent collision with terrain.NTSB WPR14CA066Accident · No injuriesData collectionFinal reportMcdonnell Douglas Helicopter 369E · Monticello, UTThe passenger's accidental discharge of the net gun which resulted in the net going through a main rotor blade.NTSB WPR10LA092Accident · No injuriesLimited investigationFinal reportCessna 402C · Moab, UTThe pilot's decision to depart on a snow covered runway, which resulted in a loss of control and encounter with terrain. Contributing to the accident was the airport manager's failure to adhere to the Airport Certification Manual and close the runway due to…NTSB WPR10CA043Accident · Minor injuriesData collectionFinal reportCessna 120 · Mineral Canyon, UTThe pilot's incorrect use of brakes, which resulted in the airplane nosing over.NTSB WPR09LA261Accident · No injuriesLimited investigationFinal reportEnstrom Helicopter 280C · Ogden, UTThe pilot's improper use of the helicopter's collective both during the takeoff sequence and while attempting remedial action in response to an engine over-boost condition, which resulted in a hard precautionary landing.