# Final NTSB investigations, Outside the U.S.: Miscellaneous/other

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 DCA24LA293](https://openairdocs.org/ntsb/DCA24LA293.md): Boeing 747-4HQF · Istanbul, Türkiye · Accident · No injuries · Class 4 · Limited · Final report · Aug 17, 2024 · N782CK · Substantial damage
  > The fatigue failure of multiple hinge ribs associated with the right outboard aileron, which resulted in abnormal aileron movement and airframe vibration. Contributing to the failure was the mis-rigged condition of the right outboard aileron, which increased…
- [NTSB ERA19FA210](https://openairdocs.org/ntsb/ERA19FA210.md): Agusta AW139 · Big Grand Cay, Bahamas · Accident · 7 fatal · Class 2 · Field · Final report · Jul 4, 2019 · N32CC · Substantial damage
  > The pilots’ decision to takeoff over water in dark night conditions with no external visual reference, which resulted in spatial disorientation and subsequent collision with the water. Also causal was the pilots’ failure to adequately monitor their…
- [NTSB DCA13CA008](https://openairdocs.org/ntsb/DCA13CA008.md): Bombardier DHC-8-315 · Kabul, Afghanistan · Accident · No injuries · Data collection · Final report · Oct 17, 2012 · N800AW · Substantial damage
  > the captains ineffective management of the airplanes energy state during final approach and flare that resulted in a hard landing and tail strike at touchdown.

## 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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '900' 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/900/sequence?state=OF&status=final

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