NTSB investigations, 2011
10 cases where NTSB found Sudden wind shift.
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 5 |
| 2010 | 6 |
| 2011 | 10 |
| 2012 | 11 |
| 2013 | 4 |
| 2014 | 13 |
| 2015 | 3 |
| 2016 | 5 |
| 2017 | 6 |
| 2018 | 2 |
| 2019 | 5 |
| 2020 | 4 |
| 2021 | 5 |
| 2022 | 3 |
| 2023 | 6 |
| 2024 | 6 |
| 2025 | 7 |
| 2026 | 3 |
Where
Open the mapLatest 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\", '03034010'))
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", '03034010')) 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 ERA12CA040Accident · No injuriesData collectionFinal reportEngineering & Research 415-C · Mebane, NCThe pilot's delay in aborting the takeoff.NTSB ANC11CA113Accident · No injuriesData collectionFinal reportPiper PA-12 · Talkeetna, AKThe pilot’s decision to take off from an off-airport site in variable wind.NTSB ANC11CA102Accident · No injuriesData collectionFinal reportCessna 180 · Ambler, AKThe pilot's decision to takeoff with a tailwind, which resulted in a runway excursion.NTSB ANC11CA081Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Valdez, AKThe pilot's failure to maintain the proper approach path, which resulted in a runway undershoot.NTSB CEN11LA579Accident · No injuriesLimited investigationFinal reportCessna 180 · Stillwater, OKThe pilot's on-ground loss of control during the landing roll upon encountering a sudden wind shift and gust.NTSB CEN11CA354Accident · No injuriesData collectionFinal reportHenry Slosing Lanceair · Albuqurque, NMThe pilot’s loss of directional control while landing in gusty conditions.NTSB ERA11CA303Accident · No injuriesData collectionFinal reportChampion 7EC-703 · Moultonboro, NHThe pilot’s loss of directional control during the landing rollout, which resulted in a collision with trees.NTSB CEN11CA268Accident · Minor injuriesData collectionFinal reportCub Crafters CC11-160 · Kiowa, COThe pilot's failure to maintain directional control following a hard landing.NTSB CEN11CA166Accident · No injuriesData collectionFinal reportMcholland C L Solitare · Wellington, COThe glider pilot’s misjudgment while approaching to land, which resulted in an off-airport landing.NTSB ANC11CA011Accident · No injuriesData collectionFinal reportMiller Gregory Scott GOT Rocks · Anchorage, AKThe pilot's selection of an unsuitable landing/takeoff area with an unfavorable wind.