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 DEN04CA122Accident · No injuriesData collectionFinal reportEurocopter France EC-130 B4 · Englewood, COthe pilot's failure to perform a preflight inspection. Contributing to the accident was the transmission cowling that disconnected during the landing.Aug 9, 2004 · N910U · Substantial damageNTSB FTW04LA212Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28F · De Leon, TXThe pilot's failure to properly secure a fuel line, which resulted in a loss of engine power due to leakage and subsequent fuel starvation.Aug 7, 2004 · N78616 · Substantial damageNTSB CHI04FA214Accident · 2 fatalField investigationFinal reportEurocopter France EC130 B4 · Prairie du Sac, WIThe pilot's intentional low-level flight toward the lake and his failure to maintain clearance from the static wire on power transmission lines. Contributing factors were the separation of the Fenestron (tail rotor) assembly from the tail boom as a result of…Aug 7, 2004 · N450CM · DestroyedNTSB MIA04GA117Accident · 1 fatalFinal reportBell 47G-5 · Bunnell, FLThe pilot's continued flights and inadequate inspections after repeated tail rotor guard ground strikes due to improper flaring, which resulted in an in-flight failure of tail rotor drive shaft components, a loss of control, and the helicopter crash.Aug 4, 2004 · N232MC · Substantial damageNTSB DEN04FA115Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Mineral Wells, TXthe pilot's failure to maintain airspeed which resulted in a stall. A contributing factor was the low altitude.Aug 4, 2004 · N3352W · DestroyedNTSB SEA04FA150Accident · Minor injuriesField investigationFinal reportStinson 108 · Graham, WAThe total loss of power for undetermined reasons while maneuvering.Aug 1, 2004 · N97599 · Substantial damageNTSB ATL04LA164Accident · 1 fatalLimited investigationFinal reportCessna 172S · Waterloo, ALThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in a stall and subsequent uncontrolled descent and collision into water.Aug 1, 2004 · N970SP · Substantial damageNTSB NYC04LA181Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Farmingdale, NJThe pilot's failure to maintain adequate airspeed which resulted in a stall and collision with wires.Jul 31, 2004 · N53748 · Substantial damageNTSB FTW04LA201Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-400 · Clayton, LAThe pilot's failure to maintain clearance from the high tension power lines.Jul 31, 2004 · N3159W · DestroyedNTSB ANC04FA084Accident · 4 fatalField investigationFinal reportCessna 170B · Kenai, AKThe pilot's failure to maintain airspeed (Vs) while maneuvering, which resulted in an inadvertent stall and loss of control.Jul 31, 2004 · N2269D · Substantial damageNTSB ATL04CA163Accident · Minor injuriesData collectionFinal reportCessna 172 · Inman, SCThe pilot's failure to maintain clearance from the ground while maneuvering for a visual approach to land.Jul 29, 2004 · N3967F · Substantial damageNTSB CHI04FA198Accident · 2 fatalField investigationFinal reportMooney M20J · Fox Lake, ILThe flight crew's failure to maintain airspeed which led to an inadvertent stall/spin. An additional cause was the flight instructor's unsuccessful remedial action during the course of the accident sequence. The slow flight performed was a factor.Jul 28, 2004 · N91381 · DestroyedNTSB NYC04FA179Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Exton, PAThe pilot's failure to maintain aircraft control in instrument meteorological conditions, which resulted in the airplane impacting a residence. Factors in the accident were the pilot's lack of recent instrument experience.Jul 27, 2004 · N91075 · Substantial damageNTSB SEA04TA147Accident · No injuriesFinal reportWSK PZL Mielec M-18A · Burns, ORThe improper installation of the throttle linkage clevis to the throttle control arm by unknown maintenance personnel. Contributing factors were the nylon lock nut separating from its' bolt, which permitted the throttle cable to disconnect from the throttle…Jul 26, 2004 · N495WP · Substantial damageNTSB SEA04LA146Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Homedale, IDThe loss of engine power for an undetermined reason while maneuvering at low altitude, which resulted in a hard landing.Jul 26, 2004 · N62126 · Substantial damageNTSB NYC04LA178Accident · 1 fatalLimited investigationFinal reportGarrett Stephens Akro · Westport, NYThe pilot's loss of aircraft control while maneuvering, due to incapacitation, which resulted in a collision with terrain.Jul 26, 2004 · N45KY · Substantial damageNTSB LAX04LA281Accident · Serious injuriesLimited investigationFinal reportBell 206B · Little Valley, CAthe pilot's failure to maintain an adequate clearance from objects and terrain while maneuvering at low altitude. Factors in the accident were the high, rising terrain, and the high density altitude.Jul 26, 2004 · N549W · DestroyedNTSB SEA04FA143Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Cle Elum, WAThe pilot's failure to obtain and maintain a safe rate of climb after takeoff, due to his failure to perform pre-takeoff weight/balance and takeoff/climb performance calculations. Factors include a high density altitude environment, and trees off the…Jul 25, 2004 · N1912H · Substantial damageNTSB SEA04LA139Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Nyssa, ORThe failure (fracture) of the number four cylinder head during an aerial application run. Factors include the soft crop-covered terrain.Jul 23, 2004 · N7220 · Substantial damageNTSB NYC04LA174Accident · Serious injuriesLimited investigationFinal reportBombardier CL-600 · Snow Hill, VAThe pilot's excessive maneuvering in response to a TCAS alert, which resulted in a serious injury to the flight attendant.Jul 21, 2004 · N995CA · No damageNTSB FTW04CA192Accident · Minor injuriesData collectionFinal reportRotorway Exec · Conroe, TXThe loss of engine power due to the tripped fuel pump circuit breaker which resulted in the failure of the electric fuel pump.Jul 20, 2004 · N342RD · DestroyedNTSB ATL04CA160Accident · No injuriesData collectionFinal reportPiper PA 25 · Foley, ALThe pilot's failure to maintain airspeed during climbout which resulted in a stall while maneuvering to pick up a banner.Jul 20, 2004 · N7222Z · Substantial damageNTSB LAX04LA273Accident · No injuriesLimited investigationFinal reportAgusta A119 · Big Bear City, CAthe pilot-passenger's failure to maintain an adequate airspeed above translational lift and to maintain adequate main rotor rpm while performing a maneuvering turn under high density altitude conditions and over high mountainous terrain, which resulted in an…Jul 19, 2004 · N928KR · Substantial damageNTSB LAX04FA271Accident · 3 fatalField investigationFinal reportBeech 58 · Bishop, CAthe pilot's continued VFR flight into marginal weather conditions with lowering ceilings in a box canyon in mountainous terrain, and his subsequent inability to maintain an adequate airspeed while maneuvering to reverse direction, which led to an accelerated…Jul 17, 2004 · N807Q · DestroyedNTSB ANC04FA080Accident · 4 fatalField investigationFinal reportCessna 170B · Willow, AKThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall while maneuvering, and a collision with trees and terrain during an uncontrolled descent.Jul 17, 2004 · N4588C · DestroyedNTSB LAX04CA268Accident · No injuriesData collectionFinal reportMcDonnell Douglas 369FF · Lihue, HIThe pilot misjudging the clearance between the tree and the main rotor blades. Contributing factors to the accident were the high workload of the pilot and his lack of experience with bambi bucket operations.Jul 16, 2004 · N530RL · Substantial damageNTSB FTW04CA185Accident · Serious injuriesData collectionFinal reportGrumman G-164 · Havana, ARThe pilot's failure to maintain clearance with the power lines while maneuvering during an aerial application flight.Jul 16, 2004 · N519Y · Substantial damageNTSB SEA04FA133Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Ontario, ORThe pilot's failure to maintain airspeed resulting in an aerodynamic stall while maneuvering for an approach to land.Jul 15, 2004 · N4439P · Substantial damageNTSB NYC04CA166Accident · No injuriesData collectionFinal reportRobinson R-44 II · Beverly, MAThe pilot's inadequate visual lookout, which resulted in a collision with transmission wires.Jul 11, 2004 · N277MC · Substantial damageNTSB IAD04FA030Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Ticonderoga, NYReason for occurrence undetermined.Jul 10, 2004 · N45032 · DestroyedNTSB FTW04LA179Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Winnsboro, LAThe pilot's mismanagement of fuel resulting in fuel starvation. A contributing factor was the ditch.Jul 10, 2004 · N10061 · Substantial damageNTSB SEA04FA127Accident · Serious injuriesField investigationFinal reportExtra Flugzeugrau EA 300/L · Boise, IDThe failure of the pilot to maintain clearance with terrain during descent while conducting an aerobatic maneuver. Low altitude flight was a factor.Jul 9, 2004 · N609JW · DestroyedNTSB NYC04LA162Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Norfolk, VAThe pilot's failure to complete an autorotation due to the restrictive movement of the collective control.Jul 9, 2004 · N152SP · Substantial damageNTSB SEA04LA125Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Wendell, IDA cracked cylinder head which resulted in a loss of engine power while maneuvering. High vegetation was a factor.Jul 7, 2004 · N7502Y · Substantial damageNTSB FTW04LA176Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Jonesville, LAThe pilot's failure to maintain clearance with the power lines.Jul 6, 2004 · N8486V · Substantial damageNTSB ATL04CA146Accident · Minor injuriesData collectionFinal reportAir Tractor AT-402A · Hillsboro, ALThe pilot's inadequate visual lookout and failure to maintain adequate obstacle clearance, which resulted in collision with transmission wires.Jul 3, 2004 · N9089L · Substantial damageNTSB FTW04FA172Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Hot Springs, ARThe pilot's failure to fly a stabilized, published instrument approach procedure, which resulted in a collision with mountainous terrain. Factors were the clouds and the air traffic controllers' failure to provide known information that may have assisted the…Jul 2, 2004 · N4123R · Substantial damageNTSB NYC04LA154Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Lawrenceburg, KYThe pilot's decision to perform a negative g maneuver, which resulted in a loss of engine power due to fuel starvation.Jun 30, 2004 · N2364A · Substantial damageNTSB SEA04LA119Accident · 2 fatalLimited investigationFinal reportApco Powered Parachute · Wolf Point, MTThe pilot's loss of control as a result of trying a low altitude quick turning maneuver. A factor was the pilot's lack of experience in the aircraft.Jun 29, 2004 · UNREG · DestroyedNTSB FTW04FA167Accident · 2 fatalField investigationFinal reportBell 206B · Cushing, OKthe pilot's inadequate in-flight planning/decision and his failure to maintain obstacle clearance. Contributing factors were low altitude flight, sun glare, and the static wires.Jun 27, 2004 · N27TV · DestroyedNTSB SEA04LA114Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Medford, ORThe pilot's failure to maintain clearance from a tree while maneuvering. Trees were a factor.Jun 23, 2004 · N73909 · Substantial damageNTSB CHI04CA162Accident · No injuriesData collectionFinal reportAir Tractor AT-401 · Britton, SDThe loss of engine power due to a stuck exhaust valve and the unsuitable terrain encountered during the forced landing. A factor to the accident was the soft terrain condition.Jun 23, 2004 · N1013N · Substantial damageNTSB ATL04TA137Accident · No injuriesFinal reportBell 206B · Graysville, ALThe pilot's inadequate compensation for a tailwind and his failure to maintain directional control resulting in a loss of tail rotor effectiveness. A factor was the pilot's improper in-flight decision to hover with a tailwind.Jun 22, 2004 · N3902W · DestroyedNTSB SEA04LA113Accident · Serious injuriesLimited investigationFinal reportPiper J-3 · Glenoma, WAThe pilot's failure to maintain clearance from the trees while maneuvering at a very low level in hilly terrain. Factors include hilly terrain, and thickly forested slopes in the area where the pilot was maneuvering.Jun 21, 2004 · N27135 · Substantial damageNTSB CHI04LA146Accident · 1 fatalLimited investigationFinal reportCessna A188B · Prosser, NEThe pilot's abrupt maneuver to avoid obstructions, and his failure to maintain adequate airspeed resulting in a stall. The low altitude flight operation, and the transmission tower (antenna) were contributing factors.Jun 21, 2004 · N731MP · Substantial damageNTSB CHI04LA158Accident · 2 fatalLimited investigationFinal reportMonocoupe 90AL-115 · St. Paul, MOThe pilot's failure to maintain altitude/clearance from the terrain while maneuvering.Jun 19, 2004 · N1161 · DestroyedNTSB LAX04GA243Accident · 1 fatalFinal reportWSK PZL Mielec M-18A · St. George, UTThe pilot's failure to maintain an adequate airspeed margin, resulting in a stall and loss of control.Jun 17, 2004 · N8214J · DestroyedNTSB FTW04LA162Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Rush Springs, OKThe pilot's failure to maintain clearance with a utility pole and power lines while maneuvering during an aerial application.Jun 15, 2004 · N21650 · Substantial damageNTSB MIA04LA096Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Williston, FLThe pilot's failure to maintain airspeed (Vso) while maneuvering, which resulted in a stall/mush, an uncontrolled descent, and impact with terrain.Jun 13, 2004 · N85970 · Substantial damageNTSB LAX04LA239Accident · 1 fatalLimited investigationFinal reportChampion 7AC · La Porte, CAthe student pilot's failure to maintain clearance with trees while flying along a mountainous ravine.Jun 12, 2004 · N81471 · Substantial damage