# NTSB investigations: Cessna P206B, 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 WPR09LA432](https://openairdocs.org/ntsb/WPR09LA432.md): Cessna P206B · Truckee, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 8, 2009 · N206ST · Substantial damage
  > The pilot’s failure to maintain adequate airspeed for flight, which resulted in an aerodynamic stall and subsequent impact with the ground. Contributing to the accident was the intermittent failure of the stall warning system due to a contaminated switch.
- [NTSB LAX01LA303](https://openairdocs.org/ntsb/LAX01LA303.md): Cessna P206B · Willits, CA · Accident · 2 fatal · Limited investigation · Final report · Sep 9, 2001 · N146A · Substantial damage
  > the failure of the pilot to reset the elevator trim tab during the go-around, which resulted in his failure to maintain airspeed and an inadvertent stall.
- [NTSB LAX97LA231](https://openairdocs.org/ntsb/LAX97LA231.md): Cessna P206B · Desert Center, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 1997 · N4733F · Destroyed
  > The pilot's unexpected encounter with dust devils during the takeoff ground roll.
- [NTSB LAX87FA142](https://openairdocs.org/ntsb/LAX87FA142.md): Cessna P206B · Green Valley, CA · Accident · 2 fatal · Field investigation · Final report · Feb 23, 1987 · N58RS · Destroyed
  > A Cessna P206B collided with mountainous terrain. Instrument meteorological conditions prevailed at the time. An unoffical weather observation taken the day of occurrence 12 miles east of the accident site indicated an indefinite 100 foot ceiling, 1/4 mile…
- [NTSB LAX83FA388](https://openairdocs.org/ntsb/LAX83FA388.md): Cessna P206B · Kernville, CA · Accident · 2 fatal · Field investigation · Final report · Aug 16, 1983 · N4738F · Destroyed
  > The acft was conducting an aerial search in a box canyon. According to the surviving pax they ran out of room to turn the acft around in the canyon. The acft crashed at the 3,850 ft level. Surrounding mountain peaks are 9,470 ft MSL.
- [NTSB LAX78DUM20](https://openairdocs.org/ntsb/LAX78DUM20.md): Cessna 206 · Imperial, CA · Accident · No injuries · Closed · Apr 7, 1978 · N8619Z · Substantial damage
- [NTSB OAK77DVD28](https://openairdocs.org/ntsb/OAK77DVD28.md): Cessna 206 · Crescent City, CA · Accident · No injuries · Closed · Mar 25, 1977 · N4794F · 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" = '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 ('2073309'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2073309&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.
