NTSB investigations, 1985, OR

5 cases where the first occurrence was “Loss of control - on ground/water”.

Cases per year

19822026
NTSB investigations, 1985, OR per year, 1982–2026: 122 cases
19827
19835
19847
19855
19862
19872
19882
19894
19909
19911
19922
19934
19944
19956
19963
19974
19982
19994
20009
20018
20023
200310
20046
20055
20063
20075

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\") = 1985
    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\" = 260)
  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 SEA86LA025Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Imnaha, ORPrior to takeoff the pilot taxied through a lot of slush. A nose over occurred while attempting to land on a snow covered clearing. The nose over probably occurred due to very deep snow on the landing area and frozen brakes.Nov 12, 1985 · N3534M · Substantial damageNTSB SEA86LA011Accident · No injuriesLimited investigationFinal reportCessna 172 · Lebanon, ORA loss of directional control occurred during landing roll. The acft veered to the right, struck a ditch and then nosed over. A helicopter was hovering to the left of the landing rwy, probably causing enough wake turbulence to cause the loss of directional…Oct 12, 1985 · N5790J · Substantial damageNTSB SEA85LA139Accident · No injuriesLimited investigationFinal reportMaule M-5-180C · Ontario, ORThe plt reported that when he landed, the wind was gusting to 25 KTS. He stated that when the acft touched down, it encountered a whirlwind that lifted the tail. Subsequently, the acft nosed over & was damaged. According to the 1700 PDT wx observation at…Jun 15, 1985 · N5652W · Substantial damageNTSB SEA85LA091Accident · No injuriesLimited investigationFinal reportCessna 185 · Paulina, ORThe plt reported that on 4/11/85, the left tire blew out during a landing at omak, WA, damaging the left wheel & braking sys. He said that repairs had been made, but the left brake felt spongy. The next flt (on 4/12/85) was to a private airstrip at Paulina,…Apr 13, 1985 · N4892E · Substantial damageNTSB SEA85LA083Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Burns, ORThe acft veered left and the plt overcorrected with right rudder and a ground loop then occurred. The plt said the brakes needed to be worked on prior to the accident. He said that they were not as effective as they should have been & that he was aware of the…Apr 5, 1985 · N5051U · Substantial damage