# NTSB investigations: Cessna T207A: In flight collision with terrain/water

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 LAX96FA339](https://openairdocs.org/ntsb/LAX96FA339.md): Cessna T207A · Littlefield, AZ · Accident · 1 fatal · Field investigation · Final report · Sep 21, 1996 · N6468H · Destroyed
  > The pilot's failure to maintain clearance with terrain during descent for undetermined reasons. Contributing factors were the dark night and mountainous terrain.
- [NTSB SEA93FA023](https://openairdocs.org/ntsb/SEA93FA023.md): Cessna T207A · Elk City, ID · Accident · 3 fatal · Field investigation · Final report · Nov 19, 1992 · N6257H · Substantial damage
  > The pilot's continuation of a VFR flight into instrument meteorological conditions. Factors include becoming lost, disoriented, falling snow, and mountainous, hilly terrain.
- [NTSB LAX86LA295](https://openairdocs.org/ntsb/LAX86LA295.md): Cessna T207A · Whitmore, AZ · Accident · Minor injuries · Limited investigation · Final report · Jul 19, 1986 · N6484H · Substantial damage
  > The airplane departed marble canyon airport, marble canyon, Arizona, to pick up passengers at the grand canyon bar ten airstrip (1Z1) for a 14 CFR 135 flight. The pilot reported that upon arrival at 1Z1 he flew over the single dirt strip runway at about 20 ft…
- [NTSB MIA84FA056](https://openairdocs.org/ntsb/MIA84FA056.md): Cessna T207A · Zolfo Springs, FL · Accident · 2 fatal · Field investigation · Final report · Jan 7, 1984 · N73180 · Destroyed
  > The acft collided with trees and the ground during takeoff in IMC weather. The visibility was zero due to ground fog. There were no known witnesses to the accident but there was evidence of a collision with a 60 ft high tree at the end of the 3000 ft rwy. It…

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

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

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