# Final NTSB investigations: Cessna 150, MN

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 GAA18CA293](https://openairdocs.org/ntsb/GAA18CA293.md): Cessna 150 · Bemidgi, MN · Accident · No injuries · Data collection · Final report · May 22, 2018 · N5999T · Substantial damage
  > The student pilot’s failure to maintain lateral control of the airplane during the landing roll, which resulted in a side load and subsequent failure of the left main landing gear extension casting.
- [NTSB CHI82DA137](https://openairdocs.org/ntsb/CHI82DA137.md): Cessna 150 · Blaine, MN · Accident · No injuries · Final report · Apr 24, 1982 · N5729E · Substantial damage
  > While on final approach the pilot stated that the engine lost power. The aircraft landed about 700 feet short of the runway in rough terrain. Investigation disclosed at least 1 1/2 pints of water in the left fuel tank, water in the carburetor bowl, and the…
- [NTSB MKC66D0526](https://openairdocs.org/ntsb/MKC66D0526.md): Cessna 150 · Hibbing, MN · Accident · No injuries · Closed · Mar 14, 1966 · N5999T · Substantial damage
- [NTSB MKC66F0251](https://openairdocs.org/ntsb/MKC66F0251.md): Cessna 150 · Mound, MN · Accident · No injuries · Closed · Sep 5, 1965 · N5862E · Substantial damage
- [NTSB MKC65F0145](https://openairdocs.org/ntsb/MKC65F0145.md): Cessna 150 · Hopkins, MN · Accident · No injuries · Closed · Apr 7, 1965 · N5529E · Substantial damage
- [NTSB UNK64X0689](https://openairdocs.org/ntsb/UNK64X0689.md): Cessna 150 · Moorehead, MN · Accident · Minor injuries · Closed · Feb 25, 1964 · N7897E · Destroyed
- [NTSB UNK64X0391](https://openairdocs.org/ntsb/UNK64X0391.md): Cessna 150 · Elk River, MN · Accident · Minor injuries · Closed · Jan 28, 1964 · N5755E · Substantial damage
- [NTSB UNK64X0229](https://openairdocs.org/ntsb/UNK64X0229.md): Cessna 150 · Rosemont, MN · Accident · No injuries · Closed · Jan 12, 1964 · N5828E · Substantial damage

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

This list as a web page: https://openairdocs.org/ntsb?model=2071802&state=MN&status=final

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