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 SEA94LA069Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Hanksville, UTThe pilot's delay in releasing his tow line when the line became entangled with wires.Feb 28, 1994 · N4082J · Substantial damageNTSB BFO94LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Bath, OHloss of engine power for undetermined reasons. A factor in the accident was the frozen, snow covered terrain.Feb 28, 1994 · N47316 · Substantial damageNTSB FTW94LA086Accident · 1 fatalLimited investigationFinal reportAir Tractor AT400 · Widener, ARThe pilot's loss of control for undetermined reasons.Feb 27, 1994 · N3652D · DestroyedNTSB SEA94LA065Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Gold Hill, ORSeparation of the crossover fuel line, and the inability of the pilot in command to maintain a proper rate of descent during the autorotation.Feb 24, 1994 · N73909 · DestroyedNTSB LAX94FA138Accident · 2 fatalField investigationFinal reportCessna 150L · San Jacinto, CAThe pilot's impairment of judgment and performance due to alcohol and drugs, which led to his improper planning/decision, and his failure to maintain altitude/clearance from mountainous terrain, while maneuvering at low altitude.Feb 24, 1994 · N10998 · DestroyedNTSB CHI94LA091Accident · No injuriesLimited investigationFinal reportCessna 150M · La Crosse, WIThe failure of the exhaust valve in the number one cylinder. The lack of suitable terrain for the forced landing was a factor in the accident.Feb 18, 1994 · N704CE · Substantial damageNTSB ATL94LA050Accident · Serious injuriesLimited investigationFinal reportArgo Minimax · Franklin, TNThe pilot's failure to secure cargo in the cockpit.Feb 18, 1994 · NONE · Substantial damageNTSB MIA94LA073Accident · No injuriesLimited investigationFinal reportCessna 150L · Ocean Springs, MSThe loss of engine power for undetermined reasons.Feb 14, 1994 · N10797 · Substantial damageNTSB CHI94FA082Accident · 2 fatalField investigationFinal reportCessna A185F · Sterling Hgts, MIThe pilot's impairment of judgment and performance due to alcohol, which led to his intentional buzzing, and his failure to maintain sufficient altitude (or clearance) from obstacles. Factors related to the accident were: darkness and the unlighted tower.Feb 11, 1994 · N53064 · DestroyedNTSB MIA94FA070Accident · 1 fatalField investigationFinal reportCessna 152 · Brooksville, FLThe pilot-in-command's failure to maintain a visual lookout and altitude while maneuvering after becoming lost/disoriented, resulting in an in-flight collision with trees and terrain. Contributing to the accident was the pilot's physical impairment due to…Feb 10, 1994 · N6613L · DestroyedNTSB ANC94FA032Accident · 1 fatalField investigationFinal reportPiper PA-12 · Kenai, AKThe pilot's failure to maintain airspeed while maneuvering at low altitude. A factor in the accident was the student pilot's inadequate training.Feb 10, 1994 · N7523H · DestroyedNTSB LAX94LA115Accident · 2 fatalLimited investigationFinal reportLampman Kitfox IV · Banning, CA1) The pilot's decision to fly in mountainous terrain at a low level, and 2) his failure to maintain adequate airspeed while maneuvering to reverse direction in a box canyon, which resulted in an inadvertent stall spin.Feb 6, 1994 · N92NL · DestroyedNTSB SEA94LA057Accident · Minor injuriesLimited investigationFinal reportBell 206B · Cathlamet, WALoad jettison was not performed.Feb 3, 1994 · N43823 · Substantial damageNTSB SEA94FA055Accident · 2 fatalField investigationFinal reportBeech S35 · Ashland, ORPoor in-flight planning/decision. Factors to the accident were: clearance was not maintained and poor supervision.Feb 3, 1994 · N50VT · DestroyedNTSB SEA94LA054Accident · No injuriesLimited investigationFinal reportFokker DR-1 · Auburn, WAThe pilot failed to maintain clearance while maneuvering near another airplane.Feb 2, 1994 · N10717 · Substantial damageNTSB MIA94LA062Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · New Smyrna Bch, FLThe pilot-in-command's failure to maintain airspeed (VSO) while maneuvering, resulting in an in-flight loss of control (inadvertent stall) and subsequent in-flight collision with terrain.Jan 29, 1994 · N57436 · DestroyedNTSB LAX94FA106Accident · 1 fatalField investigationFinal reportSikorsky S-58 · San Jose, CAThe pilot's inadequate preflight planning/preparation and subsequent fuel starvation, due to an inadequate supply of fuel. A factor related to the accident was: the proximity of high obstructions.Jan 28, 1994 · N4995G · DestroyedNTSB FTW94GA076Accident · 2 fatalFinal reportBellanca 8GCBC · Usaf Academy, COLoss of control in flight for an undetermined reason.Jan 28, 1994 · N7634S · DestroyedNTSB BFO94LA035Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Gaithersburg, MDThe pilot's failure to maintain rotor RPM which led to an in flight loss of control resulting in a collision with the runway and the helicopter rolling over on its side. A factor in this accident was the pilot's lack of total experience flying helicopters.Jan 25, 1994 · N8559A · Substantial damageNTSB MIA94LA060Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Naples, FLThe flight instructor's delayed reaction to take control of the helicopter. Contributing factors were the student pilot's improper use of cyclic and collective controls and his failure to release the flight controls to the flight instructor.Jan 24, 1994 · N525BW · Substantial damageNTSB ATL94FA043Accident · 2 fatalField investigationFinal reportCulver LCA · Lake City, SCWas the pilot's failure to maintain flying speed while maneuvering the airplane which resulted in the loss of control and the collision with the ground.Jan 23, 1994 · N72M · Substantial damageNTSB MIA94FA058Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Pontotoc, MSThe pilot in command's failure to maintain altitude while manuevering resulting in the aircraft colliding with trees and then the ground.Jan 22, 1994 · N88255 · DestroyedNTSB LAX94LA102Accident · 1 fatalLimited investigationFinal reportFurche-Bielsko SZD-48 Jantar · Warner Springs, CAThe pilot's improper remedial action to recover from the spin. The intentional stall/spin was a factor in this accident.Jan 22, 1994 · N48DF · DestroyedNTSB LAX94LA101Accident · 1 fatalLimited investigationFinal reportAviat Christen Eagle II · Ramona, CAA failure of the pilot-in-command to maintain an adequate visual lookout and proper altitude to avoid colliding with rising terrain.Jan 22, 1994 · N27HR · DestroyedNTSB SEA94FA052Accident · 1 fatalField investigationFinal reportPiper PA-12 · Idaho Falls, IDThe pilot's failure to maintain clearance from the terrain. Factors include the pilot's poor inflight decision to attempt low level maneuvers in a narrow canyon.Jan 21, 1994 · N7805H · Substantial damageNTSB LAX94LA099Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Davis, CAwas that the pilot misjudged the airplane's altitude during the swath run.Jan 20, 1994 · N8649H · DestroyedNTSB LAX94FA100Accident · 2 fatalField investigationFinal reportAerospatiale AS-350D · Lebec, CAThe pilot-in-command's inadequate in-flight planning and inadequate visual lookout. Factors in the accident were mountainous terrain which masked the presence of the wires and the pilot-in-command's lack of familiarity with the geographic area.Jan 20, 1994 · N5795X · DestroyedNTSB FTW94LA071Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Cascade, COThe pilot's improper in-flight planning which resulted in the aircraft's yaw performance being exceeded. A factor was the high density altitude.Jan 20, 1994 · N3211K · Substantial damageNTSB FTW94LA067Accident · No injuriesLimited investigationFinal reportCessna 150D · Mount Pleasant, TXThe power loss due to carburetor icing and the pilot's delayed use of carburetor heat. Factors were the weather conditions and the lack of suitable terrain for the forced landing.Jan 18, 1994 · N4558U · Substantial damageNTSB FTW94FA065Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Ratcliff, TXThe pilot failed to maintain control of the airplane and allowed it to exceed its design stress limits, which resulted in overload failure of the stabilators and right outboard wing section.Jan 16, 1994 · N6522P · DestroyedNTSB ATL94LA039Accident · No injuriesLimited investigationFinal reportAir & Space 18A · Atlanta, GAA loss of control for undetermined reasons.Jan 16, 1994 · N6118S · Substantial damageNTSB MIA94LA050Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS-350 · Lakeland, FLThe pilot-in-command's failure to follow the emergency procedure in the flight manual for governor malfunction. Contributing to the accident was inadequate written procedures in the flight manual by the aircraft manufacturer.Jan 13, 1994 · N902BA · DestroyedNTSB ANC94LA028Accident · No injuriesLimited investigationFinal reportCessna 150 · Big Lake, AKLoss of engine power due to improper procedures used by the PIC. A factor contributing to the accident was the snow covered terrain.Jan 8, 1994 · N16037 · Substantial damageNTSB SEA94LA047Accident · Minor injuriesLimited investigationFinal reportMBB BO-105S · Clearwater, ORThe pilot in command's failure to maintain clearance with the transmission wires. Factors contributing to the accident were the wires and sunglare.Jan 6, 1994 · N204PC · DestroyedNTSB LAX94LA092Accident · Minor injuriesLimited investigationFinal reportBeech 76 · Avalon, CAThe pilot's failure to see and avoid the powerlines. A related factor was the pilot's poor judgment in flying at low altitude.Jan 3, 1994 · N8013Y · Substantial damageNTSB SEA94FA045Accident · 2 fatalField investigationFinal reportCessna 172D · Bandon, ORThe pilot's failure to maintain adequate clearance. Factors include strong, gust winds, a dark night, and the pilot's lack of experience in nighttime operations.Jan 1, 1994 · N2813U · DestroyedNTSB SEA94LA044Accident · No injuriesLimited investigationFinal reportSommerauer Glasair I RG · Ogden, UTA loose fuel line fitting, and fuel starvation. Factors include an intentional wheels up forced landing, and soft rough/uneven terrain.Dec 31, 1993 · HBYDJ · Substantial damageNTSB ATL94LA035Accident · No injuriesLimited investigationFinal reportKaman HH-43B/F · Mobile, ALAn inadequate major repair by company maintenance personnel who failed to install the cotter pin which secured the retaining nut of the right main rotor hub teeter pin.Dec 29, 1993 · N5197W · Substantial damageNTSB LAX94LA084Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74L · Los Banos, CAA failure of the pilot to utilize carburetor heat. The carburetor icing conditions were a factor in the accident.Dec 28, 1993 · N38110 · Substantial damageNTSB ATL94LA032Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Edisto Island, SCFailure of the pilot to use carburetor heat, while maneuvering and changing altitudes, which resulted in carburetor ice. A factor related to the accident was that weather conditions were favorable for the formation of carburetor ice.Dec 26, 1993 · N25566 · Substantial damageNTSB LAX94LA080Accident · 2 fatalLimited investigationFinal reportCessna 150G · Truckee, CAThe pilot's impaired judgment and impaired performance, while under the influence of drugs, that resulted in his failure to maintain sufficient altitude and clearance above the mountainous terrain and obstructions (power line & trees).Dec 25, 1993 · N4813X · DestroyedNTSB LAX94LA076Accident · No injuriesLimited investigationFinal reportHughes 369D · Waimea, Kauai, HIAn inadequate engine compressor cleaning procedure specified in the manufacturer's service letter, which resulted in the total loss of engine power due to contamination, blockage, and collapse of the fuel nozzle inlet screen. Factors in the accident were: the…Dec 22, 1993 · N115HD · Substantial damageNTSB NYC94FA040Accident · 2 fatalField investigationFinal reportAero Commander 500A · White Mills, PAwas the fracture and separation of the airplane wing, and the subsequent loss of control and collision with trees, as a result of the pilot's repeated performance of acrobatic maneuvers, which exceeded the design limits of the airplane.Dec 16, 1993 · N9379R · DestroyedNTSB NYC94LA049Accident · 3 fatalLimited investigationFinal reportMooney M20J · Jones Beach, NYwas the pilot's failure to maintain control of the airplane, resulting in the airplane impacting with the water. Also casual in this accident was the pilot's total lack of experience in this type of aircraft, and operations. A factor in this accident was the…Dec 15, 1993 · N201TX · DestroyedNTSB FTW94LA055Accident · No injuriesLimited investigationFinal reportEbershoff Steen Skybolt · Erie, COWas flutter of the flight controls.Dec 15, 1993 · N360HP · Substantial damageNTSB SEA94LA039Accident · No injuriesLimited investigationFinal reportHiller-Soloy UH-12D · Sublimity, ORFuel exhaustion due to inadequate preflight and refueling not acomplished.Dec 7, 1993 · N2297W · Substantial damageNTSB ATL94LA027Accident · Minor injuriesLimited investigationFinal reportWonder VAN'S Acft RV-6 · Ridgeland, SCImproper installation of the magnetos by maintenance personnel, which allowed the right magneto to come loose, oil to escape from the engine, and subsequent oil starvation.Dec 7, 1993 · N443MW · Substantial damageNTSB NYC94LA034Accident · 1 fatalLimited investigationFinal reportCessna 182Q · Nantucket, MAThe pilot's inability to control the airplane due to alcoholic impairment.Dec 6, 1993 · N96666 · DestroyedNTSB MIA94FA034Accident · 1 fatalField investigationFinal reportCessna 150J · Delray Beach, FLThe pilot-in-command's failure to maintain altitude while maneuvering. This resulted in the pilot becoming spatially disoriented, and subsequent in-flight collision with the ocean. Contributing to the accident was the dark night with no visible horizon.Dec 4, 1993 · N60517 · DestroyedNTSB LAX94FA065Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Payson, AZImproper in-flight planning/decision by the pilot, and his failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin. Factors related to the accident were: pilot impairment from improper use of prescription drugs (not approved for…Dec 4, 1993 · N4417Z · Destroyed