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 ATL90FA017Accident · 1 fatalField investigationFinal reportCessna 150M · Carrollton, OHThe pilot failed to maintain adequate airspeed while maneuvering, which led to an inadvertent stall/spin. Contributing to the accident were the pilot's apparent desire to show off, and the low altitude at which he chose to perform the maneuver.NTSB MKC90FA019Accident · 2 fatalField investigationFinal reportCessna 320 · Nebraska City, NEThe pilot's decision to continue the flight into IFR conditions and the failure to maintain adequate alittude. Factors related to the accident were the pilot's over confidence in his ability and the lack of instrument flight experience.NTSB MIA90LA018Accident · Minor injuriesLimited investigationFinal reportBell 47G · West Palm Beach, FLThe pilot's inadequate compensation for wind conditions. Factors related to the accident were: the unfavorable and gusty wind conditions.NTSB LAX90LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Bishop, CAThe pilot's neglect in failure to ensure adequate clearance was available to pass the parked refueling vehicle. The refueling vehicle parking position on an active taxiway was a factor in the accident.NTSB DEN90LA014Accident · No injuriesLimited investigationFinal reportCessna 206F · Opheim, MTPilot's failure to maintain terrain clearance while executing a low pass.NTSB ATL90DKJ02Accident · No injuriesFinal reportBell 47G2 · Wettumpka, ALThe pilot's failure to avoid obstacles during aerial application maneuvering.NTSB LAX90LA013Accident · Minor injuriesLimited investigationFinal reportRobinson R22A · Simi Valley, CAStudent pilot's failure to maintain the proper altitude.NTSB DEN90FA013Accident · 2 fatalField investigationFinal reportCessna T210L · Penasco, NMImproper inflight planning/decision by the pilot, and his failure to maintain sufficient altitude over mountainous terrain. Factors related to the accident were: failure of the pilot to obtain (and/or understand) wind aloft information, his lack of…NTSB ATL90GA010Accident · Serious injuriesFinal reportHiller UH-12D · Mentor, OHImproper in-flight planning/decision by the pilot. Factors related to the accident were: the pilot's improper compensation for wind conditions and trees.NTSB MKC90LA016Accident · No injuriesLimited investigationFinal reportHughes 369HS · Ogilvie, MNLoss of engine power for an undetermined reason. Factors related to the accident were: the unsuitable terrain conditions in the emergency landing area.NTSB ANC90LA007Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Heiden, AKFailure of the pilot to maintain of the aircraft while maneuvering.NTSB ATL90LA020Accident · No injuriesLimited investigationFinal reportCessna 172N · Valdosta, GAInadequate visual lookout by the pilot (failure to see & avoid the obstruction). Contributing factors were the transmission (power) line and lack of visual cues (pilot's visual perception).NTSB ATL90FA007Accident · 2 fatalField investigationFinal reportVultee BT-13 · Axis, ALThe aircraft inadvertently entered a stall, when the pilot/passenger had a heart attack. A factor related to the accident was: lack of altitude for the pilot-in-command to recover from the stall.NTSB ATL90DKJ01Accident · No injuriesFinal reportSteen Skybolt · Bessemer, ALThe improper use of the flight controls by the pilot in command during an aerobatic maneuver. While attempting a snap roll, the pilot failed to introduce sufficient elevator input to complete the maneuver.NTSB CHI90LA011Accident · 1 fatalLimited investigationFinal reportCessna 152 · Hillsdale, MIPoor judgement of the student pilot by not following his flight instructor's directions on his first supervised solo flight and by not maintaining a safe altitude, which resulted in a collision with the terrain. Related factors were: unauthorized low flight…NTSB SEA90FA005Accident · 1 fatalField investigationFinal reportHughes 369D · Bothell, WAThe pilot failed to determine weather conditions before the flight, his attempt to fly VFR in IMC, and his failure to maintain obstacle clearance altitude. Factors in the accident were the low ceiling, rain and fog weather conditions.NTSB NYC90FA011Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Glastonbury, CTThe pilot-in-command's failure to maintain adequate altitude control during maneuvering flight. Contributing to the accident was the failure of the airplane's electrical system and the pilot's operation at night, without emergency lighting (flashlight).NTSB LAX90DUJ03Accident · Serious injuriesFinal reportHiller UH-12E · Yuma, AZThe pilot misjudged the flare altitude. Contributing to this accident was the failure of the engine torsional coupling which ultimately caused the total loss of power.NTSB MKC90FA005Accident · 2 fatalField investigationFinal reportPiper PA-28 · Delavan, MNFailure of the pilot to maintain proper altitude during a low pass, and to see-and-avoid obstructions (inadequate visual lookout). Factors related to the accident were: the pilot's ostentatious display and the obstructions (powerlines).NTSB FTW90LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Amarillo, TXThe loss of aircraft control by the pilot.NTSB CHI90DEE01Accident · Serious injuriesFinal reportBaker/Santiago Pitts S-1S · Dekalb, ILImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB ATL90DLG01Accident · 1 fatalFinal reportCessna 188B · Hartsville, SCThe failure of the pilot to maintain adequate in-flight clearance from obstacles.NTSB MIA90LA002Accident · No injuriesLimited investigationFinal reportCessna A188B · Wauchula, FLFuel starvation, improper planning/decision by the pilot, and his failure to attained the emergency procedure. Factors related to the accident were: the low fuel level, and improper planning/decision by the pilot.NTSB MIA90LA001Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Belle Glade, FLInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. A factor related to the accident was: the terrain condition in the emergency landing area.NTSB FTW90LA001Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1B · Sulphur, LAThe failure of the landing gear to completely retract which resulted in the inability to gain sufficient airspeed to perform the climbing maneuver.NTSB SEA89FA183Accident · 3 fatalField investigationFinal reportCessna 182F · Diamond Lake, ORImproper inflight planning and decision by the pilot in command who continued VFR flight into IMC conditions while attempting to fly through a mountain pass. Contributing factors were the low ceiling and rain weather conditions and the mountainous, hilly…NTSB NYC89DFA02Accident · 1 fatalFinal reportNiedzielski COOT-A · Marcy, NYFuel system contamination and the pilot's failure to maintain adequate airspeed, which resulted in a stall/spin.NTSB FTW89LA174Accident · No injuriesLimited investigationFinal reportBell 206BII · Grand Prairie, TXThe pilot's decision to execute an abrupt maneuver while hovering downwind, which led to a reduction in rotor RPM and subsequent hard landing.NTSB ANC89LA175Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Cottonwood Crk, AKImproper inflight planning/decision by the pilot and his failure to maintain adequate airspeed. Factors related to the accident were: the pilot's low pass over rising terrain and the aircraft's subsequent impact with alder bushes (high vegetation).NTSB SEA89LA177Accident · Minor injuriesLimited investigationFinal reportBell 47G · Corvallis, ORStudent pilot's improper use of the collective control while performing hovering autorotations, and the instructor's inadequate supervision of the student's actions, which resuled in hard landings. In addition, the engine mount was significantly weakened…NTSB MIA89FA253Accident · 2 fatalField investigationFinal reportCessna 172N · Ochopee, FLThe failure of the pilots of both airplanes to see and avoid each other while maneuvering.NTSB ATL89LA217Accident · No injuriesLimited investigationFinal reportCessna 182Q · Mt Pleasant, SCFailure of the pilot to slow the aircraft to the proper landing speed at the proper touchdown point or go around. The weather conditions, tailwind, lack of airport facilities (UNICOM not operating and windsock damaged), wet runway/hydroplaning conditions, and…NTSB LAX89DUG09Accident · No injuriesFinal reportAir Tractor AT-301A · Blythe, CAThe pilot's failure to verify the fuel supply prior to takeoff.NTSB MIA89FA252Accident · 2 fatalField investigationFinal reportCessna 152 · Ochopee, FLFailure of the pilot to maintain altitude/clearance over the terrain. Related factors were: dark night, spatial disorientation of the pilot, and his lack of experience in the type of operation (night flying).NTSB LAX89FA318Accident · No injuriesField investigationFinal reportCessna 152 · Chandler, AZThe failure of the pilot's of both aircraft to maintain adequate visual outlook for other aircraft.NTSB FTW89DRD15Accident · Serious injuriesFinal reportCessna 188 · Winnsboro, LAThe pilot's inadequate visual lookout and subsequent collision with a tree.NTSB NYC89FA220Accident · 1 fatalField investigationFinal reportMBB BO-105CB-4 · Tuckerton, NJThe pilot's delay in remedial action by delaying the pull-up from a descending maneuver.NTSB ANC89LA172Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-105 · Port Moller, AKImproper planning/decision by the pilot. Factors related to the accident were: the pilot's self induced pressure and the adverse weather conditions.NTSB SEA89LA175Accident · 1 fatalLimited investigationFinal reportBell 47G3B2 · Monitor, WAThe pilot failed to maintain aircraft separation from obstacles on the ground. A factor in the accident was the bright glare from the rising sun.NTSB LAX89LA324Accident · 2 fatalLimited investigationFinal reportHughes 269A · AganaInadequate visual lookout by the pilot, which resulted in his failure to see-and-avoid the power line. The power line was a related factor.NTSB DEN89LA210Accident · 1 fatalLimited investigationFinal reportLet L-13 · Buena Vista, COA premature release of the glider tow line by the glider pilot and his failure to maintain sufficient airspeed, while maneuvering back toward the runway, which resulted in an inadvertent stall.NTSB SEA89LA173Accident · 1 fatalLimited investigationFinal reportMiller Special JM-2 · Reno, NVStructural failure when design stress limits were exceeded after encountering hazardous meteorological conditions.NTSB ATL89LA212Accident · No injuriesLimited investigationFinal reportSikorsky H-34J · Louisville, GAAn undetermined malfunction of the main rotor drive system.NTSB SEA89LA172Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Hillsboro, ORThe pilot misjudging altitude and airspeed.NTSB LAX89DVA10Accident · No injuriesFinal reportAir Tractor AT-301 · Mendota, CAA loss of aircraft control by the pilot when he slowed the aircraft to begin a spray run. Contributing to the loss of control was the inoperative stall warning system.NTSB DEN89LA213Accident · No injuriesLimited investigationFinal reportCessna 188B · Sunland Park, NMUndetermined. A factor related to the accident was the crop in the emergency landing area.NTSB NYC89LA213Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Boston, MAFailue of pilot to maintain control of the helicopter when a passenger inadvertently pushed the cyclic control. The fence (near the helipad) was considered to be a factor.NTSB LAX89DVG09Accident · 1 fatalFinal reportClatti FOCKE-WULF-190 · Placerville, CAThe wing failed due to delamination caused by adhesive separation.NTSB FTW89DRD14Accident · No injuriesFinal reportGrumman G-164A · Franklin, LAFatigue failure of the propeller blade, which resulted in separation of the blade's tip and severe engine vibration. The soft terrain was a related factor.NTSB DEN89FA208Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Grantsville, UTImproper in-flight planning/decision by the pilot, by entering a box canyon with insufficient altitude to assure a safe exit. Contributing factors were: box canyon, rising terrain, and high density altitude.