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 SEA91LA047Accident · No injuriesLimited investigationFinal reportCessna 150M · Salt Lake City, UTAn undetermined loss of engine power.NTSB NYC91LA072Accident · Minor injuriesLimited investigationFinal reportPiper J-3-C · Hamilton, OHThe failure of the pilot-in-command to touchdown in a suitable area after he experienced a power loss. A factor related to the accident was the improperly maintained carburetor.NTSB ANC91LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Talkeetna, AKWas the pilot-in-command's improper in-flight planning and decision. Contributing to the accident was the pilot's failure to refuel the airplane prior to the cross-country flight.NTSB SEA91LA044Accident · No injuriesLimited investigationFinal reportSchweizer Hughes 269C · Princeton, ORThe pilot's attempt to hover out of ground effect at a density altitude and gross weight in tailwind weather conditions that exceeded the aircraft performance limits. Factors relating to the accident were the high density altitude and tailwind weather…NTSB ANC91LA021Accident · Serious injuriesLimited investigationFinal reportDe Havilland DHC-2 · Two Moon Bay, AKThe pilot-in-command's failure to maintain airspeed above a stall while maneuvering in mountainous terrain.NTSB NYC91FA060Accident · 2 fatalField investigationFinal reportMooney M20J · Brookline, NHThe failure of the flight instructor (CFI) to attain remedial action after control of the airplane was lost for an unknown reason.NTSB BFO91LA023Accident · Serious injuriesLimited investigationFinal reportHolmes Special S2C · Ellendale, DEThe pilot's failure to recover from an aerobatic manuever in time to avoid inflight collision with the ground.NTSB CHI91LA069Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ashland, NEThe pilot's failure to maintain clearance above the terrain. Factors related to the accident were the low pass and ostentatious display.NTSB LAX91LA072Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Torrance, CAThe pilot's improper use of the rotorcraft's flight controls. Contributing factors were related to the pilot's lack of experience in the type of low altitude maneuver.NTSB SEA91FA262Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Dayville, ORThe pilot's poor in flight decision. Factors include mountainous/hilly terrain.NTSB NYC91DGT01Accident · 1 fatalFinal reportKolb Twin Star · Carlisle, PAThe pilot's failure to maintain adequate altitude above the ground.NTSB ANC91FA018Accident · 1 fatalField investigationFinal reportCessna 208 · False Pass, AKThe pilot's improper decision to continue flight into an area of mountainous terrain and adverse weather conditions. The terrain and weather were factors.NTSB MIA91LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · Deland, FLFailure of the instructor pilot to utilize carburetor heat in icing conditions.NTSB LAX91LA057Accident · No injuriesLimited investigationFinal reportCessna 172L · Mcdermitt, NVIntentional buzzing conducted by the pilot. His poor judgement was a factor in the accident.NTSB LAX91LA054Accident · 1 fatalLimited investigationFinal reportMcdonnell Douglas 369D · Haleakla Nat Pk, HIFuel starvation due to the unporting of the fuel supply pick-up.NTSB ATL91FA025Accident · 1 fatalField investigationFinal reportCessna 150J · Ripley, TNPerforming a stall maneuver at an altitude below prescribed minimums, and his failure to apply correct flight control inputs to recover from the stall and spin.NTSB SEA91LA030Accident · 1 fatalLimited investigationFinal reportRobinson Wenoso · Olympia, WAThe inadvertant stall/spin and loss of aircraft control by the pilot in command while performing aerobatic maneuvers.NTSB SEA91FA026Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Salt Lake City, UTThe pilot's intentional buzzing of uninhabited island in the great Salt lake and his misjudging the timing of a pull-up maneuver to clear rising terrain of a ridgeline.NTSB MIA91FA035Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Bunnell, FLFailure of the pilot to maintain altitude, while maneuvering at night over an unlighted area, which resulted in a collision with trees. Factors related to the accident were: darkness and possible spatial disorientation of the pilot due to lack of visual ques.NTSB SEA91LA023Accident · No injuriesLimited investigationFinal reportHughes 369D · Mulina, ORIn-flight collision with a rebounding long-line, which caused main-rotor RPM decay and tail-boom separation, compromising the pilot's ability to successfully accomplish an attempted autorotation.NTSB MIA91LA033Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT401 · Belle Glade, FLThe pilot failed to maintain airspeed, and stalled the airplane, resulting in a uncontrolled descent, and collision with the terrain.NTSB LAX91FA037Accident · 1 fatalField investigationFinal reportRobinson R22Beta · Simi Valley, CAA divergence of the main rotor from its normal plane of rotation for an undetermined reason, which resulted in rotor contact to the tailboom and cockpit.NTSB FTW91DRD02Accident · 2 fatalFinal reportPiper PA-J3C-65 · Mer Rouge, LAAn inadvertent stall at an altitude too low to allow for recovery.NTSB FTW91FA017Accident · 1 fatalField investigationFinal reportBeech B55 · England, ARThe pilot's misjudgement of altitude, which resulted in his failure to arrest descent from a dive. The pilot's impaired judgment from consumption of ethanol (alcohol) was a factor.NTSB CHI91DCQ01Accident · 1 fatalFinal reportRobert Bressler Pitts S-1E · St. Francis, KSThe failure of the pilot to maintain aircraft control.NTSB FTW91DRG01Accident · 1 fatalFinal reportTaylor Titch MK III · Seguin, TXThe pilot lost control at low level. Factors were the pilot attempting aerobatic maneuvers with insuffient altitude for recovery.NTSB LAX91DUJ03Accident · No injuriesFinal reportAir Tractor AT-302 · Somerton, AZThe failure of the number 3 exhaust valve which led to an engine failure and subsequent crash landing.NTSB CHI91LA027Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Lindstrom, MNLeft engine failure for an undetermined reason. A factor related to the accident was: unsuitable terrain.NTSB DEN91FA017Accident · 4 fatalField investigationFinal reportCessna T210L · Aspen, COImproper planning/decision by the pilot and his failure to maintain adequate airspeed, while turning over high terrain beside the airport, which resulted in an inadvertent stall. Factors related to the accident were: excessive gross weight of the aircraft,…NTSB SEA91LA013Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B Lama · Trout Lake, WAThe pilot's failure to maintain clearance from an obstacle.NTSB ATL91FA015Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Rock Hill, SCThe pilot misjudged the aircraft's altitude/clearance above the runway during a low pass and allowed the propeller to contact the runway; he then failed to maintain airspeed after a pull-up and allowed the aircraft to stall.NTSB NYC91LA024Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Buckland, MAThe pilot's failure to execute an aerobatic maneuver at an altitude sufficient to clear the stand of trees.NTSB LAX91LA030Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Portal, AZFailure of the pilot to maintain proper altitude.NTSB CHI91DEE01Accident · 1 fatalFinal reportPitts Special S1-S · Dekalb, ILThe pilot's attempt to perform aerobatic maneuvers at low altitude.NTSB LAX91FA020Accident · 2 fatalField investigationFinal reportGrumman AA-1B · Solana Beach, CAThe inadvertent stall/spin. Factors in the accident were: the pilot's decision to allow the reporter passenger to fly the aircraft in a critical flight situation, his decision to allow the aircraft to descend to an altitude too low to allow for contingencies,…NTSB MIA91LA018Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Osteen, FLTotal loss of engine power, for an undetermined reason.NTSB LAX91FA022Accident · 3 fatalField investigationFinal reportPiper PA-22-108 · Oceanside, CAThe pilot initiating an instrument flight without operating air/ground communications equipment, and his failure to maintain adequate terrain clearance after apparently deciding to return to the airport. Factors contributing to the accident were inoperative…NTSB CHI91LA018Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Greenfield, INA stall/spin encountered due to an improper go-around.NTSB DEN91FA013Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Belen, NMThe pilot misjudged the aircraft's altitude (ground clearance) above the desert terrain.NTSB DEN91FA012Accident · 2 fatalField investigationFinal reportCessna T210M · Carbondale, COFailure of the pilot to see-and-avoid the power line.NTSB LAX91LA013Accident · 2 fatalLimited investigationFinal reportBell 47G5 · AntarcticaThe pilot's failure to maintain on adequate altitude while maneuvering above the water.NTSB FTW91DRD01Accident · No injuriesFinal reportMonnett Soneria · Lake Charles, LAA total loss of power for unknown reasons. A factor was the proximity of the crowd and other airplanes in the race during the forced landing.NTSB NYC91LA014Accident · Minor injuriesLimited investigationFinal reportStinson SR8C · Lakeville, MAThe pilot misjudged his altitude above the lake water and allowed the airplane to descend while making a left turn. Factor's related to the accident were: calm winds causing the lake water to be glassy.NTSB DEN91FA010Accident · 2 fatalField investigationFinal reportPiper PA-38-125 · Levelland, TXInadvertent stall/spin at an altitude insufficient to effect recovery.NTSB MIA91LA013Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Miami, FLInadequate preflight of the airplane by the pilot-in-command.NTSB ATL91FA005Accident · 1 fatalField investigationFinal reportPitts Special S-1 · Ocala, FLThe pilot experiencced spatial disorientation, lost control of the airplane during a spin maneuver and collided with the ground.NTSB NYC91LA011Accident · No injuriesLimited investigationFinal reportRobinson R22 · Woonsocket, RIPilot's failure to maintain sufficient altitude above the terrain to avoid getting the right skid caught in the grass, resulting in a loss of control.NTSB CHI91GA014Accident · 1 fatalFinal reportCessna 172P · Williamsburg, IAThe pilot-in-command's abrupt pull-up to avoid an obstacle. Contributing was the pilot-in-command's diverted attention to activities on the ground.NTSB NYC91DNC01Accident · 2 fatalFinal reportSkytek Skyseeker MK II · Chapman, MEIn-flight failure of the outboard section of the wing, and the loss of aircraft control. Due to the unauthorized structural modification by the pilot/owner.NTSB FTW91DPG01Accident · Minor injuriesFinal reportCessna A-188 · Manila, ARThe pilot's failure to maintain proper clearance from power lines and the inadvertent stall.