NTSB investigations, 1982, OR

12 cases where the phase of flight was Enroute.

Cases per year

19642026
NTSB investigations, 1982, OR per year, 1964–2026: 695 cases
196411
196514
196616
196721
196817
196916
197014
197118
197220
197320
197414
197515
197625
197721
197826
197928
198022
198120
198212
198312
198419
198512
198621
198712
198816
19898
199011
199111
199213
19938
19948
19958
19968
199712
199810
19996
200013
20019
200213
20037
20046
20059
20064
20077
20086
20094
20106
201110
20124
20135
20143
20154
20163
20176
20182
20195
20203
20214
20222
20236
20247
20252

Latest cases

Query with SQL
duckdb -csv -c "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\" = 'OR' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB SEA83FYM02Accident · 2 fatalFinal reportEnstrom 280C · North Plains, ORAt about 0530 PST, the pilot departed from his home at ridge field, WA on a flight to hillsboro, OR. According to the pilot's instructor, the normal route used for this trip would been to proceed on a southerly heading to cornelius pass, go through the pass,…Dec 17, 1982 · N5686Z · DestroyedNTSB SEA83LA032Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Chemult, ORThe flt encountered heavy snow enroute & the eng quit. During the autorotation the plt maneuvered to avoid hitting a railroad signal trestle but struck several railroad signal cables & crashed. The acft was not equipped with a particle separator, nor was the…Dec 15, 1982 · N90876 · Substantial damageNTSB SEA83LA023Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Cascade Locks, ORWhile cruising at 10000 feet MSL, in IMC conditions, the pilot reported that power had been lost. During descent to 2000 feet the engine restarted and failed several times but eventually maintained idle throughout the remainder of the descent. Portland…Nov 20, 1982 · N8185P · Substantial damageNTSB SEA83FYK01Accident · Serious injuriesFinal reportPiper PA-32-300 · 27ne Rogue Rive, ORAt 9,500 ft the eng failed. The acft impacted a large tree while maneuvering to land on a rural road in heavily forested mountains. Eng examination revealed that the top of the case had a large hole on the rear portion. Pushrod housings were missing from #5 &…Nov 10, 1982 · N656ZM · DestroyedNTSB SEA83FYM01Accident · 1 fatalFinal reportBellanca 7GCBC · 1/4nm S. Of Peo, ORThe pilot and passenger were on a pleasure flight over the willamette river. The passenger stated that after following the river the aircraft began to climb and turn east. There was a sudden jolt and the plane began to spin and impacted the water.Oct 10, 1982 · N57457 · Substantial damageNTSB SEA82DA169Accident · Minor injuriesFinal reportMooney M20E · Government Camp, ORThe pilot stated that the engine power became intermittent during cruise flight. A force landing was attempted on a highway. Upon touchdown, the aircraft skidded off the road and over an embankment. The state police arrived at the accident site shortly after…Sep 21, 1982 · N9605V · Substantial damageNTSB SEA82DA135Accident · No injuriesFinal reportMooney M20F · Sandy, ORAfter the engine was overhauled, the pilot and a mechanic took off on a test flight. During the takeoff climb the engine lost power and when force landed on soft terrain, the nose and right main landing gear collapsed. An examination revealed that the left…Jul 31, 1982 · N9707M · Substantial damageNTSB SEA83FA196Accident · 1 fatalField investigationFinal reportMooney M-20 · Sandy, ORThe acft crashed into rising terrain in marginal weather conditions. No flt plan had been filed. The acft crashed 25 miles from the takeoff point on 6/12/82 and was missing until 9/9/83. The pilot had received a weather briefing from portland fss indicating…Jun 14, 1982 · N231AW · DestroyedNTSB SEA82FYM18Accident · 2 fatalFinal reportMccall KR-2 · Union, ORReportedly, the aircraft departed la grande, OR with 12 gallons of fuel on board and was flown to baker, OR. Later, the pilot departed baker on a return flight to la grande without refueling. Subsequently, the plane was reported as missing. The next day it…Jun 6, 1982 · N54622 · DestroyedNTSB SEA82DA078Accident · Minor injuriesFinal reportCessna 140 · Buena Vista, ORThe pilot stated that while looking out the left side window something impacted the windshield causing broken plexiglass to enter the cabin and injure both the pilot and the passenger. He then noticed that the airspeed was low and proceeded to lower the nose…May 23, 1982 · N73056 · Substantial damageNTSB SEA82FA046Accident · Serious injuriesField investigationFinal reportCessna 177RG · 10 East Of Till, ORDuring flight at 13,000 ft MSL, the engine began losing power. The aircraft was vectored toward the prospect airport near tiller, Oregon. However, about two minutes later, all engine power was lost. During a forced landing, the aircraft struck a dead…Apr 6, 1982 · N2114Q · Substantial damageNTSB SEA82FA015Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Pleasant Hill, ORThe plane tookoff at 1505 PST on a local VFR pleasure flight with 4 occupants and about 48 gallons of fuel on board. The plane was estimated to be about 140 lbs over the maximum gross weight limit. At about 1622 PST, it was observed to break up in flight.…Jan 5, 1982 · N8265A · Destroyed