NTSB investigations
18,850 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 CEN25LA297Accident · Serious injuriesClass 3 · LimitedPreliminary reportAyres S2R · Akron, IAOn July 28, 2025, about 1537 central daylight time, an Ayres Corporation S2R-T34 airplane, N524SL, sustained substantial damage when it was involved in an accident near Akron, Iowa. The pilot sustained serious injuries. The airplane was operated as a Title 14…NTSB CEN25FA289Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-22-150 · New Underwood, SDOn July 28, 2025, about 0604 mountain daylight time, a Piper PA-22-150 airplane, N9642D, was substantially damaged when it was involved in an accident near New Underwood, South Dakota. The pilot was seriously injured and the passenger sustained fatal…NTSB CEN25LA292Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · North Bend, NEThe pilot’s failure to maintain clearance from wires while maneuvering at a low altitude, and the ground crew failure to inform the pilot that the support truck had been moved.NTSB ERA25LA287Accident · No injuriesClass 4 · LimitedFinal reportGrob-Werke Twin Astir · Franconia, NHThe pilot’s failure to detect the inadvertent deployment of the spoilers, which resulted in a prolonged, excessive descent rate. Contributing to the accident was the pilot’s decision to conduct a downwind approach versus a straight in approach to the…NTSB CEN25LA286Accident · Minor injuriesClass 4 · LimitedFinal reportWeatherly 620B · Rushmore, MNThe pilot’s failure to maintain clearance from a tree during low-level maneuvering.NTSB CEN25LA285Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · Walcott, IAThe pilot’s failure to maintain clearance from the crops during an aerial application flight.NTSB CEN25LA283Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-301 · Hartsburg, ILThe pilot’s failure to maintain control of the airplane during takeoff with a tailwind from a wet turf airstrip.NTSB CEN25FA281Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron 206L-1 · Thibodaux, LAThe pilot’s failure to maintain clearance to powerlines during an agricultural application pass.NTSB GAA25WA244Accident · 2 fatalClass 3 · ForeignProMecc Aerosapce Freccia FG · Azzano Mella, ItalyNTSB CEN25LA277Accident · No injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R66 · Maynard, IAOn July 22, 2025, about 1400 central daylight time, a Robinson Helicopter Company R66 helicopter, N88911, was substantially damaged when it was involved in an accident near Maynard, Iowa. The pilot was uninjured. The helicopter was operated under Title 14…NTSB CEN25LA276Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-402A · Centralia, MOThe pilot’s failure to maintain clearance from power lines during low-level maneuvering.NTSB CEN25LA274Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Hastings, NEThe pilot’s failure to maintain clearance from powerlines while maneuvering at low altitude.NTSB CEN25FA273Accident · 1 fatalClass 3 · FieldPreliminary reportCessna T188C · Oregon, ILOn July 22, 2025, about 0930 central daylight time, a Cessna T188C, N2802J, was substantially damaged when it was involved in an accident near Oregon, Illinois. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB WPR25LA216Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Concrete, WAThe pilot’s failure to maintain clearance from powerlines, which resulted in a wire strike.NTSB ENG25WA056AccidentClass 5 · ForeignAgustaWestlands AW119 Mkii · Britânia, state of Goiás, BrazilNTSB CEN25LA266Accident · Minor injuriesClass 4 · LimitedFinal reportBell B206-B · Bloomington, ILThe pilot’s failure to avoid power lines during an aerial application flight.NTSB CEN25FA247Accident · 1 fatalClass 3 · FieldPreliminary reportZenith CH601 · Pawnee National Grassland, COOn July 12, 2025, about 1250 mountain daylight time, a Zenith CH601 HDS airplane, N314LB was destroyed when it was involved in an accident in the Pawnee National Grasslands, Colorado. The pilot was fatally injured. The airplane was operated under the…NTSB WPR25LA209Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Colorado City, AZThe pilot’s exceedance of the airplane’s never-exceed speed (VNE) during maneuvering, which resulted in the in-flight separation of the left flaperon.NTSB CEN25LA240Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CCK-1865 · La Garita, COThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude in mountainous terrain. Contributing was the pilot’s inadequate preflight planning and aeronautical decision making.NTSB ERA25LA259Accident · No injuriesClass 4 · LimitedFinal reportRobbins C/Robbins J Rotorway Exec 162F · Towanda, PAAn in-flight fire for reasons that could not be determined due to the extent of fire damage.NTSB CEN25LA237Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Pecos, TXThe pilot’s failure to maintain aircraft control during gusty wind conditions.NTSB GAA25WA225AccidentClass 5 · ForeignRobinson R22 · Anthony Lagoon, AustraliaNTSB CEN25LA231Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Lockport, LAThe pilot’s inadequate planning for the high density altitude conditions which resulted in reduced airplane performance, climb capability, and subsequent forced landing.NTSB GAA25WA226Accident · Minor injuriesClass 5 · ForeignAir Tractor AT301 · Cienaga, ColombiaNTSB CEN25FA224Accident · 2 fatalClass 3 · FieldPreliminary reportVans RV-10 · Capron, ILOn June 28, 2025, about 0934 central daylight time, a Vans RV-10 airplane, N847CS, was substantially damaged during an accident near Capron, Illinois. The pilot and flight instructor were fatally injured. The airplane was operated as a Title 14 Code of…NTSB ERA25LA240Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Hawesville, KYThe pilot’s failure to maintain clearance from power lines during low-level agricultural spray operations.NTSB CEN25LA221Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-402B · Pierre, SDThe pilot’s failure to maintain clearance with the power lines while maneuvering that resulted in an in-flight collision with the power lines and impact with terrain.NTSB ERA25LA237Accident · Minor injuriesClass 3 · LimitedFinal reportGyro Technic GT-VX2 · Swanzey, NHThe pilot’s failure to maintain rotor rpm of the gyroplane during a low approach, while distracted by other aircraft in the airport traffic pattern, which resulted in the pilot’s decision to perform an off-runway landing.NTSB CEN25LA219Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Charleston, MOThe pilot’s loss of control during the spray pass, which resulted in impact with vegetation and terrain.NTSB WPR25FA182Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172 · Billings, MTOn June 19, 2025, at 1412 mountain daylight time, a Cessna 172K airplane, N79306, was destroyed when it was involved in an accident near Billings, Montana. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB ERA25FA230Accident · 2 fatalClass 3 · FieldFinal reportMooney M20F · Beverly, MAThe pilot’s failure to maintain control of the airplane while maneuvering to return to the airport which resulted in an aerodynamic stall. Contributing to the accident was the improperly installed No. 2 cylinder bottom spark plug by maintenance personnel,…NTSB CEN25LA218Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-36-375 · Huron, SDThe pilot’s exceedance of the airplane’s critical angle of attack during a low-level aerial application, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover.NTSB ERA25FA228Accident · 2 fatalClass 3 · FieldPreliminary reportBeech 58 · Tabor City, NCOn June 14, 2025, at 1245 eastern daylight time, a Beech 58 airplane, N82UC, was destroyed when it was involved in an accident near Tabor City, North Carolina. The private pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code…NTSB ERA25LA229Accident · Minor injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R66 · Valparaiso, FLOn June 12, 2025, about 1850 eastern daylight time, a Robinson Helicopter R66, N633AF, was substantially damaged when it was involved in an accident near Valparaiso, Florida. The pilot and passenger sustained minor injuries, and a second passenger was not…NTSB CEN25FA198Accident · 1 fatalClass 3 · FieldPreliminary reportAeronca 7AC · Waterman, ILOn June 7, 2025, about 1459 central daylight time, an Aeronca 7AC airplane, N1846E, sustained substantial damage when it was involved in an accident near Waterman, Illinois. The pilot was fatally injured, and the passenger was seriously injured. The airplane…NTSB CEN25LA206Accident · No injuriesClass 3 · LimitedPreliminary reportXag P100 PRO · Pontiac, ILOn June 5, 2025, at 1155 central daylight time, a XAG P100 Pro, N231CU, was substantially damaged when it was involved in an accident near Pontiac, Illinois. The unmanned aerial system (UAS) was operated under Title 14 Code of Federal Regulations as a Part…NTSB ERA25LA217Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-23 · Palm Bay, FLA loss of engine power to both of the airplane’s engines due to fuel exhaustion and fuel starvation.NTSB CEN25LA191Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-401 · Hamlet, NEThe pilot's failure to maintain clearance from the power lines during low altitude maneuvering.NTSB WPR25LA165Accident · No injuriesClass 4 · LimitedFinal reportWeatherly 620B · Lewiston, MTThe pilot’s failure to maintain clearance from terrain while maneuvering at a low altitude.NTSB CEN25FA184Accident · 2 fatalClass 3 · FieldPreliminary reportRockwell Commander 114A · Hankamer, TXOn May 24, 2025, about 1658 central daylight time (CDT), a Rockwell Commander 114A airplane, N5903N, was destroyed when it was involved in an accident near Hankamer, Texas. The private pilot and passenger were fatally injured. The airplane was operated under…NTSB GAA25WA158Incident · No injuriesClass 5 · ForeignAir Tractor AT602 · St George Aerodrome, AustraliaNTSB GAA25WA155Accident · 1 fatalClass 5 · ForeignCessna 182 · Allen, ArgentinaNTSB GAA25WA144Accident · 1 fatalClass 5 · ForeignCessna 188 · Sangkiang Village, Papua New GuineaNTSB GAA25WA150Accident · 1 fatalClass 5 · ForeignAyres S2R · SãO José Do Rio Claro, BrazilNTSB CEN25LA161Accident · No injuriesClass 4 · LimitedFinal reportChampion Aeronca 7AC · Estherwood, LAThe non-certificated pilot’s failure to maintain altitude while maneuvering at low altitude that resulted in a descent and impact into terrain.NTSB CEN25LA155Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver MX II · Brady, TXThe airplane’s encounter with a dust devil, which resulted in a loss of airplane control at a low altitude.NTSB CEN25FA151Accident · 1 fatalClass 3 · FieldPreliminary reportAeronca 7AC · Cape Fair, MOOn April 10, 2025, at 0904 central daylight time, an Aeronca 7AC airplane, N83952, was substantially damaged when it was involved in an accident near Cape Fair, Missouri. The pilot received serious injuries, and the passenger was fatally injured. The airplane…NTSB CEN25LA149Accident · Serious injuriesClass 3 · LimitedFinal reportPphu Ekolot KR-030 Topaz · Platteville, WIThe pilot’s failure to maintain clearance from terrain for reasons which could not be determined.NTSB ERA25LA181Accident · Serious injuriesClass 4 · LimitedFinal reportSchleicher ASW-19 · Zephyrhills, FLThe pilot’s inadequate inflight planning and an encounter with atmospheric conditions where the lift was not sufficient to maintain flight, resulting in an off-airport landing and collision with a fence.NTSB CEN25LA140Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · Cash, ARThe pilot’s failure to maintain clearance from an excavator during low-altitude aerial application operations.