# Final NTSB investigations: Reservoir, main

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 WPR20LA104](https://openairdocs.org/ntsb/WPR20LA104.md): Piper PA46 · San Jose, CA · Accident · No injuries · Class 3 · Limited · Final report · Feb 28, 2020 · N304LA · Substantial damage
  > The failure to properly service the hydraulic power pack prevented a normal landing gear extension. Contributing to the accident was the failure of the landing gear emergency release valve to function properly for reasons that could not be determined based on…
- [NTSB CEN19TA333](https://openairdocs.org/ntsb/CEN19TA333.md): Lancair Lancair 320 · Bolivar, MO · Accident · No injuries · Class 3 · Final report · Sep 25, 2019 · N52WL · Substantial damage
  > Inadequate maintenance of the airplane, which resulted in a lack of adequate hydraulic fluid, malfunction of the landing gear extension system, and the landing gear collapse on landing.
- [NTSB MIA08LA086](https://openairdocs.org/ntsb/MIA08LA086.md): Cessna 750 · New York, NY · Accident · No injuries · Limited investigation · Final report · Apr 4, 2008 · N750WM · Substantial damage
  > The co-pilot's failure to maintain directional control during the landing roll. Contributing to the accident was a loss of system A hydraulic fluid for undetermined reasons and the flight crew's failure to follow the checklist sequence.

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

This list as a web page: https://openairdocs.org/ntsb-findings/01022916/cases?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, except the copies of manufacturers’ service documents, which belong to their rights holders.
