# Fatal NTSB investigations: Cessna 172, 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 WPR19FA244](https://openairdocs.org/ntsb/WPR19FA244.md): Cessna 172 · McKenzie Bridge, OR · Accident · 2 fatal · Class 3 · Field · Final report · Aug 28, 2019 · N4108F · Destroyed
  > The pilot's delayed climb and misjudgment of the airplane’s performance and the runway distance needed to clear obstacles at the end of the runway, which resulted in a collision with trees and subsequent impact with terrain. Contributing to the accident was…
- [NTSB WPR12FA274](https://openairdocs.org/ntsb/WPR12FA274.md): Cessna 172 · Veneta, OR · Accident · 4 fatal · Field investigation · Final report · Jun 23, 2012 · N5781A · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and altitude to clear trees during the initial climb after takeoff.
- [NTSB SEA98LA154](https://openairdocs.org/ntsb/SEA98LA154.md): Cessna 172 · Baker City, OR · Accident · 1 fatal · Limited investigation · Final report · Jul 31, 1998 · N835T · Substantial damage
  > The pilot's failure to maintain terrain clearance and inadequate in-flight planning/decision. Contributing to the accident was mountain obscuration.
- [NTSB SEA91FA059](https://openairdocs.org/ntsb/SEA91FA059.md): Cessna 172 · Oregon City, OR · Accident · 1 fatal · Field investigation · Final report · Feb 28, 1991 · N7119T · Destroyed
  > The pilot's failure to attain proper airspeed before takeoff. Factors relating to the accident were the binding brake, the uphill grass airstrip, the tail wind weather conditions, and the improper annual inspection that was just completed on the aircraft.
- [NTSB SEA82FYK07](https://openairdocs.org/ntsb/SEA82FYK07.md): Cessna 172 · Lapine, OR · Accident · 1 fatal · Final report · Jan 24, 1982 · N8172B · Destroyed
  > When the pilot landed at lakeview,OR,he checked the weather but reported to his passenger that although the weather was bad he did not want to stay in lakeview. The aircraft departed lakeview, following a highway, when the weather conditions continued to…
- [NTSB SEA77FA029](https://openairdocs.org/ntsb/SEA77FA029.md): Cessna 172N · Newberg, OR · Accident · 2 fatal · Closed · May 1, 1977 · N733VP · Destroyed
- [NTSB SEA77FA005](https://openairdocs.org/ntsb/SEA77FA005.md): Cessna 172 · Pendleton, OR · Accident · 2 fatal · Closed · Nov 9, 1976 · N5789A · Destroyed
- [NTSB SEA76A5043](https://openairdocs.org/ntsb/SEA76A5043.md): Cessna 172 · Sweet Home, OR · Accident · 1 fatal · Closed · Apr 10, 1976 · N7075T · Destroyed
- [NTSB SEA68A0027](https://openairdocs.org/ntsb/SEA68A0027.md): Cessna 172 · Portland, OR · Accident · 1 fatal · Closed · Sep 16, 1967 · N5907A · 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072402'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=2072402&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, except the copies of manufacturers’ service documents, which belong to their rights holders.
