# NTSB investigations: Cessna A150L, 1982

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 MKC82FCD08](https://openairdocs.org/ntsb/MKC82FCD08.md): Cessna A150L · New Hampton, IA · Accident · Serious injuries · Final report · Jul 23, 1982 · N5937J · Substantial damage
  > The aircraft crashed while maneuvering in the vicinity of the pilot/owner's private airfield. The pilot stated that plane went into a 180 deg reverse backslide after he started a left turn and applied left rudder and aileron. He reported that the plane began…
- [NTSB ATL82DA128](https://openairdocs.org/ntsb/ATL82DA128.md): Cessna A150L · Greensboro, NC · Accident · No injuries · Final report · May 9, 1982 · N5938J · Substantial damage
  > While landing the pilot reported his misjudgement caused him to undershoot and touchdown short of the runway. The pilot stated he touched down hard on the left main gear and suggested that the nose gear failed to the right, possibly prior to contact with a…

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

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

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