# NTSB investigations, 1982, ND: Maneuvering

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 DEN82FTG06](https://openairdocs.org/ntsb/DEN82FTG06.md): Piper PA-12 · Oakes, ND · Accident · 2 fatal · Final report · Aug 27, 1982 · N7715H · Destroyed
  > Several witnesses reported that the purpose of the flight was blackbird control of a sunflower field. There was speculation by local residents that the aircraft was being used to spread poisoned corn. This was substantiated when corn and a portion of an…
- [NTSB DEN82DA144](https://openairdocs.org/ntsb/DEN82DA144.md): Piper PA-25-235 · Leonard, ND · Accident · No injuries · Final report · Jul 26, 1982 · N4461Y · Substantial damage
  > The pilot stated the engine lost power as he pulled up from the final spray run. The aircraft wing contacted a tree and a forced landing was made in a barley field. Post flight exam showed no reason for the power loss.
- [NTSB DEN82DA108](https://openairdocs.org/ntsb/DEN82DA108.md): Callair A-9B · Rolla, ND · Accident · No injuries · Final report · Jun 20, 1982 · N7634V · Substantial damage
  > The pilot reported that after loading with chemical, water, and fuel, he went to a field and began spraying. He stated that after he had made his first swath run, he was turning for a second swath when the plane stalled and crashed. The landing gear,…
- [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 DEN82DA050](https://openairdocs.org/ntsb/DEN82DA050.md): Piper PA-11 · Devils Lake, ND · Accident · Serious injuries · Final report · Mar 28, 1982 · N4709H · Substantial damage
  > The pilot and passenger/pilot were making low, slow passes over fisherman on the ice. The pilot reversed directions and the aircraft stalled. The pilot stated he was looking at the ground and became distracted.
- [NTSB DEN82DA040](https://openairdocs.org/ntsb/DEN82DA040.md): Bell 206B III · Trenton, ND · Accident · Serious injuries · Final report · Mar 7, 1982 · N16867 · Substantial damage
  > The aircraft was hovering during a sling load operation when the engine lost power. The pilot released the load but due to low rotor RPM the aircraft landed hard, substantially damaging the aircraft. Investigaton revealed a failure of the forward male splines…

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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 case_mkey FROM case_phases WHERE main = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/450/cases?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.
