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 SEA97LA059Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Madras, ORThe pilot's inadvertent visual flight rules (VFR) flight into instrument meteorological conditions (IMC). Factors include the pilot's improper decision to fly under a low ceiling while in mountainous/hilly terrain, and his encounter with fog and low clouds…Feb 7, 1997 · N5618J · Substantial damageNTSB FTW97FA100Accident · 3 fatalField investigationFinal reportPiper PA-28-200 · Lone Wolf, OKthe pilot's impairment of judgment and performance due to drugs, his resultant improper planning/decision, and his failure to maintain sufficient altitude (clearance above a lake), while performing aerobatic flight. Factors relating to the accident were: the…Feb 3, 1997 · N33322 · DestroyedNTSB SEA97LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Moorcroft, WYThe pilot's failure to maintain adequate airspeed. A factor was the pilot's low altitude flight and maneuvering.Feb 2, 1997 · N83347 · Substantial damageNTSB MIA97LA081Accident · Serious injuriesLimited investigationFinal reportCessna A150L · St. Mary'S, GAthe pilot's failure to maintain airspeed which resulted in an inadvertent stall the at too low an altitude to allow recovery. A factor in this accident was the pilot's attention was diverted.Feb 2, 1997 · N6005J · Substantial damageNTSB MIA97LA078Accident · No injuriesLimited investigationFinal reportRichards Velocity 173 RG · Valkaria, FLa loss of engine power for undetermined reasons.Feb 1, 1997 · N525V · Substantial damageNTSB ATL97FA034Accident · 2 fatalField investigationFinal reportCessna A150L · Trinity, ALfailure of the pilot to maintain flying airspeed, while maneuvering at low altitude, which resulted in a stall and subsequent collision with a tree, utility line, and the ground.Feb 1, 1997 · N50TB · DestroyedNTSB FTW97FA097Accident · 2 fatalField investigationFinal reportCessna 152 · Guthrie, OKThe flight instructor's failure to obtain/maintain clearance with the power line. A factor was the sunglare from the setting sun, which could have impaired the flight instructor's ability to see the power line.Jan 31, 1997 · N5366B · DestroyedNTSB ATL97LA036Accident · No injuriesLimited investigationFinal reportRobinson R22 · Wiggins, MSthe student pilot misjudged rotor blade clearance from a utility pole, which resulted in a collision. The proximity of the pole was a related factor.Jan 31, 1997 · N8319T · Substantial damageNTSB MIA97LA073Accident · 1 fatalLimited investigationFinal reportCress Cress B-8-M (Bensen) · Williston, FLfailure of the pilot to maintain rotor rpm, while maneuvering, which resulted in an uncontrolled descent and collision with terrain.Jan 24, 1997 · N3495 · DestroyedNTSB SEA97FA049Accident · 2 fatalField investigationFinal reportChampion 7-GCBC · Creswell, ORthe pilot exceeded the design stress limits of the aircraft, while recovering from a spin, which resulted in failure and separation of the right wing tip and adjacent wing fabric (skin).Jan 19, 1997 · N9677S · DestroyedNTSB MIA97FA063Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Okeechobee, FLthe noninstrument-rated pilot's decision to conduct a VFR flight into instrument meteorological flight conditions. The weather was a factor.Jan 16, 1997 · N712DB · DestroyedNTSB FTW97LA083Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Laporte, TXThe pilot's diminished ability to maintain control of the airplane due to a jammed elevator control as result of inadequate maintenance procedures by the operator's mechanic.Jan 15, 1997 · N5062P · Substantial damageNTSB SEA97LA047Accident · No injuriesLimited investigationFinal reportBarriger RV-6 · The Dalles, ORThe pilot's failure to maintain clearance from a powerline during an intentional low altitude maneuver.Jan 9, 1997 · N812AB · Substantial damageNTSB SEA97LA046Accident · Serious injuriesLimited investigationFinal reportCessna TU-206 · Cascade, IDThe pilot's failure to maintain adequate altitude/clearance from the terrain while reversing course in mountainous terrain. Factors include the mountainous terrain and tall trees in the area where he was maneuvering.Jan 7, 1997 · N717CM · Substantial damageNTSB MIA97GA059Accident · 1 fatalFinal reportAyres S2RHG-T65 · Guaviare, Colombiathe pilot's failure to maintain adequate altitude/clearance while maneuvering at a low altitude.Jan 7, 1997 · N3100U · DestroyedNTSB MIA97LA052Accident · 1 fatalLimited investigationFinal reportSirocco Flying Club MJ 5 · Sanford, FLfailure of the pilot to maintain adequate airspeed, while maneuvering in the traffic pattern (crosswind) after takeoff, which resulted in an inadvertent stall, uncontrolled descent, and collision with terrain.Dec 31, 1996 · N949EA · DestroyedNTSB LAX97LA079Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Banning, CAThe pilot's intentional low flight in an area of foothills and canyons at an altitude insufficient to maintain clearance from obstacles.Dec 29, 1996 · N9944U · Substantial damageNTSB NYC97LA037Accident · 1 fatalLimited investigationFinal reportRichardson Kitfox 4 · Trenton, MEfailure of the pilot to maintain adequate airspeed while maneuvering after takeoff, which resulted in a stall/spin and an uncontrolled descent into terrain. The airplane's excessive gross weight was a related factor.Dec 24, 1996 · N922VR · DestroyedNTSB MIA97LA048Accident · No injuriesLimited investigationFinal reportKelly Rans S-12 · Jacksonville, FLfailure of the pilot to maintain adequate airspeed, while maneuvering after takeoff, which resulted in a stall/mush and collision with trees.Dec 24, 1996 · N6156K · Substantial damageNTSB FTW97LA071Accident · No injuriesLimited investigationFinal reportCessna 210A · Peyton, COthe pilot's improper fuel management by failing to avoid a prolong uncoordinated turn or slip, which resulted in fuel starvation. Factors relating to the accident were: darkness, and the lack of (activated) runway lights.Dec 23, 1996 · N6680X · Substantial damageNTSB IAD97LA037Accident · No injuriesLimited investigationFinal reportRobinson R22 HP · Islip, NYThe students pilot's failure to maintain control of the helicopter and the instructor's inadequate supervision of the flight.Dec 22, 1996 · N8414H · Substantial damageNTSB SEA97LA038Accident · No injuriesLimited investigationFinal reportBeech BE-77 · Spokane, WAThe failure of the pilots of both airplanes to see and avoid each other. A factor contributing to the accident was the Cessna's pilot diverted attention.Dec 18, 1996 · N6043M · 2 aircraft · Substantial damageNTSB LAX97LA068Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Lakeport, CAinadequate supervision by the flight instructor (CFI), and his delayed corrective action to the student pilot's abrupt control inputs, thereby allowing the main rotor blades to strike the ground. Factors relating to the accident were: the CFI's lack of…Dec 15, 1996 · N8311A · Substantial damageNTSB SEA97FA037Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Eagle Point, ORThe failure of the first pilot (flight instructor) to initiate proper aircraft control, and his failure to perform the adequate remedial action to recover from an intentional inverted spin.Dec 14, 1996 · N278ML · DestroyedNTSB SEA97LA035Accident · 2 fatalLimited investigationFinal reportBell 47G · Pendleton, ORThe pilot-in-command's attempt to conduct visual flight into instrument meteorological conditions, and his failure to maintain altitude/clearance with hilly terrain. A contributing factor in the accident was the presence of fog.Dec 10, 1996 · N4758R · DestroyedNTSB FTW97LA058Accident · No injuriesLimited investigationFinal reportAerospatiale AS350B · East Cameron 71failure of the pilot to maintain clearance from an object (crane/bucket). The gusty wind condition and proximity of the crane/bucket were related factors.Dec 9, 1996 · N390MA · Substantial damageNTSB NYC97LA026Accident · 1 fatalLimited investigationFinal reportParker Mustang · Port Norris, NJThe student pilot's failure to maintain adequate airspeed.Dec 8, 1996 · N7009S · DestroyedNTSB ATL97FA092Accident · 2 fatalField investigationFinal reportCessna 182 · Charleston, SCThe noninstrument-rated pilot's failure to remain clear of instrument meteorological conditions which led to spatial disorientation and loss of aircraft control. A factor was the pilot's failure to obtain a weather briefing.Dec 7, 1996 · N8683T · Substantial damageNTSB MIA97LA035Accident · No injuriesLimited investigationFinal reportHoster/Volmer VJ22 (Sportsman) · Seminole, FLinadequate maintenance/inspection of the airplane by the pilot/owner, and fuel contamination that resulted in fuel starvation.Dec 6, 1996 · N2921 · Substantial damageNTSB SEA97LA036Accident · 2 fatalLimited investigationFinal reportPiper PA18-135 · Cohagen, MTThe pilot's failure to maintain airspeed. Factors were the intentional flight at a low altitude and the over gross condition of the airplane.Dec 5, 1996 · N62100 · Substantial damageNTSB LAX97FA065Accident · 2 fatalField investigationFinal reportOpperman Lancair IV-P · Suisun City, CAIn-flight loss of control for an undetermined reason.Dec 5, 1996 · N444LP · DestroyedNTSB ATL97FA021Accident · 3 fatalField investigationFinal reportBellanca 17-31ATC · Fitzgerald, GAA loss of engine power due to the blockage of the intake manifold of the induction air system, by the broken alternate air door, and the loss of aircraft control for undetermined reasons.Dec 1, 1996 · N123SS · Substantial damageNTSB ANC97FA009Accident · 2 fatalField investigationFinal reportCessna 185 · Marshall, AKfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall and collision with the terrain.Nov 30, 1996 · N93829 · DestroyedNTSB LAX97LA057Accident · Serious injuriesLimited investigationFinal reportBell 206B · Mcgregor Point, HIthe pilot's failure to maintain control of the aircraft and distance from the pole.Nov 29, 1996 · N6262N · Substantial damageNTSB MIA97LA028Accident · 1 fatalLimited investigationFinal reportNorth American T28B · Somerville, TNthe pilot misjudged his altitude/clearance above trees on terrain that was higher than the surrounding terrain, while performing an aerobatic maneuver.Nov 23, 1996 · N3178U · DestroyedNTSB FTW97TA046Accident · No injuriesFinal reportAerospatiale AS-355-F1 · Taos, NMThe pilot's failure to maintain directional control. A factor was terrain induced turbulence.Nov 23, 1996 · N606SP · Substantial damageNTSB CHI97LA035Accident · No injuriesLimited investigationFinal reportCessna 150 · Chesterfield, MOthe pilot's failure to maintain an adequate visual lookout.Nov 22, 1996 · N704DR · Substantial damageNTSB MIA97LA027Accident · No injuriesLimited investigationFinal reportCessna A188B · Ocilla, GAthe pilot's inadequate fuel consumption calculations and failure to ensure the aircraft contained an adequate amount of fuel to complete the flight, which resulted in loss of engine power because of fuel exhaustion. Uneven terrain in the emergency landing…Nov 20, 1996 · N53319 · Substantial damageNTSB SEA97LA029Accident · Serious injuriesLimited investigationFinal reportBell 206B3 · Ballston, ORa loss of control for undetermined reasons.Nov 19, 1996 · N921RB · Substantial damageNTSB SEA97LA032Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Forks, WAfuel contamination, which resulted in loss of engine power. Factors relating to the accident included: improper servicing of the helicopter, and a lack of suitable terrain for an emergency landing due to the proximity of trees.Nov 16, 1996 · N5225C · Substantial damageNTSB SEA97FA027Accident · 1 fatalField investigationFinal reportCessna P210N · Boring, ORThe pilot's attempt to conduct visual flight into instrument meteorological conditions. A factor contributing to the accident was the presence of thick fog.Nov 15, 1996 · N7823K · DestroyedNTSB CHI97FA025Accident · 3 fatalField investigationFinal reportEnstrom F28F · Gutherie, ILthe pilot's inadequate preflight preparation and not maintaining control of the helicopter during its rearward flight. A factor was the pilot's over-confidence in his personal ability.Nov 11, 1996 · N86214 · DestroyedNTSB MIA97FA020Accident · 3 fatalField investigationFinal reportPiper PA-60-600 · New Bern, NCthe pilot's failure to maintain airspeed (VMC). Contributing to the accident was his lack of total experience in kind of aircraft.Nov 9, 1996 · N8239J · DestroyedNTSB MIA97FA021Accident · 1 fatalField investigationFinal reportCessna TU206B · Jasper, GAcontinued flight by the pilot into adverse weather conditions, and his failure to maintain sufficient altitude or clearance from rising/mountainous terrain. The adverse weather and terrain conditions were related factors.Nov 8, 1996 · N4970F · DestroyedNTSB SEA97LA025Accident · 1 fatalLimited investigationFinal reportGarlick TH-1L · Leavenworth, WAFatigue failure of the vertical stabilizer spar cap and subsequent loss of the rotorcraft's vertical stabilizer. Factors include inadequate inspection or trouble-shooting of the aircraft tail cone and vertical stabilizer at and after the time sheet-metal…Nov 5, 1996 · N465JR · DestroyedNTSB IAD97LA015Accident · No injuriesLimited investigationFinal reportAyres Scorpion Executive · Union Vale, NYthe pilot's failure to maintain control of the helicopter, which resulted in a subsequent emergency landing and collision with a fence and a cherry picker (vehicle). A factor relating to the accident was: the student pilot's lack of experience in the type…Nov 4, 1996 · N3903C · Substantial damageNTSB FTW97LA034Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Mancos, COfailure of the pilot to maintain clearance from the windsock, during a hover/pedal-turn after lift-off.Nov 2, 1996 · N937R · Substantial damageNTSB LAX97LA030Accident · Minor injuriesLimited investigationFinal reportBell 206B · Supai, AZimproper routing of the external cargo hoist cable (over helicopter skid), which resulted in lateral imbalance and roll-over of the helicopter, as weight on the cable became effective.Nov 1, 1996 · N90144 · DestroyedNTSB FTW97FA032Accident · 1 fatalField investigationFinal reportMooney M20J · San Leon, TXThe pilot's inadvertent stall and spin of the airplane. Factors were the pilot's lack of total experience in the make and model of airplane and the weather conditions.Nov 1, 1996 · N25LS · Substantial damageNTSB ATL97LA016Accident · No injuriesLimited investigationFinal reportCessna 188B · Ocilla, GAThe pilot's failure to adequately preflight and plan the fuel required for the flight.Oct 31, 1996 · N731BQ · Substantial damage