# NTSB investigations: Cessna R172K, 1990

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 DEN90LA151](https://openairdocs.org/ntsb/DEN90LA151.md): Cessna 172XP · Tooele, UT · Accident · No injuries · Limited investigation · Final report · Jul 2, 1990 · N736NB · Substantial damage
  > The flights encounter with turblence on final which resulted in a loss of control and a subsequent collision with the ground.
- [NTSB FTW90LA109](https://openairdocs.org/ntsb/FTW90LA109.md): Cessna 172XP · Leona, TX · Accident · No injuries · Limited investigation · Final report · May 26, 1990 · N1650V · Substantial damage
  > Engine power loss due to a totally obstructed air intake manifold. Contributing to the accident was the unsuitable terrain in which the forced landing had to be performed.
- [NTSB DEN90LA091](https://openairdocs.org/ntsb/DEN90LA091.md): Cessna 172XP · Hurricane, UT · Accident · No injuries · Limited investigation · Final report · Mar 13, 1990 · N1530V · Substantial damage
  > The engine oil leak induced connecting rod failure and subsequent total power loss.
- [NTSB LAX90LA271](https://openairdocs.org/ntsb/LAX90LA271.md): Cessna R172K · Lone Pine, CA · Accident · 1 fatal · Limited investigation · Final report · Jan 14, 1990 · N758UV · Destroyed
  > The pilot's decision to continue VFR flight into instrument meteorological conditions. Factors to the accident were the adverse weather conditions, mountainous terrain, and the likely effect of hypoxia on the pilot.

## 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 year(c."eventDate") = 1990
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072431'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072431&year=1990

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