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 LAX93LA290Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Buckeye, AZthe pilot's failure to visually detect and avoid a power line. A factor in the accident was the twilight light condition.Jul 15, 1993 · N40203 · DestroyedNTSB DEN93LA081Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Dermott, ARPower loss due to the total failure of the engine's master rod. Factors were an improper engine overhaul and the lack of suitable terrain for a forced landing.Jul 15, 1993 · N1009T · Substantial damageNTSB DEN93LA079Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Burkburnett, TXThe disconnection of the up elevator cable from the control horn. A factor was the incorrect installation of the bolt and castle nut by unknown maintenance personnel.Jul 15, 1993 · N4834M · Substantial damageNTSB MIA93GA154Accident · 4 fatalFinal reportSikorsky UH-60A · Hortense, GAThe pilot-in-command's inadequate supervision of the flight, the co-pilot's failure to maintain an adequate altitude, and the failure of both pilots to see and avoid the wires. Contributing to the accident was the pilot-in-command's inadequate preflight…Jul 14, 1993 · USA · DestroyedNTSB DEN93LA076Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Kaplan, LAFailure of the spray rig which sprayed chemicals into the pilot's eyes temporarily blinding him.Jul 12, 1993 · N9680 · Substantial damageNTSB CHI93LA251Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Clarence, MOIs the pilot in command's failure to maintain proper clearance. A factor to the accident were the trees at the end of the field to be sprayed.Jul 12, 1993 · N8906L · Substantial damageNTSB CHI93DEE03Accident · Serious injuriesFinal reportMaxair MU532 · Fox Lake, ILthe failure of the pilot to maintain the necessary altitude above the terrain.Jul 12, 1993 · NONE · Substantial damageNTSB BFO93FA119Accident · 1 fatalField investigationFinal reportBellanca 8GCBC · Berlin, MDFailure of the pilot to maintain airspeed during pullup from an attempted banner pickup, which resulted in a stall.Jul 12, 1993 · N88189 · DestroyedNTSB ATL93FA127Accident · 1 fatalField investigationFinal reportHughes 369HS · Talladega, ALThe pilot's poor in-flight decision to land downwind in a confined area that was surrounded by high obstructions, and his failure to properly compensate for the tailwind condition. A factor related to the accident was: the pilot's lack of total experience in…Jul 12, 1993 · N9116F · Substantial damageNTSB DEN93LA077Accident · 2 fatalLimited investigationFinal reportWeedhopper B · Port Arthur, TXThe failure of the wing fabric and wing spar. Factors were: the improper design change, major repair, and rebuilding of the aircraft by the pilot in command.Jul 11, 1993 · UNREG · DestroyedNTSB BFO93LA117Accident · Serious injuriesLimited investigationFinal reportHolmes Special · Chavies, KYFuel starvation due to the pilot's improper decision to take off with a low fuel level. Factors related to the accident were the low fuel level, the pilot's lack of familiarity with the characteristics of the fuel system, and the uneven terrain in the…Jul 11, 1993 · N485MH · DestroyedNTSB BFO93LA116Accident · 1 fatalLimited investigationFinal reportMaule M-6-235 · Willoughby, OHFailure of the pilot to maintain adequate airspeed during a pullup maneuver, which resulted in a stall. A factor related to the accident was the lack of altitude for recovery.Jul 11, 1993 · N56476 · DestroyedNTSB FTW93FA211Accident · 1 fatalField investigationFinal reportRockwell S-2R · Bastrop, LAThe pilot's failure to maintain terrain clearance.Jul 10, 1993 · N8512V · DestroyedNTSB CHI93FA249Accident · Serious injuriesField investigationFinal reportAmerican Eurocopter AS350BA · West Plains, MOUndetermined.Jul 10, 1993 · N350BA · DestroyedNTSB CHI93FA247Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Houghton, MIThe pilot's failure to maintain sufficient airspeed while maneuvering which resulted in a stall/mush. Intentional buzzing was a factor.Jul 9, 1993 · N6279A · DestroyedNTSB SEA93FA151Accident · 1 fatalField investigationFinal reportPiper PA-12 · Laramie, WYPoor inflight planning and an inadvertent stall.Jul 8, 1993 · N3108M · Substantial damageNTSB LAX93FA281Accident · 1 fatalField investigationFinal reportRobinson R22B · Honolulu, HIThe instructor allowing the student fly solo in wind conditions exceeding the maximum allowable winds in the training syllabus, and also near the maximum demonstrated controllability envelope for the helicopter. Factors which contributed to the accident were…Jul 8, 1993 · N501R · DestroyedNTSB FTW93LA212Accident · No injuriesLimited investigationFinal reportCessna A188B · Temple, TXPilot's failure to maintain proper object/terrain clearance. Factors were tailwinds and high density altitude.Jul 8, 1993 · N4739R · Substantial damageNTSB DEN93FA075Accident · 1 fatalField investigationFinal reportWiley Pitts S-1-E · Walters, OKPerformance of an aerobatic maneuver at an altitude insufficient for adequate terrain clearance.Jul 8, 1993 · N70BW · DestroyedNTSB LAX93LA277Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Torrance, CAAn encounter with a windshear condition. The delayed banner jettison was a factor.Jul 5, 1993 · N79034 · Substantial damageNTSB FTW93LA203Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA316B · Snyder, TXFailure of the pilot in command to properly compensate for wind conditions resulting in the loss of directional control through loss of tail rotor authority. Factors were high winds, high density altitude, and failure to jettison the external load.Jul 4, 1993 · N3154Y · Substantial damageNTSB BFO93LA106Accident · 1 fatalLimited investigationFinal reportWernega Benson KB-2 · Mount Holly, NJThe pilot's improper use of the gyroplane's flight controls.Jul 4, 1993 · N6606B · DestroyedNTSB ATL93LA123Accident · 1 fatalLimited investigationFinal reportGulfstream G-164B · Selmer, TNThe pilot's failure to maintain adequate clearance from the power lines.Jul 2, 1993 · N8163K · DestroyedNTSB ATL93LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Seneca, SCThe pilot's improper preflight planning which resulted in fuel exhaustion.Jul 2, 1993 · N5812A · Substantial damageNTSB ATL93LA121Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAThe pilot's failure to maintain adequate clearance from the ground.Jul 2, 1993 · N8659L · Substantial damageNTSB NYC93FA133Accident · 2 fatalField investigationFinal reportAmerican General AA-1 · Vestal, NYThe loss of engine power due to fuel starvation from a fuel leak caused by inadequate maintenance by unqualified personnel, the pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and collision with the ground.Jun 29, 1993 · N5932L · DestroyedNTSB CHI93FA238Accident · 3 fatalField investigationFinal reportBeech 58 · Beardstown, ILthe pilot-in-command's continued VFR flight into IMC and his failure to maintain control of the airplane. Factors were the fog, drizzle, and an abrupt maneuver by the pilot-in-command.Jun 29, 1993 · N120TW · DestroyedNTSB ATL93LA118Accident · No injuriesLimited investigationFinal reportCessna 188B · Centre, ALThe failure of maintenance personnel to properly torque the crankcase through bolts.Jun 29, 1993 · N731DH · Substantial damageNTSB SEA93LA142Accident · Serious injuriesLimited investigationFinal reportWeatherly 201B · Wilbur, WAVisual lookout was not maintained. The wires were a factor.Jun 28, 1993 · N1266W · Substantial damageNTSB NYC93LA139Accident · 1 fatalLimited investigationFinal reportTitan Tornado · East Moriches, NYFailure of the pilot to maintain adequate airpseed, which resulted in an inadvertent stall and collision with the terrain.Jun 28, 1993 · UNREG · Substantial damageNTSB CHI93FA234Accident · 1 fatalField investigationFinal reportCessna 210D · Salem, MIthe pilot's physical impairment.Jun 28, 1993 · N3899Y · DestroyedNTSB DEN93LA070Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Boulder, COA failure by the pilot flying to adequately compensate for wind conditions which led to a loss of tail rotor control. A factor was: inadequate supervision by the pilot in command.Jun 27, 1993 · N625H · Substantial damageNTSB CHI93LA236Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Waukesha, WIThe pilot's failure to maintain airspeed above a stall.Jun 27, 1993 · N83429 · Substantial damageNTSB NYC93FA127Accident · 2 fatalField investigationFinal reportBoeing Stearman PT-17 · Concord, NHLoss of airplane control as the result of incapacitation.Jun 26, 1993 · N58212 · DestroyedNTSB FTW93FA197Accident · 1 fatalField investigationFinal reportAir Tractor AT-502 · Petronila, TXFailure of the pilot to maintain sufficient airspeed, while maneuvering, which resulted in an inadvertent stall. A factor related to the accident was: his lack of altitude for recovery from the stall.Jun 26, 1993 · N1504Q · DestroyedNTSB NYC93LA126Accident · No injuriesLimited investigationFinal reportRobinson R22 · Sanford, METhe pilot's failure to maintain directional control of the helicopter while hovering, resulting in the main rotor blades impacting the ground.Jun 24, 1993 · N8557Y · Substantial damageNTSB CHI93FA218Accident · 1 fatalField investigationFinal reportCessna 172F · Miami, MOthe pilot's failure to maintain aircraft control.Jun 21, 1993 · N5461R · DestroyedNTSB SEA93LA135Accident · Minor injuriesLimited investigationFinal reportBell 206B · Harlem, MTThe improper refueling system procedures which allowed water to contaminate the aircraft fuel and the pilot's inadequate preflight.Jun 20, 1993 · N33EA · Substantial damageNTSB MIA93FA145Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Pensacola, FLThe pilot's failure to maintain control of the airplane due to alcohol impairment. The dark night was a contributing factor.Jun 20, 1993 · N2534B · DestroyedNTSB FTW93LA193Accident · Serious injuriesLimited investigationFinal reportCessna AT188B · Holly Grove, ARTotal loss of power due to fuel exhaustion due to the pilot not refueling. A factor was the lack of suitable terrain for the forced landing.Jun 19, 1993 · N4804Q · Substantial damageNTSB NYC93FA118Accident · 3 fatalField investigationFinal reportCessna P210 · Marthas Vineyrd, MAThe pilot's failure to maintain control of the airplane.Jun 18, 1993 · N73CE · DestroyedNTSB SEA93LA132Accident · Minor injuriesLimited investigationFinal reportCessna T-188C · Augusta, MTThe pilot's failure to maintain airspeed and terrain clearance while maneuvering on an aerial application flight. A factor relating to the accident was the pilot's diverted attention.Jun 17, 1993 · N9952J · Substantial damageNTSB CHI93LA208Accident · No injuriesLimited investigationFinal reportHughes 269 · Valley City, NDthe pilot-in-command's failure to maintain clearance from a tree during an aerial application manuever.Jun 15, 1993 · N213MS · Substantial damageNTSB NYC93FA110Accident · 1 fatalField investigationFinal reportSkillman Thorp T-18 · Chatham, MAthe pilot's performance of an aerobatic maneuver, with insufficient altitude for recovery, resulting in a collision with the waterJun 13, 1993 · N221DP · DestroyedNTSB LAX93LA248Accident · 1 fatalLimited investigationFinal reportHenderson Rutan Long EZ · San Pedro Bay, CAthe pilots failure to maintain an adequate terrain clearance altitude while maneuvering over the water at low altitude.Jun 13, 1993 · N874PM · DestroyedNTSB MIA93LA142Accident · No injuriesLimited investigationFinal reportSayer, Trevor A. Rans S-12 · New Smyrna Bch, FLFailure of the pilot to maintain adequate airspeed and inadvertent stall/spin. Contributing to the accident was total loss of engine power due to fuel starvation. This was due to improper placement of a component of the fuel system by the builder/pilot.Jun 12, 1993 · N162JT · Substantial damageNTSB FTW93FA187Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Texas City, TXThe pilot's failure to recover from the intentional maneuver for undetermined reasons.Jun 12, 1993 · N2977A · DestroyedNTSB LAX93LA249Accident · No injuriesLimited investigationFinal reportHughes 369D · Kahului, HIThe failure of the pilot to maintain adequate ground obstruction clearance while engaged in a cattle herding operation.Jun 11, 1993 · N1113L · Substantial damageNTSB CHI93LA203Accident · Minor injuriesLimited investigationFinal reportPiper PA-36 · Mc Laughlin, SDPilot in command's failure to maintain proper clearance.Jun 11, 1993 · N3890E · Substantial damageNTSB CHI93LA201Accident · 1 fatalLimited investigationFinal reportBell 47G-2A-1 · Phlox, WIWas the pilot in command's failure to maintain aircraft control. A factor to the accident was the inadequate cyclic control.Jun 11, 1993 · N73988 · Destroyed