# NTSB investigations: Cessna A188A, 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 LAX03LA070](https://openairdocs.org/ntsb/LAX03LA070.md): Cessna A188A · Brawley, CA · Accident · No injuries · Limited investigation · Final report · Jan 15, 2003 · N5638J · Substantial damage
  > loss of engine power for undetermined reasons.
- [NTSB LAX84LA100](https://openairdocs.org/ntsb/LAX84LA100.md): Cessna A 188 A · Cantua Creek, CA · Accident · No injuries · Limited investigation · Final report · Dec 10, 1983 · N5636J · Substantial damage
  > The acft collided with a pick-up truck during a landing on a private airstrip. The truck driver became distracted while driving alongside the dirt rwy and reported that he did not see the arriving acft.
- [NTSB LAX83LA075](https://openairdocs.org/ntsb/LAX83LA075.md): Cessna 188 · Five Points, CA · Accident · No injuries · Limited investigation · Final report · Jan 18, 1983 · N5636J · Substantial damage
  > The pilot lost control of his aircraft during takeoff in a cross wind. The aircraft ground looped collapsed the right main landing gear and nosed over. The agricultural operations were canceled at this provisional strip because of wind and the aircraft was…
- [NTSB LAX80DUM02](https://openairdocs.org/ntsb/LAX80DUM02.md): Cessna 188 · Holtville, CA · Accident · No injuries · Closed · Oct 6, 1979 · N5627J · Substantial damage
- [NTSB LAX77FUG56](https://openairdocs.org/ntsb/LAX77FUG56.md): Cessna 188B · Blythe, CA · Accident · No injuries · Closed · Jul 26, 1977 · N5647J · Substantial damage
- [NTSB LAX76FUM09](https://openairdocs.org/ntsb/LAX76FUM09.md): Cessna 188A · Brawley, CA · Accident · Minor injuries · Closed · Oct 28, 1975 · N1566M · Substantial damage
- [NTSB OAK76DVG19](https://openairdocs.org/ntsb/OAK76DVG19.md): Cessna A188A · Herald, CA · Accident · No injuries · Closed · Aug 29, 1975 · N9988G · Substantial damage
- [NTSB OAK75DVA62](https://openairdocs.org/ntsb/OAK75DVA62.md): Cessna A188A · Merced, CA · Accident · No injuries · Closed · May 15, 1975 · N9957G · Substantial damage
- [NTSB OAK74DVG54](https://openairdocs.org/ntsb/OAK74DVG54.md): Cessna 188 · Willows, CA · Accident · No injuries · Closed · May 5, 1974 · N5672J · Substantial damage
- [NTSB OAK73DVG72](https://openairdocs.org/ntsb/OAK73DVG72.md): Cessna A188A · Butte City, CA · Accident · No injuries · Closed · Jun 27, 1973 · N5672J · 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 ('2073008'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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