NTSB investigations, 1995, OR

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases, newest first

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\") = 1995
    AND c.\"eventStateOrRegion\" = 'OR' AND c.\"eventCountry\" = 'USA'
  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 SEA95LA053Accident · 2 fatalLimited investigationFinal reportBruce Tifft Varieze · Tiller, ORThe pilot's failure to maintain clearance from trees.Feb 18, 1995 · N115EZ · Substantial damageNTSB SEA95LA047Accident · No injuriesLimited investigationFinal reportCessna 120 · Scappoose, ORThe pilot's improper recovery from a bounced landing and inadvertent use of the brakes.Feb 10, 1995 · N77480 · Substantial damageNTSB SEA95LA046Accident · No injuriesLimited investigationFinal reportCessna 177 · Corvallis, ORThe pilot's improper flare and improper recovery from a bounced landing.Feb 4, 1995 · N2901X · Substantial damageNTSB SEA95LA044Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Salem, ORFuel starvation due to inadequate supervision of the dual student by the pilot-in-command when the dual student improperly adjusted the fuel selector position.Jan 27, 1995 · N9201P · Substantial damageNTSB SEA95LA040Accident · No injuriesLimited investigationFinal reportCessna A185E · Hillsboro, ORA loss of engine power for undetermined reasons.Jan 21, 1995 · N748 · Substantial damageNTSB SEA95LA039Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · La Grande, ORFailure of the pilot to maintain proper altitude/clearance from higher terrain that was located near the airport. Factors related to the accident were: low ceiling, fog, false/incorrect indication of the NDB, failure of other personnel to properly issue a…Jan 21, 1995 · N36PB · Substantial damage