NTSB investigations, OR

393 cases where the phase of flight was Approach.

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 = 500)
  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 WPR10LA298Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Hillsboro, ORA partial loss of engine power while on approach for undetermined reasons.Jun 19, 2010 · N2548S · Substantial damageNTSB WPR10CA026Accident · No injuriesData collectionFinal reportCessna 180A · Condon, ORThe pilot's failure to maintain clearance from the fence post on approach.Oct 10, 2009 · N9586B · Substantial damageNTSB WPR10LA006Accident · Serious injuriesLimited investigationFinal reportTurpen RV-8 · Yankton, ORThe pilot's inadequate planning during an instrument approach and failure to maintain the published minimum altitudes, which resulted in controlled flight into terrain.Oct 5, 2009 · N61FS · Substantial damageNTSB WPR09LA426Accident · Minor injuriesLimited investigationFinal reportSix-Chuter American Spirit · Brownsville, ORThe pilot's failure to maintain clearance from power lines.Aug 29, 2009 · N9184F · Substantial damageNTSB WPR09LA361Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Redmond, ORAn undetermined hydraulic system malfunction in the engine compartment during descent from cruise flight which resulted in an in-flight fire.Jul 21, 2009 · N117KR · Substantial damageNTSB WPR09CA288Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Hell's Canyon, ORThe pilot's failure to maintain clearance from trees.Jun 14, 2009 · N3761Z · Substantial damageNTSB WPR09FA027Accident · 2 fatalField investigationFinal reportCessna P206 · Estacada, ORThe pilot's failure to maintain clearance from trees while on approach to land at night. Contributing to the accident was the electrical system failure and the pilot's diverted attention.Oct 29, 2008 · N2570X · Substantial damageNTSB LAX08CA185Accident · Minor injuriesData collectionFinal reportRobinson R-22 Beta · Philomath, ORThe student pilot's failure to maintain rotor rpm during a pinnacle approach and the flight instructor's delayed remedial action and inadequate supervision of the flight. Contributing to the accident was the downdraft weather condition.Jun 17, 2008 · N4000Y · Substantial damageNTSB SEA08CA143Accident · Minor injuriesData collectionFinal reportCessna 150M · Cove, ORThe pilot's failure to maintain clearance with terrain during a go-around.May 28, 2008 · N63422 · Substantial damageNTSB SEA08CA141Accident · No injuriesData collectionFinal reportPiper PA-20 · Fields, ORThe pilot's failure to maintain aircraft control during the approach. Contributing to the accident was a windshear.May 25, 2008 · N7076K · Substantial damageNTSB LAX08CA143Accident · No injuriesData collectionFinal reportMason RV-9A · Pacific City, ORThe pilot's inadequate flare and failure to maintain control following a hard landing. Contributing to the accident was a temporary partial loss of power due to carburetor icing conditions.May 17, 2008 · N486EM · Substantial damageNTSB SEA08FA078Accident · 1 fatalField investigationFinal reportLancair LC41 · Portland, ORThe pilot's failure to follow the missed approach procedure. Contributing to the accident were the fog and below landing minimums visibility conditions.Feb 16, 2008 · N621ER · DestroyedNTSB SEA07CA269Accident · Minor injuriesData collectionFinal reportRobinson R-22 Beta · Bend, ORProper descent rate not obtained/maintained during a pinnacle approach.Sep 21, 2007 · N2341J · Substantial damageNTSB LAX07LA280Accident · Serious injuriesLimited investigationFinal reportRoot Sherpa · Scappoose, ORA loss of aircraft pitch control due to the fatigue failure of the fuselage tube structure at the flight control stick gimbal mechanism due to an incomplete weld penetration at the root of the weld.Sep 18, 2007 · N1415B · Substantial damageNTSB LAX07CA242Accident · No injuriesData collectionFinal reportCessna 172B · Sisters, ORThe pilot's failure to maintain adequate clearance from trees.Aug 7, 2007 · N7604X · Substantial damageNTSB SEA07LA056Accident · Minor injuriesLimited investigationFinal reportMartin/Harris Harmon Rocket · Troutdale, ORA total loss of power for undetermined reasons just as the aircraft was maneuvering to enter the downwind for landing. The absence of a suitable landing location was a factor in the accident.Jan 31, 2007 · N141RH · Substantial damageNTSB SEA07FA031Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Bandon, ORThe loss of aircraft control in the traffic pattern for undetermined reasons.Dec 12, 2006 · N5618U · Substantial damageNTSB SEA07CA010Accident · No injuriesData collectionFinal reportAlexander Lancair 320 · Scappoose, ORThe pilot's failure to maintain aircraft control during a go-around.Oct 22, 2006 · N1382Y · Substantial damageNTSB SEA06CA174Accident · No injuriesData collectionFinal reportCessna 180 · Arock, ORThe pilot's failure to maintain directional control during a go-around, resulting in an in-flight collision with trees and substantial damage to the airplane. Factors included the pilot's failure to attain the proper touchdown point, the delayed go-around,…Sep 3, 2006 · N9026C · Substantial damageNTSB SEA06LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Ontario, ORThe pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. Factors were the en route high wind condition and the soft terrain.Aug 4, 2006 · N1221P · Substantial damageNTSB SEA06CA092Accident · No injuriesData collectionFinal reportCessna 182F · Canby, ORThe pilot's misjudgment of altitude resulting in an undershoot. A factor was the berm.May 5, 2006 · N3305W · Substantial damageNTSB SEA06CA084Accident · No injuriesData collectionFinal reportBeech P-35 · Bandon, ORThe pilot's failure to adequately compensate for wind conditions. A crosswind was a factor.Apr 24, 2006 · N8689M · Substantial damageNTSB SEA06CA061Accident · No injuriesData collectionFinal reportPiper PA-18 · Saint Paul, ORThe pilot's failure to maintain a proper glide path on final approach to landing resulting in a nose over. A factor was the loose gravel/sandy condition.Mar 5, 2006 · N1991A · Substantial damageNTSB SEA06LA057Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Cottage Grove, ORFuel starvation while on approach for landing resulting in a loss of engine power, and an inadequately accomplished annual inspection. Incorrect hardware which impeded the movement of the fuel selector valve, improper fuel management and not identifying the…Feb 23, 2006 · N6595U · Substantial damageNTSB SEA06FA038Accident · 1 fatalField investigationFinal reportMooney M20K · North Plains, ORThe pilot's failure to maintain airspeed while maneuvering for a forced landing, resulting in a stall-spin and uncontrolled descent to ground impact. A contributing factor was the loss of engine power due to fuel exhaustion resulting from the pilot's…Jan 5, 2006 · N27ER · DestroyedNTSB SEA06LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Newberg, ORThe flight instructor's failure to maintain airspeed while on approach for landing resulting in an inadvertent stall. Wind gusts, trees and an undetermined loss of engine power were factors.Oct 15, 2005 · N23887 · Substantial damageNTSB SEA05LA153Accident · No injuriesLimited investigationFinal reportMooney M20J · Sunriver, ORThe loss of engine power as a result of both sets of magneto points failing to open due to excessive wear of the nylon cam followers. The excessive wear of the cam followers was due to maintenance personnel's failure to follow the magneto manufacturer's…Jul 28, 2005 · N110MP · Substantial damageNTSB SEA05FA125Accident · 2 fatalField investigationFinal reportCessna 172M · Yamhill, ORThe flight instructor's excessive climb and failure to maintain adequate airspeed during an attempted go-around, which resulted in an inadvertent stall and subsequent collision with the ground. Contributing factors were the flight instructor's improper…Jun 24, 2005 · N4368R · Substantial damageNTSB SEA05CA080Accident · No injuriesData collectionFinal reportCessna 172 · Yamhill, ORThe pilot's failure to maintain aircraft control while on final approach for landing. A crosswind, a fence post and the pilot's inadequate compensation for the crosswind condition were contributing factors.Apr 9, 2005 · N8400L · Substantial damageNTSB SEA05CA059Accident · No injuriesData collectionFinal reportCessna 182A · Manzanita, ORThe pilot's inadequate compensation for the wind, which resulted in an inflight loss of control, a subsequent uncontrolled descent into the tree stump and guy wire, and the resultant nose over. A factor contributing to the accident was the downdraft.Mar 13, 2005 · N4076D · Substantial damageNTSB SEA04CA186Accident · No injuriesData collectionFinal reportGrumman American AA-5A · Brooks, ORThe flight instructor's failure to maintain altitude/clearance on final approach to land resulting in an in-flight collision with terrain. Contributing factors were the student pilot's failure to maintain adequate airspeed during the approach and the flight…Sep 12, 2004 · N26327 · DestroyedNTSB SEA04CA076Accident · No injuriesData collectionFinal reportMooney M-20J · Redmond, ORThe pilot's failure to adequately compensate for wind conditions. Unfavorable wind was a factor.Apr 30, 2004 · N5764K · Substantial damageNTSB SEA04LA073Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Haines, ORA momentary partial loss of power for undetermined reason(s) and the pilot's failure to maintain adequate RPM during his autorotation landing.Apr 26, 2004 · N9785C · Substantial damageNTSB SEA04LA058Accident · Minor injuriesLimited investigationFinal reportLuscombe T8F · Chiloquin, ORThe pilot's failure to maintain airspeed during a downwind turn resulting in a stall-mush and collision with the ground. Wind gusts were a factor.Mar 26, 2004 · C-FHUH · Substantial damageNTSB SEA04LA046Accident · Minor injuriesLimited investigationFinal reportJerome Q-2 · Hillsboro, ORThe pilot's inadequate evaluation of deteriorating weather conditions (increasing rain) and his failure to maintain the proper rate of descent on landing (long/hard touchdown). Contributing factors were carburetor icing conditions and rain.Feb 28, 2004 · N143GJ · Substantial damageNTSB SEA04LA013Accident · No injuriesLimited investigationFinal reportCessna 172M · Bandon, ORThe pilot's failure to maintain clearance from objects while on final approach. Dark night conditions, trees and a low glidepath were factors.Oct 28, 2003 · N80628 · Substantial damageNTSB SEA03LA182Accident · Minor injuriesLimited investigationFinal reportPitts S-2A · Hillsboro, ORThe pilot's failure to maintain the proper distance and altitude while on final approach which led to touching down short of the runway. The pilot's restricted visual lookout was a factor.Sep 1, 2003 · N5301W · DestroyedNTSB SEA03LA152Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hermiston, ORThe pilot's inadequate in-flight decision by failing to refuel, resulting in fuel exhaustion and the loss of power. Rocky terrain was a factor.Jul 21, 2003 · N4250X · Substantial damageNTSB SEA03LA118Accident · 1 fatalLimited investigationFinal reportHerrin Hornet · Newberg, ORAircraft control not maintained while maneuvering for landing.Jun 26, 2003 · N1424 · Substantial damageNTSB SEA03FA110Accident · 1 fatalField investigationFinal reportHarshbarger W/Reed RV-8 · Grants Pass, ORCorrosion and contamination within the fuel servo unit and the pilot's delayed turn back to the runway. Contributing factors were trees and the pilot's impairment due to prescription medication.Jun 20, 2003 · N863Y · Substantial damageNTSB SEA03FA024Accident · Serious injuriesField investigationFinal reportBombardier DHC-8-401 · Medford, ORThe fracture and spalling of the inner-most pane of the aircraft's port side windshield while on a downwind for a night visual approach due to an imposed load beyond that required for windshield certification (multiple bird strikes). Factors include a dark…Jan 9, 2003 · N409QX · Substantial damageNTSB SEA03LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28-201T · La Grande, ORInadequate supervision and the premature raising of flaps before a positive climb was established.Nov 14, 2002 · N2208Y · Substantial damageNTSB SEA02LA107Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Troutdale, ORA loss of engine power for an undetermined (non-mechanical) reason. Contributing factors were high grass and soft terrain which lead to the collapse of the nose gear during the landing roll.Jun 20, 2002 · N5383T · Substantial damageNTSB SEA02LA102Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Umpqua, ORThe pilot's failure to adequately compensate for unfavorable wind conditions and maintain clearance from the terrain during an attempted VFR go-around. Factors include an encounter with unfavorable wind conditions during the landing flare and the attempted…Jun 15, 2002 · N5942H · Substantial damageNTSB SEA02FA005Accident · 2 fatalField investigationFinal reportPiper PA-18 · Sandy, ORThe pilot's failure to maintain clearance from the trees while attempting to land in a field after entering an area of instrument meteorological conditions. Factors include low ceilings, rain, fog, strong winds, mountainous/hilly terrain, the pilot's…Oct 16, 2001 · N7502K · Substantial damageNTSB SEA01LA170Accident · 1 fatalLimited investigationFinal reportCessna 182J · Gold Beach, ORThe pilot's failure to attain proper alignment while on final approach and clearance from trees. The pilot's lack of total experience in this type of mountain flying operation was a factor.Sep 9, 2001 · N3056F · Substantial damageNTSB SEA01LA105Accident · No injuriesLimited investigationFinal reportCessna T210M · Portland, ORA burst hydraulic line and consequent total loss of hydraulic fluid from the landing gear, which disabled landing gear operation.May 27, 2001 · N761DL · Substantial damageNTSB SEA01LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Corvallis, ORThe student instructor's failure to maintain the airplane's minimum control airspeed during a practice single-engine approach, and the flight instructor's failure to direct or accomplish a timely go-around, resulting in loss of aircraft control with…May 9, 2001 · N47GM · DestroyedNTSB SEA01FA059Accident · No injuriesField investigationFinal reportde Havilland DHC-8-102 · Portland, ORThe failure of the number 5 engine bearing assembly followed by the disconnection of the P2.5/P3 switching valve to rear inlet case sealing air tube and the melting of the NL probe port (sealing tube) which allowed an oil fed fire beyond the constraints of…Mar 6, 2001 · N822PH · Substantial damageNTSB SEA01LA053Accident · No injuriesLimited investigationFinal reportGibbs V-6 Stol · Newberg, ORthe pilot's mismanagement of his available fuel, the fuel starvation of the engine, and the pilot's excessive rate of descent during the touchdown portion of a power-off forced landing.Feb 25, 2001 · N230VG · Substantial damage