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 LAX94LA241Accident · No injuriesLimited investigationFinal reportHughes 369D · Kaneohe, HIthe operator's and pilot's failure to ensure that the cargo net containing empty paper bags was sufficiently ballasted to prevent it from flying up into the tail rotor.Jun 7, 1994 · N4943T · Substantial damageNTSB ATL94LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Flowery Branch, GAThe maintenance personnel's failure to properly secure the throttle linkage assembly that resulted in a reduction in engine power.Jun 7, 1994 · N3882L · Substantial damageNTSB SEA94LA138Accident · No injuriesLimited investigationFinal reportSiai-Marchetti SF.260B · Prospect, ORThe fracture of a connecting rod. Factors include no suitable forced landing site, and a fence and irrigation system in the field where the forced landing took place.Jun 6, 1994 · N943TA · Substantial damageNTSB FTW94LA187Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Carlisle, ARThe loss of engine power for undetermined reason. A factor ws the lack of suitable terrain at the pilot's disposal for the forced landing.Jun 6, 1994 · N8363K · DestroyedNTSB LAX94LA239Accident · No injuriesLimited investigationFinal reportEnstrom 280C · California City, CAthe pilot's inadequate compensation for the gusty wind conditions and his subsequent failure to maintain control of the helicopter.Jun 5, 1994 · N123MT · Substantial damageNTSB FTW94LA197Accident · No injuriesLimited investigationFinal reportGlasflugel Standard Libelle · Wellington, COWas the pilot's improper compensation for the crosswind. A factor was the crosswind.Jun 5, 1994 · N3992 · Substantial damageNTSB CHI94LA193Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Levant, KSThe pilot's inadequate evaluation of weather conditions associated with known thunderstorm activity. Factors were the thunderstorm and downdrafts.Jun 5, 1994 · N2344T · DestroyedNTSB BFO94LA090Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA318C · Rassellas, PAThe pilot's inadequate preflight inspection, which resulted in fuel exhaustion and the lost of engine power. Factors in the accident were the pilot operating the helicopter with known deficiencies in equipment and no suitable terrain available for landing.Jun 5, 1994 · N4682 · Substantial damageNTSB CHI94LA189Accident · 1 fatalLimited investigationFinal reportWaco UPF-7 · Good Hope, ILFailure of the pilot to maintain control of the aircraft, while maneuvering. A factor related to the accident was: the pilot's impairment due to use of a prescription drug that was not approved for use while flying.Jun 4, 1994 · N29952 · DestroyedNTSB ANC94LA066Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Naknek, AKThe pilot's failure to maintain airspeed above the stall speed during maneuvering flight.Jun 4, 1994 · N84310 · Substantial damageNTSB SEA94LA136Accident · No injuriesLimited investigationFinal reportAyres S2R · Burley, IDA loose carburetor. Factors include no suitable terrain for making a forced landing, and trees in the field where the forced landing took place.Jun 2, 1994 · N8542 · Substantial damageNTSB LAX94LA235Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Chino, CAloss of aircraft control due to the pilot's failure to correctly configure the hydraulic system prior to takeoff.Jun 2, 1994 · N14412 · Substantial damageNTSB CHI94DEM01Accident · No injuriesFinal reportGrumman G-164A · Muskegon, MIThe propeller not being able to be feathered by the pilot, inadequate altitude for a successful forced landing, and the failure of the combustion section. A factor associated with this accident was the stall/mush encountered by the pilot due to the…Jun 2, 1994 · N8939H · Substantial damageNTSB BFO94LA083Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-C · Fairfield, PAThe pilot-in-command's failure to maintain control of the airplane during the maneuver.Jun 1, 1994 · N166W · Substantial damageNTSB NYC94LA097Accident · Serious injuriesLimited investigationFinal reportBell 47G3 Soloy · Friendsville, MDThe partial failure of the turbine engine for undetermined reasons, during an agriculture maneuver at low altitude, over terrain unsuitable for an autorotation.May 31, 1994 · N121CD · DestroyedNTSB LAX94LA231Accident · 1 fatalLimited investigationFinal reportCessna 172N · Roosevelt, AZthe pilot's selection of an inadequate terrain clearance altitude while maneuvering over a lake. A factor in the accident was the calm glassy water conditions which may have affected the pilot's perception of his actual height above the water.May 31, 1994 · N6305J · DestroyedNTSB NYC94LA098Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Burt, NYThe pilot's failure to maintain airspeed, resulting in an inadvertent stall and collision with trees.May 30, 1994 · N8688L · Substantial damageNTSB SEA94LA133Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Lookout Pass, IDPoor in-flight planning. Factors include cloudy weather.May 29, 1994 · N30608 · DestroyedNTSB LAX94LA226Accident · 1 fatalLimited investigationFinal reportParker Rotorway Exec 90 · Fallbrook, CAThe pilot's improper preflight and miscalculation of remaining fuel, which resulted in fuel exhaustion, and improper autorotation, due to inadequate transition/upgrade training and lack of familiarity with helicopters.May 29, 1994 · N78435 · DestroyedNTSB SEA94LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260 · Rexburg, IDEngine failure after loss of oil due to a ruptured oil line.May 28, 1994 · N4842Y · Substantial damageNTSB LAX94LA225Accident · Serious injuriesLimited investigationFinal reportStaudacher 300S · Chandler, AZThe operation of the engine at an RPM setting that exceeded the original design specifications and resulted in the failure of the no. 5 connecting rod bearing.May 28, 1994 · N791S · Substantial damageNTSB FTW94FA183Accident · 2 fatalField investigationFinal reportCessna 320E · Battle Mountain, NVThe pilot's failure to maintain terrain clearance while maneuvering during a low level aerial mapping flight. A factor was the box canyon.May 28, 1994 · N3472Q · DestroyedNTSB BFO94FA082Accident · No injuriesField investigationFinal reportCessna A150L · Leonardtown, MDImproper use of carburetor heat by the pilot, which resulted in loss of engine power due to carburetor ice. A contributing factor was the presence of carburetor icing conditions.May 28, 1994 · N5964J · DestroyedNTSB SEA94LA132Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Nashua, MTAirspeed was not maintained. Factors include an inadvertent stall.May 27, 1994 · N3960M · Substantial damageNTSB SEA94LA128Accident · Serious injuriesLimited investigationFinal reportBell 204B · Libby, MTThe fatigue fracture of the 42 degree gear box input pinion. Factors include unsuitable, mountainous/hilly terrain.May 27, 1994 · N911SW · Substantial damageNTSB LAX94LA240Accident · No injuriesLimited investigationFinal reportCessna 150M · Lancaster, CAthe flight instructor's failure to maintain an adequate airspeed margin while maneuvering at minimum controllable airspeed. A factor in the accident was the instructor's selection of an inadequate above ground altitude to begin the maneuver.May 27, 1994 · N63105 · Substantial damageNTSB MIA94LA154Accident · No injuriesLimited investigationFinal reportPitts S2B · Keystone Height, FLThe pilot-in-command's exceeding of the design limitations of the airplane.May 26, 1994 · N61PS · Substantial damageNTSB NYC94LA094Accident · 1 fatalLimited investigationFinal reportBradford Seahawk · Richmond, KYwas the loss of engine power for undetermined reasons, and the collision with an object during the subsequent forced landing.May 25, 1994 · N65TB · DestroyedNTSB FTW94LA177Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Casscoe, ARThe inadvertent stall and power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.May 24, 1994 · N48386 · DestroyedNTSB CHI94DTK01Accident · No injuriesFinal reportWeatherly 620 · Ridgeview, SDfuel starvation due to the pilot's improper fuel tank selection.May 24, 1994 · N5296W · Substantial damageNTSB MIA94FA148Accident · 2 fatalField investigationFinal reportCessna A150M · Indiantown, FLThe pilot's impairment of judgment and performance due to alcohol and drugs, which led to his improper planning/decision, and his failure to maintain adequate airspeed during a maneuver.May 23, 1994 · N9856J · DestroyedNTSB SEA94LA127Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Princeton, IDInadvertent retarding of throttle by pilot. Factors include trees.May 21, 1994 · N50WS · DestroyedNTSB SEA94FA123Accident · 2 fatalField investigationFinal reportBellanca 8GCBC · Challis, IDThe pilot's failure to maintain clearance from terrain.May 21, 1994 · N86980 · Substantial damageNTSB LAX94LA222Accident · No injuriesLimited investigationFinal reportHillberg EH-101 · Corona, CAthe pilot's loss of control of the helicopter while hovering downwind. A lack of test-flight data to establish the aircraft's performance limitations was a factor in the accident.May 21, 1994 · N10TE · Substantial damageNTSB FTW94LA174Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Stuttgart, ARWas the pilots failure to maintain terrain clearance.May 20, 1994 · N9678 · Substantial damageNTSB CHI94LA166Accident · Serious injuriesLimited investigationFinal reportGrumman G-164 · Hillsboro, NDthe pilot's failure to maintain clearance from a tree.May 20, 1994 · N551Y · DestroyedNTSB ATL94LA104Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Memphis, TNThe pilot's failure to maintain clearance from the earthen dike during the swath run.May 20, 1994 · N6816Q · Substantial damageNTSB FTW94LA166Accident · No injuriesLimited investigationFinal reportBell 47G · Sulphur, OKThe loss of engine power due to the failure of an engine accessory oil pump gear. A factor was the lack of suitable terrain for the autorotation.May 18, 1994 · N933B · Substantial damageNTSB MIA94LA143Accident · Minor injuriesLimited investigationFinal reportAerosport Scamp WT-B1 · Lake Wales, FLThe pilot-in-command's failure to maintain airspeed (vs) while maneuvering resulting in an in-flight loss of control (inadvertent stall) and subsequent in-flight collision with terrain.May 17, 1994 · N8490 · DestroyedNTSB FTW94LA164Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Monticello, ARThe loss of engine power due to the number 2 cylinder cracking. A factor was the lack of suitable terrain for the forced landing.May 17, 1994 · N4080X · Substantial damageNTSB FTW94FA156Accident · 2 fatalField investigationFinal reportBoeing E75N1 · Peyton, COThe pilot's performance of aerobatic maneuvers at an altitude inadequate for recovery.May 14, 1994 · N631E · DestroyedNTSB CHI94LA159Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Burlington, IAfuel exhaustion resulting from the failure of the pilot to refuel en route.May 14, 1994 · N6737B · DestroyedNTSB FTW94FA155Accident · 2 fatalField investigationFinal reportCessna 172P · Arlington, TXThe pilot's loss of aircraft control for an undetermined reason, while maneuvering in the vicinity of the airport.May 13, 1994 · N98723 · DestroyedNTSB CHI94LA161Accident · No injuriesLimited investigationFinal reportBell 206B · Winnebago, ILa wire strike due to failure to maintain proper altitude, and improper visual lookout by the pilot-in-command.May 12, 1994 · N49585 · Substantial damageNTSB LAX94LA213Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Gridley, CAa loss of engine power due to a cracked engine cylinder head.May 8, 1994 · N3629E · Substantial damageNTSB SEA94LA116Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Dayton, WATotal failure of the connecting rod.May 7, 1994 · N5646X · Substantial damageNTSB MIA94LA132Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Port Saint Joe, FLThe failure of the pilot to maintain airspeed resulting in an inadvertent stall. The low altitude at the time of the stall was a factor.May 7, 1994 · N704LZ · DestroyedNTSB FTW94FA149Accident · 2 fatalField investigationFinal reportRobl RV4 · Elbert, COAn inadvertent stall spin. A factor was the pilot's performance of aerobatic maneuvers at an inadequate altitude.May 7, 1994 · N88LG · DestroyedNTSB CHI94LA162Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Alexandria, NEThe pilot's failure to maintain clearance with wires.May 4, 1994 · N7368 · Substantial damageNTSB LAX94LA208Accident · No injuriesLimited investigationFinal reportBell UH-1L · Pleasant Grove, CAthe pilot's failure to see and avoid the power lines due to sun glare from the rising sun at dawn.May 2, 1994 · N204RW · Destroyed