# NTSB investigations: Cessna 172, 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 CEN15FA278](https://openairdocs.org/ntsb/CEN15FA278.md): Cessna 172 · Shreveport, LA · Accident · 1 fatal · Field investigation · Final report · Jun 19, 2015 · N5743A · Substantial damage
  > The pilot's loss of airplane control during initial climb after takeoff for reasons that could not be determined because an examination of the airframe and engine did not reveal any preimpact anomalies.
- [NTSB FTW81FA059](https://openairdocs.org/ntsb/FTW81FA059.md): Cessna 172P · Lake Charles, LA · Accident · 1 fatal · Closed · Mar 27, 1981 · N52710 · Destroyed
- [NTSB FTW78FRJ05](https://openairdocs.org/ntsb/FTW78FRJ05.md): Cessna 172 · Ruston, LA · Accident · No injuries · Closed · Nov 2, 1977 · N7123T · Substantial damage
- [NTSB FTW72DRD28](https://openairdocs.org/ntsb/FTW72DRD28.md): Cessna 172 · Venice, LA · Accident · No injuries · Closed · May 29, 1972 · N9114B · Substantial damage
- [NTSB FTW72DRJ11](https://openairdocs.org/ntsb/FTW72DRJ11.md): Cessna 172 · Lecompte, LA · Accident · Minor injuries · Closed · Oct 16, 1971 · N7486A · Substantial damage
- [NTSB FTW69F0373](https://openairdocs.org/ntsb/FTW69F0373-191926.md): Cessna 172 · Oak Grove, LA · Accident · No injuries · Closed · Dec 28, 1968 · N7281A · Substantial damage
- [NTSB FTW68F0218](https://openairdocs.org/ntsb/FTW68F0218.md): Cessna 172 · Pollock, LA · Accident · Minor injuries · Closed · Sep 3, 1967 · N5929R · Substantial damage
- [NTSB FTW67D0626](https://openairdocs.org/ntsb/FTW67D0626.md): Cessna 172 · Chandeleur Isl, LA · Accident · No injuries · Closed · May 27, 1967 · N4021F · Substantial damage
- [NTSB FTW67D0219](https://openairdocs.org/ntsb/FTW67D0219.md): Cessna 172 · Hammond, LA · Accident · No injuries · Closed · Sep 23, 1966 · N5740A · Substantial damage
- [NTSB FTW66A0109](https://openairdocs.org/ntsb/FTW66A0109.md): Cessna 172 · Boyce, LA · Accident · 1 fatal · Closed · May 28, 1966 · N5886A · Destroyed
- [NTSB FTW66D0623](https://openairdocs.org/ntsb/FTW66D0623.md): Cessna 172 · Freemason Is, LA · Accident · No injuries · Closed · Apr 8, 1966 · N7967B · Substantial damage
- [NTSB FTW66D0528](https://openairdocs.org/ntsb/FTW66D0528.md): Cessna 172 · Franklin, LA · Accident · No injuries · Closed · Mar 12, 1966 · N5757A · Substantial damage
- [NTSB FTW66D0272](https://openairdocs.org/ntsb/FTW66D0272.md): Cessna 172 · De Quincy, LA · Accident · No injuries · Closed · Aug 26, 1965 · N5621A · 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 ('2072402'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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