# NTSB investigations: Cessna 337A, AR

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 FTW83LA325](https://openairdocs.org/ntsb/FTW83LA325.md): Cessna 337A · Oxford, AR · Accident · No injuries · Limited investigation · Final report · Jul 4, 1983 · N6302F · Substantial damage
  > Prior to starting on a round trip from manhattan, KS, the owner informed the plt that the fuel selector for the rear eng was inop & precluded selection of the aux fuel tank. For that reason, the plt did not use either aux fuel tank. After about 2.8 hrs on the…
- [NTSB FTW74FRJ18](https://openairdocs.org/ntsb/FTW74FRJ18-132527.md): Cessna 337 · Texarkana, AR · Accident · No injuries · Closed · Oct 19, 1974 · N6318F · 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" = 'AR' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2075704'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2075704&state=AR

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