# NTSB investigations: Within group(s)/organization

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 ANC19FA019](https://openairdocs.org/ntsb/ANC19FA019.md): De Havilland DHC 2 · Metlakatla, AK · Accident · 2 fatal · Class 2 · Field · Final report · May 20, 2019 · N67667 · Substantial damage
  > The pilot’s inadequate compensation for a quartering tailwind during a water landing, which resulted in a loss of control and subsequent nose-over. Contributing to the accident was the company’s inadequate operational control of the flight release process,…
- [NTSB GAA15CA128](https://openairdocs.org/ntsb/GAA15CA128.md): Beech C23 · Long Beach, CA · Accident · No injuries · Data collection · Final report · Jun 19, 2015 · N24022 · Substantial damage
  > The pilot failed to maintain clearance from trees while maneuvering to land at night, which resulted in a collision with terrain/objects. A factor contributing to the accident was the lack of oversight by ATC; failing to insure that the fully operational VASI…
- [NTSB ERA13LA188](https://openairdocs.org/ntsb/ERA13LA188.md): Cessna 402C · Fort Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Apr 1, 2013 · VQ-TIN · Substantial damage
  > The disconnection of the nose landing gear actuator, which resulted in the subsequent collapse of the nose landing gear. Contributing to the accident was the repair station’s inadequate maintenance, postmaintenance inspection process, and oversight of the…
- [NTSB WPR11FA050](https://openairdocs.org/ntsb/WPR11FA050.md): Diamond Aircraft Ind DA20-C1 · Payson, UT · Accident · 2 fatal · Field investigation · Final report · Nov 17, 2010 · N978CT · Substantial damage
  > The pilots' failure to maintain adequate airspeed during a slow flight maneuver that resulted in a stall and spin, and the flight instructor’s delayed or improper remedial actions to recover from the spin. Contributing to the accident was the flight school’s…

## 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", '04025015'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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