# NTSB investigations, 1987, ND: Loss of control - in flight

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 DEN87FA224](https://openairdocs.org/ntsb/DEN87FA224.md): Champion 7ECA · Devils Lake, ND · Accident · Serious injuries · Field investigation · Final report · Aug 26, 1987 · N11024 · Destroyed
  > The acft was observed flying at low altitude and circling a farm that belonged to the plt's sister. After making two passes by the farm, the acft crashed in a corn field. The plt said he was looking for a field in which to land, and on the 2nd pass, the acft…
- [NTSB DEN87LA196](https://openairdocs.org/ntsb/DEN87LA196.md): Piper PA-18-150 · Fargo, ND · Accident · No injuries · Limited investigation · Final report · Jul 28, 1987 · N7174B · Substantial damage
  > Plt installed new aerial application chemical tank. The tank was filled with water for a test flight. Plt could not hold nose down after takeoff. Acft stalled into trees and landed in field beyond trees. Acft nosed over and damaged fuselage and vertical…
- [NTSB DEN87LA137](https://openairdocs.org/ntsb/DEN87LA137.md): Cessna 140 · Sawyer, ND · Accident · Minor injuries · Limited investigation · Final report · May 30, 1987 · N1677V · Substantial damage
  > The commercial plt and his wife were on a cross country flt and were landing for refueling. On final, the acft began an uncommanded left turn as landing flaps were selected. The plt was unable to correct the turn and struck trees short of the private…
- [NTSB DEN87LA114](https://openairdocs.org/ntsb/DEN87LA114.md): Piper PA-25 · Valley City, ND · Accident · No injuries · Limited investigation · Final report · Apr 28, 1987 · N6749Z · Substantial damage
  > The commercial pilot was trying out an acft with the stated intention of leasing it. A takeoff was planned from a stretch of gravel road. During the takeoff ground run, the acft became airborne then touched down in a field, bounced across an intersecting road…
- [NTSB DEN87LA101](https://openairdocs.org/ntsb/DEN87LA101.md): Boeing A75N1 · Argusville, ND · Accident · Minor injuries · Limited investigation · Final report · Apr 16, 1987 · N63915 · Substantial damage
  > The plt took off with a load of 46-0-0 fertilizer and proceeded to the field to be treated. The plt said when he arrived his flagger was not in position so he initiated a goaround. When the plt had turned 90 deg onto the x-wind leg the acft stalled. The plt…
- [NTSB DEN87LA085](https://openairdocs.org/ntsb/DEN87LA085.md): Aero Commander 100-180 · Cando, ND · Accident · Minor injuries · Limited investigation · Final report · Apr 6, 1987 · N4069X · Substantial damage
  > The acft attempted landing and on short final, the plt recognized a pickup truck obstructing the rwy near midfield. A go around was attempted resulting in an inadvertant stall. The left wing dipped, struck the rwy, and skidded into the vehicle. The acft and…

## 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") = 1987
  AND c."eventStateOrRegion" = 'ND' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=250&state=ND&year=1987

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