# NTSB investigations: Cessna 175A, IN

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 CHI88DEX07](https://openairdocs.org/ntsb/CHI88DEX07.md): Cessna 175A · Bloomington, IN · Accident · Minor injuries · Final report · Jul 8, 1988 · N8059T · Substantial damage
  > Aircraft experienced partial loss of engine power at 150 feet AGL after takeoff. Pilot made 180 degree turn in attempt to return to airport, but experienced further power loss and elected to make emergency landing in field. Right wingtip hit tree, and…
- [NTSB CHI76FEA26](https://openairdocs.org/ntsb/CHI76FEA26.md): Cessna 175A · Glendale, IN · Accident · No injuries · Closed · Feb 13, 1976 · N6966E · Substantial damage
- [NTSB CHI74DEA30](https://openairdocs.org/ntsb/CHI74DEA30.md): Cessna 175 · Lafayette, IN · Accident · No injuries · Closed · Feb 28, 1974 · N6883E · Substantial damage
- [NTSB CHI69D0619](https://openairdocs.org/ntsb/CHI69D0619.md): Cessna 175 · Gary, IN · Accident · Minor injuries · Closed · Mar 22, 1969 · N6984E · Substantial damage
- [NTSB CHI67F0405](https://openairdocs.org/ntsb/CHI67F0405.md): Cessna 175A · Martinsville, IN · Accident · No injuries · Closed · Dec 17, 1966 · N6997E · 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" = 'IN' 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 ('2072504'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072504&state=IN

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