# NTSB investigations, Outside the U.S.: In flight collision with terrain/water

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 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 IAD99GA036](https://openairdocs.org/ntsb/IAD99GA036.md): Mil MI-8MTV-1 · Hinche, Haiti · Accident · 13 fatal · Final report · Mar 15, 1999 · RA-25464 · Destroyed
  > The flightcrew's inability to maintain visual contact with mountainous terrain in night, instrument meteorological conditions. Contributing to the accident was a lack of preparation and support for difficult flight conditions, including lack of coordination…
- [NTSB LAX95LA190](https://openairdocs.org/ntsb/LAX95LA190.md): Stol UC-1 · Saipan, Sark · Accident · 3 fatal · Limited investigation · Final report · May 21, 1995 · N108CA · Destroyed
  > an inflight collision with the ocean for undetermined reasons.
- [NTSB ANC94GA041](https://openairdocs.org/ntsb/ANC94GA041.md): Grumman G21A · Mt. Fairweather, Canada · Accident · Minor injuries · Final report · Mar 21, 1994 · N741 · Substantial damage
  > The pilot's improper decision in attempting to outclimb the rising terrain with the existing airplane climb performance. Factors which contributed to the accident were: the pilot's inadequate preflight of the airplane, the over maximum gross weight of the…
- [NTSB LAX88FA045](https://openairdocs.org/ntsb/LAX88FA045.md): Cessna 441 · Mexicali, Mexico · Accident · 2 fatal · Field investigation · Final report · Nov 16, 1987 · N2484B · Destroyed
  > A Cessna 441 operated by the uscs collided with terrain while on a authorized night tactical flight. The copilot did not meet the currency standards as required by uscs and was not qualified in the acft. The flight originated during the daylight hours and…

## 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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=230&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.