# NTSB investigations: Cessna A188A, AZ

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 LAX89DUJ01](https://openairdocs.org/ntsb/LAX89DUJ01.md): Cessna A188A · Casa Grande, AZ · Accident · Serious injuries · Final report · Oct 23, 1988 · N5640J · Destroyed
  > During aerial application flight, the aircraft collided with a high-tension static wire and subsequently with the ground. Post-impact fire ensued. The pilot stated he misjudged his approach to the field and did not see the wire.
- [NTSB LAX82DA325](https://openairdocs.org/ntsb/LAX82DA325.md): Cessna 188 · Casa Grande, AZ · Accident · No injuries · Final report · Aug 31, 1982 · N1562M · Substantial damage
  > The pilot initiated his takeoff with a light quartering tail wind from a 2300 ft runway that was covered with tall grass. The temperature and elevation were 95 deg and about 1500 ft, respectively. He reported that the plane accelerated slowly, but was about…
- [NTSB LAX77FUJ02](https://openairdocs.org/ntsb/LAX77FUJ02.md): Cessna A188A · Buckeye, AZ · Accident · 2 fatal · Closed · Oct 5, 1976 · N9997G · Destroyed
- [NTSB LAX76DUK15](https://openairdocs.org/ntsb/LAX76DUK15.md): Cessna 188B · Quail Mesa, AZ · Accident · No injuries · Closed · Sep 26, 1976 · N5647J · Substantial damage
- [NTSB LAX73DUJ22](https://openairdocs.org/ntsb/LAX73DUJ22.md): Cessna A188 · Yuma, AZ · Accident · No injuries · Closed · Sep 16, 1972 · N9960G · Substantial damage
- [NTSB LAX72FUJ98](https://openairdocs.org/ntsb/LAX72FUJ98.md): Cessna A188B · Surprise, AZ · Accident · No injuries · Closed · May 6, 1972 · N9997G · 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" = 'AZ' 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=AZ

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