# NTSB investigations: Cessna 172M, LA

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 CEN13LA249](https://openairdocs.org/ntsb/CEN13LA249.md): Cessna 172M · Covington, LA · Accident · Minor injuries · Limited investigation · Final report · May 1, 2013 · N8899V · Substantial damage
  > The pilot’s failure to maintain airspeed during a banner towing operation, which resulted in the airplane stalling and landing hard.
- [NTSB FTW01LA133](https://openairdocs.org/ntsb/FTW01LA133.md): Cessna 172M · Patterson, LA · Accident · No injuries · Limited investigation · Final report · May 4, 2001 · N5247R · Substantial damage
  > the pilot's failure to maintain control during the go-around. A contributing factor was the wind gust.
- [NTSB FTW90LA029](https://openairdocs.org/ntsb/FTW90LA029.md): Cessna 172 · Port Allen, LA · Accident · No injuries · Limited investigation · Final report · Nov 20, 1989 · N13055 · Substantial damage
  > Fuel system contamination due to inadequate maintenance/service of the airplane.
- [NTSB FTW85LA304](https://openairdocs.org/ntsb/FTW85LA304.md): Cessna 172 M · Arcadia, LA · Accident · No injuries · Limited investigation · Final report · Aug 3, 1985 · N5045H · Substantial damage
  > The plt stated he heard a 'boom' and experienced a partial power loss when he was about 10 ft above the rwy during the initial takeoff climb. He was about half way down the 3000 foot rwy at this time. He aborted the takeoff and landed. However, he was not…
- [NTSB FTW85LA164](https://openairdocs.org/ntsb/FTW85LA164.md): Cessna 172M · Angola, LA · Accident · No injuries · Limited investigation · Final report · Mar 24, 1985 · N73616 · Substantial damage
  > The acft touched down short of the rwy following an approach to land after the plt had accomplished a x-country flt with a pass'g on board. The plt stated that he became momentarily disoriented due to haze & bright sunlight during the approach. During this…
- [NTSB FTW81DRD11](https://openairdocs.org/ntsb/FTW81DRD11.md): Cessna 172M · Belle Chasse, LA · Accident · No injuries · Closed · Dec 26, 1980 · N73214 · Substantial damage
- [NTSB FTW80DRD40](https://openairdocs.org/ntsb/FTW80DRD40.md): Cessna 172 · Delacroix, LA · Accident · No injuries · Closed · Jun 5, 1980 · N4478R · Destroyed
- [NTSB FTW79FRD42](https://openairdocs.org/ntsb/FTW79FRD42.md): Cessna 172 · Grand Isle, LA · Accident · No injuries · Closed · Jun 24, 1979 · N73214 · Substantial damage
- [NTSB FTW79DRD18](https://openairdocs.org/ntsb/FTW79DRD18.md): Cessna 172M · Franklinton, LA · Accident · No injuries · Closed · Mar 8, 1979 · N80991 · Substantial damage
- [NTSB FTW77DRD23](https://openairdocs.org/ntsb/FTW77DRD23.md): Cessna 172 · Melville, LA · Accident · No injuries · Closed · May 10, 1977 · N1247U · Destroyed
- [NTSB FTW76FRD64](https://openairdocs.org/ntsb/FTW76FRD64.md): Cessna 172M · Lake Charles, LA · Accident · No injuries · Closed · Aug 28, 1976 · N80347 · Destroyed
- [NTSB FTW76AF113](https://openairdocs.org/ntsb/FTW76AF113.md): Cessna 172 · Baker, LA · Accident · 1 fatal · Closed · Aug 8, 1976 · N12697 · Destroyed
- [NTSB FTW76DRJ28](https://openairdocs.org/ntsb/FTW76DRJ28.md): Cessna 172 · Many, LA · Accident · No injuries · Closed · May 30, 1976 · N13441 · Substantial damage
- [NTSB FTW76DRJ22](https://openairdocs.org/ntsb/FTW76DRJ22.md): Cessna 172M · Alexandria, LA · Accident · No injuries · Closed · Apr 21, 1976 · N80327 · Substantial damage
- [NTSB FTW76ARD25](https://openairdocs.org/ntsb/FTW76ARD25.md): Cessna 172 · Lafayette, LA · Accident · Minor injuries · Closed · Dec 18, 1975 · N5092R · 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" = 'LA' 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 ('2072418'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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