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 CHI01LA119Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Du Quoin, ILloss of engine power for undetermined reasons, the pilot operating the helicopter outside of the height-velocity curve, and the pilot's failure to maintain control of the helicopter during the emergency landing. Factors relating to the accident were the…Apr 18, 2001 · N713HT · DestroyedNTSB ANC01TA047Accident · Minor injuriesFinal reportCessna 207 · Mtn. Village, AKThe pilot's continued VFR flight into instrument meteorological conditions while maneuvering. Factors in the accident were low ceilings, snow showers, whiteout conditions, and snow-covered terrain.Apr 17, 2001 · N6476H · Substantial damageNTSB ANC01LA056Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Emmonak, AKThe pilot's inadvertent stall while maneuvering. A factor associated with the accident was soft, snow-covered terrain.Apr 14, 2001 · N4375B · Substantial damageNTSB MIA01TA121Accident · Minor injuriesFinal reportBell OH-58C · Panama City, FLThe poor in-flight planning by the pilot for failure to maintain adequate airspeed while maneuvering to begin spray operations resulting in the loss of tail rotor effectiveness, subsequent in flight loss of control, and in flight collision with terrain.Apr 13, 2001 · N91335 · Substantial damageNTSB FTW01LA097Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Roe, ARthe inadvertent stall by the pilot while maneuvering at low altitude. A contributory factor was the tailwind.Apr 8, 2001 · N2129E · Substantial damageNTSB DEN01LA084Accident · No injuriesLimited investigationFinal reportBell 222UT · Alcova, WYthe pilot's failure to maintain tail rotor clearance during a right pedal turn while hovering.Apr 6, 2001 · N222LF · Substantial damageNTSB ANC01LA046Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Nightmute, AKThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain adequate distance/altitude from terrain, resulting in a collision with terrain while maneuvering. Factors in the accident were flat light conditions,…Apr 4, 2001 · N1581U · Substantial damageNTSB LAX01FA134Accident · 2 fatalField investigationFinal reportCessna 172N · Rialto, CAThe pilot's intentional visual flight into instrument meteorological conditions. Contributing to the accident was the pilot's improper weather evaluation and lack of total experience.Apr 1, 2001 · N739WE · DestroyedNTSB ATL01LA043Accident · No injuriesLimited investigationFinal reportGlobe GC1B · Cherry Point, NCFatigue cracking of the propeller hub that resulted in the in-flight separation of a propeller blade.Apr 1, 2001 · N78321 · Substantial damageNTSB NYC01LA091Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Wintergreen, VAThe pilot's improper decision to continue the flight into deteriorating weather.Mar 31, 2001 · N5433Q · Substantial damageNTSB MIA01FA107Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Concord, NCAn in-flight collision with terrain for undetermined reasons.Mar 30, 2001 · N42Y · DestroyedNTSB LAX01FA129Accident · 3 fatalField investigationFinal reportCessna 172N · Santa Monica, CAthe pilot's loss of airplane control while maneuvering due to spatial disorientation. Contributing factors were the dark night, the marine cloud layer that restricted the pilot's cruising altitude, and the pilot's lack of familiarity with nighttime flight…Mar 29, 2001 · N2838E · DestroyedNTSB MIA01LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAThe pilot's failure to maintain a visual lookout while maneuvering during a agricultural run, and inadvertent descent with a known sun glare resulting in an in-flight collision with terrain.Mar 22, 2001 · N6674Z · Substantial damageNTSB FTW01LA087Accident · No injuriesLimited investigationFinal reportBell 47G2 · Ardmore, OKthe loss of tail rotor control during maneuvering resultant from the failure of the tail rotor drive shaft coupling due to a stripped thread which allowed the grease lubricating the shaft to leak out. A factor was the lack of suitable terrain for the forced…Mar 22, 2001 · N1575 · Substantial damageNTSB DEN01FA074Accident · 2 fatalField investigationFinal reportVangilder Christen Eagle II · Ogden, UTthe flight instructor's failure to maintain aircraft control while maneuvering and the subsequent inadvertent stall/spin. A contributing factor was the flight instructor's lack of familiarity with the airplane.Mar 22, 2001 · N5JV · DestroyedNTSB SEA01FA064Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Greenwater, WAFailure to maintain clearance from mountainous terrain.Mar 20, 2001 · N8769N · DestroyedNTSB LAX01TA119Accident · No injuriesFinal reportEurocopter France AS350-B2 · Hayward, CAThe fatigue fracture of the engine accessory drive gear while maneuvering, which resulted in a loss of engine power and collision with a residential transmission line during the ensuing forced landing. A factor associated with the accident was the residential…Mar 18, 2001 · N996PD · Substantial damageNTSB FTW01LA082Accident · Serious injuriesLimited investigationFinal reportChampion 7KCAB · Ragley, LAthe loose clamp (Nicopress fitting) on the elevator control cable due to inadequate quality control during the cable's manufacturing, which allowed the cable to disconnect and restricted the pilot's control of the airplane during landing.Mar 17, 2001 · N9017L · Substantial damageNTSB FTW01LA076Accident · No injuriesLimited investigationFinal reportRobinson R22 · Alvarado, TXthe pilot's failure to maintain clearance with a marked static wire.Mar 10, 2001 · N4009W · Substantial damageNTSB MIA01LA089Accident · 1 fatalLimited investigationFinal reportPiper PA-32RT-300T · Gulfport, MSthe pilot's attempted flight into known adverse weather, resulting in an in flight loss of control, exceedance of design limits of the aircraft, and wing separation prior to collision with water.Mar 3, 2001 · N911PL · DestroyedNTSB FTW01LA073Accident · No injuriesLimited investigationFinal reportHughes 369D · Canadian, TXthe helicopter's encounter with loss of tail rotor effectiveness while hovering out-of-ground effect, and the pilot's failure to maintain control. A contributing factor was the soft terrain condition.Mar 2, 2001 · N8356F · Substantial damageNTSB SEA01LA055Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Waitsburg, WAThe pilot's failure to maintain clearance from the power lines during a pull-up, resulting in an in-flight collision with the lines, loss of control and subsequent in-flight collision with terrain. Contributing factors were the power lines and the pilot's…Feb 28, 2001 · N48651 · DestroyedNTSB MIA01LA084Accident · 1 fatalLimited investigationFinal reportBoeing Helicopters Div. 369D · Inverness, MSThe lineman's failure to use the designed attachment point for securing his safety harness to the helicopter, resulting in overload and failure of the component he did attach to. A factor in the accident was the lineman's failure to follow exact sequential…Feb 23, 2001 · N58377 · No damageNTSB DEN01FA064Accident · 3 fatalField investigationFinal reportBeech V35 · Wendover, UTThe pilot flying at an altitude insufficient to clear surrounding terrain. Contributing factors were the pilot becoming lost/disoriented, his subsequent spatial disorientation, and dark night conditions.Feb 19, 2001 · N5757K · DestroyedNTSB CHI01LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Detroit Lakes, MNAltitude/clearance not maintained from the transmission wires during a low altitude flight/maneuver performed by the pilot. A factor to the accident was the transmission wires.Feb 18, 2001 · N9714W · Substantial damageNTSB MIA01LA080Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Seminole, ALthe pilot's improper inflight planning/decision and failure to refuel en route and ensure an adequate supply of fuel to safely complete the flight to his destination with adequate reserves, which resulted in fuel exhaustion, subsequent engine failure, and a…Feb 16, 2001 · N210FW · Substantial damageNTSB DEN01FA053Accident · 1 fatalField investigationFinal reportRoss G-202 · Grand Junction, COthe pilot's inadvertent entry into a spin while performing aerobatic maneuvers. A contributing factor was the pilot's lack of aerobatic experience.Feb 16, 2001 · N39HR · DestroyedNTSB MIA01LA083Accident · No injuriesLimited investigationFinal reportPiper J5A · Hollywood, FLthe pilot's improper inflight planning/decision and inadequate fuel consumption calculations that resulted in fuel exhaustion and substantial damage to the aircraft as a result of a hard landing during the emergency descent/landing.Feb 15, 2001 · N35288 · Substantial damageNTSB LAX01FA101Accident · 4 fatalField investigationFinal reportCessna 152 · Long Beach, CAThe failure of the flight crews of both airplanes to maintain adequate visual lookout for traffic.Feb 15, 2001 · N68763 · 2 aircraft · DestroyedNTSB FTW01FA065Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Pampa, TXthe pilot's failure to maintain terrain clearance. Contributing factors were the dark night and the fog.Feb 13, 2001 · N1256R · DestroyedNTSB MIA01LA076Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Parkland, FLThe failure of the instructor to take corrective action in a timely manner to prevent the helicopter from contacting the ground when the student allowed it to descend during hover practice which resulted in a dynamic rollover.Feb 12, 2001 · N2327S · Substantial damageNTSB MIA01FA075Accident · 2 fatalField investigationFinal reportBrantly B-2B · Archer, FLThe flight crew's loss of control for undermined reasons.Feb 11, 2001 · N2166U · DestroyedNTSB FTW01FA063Accident · 2 fatalField investigationFinal reportAero Vodochody L-39C · Pecan Island, LAthe pilot's failure to maintain altitude/clearance from terrain while performing low level aerobatics. A factor was fatigue.Feb 10, 2001 · N901NL · DestroyedNTSB CHI01FA085Accident · 1 fatalField investigationFinal reportCessna 152 · Horicon, WIthe inadvertent stall/spin. Additional factors included the aerobatic manuevers, low altitude, and the procedures not followed.Feb 10, 2001 · N5085P · DestroyedNTSB FTW01IA062Incident · No injuriesIncident investigationFinal reportCessna 172S · Ruston, LAthe loss of engine power while manuevering as a result of an incorrect mixture control adjustment. A contributing factor was the lack of suitable terrain for the ensuing forced landing.Feb 7, 2001 · N980SP · Minor damageNTSB FTW01FA058Accident · 2 fatalField investigationFinal reportCessna 152 · Platter, OKthe failure of both pilots to maintain a visual lookout, which resulted in a mid-air collision over a lake. A contributing factor to the accident was the sun glare from the setting sun.Feb 6, 2001 · N114SS · 2 aircraft · DestroyedNTSB LAX01LA087Accident · 2 fatalLimited investigationFinal reportSutton Tailwind W-8L · Reno, NVThe pilot performed aerobatics at low altitude and failed to maintain clearance from the gound resulting in a collision with the terrain.Feb 4, 2001 · N12079 · DestroyedNTSB CHI01FA077Accident · 2 fatalField investigationFinal reportWatson Steen Skybolt · Camdenton, MOThe pilot not maintaining altitude/clearance from terrain during the low altitude maneuver. Factors were the wind gusts and the low altitude maneuver the pilot performed.Feb 4, 2001 · N50BW · DestroyedNTSB MIA01GA070Accident · 2 fatalFinal reportPiper PA-32-300 · Marathon, FLThe pilot-in-command's lack of recent experience in instrument flight resulting in the pilot becoming spatially disoriented, and subsequent in-flight collision with water while descending.Feb 2, 2001 · N99WD · DestroyedNTSB NYC01LA070Accident · 1 fatalLimited investigationFinal reportWhittman Tailwind DN-1 · Grafton, WVThe pilot's improper preflight planning, which resulted in fuel exhaustion. A factor was the pilot's lack of familiarity with the airplane.Jan 22, 2001 · N911N · Substantial damageNTSB LAX01LA078Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T34 · Holtville, CAThe pilot's failure to maintain clearance from the wires. Contributing to the accident was the pilot's inadequate preflight inspection.Jan 18, 2001 · N8927Q · Substantial damageNTSB CHI01FA067Accident · 2 fatalField investigationFinal reportCessna 182B · Piedmont, KSThe pilot's failure to maintain obstacle clearance. Contributing factors were low altitude maneuvering and the transmission wire.Jan 18, 2001 · N2371G · DestroyedNTSB ANC01LA030Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Tyonek, AKThe pilot's failure to maintain adequate tail rotor clearance while maneuvering to land.Jan 18, 2001 · N80KA · Substantial damageNTSB FTW01FA048Accident · 1 fatalField investigationFinal reportBell 206B · Mineral Wells, TXthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Jan 8, 2001 · N152AL · Substantial damageNTSB FTW01LA064Accident · No injuriesLimited investigationFinal reportCessna 172 · Pine Bluff, ARthe pilot's failure to maintain directional control during the forced landing on a gravel road. Contributing factors were the pilot's delay in using carburetor heat and the loose gravel.Jan 6, 2001 · N8984B · Substantial damageNTSB LAX01LA068Accident · No injuriesLimited investigationFinal reportWallace Rotorway Exec 152 · Placerville, CAThe failure of the student pilot to maintain adequate ground clearance while hovering.Jan 1, 2001 · N94LW · DestroyedNTSB SEA01FA032Accident · 2 fatalField investigationFinal reportHughes 369HS · Pierce, IDWhile maneuvering, clearance from an object was not maintained. A tree was a factor.Dec 28, 2000 · N9186F · Substantial damageNTSB FTW01LA042Accident · Serious injuriesLimited investigationFinal reportRobinson R-22B2 · Mesquite, TXThe student pilot's abrupt control input, which resulted in a tail rotor blade strike. Factors were the CFI's delay in taking remedial action and the student pilot's lack of total experience.Dec 22, 2000 · N7158M · Substantial damageNTSB DEN01LA029Accident · No injuriesLimited investigationFinal reportCessna 172E · Salt Lake City, UTthe lack of suitable terrain for a forced landing. A factor was a total power loss due to a connecting rod failure.Dec 16, 2000 · N96024 · Substantial damageNTSB MIA01FA043Accident · 1 fatalField investigationFinal reportPiper PA-31-325 · Belvidere, NCThe pilot's failure to maintain airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions resulting in the airplane entering a descending turn and crashing into terrain.Dec 14, 2000 · N120JB · Destroyed