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 WPR13GA128Accident · 1 fatalFinal reportBell 206B · Eureka, NVThe pilot’s failure to maintain clearance from a wire while maneuvering during low-altitude operations. Contributing to the accident was task- and/or work-related fatigue.Feb 18, 2013 · N20620 · Substantial damageNTSB ERA13LA136Accident · 1 fatalLimited investigationFinal reportQuicksilver MX2 · Poplarville, MSThe noncertificated pilot’s decision to make the flight and his failure to maintain clearance from trees while maneuvering at a low altitude.Feb 17, 2013 · UNREG · Substantial damageNTSB CEN13LA163Accident · 1 fatalLimited investigationFinal reportPZL Mielec M-18A · Jennings, LAThe pilot’s inadequate visual lookout, which resulted in a collision with guy wires during an aerial application flight.Feb 15, 2013 · N4305D · Substantial damageNTSB ERA13WA165Accident · 1 fatalForeign investigationPiper PA-36-300 · Quevedo, EcuadorOn February 14, 2013, about 1310 coordinated universal time (UTC), a Piper PA-36-300, Ecuadorian registration HC-BJM, operated by CIA FAP S.A., was substantially damaged when it impacted the ground during an aerial application flight. The Ecuadorian pilot was…Feb 14, 2013 · HC-BJM · Substantial damageNTSB CEN13TA165Accident · Minor injuriesFinal reportBell OH-58A · Pine Springs, TXThe pilot's failure to maintain directional control while operating in conditions conducive to a loss of tail rotor effectiveness.Feb 14, 2013 · N337PW · Substantial damageNTSB ERA13WA157Accident · 1 fatalForeign investigationCessna 172S · Mersin, TürkiyeOn February 12, 2013, at about 1414 Universal Time Coordinated, a Cessna 172S, Turkish registration TC-CDA, operated by the Turkish Aeronautical Association, impacted terrain during an instructional flight, near Mersin, Turkey. The flight instructor was…Feb 12, 2013 · TC-CDA · Substantial damageNTSB WPR13FA119Accident · 3 fatalField investigationFinal reportBell 206B · Acton, CAThe pilot's decision to conduct a flight in dark night conditions with an illuminated cockpit light that degraded his visibility and his ability to identify and arrest the helicopter's descent while maneuvering, which resulted in controlled flight into…Feb 10, 2013 · N59518 · Substantial damageNTSB WPR13CA120Accident · No injuriesData collectionFinal reportBell 206B · Shandon, CAThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.Feb 10, 2013 · N802KA · Substantial damageNTSB WPR13CA121Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Sunnyside, WAThe pilot’s inadequate vigilance while maneuvering at low altitude and his subsequent failure to maintain clearance from power lines.Feb 9, 2013 · N6726J · Substantial damageNTSB ERA13CA130Accident · Minor injuriesData collectionFinal reportDratbe Shmiel Amir Classic Edge X · Miami, FLThe student pilot's decision to fly at low altitude surrounded by tree, wire, and water hazards, and his failure to maintain clearance from those obstacles.Feb 9, 2013 · N662DA · Substantial damageNTSB ERA13WA135Accident · 4 fatalForeign investigationCessna 172 · La Matanza, ArgentinaOn February 8, 2013, at 2250 Coordinated Universal Time (UTC), a Cessna 172, Argentine registration LV-GEU, impacted terrain while maneuvering at an altitude of approximately 500 feet in the vicinity of Matanza Airport (SADZ), La Matanza, Argentina. The local…Feb 8, 2013 · LV-GEU · Substantial damageNTSB CEN13LA168Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Forrest City, ARThe in-flight separation of the left aileron's push-pull rod and hardware. Contributing to the accident was the failure of maintenance personnel to apply proper torque to the self-locking nuts.Feb 7, 2013 · N198LA · Substantial damageNTSB CEN13LA148Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta II · Gillett, TXA loss of tail rotor effectiveness while manuevering at low altitude.Feb 1, 2013 · N3059Q · Substantial damageNTSB CEN13LA152Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Victoria, TXThe mechanical failure of the engine power section, which resulted in a loss of engine power.Jan 31, 2013 · N9190B · Substantial damageNTSB ERA13CA122Accident · Minor injuriesData collectionFinal reportAmirkhanian Shahram Charl Commander · Westminster, MDImpact with power lines due to the pilot’s obscured vision due to the low angle of the sun, which prevented the pilot from seeing the lines.Jan 29, 2013 · N393GX · Substantial damageNTSB ERA13LA118Accident · Minor injuriesLimited investigationFinal reportHiller-Tri-Plex Ind.Inc. UH-12B · Okeechobee, FLThe pilot's failure to monitor carburetor temperature and use carburetor heat in conditions conducive to serious carburetor icing, which resulted in partial loss of engine power.Jan 26, 2013 · N9041U · Substantial damageNTSB WPR13FA095Accident · 2 fatalField investigationFinal reportCessna 140 · Boulder, UTThe pilot’s improper decision to maneuver at a low altitude and failure to adequately monitor the environment to maintain clearance from power lines.Jan 19, 2013 · N2341N · Substantial damageNTSB WPR13LA087Accident · Serious injuriesLimited investigationFinal reportBell OH-58C · Riverdale, CAA flight control malfunction while maneuvering for reasons that could not be determined because it was not possible to establish whether observed damage to the flight control assembly was the result of wreckage recovery efforts or a preexisting condition.Jan 8, 2013 · N911PT · Substantial damageNTSB CEN13WA126Accident · 5 fatalForeign investigationPiper PA34 · Saint Pierre de Bressieux, FranceOn January 5, 2013, at 1235 coordinated universal time, a Piper PA-34-200T airplane, Morocco registration, CN-DAY, crashed in mountainous terrain near Saint Pierre de Bressieux, France. The pilot and four passengers were fatally injured. The accident…Jan 5, 2013 · CN-DAY · Substantial damageNTSB WPR13FA083Accident · 1 fatalField investigationFinal reportLuscombe 8A · Oceano, CAThe pilot’s failure to maintain airplane control and his improper decision to begin a low-level maneuver at an altitude that was not sufficient for recovery before ground impact. Contributing to the accident was the pilot’s impairment from marijuana use.Jan 3, 2013 · N45923 · Substantial damageNTSB WPR13CA084Accident · Minor injuriesData collectionFinal reportBell 47G · Five Points, CAThe pilot’s failure to maintain clearance with a telephone pole during a low-level maneuver.Jan 3, 2013 · N14841 · Substantial damageNTSB WPR13FA080Accident · 1 fatalField investigationFinal reportBell 206 · Delano, CAThe pilot's failure to maintain helicopter control due to spatial disorientation while maneuvering in low visibility, dark night conditions.Jan 2, 2013 · N828AC · DestroyedNTSB WPR13FA073Accident · 2 fatalField investigationFinal reportBeech B100 · Libby, MTThe noncertificated pilot’s failure to maintain clearance from terrain while maneuvering to land in dark night conditions likely due to his geographic disorientation (lost). Contributing to the accident was the pilot’s improper decision to fly at night with a…Dec 19, 2012 · N499SW · DestroyedNTSB WPR13LA069Accident · Serious injuriesLimited investigationFinal reportPowerchute Airwolf 912ULS · Dell, MTThe pilot's failure to maintain aircraft control and clearance from mountainous terrain while maneuvering at a low altitude in downdraft conditions.Dec 14, 2012 · N480QP · Substantial damageNTSB ERA13LA087Accident · Minor injuriesLimited investigationFinal reportRotorway DB-1 · Mayland, TNThe pilot’s failure to maintain helicopter control following a high-side governor failure for reasons that could not be determined during postaccident examination.Dec 13, 2012 · N828X · Substantial damageNTSB CEN13FA100Accident · 2 fatalField investigationFinal reportAerovodochody L-29 Delfin · Combine, TXThe airplane's impact with terrain for reasons that could not be determined during examination of the available evidence because of extensive impact damage and postimpact fire.Dec 13, 2012 · N29NR · Substantial damageNTSB CEN13FA089Accident · 1 fatalField investigationFinal reportBeech 58 · Manhattan, ILAn in-flight loss of control and impact with terrain for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Dec 4, 2012 · N4016A · Substantial damageNTSB WPR13LA062Accident · 1 fatalLimited investigationFinal reportCessna 172S · Kahului, HIThe noninstrument-rated pilot’s spatial disorientation and subsequent failure to maintain airplane control while operating over water in dark night conditions with reduced visibility due to rain in the area.Dec 2, 2012 · N3554Y · Substantial damageNTSB CEN13FA085Accident · 4 fatalField investigationFinal reportPiper PA 46-350P · Greensburg, INThe pilot's failure to maintain airplane control while maneuvering in night instrument meteorological conditions due to spatial disorientation.Dec 2, 2012 · N92315 · DestroyedNTSB CEN13FA082Accident · 2 fatalField investigationFinal reportBeech P35 · Correctionville, IAThe pilot’s failure to perform a go-around after encountering thick fog at night.Dec 2, 2012 · N1566Z · Substantial damageNTSB CEN13LA086Accident · 1 fatalLimited investigationFinal reportBell 47G-2 · Walkerville, MIThe pilot's failure to maintain altitude while maneuvering, which resulted in a collision with trees. Contributing to the accident was the pilot's decision to fly at a low altitude, which did not provide enough margin to recover from the descent.Dec 1, 2012 · N3755Z · Substantial damageNTSB CEN13CA079Accident · Minor injuriesData collectionFinal reportSchweizer SGS 2-32 · Boulder, COThe glider pilot's inability to locate an area of thermal lift.Nov 29, 2012 · N9929J · Substantial damageNTSB WPR13CA057Accident · Minor injuriesData collectionFinal reportHughes 369D · Sheridan, ORThe pilot’s failure to prevent the helicopter from entering a vortex ring state (settling with power) condition during an external load operation, which resulted in the helicopter’s main rotor blades impacting the truck.Nov 27, 2012 · N163PJ · Substantial damageNTSB WPR13FA056Accident · 2 fatalField investigationFinal reportMcdaniel RV-6-CH · Scio, ORThe pilot's decision to perform aerobatics in an airplane that was prohibited from aerobatics as stated in its operating limitations document, which resulted in the failure of the right wing spar.Nov 26, 2012 · N424D · Substantial damageNTSB WPR13LA050Accident · 1 fatalLimited investigationFinal reportSater Coot A-Amphib · San Andreas, CAThe pilot's excessive flight control inputs, which led to flight that exceeded the structural limits of the airplane and resulted in structural failure of both wings.Nov 23, 2012 · N8VS · Substantial damageNTSB ERA13WA066Accident · 1 fatalForeign investigationAerospatiale AS-355F1 · Great Guana Cay, BahamasOn November 22, 2012, about 1310 eastern standard time, an Aerospatiale AS 355F1, Bahamian registration C6-APV, registered to Pioneer Caribbean Logistics Ltd., impacted terrain while attempting to land at Baker's Bay Resort, Great Guana Cay, Bahamas. The…Nov 22, 2012 · C6-APV · Substantial damageNTSB CEN13FA060Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA-1B · Burlington, WIThe pilot’s failure to maintain control of the airplane while maneuvering at a low altitude, which resulted in an inadvertent stall and spin.Nov 18, 2012 · N6273L · Substantial damageNTSB WPR13GA044Accident · Minor injuriesFinal reportBell OH-58 · Altadena, CAThe landing pilot's failure to maintain clearance with from obstacles a parked prior to landinghelicopter and the other pilot's failure to park the helicopter inside of a marked parking pad. Contributing to the accident was the landing pilot's obscured…Nov 17, 2012 · N911FA · 2 aircraft · Substantial damageNTSB ERA13WA431Accident · 3 fatalForeign investigationBeech 95B55 - B · Concepcion, ParaguayOn November 16, 2012, about 0813 local time (1113 coordinated universal time), a Beech BE-55, Paraguayan registration ZP-BLV, was destroyed when it impacted terrain about 500 meters short of the runway at a ranch in Departamento Presidente Hayes, about 50…Nov 16, 2012 · ZP-BLV · DestroyedNTSB ERA13LA057Accident · 2 fatalLimited investigationFinal reportHughes 369D · Corning, NYThe pilot’s failure to maintain adequate altitude while conducting a power line aerial observation flight, which resulted in an in-flight collision with wires. Contributing to the accident was the pilot’s lack of total experience in the type of operation.Nov 15, 2012 · N369AW · Substantial damageNTSB WPR13FA036Accident · 2 fatalField investigationFinal reportNorth Wing Scout X-C · Waterville, WAThe pilot's failure to maintain control of the airplane while maneuvering at a low altitude, which resulted in a stall and subsequent spin from which he was unable to recover.Nov 8, 2012 · N467XW · Substantial damageNTSB WPR13LA035Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Modesto, CAFailure of the throttle control cable during maneuvering flight, which resulted in a partial loss of engine power.Nov 6, 2012 · N21391 · Substantial damageNTSB CEN13FA051Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Anadarko, OKThe pilot’s use of excessive bank angle while maneuvering in the airport traffic pattern, which resulted in an accelerated stall.Nov 6, 2012 · N7337J · Substantial damageNTSB ERA13GA046Accident · 2 fatalFinal reportHughes OH-6A · Atlanta, GAThe pilot's failure to maintain sufficient altitude during maneuvering flight, which resulted in his failure to see and avoid a power pole and wires.Nov 4, 2012 · N368PD · Substantial damageNTSB CEN13LA034Accident · 2 fatalLimited investigationFinal reportUS Light Hornet · Mont Belvieu, TXThe pilot’s inadequate airspeed management while maneuvering in gusty wind conditions, which resulted in an aerodynamic stall. Contributing to the accident was the airplane’s low altitude, which did not allow for a stall recovery.Oct 28, 2012 · N2482J · Substantial damageNTSB WPR13LA025Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Mariner · Lake Havasu, AZThe pilot’s unintentional and unrecognized entry into a vortex ring state as a result of conducting a course reversal turn into a tailwind while at a low altitude and airspeed, which resulted in an uncontrolled descent into water.Oct 27, 2012 · N2627M · Substantial damageNTSB WPR13LA023Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R-44 II · Toutle, WAThe pilot’s failure to maintain precise altitude control, which resulted in the helicopter entering a settling with power condition while hovering out of ground effect.Oct 26, 2012 · N7530F · Substantial damageNTSB WPR13FA022Accident · 2 fatalField investigationFinal reportBehne Glasair III · Byron, CAThe pilot's failure to maintain control of the airplane while maneuvering, which resulted in a stall and subsequent spin.Oct 23, 2012 · N655DB · DestroyedNTSB ERA13FA032Accident · 2 fatalField investigationFinal reportSwift Museum Foundation GC-1A · East Moriches, NYThe failure of the pilot to maintain airspeed, while attempting a precautionary landing for reasons that could not be determined from the available evidence. Contributing to the accident was the pilot’s pitch-up reaction to birds that took flight during his…Oct 20, 2012 · N80823 · Substantial damageNTSB ERA13LA029Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Edison, GAThe total loss of engine power due to the fatigue failure of the k-pin associated with the No. 1 cylinder.Oct 19, 2012 · N6670K · Substantial damage