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 MKC90LA124Accident · No injuriesLimited investigationFinal reportBell B47G-5 · Shell Knob, MOVisual outlook not maintained by the pilot in command.NTSB LAX90FA219Accident · 1 fatalField investigationFinal reportAerotek Pitts S2A · Thermal, CAThe pilot's inadequate handling of the airplane during an aerobatic maneuver.NTSB FTW90DRD12Accident · Minor injuriesFinal reportGrumman G-164A · Bastrop, LAThe pilot's improper engine procedures during ground operations and prior to takeoff which resulted in fouled spark plugs.NTSB LAX90LA212Accident · 1 fatalLimited investigationFinal reportRolladen-Schneider LS-3A · Vacaville, CAThe pilot's inflight loss of control for undetermined reasons.NTSB DEN90LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Andover, SDThe pilot's failure to maintain proper clearance during the swath run.NTSB LAX90DVA04Accident · Serious injuriesFinal reportGrumman-Schweizer G-164B · Buttonwillow, CAFailure of the #7 cylinder due to a pre-existing crack. The terrain condition was a related factor.NTSB DEN90LA127Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Sisseton, SDA total loss of power due to fuel starvation. Fuel starvation was caused by a missing fuel valve support clamp and a resultant cracked fuel line. Inadequate maintenance inspections and rough, uneven terrain were contributing factors.NTSB SEA90LA097Accident · Minor injuriesLimited investigationFinal reportRockwell S2R · Cottonwood, IDThe loss of engine power due to undetermined reasons. The berm, which the airplane struck during landing, was a factor in the accident.NTSB NYC90LA125Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Brookville, PAWorn tail rotor pitch control assembly, due to improper maintenance/installation, and subsequent fatigue failure of the tail rotor swashplate.NTSB MIA90LA138Accident · Minor injuriesLimited investigationFinal reportSpezio Sport DAL-1 · Columbus, MSFailure of the pilot to maintain adequate airspeed, resulting in an inadvertent stall and subsequent loss of control. A related factor was: the lack of a stall warning system installed in the aircraft.NTSB LAX90LA208Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26B · Truckee, CAThe pilot's improper decision to release from the tow airplane at an insufficient altitude on the lee side of the mountains.NTSB DEN90LA124Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Sturgis, SDPilot inadvertently stalling the airplane. Contributing to the accident was the pilot's lack of total experience.NTSB CHI90DEC02Accident · Minor injuriesFinal reportSchweizer G-164C · Sandusky, MIThe pilot's failure to maintain adequate airspeed during the swath run turn.NTSB FTW90DPJ07Accident · Minor injuriesFinal reportCessna T188C · Altus, OKThe PIC did not maintain the proper clearance from the powerline.NTSB CHI90FA146Accident · 4 fatalField investigationFinal reportBeech A36 · Gaylord, MIThe pilot's inadequate airspeed, while maneuvering (turning) after takeoff, which resulted in a stall/mush. Factors related to the accident were: the pilot's improper planning/decision, failure to maintain weight and balance limits, and adverse wind…NTSB ATL90DKG04Accident · No injuriesFinal reportAir Command 532 · Rome, GAThe pilot attempted a flat spiraling spin maneuver at an altitude that was too low to effect a safe recovery.NTSB MKC90DPG02Accident · 1 fatalFinal reportAero Commander S-2R · Alicia, ARThe pilot's failure to maintian airspeed during the turn to reverse direction for a swath run.NTSB NYC90LA114Accident · Minor injuriesLimited investigationFinal reportRolladen-Schneider Lsif Sailplane · Mayville, NYJammed flight controls in flight due to a bent aileron push-rod.NTSB ATL90FA120Accident · 1 fatalField investigationFinal reportHispano Aviacion HA-200 · Tuskegee, ALImproper in-flight planning/decision by the pilot, and his failure to maintain altitude and clearance above the terrain, while perfoming low altitude, inverted flight. Factors related to the accident were: the lack of visual perception to the pilot at dusk…NTSB MIA90LA134Accident · Minor injuriesLimited investigationFinal reportAyres S2R-600 · Vero Beach, FLThe operation of the airplane with an unairworthy propeller by the operator.NTSB FTW90DRA05Accident · No injuriesFinal reportGrumman 164-B · Garwood, TXThe power loss due to super charger impeller failure.NTSB LAX90LA191Accident · No injuriesLimited investigationFinal reportHughes 369FF · Madera, CAThe loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain encountered by the pilot when he turned during the autorotative descent to avoid obstacles.NTSB NYC90DHA01Accident · 1 fatalFinal reportGrumman G-164A · Hunlock Creek, PAThe pilot's failure to maintain adequate clearance from obtacles, and his failure to see and avoid the electrical transmission line.NTSB LAX90LA190Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26 · Waialua, HIThe failure of the pilot to maintain an adequate clearance from clouds.NTSB DEN90FA115Accident · Serious injuriesField investigationFinal reportAerospatiale SA315B · La Sal, UTA failure of the engine speed governor unit due to improper storage and/or inspection of the speed governor unit prior to placing it in service. A factor in the accident was the pilot carrying passengers on the external load.NTSB MIA90LA126Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Perry, FLLoss of engine power for an undetermined reason.NTSB SEA90LA083Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58D · Juneau, AKThe failure of the number 3 segment of the tail rotor drive shaft assembly.NTSB MIA90LA125Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Lake Wales, FLThe pilot's failure to maintain adequate clearance between the main rotor blades and a power line pole while maneuvering during an aerial application flight.NTSB BFO90FA046Accident · 2 fatalField investigationFinal reportDouglas DC-3 · Capon Bridge, WVInadequate visual lookout by the pilots of the DC-3, which resulted in their failure to see-and-avoid the powerlines. Factors related to the accident were: the obstruction (transmission wires), and the lack of visual cues for the pilots.NTSB CHI90DEV04Accident · No injuriesFinal reportGrumman G-164B · Princeton, ILThe pilot-in-command's failure to maintain adequate clearance from obstacles during flight at low altitude, resulting in wire strike.NTSB CHI90DEK04Accident · Minor injuriesFinal reportRobinson R-22 · St. Mary'S, OHThe pilot's failure to see and avoid wires in his operating area.NTSB MIA90LA119Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Shelby, MSThe pilot's inadequate preflight planning and attempted flight with insufficient fuel on board to complete the flight.NTSB DEN90LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Powderville, MTPilot failed to maintain terrain clearance during descent on an aerial application swath run, resulting in an in flight collision with the terrain. That the pilot misjudged the pull up altitude is considered a contributing factor.NTSB NYC90LA103Accident · No injuriesLimited investigationFinal reportRobinson R22 · Millville, NJThe student pilot's improper use of the flight controls, and inadequate supervision of the flight by the instructor (CFI). Contributing to the accident was the lack of total time and experience of both the student and instructor.NTSB NYC90DGM01Accident · Serious injuriesFinal reportAir Tractor AT-400 · Tyrone, PAThe pilot's failure to maintain adequate clearance from obstructions during low level aerial application operations. The pilot's inadequate visual lookout was a factor.NTSB LAX90DVG07Accident · Serious injuriesFinal reportGrumman G-164A · Gridley, CAFailure of the no.7 cylinder head which led to a forced landing and substantial damage to the aircraft when it nosed over after colliding with a ditch.NTSB DEN90DTK01Accident · 1 fatalFinal reportPiper PA-36-375 · Woonsocket, SDFailure of the pilot of N3634E to follow the briefed plan of operation, and failure of both pilots to see-and-avoid each other (inadequate visual lookout).NTSB SEA90LA076Accident · 1 fatalLimited investigationFinal reportPiper PA-18-125 · Rogerson, IDThe pilot's intentional flight below safe altitudes while engaged in low-altitude 'buzzing' activities.NTSB MKC90DCQ02Accident · 1 fatalFinal reportBell UH-1B · Ulysses, KSThe pilot failed to maintain proper rotor RPM, while maneuvering over a high obstruction (power line) at the end of a swath run, which resulted in an inadvertent descent & collision with the terrain. The high obstruction was considered to be a related factor.NTSB MKC90LA103Accident · No injuriesLimited investigationFinal reportPiper PA-25-235C · Hardin, MOPoor in-flight planning/decision and inadequate visual outlook by the pilot in command.NTSB LAX90DVA03Accident · Serious injuriesFinal reportNaval Aircraft Factory N3N-3 · Madera, CAThe pilot inadvertently descending into the ground. Contributing to the accident was the inflight opening of the hopper lid which partially obscured the pilot's vision.NTSB ATL90FA109Accident · 1 fatalField investigationFinal reportCessna 150L · Stockbridge, GAThe pilot's failure to maintain the proper clearance from objects on the ground.NTSB ANC90LA066Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Glennallen, AKThe pilot failed to maintain proper altitude and terrain clearance while maneuvering.NTSB LAX90LA164Accident · Minor injuriesLimited investigationFinal reportBell 47G · Riverside, CAThe pilot's failure to maintain control of the helicopter. A factor related to the accident was: the pilot's lack of experience in the type of aircraft.NTSB LAX90LA162Accident · No injuriesLimited investigationFinal reportHughes 369C · Kahului, HIThe pilots failure to ensure that adequate room existed to position the helicopter on the landing platform. Contributing to the accident was the failure of ground personnel to ensure that hazards to the landing helicopter were clear of the landing area.NTSB DEN90FA104Accident · 2 fatalField investigationFinal reportCanadair CT-133 · Roswell, NMThe pilot-in-command's performance of aerobatic maneuvers that exceeded the design stress limits of the aircraft, resulting in catastrophic failure of the wing.NTSB NYC90LA100Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Lawrence, MAThe pilot's improper use of flight controls, resulting in loss of control.NTSB FTW90DRD07Accident · No injuriesFinal reportGrumman G-164A · Ville Platte, LAPartial loss of engine power due to a cracked number four cylinder intake rocker box housing. The lack of a suitable forced landing site was a related factor.NTSB MKC90FA101Accident · 1 fatalField investigationFinal reportBeech J-35 · Pine Bluff, ARAircraft stall, from which recovery was not achieved.NTSB FTW90DPA02Accident · No injuriesFinal reportCessna A188B · Perry, TXThe total loss of engine power as a result of water contamination of the fuel supply. A factor was the unsuitable terrain in which the pilot had to make the forced landing.