NTSB investigations, LA
10 cases where NTSB found Angle of attack.
Cases per year
| 2013 | 1 |
|---|---|
| 2015 | 2 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2021 | 1 |
| 2023 | 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\" = 'LA' 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" = 'LA' 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 CEN24FA010Accident · 2 fatalClass 3 · FieldFinal reportCessna 414 · Patterson, LAThe pilot’s failure to properly set the elevator trim before takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.NTSB CEN23LA331Accident · Minor injuriesClass 4 · LimitedFinal reportDavid Brown/U Balldin/T Morgan Zenith Stol CH701 · Arnaudville, LAThe pilot’s failure to maintain airspeed resulting in exceeding the airplane’s critical angle of attack and an aerodynamic stall. The low altitude at which the flight was conducted contributed to the outcome.NTSB CEN21LA399Accident · Serious injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P92 Echo Classic · Cotton Port, LAThe pilot exceeding the airplane’s critical angle of attack, resulting in an aerodynamic stall and subsequent loss of control during go-around after a bounced landing.NTSB CEN19FA164Accident · 2 fatalClass 3 · FieldFinal reportQuicksilver Sport 2S · Henderson, LAThe pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in the airplane exceeding its critical angle-of-attack and an aerodynamic stall. Contributing to the accident was the pilot’s diminished reaction times and flying performance…NTSB CEN18LA257Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Springhill, LAThe pilot’s exceedance of the airplane's critical angle of attack during an improper go-around procedure which resulted in an aerodynamic stall.NTSB GAA18CA335Accident · No injuriesData collectionFinal reportBeech A36 · Gilliam, LAThe pilot’s exceedance of the airplane’s critical angle of attack during a soft-field takeoff, which resulted in an aerodynamic stall.NTSB CEN17LA228Accident · Serious injuriesLimited investigationFinal reportThompson Angel Hawk II · Homer, LAA total loss of engine power due to the engine’s unresolved high operating temperatures, which resulted in failure of the distributor rotor and drive shaft, and the pilot’s failure to maintain airspeed during the subsequent forced landing, which resulted in…NTSB CEN15FA426Accident · 1 fatalField investigationFinal reportJones Ralph D Zodiac CH 601 HD · Ama, LAThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack following a loss of engine power for reasons that could not be determined based on available evidence, which resulted in an aerodynamic stall and…NTSB CEN15LA276Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Branch, LAAn exceedance of the airplane's takeoff/climb capability, which resulted in a stall during initial climb at an altitude that was too low for recovery.NTSB CEN13LA472Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Simmesport, LAThe pilot's failure to maintain proper airplane pitch control while maneuvering at an altitude that was too low for recovery.