# NTSB investigations: Cessna 177, 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 FTW85LA155](https://openairdocs.org/ntsb/FTW85LA155.md): Cessna 177 · Monroe, LA · Accident · No injuries · Limited investigation · Final report · Mar 19, 1985 · N2207Y · Substantial damage
  > Aprx 15 mins after departure, on final apch to Monroe regional arpt the eng lost pwr due to fuel exhaustion. During the forced landing the acft struck cable tv lines and trees causing a right yaw and uncontrolled descent to the ground. The student plt stated…
- [NTSB FTW77FRD37](https://openairdocs.org/ntsb/FTW77FRD37.md): Cessna 177 · New Orleans, LA · Accident · Serious injuries · Closed · Jun 27, 1977 · N29387 · Destroyed
- [NTSB FTW76AF082](https://openairdocs.org/ntsb/FTW76AF082.md): Cessna 177 · New Iberia, LA · Accident · 1 fatal · Closed · Apr 3, 1976 · N2894X · 2 aircraft · Destroyed
- [NTSB FTW74DRJ22](https://openairdocs.org/ntsb/FTW74DRJ22.md): Cessna 177 · Jonesville, LA · Accident · No injuries · Closed · Dec 29, 1973 · N3170T · Substantial damage
- [NTSB FTW73FRD30](https://openairdocs.org/ntsb/FTW73FRD30.md): Cessna 177 · New Orleans, LA · Accident · No injuries · Closed · May 20, 1973 · N3146T · Substantial damage
- [NTSB FTW72AF078](https://openairdocs.org/ntsb/FTW72AF078.md): Cessna 177 · Many, LA · Accident · 1 fatal · Closed · May 18, 1972 · N3344T · Destroyed
- [NTSB FTW72FRD06](https://openairdocs.org/ntsb/FTW72FRD06.md): Cessna 177 · Baton Rouge, LA · Accident · Serious injuries · Closed · Aug 11, 1971 · N2951X · 2 aircraft · Substantial damage
- [NTSB FTW71AF024](https://openairdocs.org/ntsb/FTW71AF024.md): Cessna 177 · Indian Bayou, LA · Accident · 2 fatal · Closed · Nov 23, 1970 · N2874X · Destroyed
- [NTSB FTW70DRD09](https://openairdocs.org/ntsb/FTW70DRD09.md): Cessna 177 · Lacassine, LA · Accident · No injuries · Closed · Mar 29, 1970 · N29503 · Substantial damage
- [NTSB FTW70F0339](https://openairdocs.org/ntsb/FTW70F0339.md): Cessna 177 · Berwick, LA · Accident · Minor injuries · Closed · Dec 27, 1969 · N29549 · Substantial damage
- [NTSB FTW70F0265](https://openairdocs.org/ntsb/FTW70F0265.md): Cessna 177 · Georgetown, LA · Accident · Minor injuries · Closed · Oct 2, 1969 · N2928X · Destroyed
- [NTSB FTW70D0012](https://openairdocs.org/ntsb/FTW70D0012.md): Cessna 177 · Kaplan, LA · Accident · No injuries · Closed · Jun 14, 1969 · N2298Y · Substantial damage
- [NTSB FTW69F0366](https://openairdocs.org/ntsb/FTW69F0366.md): Cessna 177 · Baton Rouge, LA · Accident · No injuries · Closed · Jan 4, 1969 · N29655 · 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 ('2073704'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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