# NTSB investigations: Cessna 175, 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 FTW04LA229](https://openairdocs.org/ntsb/FTW04LA229.md): Cessna 175 · De Ridder, LA · Accident · No injuries · Limited investigation · Final report · Sep 2, 2004 · N6517E · Substantial damage
  > The partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW98LA039](https://openairdocs.org/ntsb/FTW98LA039.md): Cessna 175 · Arnaudville, LA · Accident · No injuries · Limited investigation · Final report · Nov 2, 1997 · N9437B · Substantial damage
  > a cracked fuel line, which allowed air to enter the line and lead to fuel starvation and loss of engine power. A related factor was: the lack of suitable terrain for a forced landing.
- [NTSB FTW94LA109](https://openairdocs.org/ntsb/FTW94LA109.md): Cessna 175 · Leesville, LA · Accident · No injuries · Limited investigation · Final report · Mar 20, 1994 · N6537E · Substantial damage
  > The loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.
- [NTSB FTW85LA062](https://openairdocs.org/ntsb/FTW85LA062.md): Cessna 175 · Bastrop, LA · Accident · Minor injuries · Limited investigation · Final report · Dec 1, 1984 · N7327M · Substantial damage
  > Plt stated that on preflight a small amount of water was drained from each wing tank. Also, the main fuel strainer was drained and fuel tanks were topped off (17 gals added). At about 500 ft AGL on initial climb, the engine quit and restart attempts were…
- [NTSB FTW70D0043](https://openairdocs.org/ntsb/FTW70D0043.md): Cessna 175 · Flora, LA · Accident · No injuries · Closed · Apr 9, 1969 · N6634E · Substantial damage
- [NTSB FTW67A0059](https://openairdocs.org/ntsb/FTW67A0059.md): Cessna 175 · Alexandria, LA · Accident · 2 fatal · Closed · Dec 3, 1966 · N8185T · Destroyed
- [NTSB FTW66D0049](https://openairdocs.org/ntsb/FTW66D0049.md): Cessna 175 · Bastrop, LA · Accident · No injuries · Closed · May 10, 1965 · N9378B · Substantial damage
- [NTSB UNK65X1423](https://openairdocs.org/ntsb/UNK65X1423.md): Cessna 175 · Abbeville, LA · Accident · No injuries · Closed · Feb 14, 1965 · N6681E · 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 ('2072502'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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