# NTSB investigations: Cessna T188C, SD

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 DEN86LA176](https://openairdocs.org/ntsb/DEN86LA176.md): Cessna T188 · Kimball, SD · Accident · No injuries · Limited investigation · Final report · Jun 27, 1986 · N2507J · Substantial damage
  > According to the plt, the acft he was piloting encountered unfavorable winds during the aerial application maneuver and stalled. The plt indicated that during the touchdown, the main gear collapsed and the acft was substantially damaged.
- [NTSB DEN84LA197](https://openairdocs.org/ntsb/DEN84LA197.md): Cessna T188C · Philip, SD · Accident · No injuries · Limited investigation · Final report · Jun 25, 1984 · N9952J · Substantial damage
  > The plt lost control of the acft during takeoff ground run when his vision was obscured by water which was sprayed on the windshield from a light rain shower.
- [NTSB DEN83LA164](https://openairdocs.org/ntsb/DEN83LA164.md): Cessna T188C · Carthage, SD · Accident · No injuries · Limited investigation · Final report · Jul 14, 1983 · N2060J · Substantial damage
  > The acft was using a county road near the field being sprayed for takeoff. The pilot reported that the herbicide sloshedout onto the windscreen during takeoff and obscured his vision. The acft veered right and entered the ditch. The pilot said the hopper lid…
- [NTSB DEN81DTK09](https://openairdocs.org/ntsb/DEN81DTK09.md): Cessna T188C · White Lake, SD · Accident · No injuries · Closed · May 25, 1981 · N2559J · 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" = 'SD' 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 ('2073012'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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