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 SEA92FA002Accident · 4 fatalField investigationFinal reportCessna 172G · Miltonfreewater, ORInadequate in-flight planning. Factors to the accident were: mountainous terrain, clearance not maintained, lack of total flight experience, and lack of familiarity with geographical area.Oct 6, 1991 · N1372F · DestroyedNTSB FTW92DPJ01Accident · 1 fatalFinal reportAyres S2R-T15 · Cordell, OKInadvertent stall. A factor was that the aircraft weight and balance limitations were exceeded.Oct 5, 1991 · N4008S · DestroyedNTSB NYC92LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Auburn, METhe pilot was buzzing and stalled the airplane at too low an altitude to recover.Oct 4, 1991 · N2065E · Substantial damageNTSB MIA92LA003Accident · Minor injuriesLimited investigationFinal reportBell 47D-1 · Clewiston, FLThe pilot in command's failure to maintain adequate clearance while maneuvering resulting in an in flight collision with a guy wire.Oct 4, 1991 · N3655F · Substantial damageNTSB LAX92LA005Accident · No injuriesLimited investigationFinal reportRobinson R22B · Honolulu, HIThe improper use of the flight controls by the instructor pilot ND the failure to maintain proper rotor RPM.Oct 4, 1991 · N900AB · Substantial damageNTSB SEA91FA258Accident · 2 fatalField investigationFinal reportCessna 182Q · Lincoln, MTThe improper inflight planning/decision by the pilot to continue VFR flight into IMC conditions. Factors relating to the accident were the mountainous terrain in the area, and the low ceilings and clouds obscuring the mountains.Sep 30, 1991 · N759SN · DestroyedNTSB MIA91LA228Accident · Serious injuriesLimited investigationFinal reportAeronca 7EC · Moore Haven, FLThe pilot's diversion of attention and inattention to the airspeed resulting in the inadvertent stall mush. Contributing to the accident was inadequate altitude to recover.Sep 29, 1991 · N4713E · Substantial damageNTSB LAX91LA413Accident · Minor injuriesLimited investigationFinal reportGrumman G164A-450 · Queen Creek, AZFailure of the engine cylinder, producing a loss of power. Contributing to the accident was the location of an irrigation ditch next to the landing area and a dark night light condition.Sep 29, 1991 · N16SS · Substantial damageNTSB ATL91LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Newberry, SCThe pilot's failure to maintain visual lookout and clearance while maneuvering at a low altitude.Sep 29, 1991 · N2862E · Substantial damageNTSB LAX91LA412Accident · 2 fatalLimited investigationFinal reportChristian Ind. Eagle II · Incline Village, NVThe failure of the pilot to recover from the maneuver in a timely manner which resulted in the airplane striking the water.Sep 28, 1991 · N432EC · DestroyedNTSB LAX91LA411Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Rio Vista, CAThe student pilot's improper use of the flight controls.Sep 27, 1991 · N8069Q · DestroyedNTSB CHI91FA305Accident · 1 fatalField investigationFinal reportErcoupe Ercoupe 415-D · Emmett, MIThe pilot's exceeding the design limits of the aircraft, which resulted in an inflight breakup.Sep 27, 1991 · N99283 · DestroyedNTSB ATL91LA180Accident · No injuriesLimited investigationFinal reportContinental Copters MK5A · Franklin, GAAn undetermined failure of the tail rotor control cable, which resulted in an uncontrolled collision with the ground.Sep 26, 1991 · N62108 · Substantial damageNTSB CHI91FA302Accident · 2 fatalField investigationFinal reportCessna A150L · Bellaire, MIThe instructor pilot's inadequate supervision which resulted in an inaverent stall and uncontrolled descent into terrain. A related factor is the insufficient altitude.Sep 24, 1991 · N4501F · DestroyedNTSB ATL91LA178Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Brewton, ALThe inflight separation of the left wing resulting from corrosion of the wing front spar fitting assembly. A factor was inadequate maintenance procedures.Sep 21, 1991 · N7509Z · DestroyedNTSB ANC91LA150Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Stoney River, AKThe pilot's failure to attain a proper climb. Factors in the accident were: the pilot's lack of familiarity with the airplane, his inadequate training in that model airplane, his lack of total experience, his inflight planning/decision, his overconfidence in…Sep 21, 1991 · N8143D · Substantial damageNTSB SEA91FA246Accident · Serious injuriesField investigationFinal reportCessna C-172G · Red Lodge, MTThe loss of control by the instructor due to the improper recovery altitude selected to terminate a simulated forced landing, the excessive pull-up by the student due to his lack of experience, and the delayed remedial action of the instructor. Factors…Sep 20, 1991 · N1359F · DestroyedNTSB MIA91LA220Accident · No injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Bay Springs, MSTotal loss of engine power due to undetermined reasons. Contributing to the accident was unsuitable terrain encountered during the forced landing.Sep 18, 1991 · N9010T · Substantial damageNTSB SEA91LA238Accident · No injuriesLimited investigationFinal reportChampion 7EC · Coeur D'Alene, IDA blocked fuel system vent, and an inadequate aircraft preflight by the pilot. Rough terrain in the emergency landing area was a related factor.Sep 17, 1991 · N7547E · Substantial damageNTSB SEA91LA237Accident · 1 fatalLimited investigationFinal reportCessna 170B · Curtis, WAA misjudged maneuver due to physical impairment by alcohol. Contributing to the accident was overconfidence in personal ability.Sep 16, 1991 · N4693C · DestroyedNTSB DEN91FA132Accident · 2 fatalField investigationFinal reportCessna 172N · Tererro, NMA failure of the pilot to maintain adequate obstacle clearance in mountainous terrain. Factors were: lack of familiarity with the aircraft, and insufficient standards by the operator.Sep 15, 1991 · N4868F · DestroyedNTSB CHI91FA294Accident · 3 fatalField investigationFinal reportBell-K Copter 47D1 · Laurie, MOPoor judgement of the pilot, due to impairment from consumption of alcoholic beverage before flight, his intentional buzzing, and his inadequate visual lookout (failure to see-and-avoid power lines).Sep 15, 1991 · N7768 · DestroyedNTSB LAX91FA394Accident · 2 fatalField investigationFinal reportCessna 210 · Rialto, CAThe pilot's inadequate weather evaluation and poor inflight planning/decision. The pilot's impairment due to the use of drugs was a factor in the accident.Sep 14, 1991 · N6558X · DestroyedNTSB CHI91DCQ09Accident · No injuriesFinal reportHispano Aviacion HA200 · Liberal, KSA disconnected ignition harness resulting in an inflight fire during maneuvering flight.Sep 14, 1991 · N9123E · Substantial damageNTSB LAX91LA392Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6G · Reno, NVThe failure of the pilot to maintain an adequate clearance between the aircraft and the ground while maneuvering around a pylon, which resulted in a loss of control during landing.Sep 12, 1991 · N29931 · Substantial damageNTSB CHI91DTK05Accident · No injuriesFinal reportEagle DW1 · Hurley, SDThe failure of the pilot to maintain a visual lookout.Sep 10, 1991 · N8814L · Substantial damageNTSB LAX91LA387Accident · 1 fatalLimited investigationFinal reportRotorway Exec 90 · Phoenix, AZUndetermined.Sep 8, 1991 · N7456T · Substantial damageNTSB LAX91LA383Accident · 3 fatalLimited investigationFinal reportCessna 172 · Arroyo Grande, CAThe pilot's failure to maintain a proper altitude, and continued flight into instrument meteorological conditions.Sep 5, 1991 · N739YG · DestroyedNTSB ANC91FA142Accident · No injuriesField investigationFinal reportCessna 208 · Dillingham, AKThe pilot's inattentive preflight inspection which resulted in his failure to properly secure the engine oil tube filler cap resulting in the loss of engine oil and oil pressure and the pilot's failure to properly compensate for wind conditions during the…Sep 3, 1991 · N9438F · Substantial damageNTSB ATL91LA169Accident · Minor injuriesLimited investigationFinal reportBates, Frank L Skybolt · Yatesville, GAThe pilot's failure to maintain a proper altitude during maneuvering flight.Sep 2, 1991 · N9FB · DestroyedNTSB ATL91LA168Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235C · Bainbridge, GAThe pilot's failure to maintain adequate clearance from objects while practicing aerial application procedures.Sep 2, 1991 · N4393Y · DestroyedNTSB NYC91LA227Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Galloway, OHImproper supervision by the flight instructor which resulted in an inadvertent ground contact and a dynamic rollover. A factor related to the accident was improper use of the flight controls by the non-rated student pilot.Sep 1, 1991 · N9590F · Substantial damageNTSB LAX91LA377Accident · 1 fatalLimited investigationFinal reportKaman HH43 B/F · Coleville, CAThe failure of the pilot to adequately calculate the helicopter performance. Contributing to the accident was a delay in jettisoning the external load; the pilot's overconfidence in his abilities; and exceeding of the helicopter's hover ability during high…Aug 31, 1991 · N53RH · DestroyedNTSB CHI91DCD03Accident · 2 fatalFinal reportTullis Tierra II · Ottumwa, IAFailure of the pilot to maintain control of the airplane during maneuvering flight.Aug 31, 1991 · N2162S · DestroyedNTSB SEA91FA223Accident · 3 fatalField investigationFinal reportAerospatiale 350 B1 · Walton, ORThe pilot's failure to maintain clearance from terrain.Aug 29, 1991 · N64SF · DestroyedNTSB SEA91LA224Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Corbett, ORThe pilot's improper in-flight planning/decision, his delay in taking remedial action, and his failure to maintain clearance from trees on rising terrain. The weather and terrain conditions were related factors.Aug 28, 1991 · N6LG · Substantial damageNTSB NYC91LA217Accident · Minor injuriesLimited investigationFinal reportWaco YMF-5 · Jamestown, RIThe pilot's improper use of carburetor heat, resulting in carburetor ice formation and subsequent loss of engine power and a forced landing in trees.Aug 28, 1991 · N44JS · Substantial damageNTSB MIA91FA209Accident · 2 fatalField investigationFinal reportAeronca 7AC · Dawson, GAThe pilot in command's failure to maintain altitude while maneuvering.Aug 28, 1991 · N84216 · DestroyedNTSB MIA91LA205Accident · Serious injuriesLimited investigationFinal reportMaxair ARV-582 · Jacksonville, FLThe unqualified pilot's failure to maintain airspeed (vso) while maneuvering to land, which resulted in an in flight loss of control, stall spin, and collision with terrain.Aug 26, 1991 · UNREG · Substantial damageNTSB ANC91LA134Accident · No injuriesLimited investigationFinal reportCessna T-207A · Coville Lake, AKA total failure of the power output shaft bolts due to fatigue. Contributing to the accident was the rough and uneven terrain.Aug 25, 1991 · N73762 · Substantial damageNTSB LAX91LA375Accident · Serious injuriesLimited investigationFinal reportBeierle Thunder Gull J · Santa Margarita, CAThe failure of the wing spar when the design limits of the airplane was exceeded by the pilot. Contributing to the accident was an inadequate airframe design and an abrupt movement of the flight controls by the pilot.Aug 24, 1991 · UNREG · DestroyedNTSB CHI91LA272Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Freeburg, ILImproper use of the mixture control by the pic/cfi. A factor related to the accident was inadequate friction on the mixture control lever.Aug 23, 1991 · N8479F · Substantial damageNTSB ANC91FA132Accident · 3 fatalField investigationFinal reportCessna 172 · Eklutna Lake, AKThe pilot's failure to maintain terrain clearance. Contributing to the accident was the high terrain.Aug 23, 1991 · N98785 · Substantial damageNTSB LAX91LA363Accident · Minor injuriesLimited investigationFinal reportBell 47G · Kettleman City, CAA non-mechanical loss of engine power due to fuel exhaustion by the pilot's improper calculation of the fuel supply and subsequent hard landing.Aug 20, 1991 · N4062G · Substantial damageNTSB FTW91FA149Accident · 2 fatalField investigationFinal reportCessna 150K · Waller, TXThe instructor pilot's failure to take remedial action during stall/spin training. Factors were the instructor's overconfidence in his personal ability and the student's apprehension of stalls.Aug 20, 1991 · N6102G · DestroyedNTSB CHI91DEP12Accident · No injuriesFinal reportSchweizer G-164-A · Elkhorn, WIThe pilot in command's failure to maintain adequate altitude.Aug 20, 1991 · N48635 · Substantial damageNTSB DEN91LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-150 · Seagraves, TXThe pilot's improper inflight planning which resulted in loss of aircraft control due to wake turbulence.Aug 17, 1991 · N6261Z · DestroyedNTSB CHI91DTG08Accident · No injuriesFinal reportGrumman G164B · Minto, NDInadequate aircraft servicing, inadequate aircraft preflight, fuel contamination, and unsuitable soft terrain in which to effect an emergency landing.Aug 17, 1991 · N8351K · Substantial damageNTSB ANC91FA128Accident · 3 fatalField investigationFinal reportMaule M-5 · Ruby, AKA loss of control inflight due to improper aircraft handling and alcohol impairment.Aug 17, 1991 · N9026E · DestroyedNTSB SEA91LA208Accident · Minor injuriesLimited investigationFinal reportChampion 7GCAA · Townsend, MTThe instructor pilot's not maintaining the power off stall speed resulting in a stall condition. A factor contributing to the accident was the lack of sufficient altitude to enable a successful recovery from the stall.Aug 16, 1991 · N1645G · Destroyed