NTSB investigations, 2026
7 cases where the defining event was Dragged wing/rotor/float/other.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 3 |
| 2010 | 5 |
| 2011 | 5 |
| 2012 | 4 |
| 2013 | 3 |
| 2014 | 7 |
| 2015 | 3 |
| 2016 | 2 |
| 2017 | 4 |
| 2018 | 1 |
| 2020 | 1 |
| 2021 | 5 |
| 2022 | 6 |
| 2023 | 4 |
| 2024 | 7 |
| 2025 | 5 |
| 2026 | 7 |
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\") = 2026
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '093')
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") = 2026 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '093') 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 ERA27LA015Accident · No injuriesClass 4 · LimitedInvestigation openCessna R172K · Jackman, MENTSB ERA26LA320Accident · No injuriesClass 3 · LimitedPreliminary reportHawker Beechcraft 400A · Newark, NJOn August 27, 2026, about 1625 eastern daylight time, a Hawker Beechcraft Corporation 400A airplane, N199TT, was substantially damaged when it was involved in an accident near Newark, New Jersey. The airline transport pilot and commercial pilot were not…NTSB WPR26LA278Accident · No injuriesClass 4 · LimitedFinal reportNeuberg Bill Glastar · Wills Point, TXThe pilot’s failure to maintain directional control during landing with a right crosswind, which resulted in the airplane’s impact with terrain.NTSB CEN26LA233Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Gregory, MIThe flight instructor’s improper planning during the simulated aborted launch which resulted in a touchdown on unsuitable terrain.NTSB CEN26LA153Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Arlington, TXThe pilot’s failure to maintain clearance from terrain during the hover taxi.NTSB ERA26LA148Accident · No injuriesClass 4 · LimitedFinal reportCessna 208 · North Canton, OHThe flight instructor’s decision to conduct a training flight in strong, gusting crosswinds, which resulted in the airplane’s right wing impacting the ground during taxi.NTSB ERA26FA115Accident · 1 fatalClass 3 · FieldPreliminary reportCessna A185 · Everglades City, FLOn February 15, 2026, about 1155 eastern standard time, a Cessna A185F, N7574N, was substantially damaged when it was involved in an accident near Everglades City, Florida. The pilot was seriously injured, and the passenger was fatally injured. The airplane…