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 NYC93LA088Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-150 · Nellysford, VAThe pilot's inadequate inflight decision and planning, and his failure to maintain an altitude adequate for terrain avoidance.Apr 19, 1993 · N1494P · Substantial damageNTSB NYC93LA086Accident · No injuriesLimited investigationFinal reportPitts S1T · Halifax, MADetachment of the throttle cable at the fuel injector arm. Soft terrain in the emergency landing area was a related factor.Apr 18, 1993 · N200ST · Substantial damageNTSB CHI93FA137Accident · 2 fatalField investigationFinal reportCessna 177B · Rensselaer, INThe pilot-in-command's failure to maintain aircraft control. Factors were fog and drizzle, and the pilot-in-command's continuing VFR flight into IMC conditions.Apr 15, 1993 · N973CQ · DestroyedNTSB SEA93FA094Accident · Serious injuriesField investigationFinal reportGrumman A6E · Steptoe, WAThe inherent limitations of the see-and-avoid concept of separation of aircraft operating under visual flight rules that precluded the crew of the A6E and the pilot of the agcat from recognizing a collision hazard and taking actions to avoid a midair…Apr 14, 1993 · USN · 2 aircraft · DestroyedNTSB FTW93FA126Accident · Serious injuriesField investigationFinal reportWard Pitts Special WSC-1 · Fort Worth, TXThe fire extinguisher in the cockpit came loose and jammed the right rudder pedal.Apr 12, 1993 · N12RW · DestroyedNTSB ATL93LA071Accident · 1 fatalLimited investigationFinal reportKertesz Woody Pusher · Bradley, FLThe pilot's failure to maintain airspeed during maneuvering flight, which resulted in a stall/spin and collision with the terrain.Apr 12, 1993 · N48288 · DestroyedNTSB NYC93FA079Accident · 2 fatalField investigationFinal reportAerotek Pitts S-2B · North Benton, OHThe pilot's failure to maintain adequate aircraft control due to alcohol impairment.Apr 10, 1993 · N5306N · DestroyedNTSB CHI93LA134Accident · 1 fatalLimited investigationFinal reportCessna T188C · Belview, MNThe pilot-in-command's not maintaining proper altitude.Apr 10, 1993 · N2975J · DestroyedNTSB LAX93LA167Accident · Serious injuriesLimited investigationFinal reportAero Commander ST-R · San Jose, CAThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin.Apr 7, 1993 · N1783S · DestroyedNTSB FTW93FA117Accident · 1 fatalField investigationFinal reportBeech C-45H · Mooringsport, LAA total loss of right engine power, and a partial loss of left engine power, for undetermined reasons.Apr 6, 1993 · N492DM · DestroyedNTSB CHI93FA133Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Plattsmouth, NEThe pilot-in-command (CFI)'s failure to maintain airspeed.Apr 6, 1993 · N2530B · DestroyedNTSB SEA93FA091Accident · 4 fatalField investigationFinal reportLake LA-4-200 · Gold Bar, WAThe pilot's failure to maintain adequate airspeed while maneuvering for a water landing.Apr 4, 1993 · N39375 · Substantial damageNTSB MIA93LA096Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Fort Walton Bch, FLThe pilot-in-command's failure to visually inspect the grapple hook/cable after deployment, to ensure it was free from all control surfaces prior to initiating a banner pickup.Apr 3, 1993 · N7011K · Substantial damageNTSB LAX93FA160Accident · 4 fatalField investigationFinal reportCessna 172P · Livermore, CAThe pilot's decision to attempt VFR flight into instrument meteorological conditions. Factors that contributed to this accident were: the pilot's lack of recent instrument experience, the rain and high wind conditions in the area.Apr 1, 1993 · N97462 · DestroyedNTSB ATL93LA067Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G102 · Kingston, GAThe pilot's attempted return to the departure runway that resulted in a stall at an altutude that was too low to permit recovery.Apr 1, 1993 · N792G · Substantial damageNTSB SEA93LA085Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164A · Walla Walla, WAA loss of engine power for undetermined reasons. The lack of a suitable landing area was a factor.Mar 30, 1993 · N8734H · DestroyedNTSB FTW93LA114Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Des Arc, ARThe pilot's loss of outside visual reference and loss of control.Mar 30, 1993 · N4437S · DestroyedNTSB SEA93LA082Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Jordan Valley, ORThe pilot continued the VFR flight into IMC and failed to maintain clearance from obstacles on the ground. Factors relating to the accident were the clouds, low ceiling, and rain.Mar 26, 1993 · N3986J · DestroyedNTSB LAX93LA157Accident · Minor injuriesLimited investigationFinal reportBell 47G5 · Greenfield, CAThe pilot's failure to maintain an adequate clearance from the power lines while performing an aerial application run.Mar 20, 1993 · N7080J · Substantial damageNTSB ANC93FA045Accident · 1 fatalField investigationFinal reportPiper PA-14 · Rainey Pass, AKThe pilot-in-command's attempt to fly VFR in IMC conditions. Factors were the mountainous terrain and whiteout conditions.Mar 20, 1993 · N5153H · Substantial damageNTSB ANC93LA044Accident · No injuriesLimited investigationFinal reportCessna 185 · Barrow, AKThe pilot in command inadvertently stalling the airplane.Mar 14, 1993 · N61500 · Substantial damageNTSB LAX93FA144Accident · 1 fatalField investigationFinal reportCessna 152 · Apple Valley, CAThe pilot inadvertently stalled the airplane near the ground. The intentional buzzing, over confidence in his personal ability, and poor inflight planning/decision were factors.Mar 8, 1993 · N48860 · DestroyedNTSB BFO93LA045Accident · Serious injuriesLimited investigationFinal reportPitts S-2B · Hillsboro, MDFailure of the pilot to maintain airspeed, while performing aerobatic maneuvers, which resulted in an inadvertent flat spin and an uncontrolled descent into terrain.Mar 7, 1993 · N12QW · DestroyedNTSB ANC93LA040Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Iliamna, AKThe pilot in commands attempt to conduct a visual flight during instrument meteorological conditions and his failure to maintain control of the aircraft during the emergency 180 degree turn maneuver to reverse direction. Factors in the accident were the snow…Mar 7, 1993 · N67559 · DestroyedNTSB CHI93FA103Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Newton, IAVFR flight into IMC conditions. Factors related to the accident were fog, and the pilot's lack of total instrument time.Mar 6, 1993 · N1646J · DestroyedNTSB SEA93IA073Incident · No injuriesIncident investigationFinal reportHughes 269B · Mcminnville, ORAn inflight loss of control, and inadequate remedial action. Factors include a tailwind, and gusts.Mar 5, 1993 · N9474F · Minor damageNTSB LAX93LA148Accident · 1 fatalLimited investigationFinal reportLangerud Varieze · Zenia, CAThe pilot's poor weather evaluation and continued flight into instrument meteorological conditions. The low ceiling was a factor.Mar 2, 1993 · N91CL · DestroyedNTSB FTW93LA090Accident · Minor injuriesLimited investigationFinal reportBell 206B · Oklahoma City, OKThe passengers inadvertent control interference. A factor was the pilot's inadequate supervision of the passengerFeb 23, 1993 · N224TV · Substantial damageNTSB FTW93LA091Accident · No injuriesLimited investigationFinal reportCessna 150H · Adkins, TXThe student pilot's failure to maintain clearance while maneuvering. A factor was the student's diverted attention from the open engine inspection doorFeb 20, 1993 · N6623S · Substantial damageNTSB ANC93FA033Accident · 2 fatalField investigationFinal reportBell 214B1 · Ketchikan, AKInadequate maintenance of the hydraulic servo actuator which led to the fatigue failure and loss of flight control. In addition, the flightcrew did not, or was unable to, jettison the external load. Factors which contributed to the accident were: the pilot…Feb 19, 1993 · N114CR · DestroyedNTSB LAX93FA118Accident · 1 fatalField investigationFinal reportBeech E33 · Avalon, CAThe pilot's alcoholic impairment of efficiency and judgement which resulted in his attempt to perform aerobatics at night in hilly terrain at an altitude inadequate for terrain clearance.Feb 16, 1993 · N7882R · DestroyedNTSB FTW93LA083Accident · No injuriesLimited investigationFinal reportSwearingen SA-26AT · Ardmore, OKPilot's failure to refuel and fuel exhaustion. Factors were a fuel leak in the wing and unsuitable terrainFeb 10, 1993 · N34UA · DestroyedNTSB MIA93FA065Accident · 2 fatalField investigationFinal reportForney Ercoupe F-1 · Aguadilla, PRExcessive elevator control input by an unknown occupant at an airspeed above maneuvering speed which caused both forward wing spars to fail. Contributing to the accident was fuel exhaustion due to poor in flight planning/decision by the pilot-in-command and…Feb 8, 1993 · N7555C · DestroyedNTSB FTW93LA081Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Vermillion 39The pilot's failure to maintain proper altitude.Feb 8, 1993 · N2244W · Substantial damageNTSB SEA93LA064Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Bend, ORRotor RPM was not maintained. Factors to the accident were: low ceiling and poor inflight planning.Feb 7, 1993 · N4085M · Substantial damageNTSB FTW93FA080Accident · 2 fatalField investigationFinal reportCessna 140 · Jefferson, TXInadvertent stall. A factor was the pilot's performance of aerobatics at low altitudeFeb 7, 1993 · N76970 · DestroyedNTSB SEA93LA063Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Salem, ORA complete loss of power for undetermined reasons. Factors include unsuitable terrain, and trees surrounding the forced landing site.Feb 5, 1993 · N2019N · Substantial damageNTSB ATL93LA056Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-400 · South Mills, NCThe pilot's failure to maintain adequate clearance from trees during an aerial application maneuver. Factors were the trees adjacent to the wheat field, and the soft terrain.Feb 5, 1993 · N36521 · Substantial damageNTSB SEA93LA060Accident · No injuriesLimited investigationFinal reportCessna 206G · Keuterville, IDThe pilot's inadequate visual lookout. Factors include a power line in the vicinity of the airstrip.Feb 3, 1993 · N2837J · Substantial damageNTSB DEN93LA026Accident · No injuriesLimited investigationFinal reportRaven RX7 · Durango, COPartial failure of the balloon's burner for undetermined reasons. A factor was: unfavorable wind.Jan 31, 1993 · N3581T · Substantial damageNTSB LAX93LA104Accident · 4 fatalLimited investigationFinal reportFairchild Hiller FH-1100 · Volcano Natl Pk, HIA loss of tail rotor control for an undetermined reason(s). A factor which contributed to the accident was the pilot's choice of a hover altitude/position inadequate to reach a shoreline in the event of an emergency. A factor which contributed to the severity…Jan 25, 1993 · N427FH · DestroyedNTSB LAX93LA100Accident · 1 fatalLimited investigationFinal reportWohlers Steen Skybolt · Fountain Hills, AZThe pilot's initiation of a low level aerobatic maneuver at an altitude insufficient to ensure adequate terrain clearance.Jan 23, 1993 · N8LW · DestroyedNTSB LAX93LA092Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Watsonville, CAPilot's poor visual look-out. A factor relating to this accident was that the pilot diverted his attention.Jan 18, 1993 · N2304P · Substantial damageNTSB SEA93LA054Accident · 1 fatalLimited investigationFinal reportStinson 108-2 · Fruit Heights, UTVFR flight into IMC conditions was attempted by the pilot. Factors include rain, snow, and fog.Jan 16, 1993 · N8004K · DestroyedNTSB FTW93LA071Accident · Minor injuriesLimited investigationFinal reportKeller Varieze · Portland, TXA loss of engine power due to carburetor icing and the lack of suitable terrain for a forced landing.Jan 16, 1993 · N90LH · DestroyedNTSB FTW93LA069Accident · Minor injuriesLimited investigationFinal reportPitts S1C · Godley, TXThe partial power loss due to the pilot's delayed application of carburetor heat. Factors were carburetor ice, and the sloping terrainJan 15, 1993 · N22R · Substantial damageNTSB MIA93LA047Accident · 1 fatalLimited investigationFinal reportCessna 337H · New Smyrna Bch, FLThe pilot-in-command's failure to maintain altitude while maneuvering in a turn at a low altitude, resulting in an in-flight collision with the ocean.Jan 9, 1993 · N1443S · DestroyedNTSB CHI93LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · La Pointe, WISpatial disorientation of the pilot.Jan 9, 1993 · N7057B · Substantial damageNTSB SEA93GA049Accident · No injuriesFinal reportPiper PA-18-135 · Council, IDThe pilot's failure to maintain proper altitude during the low pass. The snow covered terrain and the pilot's inadequate preflight preparation were factors.Jan 7, 1993 · N9841Q · Substantial damageNTSB MIA93LA046Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Holly Springs, MSThe pilot-in-command's failure to maintain airspeed while maneuvering during a forced landing, resulting in an in-flight loss of control (stall), and subsequent collision with terrain. Contributing to the accident was a total loss of engine power in flight…Jan 6, 1993 · N22761 · Substantial damage