# NTSB investigations: Cessna A188, 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 OAK78FVA67](https://openairdocs.org/ntsb/OAK78FVA67.md): Cessna A188 · Chowchilla, CA · Accident · Serious injuries · Closed · Aug 1, 1978 · N8003V · Substantial damage
- [NTSB OAK78FVA28](https://openairdocs.org/ntsb/OAK78FVA28.md): Cessna A188 · Gustine, CA · Accident · No injuries · Closed · Feb 24, 1978 · N8149V · Substantial damage
- [NTSB OAK78DVM10](https://openairdocs.org/ntsb/OAK78DVM10.md): Cessna 188 · Castroville, CA · Accident · Serious injuries · Closed · Jan 27, 1978 · N9705V · Destroyed
- [NTSB OAK77FVM23](https://openairdocs.org/ntsb/OAK77FVM23.md): Beech A36 · Hollister, CA · Accident · No injuries · Closed · Aug 19, 1977 · N2859W · 2 aircraft · Substantial damage
- [NTSB OAK76FVM28](https://openairdocs.org/ntsb/OAK76FVM28.md): Cessna 188 · Castroville, CA · Accident · Serious injuries · Closed · Mar 14, 1976 · N8106V · Destroyed
- [NTSB OAK76FVA08](https://openairdocs.org/ntsb/OAK76FVA08.md): Cessna A188 · Lemoore, CA · Accident · Serious injuries · Closed · Aug 26, 1975 · N9842V · Destroyed
- [NTSB LAX75FUG31](https://openairdocs.org/ntsb/LAX75FUG31.md): Cessna 188 · Thermal, CA · Accident · Serious injuries · Closed · Feb 7, 1975 · N8095V · Destroyed
- [NTSB OAK75FVG26](https://openairdocs.org/ntsb/OAK75FVG26.md): Cessna A188 · Dixon, CA · Accident · No injuries · Closed · Oct 8, 1974 · N9776V · Substantial damage
- [NTSB OAK75DVA25](https://openairdocs.org/ntsb/OAK75DVA25.md): Cessna 188 · Lemoore, CA · Accident · No injuries · Closed · Sep 24, 1974 · N9842V · Substantial damage
- [NTSB OAK74FVA67](https://openairdocs.org/ntsb/OAK74FVA67.md): Cessna A188 · Delhi, CA · Accident · No injuries · Closed · May 27, 1974 · N9898V · Destroyed
- [NTSB LAX74DUG48](https://openairdocs.org/ntsb/LAX74DUG48.md): Cessna A188 · Vidal, CA · Accident · No injuries · Closed · Mar 28, 1974 · N9799V · Substantial damage
- [NTSB OAK73FVA42](https://openairdocs.org/ntsb/OAK73FVA42.md): Cessna A188 · Livingston, CA · Accident · No injuries · Closed · Feb 22, 1973 · N9718V · Substantial damage
- [NTSB OAK72DVD79](https://openairdocs.org/ntsb/OAK72DVD79.md): Cessna A188 · Rio Vista, CA · Accident · No injuries · Closed · Jun 25, 1972 · N9728V · Substantial damage
- [NTSB OAK72DVA82](https://openairdocs.org/ntsb/OAK72DVA82-166863.md): Cessna A188 · Merced, CA · Accident · No injuries · Closed · Jun 23, 1972 · N9883V · Destroyed
- [NTSB OAK72DVA67](https://openairdocs.org/ntsb/OAK72DVA67.md): Cessna 188 · Madera, CA · Accident · No injuries · Closed · Apr 14, 1972 · N8098V · Substantial damage
- [NTSB LAX72DUG65](https://openairdocs.org/ntsb/LAX72DUG65.md): Cessna 188 · Blythe, CA · Accident · No injuries · Closed · Mar 23, 1972 · N9755V · Substantial damage
- [NTSB OAK72DVM03](https://openairdocs.org/ntsb/OAK72DVM03.md): Cessna 188 · Salinas, CA · Accident · No injuries · Closed · Aug 10, 1971 · N8036V · Substantial damage
- [NTSB OAK72DVA02](https://openairdocs.org/ntsb/OAK72DVA02.md): Cessna 188 · Five Points, CA · Accident · No injuries · Closed · Jul 11, 1971 · N9842V · Substantial damage
- [NTSB OAK71FVG71](https://openairdocs.org/ntsb/OAK71FVG71.md): Cessna A188 · Willows, CA · Accident · 1 fatal · Closed · May 1, 1971 · N8118V · Destroyed
- [NTSB OAK71DVA32](https://openairdocs.org/ntsb/OAK71DVA32.md): Cessna A188 · Firebaugh, CA · Accident · No injuries · Closed · Sep 6, 1970 · N9867V · Substantial damage
- [NTSB LAX70FUM12](https://openairdocs.org/ntsb/LAX70FUM12.md): Cessna A-188 · Calipatria, CA · Accident · No injuries · Closed · Jun 26, 1970 · N8079V · Substantial damage
- [NTSB OAK70F0164](https://openairdocs.org/ntsb/OAK70F0164.md): Cessna 188 · Soledad, CA · Accident · Serious injuries · Closed · Sep 10, 1969 · N8053V · Destroyed
- [NTSB LAX70D0120](https://openairdocs.org/ntsb/LAX70D0120.md): Cessna A188 · Shafter, CA · Accident · No injuries · Closed · Sep 3, 1969 · N9780V · Substantial damage
- [NTSB OAK70D0089](https://openairdocs.org/ntsb/OAK70D0089.md): Cessna 188 · Madera, CA · Accident · No injuries · Closed · Aug 20, 1969 · N8114V · Substantial damage
- [NTSB LAX70D0004](https://openairdocs.org/ntsb/LAX70D0004.md): Cessna A188 · Calipatria, CA · Accident · No injuries · Closed · Jun 6, 1969 · N8083V · Destroyed
- [NTSB OAK69D0314](https://openairdocs.org/ntsb/OAK69D0314.md): Cessna 188 · Exeter, CA · Accident · No injuries · Closed · May 14, 1969 · N8098V · Destroyed
- [NTSB LAX68F0250](https://openairdocs.org/ntsb/LAX68F0250.md): Cessna A188 · Westmorelnd, CA · Accident · No injuries · Closed · Jan 5, 1968 · N9749V · Substantial damage
- [NTSB OAK68D0172](https://openairdocs.org/ntsb/OAK68D0172.md): Cessna A188 · Madera, CA · Accident · No injuries · Closed · Oct 8, 1967 · N8003V · Destroyed
- [NTSB OAK68A0014](https://openairdocs.org/ntsb/OAK68A0014.md): Cessna A188 · Pebble Bch, CA · Accident · 1 fatal · Closed · Aug 17, 1967 · N9861V · Destroyed
- [NTSB OAK67A0089](https://openairdocs.org/ntsb/OAK67A0089.md): Cessna A188 · Acampo, CA · Accident · 1 fatal · Closed · Jun 12, 1967 · N8002V · Destroyed
- [NTSB OAK68D3211](https://openairdocs.org/ntsb/OAK68D3211.md): Cessna 188 · Herald, CA · Accident · No injuries · Closed · May 15, 1967 · N9728V · Substantial damage
- [NTSB OAK67F0333](https://openairdocs.org/ntsb/OAK67F0333.md): Cessna 188 · Alviso, CA · Accident · Serious injuries · Closed · Apr 29, 1967 · N9861V · 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 ('2073004'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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