# NTSB investigations: Cessna 172K, 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 GAA17CA373](https://openairdocs.org/ntsb/GAA17CA373.md): Cessna 172 · Roseburg, OR · Accident · No injuries · Data collection · Final report · Jun 25, 2017 · N79938 · Substantial damage
  > An in-flight collision with a bird during the approach.
- [NTSB LAX08FA256](https://openairdocs.org/ntsb/LAX08FA256.md): Cessna 172K · Gearhart, OR · Accident · 5 fatal · Field investigation · Final report · Aug 4, 2008 · N828CC · Destroyed
  > The pilot's failure to maintain aircraft control during the initial climb after takeoff due to spatial disorientation.
- [NTSB SEA01LA036](https://openairdocs.org/ntsb/SEA01LA036.md): Cessna 172K · Troutdale, OR · Accident · No injuries · Limited investigation · Final report · Jan 7, 2001 · N78284 · Substantial damage
  > The pilot's failure to adequately compensate for wind conditions while taxiing the airplane.
- [NTSB SEA00LA194](https://openairdocs.org/ntsb/SEA00LA194.md): Cessna 172K · Burns, OR · Accident · No injuries · Limited investigation · Final report · Sep 28, 2000 · N84034 · Substantial damage
  > The separation of a portion of one propeller blade as a result of a fatigue crack that initiated at the site of foreign object damage to the blade.
- [NTSB SEA96LA032](https://openairdocs.org/ntsb/SEA96LA032.md): Cessna 172K · Owyhee, OR · Accident · No injuries · Limited investigation · Final report · Dec 17, 1995 · N143JP · Substantial damage
  > the pilot's selection of unsuitable terrain for landing. The soft terrain and high vegetation were related factors.
- [NTSB SEA94FA018](https://openairdocs.org/ntsb/SEA94FA018.md): Cessna 172K · North Bend, OR · Accident · 1 fatal · Field investigation · Final report · Oct 22, 1993 · N79405 · Destroyed
  > Loss of control while in flight due to pilot incapacitation from atherosclerotic heart disease.
- [NTSB SEA91LA224](https://openairdocs.org/ntsb/SEA91LA224.md): Cessna 172K · Corbett, OR · Accident · Minor injuries · Limited investigation · Final report · Aug 28, 1991 · N6LG · Substantial damage
  > The pilot's improper in-flight planning/decision, his delay in taking remedial action, and his failure to maintain clearance from trees on rising terrain. The weather and terrain conditions were related factors.
- [NTSB SEA84LA128](https://openairdocs.org/ntsb/SEA84LA128.md): Cessna 172K · Pendleton, OR · Accident · No injuries · Limited investigation · Final report · Jun 7, 1984 · N84153 · Substantial damage
  > The plt said he initiated his takeoff on rwy 25 with the wind from 220 deg at 35 gusting 42 KTS. Just after lifting off, at about 10 ft AGL, the stall warning horn sounded & the plt noticed that the airspeed had dropped to about 45 mph. The acft then drifted…
- [NTSB SEA82DYM01](https://openairdocs.org/ntsb/SEA82DYM01.md): Cessna 172 · Long Creek, OR · Accident · No injuries · Closed · Nov 8, 1981 · N7244G · Destroyed
- [NTSB SEA74AS039](https://openairdocs.org/ntsb/SEA74AS039.md): Cessna 172K · Gold Beach, OR · Accident · 4 fatal · Closed · Apr 28, 1974 · N79141 · Destroyed
- [NTSB SEA73DYC39](https://openairdocs.org/ntsb/SEA73DYC39.md): Cessna 150G · Brightwood, OR · Accident · Minor injuries · Closed · Jun 23, 1973 · N84685 · Destroyed
- [NTSB SEA72FYI22](https://openairdocs.org/ntsb/SEA72FYI22.md): Cessna 172 · Klamath Flls, OR · Accident · No injuries · Closed · May 11, 1972 · N84271 · Substantial damage
- [NTSB SEA72DYI12](https://openairdocs.org/ntsb/SEA72DYI12.md): Cessna 172 · Deschutes, OR · Accident · Minor injuries · Closed · Jan 10, 1972 · N78672 · Substantial damage
- [NTSB SEA71AS011](https://openairdocs.org/ntsb/SEA71AS011.md): Cessna 172 · Agness, OR · Accident · 1 fatal · Closed · Aug 26, 1970 · N79511 · 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 ('2072430'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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