# NTSB investigations: Cessna A188, WA

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 SEA97LA143](https://openairdocs.org/ntsb/SEA97LA143.md): Cessna A188 · Richland, WA · Accident · No injuries · Limited investigation · Final report · Jun 17, 1997 · N9766V · Substantial damage
  > the pilot's failure to maintain airspeed. Inadequate in-flight planning and high obstructions that restricted evasive maneuvers were factors.
- [NTSB SEA86LA198](https://openairdocs.org/ntsb/SEA86LA198.md): Cessna 188 · Easton, WA · Accident · No injuries · Limited investigation · Final report · Aug 14, 1986 · N5506S · Substantial damage
  > The tow plane with glider attached began losing pwr at aprx 50 ft AGL during takeoff. The tow plt signaled the glider plt for tow release. The two plts landed on the remaining rwy. The tow plane skidded into the trees off the end of the rwy. Investigation…
- [NTSB SEA78DYP25](https://openairdocs.org/ntsb/SEA78DYP25.md): Cessna 188 · Fairfield, WA · Accident · No injuries · Closed · Mar 27, 1978 · N8070V · Substantial damage
- [NTSB SEA78FYP15](https://openairdocs.org/ntsb/SEA78FYP15.md): Cessna A188 · Moxee, WA · Accident · No injuries · Closed · Mar 15, 1978 · N5501S · Destroyed
- [NTSB SEA72FYG15](https://openairdocs.org/ntsb/SEA72FYG15.md): Cessna A188 · Albion, WA · Accident · Serious injuries · Closed · Sep 23, 1971 · N9772V · Destroyed
- [NTSB SEA72DYG02](https://openairdocs.org/ntsb/SEA72DYG02.md): Cessna A188 · Brownstown, WA · Accident · No injuries · Closed · Jul 16, 1971 · N5501S · Substantial damage
- [NTSB SEA71FWG05](https://openairdocs.org/ntsb/SEA71FWG05.md): Cessna A188 · Sunnyside, WA · Accident · No injuries · Closed · Jul 14, 1970 · N8019V · Substantial damage
- [NTSB SEA69D0096](https://openairdocs.org/ntsb/SEA69D0096.md): Cessna A188 · Sunnyside, WA · Accident · No injuries · Closed · Aug 29, 1968 · N8019V · 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" = 'WA' 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=WA

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