# NTSB investigations: Cessna 172P, 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 DFW08CA148](https://openairdocs.org/ntsb/DFW08CA148.md): Cessna 172P · Rose Bud, AR · Accident · No injuries · Data collection · Final report · May 17, 2008 · N5350K · Substantial damage
  > The pilot landed long and collided with a fence.
- [NTSB FTW95LA166](https://openairdocs.org/ntsb/FTW95LA166.md): Cessna 172P · Mountain Home, AR · Accident · Minor injuries · Limited investigation · Final report · Apr 12, 1995 · N55409 · Substantial damage
  > The pilot's failure to compensate for the gusty crosswind. A factor was gusting crosswinds.
- [NTSB FTW93LA060](https://openairdocs.org/ntsb/FTW93LA060.md): Cessna 172P · Little Rock, AR · Accident · No injuries · Limited investigation · Final report · Dec 28, 1992 · N64943 · Substantial damage
  > The certified flight instructor's failure to attain the proper touchdown point.
- [NTSB FTW92LA091](https://openairdocs.org/ntsb/FTW92LA091.md): Cessna 172P · West Helena, AR · Accident · No injuries · Limited investigation · Final report · Mar 16, 1992 · N96493 · Substantial damage
  > Pilot's improper flarea ND improper recovery from a bounced landing.
- [NTSB FTW92LA086](https://openairdocs.org/ntsb/FTW92LA086.md): Cessna 172P · Harrison, AR · Accident · Minor injuries · Limited investigation · Final report · Mar 9, 1992 · N54956 · Substantial damage
  > The pilot's failure to attain the proper touchdown point, and his failure to maintain the proper descent rate.
- [NTSB FTW91LA116](https://openairdocs.org/ntsb/FTW91LA116.md): Cessna 172P · Lakeview, AR · Accident · No injuries · Limited investigation · Final report · Jul 4, 1991 · N64344 · Substantial damage
  > (1) The pilot's failure to properly flare the airplane for landing and (2) his subsequent improper recovery from a bounced landing.
- [NTSB DEN91LA060](https://openairdocs.org/ntsb/DEN91LA060.md): Cessna 172P · Lehi, AR · Accident · No injuries · Limited investigation · Final report · Apr 11, 1991 · N51254 · Substantial damage
  > The pilot's failure to maintain aircraft control. Factors were: the wet runway and resultant hydroplaning.
- [NTSB MKC89LA127](https://openairdocs.org/ntsb/MKC89LA127.md): Cessna 172 · Pine Bluff, AR · Accident · No injuries · Limited investigation · Final report · Jun 7, 1989 · N63535 · Substantial damage
  > Improper in-flight planning/decision by the pilot by continuing the approach when the runway lights did not activate. Contributing factors were: dark night and soft terrain.
- [NTSB FTW83LA352](https://openairdocs.org/ntsb/FTW83LA352.md): Cessna 172N · Morrilton, AR · Accident · Minor injuries · Limited investigation · Final report · Apr 28, 1983 · N54174 · Substantial damage
  > The acft collided with trees on the final approach to land at night. The plt had canceled his IFR clearance. During the approach the plt had the rwy in sight and asked memphis center how FAR he was from the arpt. When he was informed he WAS3 miles south he…

## 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 ('2072436'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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