# NTSB investigations: Vedeneyev M14P: Sys/Comp malf/fail (non-power)

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 CEN23LA081](https://openairdocs.org/ntsb/CEN23LA081.md): Pitts Model 12 · Conroe, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 14, 2023 · N512P · Substantial damage
  > The failure of the engine-driven fuel pump, which resulted in a total loss of engine power. Contributing to the failure of the fuel pump was an unknown non-ferrous metallic debris that was noted throughout the airplane’s fuel system.
- [NTSB CEN12LA298](https://openairdocs.org/ntsb/CEN12LA298.md): Pool Murphy Moose · Steamboat Springs, CO · Accident · Minor injuries · Limited investigation · Final report · May 12, 2012 · N223DH · Substantial damage
  > A locked left brake for reasons that could not be determined because independent observations of the postaccident condition of the airplane could not be performed, and the pilot’s subsequent loss of control.

## 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('63601')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '330'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/330/cases?engine=63601

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