NTSB investigations, OR
482 cases where the phase of flight was Maneuvering.
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 = 450)
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 = 450)
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 SEA97LA104Accident · 1 fatalLimited investigationFinal reportCessna T188C · Mitchell, ORThe pilot's failure to maintain adequate airspeed while maneuvering, which led to a stall. A factor contributing to the accident was the lack of adequate altitude to effect a successful stall recovery.NTSB SEA97FA094Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Klammath Falls, ORThe pilot's failure to set the throttle of his second failed engine to 'Cracked-1/2-Open' as called for in the Engine Failure/Restart checklist, followed by a high-power engine surge. Factors include the pilot's delay in landing for refueling, the pilot…NTSB SEA97LA074Accident · Minor injuriesLimited investigationFinal reportWeatherly 620B · Wasco, ORthe partial loss of engine power for undetermined reasons and the pilot's selection of unsuitable terrain for a precautionary landing. A factor was the rough terrain.NTSB SEA97LA072Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Glide, ORfailure of the pilot to maintain clearance from a power transmission line. Factors relating to the accident included ambient light conditions, which made the power line hard to see.NTSB SEA97LA065Accident · No injuriesLimited investigationFinal reportHughes 269C · Hood River, ORThe pilot-in-command's misjudgment of altitude and airspeed during a turn.NTSB SEA97LA059Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Madras, ORThe pilot's inadvertent visual flight rules (VFR) flight into instrument meteorological conditions (IMC). Factors include the pilot's improper decision to fly under a low ceiling while in mountainous/hilly terrain, and his encounter with fog and low clouds…NTSB SEA97FA049Accident · 2 fatalField investigationFinal reportChampion 7-GCBC · Creswell, ORthe pilot exceeded the design stress limits of the aircraft, while recovering from a spin, which resulted in failure and separation of the right wing tip and adjacent wing fabric (skin).NTSB SEA97LA047Accident · No injuriesLimited investigationFinal reportBarriger RV-6 · The Dalles, ORThe pilot's failure to maintain clearance from a powerline during an intentional low altitude maneuver.NTSB SEA97FA037Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Eagle Point, ORThe failure of the first pilot (flight instructor) to initiate proper aircraft control, and his failure to perform the adequate remedial action to recover from an intentional inverted spin.NTSB SEA97LA035Accident · 2 fatalLimited investigationFinal reportBell 47G · Pendleton, ORThe pilot-in-command's attempt to conduct visual flight into instrument meteorological conditions, and his failure to maintain altitude/clearance with hilly terrain. A contributing factor in the accident was the presence of fog.NTSB SEA97LA029Accident · Serious injuriesLimited investigationFinal reportBell 206B3 · Ballston, ORa loss of control for undetermined reasons.NTSB SEA97FA027Accident · 1 fatalField investigationFinal reportCessna P210N · Boring, ORThe pilot's attempt to conduct visual flight into instrument meteorological conditions. A factor contributing to the accident was the presence of thick fog.NTSB SEA97LA022Accident · 1 fatalLimited investigationFinal reportCollier Q200 · Estacada, ORinadequate maintenance adjustment by the owner/pilot/mechanic, by not using safety wire to secure the throttle arm clamping screw, which resulted in a loose clamping screw and rotation of the throttle arm with respect to the butterfly valve shaft. The lack of…NTSB SEA97LA011Accident · 2 fatalLimited investigationFinal reportAero Vodochody Aero. Works L-29 · Tillamook, ORfailure of the pilot to maintain control of the aircraft, while maneuvering behind an F4F aircraft. The lack of altitude for a recovery was a related factor.NTSB SEA96LA211Accident · No injuriesLimited investigationFinal reportCessna 172M · Pacific City, ORthe pilot's failure to see-and-avoid the transmission line. Factors relating to the accident were: the pilot's low altitude flight, and the transmission line.NTSB SEA96LA188Accident · Minor injuriesLimited investigationFinal reportJonas Exec 90 · Hermiston, ORslippage of the drive belts, while hover taxiing in ground effect, which resulted in loss of power to the rotor system; and inadequate remedial action by the pilot, which led to a roll over during touch down (forced landing). A factor relating to the accident…NTSB SEA96LA167Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Cornelius, ORthe pilot's inadequate preflight planning, and his failure to see-and-avoid the obstruction (inadequate visual lookout). The transmission wire was a related factor.NTSB SEA96LA144Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Mcminnville, ORimproper maintenance (replacement) and inspection of the engine fuel governor by company maintenance personnel, the pilot's inadequate preflight inspection, and a subsequent disconnect of the adjustable governor lever control rod, which disabled the engine…NTSB SEA96LA093Accident · Serious injuriesLimited investigationFinal reportCrescenzi Kitfox · Terrebonne, ORThe pilot's inadequate compensation for wind conditions and failure to maintain altitude/clearance above terrain, while maneuvering to land. The unfavorable wind was a related factor.NTSB SEA96LA070Accident · Minor injuriesLimited investigationFinal reportBell 206B · La Grande, ORthe pilot's failure to maintain clearance with trees after pulling up from an aerial application spray run.NTSB SEA96TA046Accident · Minor injuriesFinal reportChristen Industries A-1 · Lakeview, ORfailure of the pilot to maintain altitude/clearance from the terrain (snow covered, frozen lake). Factors relating to the accident were: the pilot's attention being diverted to a perceived safety hazard, and lack of visual cues for pilot perception of…NTSB SEA96LA025Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Scotts Mills, ORThe pilot's failure to maintain adequate clearance from the ground.NTSB SEA96LA020Accident · No injuriesLimited investigationFinal reportSnow S2C · Dufer, ORA loss of engine power due to a cracked cylinder head. A factor was the evasive maneuver to avoid a ditch.NTSB SEA96LA005Accident · 1 fatalLimited investigationFinal reportChard RV-3A · Forest Grove, ORThe pilot exceeded the design stress limit of the aircraft, followed by the failure of the right wing main spar.NTSB SEA95LA224Accident · 1 fatalLimited investigationFinal reportMacphee Vans RV-6 · Jacksonville, ORthe pilot-in-command's failure to maintain altitude and/or clearance from surrounding terrain after a low pass. The mountainous terrain was a factor.NTSB SEA95LA223Accident · 2 fatalLimited investigationFinal reportEurocopter AS350BA · Crater Lake, ORFailure of the pilot to maintain sufficient altitude/clearance above water, while performing low altitude flight. Factors relating to the accident were: the glassy water condition, and lack of visual cues concerning perception of altitude.NTSB SEA95LA211Accident · 2 fatalLimited investigationFinal reportGift Challenger II · Scappoose, ORFailure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in a stall/spin. Although the aircraft recovery parachute had been activated, there was not enough time (or altitude) for it to fully deploy.NTSB SEA95LA208Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Salem, ORA loss of power for undetermined reasons and the pilot's failure to maintain airspeed while maneuvering for a forced landing.NTSB SEA95LA191Accident · No injuriesLimited investigationFinal reportSchweizer G-164 · Nyssa, ORthe pilot's inadequate ground reconnaissance.NTSB SEA95LA167Accident · 1 fatalLimited investigationFinal reportPederson Silhouette 1 · Corvallis, ORThe pilot's failure to maintain control of the aircraft. A factor in the accident was the pilot performing aerobatics at an altitude inadequate for safe recovery.NTSB SEA95LA157Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Lakeview, ORthe pilot's failure to maintain clearance with terrain while his attention was directed to reading his map. The pilot's intentional low-altitude operation of the aircraft contributed to the accident.NTSB SEA95LA132Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Meachem, ORThe pilot-in-command's failure to maintain clearance from the surrounding terrain. A factor was the mountainous/hilly terrain condition.NTSB SEA95FA128Accident · 2 fatalField investigationFinal reportLuscombe 8A · Hubbard, ORThe failure of the maintenance personnel who rebuilt the aircraft to properly install the wing lower lift strut attachment bolts. Contributing to the accident was the failure of another maintenance person to adequately inspect the aircraft for properly…NTSB SEA95LA118Accident · No injuriesLimited investigationFinal reportEnstrom 280C · The Dalles, ORA partial loss of engine power due to one set of ignition points becoming loose during flight. Factors included the low altitude flight and maneuvering required to conduct the operation and the resulting lack of suitable terrain for a forced landing.NTSB SEA95LA110Accident · 1 fatalLimited investigationFinal reportGarlick TH-1L · Umpqua, ORThe pilot's failure to maintain clearance with a tree, resulting in a tail rotor blade strike on the tree which disabled the tail rotor. Contributing to the accident was the 150-foot-high rock bluff.NTSB SEA95LA105Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Hillsboro, ORThe student pilot's failure to maintain directional control while hovering, which resulted in the aircraft colliding with terrain. Contributing to the accident were gusting wind conditions.NTSB SEA95LA094Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Stayton, ORA power loss for undetermined reason(s). A factor was the soft terrain.NTSB SEA95FA064Accident · 1 fatalField investigationFinal reportMcDonnell Douglas 369E · Lakecreek, ORThe pilot's failure to maintain adequate clearance from the surrounding terrain. A factor was the transmission lines.NTSB SEA95LA053Accident · 2 fatalLimited investigationFinal reportBruce Tifft Varieze · Tiller, ORThe pilot's failure to maintain clearance from trees.NTSB SEA95LA023Accident · Serious injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Yamhill, ORFailure of the pilot to maintain adequate altitude/clearance, while maneuvering to a hover, which allowed the external load cable/hook to become snagged and to rebound into the path of the main rotor blades.NTSB SEA94FA247Accident · 1 fatalField investigationFinal reportCessna 150J · Roseburg, ORthe pilot's failure to maintain clearance from the terrain.NTSB SEA94FA208Accident · 2 fatalField investigationFinal reportPiper PA-22 · Butte Falls, ORThe pilot-in-command's failure to maintain adequate altitude and clearance from trees while maneuvering.NTSB SEA94FA194Accident · 2 fatalField investigationFinal reportHughes 369HS · Seaside, ORInflight collision with terrain for undetermined reasons.NTSB SEA94LA179Accident · Serious injuriesLimited investigationFinal reportKaman HH43F · John Day, ORFailure of a turbine compressor wheel. The lack of suitable terrain for an autorotation/forced landing was a factor.NTSB SEA94LA183Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Pilot Rock, ORDirectional control was not maintained for undetermined reasons.NTSB SEA94LA171Accident · No injuriesLimited investigationFinal reportRobinson R-22M · Portland, ORTail rotor gearbox failure due to inadequate assembly and inspection procedures by the manufacturer.NTSB SEA94LA156Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G-109B · Bend, ORThe pilot's impairment of judgment and performance due to drugs, which led to his failure to maintain control of the aircraft.NTSB SEA94LA138Accident · No injuriesLimited investigationFinal reportSiai-Marchetti SF.260B · Prospect, ORThe fracture of a connecting rod. Factors include no suitable forced landing site, and a fence and irrigation system in the field where the forced landing took place.NTSB SEA94LA109Accident · Minor injuriesLimited investigationFinal reportBell 206B · Summerville, ORThe pilot did not maintain clearance from the wires. The overcast sky condiiton was a factor.NTSB SEA94FA100Accident · 2 fatalField investigationFinal reportCessna 182Q · The Dalles, ORAn inflight loss of control for undetermined reasons.