# NTSB investigations: Cessna 175, OK

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 DFW06LA060](https://openairdocs.org/ntsb/DFW06LA060.md): Cessna 175 · Lindsay, OK · Accident · No injuries · Limited investigation · Final report · Jan 26, 2006 · N6612E · Substantial damage
  > The hard landing was the result of the pilot's failure to maintain adequate airspeed while misjudging the altitude above the runway. Contributing factors were the inadequate quality of the manufacturer's engine-support bracket and the prevailing night…
- [NTSB FTW94FA295](https://openairdocs.org/ntsb/FTW94FA295.md): Cessna 175 · Oklahoma City, OK · Accident · 2 fatal · Field investigation · Final report · Sep 10, 1994 · N7554M · Substantial damage
  > Improper maintenance of the engine by unknown person(s), the installation of unapproved parts, and subsequent bearing seizure. The lack of suitable terrain in the forced landing area was a related factor.
- [NTSB FTW78FPM03](https://openairdocs.org/ntsb/FTW78FPM03.md): Cessna 175 · Pryor, OK · Accident · No injuries · Closed · Jan 13, 1978 · N7141M · Substantial damage
- [NTSB FTW74AF025](https://openairdocs.org/ntsb/FTW74AF025-201610.md): Cessna 175 · Wister, OK · Accident · 2 fatal · Closed · Oct 27, 1973 · N7685M · Destroyed
- [NTSB FTW68F0364](https://openairdocs.org/ntsb/FTW68F0364.md): Cessna 175 · Mooreland, OK · Accident · No injuries · Closed · Nov 20, 1967 · N9431B · Substantial damage
- [NTSB FTW68D0094](https://openairdocs.org/ntsb/FTW68D0094.md): Cessna 175 · Oklahoma Cty, OK · Accident · No injuries · Closed · Jul 14, 1967 · N7232M · Substantial damage
- [NTSB FTW67F0639](https://openairdocs.org/ntsb/FTW67F0639.md): Cessna 175 · Mangum, OK · Accident · Serious injuries · Closed · May 16, 1967 · N7399M · Destroyed
- [NTSB FTW67D0224](https://openairdocs.org/ntsb/FTW67D0224.md): Cessna 175 · Perry, OK · Accident · No injuries · Closed · Oct 2, 1966 · N6593E · Destroyed
- [NTSB UNK64X0912](https://openairdocs.org/ntsb/UNK64X0912.md): Cessna 175 · Okla City, OK · Accident · No injuries · Closed · Mar 14, 1964 · N9213B · 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" = 'OK' 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=OK

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