# NTSB investigations, 1986, ND: In flight collision with object

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 DEN87LA010](https://openairdocs.org/ntsb/DEN87LA010.md): Cessna 172M · Richardton, ND · Accident · Serious injuries · Limited investigation · Final report · Oct 27, 1986 · N9051H · Substantial damage
  > The plt attempted a landing on an unlighted dirt strip at dusk. He stated he intentionally flew low because it was getting dark. On final apch acft struck trees and then impacted the terrain, nosing over.
- [NTSB DEN87FA007](https://openairdocs.org/ntsb/DEN87FA007.md): Piper PA-24-250 · Crosby, ND · Accident · 4 fatal · Field investigation · Final report · Oct 22, 1986 · N8271P · Destroyed
  > Crosby municipal arpt was notam'd closed due to rwy construction and resurfacing. The plt and paxs were employees of the engineering company participating in the arpt construction. The plt of N8271P had landed on the closed rwy earlier in the day. The rwy was…
- [NTSB DEN86LA151](https://openairdocs.org/ntsb/DEN86LA151.md): Bell 206B · Portal, ND · Accident · Minor injuries · Limited investigation · Final report · Jun 4, 1986 · N59495 · Substantial damage
  > The plt reported that the acft hit wires at the end of a swath run. The pitch change link broke when the main rotor contacted the wires and the plt attempted to land. After touchdown, the helicopter rolled onto its side.

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

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

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