# NTSB investigations: Cessna A188B, UT

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 WPR09CA303](https://openairdocs.org/ntsb/WPR09CA303.md): Cessna A188B · Ogden, UT · Accident · No injuries · Data collection · Final report · Jun 20, 2009 · N731GE · Substantial damage
  > A partial loss of engine power due to the number one cylinder air induction tube becoming disconnected for undetermined reasons.
- [NTSB DEN83LA163](https://openairdocs.org/ntsb/DEN83LA163.md): Cessna 188B · Hooper, UT · Accident · Minor injuries · Limited investigation · Final report · Jul 10, 1983 · N4886R · Substantial damage
  > The spraying operation was being conducted over a large mosquito abatement district. The district was mapped out into several small areas to be sprayed. Due to the many areas to be sprayed, the plt did not inspect each section for obstacles prior to the flt.…
- [NTSB DEN82DA101](https://openairdocs.org/ntsb/DEN82DA101.md): Cessna 188B · Central, UT · Accident · No injuries · Final report · Jun 11, 1982 · N8278G · Substantial damage
  > Pilot ran out of fuel and made a forced landing during which a wing collided with a fence.
- [NTSB DEN81FTM32](https://openairdocs.org/ntsb/DEN81FTM32.md): Cessna A188B · Layton, UT · Accident · Minor injuries · Closed · Jun 25, 1981 · N731HD · Substantial damage
- [NTSB DEN80DTM24](https://openairdocs.org/ntsb/DEN80DTM24.md): Cessna 188 · Vernal, UT · Accident · No injuries · Closed · Jun 18, 1980 · N9055R · Substantial damage
- [NTSB DEN77FTM19](https://openairdocs.org/ntsb/DEN77FTM19.md): Cessna 188B · Vernal, UT · Accident · Minor injuries · Closed · Jun 13, 1977 · N9300R · Substantial damage
- [NTSB DEN76DTM35](https://openairdocs.org/ntsb/DEN76DTM35.md): Cessna 188B · New Castle, UT · Accident · No injuries · Closed · May 14, 1976 · N9278R · 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" = 'UT' 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 ('2073005'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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