# NTSB investigations, 1982, ND: Landing

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 DEN82DA171](https://openairdocs.org/ntsb/DEN82DA171.md): Cessna 190 · Bismarck, ND · Accident · No injuries · Final report · Aug 22, 1982 · N3004B · Substantial damage
  > Left brake failed. Examination revealed the hydraulic brake line to the left brake had pulled loose from a union fitting. The line also sheared by the shifting of the gear box assembly. There were signs of inadequate flare to the tubing in that it pulled out…
- [NTSB DEN82DA170](https://openairdocs.org/ntsb/DEN82DA170.md): Mooney M-20F · Arthur, ND · Accident · Minor injuries · Final report · Aug 21, 1982 · N9066V · Substantial damage
  > The pilot landed long and fast. The aircraft collided with an elevated roadbed, shearing off the landing gear.
- [NTSB DEN82DA097](https://openairdocs.org/ntsb/DEN82DA097.md): Cessna 152 · Grand Forks, ND · Accident · No injuries · Final report · May 26, 1982 · N5329B · Substantial damage
  > During landing, the student pilot bounced and then touched down hard. The nose gear failed and the firewall and propeller were damaged. The fixed base operator reported light turbulence.
- [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.…
- [NTSB DEN82DA066](https://openairdocs.org/ntsb/DEN82DA066.md): Cessna 182P · Enderlin, ND · Accident · No injuries · Final report · Apr 23, 1982 · N1765M · Substantial damage
  > During a landing on runway 13, the aircraft veered off the runway after touchdown, then went into a freshly plowed field and nosed over. The pilot estimated that the wind was from 200 degrees at 20 gusting 25 knots. There was a 2640 ft turf runway (04/22) on…
- [NTSB DEN82DA059](https://openairdocs.org/ntsb/DEN82DA059.md): Cessna 170A · Williston, ND · Accident · Minor injuries · Final report · Apr 15, 1982 · CFZMZ · Substantial damage
  > The pilot noted unfavorable winds when he arrived for landing. He elected to fly in the local area until the winds subsided. After flying locally for about one hour, he elected to land on runway 29 with a crosswind from 020 degrees. While on downwind, he…
- [NTSB DEN82DA058](https://openairdocs.org/ntsb/DEN82DA058.md): Mooney M20F · Crosby, ND · Accident · No injuries · Final report · Apr 13, 1982 · N7446V · Substantial damage
  > The pilot reported that the runway had a 6 to 7 ft snowbank on the left side of the runway and a 2 to 3 ft snowbank on the right side. Also, water was on the runway intermittently along the entire length. After landing, the plane started hydroplaning. As the…
- [NTSB DEN82DA047](https://openairdocs.org/ntsb/DEN82DA047.md): Taylorcraft BC-12D · Lisbon, ND · Accident · No injuries · Final report · Mar 23, 1982 · N43393 · Substantial damage
  > The pilot stated that during the landing on runway 15, at an altitude of approximately 20 to 30 feet, the wind coming over the snowbanks on the sides of the runway caused turbulence that raised the aircraft and pushed it to the left of the runway. The…

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

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