# NTSB investigations: Cessna 206: In flight collision with object

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 ANC88LA081](https://openairdocs.org/ntsb/ANC88LA081.md): Cessna 206 · Naknek, AK · Accident · 1 fatal · Limited investigation · Final report · Jul 3, 1988 · N5045U · Destroyed
  > The pilot was hauling fish from remote beach sites in Alaska to a nearby gravel airstrip. Witnesses reported seeing the airplane make two approaches to the field in weather estimated as visibility 1/2 mile in fog, and a ceiling of 100-200 feet. After the two…
- [NTSB ANC86LA030](https://openairdocs.org/ntsb/ANC86LA030.md): Cessna 206 · Delta Junction, AK · Accident · Minor injuries · Limited investigation · Final report · Feb 20, 1986 · N116ME · Destroyed
  > The aircraft struck a telephone pole guide wire while maneuvering at a low altitude. The electric company stated that the guide wire was 32 feet above the road surface. The pilot stated that he was low flying less than 50 feet above the ground to review…

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

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

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