# NTSB investigations: Cessna 172B, 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 WPR13LA378](https://openairdocs.org/ntsb/WPR13LA378.md): Cessna 172B · Sisters, OR · Accident · No injuries · Limited investigation · Final report · Aug 18, 2013 · N8141X · Substantial damage
  > A loss of engine power during cruise flight for reasons that could not be determined because the engine was not properly preserved to prevent corrosion after the wreckage was recovered from the lake.
- [NTSB LAX07CA242](https://openairdocs.org/ntsb/LAX07CA242.md): Cessna 172B · Sisters, OR · Accident · No injuries · Data collection · Final report · Aug 7, 2007 · N7604X · Substantial damage
  > The pilot's failure to maintain adequate clearance from trees.
- [NTSB SEA00LA168](https://openairdocs.org/ntsb/SEA00LA168.md): Cessna 172B · Sunriver, OR · Accident · No injuries · Limited investigation · Final report · Aug 20, 2000 · N8178X · Substantial damage
  > The pilot's improper decision to continue the takeoff after the aircraft failed to climb or accelerate immediately after the initial liftoff. Factors were inadequate preflight planning, to include the pilot's failure to calculate takeoff performance data,…
- [NTSB SEA86LA005](https://openairdocs.org/ntsb/SEA86LA005.md): Cessna 172 · Medford, OR · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 1985 · N7798X · Destroyed
  > The acft collided with rocky terrain during an attempted forced landing following a loss of pwr. A witness reported seeing the acft in a steep descending left turn at an alt of aprx 100 ft AGL. The descent continued until the left wing contacted the terrain.…
- [NTSB SEA85LA143](https://openairdocs.org/ntsb/SEA85LA143.md): Cessna 172B · Imbler, OR · Accident · No injuries · Limited investigation · Final report · Jun 22, 1985 · N6987X · Substantial damage
  > During takeoff from a field (off arpt), the acft failed to clear a fence. The pilot then attempted to abort the takeoff, but the acft hit a bale of hay & nosed over. The plt's last medical certificate was dated 9/2/82.
- [NTSB SEA68F0290](https://openairdocs.org/ntsb/SEA68F0290.md): Cessna 172 · Bend, OR · Accident · No injuries · Closed · Apr 7, 1968 · N7831X · Substantial damage
- [NTSB SEA68D0202](https://openairdocs.org/ntsb/SEA68D0202.md): Cessna 172 · Vernonia, OR · Accident · No injuries · Closed · Oct 7, 1967 · N7642X · Substantial damage
- [NTSB SEA66D0272](https://openairdocs.org/ntsb/SEA66D0272.md): Cessna 172 · Heppner, OR · Accident · No injuries · Closed · May 12, 1966 · N8141X · 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" = '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 ('2072406'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072406&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.