# NTSB investigations: Continental C145 series, 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 GAA17CA116](https://openairdocs.org/ntsb/GAA17CA116.md): Cessna 170 · Coeur D'Alene, ID · Accident · No injuries · Data collection · Final report · Jan 14, 2017 · N3210A · Substantial damage
  > The pilot’s failure to maintain an appropriate descent rate during approach, which resulted in landing short of the runway threshold.
- [NTSB WPR11CA409](https://openairdocs.org/ntsb/WPR11CA409.md): Cessna 170A · Grangeville, ID · Accident · Serious injuries · Data collection · Final report · Aug 28, 2011 · N1238D · Substantial damage
  > The pilot's loss of directional control for undetermined reasons.
- [NTSB SEA07CA125](https://openairdocs.org/ntsb/SEA07CA125.md): Cessna 170B · Fairfield, ID · Accident · No injuries · Data collection · Final report · May 17, 2007 · N2778C · Substantial damage
  > The pilot's failure to maintain adequate airspeed while turning from base to final, resulting in an inadvertent stall/mush and subsequent collision with terrain.
- [NTSB SEA06LA077](https://openairdocs.org/ntsb/SEA06LA077.md): Cessna 170B · Clark Fork, ID · Accident · Serious injuries · Limited investigation · Final report · Apr 17, 2006 · N2288D · Substantial damage
  > The pilot's failure to maintain aircraft control during a go-around. A quartering tailwind was a factor.
- [NTSB SEA04LA072](https://openairdocs.org/ntsb/SEA04LA072.md): Cessna 170B · Nampa, ID · Accident · No injuries · Limited investigation · Final report · Apr 23, 2004 · N8252A · Substantial damage
  > The right seat pilot's failure to maintain directional control during the initial part of the landing roll, and his improper handling of the aircraft (excessive braking) as the aircraft departed the side of the runway. Factors include the pilot's lack of…
- [NTSB SEA00LA164](https://openairdocs.org/ntsb/SEA00LA164.md): Cessna 170B · Nampa, ID · Accident · No injuries · Limited investigation · Final report · Aug 18, 2000 · N3007A · Substantial damage
  > The pilot's failure to maintain directional control during the balked landing.
- [NTSB SEA97LA200](https://openairdocs.org/ntsb/SEA97LA200.md): Cessna 170A · Elk City, ID · Accident · Serious injuries · Limited investigation · Final report · Aug 31, 1997 · N1487D · Destroyed
  > A horse and children wandered onto the airstrip.
- [NTSB SEA97LA195](https://openairdocs.org/ntsb/SEA97LA195.md): Cessna 170 · Elk City, ID · Accident · Serious injuries · Limited investigation · Final report · Aug 24, 1997 · N3964V · Destroyed
  > Oil starvation of the engine due to undetermined reasons, which led to the failure and separation of a main bearing and a connecting rod. A factor contributing to the accident was the lack of suitable terrain for a successful forced landing.
- [NTSB SEA87LA143](https://openairdocs.org/ntsb/SEA87LA143.md): Cessna 170B · Coeur D'Alene, ID · Accident · No injuries · Limited investigation · Final report · Jul 21, 1987 · N3063A · Substantial damage
  > On initial climb a partial loss of power occurred and the pilot made a forced landing in a wheat field. During landing roll the aircraft's left main gear struck an irrigation pipe and the aircraft nosed over inverted. No evidence of a preimpact mechanical…
- [NTSB SEA81FYP41](https://openairdocs.org/ntsb/SEA81FYP41.md): Cessna 170B · Athol, ID · Accident · No injuries · Closed · Sep 20, 1981 · N1954C · Substantial damage
- [NTSB SEA80DYA08](https://openairdocs.org/ntsb/SEA80DYA08.md): Cessna 170B · Mccall, ID · Accident · No injuries · Closed · Feb 12, 1980 · N2713D · Substantial damage
- [NTSB SEA68D0146](https://openairdocs.org/ntsb/SEA68D0146.md): Cessna 170A · Montpelier, ID · Accident · No injuries · Closed · Sep 23, 1967 · N1351D · Substantial damage
- [NTSB SEA67D0012](https://openairdocs.org/ntsb/SEA67D0012.md): Aeronca 15AC · Coeur D'Alene, ID · Accident · No injuries · Closed · Jun 19, 1966 · N1346H · 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17012'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=17012&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.