NTSB investigations, UT
146 cases where NTSB found Action/decision.
Cases per year
| 2008 | 12 |
|---|---|
| 2009 | 9 |
| 2010 | 17 |
| 2011 | 14 |
| 2012 | 9 |
| 2013 | 7 |
| 2014 | 9 |
| 2015 | 4 |
| 2016 | 4 |
| 2017 | 8 |
| 2018 | 4 |
| 2019 | 10 |
| 2020 | 6 |
| 2021 | 6 |
| 2022 | 6 |
| 2023 | 11 |
| 2024 | 5 |
| 2025 | 4 |
| 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0204'))
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", '0204')) 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 WPR25LA278Accident · Minor injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Rocky Ridge, UTThe flight instructor’s inadequate supervision and delayed remedial action during an unusual attitude recovery, which resulted in a descent into terrain.NTSB ANC25LA115Accident · No injuriesClass 4 · LimitedFinal reportCessna 182M · Kanab, UTThe pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR25LA173Accident · Minor injuriesClass 4 · LimitedFinal reportBell 407 · Bountiful, UTThe pilot’s improper decision to depart with inadequate clearance from a hangar door.NTSB WPR25LA142Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · West Jordan, UTThe pilot's failure to maintain directional control during takeoff. Contributing to the accident was the pilot inadvertently using a runway that resulted in a tailwind condition and the flight instructors delayed remedial action.NTSB WPR24FA313Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Provo, UTThe pilot's exceedance of the airplane’s critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and loss of control.NTSB DCA24LA245Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737 · Salt Lake City, UTDelta Air Lines flight 2046 flight crew's incorrect evaluation of the clearance between their airplane and Delta Air Lines flight 2046 as they turned onto a perpendicular taxiway.NTSB WPR24LA254Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-34-220T · Roy, UTThe flight instructor’s decision to shut down an engine on an extended leg of the airport traffic pattern, which led to a loss of performance and inability to maintain altitude.NTSB WPR24LA241Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Herriman, UTA hard landing following a total loss of engine power due to fuel starvation as a result of the improper idle setting of the helicopter’s engine. Contributing to the loss of engine power was the instructor’s reduction of engine power past that recommended by…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 WPR24FA035Accident · 2 fatalClass 3 · FieldFinal reportCessna 172G · Provo, UTThe pilot's exceedance of the airplane's critical angle of attack during a chandelle maneuver, which resulted in an aerodynamic stall and descent into trees and terrain. Contributing to the accident was the pilot’s decision to maneuver into a canyon and…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 WPR23LA329Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Kanab, UTThe pilot's decision to take off in high density altitude conditions, which resulted in a loss of control and subsequent impact with terrain.NTSB WPR23LA324Accident · No injuriesClass 4 · LimitedFinal reportDiamond DA20 · Fairfield, UTThe flight pilots improper fuel management, which resulted a total loss of engine power, and impact with terrain during an off-airport landing. Contributing to the accident was the flight instructor’s failure to follow the airplane checklist.NTSB WPR23LA308Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Ritchfield, UTThe pilot’s improper preflight planning that resulted in the loss of engine power due to fuel exhaustion.NTSB WPR23LA240Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Cedar Mountain, UTThe pilot’s decision to depart with a high density altitude, which degraded the airplane’s climb performance and resulted in an impact with trees.NTSB WPR23LA194Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CCX-2300 · Spanish Fork, UTThe pilot's decision to attempt an unfamiliar takeoff technique, his failure to maintain pitch control during takeoff, and his subsequent decision to retract flaps at a low altitude, which resulted in a descent into a building.NTSB WPR23LA114Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Ephraim, UTThe pilot’s improper landing flare and loss of directional control.NTSB WPR23LA103Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Porterville, UTThe pilot’s failure to maintain clearance from snow covered terrain while maneuvering at low altitude.NTSB WPR23FA083Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-34-220T · New Harmony, UTThe pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in a loss of airplane control due to spatial disorientation.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 WPR23LA032Accident · No injuriesClass 4 · LimitedFinal reportHonda HA-420 · Salt Lake City, UTThe pilot’s inadvertent attempt to takeoff on a left side of runway, rather than the centerline of runway, which resulted in a collision with runway edge lights during the night time takeoff.NTSB WPR22LA307Accident · No injuriesClass 4 · LimitedFinal reportRans S20 · Bountiful, UTThe pilot’s improper landing flare and subsequent loss of airplane control during a go-around when the airplane stalled and collided with the ground.NTSB WPR22FA227Accident · 2 fatalClass 3 · FieldFinal reportCessna 152 · Mendon, UTThe flight instructor’s failure to recover from a developed spin, which resulted in impact with terrain. Contributing to the accident was the flight instructor’s decision to enter the maneuver below the operator’s altitude limitation.NTSB WPR22LA208Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Fort Duchesne, UTThe pilot’s decision to takeoff from an unimproved surface which resulted in a collision with an object and the airplane nosing over.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 WPR22LA157Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Salt Lake City, UTThe student pilot’s failure to maintain lateral control and terrain clearance while hovering, and the flight instructor’s delayed remedial action which resulted in a dynamic rollover.NTSB WPR21LA334Accident · No injuriesClass 4 · LimitedFinal reportBellanca 17-30A · Hurricane, UTThe pilot's failure to extend the landing gearNTSB WPR21FA321Accident · 3 fatalClass 3 · FieldFinal reportCessna 182H · Bountiful, UTThe decision of both pilots to fly into a steep canyon, which resulted in the airplane being unable to maintain a sufficient altitude to clear rising terrain. Contributing to the accident was their delayed initial action in responding to the hazard, and their…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 WPR21FA211Accident · 2 fatalClass 3 · FieldFinal reportTextron 172S · Eden, UTThe flight instructor’s improper aeronautical decision-making, which led to an encounter with a downdraft at a low altitude in mountainous terrain and resulted in the instructor’s loss of airplane control and an impact with terrain.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 WPR21LA078Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Moab, UTThe pilot’s improper application of full throttle during takeoff, which resulted in loss of engine power due to an excessive fuel flow and overly rich fuel mixture.NTSB WPR21LA070Accident · 1 fatalClass 3 · LimitedFinal reportSilverLight AR-1 · Heber City, UTThe pilot’s failure to follow the procedures for takeoff in the Pilot Operating Handbook, which resulted in a loss of control and collision with the terrain. Contributing to the accident was the pilot’s failure to receive additional training in the gyroplane.NTSB WPR21LA155Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International RX 8 · St. George, UTThe pilot’s failure to maintain control of the balloon and a member of the ground crews entanglement with a tether rope, which resulted in a serious injury when they fell to the ground after the balloon unexpectedly ascended.NTSB WPR20CA305Accident · No injuriesClass 4 · Data collectionFinal reportDiamond DA20 · Fillmore, UTThe student pilot's improper landing flare and delayed remedial action to abort the landing, which resulted in a loss of aircraft control, runway excursion and impact 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 WPR20CA195Accident · Minor injuriesClass 4 · Data collectionFinal reportCapella XLS · Liberty, UTThe pilot's failure to maintain clearance from a fence post during the initial climb.NTSB WPR20CA158Accident · No injuriesClass 4 · Data collectionFinal reportCessna P210 · Heber City, UTThe pilots failure to switch the fuel pump to the 'OFF' position during landing, resulting in a loss of engine power and subsequent collision with a fence during landing. Contributing to the accident was a modified before landing checklist which omitted the…NTSB WPR20TA039Accident · Minor injuriesClass 3Final reportEnstrom F28 · Riverton, UTThe noncertificated pilot’s decision to operate a deregistered helicopter, which resulted in a component failure and subsequent loss of control and hard landing. Contributing to the accident was the lack of recent maintenance on the helicopter.NTSB WPR20LA024Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28R · Ogden, UTThe flight instructor’s failure to raise the landing gear using the alternate system, which resulted in a reduced climb rate and impact with an obstacle. Contributing to the accident was the flight instructor’s lack of understanding of the backup landing gear…NTSB WPR20LA029Accident · No injuriesClass 3 · LimitedFinal reportAgusta A109 · Salt Lake City, UTThe flight nurse’s inadvertent application of left anti-torque pedal during cruise flight, which resulted in a rapid yaw and pitch movement that caused the tail rotor blades to contact the tailboom.NTSB GAA20CA085Accident · No injuriesData collectionFinal reportPiper PA60 · Salt Lake City, UTThe pilot's failure to follow the taxiway centerline guide and his distraction due to adjusting the radio, which resulted in his failure to maintain clearance from a taxiway light after landing and while taxiing to a ramp.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 WPR19LA204Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 162 · Vernal, UTThe flight instructor's abrupt maneuver at an altitude too low for recovery, which resulted in impact with the runway.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 WPR19FA154Accident · 2 fatalClass 2 · FieldFinal reportCirrus SR22 · Grover, UTThe pilot's encounter with moderate to severe icing conditions during cruise flight, which resulted in structural icing and a subsequent loss of control. Contributing to the accident was the pilot’s decision to continue a flight route through known moderate…NTSB WPR19FA148Accident · 2 fatalClass 3 · FieldFinal reportRobinson R44 · Alpine, UTThe noninstrument-rated pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of control. Contributing to the accident was hypoxia due to the high altitude at which…NTSB WPR19CA072Accident · No injuriesData collectionFinal reportCessna R172 · Ogden, UTThe student pilot's failure to maintain the runway heading during a touch-and-go landing and the flight instructor's delayed remedial action, which resulted in the airplane departing the left side of the runway, impacting snow, and nosing over.NTSB GAA18CA553Accident · Minor injuriesData collectionFinal reportPiper PA28 · Spanish Fork, UTThe student pilot’s failure to maintain the runway heading during takeoff and the flight instructor’s decision to conduct primary flight instruction in an airplane without dual controls.