# NTSB investigations: Cessna 175A: Nose over/nose down

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 WPR14CA264](https://openairdocs.org/ntsb/WPR14CA264.md): Cessna 175A · Salmon, ID · Accident · No injuries · Data collection · Final report · Jun 19, 2014 · N7936T · Substantial damage
  > The pilot's failure to attain the proper touchdown point that resulted in a runway overrun.
- [NTSB CEN13CA234](https://openairdocs.org/ntsb/CEN13CA234.md): Cessna 175A · Albuquerque, NM · Accident · No injuries · Data collection · Final report · Apr 20, 2013 · N6955E · Substantial damage
  > The pilot’s inability to maintain airplane control during taxi due to an inadvertent encounter with a dust devil.
- [NTSB CEN12LA455](https://openairdocs.org/ntsb/CEN12LA455.md): Cessna 175A · Shelby, IL · Accident · No injuries · Limited investigation · Final report · Jul 17, 2012 · N7003E · Substantial damage
  > The loss of engine power due to oil starvation for reasons that could not be determined because engine examinations revealed no malfunctions or failures that would have led to oil starvation.
- [NTSB WPR09CA285](https://openairdocs.org/ntsb/WPR09CA285.md): Cessna 175A · Polacca, AZ · Accident · No injuries · Data collection · Final report · Jun 12, 2009 · N7979T · Substantial damage
  > The pilot’s failure to adequately estimate the required distance to avoid obstructions while taking off from a road.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072504')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '096' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/096/sequence?model=2072504

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