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 MIA96FA185Accident · 1 fatalField investigationFinal reportChampion Aeronca 7GCB · Fairhope, ALfailure of the pilot to maintain adequate airspeed, while manuevering at low altitude, which resulted in an inadvertent stall and uncontrolled impact with the water. The pilot's ostentatious display and the lack of altitude to recover from a stall were…Jul 15, 1996 · N9908Y · Substantial damageNTSB CHI96LA239Accident · No injuriesLimited investigationFinal reportCessna A188B · Saint Charles, MOa partial loss of engine power due to undetermined reasons and the pilot's failure to maintain aircraft control. The factors involved were the pilot did not perform load jettison and low airspeed.Jul 15, 1996 · N9703J · Substantial damageNTSB IAD96LA116Accident · 1 fatalLimited investigationFinal reportQuicksilver Sprint · Mt Airy, MDThe pilot's improper planning/decision and exceeding the design stress limits of the aircraft, which resulted in overload failure of the wing and subsequent uncontrolled collision with the terrain. Factors related to the accident were: the pilot's failure to…Jul 13, 1996 · UNREG · DestroyedNTSB CHI96FA237Accident · 1 fatalField investigationFinal reportPiper PA-12 · Roselle, ILthe pilot's improper decision to perform a go-around, while there was restricted rudder movement and the banner was still attached to the airplane, which resulted in a loss of airspeed and an inadvertent stall. Factors relating to the accident were: the…Jul 13, 1996 · N25JP · DestroyedNTSB ANC96FA098Accident · 1 fatalField investigationFinal reportSikorsky CH-54A · Ketchikan, AKfailure of the number 5 tailrotor bearing. A factor relating to the accident was: the uneven/steep sloping terrain, where the pilot was forced to land. Possible factors were: inadequate handling/labeling of the 'relubed' bearing by intermediate supplyier(s),…Jul 13, 1996 · N541SB · DestroyedNTSB SEA96LA152Accident · No injuriesLimited investigationFinal reportHanks Avid Flyer · Spanish Fork, UTpartial loss of engine power for undetermined reason(s). A factor relating to the accident was: the tall grain crop that was encountered during the forced landing.Jul 11, 1996 · N3086G · Substantial damageNTSB FTW96LA297Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Mcgehee, ARa loss of engine power and subsequent engine fire for undetermined reasons.Jul 10, 1996 · N80199 · DestroyedNTSB CHI96LA236Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18 Dromader · Waupaca, WIinadequate maintenance of the throttle cable by maintenance personnel.Jul 10, 1996 · N2047S · Substantial damageNTSB ATL96LA106Accident · Minor injuriesLimited investigationFinal reportBell 47G · Bartow, FLthe pilot's inadequate visual lookout, and his failure to maintain ground clearance, while maneuvering to avoid a collision with a utility line.Jul 9, 1996 · N6356 · DestroyedNTSB ATL96FA103Accident · 2 fatalField investigationFinal reportGeorge Evenson Cuby · Hawkinsville, GAThe failure of the pilot-in-command to maintain airspeed.Jul 9, 1996 · N1035W · DestroyedNTSB SEA96LA146Accident · 1 fatalLimited investigationFinal reportGrumman American AA-5B · St Maries, IDthe pilot's impairment of judgment and performance due to a drug (marijuana), and his failure to see-and-avoid power lines. The pilot's intentional low altitude flight was a related factor.Jul 8, 1996 · N28452 · DestroyedNTSB NYC96LA145Accident · Minor injuriesLimited investigationFinal reportBell 47G-5 · Carver, MAthe pilot's inadequate visual look out for obstacles, which resulted in a collision with wires and the ground.Jul 8, 1996 · N8591F · Substantial damageNTSB IAD96FA107Accident · 5 fatalField investigationFinal reportBell 206B · Salem, OHThe pilot's impairment of judgment and performance due to alcohol and the pilot's improper handling of the helicopter resulting in a loss of tail rotor effectiveness. A related factor was the pilot's disregard for the aircraft's weight and balance while…Jul 8, 1996 · N49578 · DestroyedNTSB ANC96LA097Accident · No injuriesLimited investigationFinal reportBell 206B · Juneau, AKThe pilot's failure to maintain proper alignment while lifting the helicopter to a hover and inducing a dynamic roll to avoid striking a passenger.Jul 8, 1996 · N2761F · Substantial damageNTSB LAX96LA265Accident · Minor injuriesLimited investigationFinal reportCessna 150L · California City, CAThe pilot's selection of an inadequate cruise altitude in an area of rising terrain and his failure to consider the effect of the high density altitude on the climb capability of the aircraft.Jul 7, 1996 · N332CS · DestroyedNTSB SEA96LA144Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Mcminnville, ORimproper maintenance (replacement) and inspection of the engine fuel governor by company maintenance personnel, the pilot's inadequate preflight inspection, and a subsequent disconnect of the adjustable governor lever control rod, which disabled the engine…Jul 6, 1996 · N5110Y · Substantial damageNTSB LAX96LA263Accident · No injuriesLimited investigationFinal reportBell 47G3 · Wasco, CAthe pilot's failure to maintain adequate engine rpm during an aerial application flight.Jul 6, 1996 · N154PG · Substantial damageNTSB FTW96LA313Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Corsicana, TXThe pilot's failure to maintain adequate airspeed. A factor was the high wind.Jul 4, 1996 · N71973 · Substantial damageNTSB IAD96LA103Accident · Serious injuriesLimited investigationFinal reportAero Commander Calair A-9B · Cloverdale, OHPowerplant failure due to undetermined reasons. Contributing to the severity of the crash was the unsuitable terrain in which the aircraft landed and post-crash fire.Jul 2, 1996 · N7730V · DestroyedNTSB NYC96LA135Accident · No injuriesLimited investigationFinal reportBell 206B III · South Carver, MAThe pilot's failure to maintain control of the helicopter during an aerial application maneuver. This put the helicopter in a low slow down wind, high power demand turn, where it encountered a loss of tail rotor effectiveness, and the subsequent collision…Jul 1, 1996 · N444JB · Substantial damageNTSB FTW96LA290Accident · No injuriesLimited investigationFinal reportCessna 172L · Johnstown, COfailure of the pilot to maintain proper altitude/clearance from obstructions, while buzzing.Jul 1, 1996 · N19682 · Substantial damageNTSB FTW96LA286Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Almyra, ARThe pilot's failure to maintain aircraft control. A factor was the pilot's excessive use of flaps during the maneuver.Jul 1, 1996 · N7314C · DestroyedNTSB CHI96LA223Accident · No injuriesLimited investigationFinal reportBell TH-13T · Mandan, NDthe pilot's failure to maintain clearance from known transmission lines. A factor relating to this accident was the sunglare which hindered the pilot's ability to see the transmission lines.Jun 30, 1996 · N96161 · Substantial damageNTSB CHI96LA222Accident · 1 fatalLimited investigationFinal reportPiper J3C-90 · Racine, WIwas improper remdial action by the pilot after encountering a stall when the elevator back pressure was not removed and the ailerons were positioned for a right bank by that increasing the airplane's left yaw/roll action. Factors in this accident were a stall…Jun 29, 1996 · N77563 · DestroyedNTSB MIA96LA166Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Lorida, FLfailure of company maintenance personnel to properly torque the tail rotor 90 degree gear box mounting bolts during installation, which resulted in failure of the mounting studs due to bending fatigue and subsequent separation of the gearbox.Jun 28, 1996 · N9846F · Substantial damageNTSB FTW96LA278Accident · Serious injuriesLimited investigationFinal reportRyan PT-22 · Krum, TXthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor was his lack of recent experience in the make and model of airplane.Jun 28, 1996 · N47621 · Substantial damageNTSB MIA96LA164Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Jonesville, SCthe pilot's inadequate visual lookout and failure to maintain altitude and/or clearance from the obstruction (power line) during low altitude flight. The lack of natural lighting at dusk was a related factor.Jun 26, 1996 · N3887R · Substantial damageNTSB CHI96LA217Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Ness City, KSthe failure of a counterweight bolt in the propeller for reasons undetermined. Factors were the wet landing area and the encounter with unsuitable terrain during the forced landing.Jun 26, 1996 · N8883S · Substantial damageNTSB FTW96LA274Accident · No injuriesLimited investigationFinal reportHughes 369HE · Las Cruces, NMthe pilot's failure to maintain clearance between the tail rotor and a fence while hovering.Jun 24, 1996 · N521TC · Substantial damageNTSB FTW96LA270Accident · Minor injuriesLimited investigationFinal reportAmerican AG5B · Longmont, COAn inadvertent stall spin. Factors were the pilot's intentional maneuver at an altitude insufficient to ensure a safe recovery, and overconfidence in his personal ability.Jun 24, 1996 · N227ER · DestroyedNTSB LAX96LA241Accident · No injuriesLimited investigationFinal reportCessna 182 · Mendota, CAThe pilot's decision to intentionally shut down the engine; his failure to verify the surface winds during the prolonged orbiting descent over the airport, which resulted in a final approach with a tailwind component; and his misjudging of the aircraft's…Jun 23, 1996 · N3675U · Substantial damageNTSB SEA96FA133Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Pomeroy, WAThe pilot's failure to maintain adequate clearance with the surrounding terrain while maneuvering to land. A factor was the rising terrain conditions.Jun 21, 1996 · N57514 · DestroyedNTSB LAX96LA239Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lamont, CAfailure of the pilot to see-and-avoid a guy wire along the border of a field that was being agriculturally treated. The sunglare, guy wire, and lack of visual cues were related factors.Jun 21, 1996 · N2456E · Substantial damageNTSB FTW96LA264Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Littlefield, TXThe total loss of engine power due to the failure of the number 5 and 6 connecting rods. A factor was the lack of suitable terrain for the forced landing.Jun 20, 1996 · N57836 · Substantial damageNTSB FTW96TA261Accident · Minor injuriesFinal reportBell 212 · Pagosa Springs, COThe pilot's failure to comply with performance data for hover out of ground effect. A factor was not attaining load jettison.Jun 18, 1996 · N91AL · DestroyedNTSB FTW96LA258Accident · Serious injuriesLimited investigationFinal reportAir Tractor 301A · Hunter, ARThe loss of engine power for undetermined reasons.Jun 18, 1996 · N7319C · DestroyedNTSB MIA96LA159Accident · No injuriesLimited investigationFinal reportCessna 150M · Knightdale, NCfailure of the flight instructor (CFI) to ensure proper use of the carburetor heat, which resulted in carburetor ice, loss of engine power, and a subsequent emergency landing.Jun 17, 1996 · N47ES · Substantial damageNTSB SEA96GA129Accident · Minor injuriesFinal reportCessna 182R · Grand View, IDfailure of the pilot to maintain clearance from mountainous terrain in a box canyon. The mountainous terrain and box canyon, limiting the pilot's ability to climb or maneuver and maintain sufficient altitude in the canyon, were related factors.Jun 15, 1996 · N6356N · Substantial damageNTSB FTW96FA250Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Monument, COThe pilot's VFR flight into instrument meteorological conditions in an aircraft which not instrument-equipped. Factors were clouds, low ceiling, and rain.Jun 15, 1996 · N111BF · DestroyedNTSB LAX96LA230Accident · Minor injuriesLimited investigationFinal reportAyres S2R · Oracle, AZthe pilot's improper decision to turn toward rising terrain, without releasing or jettisoning the load of fire retardant, while maneuvering at slow airspeed, which resulted in a stall/mush and collision with the terrain. Factors relating to the accident were:…Jun 14, 1996 · N4006K · DestroyedNTSB NYC96FA125Accident · 3 fatalField investigationFinal reportBeech V35 · Williamstown, NJinadequate supervision by the flight instructor (CFI); and failure of the pilot rated (dual) student to maintain control of the airplane during a simulated forced landing after takeoff, which resulted in a stall and collision with the terrain. Factors…Jun 13, 1996 · N2011W · DestroyedNTSB FTW96LA247Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Levelland, TXThe student pilot's improper use of mixture control resulting in a loss of engine power. A factor was the unsuitable terrain for the forced landing.Jun 13, 1996 · N17299 · Substantial damageNTSB LAX96LA220Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Placerville, CAthe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain sufficient altitude to clear surrounding terrain. A factor was the pilot's intentional buzzing.Jun 12, 1996 · N7880F · DestroyedNTSB CHI96LA194Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Cleveland, NDfailure of the pilot to maintain sufficient altitude or clearance from trees during an aerial application operation. The wires and trees (obstructions) were related factors.Jun 11, 1996 · N9844P · DestroyedNTSB FTW96FA243Accident · 1 fatalField investigationFinal reportAeronca 65-CA · Lonoke, ARThe pilot's failure to maintain aircraft control.Jun 10, 1996 · N36513 · Substantial damageNTSB LAX96FA223Accident · 3 fatalField investigationFinal reportCessna 172N · Bermuda Dunes, CAthe pilot's impairment of judgment and performance due to alcohol and drugs (methamphetamine, amphetamine, & marijuana), his excessive maneuvering (pull-up) after making a touch-and-go landing, and his failure to maintain sufficient airspeed, which resulted…Jun 9, 1996 · N734FB · DestroyedNTSB FTW96LA244Accident · No injuriesLimited investigationFinal reportHughes 269 · Dallas, TXThe student pilot's encounter with dynamic rollover while hovering. Factors were the prevailing high winds and the inadequate supervision provided by the flight instructor.Jun 8, 1996 · N269A · Substantial damageNTSB SEA96LA114Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Roundup, MTfailure of the pilot to maintain adequate airspeed, during a turn-around maneuver after a swath run, which resulted in an inadvertent stall.Jun 7, 1996 · N4970J · DestroyedNTSB SEA96LA112Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Prescott, WAfailure of the pilot to visually clear his flight path, after allowing his attention to be diverted, and his resultant failure to maintain sufficient altitude/clearance from a hill. The hilly terrain was a related factor.Jun 6, 1996 · N9793 · Substantial damageNTSB MIA96FA148Accident · 1 fatalField investigationFinal reportAeronca O-58B · Greenville, SCthe pilot's failure to maintain adequate altitude/clearance from power lines while maneuvering at a low altitude.Jun 5, 1996 · N49546 · Destroyed