# NTSB investigations: Aeroconver AEROVEE: Not determined, general

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 ERA22FA051](https://openairdocs.org/ntsb/ERA22FA051.md): Issitt Greg Sonex · Malone, FL · Accident · 1 fatal · Class 3 · Field · Final report · Nov 8, 2021 · N432SX · Substantial damage
  > An in-flight collision with a tree for reasons that could not be determined.
- [NTSB ERA15FA003](https://openairdocs.org/ntsb/ERA15FA003.md): Miller Raymond A Sonex Waiex · Palm Coast, FL · Accident · 1 fatal · Field investigation · Final report · Oct 3, 2014 · N461MM · Substantial damage
  > A total loss of engine power during cruise flight for reasons that could not be determined due to the postaccident condition of the engine and its associated fuel and ignition systems.
- [NTSB ERA13LA024](https://openairdocs.org/ntsb/ERA13LA024.md): Cashmer Philip M Sonex · Crossville, TN · Accident · Serious injuries · Limited investigation · Final report · Oct 16, 2012 · N198PC · Substantial damage
  > The pilot’s failure to maintain control of the airplane, which resulted in a low-altitude aerodynamic stall/spin. Contributing to the accident was a loss of engine power for reasons that could not be determined during postaccident examination and the pilot’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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('01401')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f."findingCode", '05000000')))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/05000000/cases?engine=01401

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