# NTSB investigations: Continental O-470R, TX

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 CEN16LA270](https://openairdocs.org/ntsb/CEN16LA270.md): Cessna 182J · Weatherford, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 19, 2016 · N2644F · Substantial damage
  > An electrical system malfunction for reasons that could not be determined, and the subsequent loss of engine power due to the loss of the electrical boost pumps. Also causal was the pilot's improper emergency action following the loss of engine power due to…
- [NTSB FTW02LA035](https://openairdocs.org/ntsb/FTW02LA035.md): Terry Zenith 801 · Manvel, TX · Accident · No injuries · Limited investigation · Final report · Nov 10, 2001 · N54RX · Substantial damage
  > loss of engine power while maneuvering for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW72FRA56](https://openairdocs.org/ntsb/FTW72FRA56.md): Cessna 182G · Hempstead, TX · Accident · No injuries · Closed · May 13, 1972 · N3434S · Substantial damage
- [NTSB FTW67F0649](https://openairdocs.org/ntsb/FTW67F0649.md): Cessna 182 · Briggs, TX · Accident · No injuries · Closed · May 3, 1967 · N3434S · Substantial damage

## 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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17071'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=17071&state=TX

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