NTSB investigations
18,849 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 CEN24LA205Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Palmyra, MOThe pilot’s failure to maintain clearance from power lines during approach.NTSB ERA24LA229Accident · Serious injuriesClass 3 · LimitedFinal reportGreat Lakes 2T-1(Menasco Special) · Salisbury, MDThe pilot’s exceedance of the airplane’s critical angle of attack, resulting in an aerodynamic stall and loss of control.NTSB ERA24LA228Accident · Serious injuriesClass 3 · LimitedFinal reportSchleicher ASH 31 MI · Winter Haven, FLThe pilot’s failure to ensure that a suitable landing area was available in case the restart of the motor glider’s engine was unsuccessful. Contributing, was insufficient battery charge to extend the motor glider’s pylon assembly.NTSB CEN24LA193Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-502 · Covert, KSThe improper maintenance of the fuel control unit, which resulted in air leakage and a loss of control of fuel flow to the engine.NTSB ERA24LA220Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · New Washington, OHThe pilot’s failure to maintain clearance from powerlines during an aerial application flight.NTSB GAA24WA174Accident · Minor injuriesClass 5 · ForeignPiper PA25 · Lorenzo de Garaicoa, EcuadorNTSB CEN24FA188Accident · 1 fatalClass 3 · FieldFinal reportCessna 150L · Godley, TXThe student pilot’s failure to maintain airplane control while practicing a power-on stall, which resulted in an inadvertent spin at an altitude from which he was unable to recover.NTSB WPR24FA150Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-18-150 · Thurlow, MTThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, resulting in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s distraction by his cell phone use while…NTSB WPR24LA139Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · Olympia, WAThe flight instructor’s delayed action to arrest the descending, left pedal turn while maneuvering for a low-altitude hover with the helicopter near the maximum gross weight limitation, which resulted in an impact with the ground and a dynamic rollover.NTSB WPR24LA138Accident · Minor injuriesClass 4 · LimitedFinal reportAerospatiale SA315B · Lewiston, IDThe pilot’s failure to maintain clearance from power lines during a low level aerial application.NTSB ERA24LA205Accident · No injuriesClass 3 · LimitedFinal reportAirbus Helicopters AS350B3 · Plant City, FLThe pilot’s inadequate yaw control of the helicopter while maneuvering at a low altitude and airspeed, which resulted in a hard landing.NTSB CEN24LA175Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · England, ARThe pilot’s failure to maintain clearance from tower guy wires while maneuvering during a low-level aerial application flight.NTSB WPR24LA134Accident · No injuriesClass 3 · LimitedFinal reportBell 206L-3 · Tracy, CAA loss of collective control authority due to fatigue failure of the collective servo cylinder extension arms from corrosion pitting.NTSB ENG24WA038Incident · No injuriesClass 3 · ForeignDornier 328 · Zurich, SwitzerlandNTSB GAA24WA149Accident · Minor injuriesClass 5 · ForeignBell 206 · State of Mato Grosso do Sul, MS, BrazilNTSB GAA24WA173AccidentClass 5 · ForeignPiper PA-25 · Trissa Charkaoua, MoroccoNTSB GAA24WA143Accident · 2 fatalClass 5 · ForeignExtra 300 · Tokol, Hungary, HungaryNTSB CEN24LA162Accident · No injuriesClass 3 · LimitedFinal reportAmerican Champion 7ECA · Longview, TXThe rudder post’s failure due to corrosion fatigue. Contributing to the accident were the misalignment of the rudder hinge components, which produced mechanical binding and elevated localized stress, and a compromised the protective coating, which allowed…NTSB WPR24FA123Accident · 1 fatalClass 3 · FieldFinal reportAyres S2R-G10 · Derner, CAThe pilot’s failure to adequately monitor his fuel supply, resulting in fuel exhaustion, a total loss of engine power, and the airplane’s impact with terrain.NTSB ERA24LA172Accident · No injuriesClass 4 · LimitedFinal reportMD Helicopters 369FF · Ceiba, PRThe pilots’ failure to ensure adequate clearance from the taxiway while performing a quick stop maneuver.NTSB ERA24LA171Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · South Kingstown, RIThe pilot’s failure to maintain clearance from the water while maneuvering at low altitude.NTSB ANC24LA021Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Huasna, CAThe pilot’s failure to maintain adequate airspeed during a low altitude maneuver, resulting in a loss of control.NTSB WPR24LA117Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Acton, CAThe pilots inability to fully turn off the carburetor heat which resulted in a reduction of engine power and reduced climb performance. Contributing to the accident was the pilots delayed recovery from the simulated emergency landing.NTSB GAA24WA132Accident · 1 fatalClass 5 · ForeignCessna A188 · Lucas Do Rio Verde, BrazilNTSB ERA24LA148Accident · Serious injuriesClass 3 · LimitedFinal reportHughes 369D · Belleville, WVThe ingestion of foreign object debris into the engine, which resulted in a sudden loss of engine power and a subsequent collision with trees and terrain during the forced landing.NTSB WPR24LA113Accident · Minor injuriesClass 4 · LimitedFinal reportKitfox S7 Super Sport · Asotin, WAPilot’s failure to maintain clearance from powerlines during low altitude flying.NTSB CEN24LA137Accident · No injuriesClass 3 · LimitedFinal reportEnstrom Helicopter 280C · Port Lavaca, TXThe pilot’s improper manual engine mixture management which resulted in a loss of power. Contributing to the accident was the mechanic’s improper setting of the idle mixture adjustment and the pilot’s decision to take off with a known mechanical deficiency.NTSB WPR24LA115Accident · Minor injuriesClass 4 · LimitedFinal reportZenith Zodiac CH601 · Rawlins, WYThe student pilot’s failure to see and avoid powerlines during an unstabilized approach, which resulted the airplane landing short of the runway and coming to rest inverted.NTSB WPR24FA104Accident · 1 fatalClass 3 · FieldFinal reportKolb Firestar KXP · Cave Junction, ORThe pilot's exceedance of the airplane's critical angle of attack during a turn, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's use of potentially impairing substances with bipolar disorder, which resulted in a decreased…NTSB GAA24WA108AccidentClass 5 · ForeignCessna 172M · Wilson Airport, KenyaNTSB GAA24WA142AccidentClass 5 · ForeignRockwell Commander · Dortmond, GermanyNTSB WPR24LA094Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 7AC · Valley Springs, CAThe pilot’s decision to maneuver the airplane at a low altitude and inadvertently entering a box canyon where the airplane could not outclimb the rising terrain.NTSB WPR24LA093Accident · Minor injuriesClass 3 · LimitedFinal reportBell 47G-3B-1 · Garey, CAMaintenance personnel’s failure to properly check the torque paint on a fuel control unit B-nut, which resulted in the loosening of the B-nut, a loss of engine power at a low altitude, and a subsequent impact with terrain.NTSB ERA24LA216Accident · Serious injuriesClass 3 · LimitedFinal reportApellix B1 Washing Drone · Orlando, FLA failure of the sUAS’s magnetometer while operating in close proximity to commercial air conditioning equipment, which resulted in the sUAS’s erratic maneuvering. Contributing to the accident was the RPIC’s failure to input the appropriate command to disarm…NTSB GAA24WA119Incident · No injuriesClass 5 · ForeignAgusta AW139 · Kawajima, JapanNTSB ANC24LA015Accident · No injuriesClass 4 · LimitedFinal reportCessna R172K · Trapper Creek, AKThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall; loss of airplane control; and impact with terrain.NTSB ERA24LA114Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172M · Brookwood, ALThe pilot’s failure to see and avoid powerlines while maneuvering at low altitude.NTSB GAA24WA100AccidentClass 5 · ForeignBell 407 · Midrand, South AfricaNTSB GAA24WA093AccidentClass 5 · ForeignAir Tractor AT-502 · Bourke, AustraliaNTSB WPR24FA083Accident · 2 fatalClass 2 · FieldFinal reportHawker Beechcraft Hawker 900XP · Westwater, UTThe flight crew’s decision to conduct a post-maintenance stall test in an area of icing conditions, which resulted in wing contamination that significantly decreased the airplane’s critical angle of attack. Also causal was the airplane manufacturer’s lack of…NTSB CEN24LA104Accident · No injuriesClass 3 · LimitedFinal reportPiper PA24 · Cherokee, OKA partial loss of engine power for reasons that could not be determined. Contributing to the accident was the presence of ground fog, which hindered the landing approach and resulted in the pilot inadvertently landing long and impacting a fence during the…NTSB CEN24LA110Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Taurus · Waller, TXThe failure of both pilots to see and avoid one another while maneuvering, which resulted in a mid-air collision.NTSB GAA24WA081Accident · Minor injuriesClass 5 · ForeignHughes 369 · Erharting, GermanyNTSB CEN24FA101Accident · 2 fatalClass 3 · FieldFinal reportLockwood AIR CAM · Ranchitos Las Lomas, TXThe pilot's failure to maintain clearance from a meteorological evaluation tower.NTSB ERA24FA097Accident · Serious injuriesClass 3 · FieldFinal reportBeech C99 · Londonderry, NHThe pilot’s failure to ensure that the cockpit door was secured before flight, which resulted in its separation during initial climb and a subsequent loss of control.NTSB CEN24LA099Accident · 1 fatalClass 4 · LimitedFinal reportTextron 172S · Direct, TXThe pilot died by suicide.NTSB ERA24LA099Accident · No injuriesClass 3 · LimitedFinal reportSwissdrones Operating SDO 50 V2 · Antioch, GAA partial loss of engine power due to a reduction of fuel flow for undetermined reasons. Contributing to the accident was the UAS manufacturer’s lack of instructions for a partial loss of engine power landing.NTSB GAA24WA070AccidentClass 5 · ForeignThrush S2R · Región del Maule, ChileNTSB WPR24FA072Accident · 4 fatalClass 3 · FieldFinal reportKubicek BB85Z · Eloy, AZThe pilot’s decision to open the rapid deflation valve during flight as a means of descending, which resulted in the deflation of the envelope and hard impact with terrain.NTSB ERA24FA088Accident · 3 fatalClass 3 · FieldFinal reportBeech 95-B55 (T42A) · Leyden, MAThe flight instructor’s failure to maintain airplane control during a stall, which resulted in an inadvertent spin from which the airplane was not recovered. Contributing to the accident were the overall effect of the flight instructor’s use of multiple…