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 CEN09LA512Accident · 1 fatalLimited investigationFinal reportHooper James A Bushby MUS · Gladwin, MIThe pilot's failure to maintain aircraft control for undetermined reasons.Aug 7, 2009 · N37JD · DestroyedNTSB CEN09WA506Accident · 2 fatalForeign investigationEnstrom F28 · Mont Laurier, CanadaOn August 5, 2009, at 1000 eastern daylight time, an Enstrom F28C helicopter, Canadian registered C-GVQQ, registered to a private individual and piloted by the accident pilot, was destroyed when it impacted wires and terrain near Mont-Laurier Airport (CSD4),…Aug 5, 2009 · C-GVQQ · DestroyedNTSB ERA09TA440Accident · Minor injuriesFinal reportEurocopter AS 350B3 · Jacksonville, FLThe flight instructor's improper decision to attempt hover flight without hydraulic power and his subsequent loss of control.Aug 4, 2009 · N186AE · Substantial damageNTSB CEN09LA503Accident · No injuriesLimited investigationFinal reportAir Tractor AT401 · Waterloo, IAA loss of engine power for undetermined reasons.Aug 4, 2009 · N60747 · Substantial damageNTSB ERA09LA441Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Suffolk, VAA loss of engine power due to fuel exhaustion as a result of the pilot’s failure to accurately calculate the fuel required for the flight. Contributing to the accident was a malfunction of the fuel quantity indicators.Aug 3, 2009 · N3549N · Substantial damageNTSB CEN09LA488Accident · Serious injuriesLimited investigationFinal reportPiontkowski Challenger · Kankakee, ILThe pilot's failure to maintain clearance from the telephone line and his poor judgment to fly while under the influence of alcohol. Contributing to the accident was the pilot's impairment due to the alcohol consumption.Aug 3, 2009 · N4526G · Substantial damageNTSB CEN09CA483Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Royal, IAThe pilot's failure to maintain clearance from the crop during an aerial application maneuver.Aug 3, 2009 · N6701Z · Substantial damageNTSB ERA09LA436Accident · Minor injuriesLimited investigationFinal reportEurocopter EC130 · Deer Isle, METhe pilot's loss of directional control during an out-of-ground-effect hover.Aug 1, 2009 · M-BOAT · Substantial damageNTSB ERA09CA434Accident · Serious injuriesData collectionFinal reportLet L13 · Sparta, NYThe student pilot's failure to maintain airspeed resulting in an aerodynamic stall.Aug 1, 2009 · N66FL · Substantial damageNTSB CEN09LA492Accident · Serious injuriesLimited investigationFinal reportStirling Starduster · Earlham, IAThe pilot's failure to maintain clearance from the ground during an aerobatic maneuver.Aug 1, 2009 · N1XY · Substantial damageNTSB ERA09LA431Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT502 · Minter City, MSThe pilot’s failure to maintain airspeed while maneuvering at a low altitude, resulting in an aerodynamic stall.Jul 31, 2009 · N60237 · Substantial damageNTSB ERA09CA432Accident · Minor injuriesData collectionFinal reportBingham Chuck Rotorway 1 · Atlanta, GAThe pilot's failure to maintain control of the helicopter while hovering in gusting wind conditions.Jul 31, 2009 · N267BC · Substantial damageNTSB CEN09CA479Accident · Serious injuriesData collectionFinal reportPiper PA28-151 · Purcell, OKThe student pilot's failure to see and avoid the power lines.Jul 31, 2009 · N41930 · DestroyedNTSB WPR09LA373Accident · Minor injuriesLimited investigationFinal reportGrumman G164 · Riverdale, CAThe partial loss of engine power due to the failure of the engine's supercharger-blower.Jul 28, 2009 · N8741H · Substantial damageNTSB CEN09LA466Accident · 1 fatalLimited investigationFinal reportLuscombe 8C · Mount Carmel, ILThe reason for this accident was not determined.Jul 25, 2009 · N37080 · Substantial damageNTSB WPR09LA371Accident · No injuriesLimited investigationFinal reportSikorsky S-55 · Chelan, WAFailure of a seal in the hydraulic system resulting in a loss of hydraulic pressure while maneuvering at low altitude.Jul 24, 2009 · N1255T · Substantial damageNTSB ERA09LA421Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Dunedin, FLA partial loss of engine power for undetermined reasons.Jul 24, 2009 · N645JC · Substantial damageNTSB WPR09TA356Accident · 1 fatalFinal reportBell 212 · Willow Creek, CAThe rappeller's failure to properly latch the rappelling harness to the rappelling assembly before exiting the helicopter.Jul 21, 2009 · N212HP · No damageNTSB CEN09CA452Accident · Minor injuriesData collectionFinal reportWeatherly 620B · New England, NDThe loss of engine power for undetermined reasons while maneuvering at low altitude.Jul 21, 2009 · N2027K · Substantial damageNTSB WPR09CA358Accident · Minor injuriesData collectionFinal reportWsk-Pzl Meilec PZL M18B · Rockland, IDThe pilot's failure to maintain clearance from the terrain during an aerial application reversal turn.Jul 20, 2009 · N7813T · Substantial damageNTSB ERA09LA413Accident · 1 fatalLimited investigationFinal reportCessna 152 · Ponce, PRThe airplane’s impact with water for undetermined reasons.Jul 19, 2009 · N5518P · DestroyedNTSB CEN09LA444Accident · 1 fatalLimited investigationFinal reportBeech TC-45J · Verdel, NEThe pilot's improper decision to fly an airplane that was not airworthy and for which he was not properly rated to operate, and his failure to maintain control of the airplane during a forced landing to a field following an engine failure. Contributing to the…Jul 19, 2009 · N6688 · DestroyedNTSB WPR09LA357Accident · 2 fatalLimited investigationFinal reportWeiss Lancair · Santa Clarita, CAThe pilot's failure to maintain adequate airspeed and control while maneuvering.Jul 18, 2009 · N244RR · Substantial damageNTSB WPR09TA353Accident · Minor injuriesFinal reportCroman SH-3H · Willow Creek, CAThe pilot’s failure to maintain adequate power during egress from a heliwell, which resulted in collision with the heliwell and a dynamic rollover.Jul 17, 2009 · N613CK · Substantial damageNTSB ERA09FA419Accident · 3 fatalField investigationFinal reportMD Helicopter 530 (369FF) · Camp Butler, IraqThe pilot’s failure to maintain terrain clearance during a low-level course reversal.Jul 17, 2009 · N974BW · DestroyedNTSB WPR09LA350Accident · Minor injuriesLimited investigationFinal reportBielawa Rotorway E · Sequim, WAThe failure (disbonding) of a composite main rotor blade for undetermined reasons, leading to an immediate loss of control in flight during hover.Jul 16, 2009 · N3213K · Substantial damageNTSB CEN09LA447Accident · No injuriesLimited investigationFinal reportCessna A188B · Suring, WIA loss of engine power resulting from the fatigue failure of the crankshaft due to the loss of engine case through-bolt torque. Contributing to the engine failure was the operator's failure to overhaul the engine in accordance with the manufacturer's…Jul 16, 2009 · N9747G · Substantial damageNTSB WPR09CA339Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Marysville, CAThe pilot’s failure to maintain adequate clearance from the power line wires.Jul 13, 2009 · N244HP · Substantial damageNTSB ERA09CA401Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Bedford, MAThe flight instructor's inadequate remedial action while conducting hover practice with a student pilot, which resulted in the helicopter rolling over when it contacted the ground.Jul 13, 2009 · N211SH · Substantial damageNTSB CEN09CA431Accident · Minor injuriesData collectionFinal reportPiper J3C-65 · Porter, TXThe partial loss of engine power due to carburetor icing resulting in the pilot's inability to clear the wires.Jul 13, 2009 · N70455 · Substantial damageNTSB ERA09LA398Accident · 2 fatalLimited investigationFinal reportBarber John A Glasair · Switzerland, FLA loss of control in flight for undetermined reasons. Contributing to the accident was the pilot's performance of aerobatic maneuvers at altitudes lower than those recommended by the kit manufacturer, resulting in insufficient terrain clearance to conduct a…Jul 11, 2009 · N132JB · DestroyedNTSB ERA09LA394Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Hertford, NCThe in-flight collision with terrain for undetermined reasons.Jul 10, 2009 · N357CA · Substantial damageNTSB CEN09LA427Accident · 1 fatalLimited investigationFinal reportZivko Aeronautics Edge 540 · Tarkio, MOThe pilot's failure to maintain aircraft control during the aerobatic flight.Jul 10, 2009 · N26HB · Substantial damageNTSB CEN09FA425Accident · 1 fatalField investigationFinal reportNorth American SNJ-5 · Simla, COThe pilot’s failure to maintain control of the airplane while practicing aerobatic maneuvers and his subsequent failure to recover from an inadvertent spin.Jul 9, 2009 · N212TC · DestroyedNTSB WPR09FA334Accident · 2 fatalField investigationFinal reportCessna 182P · Mammoth Lakes, CAThe pilot's improper in-flight planning/decision to attempt to fly at a low altitude in a confined area of mountainous terrain in a high density altitude weather condition, and his failure to maintain clearance from the trees.Jul 8, 2009 · N7314S · Substantial damageNTSB WPR09CA333Accident · No injuriesData collectionFinal reportBell 47G-2 · Turlock, CAThe pilot's failure to maintain rotor RPM while maneuvering at a low altitude.Jul 8, 2009 · N6768D · Substantial damageNTSB ERA09LA392Accident · 1 fatalLimited investigationFinal reportNoles Vance L Vans RV7A · Sanderson, FLThe pilot's continued visual flight into instrument meteorological conditions with convective activity and thunderstorms. Contributing to the accident was his failure to get an adequate weather briefing.Jul 8, 2009 · N774US · Substantial damageNTSB ERA09LA388Accident · Serious injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Oakland, MSA total loss of engine power while maneuvering (after performing aerobatics) for undetermined reasons.Jul 8, 2009 · N113DW · Substantial damageNTSB WPR09CA331Accident · Minor injuriesData collectionFinal reportBell 47G-3B-2 · Ocean Shores, WAThe pilot's failure to maintain clearance from the water while maneuvering due to the pilot's diverted attention.Jul 7, 2009 · N8169J · Substantial damageNTSB ERA09LA385Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Brinson, GAThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in the make and model airplane.Jul 7, 2009 · N8587S · Substantial damageNTSB ERA09FA376Accident · 4 fatalField investigationFinal reportPilatus PC-12/45 · Raphine, VAThe pilot's failure to maintain control of the airplane while in instrument meteorological conditions following a reported instrumentation failure for undetermined reasons.Jul 5, 2009 · N578DC · Substantial damageNTSB WPR09LA325Accident · 2 fatalLimited investigationFinal reportAero Vodochody L-29 · Tehachapi, CAThe pilot’s failure to maintain clearance from terrain while performing a low altitude maneuver.Jul 4, 2009 · N97869 · Substantial damageNTSB CEN09LA409Accident · 1 fatalLimited investigationFinal reportCessna 172 · Latimer, IAThe pilot's failure to maintain clearance from the power line while flying at a low altitude.Jul 3, 2009 · N8138B · Substantial damageNTSB CEN09LA413Accident · Serious injuriesLimited investigationFinal reportBell Helicopter Textron 206L-1 · Breckenridge, COThe pilot's failure to maintain directional control while maneuvering due to a loss of tail rotor effectiveness. Contributing to the accident was the pilot's failure to monitor wind direction while operating in the "Critical Wind Azimuth Area."Jul 2, 2009 · N38AZ · Substantial damageNTSB CEN09LA403Accident · Serious injuriesLimited investigationFinal reportAyres S2R-G6 · Ainsworth, IAA component failure of the fuel control unit, which resulted in a loss of engine power.Jul 1, 2009 · N60015 · Substantial damageNTSB CEN09LA401Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Knobel, ARThe failure of the P-3 tube resulting in the loss of engine power.Jun 30, 2009 · N5192T · Substantial damageNTSB WPR09LA318Accident · 1 fatalLimited investigationFinal reportAlexander Schleicher ASW 27-18E · Ephrata, WAThe pilot’s failure to maintain control of the glider during flight and his exceedance of the glider’s design limits during an attempted recovery from a spin.Jun 29, 2009 · N129TD · Substantial damageNTSB CEN09LA396Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Shelbyville, INThe partial loss of engine power due to the failure of the mixture control cable. Contributing to the accident was the inadequate maintenance on the airplane and the pilot's decision to operate the airplane in a condition that was not airworthy.Jun 29, 2009 · N9085L · Substantial damageNTSB WPR09LA312Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Lakeport, CAA loss of engine power while maneuvering for undetermined reasons.Jun 25, 2009 · N515DG · Substantial damageNTSB ERA09LA369Accident · 2 fatalLimited investigationFinal reportP&M Quikr · Cedar Town, GAA loss of aircraft control for an undetermined reason.Jun 25, 2009 · N433PM · Substantial damage