NTSB investigations, 2024
11 cases where the sequence of events included Windshear or thunderstorm.
Cases per year
| 2008 | 17 |
|---|---|
| 2009 | 13 |
| 2010 | 9 |
| 2011 | 17 |
| 2012 | 21 |
| 2013 | 8 |
| 2014 | 17 |
| 2015 | 15 |
| 2016 | 10 |
| 2017 | 12 |
| 2018 | 8 |
| 2019 | 7 |
| 2020 | 5 |
| 2021 | 10 |
| 2022 | 13 |
| 2023 | 16 |
| 2024 | 11 |
| 2025 | 7 |
| 2026 | 8 |
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\") = 2024
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '390' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2024 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '390' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ANC24LA095Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Bettles, AKThe pilot’s failure to adequately compensate for shifting wind conditions, resulting in a hard landing.NTSB ANC24LA090Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18A 150 · Denali, AKFailure to maintain clearance from terrain due to the airplane’s encounter with windshear during takeoff.NTSB ANC24LA079Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Palmer, AKThe pilot's failure to follow the operator’s procedure manual and attempted to land at a remote landing zone in high wind conditions. Contributing factor was the pilot’s decision to not conduct a fly over of the landing site to determine wind condition which…NTSB ERA24LA344Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Cullman, ALThe pilot’s decision to depart in an area of developing convective weather, which resulted in an unanticipated wind shift during the initial climb after takeoff, a loss of climb performance, and the subsequent forced landing.NTSB WPR24FA257Accident · 7 fatalClass 3 · FieldFinal reportPilatus PC-12/47E · Recluse, WYThe pilot’s loss of control due to spatial disorientation while operating in instrument meteorological conditions, which resulted in an in-flight breakup. Contributing to the accident was the pilot’s distraction from the autopilot disconnecting due to an…NTSB WPR24LA247Accident · Minor injuriesClass 4 · LimitedFinal reportBell 407 · Stanley, IDA sudden wind shift which resulted in a rapid descent and subsequent dynamic rollover and collision into water.NTSB ERA24FA283Accident · 5 fatalClass 3 · FieldFinal reportPiper PA46 · Trout Creek, NYThe pilot’s loss of airplane control in flight due to spatial disorientation during a climb to cruise altitude in instrument meteorological conditions and turbulence, which resulted in the in-flight breakup of the airplane. Contributing to the accident was…NTSB ENG24WA040Incident · No injuriesClass 4 · ForeignAirbus A320 · Grafendorf bei Hartberg, AustriaNTSB ERA24FA217Accident · 3 fatalClass 3 · FieldFinal reportBeech V35 · Franklin, TNThe pilot’s flight into convective weather, which resulted in a loss of control due to spatial disorientation and a subsequent inflight breakup of the airplane. Contributing to the accident was the lack of accurate weather intensity depiction on the…NTSB CEN24FA160Accident · 1 fatalClass 3 · FieldFinal reportPiper PA 46-350P · Hartsburg, MOThe pilot’s encounter with convective weather conditions, which resulted in a loss of airplane control, the exceedance of the airplane’s never exceed speed, and the resulting overload failure of the horizontal stabilizer and subsequent failure of the…NTSB CEN24LA100Accident · No injuriesClass 3 · LimitedFinal reportBeechcraft BE58 · DeRidder, LAThe pilot’s encounter with heavy rain, hail, and severe turbulence associated with a thunderstorm, which resulted in substantial damage to the airplane.