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 ATL04FA130Accident · 2 fatalField investigationFinal reportCessna 172F · Madisonville, TNThe pilot's failure to maintain airspeed while maneuvering on a touch and go landing resulting in a stall and collision with the ground.Jun 12, 2004 · N8777U · DestroyedNTSB FTW04LA158Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Needville, TXThe loss of engine power and subsequent in-flight fire for undetermined reasons.Jun 10, 2004 · N4968X · Substantial damageNTSB CHI04CA151Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164B · Hope, NDThe pilot's failure to maintain clearance from the tree branches during the aerial-application flight. A factor to the accident was the trees.Jun 10, 2004 · N48517 · Substantial damageNTSB SEA04LA102Accident · No injuriesLimited investigationFinal reportBell 206B · Prosser, WAThe pilot's failure to maintain clearance with the power lines while maneuvering.Jun 9, 2004 · N213SD · Substantial damageNTSB ATL04LA128Accident · 1 fatalLimited investigationFinal reportGrover J3 Kitten · Mohawk, TNThe pilot's decision to perform aerobatic flight in an airplane with known deficiencies that resulted in the in-flight separation of the airframe and the uncontrolled collision with the ground.Jun 9, 2004 · UNREG · Substantial damageNTSB FTW04LA156Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Joiner, ARThe pilot's failure to maintain clearance and altitude from terrain while maneuvering during an aerial application.Jun 8, 2004 · N9151C · DestroyedNTSB FTW04LA153Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402 · Tucker, ARThe pilot's failure to maintain control while manuevering during aerial application which resulted in impact with terrain.Jun 7, 2004 · N182PB · Substantial damageNTSB DEN04LA086Accident · Minor injuriesLimited investigationFinal reportEagle DW-1 · Circleville, UTthe encounter with severe turbulence during aerial application and the pilot's inability to maintain aircraft control resulting in the in-flight collision with terrain. A contributing factor was the low altitude.Jun 7, 2004 · N8805D · DestroyedNTSB ATL04CA127Accident · Minor injuriesData collectionFinal reportCessna 150 · Decatur, ALThe pilot's failure to maintain obstacle clearance, which resulted in collision with utility wires.Jun 6, 2004 · N10424 · Substantial damageNTSB SEA04LA099Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · Midvale, IDThe failure of the pilot to maintain clearance from the high tension powerline. A factor was the powerline.Jun 5, 2004 · N8440K · DestroyedNTSB LAX04CA233Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Brentwood, CAthe student's improper use of the cyclic control, the flight instructor's inadequate supervision, and his delayed remedial action. A factor in the accident was the CFI's diverted attention.Jun 5, 2004 · N9421K · Substantial damageNTSB FTW04LA157Accident · No injuriesLimited investigationFinal reportSnow S2C · La Feria, TXThe pilot's failure to maintain clearance from the obstacle while maneuvering to perform an aerial application. A contributing factor was the high vegetation.Jun 5, 2004 · N9492R · Substantial damageNTSB FTW04LA150Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Cotton Plant, ARThe loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.Jun 4, 2004 · N3166U · Substantial damageNTSB SEA04LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Easton, WAThe pilot's failure to maintain terrain clearance while maneuvering in mountainous terrain. Mountain terrain was a factor.Jun 1, 2004 · N6245J · Substantial damageNTSB SEA04LA093Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Rexburg, IDThe pilot's failure to maintain clearance from an object while maneuvering during an aerial application flight. Contributing factors were the pilot's diverted attention and the irrigation pivot.Jun 1, 2004 · N657Y · Substantial damageNTSB LAX04FA223Accident · 2 fatalField investigationFinal reportBoeing B75N1 · Mesa, AZthe pilot's failure to maintain an adequate airspeed while performing aerobatics that resulted in an inadvertent stall and spin.May 31, 2004 · N48579 · DestroyedNTSB DEN04LA083Accident · No injuriesLimited investigationFinal reportAyres S-2R · Beaver, UTthe in-flight failure of the engine's P3 tube which resulted in the loss of engine power and the subsequent impact with terrain during a forced landing. Contributing factors include the lack of suitable terrain for a forced landing and the fence.May 31, 2004 · N5686X · Substantial damageNTSB CHI04LA128Accident · 1 fatalLimited investigationFinal reportNorth American P-51C · Hager City, WIThe improper installation of the camshaft drive gear assembly which resulted in the retaining nut backing off allowing the drive gear to move up the shaft. A factor associated with the accident was the low altitude at which the power loss occurred and the…May 29, 2004 · N61429 · Substantial damageNTSB DEN04CA080Accident · No injuriesData collectionFinal reportCessna T188C · Lamar, COA partial loss of engine power for undetermined reasons and the pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing to the accident was the low altitude.May 25, 2004 · N2030J · Substantial damageNTSB FTW04LA138Accident · No injuriesLimited investigationFinal reportCessna 172 · Decatur, TXThe student pilot's failure to follow the flight instructor's instructions and relinquish the controls, and the flight instructor's delay in initiating a go-around.May 24, 2004 · N5302E · Substantial damageNTSB FTW04LA148Accident · No injuriesLimited investigationFinal reportBruce Moore Skybolt · Altus, OKThe partial in-flight separation of the wing fabric and rib structure due to an inadequate material installed by the airplane builder.May 23, 2004 · N25BM · Substantial damageNTSB FTW04LA133Accident · No injuriesLimited investigationFinal reportBell 412 · San Antonio, TXThe pilot's failure to maintain clearance with the parked helicopter while performing a hovering turn.May 23, 2004 · N555BA · Substantial damageNTSB IAD04LA022Accident · 1 fatalLimited investigationFinal reportMasak Scimitar · Alexandria, PAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A factor was the turbulent wind conditions.May 22, 2004 · N12PX · DestroyedNTSB DEN04CA073Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Flagler, COthe pilot's improper in-flight planning/decision which led to fuel exhaustion and subsequent loss of engine power. Factors contributing to the accident were the low altitude, low airspeed, and the inoperative fuel quantity gauge.May 22, 2004 · N8586L · Substantial damageNTSB LAX04TA218Accident · No injuriesFinal reportEurocopter France AS350 B3 · Livermore, CAThe pilot's failure to maintain clearance from obstructions while landing.May 21, 2004 · N216HP · Substantial damageNTSB FTW04LA136Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Brookland, ARThe pilot's failure to maintain clearance with the power lines while maneuvering.May 21, 2004 · N5013C · Substantial damageNTSB FTW04LA132Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Donna, TXThe pilot's failure to maintain clearance from the high tension power lines.May 21, 2004 · N3168H · Substantial damageNTSB LAX04LA216Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Palmdale, CAThe momentary loss of engine power for undetermined reasons.May 20, 2004 · N2019F · Substantial damageNTSB SEA04LA089Accident · Serious injuriesLimited investigationFinal reportAirframes Unlimited Powered Parachute · Richland, WAThe failure of the non-certificated pilot to maintain clearance from a pole while maneuvering. Factors contributing to the accident included the loss of directional control and the pole.May 14, 2004 · UNREG · Substantial damageNTSB LAX04FA207Accident · 3 fatalField investigationFinal reportPiper PA-44-180 · Wittmann, AZThe flight instructor's failure to maintain sufficient airspeed to avoid a stall/spin while maneuvering the airplane with a dual student.May 13, 2004 · N4144C · DestroyedNTSB SEA04LA082Accident · 1 fatalLimited investigationFinal reportKaman K-1200 · West Fork, ORThe pilot's failure to maintain adequate clearance with trees during logging operations. Contributing factors were the trees, mountainous (steeply sloped) terrain, and the pilot's decision to conduct operations in this terrain with a 200 foot long line.May 12, 2004 · N162KA · Substantial damageNTSB SEA04LA078Accident · No injuriesLimited investigationFinal reportRobinson R-22 Mariner · Chehalis, WAA loss of engine power for undetermined reasons.May 6, 2004 · N6291T · Substantial damageNTSB NYC04FA117Accident · Serious injuriesField investigationFinal reportEurocopter AS-350BA · Brooklyn, NYThe pilot's failure to maintain control of the helicopter after a loss of hydraulic system pressure due to a failure of the hydraulic pump belt. Factors in this accident were the pilot's misidentification of a hydraulic failure, the pilot's subsequent failure…May 4, 2004 · N4NY · DestroyedNTSB LAX04TA202Accident · No injuriesFinal reportBell OH-58A+ · Bakersfield, CAloss of engine power due to the separation of the diaphragm portion of the repaired second-stage turbine nozzle from the rim portion due to the use of an inadequate cleaning method to clean the joint prior to the braze repair during overhaul by the…May 4, 2004 · N397E · Substantial damageNTSB SEA04LA077Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Laurel, MTThe pilot's failure to maintain adequate clearance/altitude while maneuvering resulting in the inadvertent in-flight collision with water/terrain.May 1, 2004 · N5483H · Substantial damageNTSB ANC04FA049Accident · 1 fatalField investigationFinal reportBell 206L-3 · Deadhorse, AKThe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his spatial disorientation and loss of control during a subsequent landing. Factors associated with the accident are flat light and whiteout conditions, fog, and…May 1, 2004 · N130AL · Substantial damageNTSB ATL04LA104Accident · 1 fatalLimited investigationFinal reportSukhoi SU-31 · Fort Lauderdale, FLThe pilot's failure to recover from an intentional spin during an attempted aerobatic maneuver.Apr 30, 2004 · N31SU · Substantial damageNTSB ATL04LA103Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Sale Creek, TNThe pilot's failure to maintain airspeed, and the pilot's alcohol impairment that resulted in an inadvertent stall and collision with the ground.Apr 29, 2004 · N2277M · Substantial damageNTSB FTW04LA121Accident · No injuriesLimited investigationFinal reportCessna 150-G · Livingston, TXA loss of engine power due to the blockage of the fuel system vents, resulting in fuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.Apr 28, 2004 · N493RA · Substantial damageNTSB SEA04LA074Accident · 1 fatalLimited investigationFinal reportSchramm Helicycle · Montour, IDIn flight collision with terrain for undetermined reasons.Apr 27, 2004 · N3275Q · DestroyedNTSB CHI04CA110Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Shakopee, MNThe dual student's failure to maintain control of the helicopter during hovering flight and the flight instructor's delayed remedial action in order to prevent a loss of control. Contributing factors were the flight instructor's lack of dual instruction…Apr 24, 2004 · N819TT · Substantial damageNTSB ATL04FA099Accident · 3 fatalField investigationFinal reportCessna 172N · Moselle, MSThe pilot's failure to maintain clearance and his inadequate visual look-out while maneuvering resulting in an in-flight collision with a radio tower.Apr 24, 2004 · N75812 · Substantial damageNTSB LAX04CA193Accident · Minor injuriesData collectionFinal reportRobinson R22B · Long Beach, CAthe pilot's inadequate compensation for gusty wind conditions and failure to maintain control of the helicopter while hovering.Apr 22, 2004 · N8492A · Substantial damageNTSB FTW04LA111Accident · Minor injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Holliday, TXThe failure of the upper tail rotor shaft due to excessive misalignment after two hard landings. Also causal was the manufacturer's failure to provide specific maintenance procedures for checking the alignment of the upper tail rotor shaft.Apr 21, 2004 · N9030Z · Substantial damageNTSB ATL04CA095Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Carthage, TNThe pilot's failure to maintain visual lookout and clearance while maneuvering resulting in an in-flight collision with wires and subsequent collision with water.Apr 15, 2004 · N2908E · Substantial damageNTSB FTW04LA108Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402B · Goliad, TXThe pilot's failure to maintain clearance with power lines while maneuvering during an aerial application flight.Apr 13, 2004 · N852JH · Substantial damageNTSB SEA04CA068Accident · No injuriesData collectionFinal reportYakovlev Yak 54 · Friday Harbor, WAThe pilot's failure to properly align with the runway. Factors include rough/uneven terrain, inadequate preflight planning and diminished forward visibility.Apr 10, 2004 · N14026 · Substantial damageNTSB DEN04CA058Accident · No injuriesData collectionFinal reportEurocopter France EC 130 B4 · Watkins, COthe dual student pilot's failure to maintain control of the helicopter. Factors contributing to the accident were inadequate supervision by the instructor pilot, the high wind, the gusts, and the crosswinds.Apr 8, 2004 · N151AC · Substantial damageNTSB SEA04LA065Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Nezperce, IDThe circumferential fracture of the number seven cylinder head while en route to an aerial fertilizer application, leading to a forced landing on soft terrain, resulting in the collapse of the right main gear leg. Factors include soft terrain at the location…Apr 5, 2004 · N48564 · Substantial damageNTSB LAX04LA176Accident · Serious injuriesLimited investigationFinal reportBell 47G-4A · Bakersfield, CAa loss of tail rotor drive due to a disconnection of the drive shaft's splined coupling at the tail rotor gear box. The splined coupling to tail rotor gear box disconnection occurred as a result of tail boom flexing due to the combined effects of an…Apr 3, 2004 · N7NB · Substantial damage