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 SEA05CA045Accident · Minor injuriesData collectionFinal reportCessna 182G · Redmond, ORThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. Trees were factors.Feb 4, 2005 · N3127S · Substantial damageNTSB SEA05FA038Accident · 3 fatalField investigationFinal reportCirrus SR22 · Hood River, ORThe pilot's failure to maintain terrain clearance. Contributing factors were the mountainous terrain, the low ceiling weather conditions, and dark night light conditions.Jan 21, 2005 · N6057M · DestroyedNTSB SEA04LA181Accident · No injuriesLimited investigationFinal reportHughes 369D · Cottage Grove, ORIn-flight loss of engine power during cruise for undetermined reasons.Sep 4, 2004 · N505ST · Substantial damageNTSB SEA04CA107Accident · No injuriesData collectionFinal reportSteward Rocky 162F · Hood River, ORThe pilot's miscalculation of fuel consumption and his inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor was the high vegetation.Jun 16, 2004 · N717CS · Substantial damageNTSB SEA04LA100Accident · 1 fatalLimited investigationFinal reportGann Glasair II-S RG · Baker City, ORThe pilot's inadequate in-flight planning/decision and his failure to maintain an airspeed above stall speed (Vs) after encountering airframe icing during cruise flight. Factors include the pilot's intentional continuation of his flight along the planned…Jun 6, 2004 · N711LN · DestroyedNTSB SEA04FA088Accident · 1 fatalField investigationFinal reportCessna A185F · Molalla, ORThe pilot's inadequate in-flight planning/decision which resulted in VFR flight into IMC, and his failure to maintain control. Factors include mountain obscuration, clouds and convective weather conditions.May 19, 2004 · N61611 · DestroyedNTSB SEA04LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Sisters, ORThe loss of engine power for undetermined reasons. Factors include no suitable place for a forced landing, and trees in the area where the pilot found it necessary to attempt the forced landing.Mar 17, 2004 · N2553S · Substantial damageNTSB SEA04FA031Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · Cave Junction, ORBoth the pilot-in-command and the co-pilot allowing the aircraft to enter into an area of adverse weather (icing conditions at low [-20 degrees C] temperatures) resulting in sequential induction icing, induction filter blockage, carburetor icing and the…Jan 2, 2004 · N53505 · Substantial damageNTSB SEA04FA022Accident · 4 fatalField investigationFinal reportBeech S35 · Warren, ORThe vacuum pump failure and the pilot's failure to maintain control of the airplane. Factors contributing to the accident included the instrument meteorological weather conditions and the pilot's improper recovery from the descent.Nov 25, 2003 · N10BX · DestroyedNTSB SEA03LA157Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-24E · Hood River, ORThe pilot's failure to refuel prior to the flight, resulting in fuel exhaustion during the initial climb, followed by the pilot's failure to maintain airspeed. An inadvertent stall was a factor.Jul 28, 2003 · N24YB · Substantial damageNTSB SEA03LA115Accident · No injuriesLimited investigationFinal reportCessna 182C · Bandon, ORLoss of engine power during descent for undetermined reasons.Jun 22, 2003 · N8762T · Substantial damageNTSB SEA03LA082Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Salem, ORLoss of power in cruise flight due to a catastrophic engine failure for undetermined reasons.May 15, 2003 · N2913F · Substantial damageNTSB SEA03LA069Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Bonanza, ORSeparation of the connecting rod cap. Annual maintenance inspections which were disregarded by the owner/pilot was a factor.Apr 23, 2003 · N8159T · Substantial damageNTSB SEA03FA059Accident · 2 fatalField investigationFinal reportCessna T207 A · Merlin, ORThe pilot's failure to maintain clearance from mountainous terrain while in cruise flight. Factors include low ceilings and mountainous terrain.Apr 9, 2003 · N9785M · DestroyedNTSB SEA03FA038Accident · No injuriesField investigationFinal reportBeech A23 · Fort Klamath, ORThe separation of the rod end cap from the connecting rod for an undetermined reason during the descent for landing. The ditch was a factor.Feb 8, 2003 · N2392W · Substantial damageNTSB SEA03LA011Accident · Serious injuriesLimited investigationFinal reportPeterson Dragonfly · Mulino, ORFuel starvation of the engine while in cruise flight due to the owner/builder's alteration of the fuel system from that shown in the aircrafts plans. Factors include very rough terrain in the area where the pilot found it necessary to make his forced landing.Nov 23, 2002 · N2448 · Substantial damageNTSB SEA02FA185Accident · 2 fatalField investigationFinal reportCessna 172S · Medford, ORTerrain clearance was not maintained during cruise flight. Dark night and mountainous terrain were factors.Sep 30, 2002 · N514SP · Substantial damageNTSB SEA02LA184Accident · No injuriesLimited investigationFinal reportCessna 182 · Estacada, ORThe entanglement of an inadvertently opened skydiver's parachute in the aircraft’s elevator and rudder just after a group of four skydivers positioned themselves on the aircraft's external jump platform prior to a jump.Sep 29, 2002 · N5337B · DestroyedNTSB SEA02LA168Accident · Serious injuriesLimited investigationFinal reportNolley BD-5 · Corvallis, ORFuel starvation resulting in a loss of engine power during the aircraft's initial climb. A disconnected fuel line was a factor.Aug 31, 2002 · N50TX · Substantial damageNTSB SEA02LA151Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Creswell, ORThe pilot’s improper management of fuel, which resulted in a loss of engine power due to fuel starvation.Aug 10, 2002 · N32138 · Substantial damageNTSB SEA02LA137Accident · No injuriesLimited investigationFinal reportBell 206B · Elsie, ORThe shattering and separation of the forward right (pilot's) windscreen for undetermined reason(s).Jul 24, 2002 · N60PH · Substantial damageNTSB SEA02LA135Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas 369D · Medford, ORPower loss during cruise flight for undetermined reasons. Factors include mountainous terrain and trees.Jul 22, 2002 · N58295 · Substantial damageNTSB SEA02LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Burns, ORThe pilot’s improper decision to continue on en route into an area of forecast reduced visibility without sufficient fuel to divert to a suitable alternate airport, and his subsequent inadvertent exhaustion of the aircraft's fuel supply. Factors include…Jul 16, 2002 · N1248H · Substantial damageNTSB SEA02FA125Accident · 2 fatalField investigationFinal reportCessna 172N · Otis, ORThe pilot's failure to maintain adequate clearance with power lines while conducting low altitude flight resulting in a loss of control and subsequent collision with terrain. Contributing factors were the pilot's low altitude flight and the power lines.Jul 6, 2002 · N738QT · DestroyedNTSB SEA02LA095Accident · No injuriesLimited investigationFinal reportCessna 441 · Medford, ORThe overstress failure, for undetermined reasons, of the right main landing gear pivot pin roll pin, leading to the misalignment of the gear trunnion and the collapse of the right main gear during the landing roll.Jun 19, 2002 · N564AC · Substantial damageNTSB SEA02FA085Accident · 2 fatalField investigationFinal reportRobinson R-22 Mariner · Merlin, ORClearance from a cable running perpendicular to a river was not maintained during low level cruise flight. A cable was a factor.May 23, 2002 · N2322Y · Substantial damageNTSB SEA02LA073Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Goshen, ORThe failure of company maintenance personnel to identify and replace/repair the degraded exhaust stack. Contributing factors were the mis-rigged carburetor heat control and the pilot's failure to maintain appropriate rotor RPM. Additional contributing factors…Apr 22, 2002 · N3004T · Substantial damageNTSB SEA02LA069Accident · No injuriesLimited investigationFinal reportWoodley Zodiac 601HD · Beaver, ORA partial failure of the electrical (ignition) system and a short to the master electrical switch during cruise flight resulting in a loss of engine power. A collision with an embankment during the landing roll was a factor.Apr 18, 2002 · N9240W · Substantial damageNTSB SEA02LA003Accident · Minor injuriesLimited investigationFinal reportEllsberg One Design · Bend, ORthe separation of a propeller counterweight mounting bracket due to incorrect mounting bolt torque. Factors include significant powerplant vibration during the forced landing, no suitable landing area, and soft terrain next to the narrow road on which the…Oct 6, 2001 · N55TE · Substantial damageNTSB LAX01LA275Accident · Serious injuriesLimited investigationFinal reportBoeing 737-500 · Klamath Falls, ORAn encounter with turbulence from a developing thunderstorm during cruise flight.Aug 9, 2001 · N512SW · No damageNTSB SEA01LA138Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Troutdale, ORthe pilot's inadvertent visual flight rules ( VFR) flight into instrument meteorological conditions (IMC) during cruise flight. Factors include his attention being diverted to the indications presented by his Global Positioning System (GPS), and low ceiling…Jul 21, 2001 · N90077 · DestroyedNTSB SEA01LA109Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Salem, ORLoss of engine power during cruise flight for an undetermined reason. A factor in the accident was tall grass in the landing area.May 31, 2001 · N1389B · Substantial damageNTSB SEA01IA113Incident · No injuriesIncident investigationFinal reportCessna 172S · Monroe, ORA degradation of aircraft control for undetermined reasons.May 31, 2001 · N571SP · No damageNTSB SEA01IA093Incident · No injuriesIncident investigationFinal reportBeech C-99 · Salem, ORA short to electrical wiring while in cruise flight.May 15, 2001 · N992AF · Minor damageNTSB SEA01LA066Accident · Serious injuriesLimited investigationFinal reportMooney M20A · Gresham, ORThe pilot's inadequate decision in which he failed to refuel while en route, resulting in fuel exhaustion and loss of engine power.Mar 21, 2001 · N8346E · Substantial damageNTSB SEA01LA063Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Saint Helens, ORthe pilot's improper use of the carburetor heat while attempting to determine if there was ice accumulating in the carburetor throat. Factors include flight in conditions conducive to carburetor icing, and a fence running across the field in which the forced…Mar 8, 2001 · N6337P · Substantial damageNTSB SEA01LA040Accident · No injuriesLimited investigationFinal reportErcoupe 415G · Santiam, ORThe partial blockage of the carburetor main metering jet orifice by contamination of undetermined origin. Factors include a snow-covered runway upon which the pilot executed a forced landing.Jan 20, 2001 · N94432 · Substantial damageNTSB SEA01FA021Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Ontario, OROverstress loading to the left wing lift strut resulting in the left wing folding upward during the initial climb.Nov 17, 2000 · N3762A · DestroyedNTSB SEA01FA015Accident · 2 fatalField investigationFinal reportCessna 152 · Corvallis, ORThe pilot's failure to maintain clearance from the terrain. Factors include a dark night, densely forested, hilly terrain near the planned route of flight, and low ceilings in the area of the accident.Nov 6, 2000 · N53301 · DestroyedNTSB SEA01LA014Accident · Serious injuriesLimited investigationFinal reportBoeing 767-332ER · Portland, ORAn inflight encounter with turbulence that occurred before flight attendants could finish stowing a beverage cart and return to their seats.Nov 4, 2000 · N173DZ · No damageNTSB SEA00LA194Accident · No injuriesLimited investigationFinal reportCessna 172K · Burns, ORThe separation of a portion of one propeller blade as a result of a fatigue crack that initiated at the site of foreign object damage to the blade.Sep 28, 2000 · N84034 · Substantial damageNTSB SEA00LA166Accident · No injuriesLimited investigationFinal reportFairchild 24G · Cascade Locks, ORThe pilot's failure to apply carburetor heat after experiencing a partial power loss while flying under conditions conducive to the formation of carburetor ice. Factors include the presence of carburetor icing conditions and an expanse of water (Columbia…Aug 18, 2000 · N4714 · Substantial damageNTSB SEA00LA157Accident · No injuriesLimited investigationFinal reportHamer Lancair 235 · Chiloquin, ORLoss of engine power due to a fracture and separation of the engine's crankshaft. A factor was a vehicle on the roadway.Aug 10, 2000 · N84LH · Substantial damageNTSB SEA00LA150Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Oregon City, ORA loss of engine power for undetermined reason(s). A factor was the rough/uneven terrain.Aug 2, 2000 · N1927Y · Substantial damageNTSB SEA00LA146Accident · No injuriesLimited investigationFinal reportJonas Falcon XP · Pendleton, ORA loss of engine power for undetermined reasons. A factor was rough/uneven terrain in the forced landing area.Jul 30, 2000 · N90345 · Substantial damageNTSB SEA00LA143Accident · Serious injuriesLimited investigationFinal reportJim Weseman Challenger II · Chiloquin, ORLoss of engine power for undetermined reasons. Unsuitable terrain and the pilot's failure to maintain aircraft control were factors.Jul 23, 2000 · UNREG · Substantial damageNTSB SEA00FA127Accident · 1 fatalField investigationFinal reportCessna 175 · Molalla, ORFailure to maintain clearance from mountainous/hilly terrain.Jul 8, 2000 · N7625M · DestroyedNTSB SEA00LA121Accident · Serious injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · West Linn, ORImproper maintenance (excessive/improper sealant application) by an unknown person, and subsequent fracture of the spur adapter gearshaft resulting in a total loss of engine power. Factors included foreign material/substance in the engine oil, a blocked oil…Jul 2, 2000 · N2784D · Substantial damageNTSB SEA00LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Hillsboro, ORThe pilot's inability to maintain the correct approach airspeed (Vref) on final due to incorrect airspeed indications resulting from a partial blockage of the pitot line. Factors include a quartering tailwind, a wet runway, and the pilot's decision not to…Jun 9, 2000 · N8321S · Substantial damageNTSB SEA00LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Ashland, ORThe pilot's failure to refuel the airplane, which resulted in a loss of engine power due to fuel exhaustion. Unsuitable terrain for a landing was a contributing factor.Apr 24, 2000 · N55PJ · Substantial damage