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 ANC89FA160Accident · 1 fatalField investigationFinal reportCessna 185 · Tanacross, AKPoor judgement by the pilot by buzzing the airport and his failure to maintain sufficient altitude/clearance above the terrain. The pilot's use of abrupt maneuvers was a contributing factor.NTSB DEN89DTE04Accident · 1 fatalFinal reportCessna A188B · Wiggins, COThe pilot failed to maintain an adequate visual lookout and collided with a standpipe which severed four feet of the right wing, resulting in loss of control inflight and subsequent collision with the terrain.NTSB FTW89FA159Accident · 3 fatalField investigationFinal reportCessna 152 · Houma, LAThe failure of both pilots to see-and-avoid each other's aircraft (inadequate visual lookout). A probable factor was: failure of either pilot to issue a traffic advisory.NTSB SEA89FA156Accident · 1 fatalField investigationFinal reportCessna TU206C · Skykomish, WAThe pilot's decision to continue the flight into IMC. The pilot did not adequately plan and prepare for the flight and was unable to maintain a proper altitude above the terrain for VMC. Fog was a related factor.NTSB LAX89LA300Accident · No injuriesLimited investigationFinal reportBeech C23 · Selma, CAThe pilot's failure to maintain proper clearance from the power line, while maneuvering at low altitude. The power line was a related factor.NTSB DEN89FA200Accident · Serious injuriesField investigationFinal reportCessna 172 · Tremonton, UTThe pilot failed to maintain obstruction clearance while making a low pass over a newly constructed highway. The powerline was considered a contributing factor.NTSB SEA89LA159Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Atlanta, IDThe pilot's failue to adequately compensate for the downdraft conditions. Contributing factor(s) was: the downwind, downdraft, and high density altitude weather conditions, and the surrounding mountainous terrain.NTSB LAX89LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Williams, AZFailure of the pilot to maintain his visual lookout and flying low. Contributing to the accident was the one inch diameter telephone cable.NTSB CHI89DEI03Accident · Minor injuriesFinal reportBrumbaugh/Hubin Long EZE · West Salem, OHInadequate visual outlook and attention diversion by the pilot. Factor(s) related to the accident was: the presence of the wires.NTSB MIA89LA232Accident · No injuriesLimited investigationFinal reportCessna A188B · Edwards, MSInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Rough terrain in the emergency landing area was a related factor.NTSB MIA89LA231Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Jacksonville, FLInadequate visual look-out by the pilot and his failure to maintain control of the helicopter, while maneuvering to avoid obstructions. The transmission lines were considered to be factors.NTSB MIA89FA233Accident · 4 fatalField investigationFinal reportBeech C23 · Barranquitas, PRImproper in-flight planning/decision by the pilot and his failure to maintain adequate flying speed, which resulted in a stall and subsequent impact with the terrain. Contributing factors were: operation of the aircraft by the pilot with excessive gross…NTSB ATL89DKJ10Accident · Serious injuriesFinal reportPiper PA-36-285 · Atmore, ALThe pilot's failure to maintain clearance from obstacles (the crop) during an agricultural spray run.NTSB ANC89LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mcgrath, AKPilot-in-command's improper fuel consumption calculations, improper inflight planning, and decisions.NTSB BFO89LA071Accident · No injuriesLimited investigationFinal reportRobinson R22 · Manassas, VAImproper use of the cyclic control by the student pilot and his failure to relinquish control of the helicopter to the instructor (CFI). A contributing factor was the student's lack of experience.NTSB ATL89DKJ09Accident · 1 fatalFinal reportCessna 188B · Prattville, ALFailure of the pilot to maintain clearance from obstructions (trees).NTSB CHI89LA171Accident · No injuriesLimited investigationFinal reportCessna 172H · Lake Village, INWater contamination in the fuel/fuel system and inadequate preflight by the pilot. Soft terrain in the emergency landing area was a contributing factor.NTSB MIA89LA221Accident · Serious injuriesLimited investigationFinal reportContinental Copters Tomcat MK6C · Quitman, MSFailure of the tail boom attachment.NTSB FTW89DRG09Incident · No injuriesFinal reportMccormick Bushby Mustang II · Spicewood, TXThe pilot's failure to maintain proper clearance from personnel on the ground.NTSB SEA89LA149Accident · Serious injuriesLimited investigationFinal reportSwanson RV-4 · Carnation, WAThe pilot entered an inadvertent stall and hit trees while performing aerobatics.NTSB MIA89FA220Accident · 4 fatalField investigationFinal reportCessna 172P · Pass-A-Grille, FLFailure of the pilot to recover from a stall/spin. Excessive gross weight of the aircraft and lack of available altitude for spin recovery were probable contributing factors.NTSB CHI89LA167Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Lima, OHThe pilot failed to use carburetor heat during carburetor icing conditions. Contributing to the accident was the pilot's lack of total experience and the carburetor icing conditions.NTSB FTW89DQG05Accident · No injuriesFinal reportSchweizer G-164A · Sunray, TXA total power loss for undetermined reasons. A factor was the rough uneven terrain in which the pilot had to make the forced landing.NTSB ANC89LA138Accident · Serious injuriesLimited investigationFinal reportCessna 207-A · Tanana, AKPilot-in-command's improper inflight planning and decisions. He flew into weather that was known to be adverse, and the environmental conditions adversely affected his ability to safely complete the flight.NTSB MKC89DCQ01Accident · 1 fatalFinal reportWSK PZL Mielec PZL-M-18-A · Ingalls, KSImproper preflight planning by the pilot and his failure to attain inadequate airspeed, which resulted in a stall/spin. As he was attempting to avoid a power transmission line. Factors related to the accident were: rising terrain, tall grass, tailwind and the…NTSB LAX89LA270Accident · Serious injuriesLimited investigationFinal reportBell 206B · Bakersfield, CAThe loss of engine power due to the helicopter being flown in exhaust gases emanating from a cogeneration plant chimney stack that exceeded the certification standards of the powerplant. Contributing to the accident was invisible nature of the exhaust gases…NTSB ATL89DLT05Accident · 1 fatalFinal reportBratton RB-1 · Springfield, TNImproper planning/decision by the pilot, which resulted in fuel exhaustion at a low altitude, due to an inadequate supply of fuel; and his failure to maintain airspeed, which resulted in an inadvertent stall/spin. Factors related to the accident were: the…NTSB DEN89LA189Accident · Serious injuriesLimited investigationFinal reportBell 206B · Georgetown, COImproper inflight planning/decision by the pilot. The high density altitude, tail wind, gusts, and terrain were related factors.NTSB SEA89LA148Accident · No injuriesLimited investigationFinal reportBell 206B · Boulder City, NVPilot displayed poor inflight planning while maneuvering. The pilot did not identify the wind conditions resulting in a loss of directional control. The pilot's corrective action was inadequate and as result, the helicopter collided with the terrain.NTSB FTW89DRJ01Accident · Serious injuriesFinal reportCessna 150 · Piedmont, OKThe pilot's failure to maintain adequate airspeed while buzzing, which resulted in an inadvertent stall.NTSB ANC89FA137Accident · 1 fatalField investigationFinal reportCessna 402 · Nome, AKContinued VFR flight into instrument meteorological conditions (IMC) by the pilot, and his improper in-flight planning/decision. The weather and terrain conditions were considered to be contributing factors.NTSB SEA89LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Mollala, ORPilot displayed poor judgement and did not adequately plan for the flight. The pilot was unfamiliar with the area and terrain conditions. As a result, the airplane was not able to attain sufficient altitude for the conditions to clear the terrain.NTSB MKC89DPG04Accident · Serious injuriesFinal reportRockwell S-2R · Moscow, ARInadequate visual lookout by the pilot. The guy wire was a contributing factor.NTSB LAX89LA262Accident · 1 fatalLimited investigationFinal reportCessna 172H · Dana Point, CAPilot-in-commands failure to maintain control of the airplane while in maneuvering flight.NTSB DEN89LA186Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Lovell, WYImproper in-flight planning/decision by the pilot, which resulted in insufficient altitude to continue out of the canyon or turn around. The terrain and high density altitude were related factors.NTSB DEN89DTG01Accident · 1 fatalFinal reportCessna 188A · Valley City, NDInadequate visual lookout by the pilot. The power line was a related factor.NTSB NYC89LA186Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Shirley, NYThe failure of the pilot to maintain proper airspeed, and his delay to jettison the banner, which resulted in a stall.NTSB LAX89DUJ08Accident · No injuriesFinal reportAero Commander S2R · Tolleson, AZThe pilots failure to see and avoid contact with some wires.NTSB CHI89FA157Accident · 1 fatalField investigationFinal reportCessna 152 · York, SCFailure of the pilot to maintain adequate airspeed, which resulted in a stall. Factors related to the accident were: excessive workload (task overload) and diverted attention.NTSB ATL89FA193Accident · 1 fatalField investigationFinal reportTexas Helicopter OH-13/M74 · Norman Park, GAImproper planning/decision by the pilot, which resulted in his physical impairment from exposure to lannate, and his failure to maintain altitude/clearance above the ground. A factor related to the accident was: failure of the pilot to use a respirator while…NTSB CHI89DEP10Accident · 1 fatalFinal reportAir Tractor AT-301 · Plainfield, WIFailure of the pilot-in-command to maintain control of the aircraft while conducting aerial application maneuvers in close proximity to the terrain.NTSB ATL89DKG05Accident · Minor injuriesFinal reportGrumman G-164A · Dawson, GAFailure of the number three cylinder head.NTSB NYC89DNC01Accident · Serious injuriesFinal reportBonds & Bungey HP-14 · Warren/Sugarbus, VTFailure of the pilot to maintain adequate airspeed while maneuvering in shifting/turbulent air, and his inadequate remedial action to avoid or recover from the inadvertent spin. The shifting/turbulent/gusty wind condition was a related factor.NTSB FTW89DRD12Accident · No injuriesFinal reportSchweizer G-164B · Donaldsonville, LALoss of engine power for undetermined reasons. A contributing factor was the soft terrain.NTSB CHI89FA151Accident · Minor injuriesField investigationFinal reportCessna A152 · Oshkosh, WIThe pilot's poor judgement, and poor evaluation of the weather due to self induced pressure and overconfidence in his personal ability. Contributing factor was the experimental aircraft association's inadequate supervision of the operation.NTSB MKC89LA170Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Portland, AREngine failure due to failure of an engine cylinder.NTSB MKC89DPG03Accident · 1 fatalFinal reportPZL-Mielec M-18 · Parkin, ARThe failure of the pilot to maintain a visual lookout adequate to have avoided the powerlines.NTSB DEN89LA181Accident · No injuriesLimited investigationFinal reportCallair A-9 · Cartwright, NDA total loss of power due to an improperly adjusted carburetor which resulted in an excessive rich fuel-air mixture. This required a forced landing in an area where no suitable terrain existed.NTSB CHI89LA147Accident · 1 fatalLimited investigationFinal reportPiper PA-38-112 · River Falls, WIImproper remedial action by the pilot following an abrupt maneuver. The pilot's lack of total aviation experience was a factor in the accident.NTSB ATL89DKJ08Accident · Serious injuriesFinal reportCessna A188B · Atmore, ALPilot's failure to maintain visual lookout for obstacles. Contributing to the accident was the low (dawn) position of the sun which interfered with the pilot's vision.