# NTSB investigations: Cessna 207: Collision with terr/obj (non-CFIT)

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 ANC18FA045](https://openairdocs.org/ntsb/ANC18FA045.md): Cessna 175 · Anchorage, AK · Accident · 1 fatal · Field investigation · Final report · Jun 13, 2018 · N9423B · 2 aircraft · Substantial damage
  > The failure of both pilots to see and avoid the other airplane while in level cruise flight, which resulted in a midair collision.
- [NTSB GAA18CA154](https://openairdocs.org/ntsb/GAA18CA154.md): Cessna 207 · Newtok, AK · Accident · No injuries · Data collection · Final report · Feb 25, 2018 · N1658U · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff. Contributing to the accident was the pilot’s failure to properly check that the flight controls were correctly configured before takeoff.
- [NTSB ERA17CA213](https://openairdocs.org/ntsb/ERA17CA213.md): Cessna 207 · Vinalhaven, ME · Accident · Minor injuries · Data collection · Final report · Jun 26, 2017 · N207GM · Substantial damage
  > The pilot’s failure to maintain a stabilized approach, which resulted in a bounced landing and subsequent go-around with insufficient distance to clear trees during the climb.
- [NTSB ANC15FA032](https://openairdocs.org/ntsb/ANC15FA032.md): Cessna 207 · Bethel, AK · Accident · 1 fatal · Field investigation · Final report · May 30, 2015 · N1653U · Substantial damage
  > The pilot's failure to maintain altitude, which resulted in collision with the terrain. Contributing to the accident was the pilot's impairment from carbon monoxide exposure in flight. The source of the carbon monoxide could not be determined because the…
- [NTSB ANC13LA029](https://openairdocs.org/ntsb/ANC13LA029.md): Cessna 207 · Bethel, AK · Accident · No injuries · Limited investigation · Final report · Mar 6, 2013 · N1704U · Substantial damage
  > The failure of the engine’s No. 1 piston connecting rod retaining bolts due to fatigue fracturing, which resulted in a loss of engine power during cruise flight.
- [NTSB ANC09LA058](https://openairdocs.org/ntsb/ANC09LA058.md): Cessna 207 · Crooked Creek, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 17, 2009 · N1623U · Substantial damage
  > A total loss of engine power for an undetermined reason.
- [NTSB ANC09LA012](https://openairdocs.org/ntsb/ANC09LA012.md): Cessna 207 · Napaskiak, AK · Accident · Minor injuries · Limited investigation · Final report · Nov 14, 2008 · N36CF · Substantial damage
  > The pilot's continued flight into adverse weather and icing conditions, and his failure to maintain sufficient airspeed to avoid a stall, resulting in a loss of control and in-flight collision with terrain while on an approach to land.
- [NTSB LAX08CA180](https://openairdocs.org/ntsb/LAX08CA180.md): Cessna 207 · Page, AZ · Accident · No injuries · Data collection · Final report · Jun 10, 2008 · N9100D · Substantial damage
  > The pilot's failure to maintain directional control during an aborted takeoff. Contributing to the accident were the crosswind weather conditions and the high density altitude conditions.
- [NTSB ANC08LA032](https://openairdocs.org/ntsb/ANC08LA032.md): Cessna 207 · Aniak, AK · Accident · Serious injuries · Limited investigation · Final report · Jan 16, 2008 · N1701U · Substantial damage
  > A partial loss of engine power for an undetermined reason. Contributing to the accident were the pilot's inadvertent encounter with IMC conditions, and a whiteout during his attempted go-around from an emergency landing approach.

## 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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/470/sequence?model=2073602

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