OpenAirDocs.org

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.

NTSB CEN09FA377Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Sanborn, IAA loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel planning and failure to refuel.Jun 23, 2009 · N7795N · Substantial damageNTSB WPR09LA299Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Saint Anthony, IDA total loss of engine power for undetermined reasons.Jun 19, 2009 · N3089K · DestroyedNTSB WPR09LA270Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Yerington, NVThe pilot's failure to maintain aircraft control while maneuvering during an aerial application flight.Jun 18, 2009 · N9723 · Substantial damageNTSB ANC09LA058Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Crooked Creek, AKA total loss of engine power for an undetermined reason.Jun 17, 2009 · N1623U · Substantial damageNTSB ERA09CA351Accident · No injuriesData collectionFinal reportDreyer Starduster · Cowlesville, NYA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight fuel inspection.Jun 15, 2009 · N3LD · Substantial damageNTSB CEN09LA353Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G103C Twin III Acro · Gregory, MIThe pilot's failure to maintain sufficient airspeed during the turn to return for landing, which resulted an inadvertent stall/spin. Contributing to the accident was the failure of the ground winch tow cable shortly after takeoff.Jun 14, 2009 · N103MS · Substantial damageNTSB ERA09LA344Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC-6 Twin · Orange, VAThe pilot's improper decision to perform a low-level maneuver over a populated skydive landing area and his inadequate visual lookout.Jun 13, 2009 · N204EH · No damageNTSB ERA09CA349Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe pilot's failure to maintain control of the helicopter during hover, resulting in a rollover.Jun 13, 2009 · N1565B · Substantial damageNTSB CEN09LA355Accident · 1 fatalLimited investigationFinal reportAero Commander S2R · Cordova, ILThe pilot’s failure to maintain clearance with terrain after clearing an obstacle during an agricultural application pass.Jun 12, 2009 · N1734S · DestroyedNTSB CEN09CA616Accident · No injuriesData collectionFinal reportPiper PA-36-285 · Clark, SDThe pilot's inadequate visual lookout and failure to maintain clearance from a levy.Jun 12, 2009 · N57625 · Substantial damageNTSB CEN09CA361Accident · No injuriesData collectionFinal reportAir Tractor AT-402A · Trumann, ARThe pilot's failure to maintain aircraft control in flight. Contributing to the accident was his decision to fly with known hazardous weather conditions in the vicinity.Jun 12, 2009 · N50956 · Substantial damageNTSB WPR09FA284Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Morristown, AZThe pilot's failure to maintain clearance from the power line.Jun 11, 2009 · N149SH · Substantial damageNTSB CEN09PA348Accident · 2 fatalClass 1Final reportAgusta A109E · Santa Fe, NMThe pilot's decision to take off from a remote, mountainous landing site in dark (moonless) night, windy, instrument meteorological conditions. Contributing to the accident were an organizational culture that prioritized mission execution over aviation safety…Jun 10, 2009 · N606SP · DestroyedNTSB ANC09FA052Accident · 2 fatalField investigationFinal reportHarden RV-7 · Elim, AKThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with terrain.Jun 10, 2009 · N303BK · Substantial damageNTSB CEN09LA345Accident · Serious injuriesLimited investigationFinal reportCurtiss Moses Aerolite · Los Lunas, NMA loss of engine power due to fuel starvation as a result of the pilot's fuel mismanagement.Jun 9, 2009 · N43598 · Substantial damageNTSB ERA09LA325Accident · 2 fatalLimited investigationFinal reportSmith Bret B Searey · Knoxville, TNThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall and uncontrolled descent.Jun 6, 2009 · N169GW · Substantial damageNTSB CEN09CA344Accident · Serious injuriesData collectionFinal reportTaylorcraft BC12-D · Murray, IAThe pilot's failure to maintain control of the airplane while maneuvering at a low altitude.Jun 6, 2009 · N43524 · Substantial damageNTSB ERA09CA319Accident · No injuriesData collectionFinal reportCessna A188B · Kingstree, SCThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.Jun 3, 2009 · N9364R · Substantial damageNTSB ERA09LA317Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Greenville, VAThe inadequate design of the fourth-stage turbine wheel, resulting in the fatigue failure of one airfoil and a subsequent loss of engine power.Jun 2, 2009 · N8356F · Substantial damageNTSB WPR09CA272Accident · No injuriesData collectionFinal reportSchweizer SGS 2-32 · Warner Springs, CAThe pilot's failure to maintain clearance from a tree while maneuvering in flight.May 30, 2009 · N5826V · Substantial damageNTSB WPR09LA269Accident · 2 fatalLimited investigationFinal reportStorch Aviation Australia PTY SS-MK4 · Boulder, UTThe pilot's failure to maintain clearance from power lines during low altitude maneuvering.May 29, 2009 · N2898J · Substantial damageNTSB CEN09LA331Accident · 1 fatalLimited investigationFinal reportGentry John K Chinook PL · Bridgeport, TXThe flight instructor and pilot's decision to take off with known control deficiencies with the aircraft which resulted in a loss of control.May 29, 2009 · N31773 · Substantial damageNTSB WPR09LA264Accident · 1 fatalLimited investigationFinal reportPolit Kitfox Ser 5 Outback · Apple Valley, CAThe pilot's loss of aircraft control for undetermined reasons while maneuvering at low altitude.May 23, 2009 · N781VP · Substantial damageNTSB ERA09LA302Accident · 1 fatalLimited investigationFinal reportHazelwood Michael S RV-8 · Decatur, ALThe RV-8 pilot's failure to maintain adequate clearance from the CJ-6A while maneuvering. This report was modified on September 10, 2010.May 23, 2009 · N875MH · 2 aircraft · Substantial damageNTSB ERA09CA298Accident · Serious injuriesData collectionFinal reportAyres S2R-G1 · Bald Eagle, PAThe pilot's failure to maintain clearance from a power line.May 21, 2009 · N6134T · Substantial damageNTSB WPR09FA248Accident · 3 fatalField investigationFinal reportCessna 172N · Long Beach, CAThe failure of both pilots to see and avoid each other's aircraft.May 19, 2009 · N738NN · 2 aircraft · Substantial damageNTSB WPR09CA259Accident · Minor injuriesData collectionFinal reportVenus Trike · Kuna, IDThe complete loss of engine power for undetermined reasons, and the overload failure of the nose landing gear strut during the roll out over soft/rough terrain.May 17, 2009 · UNREG · Substantial damageNTSB ERA09CA292Accident · No injuriesData collectionFinal reportCessna 152 · Memphis, TNThe pilots' decision to fly at a low altitude and their inadequate visual lookout while maneuvering.May 15, 2009 · N6529M · Substantial damageNTSB ERA09CA294Accident · No injuriesData collectionFinal reportCessna R182 · Collins, MSThe pilot’s failure to maintain clearance from an antenna during a low-altitude aerial observation flight. Contributing to the accident was the sun glare.May 14, 2009 · N7392S · Substantial damageNTSB CEN09LA297Accident · Serious injuriesLimited investigationFinal reportAyres S-2R · Monroe, LAThe pilot's failure to maintain clearance from the power transmission lines during an aerial application run.May 14, 2009 · N223SB · Substantial damageNTSB CEN09CA290Accident · No injuriesData collectionFinal reportBolton Ricky D Rotorway E · Brookeland, TXThe pilot failed to maintain control while hovering in gusty conditions.May 10, 2009 · N602DB · Substantial damageNTSB WPR09FA235Accident · 5 fatalField investigationFinal reportBeech 95 · Minden, NVThe pilot's failure to maintain an adequate airspeed while maneuvering during a low altitude maneuver that resulted in a stall.May 9, 2009 · N1533Z · Substantial damageNTSB WPR09FA234Accident · 2 fatalField investigationFinal reportUpton Bakeng Duce · Ramona, CAAn in-flight separation of the right wing, which resulted from the pilot's performance of a maneuver that produced aerodynamic loads that exceeded the wing spar’s degraded strength. The wing spar strength degradation was due to the builder's failure to comply…May 9, 2009 · N86YP · Substantial damageNTSB CEN09CA287Accident · Serious injuriesData collectionFinal reportPitts Aerobatics S-2B · Muskogee, OKInadequate supervision by the certified flight instructor, resulting in a delayed stall recovery attempt.May 9, 2009 · N6027V · Substantial damageNTSB CEN09CA295Accident · Minor injuriesData collectionFinal reportAir Tractor AT502 · Lisse, TXA total loss of engine power for undetermined reasons.May 8, 2009 · N248LF · Substantial damageNTSB CEN09WA286Accident · 3 fatalForeign investigationCessna 340 · Veracruz, MexicoOn May 5, 2009 at about 0900 central daylight time a Cessna 340, Mexican Registration XB-CUC crashed while returning to land after takeoff at General Heriberto Jara Corona International Airport, Veracruz, Veracruz, Mexico. The pilot requested to return to the…May 7, 2009 · XB-CUC · DestroyedNTSB WPR09CA224Accident · No injuriesData collectionFinal reportRobinson R44 · Cottonwood, AZThe pilot's inadequate visual lookout and failure to maintain clearance from wires.May 3, 2009 · N441CB · Substantial damageNTSB CEN09LA277Accident · 2 fatalLimited investigationFinal reportChampion 7GCBC · Surrey, NDThe pilot’s failure to maintain control of the airplane during an abrupt pull-up maneuver, which resulted in an aerodynammic stall at low altitude.May 3, 2009 · N5106T · DestroyedNTSB WPR09LA226Accident · No injuriesLimited investigationFinal reportMD Helicopter 369FF · Santa Clarita, CAThe pilot's failure to maintain clearance from the water while maneuvering at low altitude as a result of the helicopter's grappling hook temporarily becoming ensnared with an underwater obstruction.May 1, 2009 · N67FF · Substantial damageNTSB WPR09CA220Accident · No injuriesData collectionFinal reportBell OH-58A · Arvin, CAThe pilot’s failure to maintain clearance from wires during aerial application maneuvers.Apr 30, 2009 · N175SJ · Substantial damageNTSB CEN09CA272Accident · Minor injuriesData collectionFinal reportCessna A185F · Patterson, LAThe pilot's failure to maintain adequate airspeed in a turn while attempting to return to land, which resulted in an aerodynamic stall. Contributing to the accident was the reported loss of engine power for undetermined reasons.Apr 29, 2009 · N4603E · Substantial damageNTSB ERA09WA279Accident · 2 fatalForeign investigationCirrus Design SR22 · Mt. Ainos, GreeceNone.Apr 28, 2009 · 4X-CWN · DestroyedNTSB ERA09LA272Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Chesterfield, SCThe partial loss of engine power due to a broken exhaust valve. Contributing to the accident was the operator's exceedance of the engine manufacturer's recommended time before overhaul.Apr 27, 2009 · N9884Q · Substantial damageNTSB WPR09LA215Accident · No injuriesLimited investigationFinal reportStanton Glastar · Redding, CAA loss of engine power during cruise for undetermined reasons.Apr 25, 2009 · N518PV · Substantial damageNTSB CEN09CA270Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Kent, TXThe pilot's failure to maintain control of the helicopter.Apr 23, 2009 · N518SJ · Substantial damageNTSB WPR09LA203Accident · 1 fatalLimited investigationFinal reportExtra EA-300 · Santa Barbara, CAThe pilot's failure to maintain clearance with terrain for undetermined reasons while performing aerobatics.Apr 20, 2009 · N101PK · Substantial damageNTSB WPR09FA200Accident · 2 fatalField investigationFinal reportChampion 7ECA · San Jose, CAThe pilot's failure to maintain airspeed while maneuvering within a canyon in mountainous terrain, which resulted in an inadvertent stall/spin.Apr 18, 2009 · N5174X · Substantial damageNTSB ERA09LA250Accident · 1 fatalLimited investigationFinal reportGladstone Kitfox · Dubre, KYThe pilot's failure to maintain airspeed while maneuvering at a low altitude, which resulted in an aerodynamic stall.Apr 18, 2009 · N191KF · Substantial damageNTSB ANC09LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Talkeetna, AKThe pilot's failure to maintain adequate airspeed to avoid an aerodynamic stall while maneuvering at a high density altitude.Apr 17, 2009 · N46326 · Substantial damageNTSB CEN09FA243Accident · 2 fatalField investigationFinal reportEngineering and Research 415C · Sandwich, ILThe pilot's failure to execute an immediate forced landing to a suitable field and the engine's partial loss of power for an undetermined reason.Apr 11, 2009 · N87384 · Destroyed