NTSB investigations, 2012
11 cases where NTSB found Wind, general.
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 16 |
| 2010 | 8 |
| 2011 | 11 |
| 2012 | 11 |
| 2013 | 4 |
| 2014 | 4 |
| 2015 | 5 |
| 2016 | 10 |
| 2017 | 5 |
| 2018 | 4 |
| 2019 | 4 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 3 |
| 2023 | 7 |
| 2024 | 1 |
| 2025 | 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 year(c.\"eventDate\") = 2012
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03034000'))
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") = 2012 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03034000')) 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 CEN13CA090Accident · No injuriesData collectionFinal reportCessna 172N · McKinney, TXThe pilot’s inadequate flare, which resulted in a hard nosewheel landing.NTSB ANC13CA002Accident · No injuriesData collectionFinal reportCessna U206F · Buckland, AKThe pilot's loss of airplane control during final approach in gusty wind conditions.NTSB CEN12CA499Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Hutchinson, KSThe pilot’s loss of directional control during the landing roll.NTSB CEN12LA427Accident · Serious injuriesLimited investigationFinal reportMurray Richard F Aircam BY Lockwood · Taos, NMThe pilot's decision to fly in gusty wind conditions at low altitude over mountainous terrain contrary to guidance in the airplane flight manual and subsequent loss of airplane control due to wind and turbulence.NTSB CEN12CA413Accident · Serious injuriesData collectionFinal reportCessna 182K · Newark, OHThe pilot's loss of control during taxi in strong wind conditions.NTSB CEN12CA391Accident · No injuriesData collectionFinal reportLuscombe 8A · Mexico, MOThe airplane's encounter with a downdraft during the landing flare, which resulted in a hard landing.NTSB CEN12CA295Accident · Minor injuriesData collectionFinal reportFlight Design Ctls · Moorhead, MNThe failure to maintain adequate airspeed for the wind conditions during landing, which resulted in a loss of airplane control.NTSB CEN12LA258Accident · Minor injuriesLimited investigationFinal reportBell 206B · Amarillo, TXThe pilot's failure to maintain helicopter control during landing in gusty wind conditions associated with a thunderstorm, which resulted in a loss of tail rotor effectiveness.NTSB CEN12FA188Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Mexico, MOThe pilot’s failure to maintain airplane control during takeoff, which resulted in an aerodynamic stall and subsequent collision with trees. Contributing to the accident was the pilot’s inadequate preflight performance planning before departing on the soft,…NTSB CEN12CA264Accident · No injuriesData collectionFinal reportAir Tractor AT-301A · Cheyenne Wells, COThe pilot’s inadequate compensation for the wind conditions during takeoff.NTSB WPR12CA118Accident · No injuriesData collectionFinal reportEurocopter AS 350 B3 · Poway, CAThe pilot's inadequate compensation for wind conditions during landing, which resulted in a hard landing.