# NTSB investigations: Cessna T188C: On ground/water encounter with terrain/water

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 CHI00LA198](https://openairdocs.org/ntsb/CHI00LA198.md): Cessna T188C · Rock Dell, MN · Accident · No injuries · Limited investigation · Final report · Jul 15, 2000 · N9957J · Substantial damage
  > the failure of the pilot to maintain clearance with the terrain.
- [NTSB DEN90LA150](https://openairdocs.org/ntsb/DEN90LA150.md): Cessna T 188C · Wray, CO · Accident · No injuries · Limited investigation · Final report · Jun 28, 1990 · N2870J · Substantial damage
  > The failure of the pilot to maintain proper alignment proper alignment during landing.
- [NTSB DEN87LA183](https://openairdocs.org/ntsb/DEN87LA183.md): Cessna T188C · Winnett, MT · Accident · No injuries · Limited investigation · Final report · Jul 8, 1987 · N2058J · Substantial damage
  > During landing on a roadway used by the crop-duster for re-loading chemicals for spraying, the left spray boom contacted vegetation and slewed the acft sideways. The right wing was bent and the propeller was damaged.
- [NTSB MKC87LA118](https://openairdocs.org/ntsb/MKC87LA118.md): Cessna 188C · Dalton, NE · Accident · No injuries · Limited investigation · Final report · Jun 5, 1987 · N4219J · Destroyed
  > The PIC attempted to depart a rural farm ldg strip during an aerial application operation. The acft left spray boom struck tall standing wheat prior to lift off speed causing loss of control and subsequent ground loop and nose over.
- [NTSB SEA84LA152](https://openairdocs.org/ntsb/SEA84LA152.md): Cessna T188C · Pasco, WA · Accident · No injuries · Limited investigation · Final report · Jun 28, 1984 · N1964J · Substantial damage
  > While taxiing to takeoff, the right main gear got into soft terrain off the right edge to the rwy. This pulled the acft to the right & the right wing struck an embankment. The right main gear collapsed & the right wing was buckled.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073012')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 320))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2073012&occurrence=320

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