NTSB investigations, 2022
13 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\") = 2022
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") = 2022 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 DCA23WA083OccurrenceClass 5 · ForeignBoeing 777 · Rosario, Santa Fe, ArgentinaNTSB CEN23LA032Accident · No injuriesClass 4 · LimitedFinal reportMulholland Robert A Vans RV-7 · Englewood, COAn encounter with windshear during the initial climb after takeoff, which resulted in a loss of control. Contributing to the accident was the pilot’s improper decision to takeoff with a tailwind.NTSB WPR23LA019Accident · No injuriesClass 4 · LimitedFinal reportProgressive Aerodyne SeaRey · Lake Isabel, WAThe pilot’s loss of airplane control after an encounter with windshear during takeoff which, resulted in a hard water landing.NTSB ERA22LA404Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SF50 · Saint Cloud, FLThe pilot’s continuation of the instrument approach into known extreme precipitation and turbulence associated with a thunderstorm, resulting in excessive altitude deviations that required him to activate the Cirrus Airframe Parachute System.NTSB CEN22LA417Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Delta Junction, AKThe pilot’s decision to depart during high, gusty wind conditions which resulted sink and subsequent impact with terrain.NTSB WPR22LA342Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Salt Lake City, UTThe airplane’s encounter with a microburst during initial climb that resulted in a loss of altitude and subsequent collision with a tree.NTSB ERA22LA395Accident · 1 fatalClass 3 · LimitedFinal reportDiamond Aircraft Industries DA 42 · Orlando, FLThe flight crew’s insufficient evaluation of the deteriorating weather conditions in the area, which resulted in an encounter with a microburst.NTSB CEN22LA382Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Kahului, HIThe pilot’s inadequate compensation for gusting winds while maneuvering on the ground.NTSB CEN22LA380Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · McCarthy, AKThe pilot’s failure to maintain control of the airplane during takeoff in turbulent weather conditions.NTSB ERA22FA354Accident · 1 fatalClass 3 · FieldFinal reportPiper J3C-65 · Cynthiana, KYThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall while maneuvering to land with approaching convective activity.NTSB WPR22LA251Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 208B · Salt Lake City, UTThe pilot’s inability to maintain control of the airplane when it encountered a microburst during a landing attempt and a go-around near known thunderstorm activity. Contributing to the accident was an inadequate amount of wind sensors and wind shear…NTSB ERA22LA300Accident · Minor injuriesClass 4 · LimitedFinal reportCessna A185F · Plymouth, CTThe pilot’s encounter with known and forecast adverse weather which resulted in a collision with trees during the initial climb.NTSB CEN22LA110Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Fort Carson, COThe windshear encounter on short final approach, which resulted in an excessive decent rate and ground impact.