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 WPR11CA360Accident · No injuriesData collectionFinal reportAircraft Mfg & Design CH750 Stol · New Washoe City, NVThe pilot under instruction's control interference and the CFI's inadequate supervision of the flight.Aug 10, 2011 · N799US · Substantial damageNTSB CEN11CA565Accident · No injuriesData collectionFinal reportWeatherly 201C · Bronson, IAThe pilot's failure to maintain clearance from terrain while maneuvering during an aerial application flight.Aug 10, 2011 · N9054W · Substantial damageNTSB WPR11LA377Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Deer Park, WAThe student pilot's failure to maintain control of the helicopter and his delay in relinquishing control to the flight instructor, which resulted in the instructor’s delayed remedial actions and subsequent hard landing.Aug 8, 2011 · N8332T · Substantial damageNTSB WPR11LA375Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-602 · Willcox, AZThe pilot's failure to maintain clearance from a tower while maneuvering at low altitude. Contributing to the accident was the recent installation of the unmarked tower.Aug 8, 2011 · N5123L · Substantial damageNTSB CEN11FA557Accident · 3 fatalField investigationFinal reportPiper PA-23 · Millersburg, OHThe pilot’s failure to maintain clearance with terrain during the landing approach in night conditions and fog. Contributing to the accident was the pilot’s inadequate preflight planning.Aug 8, 2011 · N2286P · Substantial damageNTSB CEN11CA551Accident · Serious injuriesData collectionFinal reportQuicksilver Sprint II · Douglas, KSThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Aug 6, 2011 · N403BP · Substantial damageNTSB WPR11FA367Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Camas, WAThe pilot's failure to maintain control of the airplane while maneuvering in the traffic pattern.Aug 3, 2011 · N6297P · Substantial damageNTSB CEN11LA543Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Washington, IAThe loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Aug 3, 2011 · N1735S · Substantial damageNTSB ERA11LA437Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Egg Harbor Township, NJThe pilot’s failure to maintain adequate airspeed while maneuvering near the ground, which resulted in an aerodynamic stall.Aug 2, 2011 · N87020 · Substantial damageNTSB CEN11CA540Accident · Serious injuriesData collectionFinal reportBell 47G-2 · Charles City, IAThe pilot's failure to refuel the helicopter which resulted in a loss of engine power due to fuel exhaustion.Aug 2, 2011 · N4771N · Substantial damageNTSB CEN11CA535Accident · No injuriesData collectionFinal reportTexas Helicopter OH-13H/M74A · Joice, IAThe pilot's failure to maintain clearance from the wire.Aug 1, 2011 · N51857 · Substantial damageNTSB ERA11LA434Accident · Minor injuriesLimited investigationFinal reportNord Stampe SV4C · Rhinebeck, NYA total loss of engine power for undetermined reasons.Jul 31, 2011 · N51SV · Substantial damageNTSB CEN11FA537Accident · 1 fatalField investigationFinal reportMorrison E-RACER · Big Rock, ILThe pilot's failure to maintain airplane control after experiencing excessive engine cylinder head temperatures during the initial flight test of the experimental amateur-built airplane.Jul 31, 2011 · N345JM · DestroyedNTSB CEN11CA533Accident · No injuriesData collectionFinal reportGarlick Helicopters OH-58C · Rushford, MNThe pilot's diverted attention, which resulted in the failure to maintain clearance from the power line.Jul 31, 2011 · N82855 · Substantial damageNTSB WPR11FA354Accident · 2 fatalField investigationFinal reportCirrus SR20 · Fredonia, AZThe non-instrument-rated pilots’ loss of situational awareness during a dark night flight over a remote area, which resulted in their failure to maintain an altitude sufficient to ensure adequate terrain clearnance. Contributing to the accident was the…Jul 30, 2011 · N365DP · Substantial damageNTSB CEN11LA541Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Hettinger, NDInternal failure of the engine for undetermined reasons.Jul 30, 2011 · N90181 · Substantial damageNTSB ANC11FA071Accident · 4 fatalField investigationFinal reportCessna U206G · Talkeetna, AKThe inadequate visual lookout and failure to see and avoid by the pilots of both airplanes while maneuvering to land, which resulted in a midair collision. Contributing to the accident was the lack of standardized, unequivocal procedures concerning common…Jul 30, 2011 · N756MP · 2 aircraft · Minor damageNTSB ERA11LA427Accident · 1 fatalLimited investigationFinal reportTL Ultralight Sro Sting S3 · Sarasota, FLThe inability of the pilot-in-command (PIC) to recover from an inadvertent spin following a stall demonstration for reasons that could not be determined because aircraft and engine examinations did not reveal any anomalies that would have precluded recovery…Jul 29, 2011 · N2442 · Substantial damageNTSB CEN11CA545Accident · No injuriesData collectionFinal reportAyres S2R-G6 · Forest City, IAThe pilot's inadequate visual lookout during an aerial application run, which resulted in an in-flight collision with a windmill.Jul 28, 2011 · N331BF · Substantial damageNTSB CEN11CA525Accident · No injuriesData collectionFinal reportBell 47G-2A · Nicolett, MNThe pilot's failure to maintain control of the helicopter while maneuvering during an aerial application flight.Jul 27, 2011 · N7578 · Substantial damageNTSB ERA11LA424Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Drew, MSThe pilot's improper decision to conduct a visual flight rules aerial application flight in instrument meteorological conditions, which resulted in an in flight collision with the ground while maneuvering.Jul 26, 2011 · N8525L · Substantial damageNTSB CEN11FA508Accident · 1 fatalField investigationFinal reportBeech A36 · Williston, NDThe pilot's improper fuel management, which resulted in fuel starvation and a partial loss of engine power while maneuvering at a low altitude.Jul 26, 2011 · N41MK · Substantial damageNTSB WPR11LA356Accident · No injuriesLimited investigationFinal reportSikorsky S-55B · Brewster, WAThe pilot did not maintain main rotor rpm while hovering in gusting wind conditions.Jul 25, 2011 · N855TC · Substantial damageNTSB WPR11FA350Accident · 1 fatalField investigationFinal reportSikorsky S-55B · Chelan, WAThe pilot’s failure to maintain clearance from power lines while maneuvering at a low altitude.Jul 25, 2011 · N5663 · Substantial damageNTSB CEN11LA512Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Anderson, INThe fatigue failure of the propeller governor speeder spring, which resulted in the pilot’s inability to control engine output power.Jul 25, 2011 · N92640 · Substantial damageNTSB CEN11FA507Accident · 1 fatalField investigationFinal reportSikorsky UH-34D · Wilton, IAThe inadequate performance planning by the pilot that resulted in reduced climb capability while transitioning to an out-of-ground effect hover with a left pedal turn.Jul 25, 2011 · N3880J · Substantial damageNTSB CEN11FA505Accident · 2 fatalField investigationFinal reportPiper J3L-65 · Van Dyne, WIThe pilot’s inability to maintain airplane control while maneuvering for reasons that could not be determined from the available evidence.Jul 25, 2011 · N81BF · Substantial damageNTSB WPR11FA344Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Corona, CAAn aggressive flight maneuver performed by the pilot during low altitude flight, which resulted in an aerodynamic stall.Jul 23, 2011 · N34299 · Substantial damageNTSB CEN11LA513Accident · No injuriesLimited investigationFinal reportCessna A188B · Mount Hamill, IAThe loss of engine power due to fuel starvation and the pilot's inadequate fuel management.Jul 23, 2011 · N9234R · Substantial damageNTSB CEN11CA509Accident · No injuriesData collectionFinal reportBell 206B · Temple, OKThe pilot’s failure to maintain clearance from static power lines.Jul 23, 2011 · N118TV · Substantial damageNTSB CEN11CA502Accident · No injuriesData collectionFinal reportCessna A188B · Devils Lake, NDThe pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in a stall during the aerial application.Jul 22, 2011 · N731AU · Substantial damageNTSB WPR11CA339Accident · No injuriesData collectionFinal reportBell 47G-5 · Watsonville, CAThe pilot's failure to maintain clearance from a pole while maneuvering during an aerial application flight.Jul 20, 2011 · N1375X · Substantial damageNTSB ERA11LA415Accident · 2 fatalLimited investigationFinal reportPolaris Polar Star · Dewees Island, SCThe non-certificated pilot’s operation of the unregistered airplane while impaired by alcohol. Contributing to the accident was the pilot’s performance of aerobatic maneuvers that exceeded the structural limits of the aircraft, which resulted in failure of…Jul 20, 2011 · UNREG · Substantial damageNTSB ERA11LA409Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Dayton, NJThe pilot's inadequate compensation for wind during an out-of-ground-effect hover, which resulted in a loss of control due to settling with power and loss of tail rotor effectiveness.Jul 20, 2011 · N83509 · Substantial damageNTSB CEN11CA495Accident · No injuriesData collectionFinal reportCessna A188B · Greenstown, INThe pilot's failure to maintain adequate clearance from vegetation that caused increased drag during a low-level maneuvering flight.Jul 19, 2011 · N4725R · Substantial damageNTSB WPR11FA334Accident · Serious injuriesField investigationFinal reportPiper PA-12 · Joshua Tree, CAThe pilot's decision to conduct low altitude flight at a high density altitude and into a box canyon, which resulted in the airplane colliding with rising terrain when its climb capability was exceeded.Jul 18, 2011 · N7510H · Substantial damageNTSB CEN11FA480Accident · 1 fatalField investigationFinal reportTaylorcraft DCO-65 · Boyne City, MIThe pilot failed to maintain airplane control while maneuvering at low altitude, which resulted in a stall/spin and impact with the terrain.Jul 16, 2011 · N50408 · Substantial damageNTSB CEN11FA479Accident · 2 fatalField investigationFinal reportCessna 150L · Silverton, COThe pilot's failure to maintain control of the airplane while operating it at low levels above mountainous terrain and in excess of its maximum allowable gross weight, which resulted in an aerodynamic stall. The pilot's failure to maintain control resulted…Jul 14, 2011 · N1539Q · Substantial damageNTSB WPR11LA325Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Wenatchee, WAThe pilot's failure to maintain control while hovering out of ground effect at low altitude, which resulted in the helicopter settling into trees.Jul 12, 2011 · N3623Z · Substantial damageNTSB ERA11WA439Accident · 1 fatalForeign investigationRobinson R-44 · Istok, RussiaOn July 9, 2011, at 1900 universal coordinated time, a Robinson R-44, Russian registration RA-04304, registered to and operated by a private owner, collided with the Yenisei River, near Istok, Krasnoyarsk Region, Russia, during a repositioning flight at…Jul 9, 2011 · RA-04304 · Substantial damageNTSB ERA11LA395Accident · Minor injuriesLimited investigationFinal reportAndrew McKimmon DR-1 Triplane · Geneseo, NYA total loss of engine power due to carburetor icing.Jul 9, 2011 · C-GDRI · Substantial damageNTSB CEN11FA467Accident · 1 fatalField investigationFinal reportRans S-12 · Scott, ARThe pilot’s loss of airplane control, likely due to a cardiac event.Jul 9, 2011 · N3266R · Substantial damageNTSB WPR11FA316Accident · 4 fatalField investigationFinal reportMooney M20F · Watsonville, CAThe pilot's decision to take off toward a nearby low cloud layer and the subsequent turn, stall, and spin during the pilot’s attempt to avoid the cloud layer. Contributing to the accident was the pilot's failure to avoid the stall. His ability to avoid the…Jul 8, 2011 · N7759M · Substantial damageNTSB WPR11LA324Accident · Serious injuriesLimited investigationFinal reportM Squared Sprint 1000 · Heise, IDThe 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 accident airplane make and model.Jul 4, 2011 · N648MA · Substantial damageNTSB ERA11LA380Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Lakewood, NJThe pilot’s inadequate yaw control of the helicopter while hovering.Jul 4, 2011 · N64JM · Substantial damageNTSB CEN11WA458Accident · 1 fatalForeign investigationVans RV6 · Shoreham, United KingdomOn July 4, 2011, at 1528 Universal Coordinated Time (UTC), a Vans RV-6A single-engine airplane, G-RVCG, and a Diamond DA-40 single-engine airplane, G-CEZR, collided in midair while maneuvering near Shoreham, West Sussex, United Kingdom. G-RVGC was destroyed…Jul 4, 2011 · G-RVGC · 2 aircraft · DestroyedNTSB WPR11LA303Accident · Serious injuriesLimited investigationFinal reportArrow Falcon Exporters OH-58C · Brentwood, CAThe failure of the main rotor mast due to fatigue cracking originating from corrosion pits.Jul 3, 2011 · N6264D · Substantial damageNTSB CEN11LA459Accident · No injuriesLimited investigationFinal reportWingtip To Wingtip Panzl S-330 · Battle Creek, MIThe inadequate aileron hinge design, which resulted in the in-flight separation of the left aileron following a fatigue failure of the center hinge rod-end.Jul 3, 2011 · N330JK · Substantial damageNTSB CEN11LA456Accident · Serious injuriesLimited investigationFinal reportCondor Southern Powered Parach Raptor · Weyauwega, WIThe pilot's failure to maintain sufficient altitude to clear power lines during flight.Jul 3, 2011 · N6012H · Minor damageNTSB CEN11FA444Accident · 1 fatalField investigationFinal reportBoeing B75N1 · Wetmore, COThe pilot's failure to maintain clearance from terrain while maneuvering at low altitude.Jul 3, 2011 · N4473N · Substantial damage