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 BFO89FA048Accident · 4 fatalField investigationFinal reportCessna 172P · Caesars Head, SCFailure of the pilot to maintain sufficient airspeed while flying over rising terrain, which resulted in an inadvertent stall and collision with wooded terrain. Factors related to the accident were: the terrain conditions and failure of the pilot to maintain…Jun 25, 1989 · N53667 · DestroyedNTSB SEA89LA121Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Colfax, WAImproper installation of the cylinder assembly. The terrain was not suitable for a successful forced landing.Jun 24, 1989 · N8974H · Substantial damageNTSB SEA89LA120Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Centralia, WAThe pilot misjudged his clearance over trees, which resulted in an in-flight tail rotor strike with the trees and loss of tail rotor control. The trees were a related factor.Jun 24, 1989 · N1161N · DestroyedNTSB SEA89FA118Accident · 1 fatalField investigationFinal reportColonial C-1 · Bremerton, WAMalfunction of both magnetos due to deterioration of the coils, which resulted in the loss of engine power. Factors related to the accident were: an inadequate airworthiness directive (no calendar time limits), and the lack of suitable terrain (rough/uneven)…Jun 23, 1989 · N260B · DestroyedNTSB FTW89DRD09Accident · No injuriesFinal reportSchweizer G-164A · Bunkie, LAThe loss of the number five cylinder in flight, resulting in a loss of engine RPM. The pilot misjudged the landing flare height due to obscured vision from fire and smoke and the airplane stalled and impacted the ground nose first.Jun 23, 1989 · N602Y · Substantial damageNTSB ATL89LA168Accident · No injuriesLimited investigationFinal reportCessna 172 · Centreville, ALThe student pilot's failure to remove all remaining water from the airplane fuel system during pre-flight inspection which led to a total loss of power.Jun 23, 1989 · N70RS · Substantial damageNTSB SEA89LA116Accident · Minor injuriesLimited investigationFinal reportBell 47G3B2A · Dyer, NVThe pilots poor planning in attempting a hover in undesirable conditions which resulting in the inability to maintain rotor rom. Contributing to the accident was the mountainous terrain and high density alt.Jun 22, 1989 · N59414 · DestroyedNTSB ATL89FA167Accident · Serious injuriesField investigationFinal reportCessna 140 · Conyers, GACarburetor ice and the pilot's improper use of carburetor heat. Carburetor icing condition was a related factor.Jun 22, 1989 · N1875V · Substantial damageNTSB DEN89DTI01Accident · 1 fatalFinal reportPiper PA-25-235 · Conrad, MTThe pilot's failure to see the guy wire in time to avoid colliding with it.Jun 20, 1989 · N7001Z · DestroyedNTSB CHI89DEM03Accident · 2 fatalFinal reportBeneteau Steen Skybolt · Elk Rapids, MIThe pilot's failure to maintain aircraft control while attempting an aerobatic maneuver. Factors related to the were: inadequate altitude and lack of total experience in type of aircraft.Jun 19, 1989 · N199BP · DestroyedNTSB MKC89FA136Accident · 1 fatalField investigationFinal reportNorth American AT-6D · Earle, ARThe pilot's improper planning/decision and over confidence in his flying ability, which resulted in a loss of control, while maneuvering at low altitude. The pilot's inadequate altitude and airpeed were considered to be contributing factors.Jun 17, 1989 · N3931S · DestroyedNTSB CHI89FA114Accident · 2 fatalField investigationFinal reportMcculloch J-2 · Oxford, OHThe failure of the pilot operator to replace the main rotor thrust bearing. The expired service life of the main rotor thrust bearing is a factor in the accident.Jun 17, 1989 · N4354G · DestroyedNTSB BFO89LA045Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Moundsville, WVThe pilot failed to maintian directional control and obstacle clearance while hovering at low altitude. A tail rotor blade struck an obstacle causing an overload separation failure of the blade.Jun 17, 1989 · N2487B · DestroyedNTSB MKC89LA134Accident · No injuriesLimited investigationFinal reportGrumman G164 · Brinkley, ARThe failure of the aircraft engine due to water contamination. The pilot executed a landing in a flooded rice field which did not permit a successful landing.Jun 15, 1989 · N8367K · Substantial damageNTSB SEA89FA111Accident · Serious injuriesField investigationFinal reportOregon Helicopters UH-1L · Baring, WAFatigue failure of the tail rotor 42 degree gear box due to pilot induced overstress. Navy data and FAA type certificate limitations were not adhered to.Jun 14, 1989 · N157LC · DestroyedNTSB MKC89DCA01Accident · 1 fatalFinal reportPiper PA-25-235 · Auxvasse, MOThe pilot-in-command's failure to maintain adequate airspeed, resulting in an inadvertant stall.Jun 14, 1989 · N6579Z · DestroyedNTSB FTW89DPJ06Accident · No injuriesFinal reportPiper PA-18A · Eva, OKThe pilot's failure to maintain visual lookout. A factor was the pilot's limited visual perception due to the ground vehicle.Jun 14, 1989 · N6873B · Substantial damageNTSB ATL89LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Jackson, TNThe separation of the mixture cable from the carburetor. Contributing factor(s) was: inadequate maintenance and inspection of the airplane and the soft terrain encountered during the forced landing.Jun 13, 1989 · N24451 · Substantial damageNTSB SEA89LA110Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Chemult, ORImproper inflight planning/decision by the pilot, which resulted in a sudden altitude deviation, and his delay in initiating remedial action to maintain clearance from the trees. Contributing factors were the downdrafts, high density altitude, the pilot…Jun 12, 1989 · N1365E · DestroyedNTSB SEA89FA104Accident · 1 fatalField investigationFinal reportAnderson BD-5 · Everett, WAInadequate maintenance by the pilot/owner/builder, his operation of the aircraft with a known deficiency, and his failure to maintain adequate airspeed during an emergency descent, which resulted in an inadvertent stall.Jun 11, 1989 · N13AT · DestroyedNTSB DCA89MA058Accident · 11 fatalMajor investigationFinal reportBeech H18 · Waipio Valley, HIThe pilot's improper in-flight planning/decision to maneuver with insufficient altitude over or in a a canyon area. Factors related to the accident were: the terrain conditions and scenic air tour's lack of specific direction to its pilots concerning safety…Jun 11, 1989 · N34AP · DestroyedNTSB NYC89LA147Accident · Minor injuriesLimited investigationFinal reportPiper J-3C-65 · Erma, NJFailure of the pilot to maintain airspeed during a banner pickup.Jun 10, 1989 · N46286 · Substantial damageNTSB MIA89FA173Accident · 2 fatalField investigationFinal reportCessna 170B · Sarasota, FLThe pilot's failure to maintain airspeed while maneuvering to spot cattle for a ground crew.Jun 10, 1989 · N3100B · DestroyedNTSB SEA89LA105Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Skagway, AKThe failure of the pilot to use proper inflight planning to identify wind conditions (downdrafts) during the flight. As a result, the pilot was unable to maintain altitude and the airplane collided with mountainous terrain.Jun 8, 1989 · N7994F · Substantial damageNTSB CHI89DEV06Accident · No injuriesFinal reportHughes 269C · Millersville, ILLoss of rotor RPM for an undetermined reason during a turn to reverse direction while applying agricultural chemicals.Jun 6, 1989 · N7439F · DestroyedNTSB SEA89LA100Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Prineville, ORThe pilots inadequate visual lookout and failure to maintain clearance from obstructions, resulting in the tail rotor impacting a road sign and subsequent loss of anti-torque control.Jun 5, 1989 · N8022Q · Substantial damageNTSB ATL89FA157Accident · 1 fatalField investigationFinal reportCessna 150K · N. Myrtle Beach, SCThe pilot's confusion and diverted attention regarding the multiple banner release system in the cockpit resulting in an inadvertent stall/spin into the terrain from a low altitude. Also causal was the pilot attempting the abrupt maneuver at the low airspeed…Jun 3, 1989 · N6367G · DestroyedNTSB ATL89DMG05Accident · 1 fatalFinal reportBloodworth Pitts Special S-1C · Townsville, NCInadequate altitude for the pilot to recover from a spin. A contributing factor was his ostentatious display.Jun 3, 1989 · N1769 · DestroyedNTSB SEA89LA098Accident · Serious injuriesLimited investigationFinal reportBell 47G-2 · Buena, WAThe pilot's failure to maintain an adequate visual lookout and clearance to avoid the power lines.Jun 2, 1989 · N41721 · DestroyedNTSB MKC89LA123Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Poplar Bluff, MOThe pilot in command misjudged the clearance of the aircraft's vertical stabilizer from the power lines.Jun 2, 1989 · N3159W · Substantial damageNTSB BFO89DIG01Accident · Minor injuriesFinal reportPiper PA-25-235 · Preston, MDPilot's failure to maintain adequate clearance with the wheat crop as he passed under the powerline during an aerial application swath run.Jun 2, 1989 · N4497Y · Substantial damageNTSB FTW89DRA06Accident · No injuriesFinal reportGrumman G-164B · Lissie, TXA bird strike which resulted in foreign object damage to the engine compressor. A berm and the lack of suitable terrain for a forced landing were contributing factors.Jun 1, 1989 · N6822Q · Substantial damageNTSB NYC89LA141Accident · No injuriesLimited investigationFinal reportBell 206-L · Wading River, NYThe pilot's failure to control the rate of descent which resulted in a hard landing. Contributing to the accident was a power loss due to a compressor failure.May 31, 1989 · N501RS · Substantial damageNTSB MIA89FA164Accident · Serious injuriesField investigationFinal reportAir Tractor AT-401 · Clarksdale, MSThe pilot failed to maintain airspeed resulting in the airplane stalling and descending out of control.May 30, 1989 · N1012H · DestroyedNTSB ATL89LA154Accident · 1 fatalLimited investigationFinal reportBoeing E75 (PT-13D) · Jacksonville, NCThe pilot encountered an accelerated stall during an abrupt maneuver, lost control of the airplane and did not have sufficient altitude to recover from the ensuing spin prior to colliding with the ground.May 30, 1989 · N5325N · DestroyedNTSB FTW89DRD05Accident · Minor injuriesFinal reportGrumman G-164A · Gueydan, LAVisual lookout was not maintained by the pilot in command, which resulted in the collision with a power transmission line during a swath run.May 29, 1989 · N5267 · DestroyedNTSB ATL89DKG03Accident · No injuriesFinal reportRotorway Exec · Roswell, GAThe pilots improper use of the tail rotor controls while in a hover. Adding to this was the pilots total lack of experience operating helicopters.May 29, 1989 · N7043T · Substantial damageNTSB MKC89FA117Accident · Serious injuriesField investigationFinal reportCessna 172M · Oakland, ARPilot electing to buzz persons on the lake at low altitude and colliding with power lines.May 28, 1989 · N9646H · Substantial damageNTSB MKC89LA114Accident · No injuriesLimited investigationFinal reportCessna 188 · Table Rock, NEThe catastrophic failure of the internal engine components due to oil starvation. Contributing to the severity of the accident was the rough terrain the pilot was forced to land on.May 26, 1989 · N9084R · Substantial damageNTSB MIA89FA154Accident · Minor injuriesField investigationFinal reportCessna 152 · Fort Pierce, FLFailure of the student pilot to maintain airspeed which resulted in an inadvertent stall. Contributing factors were: the weather conditions (smoke & haze), the student becoming lost, her lack of total experience, and her inability to understand ATC…May 24, 1989 · N714UQ · Substantial damageNTSB FTW89DRD03Accident · 1 fatalFinal reportSchweizer G-164A · Maxie, LAFailure of the pilot to maintain clearance from the trees. A factor related to the accident was: the presence of trees near the field where fertilizer was to be dispensed.May 23, 1989 · N48467 · DestroyedNTSB DEN89DTK01Accident · 1 fatalFinal reportPiper PA-36-300 · Agar, SDThe pilot's failure to maintain an adequate clearance with the powerlines. The powerline is considered to be a contributing factor to the accident.May 23, 1989 · N82644 · DestroyedNTSB CHI89MA095Accident · 3 fatalMajor investigationFinal reportDouglas DC3C-S13CG · Waterman, ILThe pilot-in-command (PIC) failed to provide adequate supervision while training the copilot and allowed the aircraft to enter a stall/spin, then did not provide adequate remedial action to properly recover from the spin. Factors related to the accident were:…May 22, 1989 · N47CE · DestroyedNTSB BFO89FA033Accident · 2 fatalField investigationFinal reportBell UH-1B · Oldtown, MDFailure of the pilot to see-and-avoid the obstruction (inadequate visual lookout). Factors related to the accident were: the obstruction (static wires), and the lack of visual cues for the pilot to detect the wires.May 22, 1989 · N508SC · DestroyedNTSB ATL89DKJ03Accident · No injuriesFinal reportGrumman G-164A · Loxley, ALThe loss of engine power due to carburetor ice, and the pilot's improper use of carburetor heat.May 22, 1989 · N8881H · Substantial damageNTSB SEA89LA091Accident · Minor injuriesLimited investigationFinal reportPazmany PL-4A · Concrete, WAAn improper low pass and clearance with trees misjudged by pilot.May 21, 1989 · N445CB · DestroyedNTSB LAX89LA197Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS350D · Waialae Falls, HIImproper maintenance/adjustment of the engine fuel control unit by company maintenance personnel, which resulted in a slight loss of engine power, and failure of the pilot to maintain rotor RPM, while turning and taking off from a hover with a relatively…May 21, 1989 · N6003S · Substantial damageNTSB FTW89LA095Accident · Serious injuriesLimited investigationFinal reportAeronca 65-TAC · Pryor, OKThe failure of the pilot to maintain airspeed during a low pass over the airport after pulling up to clear wires which resulted in a stall.May 21, 1989 · N39304 · Substantial damageNTSB ATL89FA150Accident · 2 fatalField investigationFinal reportTaylorcraft BC12-D · Jamestown, TNThe pilot failed to maintain adequate airspeed to avoid an inadvertent stall. The stall occurred at an altitude which precluded recovery prior to ground impact. Contributing to the accident was the pilot's lack of proficiency in the airplane.May 21, 1989 · N5003M · Substantial damageNTSB FTW89DQG03Accident · Minor injuriesFinal reportWeatherly 201B · Miami, TXThe pilot's failure to maintain adequate clearance from a known obstacle during agricultural spray flight operations,May 20, 1989 · N1271W · Substantial damage