# NTSB investigations: Cessna 150B, 1985

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 LAX86FA066](https://openairdocs.org/ntsb/LAX86FA066.md): Cessna 150 · Oxnard, CA · Accident · 1 fatal · Field investigation · Final report · Dec 13, 1985 · N7310X · Destroyed
  > The acft took off, pitched up steeply, stalled, nosed over to the right and crashed, nose down into the grass south of the rwy. Post accident inspection of the acft disclosed that the 2 inch bolt the plt used as a control gust lock for the elevator and…
- [NTSB FTW85LA339](https://openairdocs.org/ntsb/FTW85LA339.md): Cessna 150B · Drumright, OK · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 1985 · N1257Y · Destroyed
  > The pilot's landing approach was long and fast. The aircraft touched down but the pilot decided he would be unable to stop on the remaining runway and intiated a go-around. He then realized he would not be able to clear trees beyond the end of the runway. He…

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

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

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