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 FTW97FA229Accident · 1 fatalField investigationFinal reportAir Tractor AT-301 · Las Animas, COin-flight collision with terrain, while maneuvering, for undetermined reason(s).Jun 19, 1997 · N7308E · DestroyedNTSB SEA97LA143Accident · No injuriesLimited investigationFinal reportCessna A188 · Richland, WAthe pilot's failure to maintain airspeed. Inadequate in-flight planning and high obstructions that restricted evasive maneuvers were factors.Jun 17, 1997 · N9766V · Substantial damageNTSB LAX97TA213Accident · No injuriesFinal reportBell 47G-3B-1 · Fallon, NVexhaustion of the aircraft's fuel supply, due to improper planning and/or decision. A factor related to the accident was the high density altitude which made a successful autorotative landing unlikely.Jun 16, 1997 · N1335X · Substantial damageNTSB FTW97FA221Accident · 2 fatalField investigationFinal reportCessna 172N · Greenbrier, ARThe pilot's failure to maintain aircraft control during a low altitude maneuver. Factors were the pilot's lack of total experience in the type of operation and inadequate training by the company management.Jun 15, 1997 · N738YG · DestroyedNTSB SEA97LA142Accident · No injuriesLimited investigationFinal reportGlaser-Dirks DG-400 · Weston, ORThe pilot's failure to attain a proper descent rate during the forced landing. Factors include: the pilot's failure to use an 'engine start' checklist, failure to turn the ignition switch to the 'on' position, failure to use the landing checklist, failure to…Jun 14, 1997 · N321V · Substantial damageNTSB FTW97FA220Accident · 1 fatalField investigationFinal reportAyres S2R-T34 · Corning, ARThe in-flight separation of the left wing as result of fatigue crack of the lower spar cap due to inadequate materials by the manufacturer. A factor was the operator's failure to comply with a published service bulletin on the airframe.Jun 14, 1997 · N3103D · DestroyedNTSB FTW97LA223Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-400A · Black Oak, ARThe loss of engine power due to compressor turbine blade failure. A factor was the lack of suitable terrain for the forced landing.Jun 13, 1997 · N3161J · DestroyedNTSB ATL97LA086Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MDHC-369E · Okahumpka, FLThe failure of the crewmember to use the necessary safety equipment, and his subsequent fall from an elevated platform. A factor was the crewmember's distraction with an animal.Jun 13, 1997 · N765KV · No damageNTSB FTW97LA217Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Weston, COthe pilot's improper in-flight planning/decision and failure to maintain adequate altitude and/or clearance from rising mountainous/hilly terrain. The unfavorable wind condition and low airspeed were related factors.Jun 12, 1997 · N207DS · Substantial damageNTSB SEA97LA136Accident · Serious injuriesLimited investigationFinal reportStaudacher S-260-2 · Wallace, IDthe pilot's improper planning/decision, which resulted in his failure to maintain adequate altitude/distance from wooded terrain during a low-altitude course reversal. Related factors include mountainous/hilly terrain, blind canyon, low ceiling, and trees in…Jun 11, 1997 · N540S · Substantial damageNTSB LAX97LA206Accident · No injuriesLimited investigationFinal reportBell UH-1B · Heron, CApartial loss of engine power for undetermined reasons. A factor relating to the accident was that the engine lost power when the helicopter was outside (below) the limits of the height/velocity curve.Jun 11, 1997 · N888SJ · DestroyedNTSB IAD97LA086Accident · Minor injuriesLimited investigationFinal reportLuscombe LL-8-A · Annapolis, MDthe pilot's failure to use carburetor heat, which resulted in accumulation of carburetor ice and subsequent loss of engine power. Related factors were: carburetor icing conditions, and trees in the emergency landing area.Jun 11, 1997 · N37095 · DestroyedNTSB LAX97GA205Accident · 1 fatalFinal reportRockwell OV-10A · Hollister, CAthe pilot's failure to maintain adequate ground clearance altitude while performing a low-level aerobatic maneuver. A factor in the accident was the pilot's lack of experience in the aircraft.Jun 10, 1997 · N94LM · DestroyedNTSB NYC97LA121Accident · 1 fatalLimited investigationFinal reportRobbins Kolb Firestar · Gilbertsville, PAThe noncertificated operator's improper decision to fly low over a congested area, which resulted in an abrupt maneuver to avoid a collision with a tethered blimp, and the subsequent uncontrolled descent and collision with terrain.Jun 9, 1997 · UNREG · Substantial damageNTSB NYC97LA108Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 135 · Pepperell, MAThe pilot's failure to maintain airspeed during a turn, which resulted in an inadvertent stall and subsequent uncontrolled descent into water.Jun 8, 1997 · N17976 · Substantial damageNTSB LAX97FA202Accident · 1 fatalField investigationFinal reportCessna 206 · Saugus, CAthe pilot's failure to maintain an adequate terrain clearance altitude while attempting VFR flight into instrument meteorological conditions.Jun 8, 1997 · N756PU · DestroyedNTSB LAX97LA204Accident · No injuriesLimited investigationFinal reportBell 204-B · Kaneohe, HIfailure of the pilot to verify that the load was properly rigged before attempting to pick it up. The uneven (sloping) terrain was a related factor.Jun 6, 1997 · N64F · Substantial damageNTSB SEA97LA126Accident · No injuriesLimited investigationFinal reportGarlick UH-1H · Addy, WAThe inflight failure of the K-FLEX engine-to-gear box drive shaft and no suitable site in which to make a forced/emergency landing. A factor was the mountainous/hilly terrain.Jun 3, 1997 · N85NW · Substantial damageNTSB MIA97FA176Accident · 3 fatalField investigationFinal reportCessna 172N · Comerio, PRthe pilot's improper in-flight planning/decision, which resulted in his failure to maintain sufficient altitude/clearance from obstructions on rising terrain.Jun 2, 1997 · N4752D · DestroyedNTSB FTW97FA207Accident · 1 fatalField investigationFinal reportCanadair F-86E MK.6 · Broomfield, COInadequate planning and decision making by the pilot in starting the aerobatic maneuver at an insufficient altitude to successfully complete the maneuver.Jun 1, 1997 · N86EX · DestroyedNTSB LAX97LA221Accident · No injuriesLimited investigationFinal reportStaudaucher S300D · Chandler, AZThe owner/pilot's decision to use automotive hardware, which had not been heat treated, and the practice of adding aluminum plates to the trailing edge of the aileron without rebalancing the flight controls, which resulted in the separation of the aileron at…May 31, 1997 · N540DH · Substantial damageNTSB FTW97LA212Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Woodsboro, TXThe loss of engine power as result of fuel exhaustion due to the pilot's failure to refuel the airplane. A factor was the unsuitable terrain available for the pilot to execute the forced landing.May 31, 1997 · N842KG · Substantial damageNTSB CHI97LA150Accident · Serious injuriesLimited investigationFinal reportGrumman G164 · Illinois City, ILfailure of the pilot to see and maintain clearance from a static wire. The proximity of the wire was a related factor.May 29, 1997 · N474Y · Substantial damageNTSB SEA97LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-38 · Fruitland, UTThe pilot's failure to maintain clearance from mountainous terrain. Factors include his improper inflight decision to attempt to fly through a mountain pass under high density altitude conditions in an aircraft that was operating near the limits of its…May 27, 1997 · N2362K · Substantial damageNTSB FTW97LA202Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Lamar, COFailure of the left magneto and crank shaft idler drive gears. Factors were failure to perform a 100 hour inspection and unsuitable terrain for a forced landing.May 27, 1997 · N4829Y · Substantial damageNTSB CHI97FA149Accident · No injuriesField investigationFinal reportBell 206L3 · Boise, IDthe improper torque meter installation by maintenance personnel, attempting flight with known discrepancies by the pilot-in-command and the check airman, and an improper autorotation by the pilot-in-command with improper oversight of the autorotation maneuver…May 27, 1997 · N35CH · Substantial damageNTSB MIA97FA173Accident · 6 fatalField investigationFinal reportCessna 205 · Homestead, FLThe pilot-in-command's failure to maintain airspeed as he slowed for a parachutist to jump from the aircraft, and his failure to apply spin recovery emergency procedures prior to ground impact. Contributing to the accident was the pilot-in-command's lack of…May 25, 1997 · N8214Z · DestroyedNTSB FTW97LA200Accident · No injuriesLimited investigationFinal reportBeech BE-56TC · Spring, TXThe pilot's failure to perform an adequate preflight (did not remove pitot tube protective covering prior to flight) which resulted in an inaccurate cockpit airspeed indication during takeoff roll and subsequent emergency landing. Factors were, the pilot's…May 23, 1997 · N7890R · Substantial damageNTSB SEA97LA119Accident · No injuriesLimited investigationFinal reportGarlick UH-1H · Lolo, MTFuel exhaustion due to the pilot's failure to refuel.May 22, 1997 · N95NW · Substantial damageNTSB MIA97FA172Accident · Serious injuriesField investigationFinal reportBell 206B · Winter Park, FLThe pilots improper in-flight planning/decision to conduct an out of ground effect hover with a tailwind resulting in an in-flight loss of directional control due to loss of tailrotor effectiveness/unanticipated right yaw, and subsequent in-flight collision…May 22, 1997 · N61PP · DestroyedNTSB SEA97LA117Accident · 1 fatalLimited investigationFinal reportHiller UH-12E · Miltonfreewater, ORThe main rotor blade separated due to fatigue. Factors were: an Airworthiness Directive was not properly performed, and inadequate inspection of the main rotor blades.May 21, 1997 · N3005J · Substantial damageNTSB ATL97LA073Accident · 1 fatalLimited investigationFinal reportCapstaff Challenger II · Southern Pines, NCThe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain clearance from obstacles.May 21, 1997 · UNREG · Substantial damageNTSB ANC97LA077Accident · No injuriesLimited investigationFinal reportCessna 180 · Shaktoolik, AKloss of engine power for undetermined reason(s).May 21, 1997 · N24EJ · Substantial damageNTSB CHI97LA137Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Paragon, INthe pilot did not maintain aircraft control. The factors involved were aerobatics were performed and improper use of aircraft.May 18, 1997 · N4757B · DestroyedNTSB SEA97LA115Accident · No injuriesLimited investigationFinal reportRobinson R22B · Boise, IDimproper handling of the helicopter by the student pilot/applicant, during a hover autorotation, which resulted in loss of tail rotor effectiveness. The check pilot's inadequate remedial action was a related factor.May 16, 1997 · N2328W · Substantial damageNTSB SEA97LA111Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Freeland, WAFuel exhaustion due to the flight instructor's failure to insure there was proper fuel in the aircraft and the flight instructor's misjudgment of his altitude and airspeed while executing a power-off forced landing in a large open field. Factors include: a…May 13, 1997 · N7557A · Substantial damageNTSB LAX97LA178Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Santa Margarita, CAThe failure of the pilot to maintain adequate rotor rpm during a low pass maneuvering flight resulting in loss of control. High density altitude was a factor in the accident.May 12, 1997 · N83795 · Substantial damageNTSB LAX97FA177Accident · 5 fatalField investigationFinal reportBeech A36TC · Truckee, CAfailure of the pilot to maintain altitude and clearance above the terrain, while turning (for an unknown reason) back toward the airport after takeoff. Factors relating to the accident were: the environmental conditions (light conditions at dusk and high…May 12, 1997 · N6174N · DestroyedNTSB SEA97LA104Accident · 1 fatalLimited investigationFinal reportCessna T188C · Mitchell, ORThe pilot's failure to maintain adequate airspeed while maneuvering, which led to a stall. A factor contributing to the accident was the lack of adequate altitude to effect a successful stall recovery.May 10, 1997 · N3152J · DestroyedNTSB ATL97LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Jacksonville, FLThe pilot's failure to maintain terrain clearance while on a low pass, leading to propeller damage. A factor was birds in the area.May 8, 1997 · N520SM · Substantial damageNTSB CHI97LA124Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Huron, SDThe pilot's failure to maintain clearance from known transmission lines.May 7, 1997 · N23640 · Substantial damageNTSB MIA97FA152Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · New Smyrna Bch, FLan in flight loss of control for undetermined reasons.May 2, 1997 · N5057F · Substantial damageNTSB ATL97LA067Accident · No injuriesLimited investigationFinal reportHughes 269A · Lake Wales, FLloss of engine power for undetermined reason(s); and the flight instructor's improper flare and improper use of the flight controls, while flaring for an autorotative landing.May 1, 1997 · N37754 · Substantial damageNTSB NYC97LA083Accident · 1 fatalLimited investigationFinal reportPorter Stolp SA-750 · E. Huntingdon, PAwas the pilot's entry into an uncontrolled stall/spin and his inadequate recovery from the maneuver which resulted in collision with terrain. Factors in the accident were the low entry altitude for the maneuver and the pilot's lack of recent flight experience.Apr 30, 1997 · N513EP · DestroyedNTSB LAX97LA173Accident · 2 fatalLimited investigationFinal reportShoaf Christen Eagle II · Half Moon Bay, CAundetermined.Apr 29, 1997 · N61GS · DestroyedNTSB IAD97LA069Accident · Serious injuriesLimited investigationFinal reportJaquish Challenger Spec II · Mansfield, PAinadequate visual lookout by the pilot, which led to an in-flight collision with an electrical wire. Related factors were: low altitude flight by the pilot, and the proximity of the transmission line.Apr 29, 1997 · N9213A · Substantial damageNTSB FTW97LA167Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Hatch, NMThe pilot's failure to maintain clearance from the wires. A factor was the sunglare.Apr 28, 1997 · N7696 · Substantial damageNTSB SEA97FA094Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Klammath Falls, ORThe pilot's failure to set the throttle of his second failed engine to 'Cracked-1/2-Open' as called for in the Engine Failure/Restart checklist, followed by a high-power engine surge. Factors include the pilot's delay in landing for refueling, the pilot…Apr 27, 1997 · N30LL · Substantial damageNTSB CHI97LA114Accident · Serious injuriesLimited investigationFinal reportOlsen Acro Sport II · Monon, INThe loss of engine power for undetermined reasons. Low altitude flight is a contributing factor.Apr 27, 1997 · N52260 · Substantial damageNTSB FTW97TA165Accident · Minor injuriesFinal reportBell 206-L1 · Trinidad, COThe pilot's failure to maintain control of the helicopter due to a loss of tail rotor effectiveness. A factor was the tailwind condition and the pilot's failure to maintain proper airspeed.Apr 23, 1997 · N618DE · Substantial damage