# Major NTSB investigations, Outside the U.S.

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 DCA13MA081](https://openairdocs.org/ntsb/DCA13MA081.md): Boeing 747-400 BCF · Bagram, Afghanistan · Accident · 7 fatal · Class 1 · Major · Final report · Apr 29, 2013 · N949CA · Destroyed
  > National Airlines' inadequate procedures for restraining special cargo loads, which resulted in the loadmaster's improper restraint of the cargo, which moved aft and damaged hydraulic systems Nos. 1 and 2 and horizontal stabilizer drive mechanism components,…
- [NTSB IAD05FA023](https://openairdocs.org/ntsb/IAD05FA023.md): CASA 212-200-CC · Bamiyan, Afghanistan · Accident · 6 fatal · Class 1 · Field · Final report · Nov 27, 2004 · N960BW · Destroyed
  > the captain's inappropriate decision to fly a nonstandard route and his failure to maintain adequate terrain clearance, which resulted in the inflight collision with mountainous terrain. Factors were the operator's failure to require its flight crews to file…
- [NTSB MIA03FA141](https://openairdocs.org/ntsb/MIA03FA141.md): Cessna 402C · Treasure Cay, Bahamas · Accident · 2 fatal · Class 1 · Field · Final report · Jul 13, 2003 · N314AB · Substantial damage
  > the in-flight failure of the right engine and the pilot’s failure to adequately manage the airplane’s performance after the engine failed. The right engine failure resulted from inadequate maintenance that was performed by Air Sunshine’s maintenance personnel…
- [NTSB DCA02MA039](https://openairdocs.org/ntsb/DCA02MA039.md): McDonnell Douglas MD-11 · Subic Bay, Philippines · Accident · No injuries · Major investigation · Final report · Jun 3, 2002 · N588FE · Substantial damage
  > The momentary operation of the airplane outside of the airplane's aerodynamic design stall buffet boundary that resulted from the captain's initiation of a Ground Proximity Warning System (GPWS) escape maneuver. Factor's contributing to the accident were the…
- [NTSB DCA02MA042](https://openairdocs.org/ntsb/DCA02MA042.md): McDonnell Douglas MD-11F · Subic Bay, Philippines · Accident · No injuries · Major investigation · Final report · Jun 2, 2002 · N601FE · Substantial damage
  > The failure of the lower outboard nut and bolt assembly of the left inboard flap's outboard hinge that resulted from stress corrosion cracking and fatigue. Factors contributing to the accident were the inadequate materials specification of the bolt, and…
- [NTSB DCA93RA060](https://openairdocs.org/ntsb/DCA93RA060.md): Douglas DC-8-61 · Guantanamo Bay, Cuba · Accident · Serious injuries · Class 1 · Foreign · Aug 18, 1993 · N814CK · Destroyed
- [NTSB DCA81AA003](https://openairdocs.org/ntsb/DCA81AA003.md): Boeing 727 · Yap, Micronesia · Accident · Serious injuries · Closed · Nov 21, 1980 · N18479 · Destroyed
- [NTSB MIA80AA011](https://openairdocs.org/ntsb/MIA80AA011.md): Douglas DC-10 · Luxemburg, Georgia · Incident · No injuries · Closed · Nov 11, 1979 · XA-DUH · Minor damage
- [NTSB DCA74AZ016](https://openairdocs.org/ntsb/DCA74AZ016-79463.md): Boeing 707 · Pago Pago, Antarctica · Accident · 96 fatal · Closed · Jan 30, 1974 · N454PA · Destroyed
- [NTSB DCA71IZ001](https://openairdocs.org/ntsb/DCA71IZ001.md): Boeing 747 · St.Jean, Canada · Incident · No injuries · Closed · Aug 17, 1970 · F-BPVD · Minor damage
- [NTSB DCA71AZ002](https://openairdocs.org/ntsb/DCA71AZ002-79683.md): Douglas DC-8 · Naha Ab, JA · Accident · 4 fatal · Closed · Jul 27, 1970 · N785FT · Destroyed

## 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."eventCountry" <> 'USA'
  AND (c.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?major=1&state=OF

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