# NTSB investigations: Availability of safety program

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 ERA18MA099](https://openairdocs.org/ntsb/ERA18MA099.md): American Eurocopter AS350B2 · New York, NY · Accident · 5 fatal · Class 1 · Major · Final report · Mar 11, 2018 · N350LH · Substantial damage
  > Liberty Helicopters Inc.'s use of a NYONair-provided passenger harness/tether system, which caught on and activated the floor-mounted engine fuel shutoff lever and resulted in the in-flight loss of engine power and the subsequent ditching. Contributing to…
- [NTSB DCA17FA109](https://openairdocs.org/ntsb/DCA17FA109.md): Short Bros. & Harland SD3 30 · Charleston, WV · Accident · 2 fatal · Field investigation · Final report · May 5, 2017 · N334AC · Substantial damage
  > the flight crew's improper decision to conduct a circling approach contrary to the operator's standard operating procedures (SOP) and the captain's excessive descent rate and maneuvering during the approach, which led to inadvertent, uncontrolled contact with…
- [NTSB DCA12PA049](https://openairdocs.org/ntsb/DCA12PA049.md): Israel Aircraft Industries F21-C2 · Fallon, NV · Accident · 1 fatal · Final report · Mar 6, 2012 · N404AX · Destroyed
  > fuel exhaustion following missed approaches due to deficient ATC handling under weather conditions which were significantly lower than forecast. The second missed approach may have been initiated due to limited pilot instrument proficiency. Contributing to…
- [NTSB CEN09FA086](https://openairdocs.org/ntsb/CEN09FA086.md): Bell 206L-4 · Sabine Pass, TX · Accident · 5 fatal · Field investigation · Final report · Dec 11, 2008 · N180AL · Destroyed
  > The pilot’s failure to maintain clearance from the water. Contributing to the accident was the inadvertent encounter with instrument meteorological conditions.

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

This list as a web page: https://openairdocs.org/ntsb-findings/04035010/cases

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