# NTSB investigations: Cessna 195, 1988

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 MKC88LA169](https://openairdocs.org/ntsb/MKC88LA169.md): Cessna 195 · Keokuk, IA · Accident · No injuries · Limited investigation · Final report · Sep 8, 1988 · N3040B · Substantial damage
  > The new owner of the acft asked the former owner to ride with him in the right seat while doing some touch and go landings. After the first circuit the former owner said he felt the pilot needed additional training before attempting to fly the acft as PIC.…
- [NTSB DEN88LA189](https://openairdocs.org/ntsb/DEN88LA189.md): Cessna 195 · Rawlins, WY · Accident · Minor injuries · Limited investigation · Final report · Aug 25, 1988 · N3455V · Substantial damage
- [NTSB NYC88LA070](https://openairdocs.org/ntsb/NYC88LA070.md): Cessna 195 · Meriden, CT · Accident · No injuries · Limited investigation · Final report · Jan 31, 1988 · N1077D · Substantial damage
  > After performing several touch and go landings, the student pilot made a landing right of the center line. The aircraft drifted to the right, struck a snowbank, sheared off the left main landing gear, then groundlooped. The aircraft came to rest on the grass…

## 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 year(c."eventDate") = 1988
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073102'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2073102&year=1988

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
