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 MKC89LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrensburg, MOThe failure of the CFI to visually acquire and maintain clearance from power lines, which the airplane subsequently contacted.NTSB FTW89DRG06Accident · 1 fatalFinal reportHughes 269C · Rocksprings, TXThe pilot diverted his attention from operation of the helicopter, failed to maintian proper rotor RPM, and failed to maintain altitude (clearance) above the ground, while maneuvering at low altitude. A contributing factor was his impairment from use of a…NTSB SEA89LA088Accident · Serious injuriesLimited investigationFinal reportBell 214B-1 · Ketchikan, AKThe pilot misjudging clearance from trees during a hover descent.NTSB SEA89LA087Accident · Minor injuriesLimited investigationFinal reportBell 206B III · Lewiston, IDThe pilot's improper use of the helicopter's flight controls. Contributing to the accident was the pilot's misjudgement of the external load characteristics.NTSB FTW89DPJ04Accident · Minor injuriesFinal reportFields Rotorway Exec · Oklahoma City, OKThe pilot's failure to maintain proper altitude during the hover taxi.NTSB DEN89DTM02Accident · Serious injuriesFinal reportHiller UH-12E · Mack, COThe pilot's failure to maintain proper altitude during a swath run.NTSB NYC89DNE02Accident · 1 fatalFinal reportSmith Mini DSA-1 · Sterling, CTThe pilot's failure to maintain control of the experimental aircraft while performing aerobatic maneuvers, and the aircraft's resultant uncontrolled descent into the ground.NTSB ATL89DLT03Accident · No injuriesFinal reportBell 47 · Shelbyville, TNFailure in the rotor drive system for unknown reasons. Contributing to the accident was the pilot's inability to perform an autorotation.NTSB MKC89FA107Accident · Serious injuriesField investigationFinal reportCessna 152 · Cottage Grove, MNPoor judgement of the pilot by flying while physically impaired from consumption of alcohol; and his failure to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall and collision with wooded/hilly terrain.NTSB MIA89FA146Accident · 3 fatalField investigationFinal reportPiper PA-44-180 · Fort Pierce, FLInadequate supervision by the instructor pilot (CFI), and failure of the crew to maintain sufficient airspeed, which resulted in an inadvertent stall/spin and subsequent loss of engine power from possible interruption of fuel.NTSB MKC89FA104Accident · 1 fatalField investigationFinal reportCallair A-9 · Hamilton, MOThe pilots failure to maintain control and prevent the airplane from descending while in a turn.NTSB DEN89FA117Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Livingston, MTThe poor judgement displayed by the pilot when he maneuvered the airplane at extremely low altitude over mountainous terrain. During the flight the pilot misjudged the pull-up required and struck trees.NTSB ATL89DMG03Accident · Serious injuriesFinal reportSmithgall Pitts Special S-1C · Fuquay-Varina, NCPilot did not maintain sufficient altitude to insure recovery from an aerobatic maneuver and spin.NTSB LAX89FA181Accident · 2 fatalField investigationFinal reportCessna 152 · Port San Luis, CAPilot failed to execute a 180 degree turn and inadvertently entered into instrument meteorological conditions.NTSB FTW89LA092Accident · No injuriesLimited investigationFinal reportBell 47L · Tulsa, OKInadequate supervision of the student by the instructor in that he allowed the student to overpower his control inputs after an unexpected gust of wind moved the tail of the helicopter.NTSB FTW89FA091Accident · 2 fatalField investigationFinal reportAeronca 11AC · Paradise, TXLoss of engine power for an undetermined reason, and failure of the pilot to maintain sufficient airspeed during the forced landing, which resulted in an inadvertent stall.NTSB FTW89DQA04Accident · 1 fatalFinal reportCessna A188B · Dell City, TXThe pilot's failure to see and/or avoid the powerlines. Contributing factor(s) was: the early morning sunglare.NTSB MIA89GA144Accident · 2 fatalFinal reportDouglas C-47 · Summerland Key, FLThe failure of the pilot-in-command to assure proper altitude and clearance was maintained above the terrain and trees. The trees and light condition at dusk were contributing factors.NTSB CHI89LA082Accident · Minor injuriesLimited investigationFinal reportCessna 320D · Wixom, MIPilot's inattention to the fuel system during preflight and inadequate fuel system monitoring throughout the flight.NTSB SEA89LA076Accident · Minor injuriesLimited investigationFinal reportBell 47G3B2 · Milton-Freewtr, ORImproper planning/decision by the pilot, which resulted in fuel exhaustion from an inadequate supply of fuel.NTSB LAX89DVM02Accident · Minor injuriesFinal reportHiller UH-12E · Salinas, CAThe separation of the torsion coupling in the main rotor drive system.NTSB MKC89FA094Accident · 2 fatalField investigationFinal reportPiper J3C · Ashland, NEPoor judgement of the pilot by flying while physically impaired from alcohol consumption, and his failure to maintain adequate airspeed, while flying over a meandering river, which resulted in a stall. A contributing factor was the pilot's inadequate altitude…NTSB LAX89FA165Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Stockton, CAPoor judgement of the pilot by flying while physically impaired from consumption of alcohol & drugs, and his failure to maintain proper altitude. The light condition (at night) and the obstructions (power lines and building) were considered to be contributing…NTSB MIA89FA132Accident · 1 fatalField investigationFinal reportCoutz Quickie Q-2 · Lake City, FLAircraft control was lost for an unknown reason.NTSB SEA89LA086Accident · No injuriesLimited investigationFinal reportAerospatiale AS-355-F2 · Las Vegas, NVThe pilot's poor inflight decision in selecting an unsuitable area for practice landings and the pilot's inadequate visual lookout resulting in a tail rotor strike and loss of antitorque control.NTSB LAX89LA169Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Bolinas, CAThe pilot's poor preflight planning in that he did not accurately account for the fuel on board the aircraft as a basis for fuel consumption calculations thereby causing the engine to stop producing power because of a lack of fuel. Contributing to the…NTSB MKC89LA089Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Osceola, ARImproper planning/decision by the pilot, and his misjudgement of clearance between the airplane, wires, and the ground during the aerial application maneuver. Factors relating to the accident were: the dirty windshield, sunglare, transmission line (wires),…NTSB NYC89GA116Accident · 2 fatalFinal reportBell 206B · Airville, PAThe pilot was unable to see and avoid the unmarked power lines stretched across the river. A contributing factor was the lack of visual clues.NTSB CHI89FA071Accident · Serious injuriesField investigationFinal reportSikorsky S-58T · Milwaukee, WIDisconnect of the tailrotor drive shaft coupling.NTSB LAX89LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Irwindale, CAImproper procedure used by the certified flight instructor in simulating an engine failure. Contributing to this accident was the lack of total flight instruction experience of the flight instructor.NTSB NYC89LA045Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Gorham, MEFailure of the pilot to maintain adequate airspeed when he diverted his attention during a low pass and allowed the aircraft to enter a stall/spin. The unfavorable wind was a factor.NTSB FTW89DPJ03Accident · No injuriesFinal reportAir Tractor 301 · Jefferson, OKLoss of engine power, due to a cracked number 4 cylinder. A factor related to the accident was: the terrace (dirt bank) in the emergency landing area.NTSB ATL89FA122Accident · 1 fatalField investigationFinal reportCessna 182 · Luthersville, GAPilot's failure to take action that would prevent the formation of carburetor ice. Following the engine malfunction, the pilot did not configure the airplane so as to reduce the severity of the impact, I.e. extend the flaps and slow the airplane. Contributing…NTSB ANC89FA057Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Eklutna, AKThe pilot diverted his attention and failed to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB MKC89DCJ02Accident · 1 fatalFinal reportSchmahl Volksplane VP-1 · Papillion, NEThe pilot failed to maintain the proper climb rate and inadvertently stalled the aircraft which entered an uncontrolled descent into an open field.NTSB ATL89DKG02Accident · Minor injuriesFinal reportCessna A188B · Statesboro, GAImproper inflight planning which allowed the engine to lose power due to fuel exhaustion.NTSB NYC89LA110Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Farmingdale, NYPilot's failure to control the altitude of the helicopter while demonstrating a quick stop maneuver to a student.NTSB MIA89LA117Accident · No injuriesLimited investigationFinal reportLee, David Velocity · Ponte Vedra Bch, FLFailure through an oversight to remove the canard gap seals prior to aggravated stall testing which resulted in the aircraft entering an uncontrollable flight regime.NTSB LAX89LA138Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Mesa, AZInadequate visual lookout by the pilot, and his failure to maintain the proper altitude. Factors related to the accident were: the pilot's lack of visual perception at dusk, the transmission line, and the obstructions (tree & fence) in the emergency landing…NTSB LAX89LA139Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Santa Barbara, CAThe improper inflight planning/decisions by the plt when he decided to intentionally fly low over rough water in the pacific ocean and the partial loss of power for undetermined reasons.NTSB LAX89FA133Accident · 4 fatalField investigationFinal reportMooney M20F · San Andreas, CAInterruption of engine power for an undetermined reason, and failue of the pilot to maintain airspeed, which resulted in a stall/spin. A factor related to the accident was: lack of altitude to recover from the stall/spin.NTSB MKC89LA085Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Advance, MOThe pilot's inadequate visual lookout resulting in his failure to see power lines in time to avoid them. Contributing to the accident was the reduced visibility due to fog.NTSB MIA89FA115Accident · 1 fatalField investigationFinal reportBellanca 7KCAB · Daytona Bch Shr, FLIn-flight loss of control while maneuvering to reverse direction due the failure of the pilot to maintain adequate airspeed during the 'steep turn.'NTSB MKC89FA083Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Mayflower, ARThe pilots failure to maintain airspeed (vs), and inadvertant entry into a stall with necessary remedial action not understood.NTSB DEN89LA090Accident · No injuriesLimited investigationFinal reportBell 222 · Leadville, COFailure of the pilot to compensate adequately for wind conditions with rudder pedals while maneuvering in unfavorable wind and high density altitude.NTSB CHI89FA061Accident · 1 fatalField investigationFinal reportCessna 150M · Corunna, MIThe failure of the student pilot to maintain sufficient altitude to recover from a practice stall maneuver. A factor related to the accident was: the pilot's visual perception over snow covered terrain.NTSB LAX89DVA05Accident · Serious injuriesFinal reportGrumman G-164B · Westley, CAA loss of engine power for undetermined reasons. A factor related to the accident was the proximity of obstructions.NTSB MKC89LA080Accident · No injuriesLimited investigationFinal reportCallair A9-B · Fisher, ARFailure of the engine magneto resulting in engine failure.NTSB MKC89LA079Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Stuttgart, ARFailure of the engine blower assembly drive shaft, while maneuvering at low altitude, and failure of the pilot to maintain adequate airspeed, which resulted in a stall before he could land.NTSB ATL89LA101Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Steubenville, OHThe rudder control cable failed which rendered the control surface inoperative. The loss of rudder precluded the pilot from maintaining directional control after landing.