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 SEA94LA216Accident · No injuriesLimited investigationFinal reportCessna 170B · Redmond, ORProper touchdown point was not attained. A factor to the accident was inadequate remedial action.Aug 17, 1994 · N8339A · Substantial damageNTSB SEA94LA213Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Nehalem, ORThe separation of the landing gear transmission assembly from its attach bracket rivets due to undetermined reasons. It was not possible for the landing gear to be locked down during the landing roll due to this separation.Aug 14, 1994 · N5063P · Substantial damageNTSB SEA94LA153Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Hillsboro, ORThe improper servicing of the skid shock struts.Jun 21, 1994 · N7506A · Substantial damageNTSB SEA94LA148Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26D · North Plains, ORProper touch down point was not obtained. Factors to the accident were: canopy not secured, and inadequate preflight planning/preparation.Jun 8, 1994 · N7751S · Substantial damageNTSB SEA94LA115Accident · No injuriesLimited investigationFinal reportCessna 172P · Hillsboro, ORPoor in-flight planning. Factors to the accident were: inadequate remedial action and uncontrolled porpoise.Apr 29, 1994 · N53161 · Substantial damageNTSB SEA94LA080Accident · No injuriesLimited investigationFinal reportUnrein 80-P51D · Scapp00se, ORThe inadvertent unlocking of the tailwheel lock. Factors include the manufacturer's inadequate tailwheel lock.Mar 10, 1994 · N51PL · Substantial damageNTSB SEA94LA050Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Burns, ORThe student pilot in command's application of excessive braking during the landing roll.Jan 17, 1994 · N95169 · Substantial damageNTSB SEA94LA012Accident · No injuriesLimited investigationFinal reportCessna T-337E · Yamhill, ORThe pilot failed to attain the proper touchdown point. The tailwind was a factor.Oct 10, 1993 · N1244M · Substantial damageNTSB SEA94LA009Accident · No injuriesLimited investigationFinal reportCessna 150E · Sandy, ORFailure of the pilot to maintain proper runway alignment during the landing. The lack of adequate runway alignment marking was a related factor.Oct 5, 1993 · N3071J · Substantial damageNTSB SEA94LA008Accident · No injuriesLimited investigationFinal reportCessna 172RG · Corvallis, ORThe cfi's inadequate in-flight planning, and his inadvertent gear-up landing. Factors include the cfi's diverted attention.Oct 5, 1993 · N16ED · Substantial damageNTSB SEA93LA199Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Yamhill, ORThe pilot's failure to maintain a proper glidepath, improper flare, and improper recovery from a forced landing.Sep 13, 1993 · N757WT · Substantial damageNTSB SEA93LA062Accident · Minor injuriesLimited investigationFinal reportCessna 185E · North Bend, ORThe pilot's failure to maintain directional control, and inadequate remedial action. Factors include a poor inflight decision, and gusty crosswinds.Feb 4, 1993 · N5849J · Substantial damageNTSB SEA93LA061Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Medford, ORMovement of the tailwheel assembly was restricted. Improper maintenance was a factor.Feb 2, 1993 · N11096 · Substantial damageNTSB SEA93LA058Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Bend, ORDirectional control not maintained and ground loop/swerve not corrected by the pilot in command.Jan 31, 1993 · N56843 · Substantial damageNTSB SEA93LA053Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T(B) · John Day, ORThe pilot's failure to maintain directional control. Factors include a snow covered runway.Jan 16, 1993 · N161RS · Substantial damageNTSB SEA93LA030Accident · No injuriesLimited investigationFinal reportHughes 369HS · Scotts Mills, ORThe pilot in command's misjudged descent. Factors include the pilot in command's lack of experience in this type of operation.Nov 27, 1992 · N9228F · Substantial damageNTSB SEA93LA013Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Troutdale, ORImproper use of flt controls by the pilot, resulting in inadvertent stall/spin.Oct 30, 1992 · N66135 · DestroyedNTSB SEA92LA208Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Gates, ORThe excessive application of the brakes by the pilot in command. Factors contributing to the accident were the tailwind and the pilots visual (mis)perception of runway gradient.Sep 20, 1992 · N39039 · Substantial damageNTSB SEA92LA178Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pacific City, ORThe pilot selected the wrong runway relative to the wind and then delayed in aborting the landing. The tailwind was a factor.Aug 12, 1992 · N2328Q · Substantial damageNTSB SEA92LA175Accident · No injuriesLimited investigationFinal reportCessna 172H · Lakeview, ORThe pilot's failure to maintain directional control. Factors include soft terrain.Aug 9, 1992 · N8100L · Substantial damageNTSB SEA92LA123Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Baker, ORThe pilots inadequate recovery from a bounced landing. Factors include unfavorable, gusty winds.Jun 9, 1992 · N6138S · Substantial damageNTSB SEA92LA106Accident · No injuriesLimited investigationFinal reportCessna A185F · Spray, ORThe pilot's selection of unsuitable terrain for landing. Factors include soft and uneven terrain.May 23, 1992 · N61167 · Substantial damageNTSB SEA92LA092Accident · No injuriesLimited investigationFinal reportCessna 150F · Gold Beach, ORFailure of the pilot to maintain airspeed on final approach, resulting in aircraft stall, loss of control and impact with terrain. A factor relating to the accident was the lack of experience by the pilot.May 7, 1992 · N8791G · Substantial damageNTSB SEA92LA090Accident · No injuriesLimited investigationFinal reportCessna 172N · Parkdale, ORThe pilot's failure to use the proper touchdown point for landing. A factor relating to the accident was the soft dirt runway surface.May 4, 1992 · N5096E · Substantial damageNTSB SEA92LA088Accident · No injuriesLimited investigationFinal reportHughes 369E · Hillsboro, ORThe pilot in command's excessive application of collective.May 1, 1992 · N5211Y · Substantial damageNTSB SEA92LA084Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Grants Pass, ORA failure to maintain runway alignment, and a delayed go-around. Factors include a crosswind, gusts, and a fence in the go-around path.Apr 26, 1992 · N9403E · Substantial damageNTSB SEA91LA257Accident · No injuriesLimited investigationFinal reportCessna 172E · Burns, ORThe pilot's delay in computing aircraft fuel consumption and his failure to land at an alternate airport along the route of flight. Factors relating to the accident were the tree by the landing area and the improper maintenance adjustment of the right magneto.Sep 27, 1991 · N5680T · Substantial damageNTSB SEA91LA232Accident · No injuriesLimited investigationFinal reportCessna 140 · Gates, ORThe student pilot's excessive remedial action. Factors to the accident were poor supervision by the CFI.Sep 11, 1991 · N76006 · Substantial damageNTSB SEA91LA234Accident · No injuriesLimited investigationFinal reportCessna 182A · Grants Pass, ORPilot's selection of unsuitable terrain for a precautionary landing. Factors related to the accident were: motion sickness of the passenger, wet grass runway, the pilot's self-induced pressure to land at the accident airport, and the ditch.Sep 8, 1991 · N3974D · Substantial damageNTSB SEA91LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Medford, ORAn intentional porpoise. Factors include the pilot's psychological condition.Jul 9, 1991 · N734MD · Substantial damageNTSB SEA91LA151Accident · No injuriesLimited investigationFinal reportBeech C33A · Brookings, ORThe pilot's improper flare for touchdown, and her improper recovery from a bounced landing.Jul 2, 1991 · N12EM · Substantial damageNTSB SEA91LA141Accident · No injuriesLimited investigationFinal reportCessna 172-M · Salem, ORThe pilot's poor in-flight decision and his failure to select a proper touchdown point. Factors include a wet runway, soft terrain and high vegetation.Jun 20, 1991 · N9830V · Substantial damageNTSB SEA91LA135Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Corvallis, ORThe student pilot's overconfidence in his personal ability and inadquate remedial action. Contributing to the accident was his decision to attempt a solo autoroation.Jun 17, 1991 · N202PR · Substantial damageNTSB SEA91LA101Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Drewsey, ORThe pilot delayed in going-around.May 10, 1991 · N51612 · DestroyedNTSB SEA91LA080Accident · No injuriesLimited investigationFinal reportCessna 172A · Hood River, ORAn inadequately planned approach which resulted in a hard landing. Factors to the accident were rough water landing conditions, poor supervision by the CFI, and the overload condition to the float assembly.Apr 5, 1991 · N9852T · Substantial damageNTSB SEA91FA057Accident · 3 fatalField investigationFinal reportCessna 182J · Glendale, ORThe pilot's failure to use all available runway for this landing, aggravated by his failure to initiate a go-around after misjudging the proper touchdown point and landing with a tailwind.Feb 22, 1991 · N3154F · DestroyedNTSB SEA90LA198Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Albany, ORThe pilot's decision to land with a strong tailwind resulted in the collapse of the landing gear.Sep 29, 1990 · N22450 · Substantial damageNTSB SEA90LA194Accident · Minor injuriesLimited investigationFinal reportRoger A Hansen KR-2M · Shaniko, ORPilot's failure to maintain clearance from a road sign during landing ground roll. A factor in the accident was the failure of the engine exhaust system which resulted in high engine oil temperature.Sep 23, 1990 · N200RH · Substantial damageNTSB SEA90LA184Accident · No injuriesLimited investigationFinal reportCessna 180 · Enterprise, ORThe pilot's failure to maintain directional control of the aircraft during landing.Sep 17, 1990 · N3117D · Substantial damageNTSB SEA90LA185Accident · No injuriesLimited investigationFinal reportCessna 180A · Paisley, ORPilot's selection of unsuitable terrain for a landing site.Sep 16, 1990 · N9669B · Substantial damageNTSB SEA90FA183Accident · 1 fatalField investigationFinal reportCessna 172-P · Hood River, ORThe pilot in command's encountering spatial disorientation and his failure to maintain airspeed.Sep 16, 1990 · N5332K · DestroyedNTSB SEA90LA143Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Redmond, ORThe student pilot's failure to properly recover from a bounced landing.Jul 24, 1990 · N8756G · Substantial damageNTSB SEA90LA151Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Klamath Falls, ORPilot's failure to maintain directional control during the landing roll, resulting in a ground loop. The pilot's lack of experience in this make/model was a related factor.Jul 17, 1990 · N40643 · Substantial damageNTSB SEA90LA134Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Yamhill, ORThe pilot's failure to retract the flaps during go-around.Jul 13, 1990 · N733GJ · DestroyedNTSB SEA90LA141Accident · No injuriesLimited investigationFinal reportCessna TU206G · Sheridan, ORInadvertent engagement of the autopilot during the flare for landing.Jul 9, 1990 · N4784U · Substantial damageNTSB SEA90LA109Accident · No injuriesLimited investigationFinal reportMaule M-5 · Riverside, ORThe pilot's selection of unsuitable terrain for a landing site and his inadequate compensation for the wind condition. Factors related to the accident were: the tailwind and the ditch.Jun 22, 1990 · N9058E · Substantial damageNTSB SEA90LA096Accident · No injuriesLimited investigationFinal reportCessna 310B · Albany, ORThe pilot's failure to extend the landing gear before landing, when he became distracted by a change in his normal routine.Jun 5, 1990 · N6647B · Substantial damageNTSB SEA90LA073Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Newberg, ORThe pilot did not maintain directional control duing the landing.May 8, 1990 · N18024 · Substantial damageNTSB SEA90LA063Accident · Serious injuriesLimited investigationFinal reportCessna 152II · Scio, ORAn inadequate recovery from a bounced landing and inadequate clearance to avoid colliding with trees.Apr 5, 1990 · N67749 · DestroyedNTSB SEA90LA059Accident · No injuriesLimited investigationFinal reportStearman 4E · Burns, ORThe pilot's failure to maintain directional control.Mar 31, 1990 · N663K · Substantial damage