NTSB investigations, 2025
7 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\") = 2025
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") = 2025 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 DCA26WA043AccidentClass 5 · ForeignBoeing 737 · Tomakomai, JapanNTSB DCA26WA004IncidentClass 5 · ForeignBoeing 777 · Nassau, BahamasNTSB WPR25LA235Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Kamiah, IDThe pilot’s loss of airplane control following an encounter with a microburst during takeoff.NTSB WPR25LA152Accident · No injuriesClass 3 · LimitedPreliminary reportDehavilland DHC-6-300 · Boulder City, NVOn May 6, 2023, about 1450 Pacific daylight time, a DeHavilland DHC-6-300, N142SA, was substantially damaged when it was involved in an accident near Boulder City, Nevada. The 2 pilots and 11 passengers were not injured. The airplane was operated as a Title…NTSB ERA25FA195Accident · 1 fatalClass 3 · FieldPreliminary reportFFF Express 2000 FT · Polk, OHOn May 5, 2025, about 1940 eastern daylight time, an experimental, amateur-built FFF LLC Express 2000 FT airplane, N519EA, was substantially damaged when it was involved in an accident near Polk, Ohio. The pilot was fatally injured. The airplane was operated…NTSB DCA25LA197Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737 · Centerville, TNAn encounter with hail during descent.NTSB DCA25WA151Incident · Serious injuriesClass 5 · ForeignBoeing 777 · Truscot-Mungalalu, Australia