# NTSB investigations: Cessna U206F, TX

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 FTW86LA150](https://openairdocs.org/ntsb/FTW86LA150.md): Cessna U206F · Matagorda Is., TX · Accident · Minor injuries · Limited investigation · Final report · Aug 17, 1986 · N147ED · Substantial damage
  > The pilot was making a beach landing when the nose wheel struck an object in the sand, causing the nose wheel to collapse and the aircraft to nose over into an inverted position.
- [NTSB FTW86FRG16](https://openairdocs.org/ntsb/FTW86FRG16.md): Cessna U206F · Mcallen, TX · Accident · Minor injuries · Final report · Mar 5, 1986 · N8502Q · Destroyed
  > On 03-05-86 at 0854 CST a Cessna U206F, N8502Q, was substantially damaged on landing rollout at miller international airport in Mcallen, Texas. There was no fire and the pilot received minor injuries when the electronics cargo fell upon him as the aircraft…
- [NTSB FTW82DA359](https://openairdocs.org/ntsb/FTW82DA359.md): Cessna U206F · Katy, TX · Accident · No injuries · Final report · Aug 31, 1982 · N8641Q · Destroyed
  > During arrival, the pilot initiated his landing with a quartering tail wind at 4 gusting to 8 knots. While landing, he realized his airspeed was too high and he elected to go around. During the maneuver, the tail of the aircraft collided with a power line at…
- [NTSB FTW80FRG40](https://openairdocs.org/ntsb/FTW80FRG40.md): Cessna 206F · Orange Grove, TX · Accident · No injuries · Closed · May 2, 1980 · N1543U · Substantial damage
- [NTSB FTW80FA051](https://openairdocs.org/ntsb/FTW80FA051.md): Cessna U206 · Arlington, TX · Accident · Minor injuries · Closed · Mar 3, 1980 · N50955 · Substantial damage
- [NTSB FTW78FPA20](https://openairdocs.org/ntsb/FTW78FPA20.md): Cessna 206 · Dallas, TX · Accident · No injuries · Closed · Apr 2, 1978 · N9647G · Substantial damage
- [NTSB FTW77DQG14](https://openairdocs.org/ntsb/FTW77DQG14.md): Cessna U206F · Pampa, TX · Accident · No injuries · Closed · Mar 2, 1977 · N33214 · Substantial damage
- [NTSB FTW77FRG26](https://openairdocs.org/ntsb/FTW77FRG26.md): Cessna U206F · Johnson City, TX · Accident · No injuries · Closed · Jan 27, 1977 · N51013 · Substantial damage
- [NTSB FTW74FQG43](https://openairdocs.org/ntsb/FTW74FQG43.md): Cessna 206 · Amarillo, TX · Accident · Minor injuries · Closed · Mar 19, 1974 · N70903 · Substantial damage

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

This list as a web page: https://openairdocs.org/ntsb?model=2073333&state=TX

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