# NTSB investigations: Cessna 172I, 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 DEN04FA104](https://openairdocs.org/ntsb/DEN04FA104.md): Cessna 172I · Paris, AR · Accident · 2 fatal · Field investigation · Final report · Jul 11, 2004 · N46174 · Destroyed
  > the pilot's inadequate preflight preparation, his attempted flight into adverse weather conditions, and his failure to maintain clearance from the trees resulting in the airplane's collision with the trees and subsequent impact with the ground. Factors…
- [NTSB FTW83LA281](https://openairdocs.org/ntsb/FTW83LA281.md): Cessna 172I · Forrest City, AR · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 1983 · N35520 · Destroyed
  > The acft experienced power failure from about 20 feet AGL during takeoff from a private grass strip. A witness heard theengine spit and pop during the takeoff roll. He said it sounded just like his old pickup when it runs out of gas. After the accident the…
- [NTSB FTW80DPG68](https://openairdocs.org/ntsb/FTW80DPG68.md): Cessna 172I · Marianna, AR · Accident · No injuries · Closed · Sep 20, 1980 · N46047 · Substantial damage
- [NTSB FTW76DPG96](https://openairdocs.org/ntsb/FTW76DPG96.md): Cessna 172 · Centerville, AR · Accident · Minor injuries · Closed · Aug 15, 1976 · N46048 · Substantial damage
- [NTSB FTW74FPG73](https://openairdocs.org/ntsb/FTW74FPG73.md): Cessna 172 · N.Little Rock, AR · Accident · Serious injuries · Closed · Jun 16, 1974 · N35520 · Substantial damage
- [NTSB FTW74DPG39](https://openairdocs.org/ntsb/FTW74DPG39.md): Cessna 172 · Carlisle, AR · Accident · No injuries · Closed · Nov 29, 1973 · N8462L · Substantial damage
- [NTSB FTW74FPG04](https://openairdocs.org/ntsb/FTW74FPG04.md): Cessna 172I · Mena, AR · Accident · No injuries · Closed · Jul 21, 1973 · N35555 · Substantial damage
- [NTSB FTW69D0280](https://openairdocs.org/ntsb/FTW69D0280.md): Cessna 172 · Fort Smith, AR · Accident · No injuries · Closed · Nov 10, 1968 · N8382L · 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" = '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 ('2072426'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072426&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.