NTSB investigations, MN
13 cases where NTSB found Angle of attack.
Cases per year
| 2009 | 1 |
|---|---|
| 2014 | 3 |
| 2015 | 3 |
| 2017 | 1 |
| 2020 | 1 |
| 2023 | 2 |
| 2024 | 2 |
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\" = 'MN' 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" = 'MN' 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 CEN24LA207Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus SR20 · Aitkin, MNThe pilot’s failure to maintain adequate airspeed, which resulted in a loss of airplane control during the go-around. Contributing to the accident was the pilot’s failure to properly configure the airplane’s flaps during the go-around.NTSB CEN24FA125Accident · 2 fatalClass 3 · FieldFinal reportGlobe GC-1B · Afton, MNThe pilot’s failure to maintain airplane control while maneuvering, which resulted in an aerodynamic stall and spin.NTSB CEN23FA248Accident · 2 fatalClass 3 · FieldFinal reportAeronca 7CCM · Duluth, MNThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed, which resulted in an aerodynamic stall and loss of control.NTSB CEN23LA092Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Eden Prairie, MNThe student pilot exceeded the airplane's critical angle of attack, resulting in an aerodynamic stall and ground impact.NTSB CEN21LA101Accident · No injuriesClass 3 · LimitedFinal reportBeech 65-A80-8800 · Alexandria, MNThe pilot’s decision to attempt takeoff with frost covering the airplane and rotating below the published rotation speed, which led to exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB GAA18CA092Accident · Minor injuriesData collectionFinal reportPiper PA28 · Mankato, MNThe student pilot’s improper landing flare, which resulted in a hard, bounced landing and subsequent go-around during which the student exceeded the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA16CA050Accident · No injuriesData collectionFinal reportCessna 182Q · Bowstring, MNThe pilot exceeded the critical angle of attack during takeoff which resulted in an aerodynamic stall and impact with a wind sock and terrain.NTSB CEN15FA321Accident · 3 fatalField investigationFinal reportChristensen Steve Wheeler Express · Holland, MNThe pilot’s failure to maintain adequate airspeed during a high-pitch, steep right turn, which resulted in the exceedance of the airplane’s critical angle-of-attack and a subsequent aerodynamic stall, loss of control, and impact with terrain. Contributing to…NTSB CEN15FA181Accident · 2 fatalField investigationFinal reportPiper J-4A · Pine River, MNThe pilot' failure to maintain adequate airspeed after takeoff, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the pilot's decision to conduct the flight…NTSB CEN15CA036Accident · Minor injuriesData collectionFinal reportFlight Design CTLSi · White Bear Lake, MNThe pilot's exceedance of the airplane's critical angle of attack during the landing, which resulted in an inadvertent aerodynamic stall, a hard landing, and a nose over.NTSB CEN14LA320Accident · No injuriesLimited investigationFinal reportCessna 172XP · St. Cloud, MNThe pilot's failure to maintain the proper airspeed and angle-of-attack after a partial loss of engine power on takeoff, which resulted in a stall and the subsequent impact with water. Contributing to the accident was the partial loss of engine power due to…NTSB CEN14LA279Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Sauk Centre, MNThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s failure to retract the flaps after beginning the go-around.NTSB CEN09LA224Accident · Serious injuriesLimited investigationFinal reportTaylorcraft F19 · Lake Vermillion, MNThe pilot's failure to maintain proper pitch control resulting in a stall/spin.