# NTSB investigations: Cessna 320B, 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 LAX87LA279](https://openairdocs.org/ntsb/LAX87LA279.md): Cessna 320B · Bermuda Dunes, CA · Accident · No injuries · Limited investigation · Final report · Jul 25, 1987 · N44RM · Substantial damage
  > Drg a landing, the left main gear hit a raised lip at the apch end of the rwy & failed. The plt held the left wing off the rwy by using aileron until the acft slowed, then the acft drifted off the left side. The rwy lip had been created by construction on the…
- [NTSB LAX84LA244](https://openairdocs.org/ntsb/LAX84LA244.md): Cessna 320 · Long Beach, CA · Accident · No injuries · Limited investigation · Final report · Apr 19, 1984 · N6185Q · Substantial damage
  > While taxing to the active rwy, the plt was aware of several holes in the taxiway. He made a turn to the left & entered a dirt area to assure that the acft would not enter the taxiway holes. However, in the dirt area, the nosewheel sunk into a water covered…
- [NTSB OAK75FVG15](https://openairdocs.org/ntsb/OAK75FVG15.md): Cessna 320B · Sacramento, CA · Accident · No injuries · Closed · Aug 17, 1974 · N9811L · Substantial damage
- [NTSB LAX72DVA07](https://openairdocs.org/ntsb/LAX72DVA07.md): Cessna 320B · Bakersfield, CA · Accident · No injuries · Closed · Aug 2, 1971 · N9812L · 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 ('2074508'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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