NTSB investigations, OR

1,009 cases where the phase of flight was Landing.

Cases, newest first

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 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 SEA98LA129Accident · No injuriesLimited investigationFinal reportCessna 150 · Oregon City, ORThe pilot's improper flare.Jul 7, 1998 · N6417T · Substantial damageNTSB SEA98LA094Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · North Plains, ORThe pilot's failure to maintain directional control and his failure to maintain clearance from a pole. Contributing factors were rain and an overcast which resulted in less than optimal conditions to detect the pole.Jun 11, 1998 · N65918 · Substantial damageNTSB SEA98LA061Accident · No injuriesLimited investigationFinal reportCessna 180 · Redmond, ORThe passenger-pilot's excessive rate of descent during touchdown. Factors include the pilot-in-command's inadequate recovery from a hard/bounced landing, the passenger-pilot's failure to execute a go-around after taking control of the aircraft, and gusty…Apr 9, 1998 · N2933C · Substantial damageNTSB SEA98LA058Accident · No injuriesLimited investigationFinal reportCessna 195A · Bend, ORSeparation by fracture of the left main gear leg, as the result of fatigue cracks that initiated in corrosion pits on the gear leg surface.Apr 1, 1998 · N1069D · Substantial damageNTSB SEA98LA035Accident · Minor injuriesLimited investigationFinal reportBromley Steen Skybolt · Hillsboro, ORThe pilot's failure to maintain a proper glidepath.Feb 5, 1998 · N55740 · Substantial damageNTSB SEA97LA207Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel AIR 12-Q · Pendleton, ORthe tail wheel assembly spring disconnected.Sep 7, 1997 · N496W · Substantial damageNTSB SEA97LA190Accident · Minor injuriesLimited investigationFinal reportLaister LP-49 · North Plains, ORThe pilot's selection of an inadequate landing site, and his failure to adequately plan his return glide back to his home gliderport. A factor contributing to the accident was rough terrain.Aug 16, 1997 · N40NH · Substantial damageNTSB SEA97LA187Accident · No injuriesLimited investigationFinal reportCessna 140 · Hillsboro, ORThe pilot's failure to maintain directional control during landing.Aug 13, 1997 · N76233 · Substantial damageNTSB SEA97LA155Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Prineville, ORThe pilot's selection of an unsuitable landing area, his improper decision to attempt an aborted takeoff on a short airstrip surround by rising terrain and trees, and his failure to maintain clearance from the trees during the aborted takeoff attempt. Factors…Jun 28, 1997 · N1182A · Substantial damageNTSB SEA97LA144Accident · No injuriesLimited investigationFinal reportBeech N35 · Hillsboro, ORthe pilot's failure to ensure the landing gear was down and locked for landing. The unlatched passenger door, the uphill (unidirectional) landing area, and trees off the departure end of the landing runway were related factors.Jun 16, 1997 · N1382Z · Substantial damageNTSB SEA97LA135Accident · No injuriesLimited investigationFinal reportBucker Flugzeugbau 1.131 Jungmann · Cottage Grove, ORfailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve and gear collapse. The wet runway surface was a related factor.Jun 11, 1997 · N1XW · Substantial damageNTSB SEA97LA107Accident · No injuriesLimited investigationFinal reportCessna 170B · Ontario, ORThe pilot's failure to adequately compensate for the wind conditions. A factor contributing to the accident was gusting winds.May 10, 1997 · N8224A · Substantial damageNTSB SEA97TA012Accident · Minor injuriesFinal reportGarlick UH-1H · Detroit, ORthe pilot's misjudgement of rotor clearance from the terrain. The proximity of the berm was a related factor.Oct 20, 1996 · N98NW · Substantial damageNTSB SEA97LA014Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Albany, ORfailure of the SA-750 pilot to see-and-avoid the Cessna 172, which had landed ahead of him on the same runway. The inherent visual restrictions of the SA-750 (a tandem two-place biplane) was a related factor.Oct 12, 1996 · N9579H · 2 aircraft · Substantial damageNTSB SEA96LA218Accident · No injuriesLimited investigationFinal reportCessna 170 · Enterprise, ORthe pilot's misjudgment of speed and distance during the approach/landing, his failure to attain a proper touchdown point during the landing, and his failure to go around (while there was sufficient runway remaining). The short runway was a related factor.Sep 22, 1996 · N2496D · Substantial damageNTSB SEA96LA156Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Arock, ORfailure of the pilot to maintain directional control of the aircraft during the landing, which resulted in an inadvertent ground loop. The tailwind was a related factor.Jul 12, 1996 · N8692K · Substantial damageNTSB SEA96LA142Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Newport, ORthe passenger's inadvertent activation of the aircraft's rudder, which resulted in a loss of directional control and collision with a tree during an attempted go-around (aborted landing).Jul 5, 1996 · N5663U · Substantial damageNTSB SEA96LA139Accident · No injuriesLimited investigationFinal reportAgusta A109 · Newport, ORthe pilot's failure to adequately compensate for the gusty wind condition during the landing. The gusty wind was a related factor.Jul 1, 1996 · N808GM · Substantial damageNTSB SEA96LA122Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Wilsonville, ORfailure of the pilot to maintain clearance from the static wire, which became shorted to a transmission wire and subsequently caused a fire to erupt on the balloon's envelope. Factors relating to the accident were: the obstructions (power line wires), and the…Jun 16, 1996 · N71233 · Substantial damageNTSB SEA96LA127Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Aurora, ORinadvertent retraction of the landing gear by the pilot during landing.Jun 14, 1996 · N67SA · Substantial damageNTSB SEA96LA121Accident · No injuriesLimited investigationFinal reportBeech 35 · Aurora, ORfailure of the non-certificated pilot to ensure that the landing gear was properly extended for landing. The non-certificated pilot's diverted attention was a related factor.Jun 10, 1996 · N2145D · Substantial damageNTSB SEA96LA101Accident · No injuriesLimited investigationFinal reportCessna 177 · Corvallis, ORfailure of the pilot to properly judge the distance and altitude to the runway just before touching down, and his premature flare for landing. Factors relating to the accident were: the presence of sun glare during the landing, and the resultant degradation…May 27, 1996 · N177JM · Substantial damageNTSB SEA96LA098Accident · No injuriesLimited investigationFinal reportConsolidated-Vultee BT-13A · Brookings, ORthe pilot's misjudgment of distance/speed during the approach to landing, his failure to attain a proper touchdown point for landing, and his failure to perform a go-around, while there was sufficient runway and airspeed remaining. The tailwind was a related…May 26, 1996 · N56642 · Substantial damageNTSB SEA96LA097Accident · No injuriesLimited investigationFinal reportPowers Bede BD-4 · Pacific City, ORthe pilot's inadequate compensation for wind conditions during the landing flare, and his failure to maintain runway alignment, which resulted in an encounter with tall grass beside the intended landing area. Factors relating to the accident were: the…May 25, 1996 · N239CP · Substantial damageNTSB SEA96LA092Accident · Minor injuriesLimited investigationFinal reportAeronca 7BCM · Bend, ORThe pilot in command's failure to adequately compensate for wind conditions during the landing. Factors contributing to the accident were a crosswind and gusty wind conditions.May 11, 1996 · N2606Z · DestroyedNTSB SEA96LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Harper, ORthe pilot's selection of unsuitable terrain (landing area) for a precautionary landing. A factor relating to the accident was: the pilot became ill during the flight.May 4, 1996 · N3568D · Substantial damageNTSB SEA96LA087Accident · No injuriesLimited investigationFinal reportNanchang CJ-6A · Molalla, ORthe pilot's failure to adequately plan the approach, and his misjudgment of distance and speed during the landing. The wet runway was a related factor.May 3, 1996 · N62160 · Substantial damageNTSB SEA96LA069Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Sunriver, ORthe pilot's failure to maintain directional control during the landing rollout. A factor contributing to the accident was the presence of a tree near the edge of the runway.Mar 16, 1996 · N563UC · Substantial damageNTSB SEA96LA066Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Eugene, ORthe student pilot's inadvertent activation of the brakes and his failure to maintain directional control, which resulted in an inadvertent ground swerve.Mar 9, 1996 · N8920S · Substantial damageNTSB SEA96LA054Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Ashland, ORthe dual student's improper touchdown, and the instructor's delayed remedial action. The crosswind was a related factor.Feb 10, 1996 · N690 · Substantial damageNTSB SEA96LA035Accident · No injuriesLimited investigationFinal reportCessna 172N · Pacific City, ORThe pilot's delay in aborting the landing, which resulted in his failure to clear the perimeter fence. Factors relating to the accident were: the tailwind, and the pilot's failure to land at the proper touchdown point.Dec 24, 1995 · N738ME · Substantial damageNTSB SEA96LA032Accident · No injuriesLimited investigationFinal reportCessna 172K · Owyhee, ORthe pilot's selection of unsuitable terrain for landing. The soft terrain and high vegetation were related factors.Dec 17, 1995 · N143JP · Substantial damageNTSB SEA95LA204Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Corvallis, ORShearing of the right main landing gear shock strut retainer cap retaining pins.Sep 4, 1995 · N8865K · Substantial damageNTSB SEA95LA194Accident · No injuriesLimited investigationFinal reportCessna 421 · Creswell, ORthe company mechanic's failure to properly fabricate a fuel line.Aug 18, 1995 · N3121K · Substantial damageNTSB SEA95FA170Accident · No injuriesField investigationFinal reportDornier DO 328-100 · Portland, ORinsufficiently defined information from the manufacturer and operator concerning the landing/taxi procedures.Aug 3, 1995 · N335PH · Substantial damageNTSB SEA95LA156Accident · No injuriesLimited investigationFinal reportFairchild 24G · Nyssa, ORLock-up of the mechanical cable-actuated right wheel brake system, rendering directional control of the aircraft impossible. Contributing to the accident was a crosswind from the left during the landing.Jul 20, 1995 · N16899 · Substantial damageNTSB SEA95LA115Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Medford, ORAn unreliable fuel quantity gage and an inadequate preflight. The tall vegetation in the landing area was a factor.Jun 6, 1995 · N28087 · Substantial damageNTSB SEA95LA100Accident · No injuriesLimited investigationFinal reportBoeing E75 · Newberg, ORThe pilot's improper use of the aircraft brakes. Contributing to the accident was the pilot's decision not to perform a go-around, which resulted in failure to attain the desired touchdown point on landing.May 13, 1995 · N1067N · Substantial damageNTSB SEA95LA091Accident · No injuriesLimited investigationFinal reportNorth American SNJ-4 · Prospect, ORThe pilot's failure to maintain directional control of the airplane during landing. Contributing to the accident was wet grass.Apr 4, 1995 · N2269N · Substantial damageNTSB SEA95LA071Accident · No injuriesLimited investigationFinal reportCessna 172D · Lake Oswego, ORThe pilot's improper touchdown on the surface of the water.Mar 25, 1995 · N6600T · Substantial damageNTSB SEA95LA065Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Hillsboro, ORThe dual student pilot's failure to maintain directional control of the helicopter during the practice hover autorotation to landing, and the flight instructor's failure to adequately supervise the dual student during the landing. Contributing to the accident…Mar 12, 1995 · N721HH · Substantial damageNTSB SEA95LA068Accident · No injuriesLimited investigationFinal reportBell 230 · Portland, ORThe pilot-in-command's failure to maintain clearance from the perimeter fence while landing. A factor was the heliport perimeter fence.Mar 7, 1995 · N230LF · Substantial damageNTSB SEA95LA057Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Salem, ORThe pilot-in-command's failure to maintain directional control during the landing rollout.Feb 25, 1995 · N4269E · 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 SEA95LA019Accident · No injuriesLimited investigationFinal reportBeech A23 · La Grande, ORThe pilot's failure to maintain directional control. Factors include the soft, wet airstrip, and a ditch near the side of the runway.Nov 3, 1994 · N4792J · Substantial damageNTSB SEA95LA003Accident · No injuriesLimited investigationFinal reportCessna 210 · Bend, ORThe failure of the landing gear downlock mechanism to engage due to undetermined reasons.Oct 7, 1994 · N75DA · Substantial damageNTSB SEA95LA002Accident · No injuriesLimited investigationFinal reportCessna 150 · Florence, ORThe pilot-in-command's failure to properly recover from a bounced landing, and his failure to compensate for wind conditions and maintain directional control during the landing rollout. Contributing to the accident were gusty crosswinds.Oct 4, 1994 · N3164X · Substantial damageNTSB SEA94LA226Accident · No injuriesLimited investigationFinal reportCessna 182P · Yamhill, ORThe pilot's failure to maintain directional control. A factor to the accident was: an inadequate recovery from a bounced landing.Aug 30, 1994 · N1316S · Substantial damageNTSB SEA94LA219Accident · No injuriesLimited investigationFinal reportCessna 150E · Mcminnville, ORThe student pilot's failure to maintain directional control, and his inadequate remedial action. Factors include soft terrain in the vicinity of the runway.Aug 24, 1994 · N4016U · Substantial damage