# Major NTSB investigations: Part(s) separation from AC

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 DCA26MA024](https://openairdocs.org/ntsb/DCA26MA024.md): Mcdonnell Douglas MD-11F · Louisville, KY · Accident · 14 fatal · Class 1 · Major · Preliminary report · Nov 4, 2025 · N259UP · Destroyed
  > On November 4, 2025, about 1714 eastern standard time (EST), United Parcel Service (UPS) flight 2976, a Boeing (McDonnell-Douglas) MD-11F airplane, N259UP, was destroyed after it impacted the ground shortly after takeoff from runway 17R at Louisville Muhammad…
- [NTSB DCA24MA063](https://openairdocs.org/ntsb/DCA24MA063.md): Boeing 737-9 · Portland, OR · Accident · Minor injuries · Class 1 · Major · Final report · Jan 6, 2024 · N704AL · Substantial damage
  > the in-flight separation of the left mid exit door (MED) plug due to Boeing Commercial Airplanes’ failure to provide adequate training, guidance, and oversight necessary to ensure that manufacturing personnel could consistently and correctly comply with its…
- [NTSB DCA12MA020](https://openairdocs.org/ntsb/DCA12MA020.md): Eurocopter France AS350B2 · Las Vegas, NV · Accident · 5 fatal · Class 1 · Major · Final report · Dec 8, 2011 · N37SH · Destroyed
  > Sundance Helicopters’ inadequate maintenance of the helicopter, including (1) the improper reuse of a degraded self-locking nut, (2) the improper or lack of installation of a split pin, and (3) inadequate postmaintenance inspections, which resulted in the…

## 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 (c.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
  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
```

This list as a web page: https://openairdocs.org/ntsb-events/338/cases?major=1

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.