# NTSB investigations: North American NAVION, LA

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 FTW94LA230](https://openairdocs.org/ntsb/FTW94LA230.md): North American Navion 4 · Dupont, LA · Accident · Serious injuries · Limited investigation · Final report · Jul 12, 1994 · N8648H · Substantial damage
  > The loss of engine power due to inadequate maintenance adjustment of accessory drive starter gear screws which disengaged in flight. Factors were the lack of suitable terrain for the forced landing and non compliance with the applicable service letter.
- [NTSB FTW76FRD24](https://openairdocs.org/ntsb/FTW76FRD24.md): Navion A · New Orleans, LA · Accident · No injuries · Closed · Dec 14, 1975 · N8884H · Substantial damage
- [NTSB FTW75FRJ37](https://openairdocs.org/ntsb/FTW75FRJ37.md): Navion A · Mansfield, LA · Accident · No injuries · Closed · Jun 15, 1975 · N8885H · Substantial damage
- [NTSB UNK64X0542](https://openairdocs.org/ntsb/UNK64X0542.md): Navion A · Baton Rouge, LA · Accident · No injuries · Closed · Feb 12, 1964 · N91437 · Destroyed

## 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" = 'LA' 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 ('6150130', '6150137'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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