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 FTW90LA065Accident · No injuriesLimited investigationFinal reportHughes 269C · Encinal, TXThe loss of directional control due to the failure of the tail rotor cable.NTSB LAX90FA083Accident · 1 fatalField investigationFinal reportCessna 152 · Phoenix, AZDesign stress limits exceeded.NTSB ATL90FA061Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Norris, TNThe student pilot's misjudged descent which resulted in a collision with trees and the ground. A factor was that the pilot was buzzing when the accident occurred.NTSB ATL90FA055Accident · 1 fatalField investigationFinal reportAmerican AA-1 · Cherokee, ALCarburetor ice due to the pilot's improper use of carburetor heat, and failure of the pilot to maintain control of the airplane after the engine lost power. The weather (carburetor icing) condition was a related factor.NTSB NYC90FA063Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Fairfield, CTThe intoxicated pilot's failure to attain/maintain a safe altitude to provide clearance from the tree.NTSB CHI90DEM02Accident · Serious injuriesFinal reportMaxair MU532 · Vicksburg, MIThe pilot's failure to maintain adequate airspeed while performing manuevers.NTSB LAX90LA078Accident · No injuriesLimited investigationFinal reportCessna 172 · Inyokern, CAImproper in-flight planning/decision by the pilot-in-command (PIC), and his failure to maintain adequate airspeed while maneuvering, which resulted in an inadvertent stall/mush.NTSB LAX90LA076Accident · Serious injuriesLimited investigationFinal reportRobinson R22B · Parlier, CAThe pilot's flight into the known adverse weather and his inadvertent descent to the ground. Factors in the accident were: the fog condition and spatial disorientation of the pilot.NTSB CHI90DET02Accident · 1 fatalFinal reportAir Command 532 · Munster, INThe pilot's exceeding the design stress limits of the aircraft. Factors in the accident were the pilot's ostentatious display and his lack of total experience in type aircraft.NTSB FTW90LA057Accident · No injuriesLimited investigationFinal reportCessna 172M · Goliad, TXThe pilot in command's failure to identify and correct for carburetor icing conditions which existed at the time of the accident and precipitated the precautionary landing.NTSB LAX90FA070Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Burbank, CAPoor judgement of the instructor pilot (CFI) due to his impairment from use of marijuana, inadequate supervision of the flight by the CFI, and his failure to assure that adequate airspeed was maintained, which resulted in an inadvertent stall. Factors related…NTSB SEA90LA035Accident · 1 fatalLimited investigationFinal reportStanger Aircommander 532 · Hansen, IDFailue of the pilot to maintain control of the gyrocopter after entering an abrupt pull-up from a low pass. Factors related to the accident were: failure of the pilot to follow procedures/directives, his lack of certification (qualification) for this flight,…NTSB MKC90LA041Accident · No injuriesLimited investigationFinal reportMancini Rotorway Exec · Mountain Iron, MNFailure of the non-certificated pilot to maintain adequate altitude, while maneuvering the helicopter. The pilot's lack of experience and proper certification (qualification) were related factors.NTSB ATL90DMG01Accident · 1 fatalFinal reportWaldron Flybaby · Troy, NCPoor judgement of the non-rated pilot, due to impairment from consumption of alcohol, his lack of training/qualification, his improper use of the engine controls which resulted in loss of engine power from probable carburetor ice, and his failure to maintain…NTSB LAX90LA065Accident · No injuriesLimited investigationFinal reportHughes 269C · Rialto, CAThe lack of adequate supervision by the instructor pilot during a critical phase of flight when he allowed a student to perform in an unsafe manner without taking immediate corrective action.NTSB FTW90LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Glencoe, OKThe power loss due to carburetor ice, which resulted from the pilot's failure to engage carburetor heat in a timely manner. A factor in this accident was the pilot's lack of total experience.NTSB ANC90LA024Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Bettles, AKFailure of the pilot to maintain sufficient altitude. Factors related to the accident were: the high density altitude, high wind, downdraft, and mountainous terrain.NTSB FTW90LA045Accident · No injuriesLimited investigationFinal reportCessna 150M · Minden, TXThe pilot's mismanagement of fuel by not maintaining an adequate supply of fuel.NTSB FTW90LA044Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350B · Grand Prairie, TXManufacturer's failure to property install the left side components of the dual control system following its removal for additional completion work prior to delivery of the aircraft. Contributing to the accident was the failure of quality control personnel to…NTSB LAX90LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Byron, CAThe pilot's failure to maintain sufficient terrain clearance altitude during a low altitude turn. Contributing to the accident was the pilot's poor judgement in conducting touch-and-go landings with a 700-foot ceiling.NTSB ATL90LA043Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Norcross, GAThe student pilot's improper execution of the landing procedure resulting in dynamic roll-over of the helicopter.NTSB ANC90FA021Accident · 1 fatalField investigationFinal reportPiper PA-31 · Beluga, AKFailure of the pilot to maintain proper altitude. Darkness and adverse weather conditions were related factors.NTSB ATL90LA042Accident · No injuriesLimited investigationFinal reportBell TH-1 · Creola, ALThe loss of engine power due to a #21 bearing failure. The bearing failed as a result of inadequate maintenance. A factor in the accident was the pilot operating the helicopter within the avoid operating envelope.NTSB ATL90FA040Accident · 1 fatalField investigationFinal reportCessna 182 · Cincinnati, OHFailure of the Cessna pilot to remain clear of the helicopter after experiencing a partial power loss.NTSB LAX90DXQ01Accident · Minor injuriesFinal reportBennet Spezio Tuholer · Chilcoot, CAThe pilot's improper inflight decision by failing to maintain proper terrain clearance while maneuvering near the ground to observe some deer.NTSB ATL90LA034Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Jackson, TNLoss of power in both engines (probable fuel starvation) due to improper planning/decision by the pilot(s), and lack of supervision by the instructor. Soft terrain in the emergency landing area was considered to be a factor.NTSB LAX90LA042Accident · Minor injuriesLimited investigationFinal reportBell 47G-II · Rialto, CAThe pilot's loss of directional control and subsequent overcontrol while hovering. Contributing to the accident were the gusty wind conditions and the pilot's inexperience.NTSB SEA90LA025Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Raymond, WALoss of engine power due to fatigue failure of the impeller. The helicopter was substantially damaged as a result of a roll-over on uneven terrain.NTSB SEA90LA023Accident · No injuriesLimited investigationFinal reportHughes 369D · Stayton, ORThe maintenance personnel failed to record the previous flight time for the overrunning clutch on airworthiness certification documents when the assembly was overhauled. Also, causal to the accident was the operation of the aircraft by the operator for 175…NTSB NYC90FA036Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Coventry, CTThe non-instrument rated pilot initiating VFR flight into IMC on a dark night which resulted in spatial disorientation and uncontrolled flight into the ground. Contributing factor(s) was: the adverse weather existing at the time of the accident and the…NTSB CHI90DEE03Accident · 1 fatalFinal reportNelsen-David Sonerai II/EV · Huntley, ILPilot-in-command's failure to maintain airspeed during a turn at low altitude, resulting in an inadvertent stall and impact with terrain, lack of recent total experience and lack of total experience in type of aircraft.NTSB FTW90FA037Accident · 2 fatalField investigationFinal reportChristen Industries Pitts S-2B · La Junta, TXThe pilot's delayed remedial action to recover from the spin and his misjudging of altitude.NTSB ATL90LA029Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Burlington, NCLoss of engine power for an unknown reason. The barn was considered to be a related factor.NTSB LAX90LA033Accident · 1 fatalLimited investigationFinal reportMcDonnell Douglas 369 · Barstow, CAImproper planning/decision by the pilot, and his delay in jettisoning the load.NTSB LAX90DVG01Accident · No injuriesFinal reportSchweizer G-164B · Grimes, CAFailure of the counter weight bracket to the propeller assembly.NTSB SEA90LA016Accident · 1 fatalLimited investigationFinal reportHughes 269C · Estacada, ORThe pilot misjudged clearance between her external load and the obstruction. Factors related to the accident were: the obstruction, improper maintenance and modification of the external load line/hook by the operator, failure of the pilot to jettison the…NTSB CHI90FA026Accident · 1 fatalField investigationFinal reportCessna 172D · Mt Morris, ILVFR flight into IMC and spatial disorientation of the pilot. Contributing to the accident were the meteorological conditions and the overconfidence and lack of experience of the pilot.NTSB MKC90LA027Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Springdale, ARThe banner tow pick up equipment became entangled resulting in a jammed rudder and restricted aircraft control.NTSB DEN90FA022Accident · Serious injuriesField investigationFinal reportCessna 182F · Oakley, UTThe pilot diverted his attention, misjudged his altitude and failed to maintain clearance above the trees, while maneuvering at low altitude over mountainous terrain. The mountainous terrain, high density altitude, low airspeed, and trees were contributing…NTSB DEN90FA021Accident · 2 fatalField investigationFinal reportCessna 310I · Provo, UTThe Cessna pilot misjudge his altitude above the water. Contributing factors were: the pilot allowing his attention to be diverted and his lack of visual/depth perception over the calm (glassy) water.NTSB ANC90FA010Accident · No injuriesField investigationFinal reportCessna A185E · Anchorage, AKThe throttle control linkage became disconnected on the first flight after an annual inspection due to improper maintenance. Darkness and high vegetation were contributing factors.NTSB LAX90FA025Accident · 2 fatalField investigationFinal reportCessna 172 · Safford, AZThe pilot failed to maintain an airspeed above the aircraft's stall speed as he turned away from ascending terrain. The aircraft's inadequate performance resulting from improper grade of fuel and high density altitude and the pilot's lack of experience in…NTSB ATL90DKG02Accident · 1 fatalFinal reportBell 47G/Tomcat MK5 · Elberton, GAA loss of engine power due to carburetor ice.NTSB NYC90LA025Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B1 · Westfield, MALoss of aircraft control for an undetermined reason, which resulted in the tail rotor striking the ground and separating from the helicopter.NTSB LAX90LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · S. Juan Batista, CAThe pilot's intentional buzzing and failure to see and avoid a guy wire.NTSB LAX90DUJ05Accident · No injuriesFinal reportBell UH-1E · Mesa, AZThe inflight separation of the tail rotor due to improper maintenance procedures and the installation of incorrect attachment hardware on the tail rotor blade pitch change linkages.NTSB MIA90LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Immokalee, FLFailure of the pilot to maintain proper altitude and his failure to maintain adequate visual lookout to see and avoid obstructions. The static line (obstruction) was a contributing factor.NTSB ATL90GA023Accident · 1 fatalFinal reportSikorsky SK-70 · Marathon, FLFailure of the pilot to maintain the proper altitude over the ocean water. Factors related to the accident were: continued operation of the helicopter with a known partial deficiency of the radio altimeter/warning system, darkness, the pilot's lack of visual…NTSB MIA90LA023Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Loxahatchee, FLFailure of the pilot to maintain rotor RPM after pulling up from a swath run. A related factor was the presence of trees.NTSB LAX90DVM01Accident · No injuriesFinal reportBell 47G-5 · Guadalupe, CAThe pilot's failure to maintain sufficient clearance allowing the aircraft to collide with a wooden power pole. Contributing to the accident was the sunglare which inhibited the pilot's vision.