# NTSB investigations, Outside the U.S.: Light condition

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 ERA20CA191](https://openairdocs.org/ntsb/ERA20CA191.md): Bell UH 1N · Baghdad, Iraq · Accident · Minor injuries · Class 4 · Data collection · Final report · May 10, 2020 · N12328 · Substantial damage
  > The flight crew's inadequate situational awareness and failure to maintain adequate clearance from a security barrier during a night takeoff.
- [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 ERA11WA086](https://openairdocs.org/ntsb/ERA11WA086.md): Eurocopter AS 350 B2 · Taltal, Chile · Accident · 1 fatal · Foreign investigation · Nov 6, 2010 · CC-AAN · Destroyed
  > On November 6, 2010, at 2330 universal coordinated time, a Eurocopter, AS 350 B2 helicopter, Chilean registration CC-AAN, collided with terrain while in low level cruise flight near Taltal, Chile. The flight was operated by Servicios y Transporte Aereos…

## 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '030360'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/030360/cases?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.