# NTSB investigations, 2024: Near midair/TCAS alert/loss of separation

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB DCA25WA089](https://openairdocs.org/ntsb/DCA25WA089.md): Boeing 737-832 · Belize City, Belize · Incident · No injuries · Class 5 · Foreign · Dec 19, 2024 · N3772H · 2 aircraft · No damage
- [NTSB DCA25WA087](https://openairdocs.org/ntsb/DCA25WA087.md): Sikorsky S-92A · Hammerfest, Norway · Incident · Class 5 · Foreign · Nov 4, 2024 · LN-ONY
- [NTSB DCA25WA017](https://openairdocs.org/ntsb/DCA25WA017.md): Boeing 737 · Tenerife, Spain · Incident · No injuries · Class 5 · Foreign · Oct 21, 2024 · EI-DYD · No damage
- [NTSB DCA24WA327](https://openairdocs.org/ntsb/DCA24WA327.md): Embraer ERJ190 · Mexico · Incident · Class 4 · Foreign · Sep 27, 2024 · XA-ACC
- [NTSB DCA24LA316](https://openairdocs.org/ntsb/DCA24LA316.md): Boeing 757-224 · Dunnigan, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 19, 2024 · N12125 · No damage
  > The abrupt pitch control input by the flight crew in response to a TCAS resolution advisory resulted in two serious passenger injuries.
- [NTSB DCA24WA308](https://openairdocs.org/ntsb/DCA24WA308.md): Boeing 737-8 · San Francisco, CA · Incident · Class 5 · Foreign · Sep 16, 2024 · N105JS · No damage
- [NTSB DCA24WA273](https://openairdocs.org/ntsb/DCA24WA273.md): Boeing 737 · Olandji, Chad · Incident · Class 5 · Foreign · Aug 12, 2024 · 9XR-WY · 2 aircraft · No damage
- [NTSB DCA24WA270](https://openairdocs.org/ntsb/DCA24WA270.md): Airbus A320 · Purani, Romania · Incident · Class 5 · Foreign · Aug 7, 2024 · TC-NBO · 3 aircraft · No damage
- [NTSB DCA24WA250](https://openairdocs.org/ntsb/DCA24WA250.md): Boeing 737 · Chicago, IL · Occurrence · Class 5 · Foreign · Jul 28, 2024 · EI-GZC · No damage
- [NTSB DCA24WA253](https://openairdocs.org/ntsb/DCA24WA253.md): Embraer ERJ190 · Ruston, LA · Incident · Class 5 · Foreign · Jul 25, 2024 · XA-AEP
- [NTSB DCA24WA209](https://openairdocs.org/ntsb/DCA24WA209.md): Airbus A321 · Muscat, Oman · Incident · Class 5 · Foreign · Jun 15, 2024 · ETD390 · 2 aircraft · No damage
- [NTSB DCA24WA307](https://openairdocs.org/ntsb/DCA24WA307.md): Boeing 787-8 · Madrid, Spain · Incident · Class 5 · Foreign · May 28, 2024 · N964AM · No damage
- [NTSB DCA24WA177](https://openairdocs.org/ntsb/DCA24WA177.md): Boeing 737 · Miho, Japan · Incident · No injuries · Class 5 · Foreign · Apr 7, 2024 · JA69AN · No damage
- [NTSB DCA24WA162](https://openairdocs.org/ntsb/DCA24WA162.md): Boeing 777 · Mumbai, India · Incident · Class 5 · Foreign · Mar 24, 2024 · 4XECB · 2 aircraft · No damage
- [NTSB DCA24WA107](https://openairdocs.org/ntsb/DCA24WA107.md): Boeing 737 · Tapachula, Mexico · Incident · Class 5 · Foreign · Feb 21, 2024 · XA-ADU · 2 aircraft · No damage
- [NTSB DCA24WA111](https://openairdocs.org/ntsb/DCA24WA111.md): Airbus A320-232 · Merida, Mexico · Incident · Class 5 · Foreign · Feb 18, 2024 · N589JB · No damage
- [NTSB DCA24WA096](https://openairdocs.org/ntsb/DCA24WA096.md): Boeing 777-3FX (ER) · Abu Dhabi, United Arab Emirates · Incident · No injuries · Class 5 · Foreign · Feb 10, 2024 · A6-ETP · No damage
- [NTSB DCA24WA106](https://openairdocs.org/ntsb/DCA24WA106.md): Airbus A319 · Barcelona, Spain · Incident · Class 5 · Foreign · Jan 8, 2024 · D-AGWD · 2 aircraft · No damage

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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") = 2024
  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
```

This list as a web page: https://openairdocs.org/ntsb-events/260/sequence?year=2024

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.