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 LAX91LA223Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Chinle, AZFuel starvation due to fuel mismanagement by the pilot in command.May 25, 1991 · N593B · Substantial damageNTSB FTW91FA085Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Claremore, OKThe instructor pilot (PIC) did not maintain clearance from obstacles during the maneuver.May 25, 1991 · N3609K · DestroyedNTSB ANC91LA061Accident · 1 fatalLimited investigationFinal reportRockwell S-2R · Larsen Bay, AKThe pilot's decision to continue VFR into IMC conditions and failure to maintain proper altitude. Contributing to the accident was the low ceiling and fog.May 25, 1991 · N4851X · DestroyedNTSB FTW91DPG10Accident · No injuriesFinal reportWeatherly 201B · Mc Crory, ARLoss of the outboard portion of the propeller blade. A factor was the lack of suitable terrain for the forced landing.May 23, 1991 · N1260W · Substantial damageNTSB SEA91LA111Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Laramie, WYThe pilot's failure to maintain an airspeed above the stall speed for the aircraft. Contributing to the accident was the high density altitude.May 22, 1991 · N2234A · Substantial damageNTSB CHI91LA162Accident · No injuriesLimited investigationFinal reportCessna 177 · New Lothrop, MIFuel exhaustion and misjudged fuel calculations by the pilot. A factor was the lack of suitable terrain available for an emergency landing.May 22, 1991 · N548EC · Substantial damageNTSB ANC91LA059Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Smith Cove, AKA complete lose of engine power due to a total disintegration of the turbine wheel.May 22, 1991 · N87729 · Substantial damageNTSB SEA91LA109Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Malott, WAAn undetermined failure of the fuel pump casing resulting in an in flight fire and loss of engine power.May 19, 1991 · N73903 · DestroyedNTSB LAX91FA219Accident · Serious injuriesField investigationFinal reportBeech C23 · Cibola, AZThe pilot's failure to maintain adequate clearance between the aircraft and ground vehicle during a low pass resulting in an in flight collision with the vehicle, loss of control, and in flight collision with terrain. Factors related to the accident was the…May 19, 1991 · N6017E · Substantial damageNTSB FTW91FA081Accident · 2 fatalField investigationFinal reportCessna 150J · Caney, OKBinding of the #2 exhaust valve (stuck valve), and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. A factor related to the accident was: the failed exhaust manifold gasket.May 18, 1991 · N1019M · DestroyedNTSB DEN91FA071Accident · 1 fatalField investigationFinal reportCessna 172M · Wray, COThe pilot intentionally buzzing and failure to maintain proper altitude.May 17, 1991 · N80077 · Substantial damageNTSB MIA91LA147Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLA momentary loss of engine power due to undetermined reasons.May 15, 1991 · N32133 · Substantial damageNTSB FTW91FA092Accident · 1 fatalField investigationFinal reportAyres S2R-T34 · Parkin, ARFailure of the pilot to maintain adequate clearance from objects.May 15, 1991 · N4010P · DestroyedNTSB SEA91LA105Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Lapwai, IDThe pilot's misjudgment of an aerial application swath run. Factors include a downdraft condition and soft terrain.May 14, 1991 · N8792H · DestroyedNTSB LAX91LA214Accident · Minor injuriesLimited investigationFinal reportGrumman G164B · Yuba City, CAFatigue in the propeller blade which led to its ultimate failure. Factors relating to this accident were the soft terrain conditions on which the airplane landed and a berm across the airplane's ground path.May 14, 1991 · N48658 · Substantial damageNTSB FTW91DPG06Accident · No injuriesFinal reportGrumman G-164A · Gillett, ARThe windshiled becoming obscured by aerial application spray and the resultant limited vision from the cockpit.May 14, 1991 · N9785 · Substantial damageNTSB DEN91LA070Accident · Serious injuriesLimited investigationFinal reportPiper PA18-50 · Lordsburg, NMPilot factor in that he allowed the aircraft to enter an inadvertent stall mush at an altitude insufficient to recover.May 14, 1991 · N2331H · Substantial damageNTSB MIA91LA144Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Tutwiler, MSFatigue failure of one of the propeller blades resulting in the forced landing. Contributing to the accident was lack of suitable terrain.May 13, 1991 · N8563S · Substantial damageNTSB NYC91LA134Accident · Minor injuriesLimited investigationFinal reportTierra II · Cooperstown, NYThe mechanical failure of the flight control system, which resulted in a a loss or airplane control and subsequent forced landing in trees.May 12, 1991 · N198WC · DestroyedNTSB NYC91LA130Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Ellington, CTThe failure of the pilot to maintain directional control, and his inadequate compensation for winds, while maneuvering close to the ground. A factor relating to the accident was the adverse wind conditions.May 12, 1991 · N496TP · Substantial damageNTSB MIA91LA141Accident · No injuriesLimited investigationFinal reportBell 47-G · Aguadilla, PRThe improper in flight planning/decision of the pilot-in-command to conduct an out-of-ground-effect hover with a right crosswind. This resulted in an in flight loss of control due to settling with power and in flight collision with terrain.May 11, 1991 · N955B · DestroyedNTSB CHI91LA154Accident · No injuriesLimited investigationFinal reportEnstrom F28 · Hampshire, ILAircraft control was not maintained when the aircraft encountered an uncotrolled descent by the pilot. Remedial action by the pilot was inadequate. A factor related to the acident was lack of total experience in type of aircraft by the pilot.May 11, 1991 · N86214 · Substantial damageNTSB FTW91DRD04Accident · Serious injuriesFinal reportAir Tractor AT 301 · Lake Providence, LAA loss of engine power for undetermined reasons resulting in a forced landing and nose over on landing.May 10, 1991 · N3658T · Substantial damageNTSB LAX91LA204Accident · 1 fatalLimited investigationFinal reportAyres S2RT34 · Marysville, CAThe pilots' inadequate visual lookout for other air traffic.May 9, 1991 · N3633Q · 2 aircraft · DestroyedNTSB FTW91DRG02Accident · No injuriesFinal reportCessna 188 · La Feria, TXThe pilot exceeded the proper descent rate.May 9, 1991 · N8184V · Substantial damageNTSB LAX91LA193Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Yuma, AZThe failure of the pilot-in-command to perform fuel consumption calculations which resulted in a total loss of engine power due to fuel exhaustion.May 7, 1991 · N304JD · Substantial damageNTSB CHI91DCQ05Accident · No injuriesFinal reportCessna A188B · Mingo, KSFailure of the pilot to maintain a visual lookout while performing aerial application. A factor associated with the accident is soft terrain in the selected landing area.May 6, 1991 · N9374R · Substantial damageNTSB NYC91LA126Accident · No injuriesLimited investigationFinal reportHughes 269B · Lincoln Park, NJAn inflight loss of control during a hover due to improper use of the flight controls by the pilot and the failure of the pilot to completely use the minimal visual references available.May 5, 1991 · N3TL · Substantial damageNTSB BFO91FA048Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Odessa, DEThe pilot's failure to recover from a stall. Contributing was an intentional stall of the aircraft, pilot inexpereince and inadequate altitude.May 5, 1991 · N9285 · DestroyedNTSB FTW91DPG05Accident · 1 fatalFinal reportAyres S2R-T34 · Wheatley, ARThe failure of the flagman to follow established procedures.May 2, 1991 · N4015Z · Minor damageNTSB LAX91LA186Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Madera, CAFailure of the pilot to maintain adequate clearance from the guy wire.Apr 28, 1991 · N5250 · DestroyedNTSB SEA91FA095Accident · 1 fatalField investigationFinal reportCessna 150H · Sumpter, ORThe pilot's improper inflight planning and decisions and the pilot's VFR flight into IMC conditions.Apr 27, 1991 · N970MA · DestroyedNTSB FTW91LA064Accident · Minor injuriesLimited investigationFinal reportBell 47G4 · Corpus Christi, TXThe initial restricted movement and eventual locking of the cyclic control as a result of the failure of the lateral servo. A factor was the installation of the failed component by an unqualified person.Apr 27, 1991 · N1195W · DestroyedNTSB ATL91LA088Accident · 1 fatalLimited investigationFinal reportCessna 150J · Kure Beach, NCThe pilot's poor judgement, while impaired by alcohol, and his misjudgement of altitude/clearance above the water after initiating a low pass.Apr 25, 1991 · N50738 · DestroyedNTSB MIA91LA125Accident · 1 fatalLimited investigationFinal reportRutan Aircraft Factory Vari EZE · Panama City, FLThe pilot-in-command misjudged his altitude while conducting an aerobatic maneuver, resulting in an in flight collision with water.Apr 21, 1991 · N32F · DestroyedNTSB SEA91LA091Accident · 1 fatalLimited investigationFinal reportSchwartz Bushby MM-1 · Ephrata, WAThe pilot's loss of control after he initiated a maneuver at low altitude.Apr 20, 1991 · N484N · DestroyedNTSB SEA91FA089Accident · 2 fatalField investigationFinal reportCessna 150L · Mount Vernon, WAThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin at low altitude. His lack of experience was a related factor.Apr 20, 1991 · N16230 · DestroyedNTSB NYC91DNA02Accident · Minor injuriesFinal reportBell 47-G3B1 · Harwich, MAA failure of the clutch during takeoff due to improper maintenance procedures. Factors related to the accident were insufficient altitude to establish an autorotation.Apr 20, 1991 · N1166W · Substantial damageNTSB ATL91LA086Accident · No injuriesLimited investigationFinal reportCessna 182B · Elberta, ALThe pilot's failure to apply carburetor heat. Factors were weather conditions for the formation of induction ice, and the soft terrain.Apr 20, 1991 · N7202E · Substantial damageNTSB FTW91LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Port Lavaca, TXThe pilot's inadvertent stall at an altitude too low for recovery. A factor was the pilot's low pass.Apr 17, 1991 · N4695Y · DestroyedNTSB MIA91FA124Accident · Serious injuriesField investigationFinal reportCessna 152 · Oak Meadows, FLThe failure of the instructor pilot to maintain an airspeed above stall speed resulting in an inadvertent stall at an altitude that precluded recovery. Contributing to the accident was the instructor pilot's poor judgement and ostentatious display at a low…Apr 16, 1991 · N4902H · Substantial damageNTSB MIA91FA123Accident · 3 fatalField investigationFinal reportWaco ASO · Lake Apopka, FLAn inadvertent stall and spin at an altitude that precluded recovery.Apr 16, 1991 · NC7091 · DestroyedNTSB FTW91LA067Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Carlisle, ARThe pilot's failure to maintain airspeed above the stalling speed of the airplane and the resultant inadvertent stall. A factor was the emotional state of the pilot.Apr 16, 1991 · N8188A · Substantial damageNTSB FTW91LA066Accident · 2 fatalLimited investigationFinal reportAeronca 7AC · Bradley, ARThe pilot's attempted to perform aerobatic flight at an altitude inadequate for recovery.Apr 16, 1991 · N1599E · DestroyedNTSB SEA91LA260Accident · 1 fatalLimited investigationFinal reportAero Commander S-2R · Grangeville, IDThe improper decision by the pilot to continue VFR flight in IMC weather conditions in mountainous terrain, resulting in pilot disorientation and inadvertent flight into a box canyon. Factors relating to the accident were the rain showers and low ceiling…Apr 15, 1991 · N5539X · DestroyedNTSB MIA91LA122Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Clewiston, FLDisintegration of the impeller for undetermined reasons resulting in the total loss of engine power necessitating the forced landing.Apr 15, 1991 · N8386K · Substantial damageNTSB LAX91LA179Accident · Serious injuriesLimited investigationFinal reportRobinson R-22B · Piru, CA1) The pilot failing to maintain visual lookout, and 2) inflight collision with unmarked transmission wires.Apr 15, 1991 · N4030A · DestroyedNTSB CHI91LA131Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Grand Ledge, MIThe student's failure to maintain a proper altitude and clearance from the terrain along with the cfi's failure to adequately supervise the student's actions. A factor contributing to the accident was the inadequate visual lookout available due to the night…Apr 12, 1991 · N294Q · Substantial damageNTSB CHI91DEP04Accident · Minor injuriesFinal reportBrault Glasair SH2F · Green Bay, WIThe pilot in command's failure to refuel the aircraft prior to departure. A factor contributing to the accident was the unporting of the fuel pick up line in fuel tank during abrupt or negative 'g' maneuvers.Apr 11, 1991 · N1490 · Substantial damageNTSB LAX91LA168Accident · No injuriesLimited investigationFinal reportCessna 140 · El Mirage, CAThat the pilot made a poor inflight decision to practice the slow flight maneuver at a low altitude and that he failed to maintain airspeed.Apr 9, 1991 · N89572 · Substantial damage