# NTSB investigations: Cessna 175, AL

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 ERA23LA331](https://openairdocs.org/ntsb/ERA23LA331.md): Cessna 175 · Wetumpka, AL · Accident · No injuries · Class 3 · Limited · Final report · Aug 11, 2023 · N7117M · Substantial damage
  > A total loss of engine power due to the separation of the No. 3 connecting rod from the crankshaft.
- [NTSB ATL84LA228](https://openairdocs.org/ntsb/ATL84LA228.md): Cessna 175 · Enterprise, AL · Accident · No injuries · Limited investigation · Final report · Jul 20, 1984 · N7278M · Substantial damage
  > A witness observed the airplane slipping on final apch. The aircraft lost too much altitude and hit the terrain short of the runway. The airplane damage indicated that the pilot failed to correct the slip condition in time to arrest the descent.
- [NTSB ATL83LA148](https://openairdocs.org/ntsb/ATL83LA148.md): Cessna 175 · Tuscaloosa, AL · Accident · No injuries · Limited investigation · Final report · Apr 3, 1983 · N7588M · Substantial damage
  > The aircraft landed off the runway in soft terrain during a forced landing and nosed down. According to the pilot the engine began to run rough at 400 AGL on takeoff. He turned back toward the field and the engine quit. The pilot could not complete the turn…
- [NTSB MIA67F0402](https://openairdocs.org/ntsb/MIA67F0402.md): Cessna 175 · Lanett, AL · Accident · No injuries · Closed · Jan 18, 1967 · N7434M · Substantial damage
- [NTSB MIA66F0103](https://openairdocs.org/ntsb/MIA66F0103.md): Cessna 175 · Guntersville, AL · Accident · No injuries · Closed · May 5, 1965 · N9260B · Substantial damage
- [NTSB MIA65D0082](https://openairdocs.org/ntsb/MIA65D0082.md): Cessna 175 · Tishabee, AL · Accident · No injuries · Closed · Apr 4, 1965 · N7278M · Substantial damage
- [NTSB UNK65X1098](https://openairdocs.org/ntsb/UNK65X1098.md): Cessna 175 · Leeds, AL · Accident · 1 fatal · Closed · Dec 22, 1964 · N7086M · Substantial damage
- [NTSB UNK65X0272](https://openairdocs.org/ntsb/UNK65X0272.md): Cessna 175 · Cuba, AL · Accident · 2 fatal · Closed · Oct 14, 1964 · N6691E · Destroyed
- [NTSB UNK64X1405](https://openairdocs.org/ntsb/UNK64X1405.md): Cessna 175 · Montgomery, AL · Accident · No injuries · Closed · Apr 21, 1964 · N7220M · 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" = 'AL' 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=AL

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