NTSB investigations, 1990, OR

11 cases where the phase of flight was Enroute.

Cases per year

19642026
NTSB investigations, 1990, 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\") = 1990
    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 SEA91LA029Accident · No injuriesLimited investigationFinal reportCessna 182A · Burns, ORThe formation of carburetor ice when the pilot delayed the use of carburetor heat.Dec 2, 1990 · N4005D · Substantial damageNTSB SEA90FA197Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Bend, ORAn engine power loss due to fuel starvation as a result of a broken seal in the fuel injector servo. In addition, the pilot misjudged his approach into an open field.Sep 28, 1990 · N8646P · DestroyedNTSB SEA90LA190Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Christmas Valle, ORThe pilot's inadequate preflight and failure to maintain alignment during landing ground roll. Factors in the accident were the contaminated fuel and the soft terrain on the landing surface.Sep 19, 1990 · N29614 · Substantial damageNTSB SEA90FA166Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Salem, ORThe pilot allowed the design stress limits of the aircraft to be exceeded. Factors related to the accident concerned inadvertent flight by the pilot into known adverse weather conditions.Aug 27, 1990 · N8103P · DestroyedNTSB SEA90LA169Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Florence, ORThe failure of an engine cylinder head. Collision with a log during the landing was a factor related to the accident.Aug 26, 1990 · N1911U · Substantial damageNTSB SEA90LA153Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Burns, ORLoss of engine power due to a blocked fuel line and the operation of the aircraft in an non-airworthy condition by the PIC.Aug 1, 1990 · N681M · Substantial damageNTSB SEA90LA128Accident · No injuriesLimited investigationFinal reportCessna 150C · Sutherlin, ORLoss of engine power was due to fuel exhaustion. Because of inadequate fuel consumption calculations and poor preflight planning and preparation for the flight.Jul 9, 1990 · N1940Z · Substantial damageNTSB SEA90FA129Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Prineville, ORThe failure of the left intermediate exhaust pipe, in-flight engine fire and smoke in the cockpit, resulting in impairment of the pilot and his subsequent loss of control.Jul 9, 1990 · N30511 · DestroyedNTSB SEA90FA074Accident · 2 fatalField investigationFinal reportPiper PA28R-200 · Prairie City, ORUncontrolled spiralling descent that the pilot did not adequately recover from. The pilots lack of total experience in this type of operation and the dark night condition are a factor.Mar 2, 1990 · N2947R · DestroyedNTSB SEA90FA045Accident · 1 fatalField investigationFinal reportCessna 402B · Baker, ORPilot displayed poor inflight planning by selecting to fly into known adverse weather conditions. The pilot did not maintain an adequate visual lookout when operating in snow shower conditions and collided into the terrain.Feb 5, 1990 · N50GP · DestroyedNTSB SEA90LA038Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Boring, ORCarburetor icing, and the pilot's improper use of carburetor heat. Factors related to the accident were: carburetor icing conditions and the soft/uneven terrain in the emergency landing area.Feb 4, 1990 · N8898C · Substantial damage