NTSB investigations, OR

695 cases where the phase of flight was Enroute.

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 = 400)
  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 WPR13LA378Accident · No injuriesLimited investigationFinal reportCessna 172B · Sisters, ORA loss of engine power during cruise flight for reasons that could not be determined because the engine was not properly preserved to prevent corrosion after the wreckage was recovered from the lake.Aug 18, 2013 · N8141X · Substantial damageNTSB WPR13LA363Accident · No injuriesLimited investigationFinal reportQuarnoccio Avid Flyer · White City, ORExcessive engine operating temperature, which resulted in engine failure and a forced landing. The reason for the excessive engine operating temperature could not be determined during postaccident engine examination.Jul 13, 2013 · N399Q · Substantial damageNTSB WPR13FA006Accident · Minor injuriesField investigationFinal reportGarlick Helicopters UH-1H · Shady Cove, ORThe separation of the tail rotor gearbox and tail rotor assembly as a result of fatigue to the tail rotor gearbox input quill assembly attachment studs.Oct 7, 2012 · N1577 · Substantial damageNTSB WPR12LA439Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Eugene, ORA total loss of engine power due to fuel exhaustion during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have resulted in the loss of engine power.Sep 29, 2012 · N95840 · Substantial damageNTSB WPR12LA402Accident · Serious injuriesLimited investigationFinal reportHansen HANSEN-VANS RV-6 · Lemolo Lake, ORAn overvoltage event due to the failure of the automotive voltage regulator, which resulted in electrical anomalies and smoke in the cockpit and a subsequent forced off-airport landing.Sep 5, 2012 · N53MH · Substantial damageNTSB WPR12CA304Accident · No injuriesData collectionFinal reportSchempp Hirth Nimbus II · Redmond, ORA loss of aerodynamic lift that resulted in a forced landing on unsuitable terrain.Jul 13, 2012 · N96132 · Substantial damageNTSB WPR12LA023Accident · No injuriesLimited investigationFinal reportCessna 185 · Prineville, ORA total loss of engine power due to fuel starvation, which resulted from the pilot inadvertently leaving the fuel selector set to the left tank. Contributing to the accident was the pilot’s deviation from his normal habit pattern and his failure to refer to…Oct 28, 2011 · N520YH · Substantial damageNTSB WPR12FA021Accident · 1 fatalField investigationFinal reportCessna 182R · Lexington, ORThe pilot’s failure to maintain situational awareness and terrain clearance on a dark night during the approach to landing.Oct 27, 2011 · N6545E · Substantial damageNTSB WPR12FA020Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · St. Paul, ORThe pilot was unable to see the other aircraft to avoid a collision.Oct 25, 2011 · N3062H · 2 aircraft · Substantial damageNTSB WPR11LA412Accident · No injuriesLimited investigationFinal reportWheeler Vans RV-6A · Albany, ORThe in-flight separation of a propeller blade due to fatigue.Aug 28, 2011 · N642DW · Substantial damageNTSB WPR11FA395Accident · 1 fatalField investigationFinal reportMaule M-7-235C · Brookings, ORThe pilot’s improper decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in a collision with trees while on approach for landing.Aug 21, 2011 · N199BF · Substantial damageNTSB WPR11LA352Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B3 · Troutdale, ORThe in-flight separation of the tail rotor drive shaft cover as a result of maintenance personnel not ensuring that it was secured after a maintenance inspection; also causal was the pilot’s inadequate preflight inspection of the helicopter.Jul 27, 2011 · N808LF · Substantial damageNTSB WPR11CA329Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Albany, ORThe pilot's inadequate preflight inspection and failure to ensure the fuel cap was secured after refueling, which resulted in a total loss of engine power due to fuel exhaustion.Jul 14, 2011 · N16TP · Substantial damageNTSB WPR11LA290Accident · Minor injuriesLimited investigationFinal reportChristen Industries Pitts S-1T · Alkali Lake, ORThe loss of engine oil during cruise flight due to the failure of the front bearing oil seal.Jun 26, 2011 · N77MN · Substantial damageNTSB WPR11FA256Accident · 3 fatalField investigationFinal reportBellanca 17-31ATC · Ukiah, ORThe non-instrument-rated pilot's decision to conduct a visual flight rules flight over mountainous terrain into a region covered by clouds, which likely resulted in spatial disorientation and subsequent loss of airplane control.Jun 11, 2011 · N79BF · Substantial damageNTSB WPR11FA116Accident · 3 fatalField investigationFinal reportCessna 182K · Adrian, ORThe non-instrument-rated pilot did not maintain sufficient altitude to clear mountainous terrain while in cruise flight in the dark.Jan 30, 2011 · N3083Q · Substantial damageNTSB WPR10LA419Accident · No injuriesLimited investigationFinal reportHummel / Finberg Ultra Cruiser · Canby, ORThe loss of engine power due to low cylinder compression.Aug 21, 2010 · N524DF · Substantial damageNTSB WPR10FA397Accident · 2 fatalField investigationFinal reportAero Commander 500-B · Burns, ORThe non-instrument rated pilot's improper decision to continue flight into an area of known instrument meteorological conditions and his failure to maintain control of the airplane after entering those conditions.Aug 11, 2010 · N500FV · Substantial damageNTSB WPR10LA366Accident · 1 fatalLimited investigationFinal reportClark RV-9A · Oregon City, ORThe pilot's decision to depart with known mechanical anomalies and the loss of engine power for undetermined reasons.Jul 23, 2010 · N70720 · Substantial damageNTSB WPR10LA168Accident · No injuriesLimited investigationFinal reportCessna 150F · Tillamook, ORThe partial loss of engine power during climb to cruise due to carburetor icing and the pilot's delay in using carburetor heat.Mar 17, 2010 · N7854F · Substantial damageNTSB WPR10LA149Accident · Minor injuriesLimited investigationFinal reportSchafer Starduster SA-300 · North Bend, ORThe complete loss of engine power during cruise for undetermined reasons.Feb 28, 2010 · N105NL · Substantial damageNTSB WPR10GA113Accident · 2 fatalFinal reportCessna 182R · Corvallis, ORThe pilot’s failure to maintain clearance from terrain while operating into a known area of mountain obscuration due to low clouds, precipitation, and mist.Jan 18, 2010 · N702 · Substantial damageNTSB WPR10LA001Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Mitchell, ORThe pilot’s lack of understanding of the airplane’s fuel system, which resulted in a loss of engine power due to fuel exhaustion.Oct 2, 2009 · N1621C · Substantial damageNTSB WPR09FA428Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Canyonville, ORThe non-instrument-rated and non-certificated pilot’s decision to continue visual flight into instrument meteorological conditions in mountainous terrain, which resulted in controlled flight into terrain.Aug 30, 2009 · N2967P · Substantial damageNTSB WPR09FA391Accident · 3 fatalField investigationFinal reportNavion Navion A · Adrian, ORThe pilot’s failure to maintain aircraft control while in cruise flight due to spatial disorientation, which resulted in an exceedence of the design stress limits of the aircraft and led to an in-flight structural failure.Aug 7, 2009 · N4898K · Substantial damageNTSB WPR09LA219Accident · No injuriesLimited investigationFinal reportEllumax Leasing Epic LT · Astoria, ORThe partial loss of engine power during climb to cruise due to the failure of the engine's fuel control unit. Contributing to the accident was the incorrect machining of an internal component of the fuel control unit, and the failure of the assembling…Apr 24, 2009 · N653SB · Substantial damageNTSB SEA08LA193Accident · Serious injuriesLimited investigationFinal reportWasson Loehle Loehle P-40 · Oregon City, ORThe loss of total engine power due to a cold seizure.Aug 31, 2008 · N510JW · Substantial damageNTSB LAX08LA226Accident · No injuriesLimited investigationFinal reportJonsson Sonerai · Hood River, ORThe pilot's failure to maintain directional control during the emergency landing roll with a tailwind. Contributing was the partial separation of the left aileron that prompted the pilot to attempt the emergency landing.Jul 11, 2008 · N8050R · Substantial damageNTSB SEA08LA156Accident · Serious injuriesLimited investigationFinal reportCessna TR182 · Bend, ORThe failure of the crankshaft during cruise flight due to fatigue.Jun 30, 2008 · N7XZ · Substantial damageNTSB LAX08LA168Accident · No injuriesLimited investigationFinal reportMkii Lancair Legacy 2000 · Bend, ORA total loss of engine power due to the fatigue failure of the Number 3 cylinder connecting rod.Jun 9, 2008 · N199L · Substantial damageNTSB LAX08IA093Incident · No injuriesIncident investigationFinal reportBennett Lancair 320 · Hillsboro, ORThe malfunction of the airplane's battery and alternator that resulted in the failure of the landing gear to extend and lock in place.Apr 2, 2008 · N456 · Minor damageNTSB SEA08LA098Accident · No injuriesLimited investigationFinal reportKenney RV6 · Aurora, ORA propeller malfunction for undetermined reasons.Mar 27, 2008 · N65MK · Substantial damageNTSB SEA08LA035Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Newberg, ORThe student pilot's inadvertent application of the fuel shut off valve during flight. Contributing to the accident were the locations of the heater and fuel shutoff controls.Nov 21, 2007 · N61480 · Substantial damageNTSB SEA08CA016Accident · Minor injuriesData collectionFinal reportDye Rans S-12 Airaile · Cottage Grove, ORThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.Oct 31, 2007 · N2161Y · Substantial damageNTSB LAX07CA232Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Eagle Point, ORFuel exhaustion due to the pilot's inadequate fuel consumption calculations.Aug 3, 2007 · N919CA · Substantial damageNTSB SEA07LA158Accident · 3 fatalLimited investigationFinal reportShepard Lancair Propjet · Portland, ORThe loss of airplane control during climb for an undetermined reason.Jun 15, 2007 · N42EX · DestroyedNTSB LAX07CA133Accident · No injuriesData collectionFinal reportJiran FJ-1 · Banks, ORthe pilot's misjudged distance/altitude that led to a failure to attain the proper touchdown point.Apr 22, 2007 · N366W · Substantial damageNTSB LAX07CA111Accident · Serious injuriesData collectionFinal reportCessna 182 · Diamond Lake, ORFuel exhaustion due to the pilot's inadequate preflight inspection and failure to verify the fuel supply. A factor was the night lighting condition.Mar 17, 2007 · N6462A · Substantial damageNTSB SEA07LA052Accident · No injuriesLimited investigationFinal reportCessna 172D · Beaver Marsh, ORThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Jan 23, 2007 · N2599U · Substantial damageNTSB SEA07LA039Accident · Serious injuriesLimited investigationFinal reportAveryt Vans RV-4 · Grants Pass, ORThe pilot's failure to maintain adequate airspeed during performance of a go-around, resulting in an inadvertent stall and subsequent in flight collision with the ground. A contributing factor was the in-flight loss of a portion of one propeller blade.Dec 29, 2006 · N234RV · Substantial damageNTSB SEA07CA008Accident · Minor injuriesData collectionFinal reportBeech E-55 · Ontario, ORThe dual loss of engine power due to fuel exhaustion as a result of the pilot's failure to adequately determine the amount of fuel aboard the airplane during his preflight preparation. A contributing factor was the pilot's misjudgment of distance/speed during…Oct 12, 2006 · N94LL · Substantial damageNTSB SEA06CA099Accident · Minor injuriesData collectionFinal reportCessna 152 · Klamath Falls, ORThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power. Soft terrain was a contributing factor.May 17, 2006 · N69183 · Substantial damageNTSB SEA06LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Brookings, ORThe pilot's inadequate in flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power. Trees and no suitable terrain for the landing were factors.Jan 13, 2006 · N35681 · Substantial damageNTSB SEA05CA175Accident · No injuriesData collectionFinal reportCessna 150J · Roseburg, ORThe loss of engine power as a result of fuel exhaustion due to the pilot's inadequate in-flight planning and failure to refuel the airplane. A contributing factor was the lack of suitable terrain for the forced landing.Aug 20, 2005 · CF-YKO · Substantial damageNTSB SEA05LA099Accident · No injuriesLimited investigationFinal reportHorvath Pitts S-1C · Creswell, ORLoss of engine power as a result of a carburetor float drop restriction during cruise flight. Tall grass in the landing area was a factor in the accident.May 14, 2005 · N81PU · Substantial damageNTSB SEA05FA090Accident · 1 fatalField investigationFinal reportCessna 170B · Portland, ORThe pilot's inability to control the airplane due to his incapacitation (carbon monoxide poisoning) from a deteriorated engine exhaust muffler. A contributing factor was the inadequate annual inspection by other maintenance personnel.May 1, 2005 · N6352Y · DestroyedNTSB SEA05LA067Accident · 2 fatalLimited investigationFinal reportHoover Challenger II STD · La Grande, ORThe pilot's VFR flight into IMC and his failure to maintain clearance with terrain during cruise flight. Factors were the existing weather conditions that included low ceilings, snow, obscuration, and the mountainous, rising terrain.Mar 26, 2005 · N4018G · DestroyedNTSB SEA05CA060Accident · No injuriesData collectionFinal reportBirtch Kitfox II · Dillard, ORThe pilot's failure to maintain clearance from obstacles while in cruise flight at low altitude, which resulted in an inflight collision with a power line. A factor was the pilot's decision to fly at low altitude.Mar 11, 2005 · N481DB · Substantial damageNTSB SEA05LA058Accident · Minor injuriesLimited investigationFinal reportRotorway Exec 162F · Coos Bay, ORThe disintegration, for undetermined reasons, of the upper main drive pulley assembly bearing, while in cruise flight, leading to the decoupling of the main rotor drive assembly from the engine drive assembly. Factors include the absence of any suitable…Mar 10, 2005 · N20539 · DestroyedNTSB SEA05LA049Accident · No injuriesLimited investigationFinal reportMooney M20K · Roseburg, ORA fractured piston pin that resulted in a loss of engine power and subsequent forced landing. Factors include rough/uneven mountainous terrain.Feb 16, 2005 · N1147D · Substantial damage