# NTSB investigations: North American NAVION, NM

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 CEN16LA234](https://openairdocs.org/ntsb/CEN16LA234.md): North American Navion · Alamogordo, NM · Accident · No injuries · Limited investigation · Final report · Jun 24, 2016 · N91137 · Substantial damage
  > The failure of the No. 5 exhaust valve key spring, which resulted in a total loss of engine power.
- [NTSB DEN87LA079](https://openairdocs.org/ntsb/DEN87LA079.md): North American Navion · Los Alamos, NM · Accident · No injuries · Limited investigation · Final report · Apr 3, 1987 · N91735 · Substantial damage
  > The instructor plt was giving cross wind instruction to a pre-solo student plt. During a cross wind landing attempt, the acft touched down hard, breaking off the right main landing gear. The winds were observed at the time of touchdown to be 150 degrees at 12…
- [NTSB DEN74FQA48](https://openairdocs.org/ntsb/DEN74FQA48.md): Navion A · Cerrillos, NM · Accident · No injuries · Closed · Jun 1, 1974 · N91169 · Substantial damage
- [NTSB DEN71AD035](https://openairdocs.org/ntsb/DEN71AD035.md): Navion A · Orogrande, NM · Accident · 2 fatal · Closed · Feb 21, 1971 · N8726H · Destroyed
- [NTSB FTW66F0336](https://openairdocs.org/ntsb/FTW66F0336.md): Navion A · Clovis, NM · Accident · No injuries · Closed · Oct 3, 1965 · N91165 · 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" = 'NM' 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=NM

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