NTSB investigations, 2026
9 cases where the defining event was Part(s) separation from AC.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 15 |
| 2010 | 14 |
| 2011 | 20 |
| 2012 | 15 |
| 2013 | 13 |
| 2014 | 13 |
| 2015 | 14 |
| 2016 | 22 |
| 2017 | 19 |
| 2018 | 18 |
| 2019 | 19 |
| 2020 | 12 |
| 2021 | 12 |
| 2022 | 13 |
| 2023 | 15 |
| 2024 | 19 |
| 2025 | 22 |
| 2026 | 9 |
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\" = '338')
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" = '338') 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 WPR27LA027Accident · No injuriesClass 3 · LimitedInvestigation openGame Composites GB1 Gamebird · Blue Diamond, NVNTSB CEN26LA318Accident · No injuriesClass 3 · LimitedPreliminary reportVans RV4 · Harrisonville, MOOn September 13, 2026, about 0930 central daylight time, a Vans Aircraft Inc, RV-4, N254MM, was substantially damaged when it was involved in an accident near Harrisonville, Missouri. The pilot and passenger were not injured. The airplane was operated as a…NTSB ERA26LA289Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Weston, CTThe in-flight opening of the engine cowling, which resulted in engine baffling separating from the airplane and impacting the right elevator.NTSB WPR26LA249Accident · No injuriesClass 3 · LimitedPreliminary reportAir Tractor AT-502B · Ogden, UTOn July 7, 2026, about 1259 mountain daylight time, an Air Tractor, Inc. AT-502B airplane, N647LA, was substantially damaged when it was involved in an accident near Ogden, Utah. The commercial pilot was not injured. The flight was conducted as a Title 14…NTSB ERA26FA239Accident · 1 fatalClass 3 · FieldPreliminary reportBlessing RV-3A · Lakeland, FLOn June 15, 2026, about 1955 eastern daylight time, an experimental amateur-built Van’s RV-3A, N696DB, was destroyed when it was involved in an accident near Lakeland, Florida. The pilot received fatal injuries. The airplane was operated as a Title 14 Code of…NTSB ERA26LA232Accident · No injuriesClass 3 · LimitedPreliminary reportNorth American SNJ-5C · Midland, VAOn June 6, 2026, about 0940 eastern daylight time, a North American SNJ-5C, N98RJ was substantially damaged when it was involved in an accident near Midland, Virginia. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB CEN26LA179Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 421C · Kirksville, MOOn May 4, 2026, about 1759 central daylight time, a Cessna 421C airplane, N6161X, was substantially damaged during an accident near Kirksville, Missouri. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB ERA26LA193Accident · No injuriesClass 4 · LimitedFinal reportBell UH1 · Enterprise, ALThe in-flight separation of a turn lock fastener stud, which resulted in substantial damage to one tail rotor blade.NTSB CEN26LA131Accident · No injuriesClass 4 · LimitedFinal reportQuad City Challenger · Van Burensburg, ILPropeller separation due to failure of the propeller attachment bolts.