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 GAA22WA198AccidentClass 5 · ForeignCessna 206 · Punaauia, French PolynesiaJun 7, 2022 · F-BXAM · Substantial damageNTSB CEN22LA234Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Henderson, TXThe partial loss of engine power in a hover due to a stuck exhaust valve.Jun 6, 2022 · N94WC · Substantial damageNTSB WPR22LA202Accident · Minor injuriesClass 3 · LimitedFinal reportFischer Super Koala · Chelan, WAA total loss of engine power for undetermined reasons.Jun 5, 2022 · UNREG · Substantial damageNTSB GAA22WA199Accident · 3 fatalClass 5 · ForeignBell 206 · Currais Novos, BrazilJun 5, 2022 · PP-MCJ · DestroyedNTSB ERA22LA258Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BC12-D1 · Pittsboro, NCThe student pilot, and flight instructor’s, inadequate preflight inspection, during which they failed to detect water contamination in the fuel system, which resulted in a total loss of engine power.Jun 3, 2022 · N44374 · Substantial damageNTSB WPR22FA195Accident · 1 fatalClass 3 · FieldFinal reportMeyer Fred J Hornet · Lucerne Valley, CAThe pilot’s failure to maintain altitude during an aerobatic maneuver, which resulted in an impact with terrain.Jun 2, 2022 · N6366M · Substantial damageNTSB CEN22FA223Accident · 2 fatalClass 3 · FieldFinal reportAeronca 7AC · Bowling Green, MOThe pilots’ failure to maintain adequate airspeed while maneuvering, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.Jun 2, 2022 · N1976E · Substantial damageNTSB CEN22LA219Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206B · Cameron, TXThe flight crew not maintaining lateral control of the helicopter during hovering operation which resulted in a dynamic rollover.May 31, 2022 · N27574 · Substantial damageNTSB ERA22FA243Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-12 · North Myrtle Beach, SCThe pilot's exceedance of the airplane's critical angle of attack, which resulted in a subsequent aerodynamic stall at an altitude that was too low for recovery.May 28, 2022 · N4421M · Substantial damageNTSB GAA22WA194Accident · No injuriesClass 5 · ForeignBell 206 · Riohacha, Guajira, ColombiaMay 27, 2022 · HK5268 · Substantial damageNTSB CEN22LA226Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · Weiner, ARThe pilot’s failure to maintain clearance from the telephone pole during a low-level aerial application pass.May 27, 2022 · N579LA · DestroyedNTSB ERA22LA256Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · North Myrtle Beach, SCThe fractured attachment lug on the forward clutch shaft yoke due to fatigue failure with multiple origins.May 26, 2022 · N132TC · Substantial damageNTSB CEN22FA211Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-12 · Seagraves, TXThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering, which resulted in an aerodynamic stall/spin and loss of control.May 24, 2022 · N78466 · DestroyedNTSB ERA22LA238Accident · No injuriesClass 4 · LimitedFinal reportMX MXS · Bealeton, VAAn inflight collision with a bird while conducting low level aerobatics.May 22, 2022 · N104MX · Substantial damageNTSB WPR21LA368Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Sacramento, CAThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.May 21, 2022 · N8521V · Substantial damageNTSB CEN22FA203Accident · 1 fatalClass 3 · FieldFinal reportAmerican AA-1A · Cleburne, TXThe student pilot’s decision to operate the airplane after consuming alcohol, which led to an exceedance of the airplane’s critical angle of attack, an aerodynamic stall, and a subsequent loss of control at a low altitude.May 17, 2022 · N6409L · Substantial damageNTSB WPR22LA183AccidentClass 4 · LimitedFinal reportPyka Pelican · Winters, CADelamination of the uncrewed aircraft systems’ right wing skin surfaces from the wing spar that resulted in a spin and impact with terrain.May 14, 2022 · N605PK · Substantial damageNTSB CEN22LA200Accident · Minor injuriesClass 4 · LimitedFinal reportThrush S2R-H80 · Aurora, MOThe pilot did not ensure clearance from a power line during a surveillance pass of a field to be sprayed.May 12, 2022 · N510KK · Substantial damageNTSB WPR22LA174Accident · Serious injuriesClass 3 · LimitedFinal reportBell Helicopter Textron Canada 407 · Livermore, CALoss of engine power due to the pilot inadvertently selecting engine IDLE mode while in flight, which reduced rotor and engine speed to a level that could not sustain flight.May 11, 2022 · N999GH · Substantial damageNTSB ERA22LA224Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT-301 · Somerville, TNThe inadequate inspection and maintenance of the engine exhaust system, which resulted in an in-flight fire.May 11, 2022 · N31580 · Substantial damageNTSB WPR22FA173Accident · 2 fatalClass 3 · FieldFinal reportBlue Side UP Comp AIR 8 SS52 · Grasmere, IDThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.May 8, 2022 · N801DT · Substantial damageNTSB GAA22WA175Accident · Minor injuriesClass 5 · ForeignPiper PA25 · Clan Airfield, South AfricaMay 3, 2022 · ZS-AWX · Substantial damageNTSB GAA22WA171Accident · 4 fatalClass 5 · ForeignPiper PA28 · Sioux Lookout Ontario, CanadaApr 30, 2022 · C-GLKD · Substantial damageNTSB WPR22LA168Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Folsom, NMThe pilot’s failure to maintain airspeed and rotor rpm which resulted in a hard landing.Apr 28, 2022 · N41339 · Substantial damageNTSB ERA22LA209Accident · Minor injuriesClass 4 · LimitedFinal reportGarlick Helicopters OH-58A+ · Oakland, FLThe pilot’s decision to continue the low-altitude aerial application flight over water conditions that degraded his depth perception, which resulted in an inadvertent collision with the water.Apr 26, 2022 · N281SP · Substantial damageNTSB ERA22LA206Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206 · Lake Apopka, FLA collision with water following a loss of visual reference to the water surface due to sun glare.Apr 26, 2022 · N206BX · Substantial damageNTSB ERA22FA207Accident · 2 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 429 · Elba, NYThe pilots’ inappropriate flight control inputs while in vortex ring state, which resulted in main rotor blade contact with the tail boom and a subsequent in-flight breakup. Also causal was the flight instructor’s inadequate monitoring of the flight.Apr 26, 2022 · N507TJ · Substantial damageNTSB ERA22FA199Accident · 2 fatalClass 3 · FieldFinal reportCessna 340 · Covington, GAThe private pilot’s loss of control in flight, which resulted in a collision with terrain. Contributing to the accident was the student pilot’s decision to obtain flight instruction from the private pilot and the private pilot's insufficient qualifications to…Apr 21, 2022 · N84GR · DestroyedNTSB GAA22WA166AccidentClass 4 · ForeignPiper PA25 · Cabeceiras, BrazilApr 18, 2022 · PT-WCQ · Substantial damageNTSB ERA22LA192Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206B · Cedar Key, FLThe pilot’s improper fuel planning during agricultural spraying operations, which resulted in fuel starvation, a loss of engine power, and a hard landing following an autorotation.Apr 18, 2022 · N919AC · Substantial damageNTSB WPR22LA157Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Salt Lake City, UTThe student pilot’s failure to maintain lateral control and terrain clearance while hovering, and the flight instructor’s delayed remedial action which resulted in a dynamic rollover.Apr 16, 2022 · N3297Q · Substantial damageNTSB GAA22WA165Accident · 1 fatalClass 5 · ForeignCessna 188 · Mineiros, BrazilApr 14, 2022 · PR-AAM · Substantial damageNTSB WPR22FA148Accident · 1 fatalClass 3 · FieldFinal reportTaylorcraft BL-65 · Counselor, NMA loss of control while maneuvering at a high-density altitude in gusty wind conditions.Apr 9, 2022 · N24345 · Substantial damageNTSB ERA22LA180Accident · Minor injuriesClass 4 · LimitedFinal reportHughes 269A · Fort White, FLThe non-instrument-rated pilot’s decision to fly a visual flight rules only helicopter in instrument meteorological conditions, which resulted in a collision with trees and terrain.Apr 2, 2022 · N7057L · Substantial damageNTSB WPR22LA140Accident · Minor injuriesClass 4 · LimitedFinal reportBell OH-58A · Merced, CAThe pilot’s failure to see and avoid wires while conducting an aerial application flight, which resulted in a wire strike and ground impact.Apr 1, 2022 · N9287U · Substantial damageNTSB CEN22LA163Accident · 2 fatalClass 3 · LimitedFinal reportKitfox 7 · Crowell, TXThe pilot's exceedance of the airplane's critical angle of attack during low-level flight, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.Mar 31, 2022 · N789RB · Substantial damageNTSB ERA22LA178Accident · No injuriesClass 4 · LimitedFinal reportExtra 300 · Rome, GAAn inflight collision with a bird while conducting low level aerobatics.Mar 29, 2022 · N808YF · Substantial damageNTSB GAA22WA132Accident · 1 fatalClass 5 · ForeignSukhoi SU-31 · Ploiesti, RomaniaMar 26, 2022 · N131BT · DestroyedNTSB CEN22LA158Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Garnett, KSThe pilot’s failure to maintain lateral control while hovering which resulted in a dynamic rollover.Mar 26, 2022 · N7087X · Substantial damageNTSB CEN22LA157Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT-401 · Rayville, LAA loss of engine power for a reason that could not be determined based on available information.Mar 26, 2022 · N9192E · Substantial damageNTSB WPR22LA137Accident · Minor injuriesClass 3 · LimitedFinal reportCzech Sport Aircraft A S Sportcruiser · Lanark, NMThe pilot’s loss of control of the airplane after the inadvertent unlocking and opening of the canopy for reasons that could not be determined based on available evidence.Mar 25, 2022 · N823MM · Substantial damageNTSB CEN22FA151Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 · Rowlett, TXA loss of helicopter control while maneuvering, which resulted in main rotor blade contact with the tailboom in flight, tail boom separation, and an uncontrolled descent.Mar 25, 2022 · N514CD · DestroyedNTSB WPR22LA125Accident · Serious injuriesClass 4 · LimitedFinal reportEurocopter AS332L1 · Azusa, CAThe pilot's failure to maintain clearance from a tree after encountering brownout conditions and a loss of visual reference during the approach to land.Mar 20, 2022 · N950SG · Substantial damageNTSB GAA22WA126Accident · Serious injuriesClass 5 · ForeignAyres SRT34 · Antioquia, ColombiaMar 20, 2022 · HK3282 · Substantial damageNTSB WPR22LA144Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-151 · Alpine, CAThe pilot’s failure to maintain clearance from rising terrain while operating in a canyon, which resulted in an impact with terrainMar 19, 2022 · N42764 · Substantial damageNTSB ERA22FA160Accident · 2 fatalClass 3 · FieldFinal reportMD Helicopters 369 · Loxahatchee, FLThe pilot’s failure to maintain clearance from power lines while maneuvering at low altitude.Mar 18, 2022 · N650AG · Substantial damageNTSB CEN22LA146Accident · Minor injuriesClass 3 · LimitedFinal reportHughes 369 · Adair, IAThe mechanic’s failure to properly torque a fuel control unit B-nut, which resulted in a partial loss of engine power, an attempted autorotation, and an impact with terrain.Mar 17, 2022 · N500MZ · Substantial damageNTSB ERA22LA157Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Harveysburg, OHA complete loss of engine power as a result of carburetor ice due to the flight instructor’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.Mar 16, 2022 · N9588E · Substantial damageNTSB GAA22WA201Accident · Serious injuriesClass 5 · ForeignBell 206L-1 · Cooma, AustraliaMar 11, 2022 · VH-BHFNTSB GAA22WA156Accident · No injuriesClass 5 · ForeignBell 412 · Coelemu, ChileMar 11, 2022 · CC-APK · Substantial damage