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 SEA94LA113Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Monarch, MTPoor in flight planning/decision. A factor to the accident was downdrafts.Apr 30, 1994 · N739CW · Substantial damageNTSB FTW94FA140Accident · 2 fatalField investigationFinal reportCessna 150M · Arroyo City, TXThe pilot's inadvertent stall during the pull up. Factors were the low pass, his ostentatious display, and his inability to recover from the stall due to insufficient altitude.Apr 30, 1994 · N190AR · DestroyedNTSB ATL94LA087Accident · No injuriesLimited investigationFinal reportCessna 182B · Ellijay, GAThe inadvertent deployment of the parachute because of the jumpmaster's inattention to the static line.Apr 30, 1994 · N2673G · Substantial damageNTSB FTW94FA138Accident · 2 fatalField investigationFinal reportCessna A150K · Mccrory, ARWas the inadvertent stall and spin. Factors were the pilot's performance of aerobatics at an inadequate altitude.Apr 27, 1994 · N8457M · DestroyedNTSB SEA94LA109Accident · Minor injuriesLimited investigationFinal reportBell 206B · Summerville, ORThe pilot did not maintain clearance from the wires. The overcast sky condiiton was a factor.Apr 25, 1994 · N35BL · DestroyedNTSB SEA94LA107Accident · No injuriesLimited investigationFinal reportRich RV-4 · Weston, IDThe pilot's failure to use carburetor heat. Factors include carburetor icing conditions, and no suitable site for a forced landing.Apr 23, 1994 · N3344E · Substantial damageNTSB FTW94LA134Accident · Serious injuriesLimited investigationFinal reportWeatherly 201C · Sterling, COAn inadvertent stall. Factors were fuel exhaustion and the pilot's failue to refuel the airplane.Apr 23, 1994 · N1295W · DestroyedNTSB CHI94FA140Accident · 1 fatalField investigationFinal reportVavra, Martin A. Rebel 300 · Wonderlake, ILFatigue and catastrophic failure of the main wing spar resulting from the designer's excessive, unverified estimate of the strength of the spar cap material and the manufacturer's failure to attain the specified strength during the production process.Apr 23, 1994 · N12MV · DestroyedNTSB LAX94LA199Accident · 1 fatalLimited investigationFinal reportContinental Copters Tomcat MK5A · Brawley, CAFailure of the pilot to maintain sufficient altitude, while maneuvering to land after completing aerial application. Factors related to the accident were: darkness and the lack of visual cues for the pilot to detect the obstruction (power line).Apr 22, 1994 · N9061T · DestroyedNTSB CHI94FA137Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Marshfield, MOFailure of the pilot to maintain proper altitude during a VFR flight into IMC conditions.Apr 22, 1994 · N5581F · DestroyedNTSB CHI94LA139Accident · No injuriesLimited investigationFinal reportCessna 172K · Howes, SDThe diverted attention of the pilot-in-command and his failure to maintain proper altitude.Apr 20, 1994 · N46474 · Substantial damageNTSB ATL94LA084Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ozark, ALA loss of engine power for undetermined reasons. A factor was the soft terrain.Apr 20, 1994 · N48717 · Substantial damageNTSB LAX94FA197Accident · 1 fatalField investigationFinal reportHughes 369D · Hanapepe, HIInadequate turbine engine compressor cleaning procedures based on information in the manufacturer's service letter, and loss of engine power due to blockage of the fuel nozzle strainer with foreign material (sodium). Factors related to the accident were: the…Apr 18, 1994 · N1103N · DestroyedNTSB LAX94LA200Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Yuma, AZan uncommanded engine deceleration to idle due to the improper installation of the throttle arm on the carburetor shaft.Apr 17, 1994 · N304JP · Substantial damageNTSB LAX94LA194Accident · 1 fatalLimited investigationFinal reportPitts S-2A · Kahuku, HIThe failure of the pilot to maintain aircraft control due to spatial disorientation while performing an acrobatic routine. A factor in the accident was the low altitude at which the pilot was performing the acrobatic maneuvers.Apr 17, 1994 · N54TA · DestroyedNTSB LAX94LA192Accident · No injuriesLimited investigationFinal reportCessna 172F · Arlington, CAFailure of the certified flight instructor to properly supervise the student pilot and perform the appropriate remedial action before the airplane descended to an altitude too low for recovery. Factors were the student pilot's handling of the airplane which…Apr 17, 1994 · N5709R · Substantial damageNTSB LAX94LA190Accident · 2 fatalLimited investigationFinal reportBushby Mustang II · Byron, CAan abrupt maneuver by the pilot that initiated an in-flight separation of the tail and wing sections during acrobatic flight.Apr 17, 1994 · N363RD · DestroyedNTSB FTW94FA123Accident · 1 fatalField investigationFinal reportSIAI-Marchetti F.260C · Watson, ARThe pilot's failure to maintain adequate clearance from wires during low level flight which resulted in a severed aileron cable. Factors were the pilot's failure to maintain adequate altitude during the flight and his inability to control the airplane…Apr 17, 1994 · N14FD · DestroyedNTSB BFO94LA068Accident · No injuriesLimited investigationFinal reportCessna 150H · Mount Vernon, OHThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and collision with the ground. Factors were transmission wires and the pilot's inadequate inflight decision.Apr 17, 1994 · N22601 · Substantial damageNTSB FTW94LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-260 · Muskogee, OKThe pilot's failure to maintain clearance with the power line. Factors were a chemical spray contaminated windscreen, the resultant limitation to visibility, and sun glare.Apr 16, 1994 · N4647Y · Substantial damageNTSB FTW94LA124Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Englewood, COThe pilot's failure to maintain rotor RPM, his delayed flare, and improper touchdown. A factor was a failure of the fuel control/governor to the high side which required the pilot to perform a full autorotation.Apr 15, 1994 · N937S · Substantial damageNTSB SEA94FA100Accident · 2 fatalField investigationFinal reportCessna 182Q · The Dalles, ORAn inflight loss of control for undetermined reasons.Apr 14, 1994 · N4887N · DestroyedNTSB LAX94LA188Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Willcox, AZEngine power loss due to fuel contamination as a result of inadequate inspection of the fuel and fuel system.Apr 13, 1994 · N5827U · Substantial damageNTSB FTW94FA121Accident · 1 fatalField investigationFinal reportAir Tractor AT-502 · Hughes, ARWas the pilot's failure to maintain terrain clearance for undetermined reason.Apr 13, 1994 · N9086V · DestroyedNTSB SEA94LA098Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Troutdale, ORThe instructor pilot's inadequate remedial action. Factors include the dual student's lack of experience, and his failure to maintain directional control. Another factor was unfavorable, gusty winds.Apr 12, 1994 · N2865B · Substantial damageNTSB ATL94LA079Accident · No injuriesLimited investigationFinal reportCessna 150 · Hazel Green, ALThe loss of engine power when the fractured piece of the rocker boss interrupted the normal operation of a movable component under the valve cover. A factor was the soft terrain in the landing area.Apr 11, 1994 · N11560 · Substantial damageNTSB MIA94LA119Accident · No injuriesLimited investigationFinal reportGlobe 9C-1B · Okeechobee, FLBoth pilots misjudged their clearance from each other.Apr 10, 1994 · N78321 · 2 aircraft · Substantial damageNTSB MIA94LA116Accident · Serious injuriesLimited investigationFinal reportBell 206B · Mayaguez, PRLoss of engine power for undetermined reasons which resulted in a descent and ditching.Apr 10, 1994 · N39125 · Substantial damageNTSB ANC94LA045Accident · No injuriesLimited investigationFinal reportHiller UH12E · Valdez, AKThe inadvertent closure of the fuel supply shutoff valve.Apr 9, 1994 · N87594 · Substantial damageNTSB MIA94FA114Accident · 1 fatalField investigationFinal reportPiper PA-12 · Merritt Island, FLThe loss of elevator control due to jamming by the tow rope which prevented the pilot from being able to control the airplane.Apr 7, 1994 · N2834M · Substantial damageNTSB FTW94LA118Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Elaine, ARThe pilot's failure to maintain terrain clearance.Apr 5, 1994 · N3094F · Substantial damageNTSB NYC94LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · White Plains, NYThe partial loss of engine power as the result of a disconnected throttle cable, and the subsequent forced landing and ditching in water to avoid collision with trees.Apr 4, 1994 · N5335T · Substantial damageNTSB SEA94FA096Accident · 4 fatalField investigationFinal reportBell 206B3 · Lamoille, NVThe ingestion of foreign material (snow) in the engine, which resulted in a flameout (loss of engine power). Factors related to the accident were: the adverse weather conditions (snow falling & high density altitude), the lack of snow covers to protect the…Apr 3, 1994 · N27736 · DestroyedNTSB FTW94LA119Accident · Serious injuriesLimited investigationFinal reportCessna 208 · Whitewright, TXThe inadvertent stall when too many parachutist hung on the outside of the aircraft.Apr 3, 1994 · N9421F · Minor damageNTSB SEA94LA094Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Rimrock, WAFuel exhaustion, the pilot in command's failure to refuel the aircraft, and the inability to successfully execute an auto- rotation landing because of the low altitude.Apr 1, 1994 · N5211R · Substantial damageNTSB MIA94LA105Accident · 1 fatalLimited investigationFinal reportWallace Thorp T-18 · Boynton Beach, FLThe pilot in command's exceeding the designed stress limits of the aircraft resulting in overload failure of the left wing outboard attach fitting. This resulted in inflight separation of the outboard left wing, and subsequent inflight collision with the…Mar 27, 1994 · N215CK · DestroyedNTSB LAX94LA174Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Hi. Nat'L Park, HIthe pilot's in-flight decision to maneuver the helicopter close to an active volcano steam vent which resulted in a whiteout condition from the steam, and the pilot's subsequent loss of visual contact with the ground.Mar 26, 1994 · N113RS · Substantial damageNTSB ATL94LA069Accident · Minor injuriesLimited investigationFinal reportCessna 150L · N. Myrtle Beach, SCThe improper procedures used by ground personnel during banner tow operations.Mar 26, 1994 · N16233 · Substantial damageNTSB NYC94LA073Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G109B · Nashua, NHThe certified flight instructor's delay in taking remedial action, which resulted in the motor-glider colliding with trees.Mar 25, 1994 · N403DW · Substantial damageNTSB LAX94LA168Accident · Serious injuriesLimited investigationFinal reportFighter Rebuilders F-2G · Mesa, AZthe airplane sustained a total loss of power and an in-flight fire for undetermined reasons.Mar 19, 1994 · N31518 · DestroyedNTSB FTW94FA102Accident · 4 fatalField investigationFinal reportTaylorcraft DCO-65 · San Antonio, TXThe failure of the pilot of the other aircraft to maintain adequate clearance during formation flight. A factor was the pilot's inadequate preflight planning and preparation regarding inflight formation procedures.Mar 19, 1994 · N596BH · 2 aircraft · DestroyedNTSB FTW94LA103Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140B · Montrose, COThe pilot's failure to maintain clearance.Mar 17, 1994 · CGUFK · DestroyedNTSB FTW94LA098Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Moro, ARThe pilot's failure to maintain clearance of power lines.Mar 16, 1994 · N9189Y · DestroyedNTSB FTW94LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Lamesa, TXThe inadvertent stall. A factor was the gust of wind.Mar 15, 1994 · N8739L · Substantial damageNTSB CHI94LA106Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Sublette, KSthe commercial pilot's failure to maintain clearance from terrain. Related factors are sun glare and rising terrain.Mar 15, 1994 · N9686 · Substantial damageNTSB SEA94LA081Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Dubois, IDThe pilot's inadequate visual lookout. Factors include light conditions at dusk.Mar 14, 1994 · N40318 · Substantial damageNTSB FTW94LA097Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Hamburg, ARThe loss of engine power due to fouled spark plugs. A factor was the lack of suitable terrain for the forced landing.Mar 14, 1994 · N6665Q · Substantial damageNTSB LAX94LA160Accident · 1 fatalLimited investigationFinal reportAmerican Champion 8KCAB · Marana, AZThe pilot's delayed pullout from a vertical aerobatic maneuver for undetermined reasons.Mar 12, 1994 · N189AC · DestroyedNTSB CHI94FA097Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Inman, KSAn unintentional spin which occurred during the maneuvering phase of a biennial flight review. A factor related to the accident was: the airplane's lateral-directional characteristics at or near the stall speed.Mar 5, 1994 · N2495L · DestroyedNTSB SEA94FA071Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Frenchglen, ORThe pilot's failure to maintain minimum airspeed (vs). The tailwind was a factor.Mar 2, 1994 · N82951 · Destroyed