# NTSB investigations: Cessna 207, 1992

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 ANC93FA012](https://openairdocs.org/ntsb/ANC93FA012.md): Cessna 207 · Montague Island, AK · Accident · 2 fatal · Field investigation · Final report · Nov 6, 1992 · N1686U · Destroyed
  > The pilot's intentional VFR departure into instrument meteorological conditions, and the company chief pilot's failure to exercise adequate supervision. The weather conditions were factors in the accident.
- [NTSB ANC92LA115](https://openairdocs.org/ntsb/ANC92LA115.md): Cessna 207 · Yakutat, AK · Accident · 1 fatal · Limited investigation · Final report · Jul 29, 1992 · N7ME · Destroyed
  > The pilot elected to fly an improper altitude. Contributing factors were the pilots attempt to fly VFR into IMC conditions, and the obscured weather.
- [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…

## 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 year(c."eventDate") = 1992
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073602'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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