NTSB investigations, 1997, OR

7 cases where the first occurrence was “Loss of engine power”.

Cases per year

19822026
NTSB investigations, 1997, OR per year, 1982–2026: 109 cases
19822
19832
19842
19857
19864
19872
19882
19914
19924
19933
19942
19955
19964
19977
19987
19993
20008
20014
20029
20034
20046
20057
20064
20077

Latest cases

Query with SQL
duckdb -csv -c "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\") = 1997
    AND c.\"eventStateOrRegion\" = 'OR' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350)
  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 SEA98LA021Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · John Day, ORa loss of engine power for undetermined reasons.Dec 6, 1997 · N171HH · Substantial damageNTSB SEA98LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Eugene, ORthe pilot's failure to refuel which subsequently led to fuel exhaustion.Nov 2, 1997 · N5190B · Substantial damageNTSB SEA97LA171Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Yamhill, ORLoss of engine power for undetermined reasons.Jul 20, 1997 · N1105B · Substantial damageNTSB SEA97LA142Accident · No injuriesLimited investigationFinal reportGlaser-Dirks DG-400 · Weston, ORThe pilot's failure to attain a proper descent rate during the forced landing. Factors include: the pilot's failure to use an 'engine start' checklist, failure to turn the ignition switch to the 'on' position, failure to use the landing checklist, failure to…Jun 14, 1997 · N321V · Substantial damageNTSB SEA97LA124Accident · No injuriesLimited investigationFinal reportCessna 150H · Redmond, ORthe pilot's improper decision to depart on a flight without first ensuring the aircraft held sufficient fuel to reach his destination, which resulted in fuel exhaustion. Factors were the high vegetation and rocks at the location of the forced landing.Jun 1, 1997 · N50348 · Substantial damageNTSB SEA97LA074Accident · Minor injuriesLimited investigationFinal reportWeatherly 620B · Wasco, ORthe partial loss of engine power for undetermined reasons and the pilot's selection of unsuitable terrain for a precautionary landing. A factor was the rough terrain.Mar 22, 1997 · N20113 · Substantial damageNTSB SEA97LA069Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5A · North Bend, ORThe pilot's failure to perform the proper remedial action of applying carburetor heat/alternate induction air after impact ice accumulated on his aircraft's induction air filter. Factors include intentional flight into known adverse weather (icing…Mar 12, 1997 · N26848 · Substantial damage