NTSB investigations, UT
22 cases where NTSB found Angle of attack.
Cases per year
| 2008 | 1 |
|---|---|
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 3 |
| 2022 | 2 |
| 2023 | 3 |
| 2024 | 2 |
| 2026 | 1 |
Where
Latest 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\", '01062042'))
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", '01062042')) 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 WPR26LA174Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Big Water, UTThe pilot’s failure to maintain adequate airspeed and exceedance of the airplanes critical angle of attack while maneuvering at a low altitude, which resulted in a subsequent stall and impact with trees during stall recovery.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 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 WPR24FA010Accident · 1 fatalClass 3 · FieldFinal reportRobert L Thurmond RV8 · Centerville, UTThe pilot’s exceedance of the airplane’s critical angle of attack while attempting to return to the departure airport, which resulted in an aerodynamic stall at an altitude too low for recovery. Contributing to the accident was the failure of the No. 2…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 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 WPR22LA080Accident · Serious injuriesClass 3 · LimitedFinal reportWalter Tachiki Tachiki 750 Cruzer · Spanish Fork, UTA partial loss of engine power due to an obstructed catalytic converter, which most likely resulted from the pilot’s failure to properly repair or replace it after it was likely damaged during a previous incident. Contributing to the accident was the pilot’s…NTSB WPR20LA258Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Hanna, UTThe pilot’s failure to maintain sufficient airspeed after a partial loss of power for undetermined reasons, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall from which the pilot could not recover.NTSB WPR20LA238Accident · 5 fatalClass 3 · LimitedFinal reportPiper PA32R · West Jordan, UTThe pilot's failure to maintain the airplane’s speed during takeoff near the airplane’s maximum gross weight in high-density altitude conditions, which resulted in the exceedance of the airplane's critical angle of attack and led to an aerodynamic stall, loss…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 GAA19CA374Accident · Minor injuriesData collectionFinal reportVans RV 6 · Monument Valley, UTThe pilot's exceedance of the airplane's critical angle of attack during the aborted landing, which resulted in an aerodynamic stall.NTSB GAA19CA301Accident · No injuriesData collectionFinal reportLuscombe 8 · Heber, UTThe pilot's exceedance of the airplane's critical angle of attack during an aborted landing, which resulted in an aerodynamic stall.NTSB WPR18FA186Accident · 1 fatalClass 3 · FieldFinal reportCessna 320 · Eagle Mountain, UTThe pilot's exceedance of the airplane's critical angle of attack and the airplane experiencing an aerodynamic stall at too low an altitude to recover.NTSB GAA18CA358Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · Spanish Fork, UTThe pilot receiving instruction’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB GAA17CA327Accident · No injuriesData collectionFinal reportCessna 172 · Tooele, UTThe student pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in an aerodynamic stall.NTSB WPR16FA144Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA40 F · Logan, UTThe pilot's exceedance of the airplane's critical angle of attack while maneuvering in turbulence and gusty wind conditions, which resulted in an aerodynamic stall/spin.NTSB WPR16FA002Accident · 2 fatalField investigationFinal reportCessna 152 · Cedar City, UTThe failure of the pilots to maintain control of the airplane while maneuvering, which resulted in an aerodynamic stall from which they did not recover.NTSB GAA15CA257Accident · No injuriesData collectionFinal reportGlenn Timothy C Skystar Series 5 · Green River, UTThe pilot's failure to maintain pitch attitude, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall/spin.NTSB WPR14LA263Accident · 1 fatalLimited investigationFinal reportKnell ASC Spirit · Lehi, UTThe pilot’s exceedance of the glider’s critical angle of attack while maneuvering in a steep turn at low altitude, which resulted in an aerodynamic stall.NTSB WPR14FA252Accident · 1 fatalField investigationFinal reportCessna 175 · Moab, UTThe pilot’s decision to approach rising mountainous terrain at too low an altitude to clear it and his subsequent attempt to climb, which exceeded the airplane’s critical angle-of-attack and resulted in a stall/spin.NTSB WPR09LA026Accident · 2 fatalLimited investigationFinal reportSilfvast Starduster TOO · Cedar Fort, UTThe pilot's failure to maintain an adequate airspeed and/or angle of attack to avoid a stall/spin during an aerobatic maneuver.