# Final NTSB investigations: Cessna 150J, ND

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 CHI95LA102](https://openairdocs.org/ntsb/CHI95LA102.md): Cessna 150 · West Fargo, ND · Accident · No injuries · Limited investigation · Final report · Mar 15, 1995 · N60564 · Substantial damage
  > the pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor associated with the accident was the soft terrain that the airplane encountered.
- [NTSB CHI93LA215](https://openairdocs.org/ntsb/CHI93LA215.md): Cessna 150J · Wilton, ND · Accident · No injuries · Limited investigation · Final report · Jun 20, 1993 · N60454 · Substantial damage
  > Failure of the engine-driven fuel pump. A factor was the pilot's failure to select the auxiliary fuel pump.
- [NTSB DEN86LA248](https://openairdocs.org/ntsb/DEN86LA248.md): Cessna 150J · Goodrich, ND · Accident · No injuries · Limited investigation · Final report · Sep 5, 1986 · N50989 · Substantial damage
  > Plt said he was flying low and chasing black birds from his sunflower fields. Terrain was rolling hills. Plt said he made one pass over field and was turning around for another pass. 'I got my airspeed too low and started to stall. I brought it out of the…
- [NTSB DEN86LA106](https://openairdocs.org/ntsb/DEN86LA106.md): Cessna 150J · Tioga, ND · Accident · Serious injuries · Limited investigation · Final report · Mar 29, 1986 · N51156 · Substantial damage
  > The plt dept minot, ND, with his son aboard, for a pvt airstrip near his home of windrose, ND. He said because of high winds he landed at Tioga, ND. He said that while taxiing after landing strong gusty winds flipped his acft upside down. The acft was…
- [NTSB DEN81DTG03](https://openairdocs.org/ntsb/DEN81DTG03-122878.md): Cessna 150 · Trotter, ND · Accident · No injuries · Closed · Dec 3, 1981 · N61363 · Substantial damage
- [NTSB MKC74FTG13](https://openairdocs.org/ntsb/MKC74FTG13.md): Cessna 150J · Grand Forks, ND · Accident · No injuries · Closed · Feb 9, 1974 · N60667 · 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" = 'ND' 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 ('2071820'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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