NTSB investigations
18,849 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.\"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."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 ERA21FA130Accident · 4 fatalClass 3 · FieldFinal reportBell 206 · St Thomas, CBA total loss of engine power due to fatigue failure of two of the stage 3 compressor blades. Contributing to the failure of the compressor blades was the failure of maintenance personnel to inspect the compressor at the recommended interval for operation in…NTSB GAA21WA035Accident · 3 fatalClass 5 · ForeignCessna 182 · Culiacan, MexicoNTSB GAA21WA024Accident · No injuriesClass 5 · ForeignPiper PA36 · ConceiçãO De Alagoas, BrazilNTSB WPR21LA107Accident · Serious injuriesClass 3 · LimitedFinal reportHughes OH-6A · Horseshoe Bend, IDA partial loss of engine power due to a leak in the fuel cell outlet valve.NTSB ERA21LA126Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Pahokee, FLA loss of main rotor rpm for reasons that could not be determined, which resulted in an autorotation and a subsequent hard landing and rollover.NTSB CEN21LA123Accident · No injuriesClass 4 · LimitedFinal reportPiper J3F-50 · Weidman, MIThe pilot’s failure to maintain clearance from terrain during a low approach over a snow-covered runway. Contributing to the accident was the loss of depth perception due to the bright sunlight and snow.NTSB CEN21LA121Accident · 2 fatalClass 3 · LimitedFinal reportCessna 182Q · Hackberry, LAThe flight instructor did not maintain control of the airplane during training maneuvers, which resulted in a rapid, steep descent and impact with terrain.NTSB CEN21LA119Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Silt, COThe pilot’s failure to avoid powerlines while flying at low altitude.NTSB ERA21LA112Accident · No injuriesClass 3 · LimitedFinal reportCessna U206 · Denton, NCA partial loss of engine power for reasons that could not be determined based on available information.NTSB WPR21LA093Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Queen Creek, AZThe pilot's uncoordinated flight control inputs while entering a hover, which lead to a loss of aircraft control which resulted in the left skid making contact with the ground, causing the helicopter to roll on its side.NTSB CEN21LA113Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-802A · Newellton, LAThe pilot’s failure to maintain clearance from powerlines/poles and terrain while maneuvering for reasons that could not be determined based on available evidence.NTSB ERA21LA104Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · St. Petersburg, FLA total loss of engine power as a result of the loose fuel line B-nut connected to the engine driven fuel pump.NTSB CEN21LA124Accident · No injuriesClass 4 · LimitedFinal reportHiller UH12C · Lafayette, INThe pilot’s failure to maintain control of the helicopter shortly after liftoff into a hover, which resulted in a dynamic rollover when the left landing skid contacted the ground.NTSB CEN21LA102Accident · 1 fatalClass 3 · LimitedFinal reportHughes 369D · Tuckers Crossing, MSThe pilot’s loss of helicopter control when the external saw contacted trees during an attempted emergency landing due to a main rotor transmission oil pressure warning. The reason that the pilot did not release the external saw from the helicopter during the…NTSB ERA21LA088Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Cleveland, GAA total loss of engine power due to carburetor icing.NTSB CEN21LA096Accident · 2 fatalClass 3 · LimitedFinal reportExpress CT · Grand Prairie, TXThe pilot’s loss of airplane control during the departure turn, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN21LA091Accident · 1 fatalClass 3 · LimitedFinal reportExtra Flugzeugproduktions-Und EA 300/L · Aledo, TXThe pilot’s loss of control during an intentional aerobatic maneuver, which resulted in an upright spin into terrain.NTSB ERA21LA071Accident · 1 fatalClass 3 · LimitedFinal reportAnthony Mattioli AR-1 · San Mateo, FLA loss of engine power due to fuel contamination.NTSB ERA21LA068Accident · 1 fatalClass 3 · LimitedFinal reportBeech V35A · Attalla, ALA loss of control inflight and the failure of a component of the up elevator flight control system due to fatigue, which rendered recovery from a right descending turn improbable.NTSB CEN21LA084Accident · 2 fatalClass 3 · LimitedFinal reportRobinson R44 · Colorado City, TXThe pilot’s loss of control and exceedance of performance and/or structural limitations during low-altitude operations, which resulted in an inflight breakup.. Contributing to the accident was the pilot’s impairment from the effects of tetrahydrocannabinol.NTSB CEN21LA077Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Marietta, TXThe pilot’s failure to see and avoid a transmission wire during takeoff.NTSB ERA21LA053Accident · 1 fatalClass 3 · LimitedFinal reportBeech V35 · Deltaville, VAAn uncontrolled descent and impact with terrain following an in-flight collision with seagulls.NTSB ERA21LA046Accident · No injuriesClass 4 · LimitedFinal reportRobinson R44 · Austell, GAThe flight instructor’s failure to maintain adequate clearance above the gravel surface in a hover, which resulted in a dynamic rollover.NTSB GAA21WA173Accident · 2 fatalClass 5 · ForeignPiper PA11 · Open Door, ArgentinaNTSB CEN21LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Johnson City, KSThe pilot’s improper decision to fly the airplane at too low an altitude resulting in the airplane impacting terrain.NTSB WPR21LA058Accident · Minor injuriesClass 3 · LimitedFinal reportAir Creation Tanarg · Pahrump, NVThe pilot’s failure to maintain control while maneuvering at low altitude.NTSB ERA21WA064Accident · Serious injuriesClass 5 · ForeignCessna 188 · Esperanza, Dominican RepublicNTSB WPR21LA061Accident · 1 fatalClass 4 · LimitedFinal reportCessna 172 · Arch Cape, ORThe pilot’s descent into the ocean for reasons that could not be determined.NTSB WPR21LA040Accident · Serious injuriesClass 4 · LimitedFinal reportSchleicher ASW20C · Clayton, CAThe failure of both pilots of each glider to see an avoid one another while maneuvering, which resulted in a mid-air collision.NTSB CEN21LA047Accident · Serious injuriesClass 3 · LimitedFinal reportErcoupe 415 · Ardmore, OKThe pilot’s improper decision to takeoff with 3 persons in a 2-place airplane and over maximum gross weight, and his failure to apply carburetor heat when the airplane’s engine experienced carburetor ice and a partial loss of power.NTSB WPR21WA036Accident · 1 fatalClass 5 · ForeignPiper PA-25-235 · Kirkwood, South AfricaNTSB CEN21FA026Accident · 2 fatalClass 3 · FieldFinal reportGrumman AA5 · Woodbranch, TXThe pilot’s failure to maintain control of the airplane due to spatial disorientation.NTSB ERA21LA028Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Point Lookout, NYThe pilot’s decision to depart on a visual flight rules flight, and to continue that flight into forecasted and deteriorating instrument meteorological conditions (IMC) in a helicopter that was not equipped for flight in IMC, which resulted in the pilot’s…NTSB CEN21LA021Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Washington, WIThe pilot’s failure to maintain lateral control during a hover and improper recovery action after the helicopter contacted the ground, which resulted in a dynamic rollover sequence and an impact with terrain.NTSB WPR21LA021Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson R44 · Pahrump, NVThe pilot’s failure to maintain helicopter control while hovering low over a body a water while facing into the sun, which resulted in a loss of visual reference and subsequent impact with the lake surface.NTSB ERA21LA020Accident · 1 fatalClass 3 · LimitedFinal reportAero Commander 100 · Citra, FLThe student pilot’s inadequate preflight planning likely due to impairment from ethanol, which resulted in a total loss of engine power due to fuel exhaustion. Contributing was his improper decision to depart from an unlit airstrip in dark night conditions.NTSB ERA21LA014Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Rural Hall, NCThe pilot’s failure to maintain airplane control and improper recovery from an unusual attitude, which resulted in an in-flight breakup.NTSB CEN21LA008Accident · 2 fatalClass 3 · LimitedFinal reportStephens William E Quicksilver MXL-2 Sport · Mount Vernon, INThe pilot’s exceedance of the airplane’s critical angle of attack during an aerobatic maneuver, which resulted in an aerodynamic stall and spin and loss of control. Contributing to the accident was the pilot’s decision to perform aerobatic maneuvers in an…NTSB ERA21WA033Accident · 2 fatalClass 3 · ForeignANG 01 · Peremoha, UkraineNTSB CEN21LA050Accident · No injuriesClass 4 · LimitedFinal reportBellanca 1730 · San Saba, TXThe student pilot’s improper decision-making, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR21WA047Accident · Minor injuriesClass 5 · ForeignAir Tractor AT502 · Semera, EthiopiaNTSB WPR21LA008Accident · No injuriesClass 3 · LimitedFinal reportCessna 180 · Princeton, ORThe pilot’s failure to enrichen the mixture, which resulted in a partial loss of engine power.NTSB CEN21LA005Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT402 · Egypt, ARThe pilot’s failure to maintain clearance from a tree limb during a low-level aerial application flight.NTSB ENG20LA046Incident · No injuriesClass 3 · LimitedFinal reportThrush S2R-H80 · Donalsonville, GAA total loss of engine power due to a loose torque meter attachment nut in the reduction gearbox that jammed the planetary gearset causing the power turbine shaft to separate from the power turbine disk, resulting in the power turbine overspeeding and…NTSB ERA20LA335Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Union, SCA total loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s failure to use carburetor heat in conditions conducive to the development of carburetor icing.NTSB CEN20LA430Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46R-350T · Rogers, ARThe pilot’s inadvertent loss of aircraft control, resulting in substantial damage to the airframe during the spin recovery.NTSB GAA20WA149AccidentClass 5 · ForeignCessna 182 · Minas City, UruguayNTSB CEN20LA417Accident · 2 fatalClass 3 · LimitedFinal reportQuicksilver Mxii · Killeen, TXA total loss of engine power due to cold seizure for a reason that could not be determined, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with the ground.NTSB WPR20LA315Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-802A · Emmett, IDThe pilot’s descent below surrounding terrain and his delayed decision to initiate a climb which resulted in impact with terrain. Contributing to the accident were terrain and lighting conditions that affected the pilot’s ability to accurately assess terrain…NTSB ERA20LA330Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA25 · Floral City, FLThe pilot’s failure to see and avoid a tree while flying towards the rising sun during an aerial application flight, which resulted in a collision with the tree and a subsequent loss of airplane control.