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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB SEA00IA019Incident · No injuriesIncident investigationFinal reportBoeing 737-400 · Portland, ORArcing in the electrical system wiring for undetermined reasons.NTSB SEA99LA161Accident · No injuriesLimited investigationFinal reportWild Goose A1 · Keizer, ORA loose fuel line fitting resulted in a loss of engine power. An intentional wheels down landing was a factor.NTSB SEA99FA152Accident · 3 fatalField investigationFinal reportCessna T210M · Marcola, ORThe pilot's failure to maintain clearance from the terrain while descending in an area of deteriorating weather. Factors include mountainous terrain, clouds, low ceilings, the pilot's inadequate preflight weather analysis, and his improper decision to attempt…NTSB SEA99LA109Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Cottage Grove, ORThe pilot's inadequate management of fuel which led to fuel starvation.. A related factor was the unsuitable terrain.NTSB SEA99LA108Accident · Serious injuriesLimited investigationFinal reportWilliamson/Williamson RV-4 · Coos Bay, ORInadequate aircraft preflight inspection (engine air inlet cover not removed) by the pilot, resulting in obstruction of the carburetor air inlet in flight and consequent inflight engine stoppage. Factors contributing to the accident included a vehicle…NTSB SEA99LA058Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Detroit, ORThe pilot's inadvertent visual flight rules flight into instrument meteorological conditions, eventually resulting in a non-mechanical loss of engine power. Factors were: the pilot's inadequate preflight planning and preparation; a snowstorm with icing…NTSB SEA98LA177Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Spray, ORA partial loss of engine power, and the pilot's subsequent misjudgment of clearance with a transmission wire during a precautionary landing approach. The reason for the power loss was not determined; however, the pilot reported that it was not of a mechanical…NTSB SEA98LA163Accident · No injuriesLimited investigationFinal reportSix/Huber RV-6 · Roseburg, ORA total loss of engine power for undetermined reasons.NTSB SEA98LA154Accident · 1 fatalLimited investigationFinal reportCessna 172 · Baker City, ORThe pilot's failure to maintain terrain clearance and inadequate in-flight planning/decision. Contributing to the accident was mountain obscuration.NTSB SEA98TA152Accident · Minor injuriesFinal reportCessna TU206G · Burns, ORFatigue failure of the crankshaft.NTSB SEA98LA135Accident · No injuriesLimited investigationFinal reportCessna 152 · Miltonfreewater, ORThe pilots failure to maintain proper terrain clearance. Factors contributing to the accident are high density altitude and rising terrain.NTSB SEA98LA103Accident · No injuriesLimited investigationFinal reportCasa BU-131 · Harrisburg, ORA failed bracket attaching the throttle linkage, which resulted in the inability to control power, and unsuitable terrain for a successful forced landing. Factors include soft terrain with high vegetation.NTSB SEA98LA099Accident · Minor injuriesLimited investigationFinal reportCessna T210M · La Pine, ORFuel starvation for undetermined reasons.NTSB SEA98LA065Accident · No injuriesLimited investigationFinal reportKaman K-1200 · La Grande, ORThe pilot's inadvertent shutdown of the engine with the FUEL/OIL shutoff switch. Contributing to the accident were: the manufacturer's inadequate location and design of the FUEL/OIL shutoff switch; the FAA's inadequate determination of the type design's…NTSB SEA98IA044Incident · No injuriesIncident investigationFinal reportMooney M20K · Klamath Falls, ORThe pilot's inadequate preflight which failed to detect water contaminated fuel that subsequently led to fuel icing at altitude, blockage of fuel lines which resulted in fuel starvation. A related factor was the dark night conditions.NTSB SEA98LA028Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Sutherlin, ORLoss of engine power for an undetermined reason.NTSB SEA98LA017Accident · Minor injuriesLimited investigationFinal reportBell TH-1L · Canby, ORThe pilot's allowance of excessive airspeed resulting in the long-line hook impacting the tail rotor, and his allowance of an airspeed bleed-off preventing a successful run-on landing due to a loss of yaw control.NTSB SEA98LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Eugene, ORthe pilot's failure to refuel which subsequently led to fuel exhaustion.NTSB SEA98LA008Accident · 1 fatalLimited investigationFinal reportBeckham RV-4 · Scio, ORThe pilot-in-command's loss of control of the aircraft for undetermined reasons.NTSB SEA98LA007Accident · 2 fatalLimited investigationFinal reportCessna 185A · Damascus, ORfailure of the pilot to maintain sufficient altitude/clearance from terrain. Factors relating to the accident included: darkness, and hilly/mountainous terrain.NTSB SEA97LA216Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Creswell, ORThe pilot's improper fuel management in which the fuel selector was positioned on tank with inadequate fuel resulting in fuel starvation. Also causal was the pilot's failure to perform the pilot operating handbook 'engine failure in flight' procedure. A…NTSB SEA97LA210Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · The Dalles, ORthe pilot-in-command(CFI)'s failure to refuel which subsequently led to fuel exhaustion.NTSB SEA97LA198Accident · Serious injuriesLimited investigationFinal reportGarlick UH-1B · Dayville, ORImproper installation of the transmission door by a company mechanic, resulting in inflight separation of the door (which then struck the tail rotor system) and consequent total loss of the tail rotor. Contributing to the accident were: inadequate…NTSB SEA97LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Sweet Home, ORThe pilot's inadequate preflight preparation and his inadequate inflight planning which resulted in fuel exhaustion. A factor was lack of suitable terrain for a forced landing.NTSB SEA97FA120Accident · 2 fatalField investigationFinal reportPiper PA-32-301T · Bend, OROverload of the airframe structure. Thunderstorms and turbulence were factors.NTSB SEA97LA069Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5A · North Bend, ORThe pilot's failure to perform the proper remedial action of applying carburetor heat/alternate induction air after impact ice accumulated on his aircraft's induction air filter. Factors include intentional flight into known adverse weather (icing…NTSB SEA97LA063Accident · No injuriesLimited investigationFinal reportMaule M-5-180 · Jordan Valley, ORfailure of the pilot to maintain directional control of the aircraft, while landing. Factors relating to the accident included: the pilot's improper inflight decision to attempt a descent through what appeared to be a hole in the clouds, his inadvertent…NTSB SEA97LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Sun River, ORinadvertent VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain altitude/clearance above moutainous/wooded terrain. Factors relating to the accident were: darkness, adverse weather conditions, and the proximity…NTSB SEA97LA002Accident · No injuriesLimited investigationFinal reportRockwell S2R · Glide, ORfailure of the pilot to perform an adequate preflight inspection, which led to fuel exhaustion and subsequent loss of power. Factors relating to the accident were: false indications of cockpit fuel gauges and unsuitable terrain for a forced landing.NTSB SEA97FA001Accident · 3 fatalField investigationFinal reportBoeing Vertol BV-107 II · Canby, ORfailure of maintenance personnel to install a cotter pin in a clevis bolt in the flight control system, which resulted in the aft directional and lateral control output pushrod to become disconnected from a bellcrank in the forward portion of the first stage…NTSB SEA96LA223Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Paisley, ORTotal loss of engine power secondary to geartrain failure.NTSB SEA96TA192Accident · No injuriesFinal reportBell UH-1H · Pendleton, ORundetermined malfunction/failure of a flight control or hydraulic system. Rough terrain in the emergency landing area was a related factor.NTSB SEA96LA148Accident · Serious injuriesLimited investigationFinal reportMooney M18LA · Beaver Marsh, ORthe loss of engine power for undetermined reason(s). A factor relating to the accident was: the presence of trees near the forced landing area.NTSB SEA96LA106Accident · No injuriesLimited investigationFinal reportHughes 369HS · Arock, ORthe pilot's failure to see and avoid the transmission wire. A factor was the low altitude flight.NTSB SEA96IA074Incident · No injuriesIncident investigationFinal reportDornier DO 328-100 · Eugene, ORdelamination of the wing de-icing boot, due to the boot reaching its life limit.NTSB SEA96FA061Accident · 1 fatalField investigationFinal reportCessna 402B · Estacada, ORloss of aircraft control for undetermined reason(s).NTSB SEA96FA031Accident · 1 fatalField investigationFinal reportCessna T210M · Netarts, ORa loss of control for undetermined reasons.NTSB SEA96LA026Accident · Serious injuriesLimited investigationFinal reportBoeing 737-522 · Portland, ORAn unexpected encounter with unforecast moderate high level windshear and turbulence as the flight attendant was performing his duties during descent.NTSB SEA96LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Mulino, ORthe failure of the pilots to use carburetor heat during a reduced power descent. A factor was the carburetor icing conditions.NTSB SEA95LA186Accident · No injuriesLimited investigationFinal reportBeech P-35 · Bend, ORseizure of the #4 connecting rod bearing due to overtemperature resulting in the separation of the connecting rod and total loss of engine power. A factor contributing to the accident was the lack of suitable terrain for a forced landing.NTSB SEA95FA111Accident · 3 fatalField investigationFinal reportAero Commander 680 · North Bend, ORThe pilot initiating flight into weather conditions beyond what he was capable of handling. The pilot's overconfidence in his personal ability and the low ceiling were factors in the accident.NTSB SEA95LA081Accident · No injuriesLimited investigationFinal reportCessna 180D · Nyssa, ORFuel exhaustion due to the pilot's failure to refuel en route.NTSB SEA95LA060Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Albany, ORThe pilot's failure to use carburetor heat. Factors include icing conditions and the dark night light conditions.NTSB SEA95LA040Accident · No injuriesLimited investigationFinal reportCessna A185E · Hillsboro, ORA loss of engine power for undetermined reasons.NTSB SEA95FA018Accident · 1 fatalField investigationFinal reportCessna 172N · Klamath Falls, ORThe VFR pilot's attempt to continue the flight into instrument meteorological conditions, and his failure to maintain altitude/clearance with the mountainous terrain below him. Contributing to the accident was a downdraft.NTSB SEA95LA007Accident · Minor injuriesLimited investigationFinal reportBony MB-1 · Madras, ORThe jamming of the rudder during due to undetermined reasons. Contributing to the accident was the pilot-in-command's failure to maintain adequate flying speed while attempting to take remedial action.NTSB SEA94LA157Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Chiloquin, ORFuel exhaustion due to a false indication on the fuel quantity sensor.NTSB SEA94LA137Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Sweet Home, ORThe pilot delayed using carburetor heat until the engine had already lost power due to ice forming in the carburetor throat. Factors include carburetor icing conditions, and rough/uneven terrain in the field where the forced landing was made.NTSB SEA94LA088Accident · No injuriesLimited investigationFinal reportMikoyan MiG MIG-17T · Aurora, ORFailure of a metal fuel line, resulting in an explosion.NTSB SEA94LA064Accident · Minor injuriesLimited investigationFinal reportHiller-Soloy H-23D · Seaside, ORThe pilot's improper use of flight controls resulting in settling with power.