# NTSB investigations: Ayres S-2R: Loss of engine power(total) - nonmechanical

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 IAD01LA026](https://openairdocs.org/ntsb/IAD01LA026.md): Ayres S2R · Crewe, VA · Accident · No injuries · Limited investigation · Final report · Jan 14, 2001 · N222GK · Substantial damage
  > the loss of engine power due to the pilot's inadequate preflight planning and exhaustion of his fuel supply.
- [NTSB LAX89DVA01](https://openairdocs.org/ntsb/LAX89DVA01.md): Ayres S2R · Traver, CA · Accident · Serious injuries · Final report · Oct 12, 1988 · N3087D · Substantial damage
  > While spraying a cotton field the engine lost power. The pilot executed a forced landing in an open area but rollout continued into crops. The acft nosed over. Investigation revealed only unuseable fuel on board.
- [NTSB LAX82DA137](https://openairdocs.org/ntsb/LAX82DA137.md): Avres S-2R · Kettleman City, CA · Accident · No injuries · Final report · Apr 16, 1982 · N5672X · Substantial damage
  > The pilot stated that the fuel gauge was faulty so he flew by time. On the day of the accident the battery on the pilot's electric watch ran down. The pilot reported that the aircraft ran out of fuel and crashed in an open field with his watch still showing…

## 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.aircraft_model_code IN ('0970101', '0970113', '0970114')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=0970101&occurrence=353

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