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 DEN01LA154Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Kemmerer, WYloss of tail rotor effectiveness while hovering. A contributing factor was the wind gust.Sep 2, 2001 · N440TJ · Substantial damageNTSB CHI01FA298Accident · 1 fatalField investigationFinal reportSpears RV-6 · Grayslake, ILThe pilot inadvertently stalled the airplane. A factor was the impairment due to marihuana.Aug 31, 2001 · N910RS · DestroyedNTSB LAX01LA294Accident · 1 fatalLimited investigationFinal reportHarter Kitfox Classic · Sedona, AZThe failure of the pilot to initiate a course reversal in a timely manner after flying into a box canyon and his failure to maintain airspeed during the attempted course reversal, which resulted in a stall spin.Aug 29, 2001 · N46MH · DestroyedNTSB ATL01LA100Accident · No injuriesLimited investigationFinal reportRockwell S2R · Bentonia, MSThe loss of engine power due to the loss of throttle cable continunity. The throttle cable linkage was worn beyond servicable limits. A factor was uneven terrain at the emergency landing site.Aug 29, 2001 · N8438V · Substantial damageNTSB LAX01GA291Accident · 2 fatalFinal reportGrumman TS-2A · Hopland, CAthe failure of both pilots to maintain an adequate visual lookout. The failure of the pilot in Tanker 87 to comply with suggested procedures regarding positive radio contact and orbit entry was a factor.Aug 28, 2001 · N442DF · 2 aircraft · DestroyedNTSB FTW01LA193Accident · No injuriesLimited investigationFinal reportGrumman G164B · Rayville, LAthe partial failure of the magneto drive coupling while maneuvering, which resulted in a loss of engine power and a forced landing. A contributing factor to the accident was the lack of suitable terrain for the forced landing.Aug 28, 2001 · N2LU · Substantial damageNTSB ATL01LA099Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Batesville, MSThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for an emergency landing.Aug 28, 2001 · N91922 · DestroyedNTSB SEA01LA158Accident · 1 fatalLimited investigationFinal reportMatey Hawker Hurricane · Buckley, WAA loss of power for undetermined reasons, and the pilot's inflight decision to attempt a 180 degree turn back to the runway from low altitude and his failure to maintain sufficient flying airspeed during the turn. A contributing factor was drug impairment of…Aug 27, 2001 · N3941Q · Substantial damageNTSB IAD01LA100Accident · 1 fatalLimited investigationFinal reportSocata TB-20 · Amherst, NHSuicide, when the pilot intentionally crashed his airplane into his house.Aug 25, 2001 · N470SP · DestroyedNTSB DEN01FA152Accident · 2 fatalField investigationFinal reportNorth American SNJ-5 · Raton, NMa nonmechanical total loss of engine power for undetermined reasons while performing an aerobatic maneuver, and an inadvertent stall. A contributing factor was the insuffieient altitude to effect a safe recovery.Aug 25, 2001 · N2686D · DestroyedNTSB CHI01FA291Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Crestline, KSThe airplane's departure from level flight and subsequent impact with the terrain as a result of a maneuver initiated by the pilot, and the pilot's failure to maintain clearance from the terrain. The reason for the pilot's actions were not determined.Aug 25, 2001 · N16405 · DestroyedNTSB FTW01TA194Accident · Minor injuriesFinal reportPiper PA-18-150 · Van Horn, TXThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor contributing to the accident was the high density altitude.Aug 23, 2001 · N91187 · DestroyedNTSB CHI01LA294Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Alice, NDThe pilot's unsuccessful recovery from an intentional aerobatic stall/spin maneuver. Contributing to the accident were the pilot's impairment (alcohol), and his psychological condition.Aug 22, 2001 · N4329Z · Substantial damageNTSB CHI01LA288Accident · No injuriesLimited investigationFinal reportCessna 188 · Almond, WIthe pilot failed to maintain clearance from the corn crop. Additional factors were the inoperative spray pump, the corn crop, and the pilot's diverted attention.Aug 22, 2001 · N91138 · Substantial damageNTSB DEN01LA150Accident · No injuriesLimited investigationFinal reportHughes 269C · Tucumcari, NMfailure of the pilot-in-command to maintain adequate terrain clearance. Contributing factors were the unsuccessful low altitude flight maneuver, and the high density altitude weather conditions.Aug 21, 2001 · N502AA · Substantial damageNTSB LAX01LA283Accident · No injuriesLimited investigationFinal reportAerospatiale AS 355F1 · Vinton, CAThe pilot's selection of an unsuitable landing site, which caused "brown-out" conditions during departure liftoff and resulted in loss of control of the helicopter.Aug 18, 2001 · N53LH · Substantial damageNTSB LAX01LA281Accident · 2 fatalLimited investigationFinal reportJohnson Lancair 360 · Placerville, CAIn-flight loss of control for undetermined reasons.Aug 17, 2001 · N417DJ · DestroyedNTSB LAX01LA280Accident · Serious injuriesLimited investigationFinal reportHumphreys Stitts SA6B · Elko, NVThe failure of the pilot-in-command to reverse course in a timely manner after flying into a box canyon. Factors in the accident were the pilot's lack of familiarity with the aircraft and the local terrain.Aug 16, 2001 · N5628 · DestroyedNTSB CHI01LA286Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Petersburg, NEThe failure of the engine cylinder, and the unsuitable terrain for landing encountered by the pilot. Factors were the low altitude and the muddy field.Aug 16, 2001 · N4598 · Substantial damageNTSB CHI01LA281Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Kenmare, NDThe pilot failed to maintain clearance with the terrain during the aerial application flight. Factors associated with the accident were the high vegetation and the pilot's diverted attention during the flight.Aug 16, 2001 · N6794Z · Substantial damageNTSB LAX01FA279Accident · 2 fatalField investigationFinal reportBeech F-33A · Mobile, AZThe flying pilot's initiation of an intentional maneuver at an altitude inadequate to maintain terrain clearance. Low altitude flight was a contributing factor.Aug 15, 2001 · N3172P · DestroyedNTSB LAX01FA277Accident · Minor injuriesField investigationFinal reportMD Helicopters 600N · Fountain Hills, AZthe manufacturer's pilot's failure to maintain yaw control and main rotor speed while recovering from an unusual attitude induced by the customer pilot's inadequate control inputs while maneuvering at low altitude. The manufacturer's pilot's inadequate…Aug 14, 2001 · N70457 · Substantial damageNTSB DEN01LA144Accident · No injuriesLimited investigationFinal reportHughes 369FF · Kemmerer, WYfuel exhaustion due to the pilot's failure to refuel the aircraft, which resulted in a loss of engine power. A contributing factor was the unsuitable steep terrain on which to make a forced landing.Aug 12, 2001 · N530TJ · Substantial damageNTSB CHI01LA275Accident · Serious injuriesLimited investigationFinal reportSchuetz Miniplane DSA-1 · Michigan City, INAircraft control not being maintained by the pilot. Contributing factors to the accident were the pilot maneuvering at a low airspeed, the encountered stall/spin, and the recovery from the spin at a low altitude, which resulted in altitude/clearance not being…Aug 12, 2001 · N11991 · Substantial damageNTSB NYC01LA209Accident · 2 fatalLimited investigationFinal reportDominiak Kitfox · Byron, NYThe pilot's failure to maintain aircraft control. A factor in the accident was the physiological impairment of the pilot due to the consumption of alcohol.Aug 11, 2001 · N912WD · Substantial damageNTSB LAX01LA276Accident · Minor injuriesLimited investigationFinal reportBell 47G-4A · Strathmore, CAThe pilot's inadequate visual lookout while maneuvering during an aerial application flight.Aug 11, 2001 · N4262Y · DestroyedNTSB FTW01LA182Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · San Antonio, TXthe loss of engine power while maneuvering for undetermined reasons.Aug 11, 2001 · N1234X · Substantial damageNTSB CHI01LA273Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Hazelton, NDthe pilot's ostentatious display when he performed a low level manuever and stalled the airplane.Aug 11, 2001 · N48624 · DestroyedNTSB LAX01MA272Accident · 6 fatalMajor investigationFinal reportEurocopter AS350-B2 · Meadview, AZThe pilot’s loss of control of the helicopter for undetermined reasons.Aug 10, 2001 · N169PA · DestroyedNTSB FTW01LA181Accident · No injuriesLimited investigationFinal reportZacharius Acroduster I · Conroe, TXthe mechanic's inadequate inspection which resulted in the undetected corroded rudder cable and its subsequent failure during aerobatic maneuvers.Aug 10, 2001 · N6614R · DestroyedNTSB FTW01LA178Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Grand Coteau, LAthe loss of engine power while maneuvering, which resulted from a fractured #4 cylinder head at the exhaust valve rocker arm boss. A contributing factor was the lack of suitable terrain for the forced landing.Aug 9, 2001 · N10140 · Substantial damageNTSB FTW01LA177Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Bunkie, LAThe loss of engine power for undetermined reasons while maneuvering. A contributing factor was the lack of suitable terrain for the forced landing.Aug 9, 2001 · N542KG · DestroyedNTSB FTW01LA196Accident · Minor injuriesLimited investigationFinal reportWSK PZL Mielec M-18 · Dumas, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Aug 7, 2001 · N4206B · Substantial damageNTSB NYC01FA201Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Sedgwick, METhe failure of the pilot to maintain control while maneuvering.Aug 5, 2001 · N80195 · DestroyedNTSB SEA01LA146Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Latah, WAthe failure of a cylinder head exhaust rocker shaft boss while the aircraft was performing aerial application. Factors include soft terrain and a drop-off in the field where the emergency landing took place.Aug 4, 2001 · N4237X · Substantial damageNTSB LAX01LA268Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Winnemucca, NVthe pilot's failure to maintain clearance with the wires while he was maneuvering for an aerial application run.Aug 4, 2001 · N90191 · Substantial damageNTSB CHI01LA260Accident · No injuriesLimited investigationFinal reportHauck Moffra P-13 · Linden, INthe loss of engine power due to carburetor ice. Contributing to the accident was the rough/uneven terrain condition encountered during the landing.Aug 4, 2001 · N6408W · Substantial damageNTSB CHI01FA256Accident · 2 fatalField investigationFinal reportBeech E55 · Rensselaer, INthe pilot's ostentatious display when he buzzed the farmstead and did not maintain clearance from the barn.Aug 4, 2001 · N30WS · DestroyedNTSB DEN01FA135Accident · 1 fatalField investigationFinal reportBeech V-35A · Lusk, WYthe pilot's inadequate visual lookout, which resulted in an inadvertent collision with transmission wires.Aug 3, 2001 · N7182N · DestroyedNTSB CHI01LA263Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Callaway, NEFuel exhaustion due to the pilot's inadequate preflight. Contributing to the accident was the muddy field and the unsuitable terrain encountered during the forced landing.Aug 2, 2001 · N4478Y · Substantial damageNTSB IAD01FA089Accident · 2 fatalField investigationFinal reportBell 206B · Baltimore, MDThe pilot's improper decision to maneuver in an environment conducive to a loss of tail rotor effectiveness, and his inadequate recovery from the resultant unanticipated right yaw.Aug 1, 2001 · N89FB · DestroyedNTSB NYC01FA193Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Xenia, OHThe flight instructor's failure to maintain aircraft control while maneuvering, which resulted in an inadvertent spin.Jul 31, 2001 · N727AF · Substantial damageNTSB MIA01LA205Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-402A · Whitakers, NCthe pilot's failure to maintain an adequate visual lookout and the proper clearance from obstacles while conducting aerial applications, which resulted in an inflight collision with a power utility pole.Jul 31, 2001 · N9072T · DestroyedNTSB LAX01LA265Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-150 · Hesperia, CAthe loss of engine power due to fuel exhaustion while maneuvering in an attempt to locate the runway. Contributing factors were the inadequate runway maintenance that resulted in inoperative runway edge lights, and the night light conditions.Jul 31, 2001 · N5346W · Substantial damageNTSB DEN01TA134Accident · No injuriesFinal reportBell 205A-1 · Jackson, WYthe Bell 212 helicopter pilot's inadequate visual lookout which resulted in a midair collision.Jul 31, 2001 · N205BR · 2 aircraft · Substantial damageNTSB CHI01LA251Accident · Serious injuriesLimited investigationFinal reportAero Commander S2R · Pierre, SDclearance not obtained by the pilot. A contributing factor was the transmission line.Jul 31, 2001 · N5551X · DestroyedNTSB NYC01LA190Accident · 1 fatalLimited investigationFinal reportHolsclaw Barnett J4B · Titusville, PAThe pilot's failure to maintain control while maneuvering. A factor was the pilot's lack of experience in type of gyroplane.Jul 28, 2001 · N3919C · DestroyedNTSB IAD01LA087Accident · Serious injuriesLimited investigationFinal reportCharles Lancair 320 · Charleston, NYThe pilot's failure to maintain control of the airplane while maneuvering, which resulted in a collision with trees.Jul 27, 2001 · N92SB · Substantial damageNTSB DEN01LA129Accident · No injuriesLimited investigationFinal reportCessna 172N · Farmington, NMthe pilot's failure to maintain clearance from the powerline while descending for an emergency landing. A contributing factor was the loss of engine power for an undetermined reason.Jul 27, 2001 · N181SP · DestroyedNTSB CHI01IA246Incident · No injuriesIncident investigationFinal reportAir Tractor AT-401 · Kenesaw, NEThe propeller blade fatigue leading to its tip separating during an aerial application. Factors were no suitable terrain for an emergency landing, high vegetation, and soft terrain encountered during the emergency landing.Jul 27, 2001 · N4553K · Minor damage