# NTSB investigations: Cessna 172D, 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 CHI91LA003](https://openairdocs.org/ntsb/CHI91LA003.md): Cessna 172D · Midland, MI · Accident · Minor injuries · Limited investigation · Final report · Oct 4, 1990 · N2592Y · Substantial damage
  > The pilot did not refuel resulting in loss of engine power due to fuel exhaustion. The inadvertent stall encountered during the forced landing was also a cause.
- [NTSB NYC90LA131](https://openairdocs.org/ntsb/NYC90LA131.md): Cessna 172 · Augusta, ME · Accident · Serious injuries · Limited investigation · Final report · Jun 16, 1990 · N2898U · Destroyed
  > Poor judgement of the pilot, his decision to attempt VFR flight in instrument meteorological conditions (IMC), and his loss of aircraft control due to spatial disorientation. Factors related to the accident were: the pilot's lack of proper certification…
- [NTSB MIA90LA112](https://openairdocs.org/ntsb/MIA90LA112.md): Cessna 172D · Isla Grande, PR · Accident · Minor injuries · Limited investigation · Final report · Apr 28, 1990 · N2670U · Substantial damage
  > Improper use of carburetor heat by the pilot, which resulted in carburetor ice. The weather (carburetor icing condition) was a related factor.

## 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 ('2072410'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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