# NTSB investigations: Cessna 172F, 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 CEN24LA232](https://openairdocs.org/ntsb/CEN24LA232.md): Cessna 172F · Ruston, LA · Accident · No injuries · Class 4 · Limited · Final report · Jun 19, 2024 · N8725U · Substantial damage
  > The student pilot’s failure to maintain directional control during the landing roll with a crosswind.
- [NTSB GAA20CA006](https://openairdocs.org/ntsb/GAA20CA006.md): Cessna 172 · Kaplan, LA · Accident · Minor injuries · Data collection · Final report · Oct 5, 2019 · N7871U · Substantial damage
  > The pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and impact with a pole during an off-airport landing.
- [NTSB FTW98LA070](https://openairdocs.org/ntsb/FTW98LA070.md): Cessna 172F · Gonzales, LA · Accident · Serious injuries · Limited investigation · Final report · Dec 18, 1997 · N8426U · Substantial damage
  > The inadvertent stall resulting from the flight instructor's failure to maintain airspeed during his delayed recovery from the bounced landing. Factors were the student's failure to maintain the proper airspeed and the instructor's inadequate supervision…
- [NTSB FTW75FRD38](https://openairdocs.org/ntsb/FTW75FRD38.md): Cessna 172F · Slidell, LA · Accident · Minor injuries · Closed · Mar 31, 1975 · N7902U · Substantial damage
- [NTSB FTW67F0650](https://openairdocs.org/ntsb/FTW67F0650.md): Cessna 172 · Freemason Isle, LA · Accident · No injuries · Closed · Jun 11, 1967 · N7983U · Substantial damage
- [NTSB FTW67A0113](https://openairdocs.org/ntsb/FTW67A0113.md): Cessna 172F · Houma, LA · Accident · 1 fatal · Closed · May 30, 1967 · N8806U · Substantial damage
- [NTSB FTW67F0591](https://openairdocs.org/ntsb/FTW67F0591.md): Cessna 172 · Haynesville, LA · Accident · Serious injuries · Closed · May 3, 1967 · N7895U · Destroyed
- [NTSB FTW67D0204](https://openairdocs.org/ntsb/FTW67D0204.md): Cessna 172 · Boyce, LA · Accident · No injuries · Closed · Sep 18, 1966 · N8233U · Substantial damage
- [NTSB FTW66F0384](https://openairdocs.org/ntsb/FTW66F0384.md): Cessna 172 · Tallulah, LA · Accident · No injuries · Closed · Sep 30, 1965 · N7895U · Substantial damage
- [NTSB FTW66D0065](https://openairdocs.org/ntsb/FTW66D0065.md): Cessna 172 · Baton Rouge, LA · Accident · No injuries · Closed · Jun 10, 1965 · N7902U · Substantial damage
- [NTSB UNK65X1473](https://openairdocs.org/ntsb/UNK65X1473.md): Cessna 172 · Elizabeth, LA · Accident · No injuries · Closed · Mar 17, 1965 · N8416U · 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 ('2072414'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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