NTSB investigations, 2011
12 cases where NTSB found Angle of attack.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 10 |
| 2010 | 3 |
| 2011 | 12 |
| 2012 | 7 |
| 2013 | 30 |
| 2014 | 71 |
| 2015 | 87 |
| 2016 | 98 |
| 2017 | 83 |
| 2018 | 100 |
| 2019 | 104 |
| 2020 | 69 |
| 2021 | 74 |
| 2022 | 75 |
| 2023 | 66 |
| 2024 | 52 |
| 2025 | 33 |
| 2026 | 14 |
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 year(c.\"eventDate\") = 2011
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 year(c."eventDate") = 2011 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 DCA12CA023Accident · No injuriesData collectionFinal reportUniversity Of Kansas Meridian · McMurdo, AYan aerodynamic stall induced by an inadvertent autopilot Home command. The Home command was entered following a loss of the direct radio link due to improperly set failsafe settings, and an unintentional latching of Home mode from an earlier functionality…NTSB WPR11FA404Accident · Serious injuriesField investigationFinal reportCessna 150G · Cavanaugh Bay, IDThe pilot’s failure to maintain adequate airspeed during an attempt to execute a go-around with a tailwind condition, which resulted in an aerodynamic stall and spin.NTSB WPR11FA390Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Forsyth, MTThe pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in a stall/mush, loss of control, and impact with terrain.NTSB ERA11CA460Accident · No injuriesData collectionFinal reportMooney M20R · West Chester, PAThe pilot did not maintain adequate airspeed during a go-around, which resulted in an aerodynamic stall.NTSB CEN11LA571Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Uvalde, TXThe pilot’s failure to maintain airspeed while maneuvering to avoid power lines during a precautionary landing, which resulted an aerodynamic stall. Contributing to the accident was the fluctuating engine power for undetermined reasons and the pilot's…NTSB CEN11FA531Accident · 1 fatalField investigationFinal reportEdwards Douglas L SKY Ranger · Wautoma, WIThe pilot’s failure to maintain proper airspeed and attitude control of the airplane in the turn, which resulted in an aerodynamic stall.NTSB CEN11CA502Accident · No injuriesData collectionFinal reportCessna A188B · Devils Lake, NDThe pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in a stall during the aerial application.NTSB WPR11FA316Accident · 4 fatalField investigationFinal reportMooney M20F · Watsonville, CAThe pilot's decision to take off toward a nearby low cloud layer and the subsequent turn, stall, and spin during the pilot’s attempt to avoid the cloud layer. Contributing to the accident was the pilot's failure to avoid the stall. His ability to avoid the…NTSB CEN11CA453Accident · Serious injuriesData collectionFinal reportPowrachute Airwolf 912 · Oconto, WIThe powered parachute pilot's decision to execute an in-flight full-flare which resulted in exceeding the angle of attack capabilities of the parachute wing, and subsequent inadvertent stall.NTSB WPR11CA231Accident · No injuriesData collectionFinal reportLet L 33 Solo · Sparks, NVThe pilot’s failure to maintain an adequate airspeed during landing, which resulted in an aerodynamic stall.NTSB WPR11CA196Accident · No injuriesData collectionFinal reportCessna T188C · Palouse, WAThe pilot's inadequate evaluation of the wind conditions at takeoff and failure to maintain an adequate airspeed, which resulted in a stall and collision with terrain during the initial climb.NTSB DCA11MA076Accident · 4 fatalClass 1 · MajorFinal reportGulfstream GVI · Roswell, NMThe National Transportation Safety Board determines the probable cause(s) of this accident as follows: an aerodynamic stall and subsequent uncommanded roll during a one engine-inoperative takeoff flight test, which were the result of (1) Gulfstream’s failure…