# NTSB investigations, 1985, ND: In flight collision with terrain/water

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 DEN86LA035](https://openairdocs.org/ntsb/DEN86LA035.md): Stinson 108-1 · Beulah, ND · Accident · No injuries · Limited investigation · Final report · Nov 30, 1985 · N8143K · Substantial damage
  > During a landing at dusk on a snow covered rwy, the acft encountered deep snow and nosed over onto its back. The plt stated that after touchdown, he realized that there was aprx one ft of snow on the rwy and was unable to make a go-around.
- [NTSB DEN85LTG09](https://openairdocs.org/ntsb/DEN85LTG09.md): Piper PA-30/A · Bowman, ND · Accident · No injuries · Final report · Aug 17, 1985 · N7126Y · Substantial damage
  > The acft was landed gear up. The plt was aware of the condition at one point in the traffic pattern. A check by retarding the throttle(s) on final produced no warning horn so the plt assumed that the gear was down. After the gear up landing, the circuit…
- [NTSB DEN85LTG03](https://openairdocs.org/ntsb/DEN85LTG03.md): Piper PA-25-235 · Kramer, ND · Accident · No injuries · Final report · Jul 10, 1985 · N9538P · Substantial damage
  > The acft collided with the shoulder of a hwy when the plt attempted to avoid power lines during an aerial application flt.
- [NTSB DEN85LA166](https://openairdocs.org/ntsb/DEN85LA166.md): Piper PA-25 · Leonard, ND · Accident · No injuries · Limited investigation · Final report · Jun 15, 1985 · N4733Y · Substantial damage
  > During an aerial spray operation, the plt returned to a field with his 2nd chemical load. As he descended over trees to begin a swath run, he began a flare, but the acft continued descending & impacted the ground. The right landing gear was torn off & the…
- [NTSB DEN85FA113](https://openairdocs.org/ntsb/DEN85FA113.md): Swearingen SA-227-AC · Williston, ND · Accident · No injuries · Field investigation · Final report · Apr 7, 1985 · N3005J · Substantial damage
  > The flt crew stated after the accident that the flt was uneventful from rap to ins. The first officer was flying the acft when the accident occurred. According to the flt crew all checklist items had been performed prior to the landing. The acft made gnd…

## 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."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" = 230)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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