# Final NTSB investigations: Cessna A188A, ND

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 CHI95LA241](https://openairdocs.org/ntsb/CHI95LA241.md): Cessna 188 · Bremen, ND · Accident · No injuries · Limited investigation · Final report · Jul 29, 1995 · N9980G · Destroyed
  > the pilot's inadequate preflight planning. Deteriating aircraft performance was a factor.
- [NTSB DEN89DTG01](https://openairdocs.org/ntsb/DEN89DTG01.md): Cessna 188A · Valley City, ND · Accident · 1 fatal · Final report · Aug 6, 1989 · N188TV · Destroyed
  > Inadequate visual lookout by the pilot. The power line was a related factor.
- [NTSB DEN84LA255](https://openairdocs.org/ntsb/DEN84LA255.md): Cessna 188A · Jamestown, ND · Accident · No injuries · Limited investigation · Final report · Aug 8, 1984 · N5634J · Substantial damage
  > Plt stated, 'landing at dusk into sun. Landed into hill. Hard landing knocking feet (right) off rudder. Airplane groundlooped to left, hit ditch and flipped on its top.' Plt also stated fatigue from flying 4 hours on the day of the accident was a contributing…
- [NTSB MKC72FTG01](https://openairdocs.org/ntsb/MKC72FTG01.md): Cessna 188 · Grafton, ND · Accident · No injuries · Closed · Jul 1, 1971 · N9946G · Destroyed

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

This list as a web page: https://openairdocs.org/ntsb?model=2073008&state=ND&status=final

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