OpenAirDocs.org

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.

NTSB GAA23WA123Accident · Minor injuriesClass 4 · ForeignCessna T188 · Recinto Estero Claro, EcuadorApr 3, 2023 · HC-BRN · Substantial damageNTSB ERA23FA175Accident · 2 fatalClass 3 · FieldFinal reportAirbus Helicopters EC 130 T2 · Chelsea, ALThe pilot’s delayed corrective inputs while maneuvering, which resulted in a loss of control. Contributing to the accident was the pilot’s use of multiple sedating medications.Apr 2, 2023 · N231SH · Substantial damageNTSB WPR23LA145Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Elko, NVThe pilot’s failure to maintain sufficient altitude and airspeed in gusting tailwind conditions that resulted in an unrecoverable descent and impact with terrain.Apr 1, 2023 · N462BA · Substantial damageNTSB WPR23FA138Accident · 1 fatalClass 3 · FieldFinal reportAerotrike Cobra · Santa Teresa, NMThe pilot’s exceedance of the aircraft’s critical angle of attack, which resulted in an aerodynamic stall.Apr 1, 2023 · UNREG · DestroyedNTSB ERA23LA172Accident · Minor injuriesClass 4 · LimitedFinal reportHelicopteres Guimbal Cabri G2 · Clarksville, TNThe flight instructor’s inadequate remedial action following an abrupt control input by the student pilot, which resulted in abnormal contact with the ground and a dynamic rollover.Mar 29, 2023 · N242JL · Substantial damageNTSB CEN23LA147Accident · Minor injuriesClass 4 · LimitedFinal reportBell OH-58A · Wade, OKThe total loss of engine power due to fuel contamination.Mar 29, 2023 · N82851 · Substantial damageNTSB CEN23FA144Accident · 1 fatalClass 3 · FieldFinal reportZenith Stol CH701 · Oxford, MSAn in-flight collision with trees and terrain for undetermined reasons.Mar 29, 2023 · N43414 · DestroyedNTSB GAA23WA108Accident · 1 fatalClass 5 · ForeignGrumman G164 · Comercial, UruguayMar 27, 2023 · CX-BTI-R · Substantial damageNTSB CEN23FA142Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Port Allen, LAThe pilot’s decision to continue the visual flight rules flight into deteriorating weather conditions, which resulted in spatial disorientation and the loss of aircraft control.Mar 26, 2023 · N441PD · DestroyedNTSB ERA23FA163Accident · 1 fatalClass 3 · FieldFinal reportLarry F Preiss AR-1 · Gainesville, GAThe pilot's inadequate preflight inspection and his failure to detect water-contaminated fuel that resulted in a loss of engine power and subsequent impact with a wire and terrain during an attempted forced landing.Mar 25, 2023 · N47AR · Substantial damageNTSB ANC23FA031Accident · 2 fatalClass 3 · FieldFinal reportBell Helicopter Textron 407 · Nuevo, CAThe pilot’s decision to maneuver in a steep bank at a low altitude, which resulted in his failure to maintain clearance with terrain.Mar 24, 2023 · N14Z · DestroyedNTSB GAA23WA110Accident · No injuriesClass 4 · ForeignEmbraer EMB201 · Nova Ubirata, BrazilMar 22, 2023 · PT-UCL · Substantial damageNTSB WPR23LA131Accident · Minor injuriesClass 4 · LimitedFinal reportMaule M-4-220C · Santa Ynez, CAThe pilot’s inadequate fuel planning, which resulted in a loss of engine power due to fuel starvation.Mar 18, 2023 · N40635 · Substantial damageNTSB GAA23WA101Accident · Minor injuriesClass 5 · ForeignEmbraer EMB202 · Porto dos Gauchos, MT, BrazilMar 13, 2023 · PT-UTG · Substantial damageNTSB WPR23LA128Accident · Serious injuriesClass 3 · LimitedFinal reportJones Jay D Cassutt M 11 · Castroville, CAA failure of the outboard trailing edge rib in the left wing, which resulted in a separation of the left aileron and a loss of control.Mar 12, 2023 · N55XJ · Substantial damageNTSB WPR23LA126Accident · Minor injuriesClass 4 · LimitedFinal reportTrendak Taurus · Strawberry Reservoir, UTThe pilot’s failure to maintain clearance from the snow-covered lake while flying at a low altitude.Mar 11, 2023 · N553AT · Substantial damageNTSB CEN23LA130Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · De Kalb, TXThe pilot’s inability to maintain control of the helicopter due to his failure to maintain rotor speed. Contributing to the accident was the failure of the helicopter’s low rotor speed warning system.Mar 11, 2023 · N4164T · Substantial damageNTSB WPR23FA122Accident · 1 fatalClass 3 · FieldFinal reportRockwell International S-2R · Willows, CAThe pilot’s failure to maintain clearance from powerlines while flying under multiple conductors during a low-altitude aerial application flight, which resulted in propeller contact with a powerline and a subsequent loss of control.Mar 8, 2023 · N8424V · Substantial damageNTSB ERA23LA141Accident · No injuriesClass 3 · LimitedFinal reportCessna 172M · Miami, FLA total loss of engine power due to a lack of oil lubrication.Mar 7, 2023 · N64535 · Substantial damageNTSB ERA23FA138Accident · 2 fatalClass 3 · FieldFinal reportDiamond Aircraft Ind DA 40 · West Palm Beach, FLThe pilots’ exceedance of the airplane’s critical angle of attack following a go-around/low pass over the runway, which resulted in a loss of control and impact with terrain.Mar 6, 2023 · N804ER · Substantial damageNTSB GAA23WA096Accident · 1 fatalClass 5 · ForeignPitts S1S · Trenque Lauquen, ArgentinaMar 4, 2023 · LX-X768 · DestroyedNTSB WPR23LA120Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Vernalis, CAThe pilot’s failure to maintain clearance from a power line during a low-level aerial application flight.Mar 3, 2023 · N48492 · Substantial damageNTSB WPR23LA118Accident · No injuriesClass 4 · LimitedFinal reportBell UH-1B · Orland, CAThe pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a loss of engine power.Mar 2, 2023 · N234SJ · Substantial damageNTSB GAA23WA085Accident · Serious injuriesClass 5 · ForeignMcdonnell Douglas 500 · Dansey Pass, Livingston, New ZealandMar 2, 2023 · ZK-IES · DestroyedNTSB WPR23FA110Accident · 2 fatalClass 3 · FieldFinal reportWillman Loren LOREN'S Aircam · Grass Valley, CAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall/spin at an altitude too low for recovery.Feb 19, 2023 · N420PF · Substantial damageNTSB CEN23LA114Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Venus, TXThe loss of engine power for undetermined reasons.Feb 18, 2023 · N6536G · Substantial damageNTSB WPR23LA112Accident · 1 fatalClass 3 · LimitedFinal reportStar Lite SL1 · Corning, CAThe student pilot’s loss of airplane control during an intentional aerobatic maneuver, which resulted in an inflight separation of the left wing and subsequent impact with the terrain.Feb 16, 2023 · UNREG · DestroyedNTSB GAA23WA078Accident · No injuriesClass 5 · ForeignEmbraer EMB201 · Santa Vitoria do Palmar, BrazilFeb 16, 2023 · PT-UDU · Substantial damageNTSB WPR23LA107Accident · Minor injuriesClass 3 · LimitedFinal reportBell OH-58A · Yuma, AZA total loss of engine power for reasons that could not be determined.Feb 7, 2023 · N36FA · Substantial damageNTSB WPR23LA105Accident · No injuriesClass 4 · LimitedFinal reportHughes 269C · Yakima, WAThe pilot's failure to see and avoid a powerline while flying at low altitude over a river.Feb 6, 2023 · N7452F · Substantial damageNTSB DCA23WA150Accident · Minor injuriesClass 5 · ForeignBoeing 737-3H4 · Womarden, AustraliaFeb 6, 2023 · N619SW · DestroyedNTSB WPR23LA103Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Porterville, UTThe pilot’s failure to maintain clearance from snow covered terrain while maneuvering at low altitude.Feb 4, 2023 · N3969B · Substantial damageNTSB WPR23LA097Accident · No injuriesClass 3 · LimitedFinal reportKaman Aerospace K-1200 · Sweet Home, ORImproper installation of the hardware retaining the adjustment screw in the N2 topping governor lever and roller assembly, which resulted in a partial loss of engine power.Jan 24, 2023 · N202WM · Substantial damageNTSB ERA23LA117Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Buford, GAWater contamination in the fuel system that was not observed during the preflight inspection, resulting in a total loss of engine power and forced landing.Jan 24, 2023 · N7470R · Substantial damageNTSB CEN23LA093Accident · 1 fatalClass 4 · LimitedFinal reportCirrus Design SR20 · Indianapolis, INThe pilot’s intentional flight into terrain as an act of suicide.Jan 24, 2023 · N99EC · DestroyedNTSB ERA23LA115Accident · Minor injuriesClass 4 · LimitedFinal reportEiriavion PIK-20D · Benton, TNThe pilot’s decision to turn toward a mountain ridge in a thermal, which resulted in a collision with terrain.Jan 20, 2023 · N1NZ · Substantial damageNTSB CEN23FA079Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-301T · Kingfisher, OKAn oil leak of undetermined origin that resulted in an in-flight engine compartment fire and subsequent loss of airplane control.Jan 16, 2023 · N8266D · DestroyedNTSB CEN23LA081Accident · Serious injuriesClass 3 · LimitedFinal reportPitts Model 12 · Conroe, TXThe failure of the engine-driven fuel pump, which resulted in a total loss of engine power. Contributing to the failure of the fuel pump was an unknown non-ferrous metallic debris that was noted throughout the airplane’s fuel system.Jan 14, 2023 · N512P · Substantial damageNTSB GAA23WA054AccidentClass 5 · ForeignAir Tractor AT504 · Changuinoia, PanamaJan 10, 2023 · HP-1955AT · 2 aircraft · Substantial damageNTSB CEN23LA086Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Fowlerton, TXThe pilot’s failure to maintain clearance with trees, which resulted in an uncontrollable spin due to tail rotor damage.Jan 10, 2023 · N811S · Substantial damageNTSB GAA23WA053AccidentClass 4 · ForeignCessna 152 · Madhya Pradesh, IndiaJan 1, 2023 · VT-PTE · DestroyedNTSB CEN23LA063Accident · No injuriesClass 4 · LimitedFinal reportRockwell International S2R-G6 · Mission, TXThe pilot's failure to maintain clearance from an electrical box.Dec 6, 2022 · N4205X · Substantial damageNTSB WPR23LA053Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-180 · Morgan, UTThe pilot’s failure to maintain clearance from snow covered terrain while maneuvering at low attitude. Contributing to the accident was the pilot’s loss of visual reference due to snow and flat light conditions.Dec 3, 2022 · N60WY · Substantial damageNTSB CEN23LA058Accident · Minor injuriesClass 4 · LimitedFinal reportStinson 108-3 · Regent, NDThe pilot failed to maintain clearance from high tension wires while maneuvering at low altitude.Dec 3, 2022 · N7659X · Substantial damageNTSB GAA23WA039Accident · 5 fatalClass 5 · ForeignCenterpoint Aerospace S-58T · Yang Yang, South KoreaNov 27, 2022 · HL9678NTSB ERA23LA073Accident · No injuriesClass 3 · LimitedFinal reportChilds Michael A Rotorway Exec 162-F · Titusville, FLA failure of the No. 4 exhaust valve spring retainer, which resulted in a partial loss of engine power.Nov 27, 2022 · N8006A · Substantial damageNTSB CEN23LA049Accident · No injuriesClass 3 · LimitedFinal reportCessna 182A · Durango, COA complete loss of engine power for reasons that could not be determined from the available evidence.Nov 24, 2022 · N3886D · Substantial damageNTSB ERA23FA070Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 · Charlotte, NCThe inadequate inspections of the forward left control rod end attachment hardware to the stationary swashplate by the pilot and by maintenance personnel, resulting in an eventual loosening and backing out of the hardware and subsequent loss of helicopter…Nov 22, 2022 · N7094J · Substantial damageNTSB CEN23LA047Accident · Minor injuriesClass 4 · LimitedFinal reportSeace David A Gyroplane · Iredell, TXThe pilot's failure to maintain clearance from a power line during low-level maneuvering.Nov 22, 2022 · N44088 · Substantial damageNTSB GAA23WA032Accident · Serious injuriesClass 5 · ForeignRobinson R44 · Richmond, AustraliaNov 19, 2022 · VH-TKI · Substantial damage