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 SEA02LA172Accident · No injuriesLimited investigationFinal reportHughes 500 · Carnation, WAThe pilot's delayed power application during a practice power recovery autorotation.Sep 10, 2002 · N9263F · Substantial damageNTSB CHI02CA296Accident · No injuriesData collectionFinal reportRobinson R-22 · Maryland Height, MODynamic rollover due to the flight instructor's improper control inputs and the flight instructor's unsuccessful remedial actions. A contributing factor is the passenger's inadvertent movement of the cyclic control.Sep 10, 2002 · N8372B · Substantial damageNTSB CHI02LA282Accident · No injuriesLimited investigationFinal reportCessna A188B · Dexter, MOThe fatigue fracture of the connecting rod, the recommended engine overhaul not performed by the company, and the low altitude flight.Sep 9, 2002 · N4919Q · Substantial damageNTSB DEN02LA103Accident · 1 fatalLimited investigationFinal reportAdler SA-1 · Mead, COthe pilot's failure to maintain main rotor rpm, resulting in blade flapping, subsequent blade contact with the airframe, and loss of control.Sep 8, 2002 · N551SA · DestroyedNTSB NYC02LA186Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Jamestown, KYThe pilot's failure to maintain the proper descent rate, which resulted in low rotor rpm and a collision with water.Sep 7, 2002 · N707RG · Substantial damageNTSB LAX02LA277Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Ventus-B · Peoria, AZThe pilot's abrupt maneuver, which resulted in an inadvertent stall.Sep 7, 2002 · N114RP · DestroyedNTSB LAX02FA276Accident · 3 fatalField investigationFinal reportBell 222U · Nipton, CAThe main rotor blade separation while maneuvering for unknown reasons. A factor was the dark night condition.Sep 7, 2002 · N417MA · DestroyedNTSB FTW02LA252Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Bella Vista, ARThe binding throttle control cable, which resulted in a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.Sep 7, 2002 · N686FL · Substantial damageNTSB DEN02GA102Accident · 1 fatalFinal reportCessna A185F · Howard, COthe pilot's failure to maintain clearance of the terrain. Contributing factors were the clear air turbulent weather condition, and the high density altitude condition.Sep 4, 2002 · N24GS · DestroyedNTSB CHI02FA269Accident · 2 fatalField investigationFinal reportCessna TR182 · Tappen, NDThe pilot's inadequate visual lookout and his failure to maintain clearance of the transmission wires. Also causal was inadequate preflight planning. Factors associated with the accident were the low altitude and airspeed when the abrupt maneuver was made and…Sep 4, 2002 · N756WF · DestroyedNTSB LAX02LA269Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeside, CAThe failure of the engine to respond for undetermined reasons. Also causal was the student's decision to continue the simulated emergency maneuver to an altitude that was insufficient to allow for contingency options. The unsuitable nature of the terrain…Aug 31, 2002 · N739ZV · Substantial damageNTSB FTW02LA245Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Hearne, TXThe pilot's failure to maintain clearance with a pump rig while maneuvering during an aerial application flight. A factor was the object.Aug 30, 2002 · N9193Y · Substantial damageNTSB DEN02LA101Accident · Serious injuriesLimited investigationFinal reportBell 206L-III · Canon City, COthe pilot's failure to maintain clearance of a static wire, and the subsequent loss of aircraft control due to the main rotor pitch change tubes being severed.Aug 30, 2002 · N43GA · DestroyedNTSB FTW02LA242Accident · No injuriesLimited investigationFinal reportWhittman Tailwind W-8 · Albuquerque, NMThe structural failure and separation of a propeller blade for undetermined reasons. A contributing factor was the lack of suitable terrain available to the pilot to execute a forced landing.Aug 27, 2002 · N3992A · Substantial damageNTSB LAX02LA262Accident · Serious injuriesLimited investigationFinal reportBell 47G-2 · Oasis, CAthe pilot's failure to maintain an adequate visual lookout and clearance with power lines while maneuvering during an aerial application flight.Aug 25, 2002 · N8478H · Substantial damageNTSB CHI02LA259Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-402A · Cherokee, IAThe pilot failed to maintain clearance with the power lines resulting in the rudder separation and the subsequent loss of aircraft control. A factor associated with the accident was the power line that was contacted.Aug 25, 2002 · N9032K · Substantial damageNTSB SEA02TA164Accident · No injuriesFinal reportBell 206L-1 · Wisdom, MTThe pilot's failure to maintain clearance from an object while maneuvering. A tree(s) was a factor.Aug 24, 2002 · N832AH · Substantial damageNTSB ATL02LA161Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Peachtree City, GAThe certified flight instructors failure to feather the propeller in accordance with operating procedures that resulted in loss of altitude and the in-flight collision with terrain.Aug 24, 2002 · N55210 · Substantial damageNTSB ATL02FA160Accident · 1 fatalField investigationFinal reportBeech BE-55 · Jacksboro, TNPilot incapacitation due to a heart attack resulting in a loss of control and the subsequent in-flight collision with a lake.Aug 20, 2002 · N132WM · DestroyedNTSB LAX02FA255Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Echo Summit, CAThe pilot's decision to continue the flight into the rising mountainous terrain, and subsequent failure to maintain clearance with the trees. Contributing factors were the rising mountainous terrain, and the high density altitude,Aug 19, 2002 · N7794C · DestroyedNTSB MIA02LA153Accident · 2 fatalLimited investigationFinal reportReviere Vans RV6A · Tampa, FLthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, while maneuvering, and subsequent impact with a concrete wall. A factor in this accident was the impairment of the pilot in command due to the use of prescription…Aug 18, 2002 · N747ES · DestroyedNTSB LAX02LA258Accident · No injuriesLimited investigationFinal reportCessna 185A · Fillmore, CAthe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in the in-flight collision with terrain during a climb.Aug 16, 2002 · N4145Y · Substantial damageNTSB DEN02GA097Accident · 1 fatalFinal reportArctic S-1B2 · Meeteetse, WYthe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin. A contributing factor was the intentional low pass/slow flight maneuver.Aug 16, 2002 · N71AT · DestroyedNTSB FTW02LA237Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26B · Hobbs, NMthe pilot's inadvertent flight into adverse weather conditions which resulted in the loss of thermal lift. A contributing factor was the lack of suitable terrain for the forced landing.Aug 15, 2002 · N696U · Substantial damageNTSB FTW02FA233Accident · 1 fatalField investigationFinal reportCessna 152 · Ithaca, NEThe pilot's intentional flight of the airplane into terrain in an act of suicide.Aug 12, 2002 · N49998 · DestroyedNTSB CHI02LA244Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Hillman, MIThe pilot's failure to maintain terrain clearance.Aug 12, 2002 · N6658H · DestroyedNTSB ATL02FA156Accident · 3 fatalField investigationFinal reportCessna 182R · Lake City, TNThe pilot's failure to follow procedures pertaining to mountain flying, and the pilot's failure to maintain airspeed that resulted in an inadvertent stall and subsequent in-flight collision with trees and terrain. A factor was the certified flight instructor…Aug 10, 2002 · N9307X · DestroyedNTSB DEN02FA089Accident · 4 fatalField investigationFinal reportMooney M20A · Marysvale, UTthe pilot's poor in-flight decision to fly so close to the ridge (looking for animals). Contributing factors were the mountainous terrain condition, the downdraft weather conditions in high mountains, and the high density altitude weather condition.Aug 9, 2002 · N1088B · DestroyedNTSB CHI02LA238Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Sturgis, MIThe failure of the turbine section of the engine, and the unsuitable terrain encountered for the forced landing. The low altitude was a factor.Aug 7, 2002 · N8444K · Substantial damageNTSB FTW02LA230Accident · 2 fatalLimited investigationFinal reportYakovlev YAK 52 · Aledo, TXThe pilot's failure to maintain control of the airplane while performing aerobatics. A contributing factor was the performance of aerobatic maneuvers with low altitude.Aug 6, 2002 · N5C · DestroyedNTSB ANC02LA092Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Tok, AKThe pilot's failure to maintain clearance from terrain and trees during a low pass to examine a potential landing site.Aug 6, 2002 · N4122E · Substantial damageNTSB SEA02FA146Accident · 3 fatalField investigationFinal reportBeech BE-35 · Idaho Falls, IDThe flying pilot's failure to maintain adequate airspeed resulting in a stall/spin. An additional cause was the flight instructor's inadequate supervision of the flight.Aug 5, 2002 · N82Z · DestroyedNTSB SEA02FA145Accident · 2 fatalField investigationFinal reportCessna 182A · Emmett, IDThe pilot's failure to maintain clearance from power transmission lines while maneuvering.Aug 5, 2002 · N4085D · Substantial damageNTSB NYC02LA154Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe student pilot's failure to maintain airspeed and the flight instructor's delayed remedial action, which resulted in an inadvertent stall during a simulated forced landing. A factor was the rising terrain.Aug 5, 2002 · N89044 · Substantial damageNTSB LAX02LA246Accident · No injuriesLimited investigationFinal reportAero Commander S2R-T34 · Los Banos, CAThe pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in an inadvertent stall.Aug 5, 2002 · N8822Q · Substantial damageNTSB IAD02TA081Accident · 1 fatalFinal reportCrawford Widebody Long EZ · Martha's Vineyard, MAPilot incapacitation from a massive subarachnoid hemorrhage (stroke.)Aug 3, 2002 · N3R · Substantial damageNTSB MIA02LA143Accident · No injuriesLimited investigationFinal reportCessna A188B · Indianola, MSThe failure of the pilot to maintain clearance with a transmission wire resulting in the collision and substantial damage.Aug 2, 2002 · N4723Q · Substantial damageNTSB FTW02LA223Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Altus, OKThe loss of engine power as a result of the fracture of a compressor turbine blade due to fatigue. A contributing factor was the lack of suitable terrain for the forced landing.Aug 2, 2002 · N57597 · Substantial damageNTSB FTW02FA222Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Gypsum, COThe pilot's failure to perform remedial action and maintain clearance with the rising mountainous terrain. Contributing factors were the pilot's poor planning/decision, the rising terrain, and the high density altitude.Aug 1, 2002 · N6444J · DestroyedNTSB DEN02GA085Accident · 1 fatalFinal reportAerospatiale SA315B · Estes Park, COthe pilot's abrupt collective input during water application to a forest fire. Contributing factors were encountering a vortex ring state, the inadvertent settling with power, the low altitude, and the mountainous terrain.Jul 31, 2002 · N3978Y · DestroyedNTSB CHI02LA227Accident · No injuriesLimited investigationFinal reportJackovich Pitts S1D · Donahue, IAA loss of engine power for undetermined reasons.Jul 31, 2002 · N29FJ · Substantial damageNTSB CHI02LA223Accident · No injuriesLimited investigationFinal reportCessna A188B · Nickerson, KSFuel starvation due to the fuel contamination, the blocked fuel strainer, and the refueling truck's contaminated fuel. A factor was the berm.Jul 31, 2002 · N9639G · Substantial damageNTSB ATL02LA146Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M-18A · Indianola, MSThe pilot's failure to maintain airspeed which resulted in a stall and the subsequent uncontrolled collision with the ground while maneuvering for an aerial application run.Jul 31, 2002 · N6236M · Substantial damageNTSB LAX02LA243Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Fresno, CAThe failure of the flight instructor to ensure maintenance of an adequate terrain clearance altitude while performing low level maneuvers.Jul 30, 2002 · N4074T · Substantial damageNTSB FTW02LA221Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · New Roads, LAThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin of the airplane.Jul 29, 2002 · N48523 · Substantial damageNTSB ATL02LA145Accident · No injuriesLimited investigationFinal reportCessna 150H · Senoia, GAThe certificated flight instructor's failure to follow published procedures for the application of carburetor heat, which resulted in a loss of engine power due to carburetor ice formation, and subsequent collision with trees during the forced landing. A…Jul 28, 2002 · N6486S · Substantial damageNTSB LAX02LA240Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · San Manuel, AZthe pilot's failure to maintain adequate airspeed while maneuvering in a box canyon, which resulted in a stall/mush. A factor in the accident was downdraft conditions that led to an uncontrolled decent.Jul 27, 2002 · N293JK · Substantial damageNTSB DEN02FA080Accident · 2 fatalField investigationFinal reportCessna 177B · Crowheart, WYthe pilot's failure to maintain clearance of the high mountain terrain. Contributing factors were the high mountain terrain, and the high density altitude weather condition.Jul 27, 2002 · N34859 · DestroyedNTSB DEN02LA083Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Georgetown, COthe pilot's inadequate preflight planning for a flight through high mountainous terrain, and the pilot committing himself to a mountainous flight path where terrain clearance was not possible. Contributing factors were the high density altitude weather…Jul 26, 2002 · CGKRA · Substantial damageNTSB CHI02CA224Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301 · Malta, ILThe probable cause of this accident was fuel exhaustion, due to a failure to properly compute initial fuel quantity and/or fuel consumption.Jul 26, 2002 · N2326S · Substantial damage