# NTSB investigations: Cessna U206G, LA

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 DFW07LA120](https://openairdocs.org/ntsb/DFW07LA120.md): Cessna U206G · Leeville, LA · Accident · 1 fatal · Limited investigation · Final report · May 24, 2007 · N45WT · Substantial damage
  > The failure of the operator of the powerboat to maintain separation from the departing floatplane.
- [NTSB FTW96LA171](https://openairdocs.org/ntsb/FTW96LA171.md): Cessna U206G · Venice, LA · Accident · 1 fatal · Limited investigation · Final report · Apr 14, 1996 · N734QW · Destroyed
  > the pilot's inadvertent flight into instrument meteorological conditions. A factor was the fog.
- [NTSB FTW84LA179](https://openairdocs.org/ntsb/FTW84LA179.md): Cessna U206G · Lake Charles, LA · Accident · Minor injuries · Limited investigation · Final report · Apr 1, 1984 · N7383N · Substantial damage
  > The acft hit a tree and a ditch during a forced landing on a road after the engine lost power. Examination of the engineafter the accident revealed that the throttle rod had disconnected from the throttle control arm at the bolt hole. The hole had worn…
- [NTSB FTW80DRJ41](https://openairdocs.org/ntsb/FTW80DRJ41.md): Cessna U206G · Delhi, LA · Accident · No injuries · Closed · Sep 11, 1980 · N9942N · 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" = 'LA' 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 ('2073356', '2073315', '2073314'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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