# Fatal NTSB investigations: Cessna A188B, AL

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 MIA95LA204](https://openairdocs.org/ntsb/MIA95LA204.md): Cessna A188B · Muscle Shoals, AL · Accident · 1 fatal · Limited investigation · Final report · Aug 13, 1995 · N4940R · Destroyed
  > Failure of the pilot to maintain adequate visual lookout to see-and-avoid electrical power lines, while approaching a field for aerial application.
- [NTSB ATL89DKJ09](https://openairdocs.org/ntsb/ATL89DKJ09.md): Cessna 188B · Prattville, AL · Accident · 1 fatal · Final report · Aug 16, 1989 · N9318G · Destroyed
  > Failure of the pilot to maintain clearance from obstructions (trees).
- [NTSB ATL89DKJ07](https://openairdocs.org/ntsb/ATL89DKJ07.md): Cessna A188B · Town Creek, AL · Accident · 1 fatal · Final report · Jul 22, 1989 · N5618G · Destroyed
  > The inadvertent stall at an altitude inadequate to effect a safe recovery.
- [NTSB ATL84FKJ02](https://openairdocs.org/ntsb/ATL84FKJ02.md): Cessna A188B · Hazel Green, AL · Accident · 1 fatal · Final report · Oct 29, 1983 · N731JJ · Destroyed
  > The acft collided with the ground while the plt was flying near his rural home. No preimpact, mechanical malfunction or failure was found. According to the medical examiner, the plt had severe & extensive coronary arterioscleroses; however, the relationship…

## 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" = 'AL' AND c."eventCountry" = 'USA'
  AND c."highestInjuryLevel" = 'Fatal'
  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?fatal=1&model=2073005&state=AL

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