NTSB investigations, OR

695 cases where the phase of flight was Enroute.

Cases, newest first

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 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 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 · DestroyedNTSB SEA82FA013Accident · 1 fatalClosedErco 415-C · Ashland, ORDec 21, 1981 · N87307 · DestroyedNTSB SEA82FYK05Accident · No injuriesClosedPiper PA-28R · Cheshire, ORDec 4, 1981 · N3990M · Substantial damageNTSB SEA82FA006Accident · 5 fatalClosedCessna 172M · Payette, ORNov 26, 1981 · N9710H · DestroyedNTSB SEA82DYK03Accident · Minor injuriesClosedBeech 76 · Sutherlin, OROct 30, 1981 · N60037 · Substantial damageNTSB SEA81FYM42Accident · Serious injuriesClosedPiper PA-28 · Medical Spgs, ORSep 5, 1981 · N8723W · Substantial damageNTSB SEA81DYK15Accident · Minor injuriesClosedCessna 140 · Ashland, ORAug 24, 1981 · N2626N · DestroyedNTSB SEA81FA048Accident · 2 fatalClosedCessna 150H · Blue River, ORJul 24, 1981 · N6551S · DestroyedNTSB SEA81DYK13Accident · No injuriesClosedCessna 150G · Medford, ORJul 21, 1981 · N2800S · Substantial damageNTSB SEA81FA040Accident · 1 fatalClosedPiper PA-24 · Riverside, ORJun 12, 1981 · N9437P · DestroyedNTSB SEA83FA056Accident · 2 fatalClosedCessna 170 · Azalea, ORJun 6, 1981 · N3973V · DestroyedNTSB SEA81DYM27Accident · No injuriesClosedCessna 150 · Astoria, ORJun 5, 1981 · N6251G · Substantial damageNTSB SEA81FYM24Accident · No injuriesClosedMaule M4220C · North Plains, ORMay 10, 1981 · N2071U · Substantial damageNTSB SEA81FYK07Accident · Serious injuriesClosedHiller Acft UH-12E · Umpqua, ORMar 18, 1981 · N90467 · Substantial damageNTSB SEA81FA021Accident · 2 fatalClosedBeech A36 · Eugene, ORMar 4, 1981 · N17504 · DestroyedNTSB SEA81FYK06Accident · Minor injuriesClosedMooney M20C · Roseburg, ORMar 1, 1981 · N5994Q · DestroyedNTSB SEA83FYM03Accident · 1 fatalClosedPiper PA-24 · Scappoose, ORFeb 9, 1981 · N8604P · DestroyedNTSB SEA81FYM18Accident · Serious injuriesClosedTeenie II · Madras, ORFeb 8, 1981 · N6045 · Substantial damageNTSB SEA81FYM19Accident · Minor injuriesClosedMooney M20 · Salem, ORFeb 7, 1981 · N5257B · Substantial damageNTSB SEA81FYM17Accident · No injuriesClosedPiper PA-38 · Yamhill, ORFeb 6, 1981 · N2515B · Substantial damageNTSB SEA81FA015Accident · 3 fatalClosedAero Comdr 690B · Burns, ORJan 7, 1981 · N81521 · DestroyedNTSB SEA81FYM09Accident · Minor injuriesClosedBell 47G-3 · Buell, ORNov 22, 1980 · N6784D · Substantial damageNTSB SEA81FA002Accident · 1 fatalClosedCessna 182Q · Ashland, OROct 15, 1980 · N735PZ · DestroyedNTSB SEA80FYM63Accident · No injuriesClosedCessna 182A · Harrisburg, ORSep 28, 1980 · N6163B · Substantial damageNTSB SEA80DYK17Accident · Minor injuriesClosedCessna 150 · Redmond, ORSep 4, 1980 · N1280Q · Substantial damageNTSB SEA81FYM07Accident · No injuriesClosedHughes 269C · Pilot Rock, ORAug 31, 1980 · N9643F · Substantial damageNTSB SEA80FYK15Accident · No injuriesClosedPiper PA-28R · Sixes, ORAug 25, 1980 · N444JT · Substantial damageNTSB SEA80DYM53Accident · No injuriesClosedAero Comdr 100 · Prineville, ORAug 17, 1980 · N2924T · Substantial damageNTSB SEA80FYK13Accident · Minor injuriesClosedCessna 421 · Redmond, ORAug 11, 1980 · N3150K · Substantial damageNTSB SEA80FYK12Accident · Serious injuriesClosedCessna 182A · Roseburg, ORAug 5, 1980 · N3903D · Substantial damageNTSB SEA80DYM47Accident · Serious injuriesClosedCessna 152 · Milton-Freewtr, ORJul 13, 1980 · N68450 · Substantial damageNTSB SEA80DYM49Accident · No injuriesClosedHenkes RV-3 · Canby, ORJul 12, 1980 · N20RV · Substantial damageNTSB SEA80FYM44Accident · No injuriesClosedPiper J3C-85 · Hood River, ORJul 7, 1980 · N7116H · Substantial damageNTSB SEA80FA036Accident · 4 fatalClosedPiper PA32RT · Granite, ORJun 26, 1980 · N39691 · DestroyedNTSB SEA80FA032Accident · 1 fatalClosedPiper PA-28 · Woodburn, ORJun 14, 1980 · N5887V · DestroyedNTSB SEA80FA044Accident · 2 fatalClosedPiper PA-28 · Portland, ORJun 12, 1980 · N2333U · DestroyedNTSB SEA80FA031Accident · 1 fatalClosedCessna 210L · Harrisburg, ORJun 4, 1980 · N732DX · DestroyedNTSB SEA80DYM32Accident · No injuriesClosedPiper PA-24 · Cascade Locks, ORApr 20, 1980 · CF-BUN · Substantial damageNTSB SEA80DYK07Accident · Serious injuriesClosedCessna T210 · Bend, ORMar 29, 1980 · N761XP · Substantial damageNTSB SEA80FA020Accident · 3 fatalClosedCessna 172N · Dufur, ORFeb 24, 1980 · N2340E · DestroyedNTSB SEA80FYM17Accident · No injuriesClosedHughes 369HS · Siletz, ORFeb 21, 1980 · N9219F · Substantial damageNTSB SEA80FYK05Accident · Serious injuriesClosedPiper PA-24 · Allegany, ORFeb 9, 1980 · N5628P · Substantial damageNTSB SEA80FA018Accident · 2 fatalClosedBell 47G3B1 · Jefferson, ORJan 30, 1980 · N73285 · DestroyedNTSB SEA80FYM09Accident · Serious injuriesClosedCessna 150G · Aloha, ORDec 10, 1979 · N4825X · Substantial damage