# NTSB investigations: Cessna 175, OR

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 GAA17CA302](https://openairdocs.org/ntsb/GAA17CA302.md): Cessna 175 · Prospect, OR · Accident · No injuries · Data collection · Final report · May 20, 2017 · N175DH · Substantial damage
  > The flight instructor’s failure to attain an adequate climb rate during takeoff, which resulted in impact with trees.
- [NTSB SEA00FA127](https://openairdocs.org/ntsb/SEA00FA127.md): Cessna 175 · Molalla, OR · Accident · 1 fatal · Field investigation · Final report · Jul 8, 2000 · N7625M · Destroyed
  > Failure to maintain clearance from mountainous/hilly terrain.
- [NTSB SEA85LA003](https://openairdocs.org/ntsb/SEA85LA003.md): Cessna 175 · Astoria, OR · Accident · No injuries · Limited investigation · Final report · Oct 6, 1984 · N9243B · Destroyed
  > The plt reported that during landing the acft started to skid to the left of the rwy. He applied rudder and aileron and then added power. The elevator was pulled back, the nose went up and the left wing went down. The acft hit the ground hard on the wing tip…
- [NTSB SEA72DYC23](https://openairdocs.org/ntsb/SEA72DYC23.md): Cessna 175 · Condon, OR · Accident · No injuries · Closed · Nov 13, 1971 · N7095M · Substantial damage
- [NTSB SEA66A0043](https://openairdocs.org/ntsb/SEA66A0043.md): Cessna 175 · Bonneville, OR · Accident · 4 fatal · Closed · Feb 6, 1966 · N7067M · Destroyed

## 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" = 'OR' 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=OR

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