# Final NTSB investigations: Cessna 140, 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 WPR23LA193](https://openairdocs.org/ntsb/WPR23LA193.md): Cessna 140 · American Falls, ID · Accident · Minor injuries · Class 4 · Limited · Final report · May 20, 2023 · N77J · Substantial damage
  > The pilot’s inadvertent selection of the off position of the fuel tank selector inflight, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB WPR18LA224](https://openairdocs.org/ntsb/WPR18LA224.md): Cessna 140 · Marsing, ID · Accident · No injuries · Class 3 · Limited · Final report · Aug 14, 2018 · N89093 · Substantial damage
  > The loss of engine power during a low pass as a result of a blockage of the carburetor idle chambers which led to a forced landing in a river.
- [NTSB WPR09CA058](https://openairdocs.org/ntsb/WPR09CA058.md): Cessna 140 · Preston, ID · Accident · No injuries · Data collection · Final report · Dec 17, 2008 · N4008N · Substantial damage
  > The pilot's misjudged flare and improper recovery from a bounced landing, which resulted in a loss of control and subsequent nose over.
- [NTSB SEA74DYA10](https://openairdocs.org/ntsb/SEA74DYA10.md): Cessna 140 · Preston, ID · Accident · No injuries · Closed · Aug 30, 1973 · N76057 · Substantial damage
- [NTSB SEA72DYG25](https://openairdocs.org/ntsb/SEA72DYG25.md): Cessna 140 · Lewiston, ID · Accident · No injuries · Closed · Jan 15, 1972 · N89336 · Destroyed
- [NTSB SEA71DXM29](https://openairdocs.org/ntsb/SEA71DXM29.md): Cessna 140 · Atomic City, ID · Accident · No injuries · Closed · Apr 12, 1971 · N90124 · Substantial damage
- [NTSB SEA70D0101](https://openairdocs.org/ntsb/SEA70D0101.md): Cessna 140 · Eagle, ID · Accident · No injuries · Closed · Oct 23, 1969 · N89290 · Destroyed
- [NTSB SEA69D0222](https://openairdocs.org/ntsb/SEA69D0222.md): Cessna 140 · Idaho Falls, ID · Accident · No injuries · Closed · Apr 22, 1969 · N1926V · Substantial damage
- [NTSB SEA69D0224](https://openairdocs.org/ntsb/SEA69D0224.md): Cessna 140 · Kellogg, ID · Accident · No injuries · Closed · Apr 14, 1969 · N76978 · Substantial damage
- [NTSB SEA69D0205](https://openairdocs.org/ntsb/SEA69D0205.md): Cessna 140 · Midvale, ID · Accident · No injuries · Closed · Apr 10, 1969 · N72758 · Substantial damage
- [NTSB SEA67D0352](https://openairdocs.org/ntsb/SEA67D0352.md): Cessna 140 · Blackfoot, ID · Accident · No injuries · Closed · May 21, 1967 · N76775 · Substantial damage
- [NTSB UNK64X3084](https://openairdocs.org/ntsb/UNK64X3084.md): Cessna 140 · Weiser, ID · Accident · No injuries · Closed · Jul 28, 1964 · N2370V · Substantial damage
- [NTSB UNK64X2128](https://openairdocs.org/ntsb/UNK64X2128.md): Cessna 140 · Boise, ID · Accident · No injuries · Closed · Jun 5, 1964 · N76680 · 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" = 'ID' AND c."eventCountry" = 'USA'
  AND c."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071602', '2071603'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
