# NTSB investigations: Cessna 207: Loss of engine power(total) - mech failure/malf

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 ANC98LA078](https://openairdocs.org/ntsb/ANC98LA078.md): Cessna 207 · Holy Cross, AK · Accident · No injuries · Limited investigation · Final report · Jun 20, 1998 · N1673U · Substantial damage
  > The improper installation/undertorquing of the engine crankcase bolts by company maintenance personnel, and a subsequent fracture of the engine crankshaft. A factor in the accident was unsuitable terrain for a forced landing.
- [NTSB ATL94LA161](https://openairdocs.org/ntsb/ATL94LA161.md): Cessna 207 · Nags Head, NC · Accident · No injuries · Limited investigation · Final report · Aug 20, 1994 · N1670U · Substantial damage
  > The failure of the mixture control cable which resulted in a loss of engine power.
- [NTSB ANC92LA095](https://openairdocs.org/ntsb/ANC92LA095.md): Cessna 207 · Quinhagak, AK · Accident · No injuries · Limited investigation · Final report · Jun 19, 1992 · N23CF · Substantial damage
  > Engine failure due to total oil loss. Contributing to the accident were the separation of the oil filter adapter from the oil pump due to improper maintenance procedures and non adherence to recommended directives by company maintenance personnel, and the…
- [NTSB CHI86LA084](https://openairdocs.org/ntsb/CHI86LA084.md): Cessna 207 · Milwaukee, WI · Accident · No injuries · Limited investigation · Final report · Feb 10, 1986 · N18SA · Substantial damage
  > After preheating the eng the plt took off and during climb the cabin filled with smoke and the eng stopped. A forced landing was made on a city street during which the left wing contacted a sign pole. Post accident teardown of the eng disclosed that an oil…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073602')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 351))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2073602&occurrence=351

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