# NTSB investigations, 2023: Air traffic event

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 OPS24LA011](https://openairdocs.org/ntsb/OPS24LA011.md): Diamond Aircraft Ind DA20-C1 · North Las Vegas, NV · Incident · No injuries · Class 4 · Limited · Final report · Dec 9, 2023 · N857PA · 2 aircraft · No damage
  > The local controller’s loss of situational awareness, inadequate provision of traffic advisory or safety alert information, and lack of positive control, that resulted in a near-midair collision.
- [NTSB OPS24LA004](https://openairdocs.org/ntsb/OPS24LA004.md): Airbus A321-271N · Long Beach, CA · Incident · Class 4 · Limited · Final report · Oct 27, 2023 · N216HA · 2 aircraft · No damage
  > The local controller’s poor judgment in prioritization of their ground traffic ahead of their airborne traffic, that became a distraction and led to a loss of situational awareness resulting in a near midair collision. Contributing to the incident was the…
- [NTSB DCA23WA480](https://openairdocs.org/ntsb/DCA23WA480.md): Boeing 737 · Stuttgart, Germany · Incident · Class 5 · Foreign · Oct 23, 2023 · TC-SOR · 2 aircraft · No damage
- [NTSB OPS23FA010](https://openairdocs.org/ntsb/OPS23FA010.md): Boeing 737-7BD · San Diego, CA · Incident · Class 4 · Field · Final report · Aug 11, 2023 · N7734H · 2 aircraft · No damage
  > The local control controller’s poor judgment in duty prioritization which distracted them from monitoring arriving and departing traffic and resulted in a runway incursion and loss of same runway separation. Contributing was the operations supervisor’s…
- [NTSB DCA23WA410](https://openairdocs.org/ntsb/DCA23WA410.md): Boeing 737 · Rio De Janeiro, Brazil · Incident · Class 5 · Foreign · Jul 28, 2023 · PR-GXM · No damage
- [NTSB DCA23LA395](https://openairdocs.org/ntsb/DCA23LA395.md): Airbus A320-214 · Fort Lauderdale, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 23, 2023 · N229NV · No damage
  > The flight crew’s abrupt change in pitch in response to a traffic collision advisory system resolution advisory that resulted in a serious injury to a flight attendant.
- [NTSB DCA23WA377](https://openairdocs.org/ntsb/DCA23WA377.md): Boeing 737 · Le Mans, France · Occurrence · Class 5 · Foreign · Jul 21, 2023 · EC-NGC · No damage
- [NTSB DCA23WA229](https://openairdocs.org/ntsb/DCA23WA229.md): Airbus A320 · Sao Paulo, Brazil · Occurrence · No injuries · Class 5 · Foreign · Mar 30, 2023 · PT-MZL · 2 aircraft · No damage
- [NTSB DCA23LA179](https://openairdocs.org/ntsb/DCA23LA179.md): Boeing 737-823 · Sarasota, FL · Incident · No injuries · Class 3 · Limited · Final report · Feb 17, 2023 · N976NN · 2 aircraft · No damage
  > The local controller’s failure to prioritize and properly monitor the runway and airport environment along with his erroneous assumption that ROU 1633 would depart from runway 14 before AAL2172 arrived to land on the same runway, which resulted in a loss of…

## 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") = 2023
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '100' 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/100/sequence?year=2023

---
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.