# NTSB investigations, 1983, 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 DEN84FU001](https://openairdocs.org/ntsb/DEN84FU001.md): Eipper Quicksilver E · Fargo, ND · Accident · Serious injuries · Final report · Nov 6, 1983 · UNREG · Destroyed
  > The non-rated plt had taken ground & dual flt instruction in ultralight flying & had soloed earlier that day. He then took off & flew east, away from the designated ultralight training area. Just prior to the accident, witnesses driving east on an interstate…
- [NTSB DEN84LA006](https://openairdocs.org/ntsb/DEN84LA006.md): Artic S-1A Cadet · Fullerton, ND · Accident · Minor injuries · Limited investigation · Final report · Oct 11, 1983 · N37286 · Substantial damage
  > The acft collided with trees during a takeoff from an open OAT field.
- [NTSB DEN83LA170](https://openairdocs.org/ntsb/DEN83LA170.md): Grumman G-164B · Page, ND · Accident · No injuries · Limited investigation · Final report · Jun 29, 1983 · N6652Q · Substantial damage
  > While spraying at dusk, the plt was concerned about injuring a 'non-target crop' across the road to the south from the field that was being sprayed. He stated that an irrigation system was sitting pointed southwest, and that as he was entering a swath to the…

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

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