# NTSB investigations, 2018: Oversight

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 WPR19LA010](https://openairdocs.org/ntsb/WPR19LA010.md): Piper PA46 · Hurricane, UT · Accident · Serious injuries · Limited investigation · Final report · Oct 21, 2018 · N413LL · Substantial damage
  > The mechanic’s failure to properly align the engine exhaust crossover pipe during replacement, and his supervisor’s failure to properly inspect the installation, which resulted in an in-flight fire and the loss of engine power.
- [NTSB ANC18FA053](https://openairdocs.org/ntsb/ANC18FA053.md): De Havilland DHC 3 · Hydaburg, AK · Accident · Serious injuries · Field investigation · Final report · Jul 10, 2018 · N3952B · Substantial damage
  > The pilot's decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.
- [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 DCA18IA092](https://openairdocs.org/ntsb/DCA18IA092.md): Boeing 777 222 · Honolulu, HI · Incident · No injuries · Incident investigation · Final report · Feb 13, 2018 · N773UA · Minor damage
  > the fracture of a fan blade due to P&W's continued classification of the TAI inspection process as a new and emerging technology that permitted them to continue accomplishing the inspection without having to develop a formal, defined initial and recurrent…

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

This list as a web page: https://openairdocs.org/ntsb-findings/040320/cases?year=2018

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
