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 FTW02LA157Accident · No injuriesLimited investigationFinal reportGolden Circle Air T-Bird · Newellton, LAThe pilot's failure to maintain control of the airplane resulting in an inadvertant spin.May 21, 2002 · UNREG · DestroyedNTSB ATL02LA102Accident · No injuriesLimited investigationFinal reportBell 47G · Marion, ALThe pilot's failure to maintain visual lookout while conducting an aerial application maneuver. A factor was the transmission line.May 21, 2002 · N72MU · Substantial damageNTSB FTW02LA158Accident · No injuriesLimited investigationFinal reportAir Tractor 402 · Hughes, ARthe pilot's failure to maintain directional control during the landing roll. Contributing factors were the malfunction of the tail wheel locking mechanism and the high vegetation along the sides of the airstrip.May 20, 2002 · N91660 · Substantial damageNTSB FTW02FA155Accident · 2 fatalField investigationFinal reportBeech BE-35 · Stephenville, TXThe pilot's failure to maintain control and adequate airspeed, resulting in the inadvertent stall/spin. A contributing factor was the low altitude.May 20, 2002 · N3157V · DestroyedNTSB NYC02FA098Accident · 3 fatalField investigationFinal reportBeech 23 · King George, VAThe pilot's improper in-flight decision to perform low passes; and his failure to maintain airspeed which resulted in a stall and collision with trees.May 19, 2002 · N2351Z · Substantial damageNTSB IAD02FA052Accident · 1 fatalField investigationFinal reportAyres S-2R · Swanton, MDThe pilot's failure to maintain visual separation from a set of known, yet unmarked power lines.May 19, 2002 · N88MQ · DestroyedNTSB FTW02LA152Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Hathaway, LAthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.May 17, 2002 · N48533 · Substantial damageNTSB DEN02FA043Accident · 1 fatalField investigationFinal reportCessna 170A · Casper, WYthe pilot's inadvertent flight into adverse weather conditions and his subsequent failure to maintain aircraft control. A factor contributing to this accident was the fog.May 17, 2002 · N1211D · DestroyedNTSB ANC02TA035Accident · No injuriesFinal reportRobinson R-44 · Cantwell, AKA failure of the pilot-in-command to maintain adequate main rotor rpm during an out-of-ground-effect hover.May 16, 2002 · N344AK · Substantial damageNTSB LAX02LA161Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Phoenix, AZthe CFI's failure to maintain an adequate airspeed resulted in a settling with power, and the CFI's failure to take remedial action. A factor in the accident was the high density altitude.May 13, 2002 · N577TA · Substantial damageNTSB ATL02LA097Accident · No injuriesLimited investigationFinal reportAerospatiale 350B · Gainesville, GAThe check airman’s failure to follow prescribed procedures that resulted in the lost of control and subsequent in-flight collision with the terrain. A factor was gusting wind conditions.May 13, 2002 · N696CH · Substantial damageNTSB FTW02LA143Accident · Serious injuriesLimited investigationFinal reportBell 206B · Rosenberg, TXThe pilot's failure to maintain terrain clearance.May 12, 2002 · N717NH · Substantial damageNTSB CHI02LA133Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Bancroft, WIThe loss of engine power due to contamination of the fuel system from an unknown source and the blocked fuel filter. The rough terrain was a factor.May 10, 2002 · N4224X · Substantial damageNTSB CHI02LA132Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Hordville, NEA loss of engine power due to a fractured rocker arm shaf. Contributing to the accident was the soft, furrowed field.May 10, 2002 · N48485 · Substantial damageNTSB LAX02LA155Accident · 1 fatalLimited investigationFinal reportMueller Skyraider 1 · Elko, NVthe pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in an inadvertent stall.May 9, 2002 · N571AM · DestroyedNTSB MIA02LA093Accident · 1 fatalLimited investigationFinal reportHispano Aviacion HA-200-Saeta · Perry, GAThe pilots failure to maintain airspeed while performing a turn at a low altitude, which resulted in a inadvertent stall, an uncontrolled descent, and an impact with trees and terrain.May 5, 2002 · N2000G · DestroyedNTSB MIA02LA090Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Myakka City, FLthe pilot's failure to maintain altitude while maneuvering during an aerial application, subsequently resulting in impact with the terrain.Apr 30, 2002 · N70213 · DestroyedNTSB FTW02LA133Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Owasso, OKThe loss of engine power as a result of the pilot's failure to remove the engine cowling plugs during the preflight inspection. A contributing factor was lack of suitable terrain for the forced landing.Apr 29, 2002 · N6303W · DestroyedNTSB SEA02LA076Accident · Serious injuriesLimited investigationFinal reportCook RS-15 · Richland, WAAirspeed was not maintained while maneuvering. An inadvertent stall, remedial action was not attained, and the student pilot's lack of total experience were factors.Apr 28, 2002 · UNREG · Substantial damageNTSB FTW02FA130Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Alpine, UTThe pilot's failure to maintain clearance with terrain and continued flight into known adverse weather conditions. Contributing factors were the fog and rain weather conditions.Apr 27, 2002 · N132CP · DestroyedNTSB ATL02LA092Accident · 1 fatalLimited investigationFinal reportHartman Buccaneer 2 · Estero Bay, FLThe pilot's failure to maintain aircraft control for undetermined reasons.Apr 27, 2002 · N8127W · DestroyedNTSB ATL02FA091Accident · 2 fatalField investigationFinal reportBeech BE-35 · Warsaw, NCThe pilot's physical impairment due to the use of marijuana. The pilot's diminished judgment to continue flight into known instrument flight conditions that resulted in an in-flight loss of control, failure of the right wing due to overstress separation, and…Apr 27, 2002 · N2152D · DestroyedNTSB DEN02GA039Accident · 1 fatalFinal reportPiper/Cub Crafters PA-18-150 · USAF Academy, COThe loss of control for undetermined reasons.Apr 26, 2002 · N990CC · DestroyedNTSB ATL02LA094Accident · No injuriesLimited investigationFinal reportBell 47G-5A · La Belle, FLThe pilot's failure to maintain clearance of a tree while maneuvering, which resulted in an in-flight collision with the tree and subsequent uncontrolled descent and collision with terrain.Apr 26, 2002 · N14838 · Substantial damageNTSB LAX02LA143Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164C · Olivehurst, CAFuel starvation due to the failure of an engine accessory component. A contributing factor was the rough terrain.Apr 25, 2002 · N6702K · Substantial damageNTSB NYC02FA089Accident · 2 fatalField investigationFinal reportCirrus SR-22 · Parish, NYThe pilots' failure to maintain airspeed, which resulted in an inadvertent stall/spin. The continued spin to the ground was a result of the pilots' failure to deploy the onboard parachute recovery system, for undetermined reasons.Apr 24, 2002 · N837CD · DestroyedNTSB NYC02LA086Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Islip, NYThe flight instructors failure to maintain aircraft control during a wind gust. A factor in the accident was a sudden gust of wind.Apr 20, 2002 · N8414H · Substantial damageNTSB MIA02LA086Accident · Serious injuriesLimited investigationFinal reportLett R/Campbell K Aircam · Troy, ALthe pilot-in-commands decision to fly at a low altitude and his improper visual lookout resulting in an in-flight collision static with wires.Apr 19, 2002 · N912S · Substantial damageNTSB MIA02FA084Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-35 · Carolina, PRThe failure of the pilot to maintain airspeed (Vs) while maneuvering following inadvertent encounter with clouds resulting in an inadvertent stall and uncontrolled descent and subsequent in-flight collision with trees, a wall, and a building.Apr 15, 2002 · N45BS · DestroyedNTSB ATL02TA083Accident · Serious injuriesFinal reportHughes OH-6A · Tampa, FLThe pilot's improper planning/decision to conduct an out of ground effect hover in a tailwind environment, which resulted in the loss of tail rotor effectiveness and the subsequent in-flight collision with water.Apr 14, 2002 · N56TP · Substantial damageNTSB ATL02LA086Accident · No injuriesLimited investigationFinal reportPiper J-3 · Carrollton, GAThe pilots failure to maintain flying speed that resulted in an inadvertent stall.Apr 14, 2002 · N31118 · Substantial damageNTSB NYC02FA082Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Gardiner, NYThe pilot-in-command's failure to maintain sufficient altitude while maneuvering in a mountainous area, which resulted in a collision with terrain. Factors in the accident were, mountainous terrain, clouds, and the pilot's decision to continue the flight in…Apr 12, 2002 · N288CA · Substantial damageNTSB FTW02FA118Accident · 2 fatalField investigationFinal reportCessna T182 · Amarillo, TXThe pilot's failure to maintain clearance with the power plant while maneuvering, and his intentional flight into adverse weather conditions. Contributing factors were low clouds, fog, the power plant, and low altitude flight.Apr 12, 2002 · N983HH · DestroyedNTSB SEA02TA067Accident · No injuriesFinal reportHughes 369D · Richland, WAFailure of the netting material securing a net weight while maneuvering. The net weight was a factor.Apr 11, 2002 · N8353F · Substantial damageNTSB LAX02FA134Accident · 2 fatalField investigationFinal reportBeech G35 · Willows, CAthe pilot's entry into an abrupt maneuver at an excessive airspeed beyond Va, which resulted in exceeding the aircraft's design stress limits.Apr 11, 2002 · N4487D · DestroyedNTSB FTW02LA116Accident · No injuriesLimited investigationFinal reportAir Tractor 502B · Palestine, ARthe pilot's failure to maintain clearance with the power line while maneuvering during an aerial application flight.Apr 10, 2002 · N9074H · Substantial damageNTSB CHI02LA105Accident · 2 fatalLimited investigationFinal reportBozeman Pietenpol Aircamper · Rocky Comfort, MOThe pilot not maintaining aircraft control while maneuvering, and his failure to maintain airspeed resulting in a stall. Low altitude flight was a contributing factor.Apr 9, 2002 · N96EB · DestroyedNTSB ATL02FA077Accident · 1 fatalField investigationFinal reportBeech E35 · Blowing Rock, NCThe pilot's continued VFR flight in to known IMC, which resulted in an in-flight collision with trees in mountainous terrain. A factor was low ceiling.Apr 8, 2002 · N3292C · DestroyedNTSB SEA02FA063Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Silesia, MTThe non-certificated pilot's inadvertent entry into a stall condition at low altitude.Apr 6, 2002 · N4389A · DestroyedNTSB LAX02FA131Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Three Rivers, CAthe pilot's attempt to continue visual flight in instrument meteorological conditions in mountainous terrain. Contributing factors were low ceiling and mountainous terrain.Apr 6, 2002 · N7839W · DestroyedNTSB DEN02LA036Accident · No injuriesLimited investigationFinal reportBell 206B-III · Leadville, COthe pilot's inadvertent flight into adverse weather, which resulted in a collision with terrain. A contributing factor was the downdraft.Apr 4, 2002 · N997GM · DestroyedNTSB FTW02LA110Accident · Serious injuriesLimited investigationFinal reportThornley Thornley 2000 · Granite Shoals, TXthe pilot's failure to maintain clearance with a power line while maneuvering. Contributing factors were the pilot's diverted attention and the power lines.Apr 2, 2002 · N248JT · Substantial damageNTSB FTW02LA107Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Ferriday, LAthe failure of the number three cylinder exhaust rocker arm, resulting in a total loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.Mar 28, 2002 · N8498K · Substantial damageNTSB ATL02LA067Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS315B · Hortense, GAFailure of the engine to main transmission drive shaft due to improper installation by company maintenance personnel. A factor were the trees.Mar 28, 2002 · N49525 · Substantial damageNTSB FTW02LA104Accident · No injuriesLimited investigationFinal reportHughes 269A-1 · Fort Collins, COthe flight instructor's failure to maintain control of the helicopter while hovering. Contributing factors were the tailwind and gusty wind conditions.Mar 27, 2002 · N8942F · Substantial damageNTSB LAX02FA116Accident · 1 fatalField investigationFinal reportSikorsky S-61A · Lakehead, CAA loss of engine power for undetermined reasons, and the flight crew's failure to maintain rotor rpm following a loss of engine power while maneuvering.Mar 26, 2002 · N318Y · DestroyedNTSB FTW02LA102Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Oakley, UTThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.Mar 26, 2002 · N30YB · Substantial damageNTSB ATL02LA066Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-400A · Hastings, FLFatigue cracking in the most outboard splice bolt hole in the lower spar cap of the right wing. .Mar 26, 2002 · N3159G · Substantial damageNTSB SEA02LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Fort Peck, MTThe pilot's inability to maintain aircraft control and foreign object damage to the aileron and wing. The restricted movement of the flight controls was a factor.Mar 25, 2002 · N22EV · Substantial damageNTSB MIA02LA070Accident · No injuriesLimited investigationFinal reportHughes 269C · Bessemer, ALThe failure of the flight instructor to adequately monitor the student's rotorcraft control, resulting in an abrupt cyclic input causing a tail rotor strike of the terrain while entering a hover, and the resulting rollover during an uncontrolled descent.Mar 24, 2002 · N7490F · Substantial damage