# NTSB investigations: Cessna 172F, AR

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 DFW05FA082](https://openairdocs.org/ntsb/DFW05FA082.md): Cessna 172F · Hot Springs, AR · Accident · 1 fatal · Field investigation · Final report · Mar 8, 2005 · N8382U · Substantial damage
  > A loss of engine power due to the pilot's failure to refuel resulting in fuel starvation. Contributing factors were the lack of suitable terrain for the forced landing, and a shoulder harness restraint system was not installed.
- [NTSB MKC87LA098](https://openairdocs.org/ntsb/MKC87LA098.md): Cessna 172F · Blythville, AR · Accident · No injuries · Limited investigation · Final report · Apr 30, 1987 · N8800U · Substantial damage
  > The eng started to slow down ten miles from the destination arpt and despite emergency measures, it stopped two miles out. The forced landing was in a plowed field and when the nose wheel dug in, the acft flipped forward to the inverted position. The…
- [NTSB FTW80DPG33](https://openairdocs.org/ntsb/FTW80DPG33.md): Cessna 172F · Benton, AR · Accident · No injuries · Closed · Jun 4, 1980 · N5410R · Substantial damage
- [NTSB FTW75FPG62](https://openairdocs.org/ntsb/FTW75FPG62.md): Cessna 172F · Calico Rock, AR · Accident · Minor injuries · Closed · May 17, 1975 · N5230F · Substantial damage
- [NTSB FTW74DPG68](https://openairdocs.org/ntsb/FTW74DPG68.md): Cessna 172 · Fordyce, AR · Accident · Minor injuries · Closed · Jun 2, 1974 · N5390R · Substantial damage
- [NTSB FTW74DPG51](https://openairdocs.org/ntsb/FTW74DPG51.md): Cessna 172F · Blytheville, AR · Accident · No injuries · Closed · Mar 30, 1974 · N5159F · Substantial damage
- [NTSB FTW73FPG26](https://openairdocs.org/ntsb/FTW73FPG26.md): Cessna 172 · N.Little Rock, AR · Accident · Minor injuries · Closed · Oct 1, 1972 · N5473R · Substantial damage
- [NTSB FTW70FPG16](https://openairdocs.org/ntsb/FTW70FPG16.md): Cessna 172 · El Dorado, AR · Accident · No injuries · Closed · Apr 17, 1970 · N8404U · Substantial damage
- [NTSB FTW70F0104](https://openairdocs.org/ntsb/FTW70F0104.md): Cessna 172F · Brinkley, AR · Accident · 1 fatal · Closed · Jun 28, 1969 · N5534R · Destroyed
- [NTSB FTW69A0022](https://openairdocs.org/ntsb/FTW69A0022.md): Cessna 172 · Hot Springs, AR · Accident · 4 fatal · Closed · Oct 7, 1968 · N8225U · 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" = 'AR' 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 ('2072414'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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