NTSB investigations, AL
11 cases where NTSB found Gusts.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2012 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2023 | 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\" = 'AL' 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\", '03034045'))
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" = 'AL' 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", '03034045')) 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 ERA24LA083Accident · No injuriesClass 4 · LimitedFinal reportRabe Richard Exec 162F · Tuscumbia, ALThe pilot’s failure to maintain control of the helicopter, which resulted in the right skid contacting the ground and a subsequent rollover.NTSB ERA22LA197Accident · No injuriesClass 4 · LimitedFinal reportCessna 182R · Tuskegee, ALThe pilot’s inadequate compensation for the gusty crosswind wind conditions which resulted in a hard landing and subsequent nose gear collapse.NTSB ERA20CA116Accident · Serious injuriesData collectionFinal reportLet L 23 Super Blanik · Huntsville, ALThe pilot's failure to maintain glider control and his exceedance of the glider's critical angle of attack while maneuvering in gusting wind conditions, which resulted in an aerodynamic stall.NTSB GAA17CA220Accident · No injuriesData collectionFinal reportShilt Jerry C F-1 Rocket · Bessimer, ALThe pilot’s failure to maintain directional control during the landing rollout in gusting crosswind conditions.NTSB ERA16CA178Accident · No injuriesData collectionFinal reportChampion 7AC · Jasper, ALThe pilot's inadequate compensation for the wind which resulted in a loss of directional control at touchdown and collapse of the landing gear.NTSB GAA15CA213Accident · No injuriesData collectionFinal reportCessna A185F · Dauphin Island, ALThe pilot's loss of directional control during the landing roll in gusty wind conditions which resulted in a ground loop and impact with terrain.NTSB ERA15CA064Accident · Serious injuriesData collectionFinal reportPiper PA 28-180 · Athens, ALThe pilot's failure to maintain adequate altitude while landing in gusty wind conditions, which resulted in a collision with power lines while on final approach.NTSB ERA12CA390Accident · No injuriesData collectionFinal reportCessna 150H · Alabaster, ALThe pilot's failure to maintain directional control while landing in gusting wind conditions.NTSB ERA12CA199Accident · No injuriesData collectionFinal reportBell OH-58A · Eufaula, ALThe pilot's inadequate compensation for the gusting wind, which resulted in an excessive descent rate and hard landing.NTSB ERA10CA185Accident · Serious injuriesData collectionFinal reportShaw Fisher FP 404 · Lillian, ALThe pilot’s inadequate weather evaluation and failure to maintain directional control during takeoff in gusty wind conditions.NTSB MIA08CA165Accident · No injuriesData collectionFinal reportCessna 172S · Monroeville, ALThe pilot's inadequate compensation for winds during landing. Contributing to the accident was a wind gust.