# NTSB investigations: Cessna 414A, ID

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 SEA93LA044](https://openairdocs.org/ntsb/SEA93LA044.md): Cessna 414A · Rexburg, ID · Accident · No injuries · Limited investigation · Final report · Dec 19, 1992 · N911AG · Substantial damage
  > The pilot did not select the remaining fuel supply. Factors include a deteriorated fuel selector valve.
- [NTSB SEA87LA020](https://openairdocs.org/ntsb/SEA87LA020.md): Cessna 414A · Murtaugh, ID · Accident · Serious injuries · Limited investigation · Final report · Dec 7, 1986 · N37561 · Destroyed
  > During the transition from a DME arc to the ILS final apch course, the plt allowed the acft to prematurely descend into the ground. The reason for the descent could not be determined. However, no pre-impact mechanical malfunction with the acft was found nor…

## 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" = 'ID' 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 ('2075907', '2075910'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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