NTSB investigations
18,851 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 LAX00LA331Accident · 2 fatalLimited investigationFinal reportE. J. Humphrey Christen Eagle II · Lake Elsinore, CAThe pilot's failure to maintain clearance from ground obstacles that resulted in an in-flight collision with a tree, while intentionally maneuvering at a low altitude, and the pilot's inattentive visual lookout.NTSB ATL00LA087Accident · No injuriesLimited investigationFinal reportGrumman G164A · Dillon, SCA total loss of engine power due to a cracked cylinder head. A factor was the emergency landing into unsuitable terrain, and the subsequent nose over.NTSB CHI00FA288Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Custer, SDThe pilot not maintaining clearance from the tree. Factors relating to this accident were the pilot's inadequate preflight planning and preparation, the high density altitude, the inadequate rate of climb, the pilot's improper in-flight decision to fly into…NTSB MIA00GA264Accident · 2 fatalFinal reportBell UH-1H · Waynesville, NCAn in-flight encounter with ground level fog due to the pilot's decision to continue VMC flight into instrument conditions, resulting in an in-flight collision with trees.NTSB FTW00LA253Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Erick, OKthe loss of engine power for undetermined reasons while maneuvering. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA257Accident · No injuriesLimited investigationFinal reportAir Tractor 402B · Segraves, TXThe pilot's failure to maintain clearance with the irrigation system. A factor was the whirlwind weather condition.NTSB FTW00LA250Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Farwell, TXThe loss of engine power for undetermined reasons. Factors were the smoke in the cockpit, and the lack of suitable terrain for the forced landing.NTSB FTW00LA254Accident · No injuriesLimited investigationFinal reportAbernathy Streaker · Sherman, TXThe failure of the wing skin and the rear spar while performing aerobatics, which resulted in the restricted movement of the aileron.NTSB MIA00FA260Accident · 1 fatalField investigationFinal reportBeech B-95 · Odessa, FLthe pilot's failure to maintain Vmc, which resulted in a loss of control, and collision with the ground. Contributing to the accident was the pilot's decision to feather a propeller powered by an operational engine, while at a low altitude.NTSB DEN00LA163Accident · 2 fatalLimited investigationFinal reportNicholson Thorp T-18CWS · Tooele, UTFailure by the pilot to maintain control of the airplane during aerobatic maneuvers as a result of his alcohol impairment. Factors were: The pilot's inadequate planning and decision making and the inadequate altitude he choose for maneuvering.NTSB DEN00FA164Accident · 2 fatalField investigationFinal reportNorth American SNJ-5 · Steamboat Spg, COthe pilot's inadvertent entry into a spin while performing aerobatics.NTSB MIA00LA257Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Canton, MSThe pilot's inadequate visual lookout which resulted in the helicopter colliding with power lines, catching fire, and being consumed by fire after landing.NTSB CHI00LA279Accident · 1 fatalLimited investigationFinal reportMockler Zodiac CH-600 · Carmel, INthe pilot not maintaining altitude/clearance from the tower. A factor was the tower.NTSB MIA00LA256Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Furman, SCThe pilot's failure to ensure the aircraft contained adequate fuel to complete the flight resulting in loss of engine power due to fuel exhaustion and damage to the aircraft during the subsequent forced landing.NTSB CHI00LA277Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Spring Brook, WIA fatigue failure of the tail rotor drive gear shaft.NTSB LAX00LA326Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Salinas, CAThe pilot's inadequate visual surveillance of the worksite to see and avoid power transmission wires.NTSB LAX00FA319Accident · 2 fatalField investigationFinal reportCessna 150L · Laton, CAfailure of the pilot to maintain an adequate airspeed while maneuvering, resulting in a stall at an altitude too low to allow recovery.NTSB LAX00LA315Accident · No injuriesLimited investigationFinal reportPitts S1S · Westminister, CAThe pilot of the Pitts misjudged the clearance while maneuvering under the Cessna.NTSB FTW00LA246Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Eudora, ARthe pilot's failure to maintain obstacle clearance while maneuvering.NTSB MIA00LA252Accident · 1 fatalLimited investigationFinal reportPitts S1-T · Vero Beach, FLthe pilot's failure to maintain control in flight, which resulted in an uncontrolled descent, and collision with the ground.NTSB LAX00LA311Accident · No injuriesLimited investigationFinal reportPerrucci Randall J Revolution MINI-500 · Gridley, CAThe fracture and separation of a control rod in the cyclic flight control system.NTSB CHI00LA271Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Superior, NEthe cracked number 7 cylinder exhaust valve. A factor relating to this accident was the tree.NTSB MIA00LA245Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Berlin, GAthe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall and collision with terrain.NTSB FTW00LA237Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Ennis, TXThe loss of engine power due to fuel starvation, which resulted from the pilot's improper fuel selector positioning.NTSB FTW00FA236Accident · 1 fatalField investigationFinal reportCessna 150 · Collinsville, OKthe pilot's failure to maintain control of the aircraft while maneuvering after takeoff, which resulted in an inadvertent stall/spin and impact with terrain.NTSB FTW00FA235Accident · 4 fatalField investigationFinal reportGulfstream American AA-5B · Barrett, TXthe pilot's failure to maintain aircraft control while maneuvering, which resulted in an inadvertent stall. A contributing factor was the loss of engine power for undetermined reasons.NTSB MIA00LA241Accident · 1 fatalLimited investigationFinal reportBurgess AIR Command · Punta Gorda, FLThe pilot's failure to maintain aircraft control while performing aerobatic flight resulting in an in-flight loss of control, inadvertent stall, and subsequent in-flight collision with power lines, fence, and terrain. Contributing to the accident was the…NTSB CHI00LA258Accident · No injuriesLimited investigationFinal reportBeech K35 · Holland, MIthe misjudged glidepath by the pilot. Factors to the accident were the loose throttle cable due to improper installation by maintenance personnel, and the intentional engine shutdown during the precautionary landing by the pilot.NTSB ANC00LA100Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Arctic Village, AKThe pilot's inadequate compensation for wind conditions, resulting in an inadvertent stall. A factor in the accident was the gusty winds.NTSB FTW00LA232Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Helena, ARthe pilot's failure to maintain obstacle clearance. A contributing factor was the sun glare.NTSB CHI00LA257Accident · 1 fatalLimited investigationFinal reportAyres S2R-600 · Bad Axe, MIThe inadvertent stall/spin encountered by the pilot. A factor was the low altitude.NTSB SEA00LA158Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235 · Paulina, ORThe pilot's failure to maintain an airspeed above stalling speed (Vs), which resulted in a stall/mush into the terrain. Factors include mountainous/hilly terrain, tall trees, a high density altitude, and the pilot's diverted attention as he attempted to keep…NTSB LAX00GA297Accident · 1 fatalFinal reportBell 412 · Cold Springs, NVfailure of the compressor turbine disc due to cyclic fatigue brought about by repeated operation near or above the engines' temperature/power limits by company personnel over an extended period of time. Factors in the accident were: 1) the high density…NTSB NYC00LA230Accident · No injuriesLimited investigationFinal reportRedsell Windrose · Marion, OHThe pilot's failure to maintain control of the glider. Factors in this accident were the strong crosswinds, and thermals, which existed during the flight.NTSB SEA00LA160Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802F · Salmon River, IDCompressor turbine blade failure due to high-cycle fatigue initiating in the surface of the fir-tree root. Factors include unsuitable terrain for an emergency landing.NTSB ATL00TA080Accident · No injuriesFinal reportBell OH-58C · Tampa, FLThe pilot's improper use of flight controls that resulted in low rotor induced oscillation during a practice autorotation.NTSB ATL00LA076Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Manteo, NCThe pilot's failure of preflight planning preparation, which resulted in the fuel exhaustion, and the subsequent loss of engine power.NTSB MIA00LA233Accident · No injuriesLimited investigationFinal reportCessna 188B · Washington, NCa loss of engine power for undetermined reason, resulting in a forced landing, and subsequent impact with a ditch.NTSB NYC00LA220Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Westhampton, NYThe pilot's inadequate flare during the landing. Factors were the entanglement of the tow rope with the rudder horn, and restricted rudder movement.NTSB LAX00GA286Accident · 1 fatalFinal reportBell 206L-1 · Montello, NVThe loss of control in hovering flight and impact with terrain for undetermined reasons.NTSB CHI00LA239Accident · Minor injuriesLimited investigationFinal reportKollier Pitts S1C · Salem, INThe pilot failed to maintain control of the airplane during an intentional inverted flat spin and the initial control inputs he used in an attempt to recover were improper. A factor associated with the accident was the pilot became disoriented during the…NTSB ATL00LA078Accident · 1 fatalLimited investigationFinal reportSolo Wings Aquilla · Chatsworth, GAThe pilot's failure to maintain clearance from trees while maneuvering that resulted in the collision with trees and the ground.NTSB CHI00FA234Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Beloit, KSthe inadvertent stall. Factors relating to the accident were the pilot's low altitude, his abrupt pull up, the power lines, and his lack of recent flying experience.NTSB LAX00LA285Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Tracy, CAThe pilot's failure to maintain adequate clearance from obstacles while maneuvering during an aerial application flight.NTSB SEA00LA148Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Brockway, MTThe pilot's failure to maintain clearance from power lines.NTSB SEA00LA144Accident · Serious injuriesLimited investigationFinal reportEiriavion PIK 20E · Hamilton, MTThe pilot's entering an inadvertent stall condition during a high angle of bank turn (maneuvering), and the lack of adequate altitude in which to successfully recover before ground impact.NTSB CHI00LA224Accident · Minor injuriesLimited investigationFinal reportBohner Pitts Model 12 · Neosho, MOThe unsuitable terrain the pilot selected during his emergency landing. Factors were the hay rolls and the loss of engine power for undetermined reasons.NTSB MIA00LA228Accident · 1 fatalLimited investigationFinal reportQuicksilver MXL II Sport · Clyo, GAThe failure of the pilot to maintain control of the aircraft due to impairment by use of drugs, and the resultant uncontrolled descent and in-flight collision with the terrain.NTSB IAD00LA065Accident · Serious injuriesLimited investigationFinal reportRotorway Exec 90 · Circleville, OHPilot's improper decision to depart a confined area with two people onboard, which resulted in a loss of rotor RPM and collision with a utility pole and wires.NTSB NYC00LA208Accident · No injuriesLimited investigationFinal reportSchreder HP-11-A · Dansville, NYThe pilot's improper in-flight decision to continue the flight with an unfavorable wind. A factor related to the accident was the loss of thermal lift.