NTSB investigations, 1985, OR

17 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 1985, OR per year, 1964–2026: 1,009 cases
196423
196528
196639
196753
196837
196918
197023
197118
197215
197326
197421
197520
197624
197722
197819
197932
198023
198120
198222
198313
198410
198517
19869
19877
19887
198911
199016
199110
199211
19938
199412
199515
199618
19977
199812
199911
200022
200116
200215
200313
200410
200513
20068
200714
200819
20099
201012
201113
201214
201312
20148
20159
201612
201710
201819
20199
20207
202112
202213
20236
202414
20259
202614

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\") = 1985
    AND c.\"eventStateOrRegion\" = 'OR' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 550)
  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 SEA86LA010Accident · No injuriesLimited investigationFinal reportCessna 182P · Bly, ORThe airstrip was only 20 feet wide. The aircraft was landed slightly to the right of the center. The aircraft's right main gear went into the gravel and the aircraft veered right. The nose gear then struck rocks and collapsed. The aircraft then nosed over.Oct 15, 1985 · N5837J · 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 SEA85LA222Accident · No injuriesLimited investigationFinal reportCessna 180 · Klamath Falls, ORThe plt lost directional control of the acft following a bounced landing. The acft veered off the right side of the rwy where it contacted an area of tall grass and nosed over.Sep 22, 1985 · N8062V · Substantial damageNTSB SEA85LA200Accident · No injuriesLimited investigationFinal reportCessna 180A · Buxton, ORThe pilot misjudged his touchdown point on the 1,000 foot airstrip and had an excess of airspeed. And overrun occurred and the aircraft went down an embankment. At the time of touchdown, there was only about 4 KTS of headwind available.Aug 18, 1985 · N9607B · Substantial damageNTSB SEA85LA184Accident · No injuriesLimited investigationFinal reportGrumman 164 · Klamath Falls, ORA landing was being made on an agricultural airstrip when a dust devil was encountered. During application of brakes the right brake failed due to a leaking o ring. The aircraft then veered right striking a fence.Jul 28, 1985 · N742Y · Substantial damageNTSB SEA85LA174Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Lebanon, ORThe plt stated he performed 4 circling approaches over a sand bar and on the 5th approcah, rotor RPM decayed. Unable to regain the RPM, a hard landing resulted during which the main rotor blades severed the tailrotor.Jul 19, 1985 · N9417A · Substantial damageNTSB SEA85LA161Accident · No injuriesLimited investigationFinal reportMooney M20-F · Salem, ORThe acft was substantially damaged during an inadvertant gear-up landing. Inspection of the acft revealed the landing gear circuit breaker was popped. When functionally tested, the landing gear operated normally. The gear warning horn was found to be…Jul 11, 1985 · N6879V · Substantial damageNTSB SEA85LA159Accident · No injuriesLimited investigationFinal reportCessna 150 · La Grande, ORThis was the student pilot's second solo flight. He had a total time of less than 9 hours. A bounced landing occurred and the student was unable to make an adequate recovery. A witness who saw the accident stated that the aircraft started a climb out with…Jul 9, 1985 · N1749 · Substantial damageNTSB SEA85LA141Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · North Plains, ORAn overrun occurred due to excess speed and touching down 1/4 of the way down the 2100 foot glider strip. The aircraft rolled onto two foot high alfalfa where it then nosed over. The pilot previously landed gliders on the gliderport but never an engine…Jun 16, 1985 · N44SJ · 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 SEA85LA093Accident · No injuriesLimited investigationFinal reportLake Buccaneer · Dexter, ORThe acft bounced during touchdown several times while attending to land on the water. The acft was too close to a dam to make a go-around. The acft then struck the dam head on.Apr 20, 1985 · N2582P · 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 SEA85FA084Accident · 2 fatalField investigationFinal reportBellanca 17-31A · Yamhill, ORWitnesses observed the acft apch the airstrip with excessive speed. Touchdown on the rwy was beyond the halfway point & the acft bounced back into the air. Power was applied for an apparent go-around. The acft cleared tall trees at the end of the runway, but…Apr 7, 1985 · N9705E · DestroyedNTSB 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 damageNTSB SEA85LA072Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Christmasvalley, ORUpon touchdown the left axle broke and the left main gear s eparated from the acft. The acft left the rwy and the nosed over. The plt discovered that the axle had cristalized and then cracked.Mar 10, 1985 · N9166A · Substantial damageNTSB SEA85LA063Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Gaston, ORThe plt was attempting a precautionary landing onto a 1000 foot private grass airstrip due to a noise outside the acft which was heard inflt. The plt was landing to the east with a right quartering tailwind of 5 to 10 knots. An overrun occurred and the plt…Feb 23, 1985 · N3710T · Substantial damage