# NTSB investigations, 1982, 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 DEN82DTG05](https://openairdocs.org/ntsb/DEN82DTG05.md): Cessna 188 · Devils Lake, ND · Accident · No injuries · Final report · Jun 8, 1982 · N2087J · Substantial damage
  > The pilot started a swath run at dusk by crossing under a set of wires. As he crossed under the wires, one of his main gear struck the top of a rock pile. The pilot thought that both of the main gear had failed, and he elected to make a belly landing in a…
- [NTSB DEN82DTG04](https://openairdocs.org/ntsb/DEN82DTG04.md): Boeing A75N1 · Northwood, ND · Accident · No injuries · Final report · May 21, 1982 · N65501 · Substantial damage
  > The pilot was on a flight to practice aerial application. This was his first flight in this make and model of aircraft. While making a practice run over an open field with water in the chemical tanks, the left main gear contacted the ground damaging the…
- [NTSB DEN82DA079](https://openairdocs.org/ntsb/DEN82DA079.md): Cessna 402A · Bismarck, ND · Accident · No injuries · Final report · May 7, 1982 · N4504Q · Substantial damage
  > The pilot discovered that the gear would not extend electrically. Manual extension was attempted, but the crank would not turn in either direction. While applying pressure to the cranks, the chain drive failed. The plane was landed with the gear retracted.…

## 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") = 1982
  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=1982

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