# NTSB investigations: Cessna A188: In flight collision with object

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 ATL95LA111](https://openairdocs.org/ntsb/ATL95LA111.md): Cessna 188D · Athens, AL · Accident · No injuries · Limited investigation · Final report · Jun 15, 1995 · N8035V · Destroyed
  > The pilot's inadequate lookout, and his failure to maintain clearance from the utility line.
- [NTSB FTW92DPG13](https://openairdocs.org/ntsb/FTW92DPG13.md): Cessna A188 · Forrest City, AR · Accident · 1 fatal · Final report · Aug 6, 1992 · N9858V · Destroyed
  > The pilot's failure to maintain clearance with the trees.
- [NTSB CHI82FA174](https://openairdocs.org/ntsb/CHI82FA174.md): Cessna A188 · Blue Earth, MN · Accident · 1 fatal · Field investigation · Final report · May 19, 1982 · N9819V · Destroyed
  > The flagman stated that during the swath run the acft was following the contour of the field. The flagman thought the plt was getting close to the end of the field & was about to call him on the radio when the acft pulled up to about a 45 deg nose high…

## 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 ('2073004')
    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" = 220))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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