# NTSB investigations: Cessna TU206B, CA

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 LAX87LA188](https://openairdocs.org/ntsb/LAX87LA188.md): Cessna TU206B · Temecula, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 22, 1987 · N3835G · Substantial damage
  > During an aerial survey flight, while on final approach to the arpt, the engine began running rough then quit. The plt was unable to land the acft at the arpt, therefore, a nearby dirt road was selected. During the landing roll the acft collided with the…
- [NTSB LAX82DA288](https://openairdocs.org/ntsb/LAX82DA288.md): Cessna U206B · Grass Valley, CA · Accident · No injuries · Final report · Aug 3, 1982 · N4991F · Substantial damage
  > During arrival, the pilot entered the traffic pattern to land on runway 25 with a reported wind from the southwest at 10 KTS. On his first approach, the pilot experienced a rough ride with fluctuating airspeed and rate of descent. He was overshooting so he…
- [NTSB LAX75DUM28](https://openairdocs.org/ntsb/LAX75DUM28.md): Cessna 206B · Imperial, CA · Accident · No injuries · Closed · Jun 23, 1975 · N3414L · Substantial damage
- [NTSB OAK74FVD08](https://openairdocs.org/ntsb/OAK74FVD08.md): Cessna TU206B · Livermore, CA · Accident · No injuries · Closed · Sep 3, 1973 · N4991F · Substantial damage
- [NTSB OAK73AP004](https://openairdocs.org/ntsb/OAK73AP004.md): Cessna TU206B · Lone Pine, CA · Accident · No injuries · Closed · Jul 22, 1972 · N3821G · Destroyed

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

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

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