NTSB investigations, 2025
15 cases where the sequence of events included Near midair/TCAS alert/loss of separation.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 1 |
| 2010 | 8 |
| 2011 | 7 |
| 2012 | 1 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 4 |
| 2018 | 6 |
| 2021 | 5 |
| 2022 | 7 |
| 2023 | 6 |
| 2024 | 18 |
| 2025 | 15 |
| 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\") = 2025
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '260' 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" = '260' 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 DCA26WA025IncidentClass 5 · ForeignAirbus A321 · Amsterdam, NetherlandsNTSB DCA25WA342Incident · No injuriesClass 5 · ForeignBoeing 737 · Madrid, SpainNTSB DCA25LA306Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Industrie A320-212 · Chase City, VAThe abrupt maneuver required to comply with a traffic alert and collision avoidance system resolution advisory during descent.NTSB DCA25WA293IncidentClass 5 · ForeignBoeing 747-47UF · Abu Dhabi, United Arab EmiratesNTSB DCA25WA304IncidentClass 5 · ForeignBoeing 737 · Near MAR holding fix within Algiers TMA, AlgeriaNTSB OPS25LA052Incident · No injuriesClass 3 · LimitedPreliminary reportEmbraer-Empresa Brasileira De ERJ 170-200 LR · Minot, NDOn July 18, 2025, about 1948 central daylight time (CDT), WarBird03 (WBD03), a US Air Force (USAF) B-52H, enroute to conduct an aerial flyby at the North Dakota Fairgrounds, was involved with a loss of separation event approximately two miles south of Minot…NTSB DCA25WA302IncidentClass 5 · ForeignBoeing 737 · North/East sector of Algiers FIR, AlgeriaNTSB DCA25WA305Accident · Serious injuriesClass 5 · ForeignBoeing 737 · SeychellesNTSB DCA25WA207IncidentClass 5 · ForeignBoeing 777 · Mumbai, IndiaNTSB OPS25LA034IncidentClass 3 · LimitedPreliminary reportEmbraer ERJ 170-100 LR · Washington, DCOn May 1, 2025, about 1433 eastern daylight time (EDT), Priority Air Transport flight 23 (PAT23), (tail number forthcoming), a UH-60 Blackhawk helicopter landing at the Pentagon Heliport (JPN), and Republic Airways flight 5825 (RPA5825), an Embraer 170,…NTSB DCA25WA219IncidentClass 5 · ForeignBoeing 737 · Athens, GreeceNTSB ENG25WA035IncidentClass 5 · ForeignTecnam P2006T · Gran Canaria, SpainNTSB DCA25WA202IncidentClass 5 · ForeignBoeing 737-8 Max · Warsaw, PolandNTSB OPS25LA032IncidentClass 3 · LimitedPreliminary reportAirbus A319-114 · Arlington, VAOn March 28, 2025, about 1516 eastern daylight time (EDT), DRAGO61, a flight of four US Air Force Northrop T38s, enroute to conduct an aerial flyby at Arlington National Cemetery, and Delta (DAL) Air Lines flight 2983 (DAL2983), an Airbus 319-114, N342NB,…NTSB OPS25LA025IncidentClass 4 · LimitedInvestigation openBoeing 737-823 · Goodyear, AZ