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 FTW94LA281Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Wheatley, ARTotal loss of engine power due to a cracked cylinder. A factor was the lack of suitable terrain for the forced landing.Aug 27, 1994 · N148RA · Substantial damageNTSB ATL94FA166Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-34R · Maylene, ALThe pilot exceeding the design stress limits of the aircraft, resulting in an overload failure of the wing spar, and separation of the left wing from the aircraft. A factor was the pilot's lack of total flying experience in this model of aircraft.Aug 27, 1994 · N1132S · DestroyedNTSB SEA94FA225Accident · 2 fatalField investigationFinal reportCessna 172K · Laramie, WYThe pilot's failure to maintain clearance from terrain. Downdraft wind on the lee side of the ridgeline was a factor.Aug 26, 1994 · N79444 · DestroyedNTSB CHI94LA300Accident · No injuriesLimited investigationFinal reportBell 47 MARK-6 · Lake City, MNThe loss of lift resulting from the pilot's failure to maintain rotor RPM during an aerial application turn. The power available from the engine was less than that required to regain the lost rotor RPM.Aug 26, 1994 · N19JM · Substantial damageNTSB SEA94FA221Accident · 1 fatalField investigationFinal reportChampion 7FC · Tacoma, WAPilot incapacitation due to a heart attack.Aug 24, 1994 · N7598B · Substantial damageNTSB ATL94FA162Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Byromville, GAThe pilot's failure to maintain aircraft control, resulting in an inadvertent stall.Aug 24, 1994 · N7776D · DestroyedNTSB CHI94LA292Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Clifton, ILthe pilots failure to keep visual contact with and to avoid unmarked powerlines adjacent to the crop field he was spraying.Aug 23, 1994 · N8971H · DestroyedNTSB ATL94LA159Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Columbia, NCThe failure of the aircraft carburetor that resulted in a total loss of engine power.Aug 21, 1994 · N8819L · Substantial damageNTSB ANC94LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Northway, AKThe pilot's inadequate evaluation of the weather and his failure to maintain visual lookout during the maneuver. Factors were the low ceilings and obscuration.Aug 21, 1994 · N31670 · Substantial damageNTSB BFO94LA141Accident · 1 fatalLimited investigationFinal reportLafrance V-Witt W2 · Wilmington, OHLoss of engine power for an undetermined reason, and failure of the pilot to maintain adequate airspeed while attempting a maneuver for an emergency landing, which resulted in a stall and collision with terrain. A factor related to the accident was: the lack…Aug 20, 1994 · N63VW · DestroyedNTSB FTW94LA268Accident · No injuriesLimited investigationFinal reportCessna 150M · Glen Rose, TXThe pilot's failure to maintain flying speed and the passenger's interference with the controls during the attempted recovery.Aug 13, 1994 · N704RK · Substantial damageNTSB CHI94FA282Accident · 2 fatalField investigationFinal reportChampion 7KCAB · Humphrey, NEthe pilot's failure to maintain control of the airplane. A factor associated with the accident is the pilot's buzzing of the passenger's brother-in-law's house.Aug 13, 1994 · N7565F · DestroyedNTSB FTW94LA270Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Shreveport, LAThe pilot's incapacitation due to a heart attack.Aug 12, 1994 · N48664 · DestroyedNTSB BFO94FA134Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Grand Lake Strm, METhe pilot attempted a maneuver at an altitude insufficient for recovery. A factor in the accident was pilot physical impairment due to alcohol consumption.Aug 12, 1994 · N8588Y · DestroyedNTSB ANC94FA105Accident · 3 fatalField investigationFinal reportDe Havilland DHC-2 · Port Alsworth, AKImproper in-flight planning/decision by the pilot, and his failure to remain clear of mountainous terrain. The box/blind canyon and proximity of mountainous terrain were related factors.Aug 12, 1994 · N17394 · DestroyedNTSB SEA94FA208Accident · 2 fatalField investigationFinal reportPiper PA-22 · Butte Falls, ORThe pilot-in-command's failure to maintain adequate altitude and clearance from trees while maneuvering.Aug 11, 1994 · N3555A · DestroyedNTSB LAX94LA313Accident · No injuriesLimited investigationFinal reportSchweizer G-164-A · Laton, CAfailure of the No.7 cylinder for an unspecified reason.Aug 11, 1994 · N699Y · Substantial damageNTSB FTW94LA267Accident · No injuriesLimited investigationFinal reportWeatherly 201C · Pampa, TXThe pilot's decision to takeoff from unsuitable terrain following the forced landing. A factor was fuel starvation induced power loss resultant from the pilot's failure to select the proper fuel tank.Aug 11, 1994 · N9075W · Substantial damageNTSB CHI94LA276Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Sargeant, MNthe pilot's failure to maintain clearance from a transmission wire during an agricultural spray run. A factor in the accident is the transmission wire.Aug 11, 1994 · N64292 · Substantial damageNTSB ATL94LA154Accident · Minor injuriesLimited investigationFinal reportAyres S2R · Vienna, GAThe loss of engine power because of a fractured cylinder.Aug 11, 1994 · N8914Q · Substantial damageNTSB FTW94LA266Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Matagorda, TXA power loss due to cracked engine cylinder. A factor was the lack of suitable terrain for the forced landing.Aug 10, 1994 · N8251K · DestroyedNTSB ANC94FA104Accident · 2 fatalField investigationFinal reportTaylorcraft BC12-D · Eagle River, AKThe pilot's failure to maintain airspeed and operating at an inadequate altitude for recovery.Aug 10, 1994 · N95058 · DestroyedNTSB ANC94LA103Accident · No injuriesLimited investigationFinal reportBell 206B · Chuit River, AKThe pilot's failure to maintain tail rotor effectiveness during hover.Aug 9, 1994 · N4604Y · Substantial damageNTSB NYC94LA155Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-4A · Cannan, NHThe pilot's failure to maintain airspeed which resulted in an inadvertent stall and inflight collision with terrain. Factors were a loss of lift and the pilot's in-flight decision to maneuver too close to the ridge.Aug 7, 1994 · N245JD · Substantial damageNTSB FTW94FA262Accident · 1 fatalField investigationFinal reportGrumman G-164B · Henderson, LAThe pilot's failure to maintain clearance from a known object.Aug 5, 1994 · N6804Q · DestroyedNTSB MIA94LA191Accident · No injuriesLimited investigationFinal reportAyres S2R · Ruleville, MSThe pilot-in-command's misjudgement of his altitude while maneuvering on an aerial application/swath run, resulting in an in-flight collision with terrain and subsequent nose over.Aug 4, 1994 · N4007P · DestroyedNTSB FTW94LA271Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Clint, TXThe power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Aug 4, 1994 · N4890X · Substantial damageNTSB ANC94LA096Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Whittier, AKThe pilot's failure to maintain rotor RPM. Factors were the ravine and the tailwind.Aug 2, 1994 · N2622M · Substantial damageNTSB FTW94LA257Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Bosco, LAThe pilot's failure to maintain clearance with the telephone pole.Aug 1, 1994 · N9152C · DestroyedNTSB FTW94LA253Accident · No injuriesLimited investigationFinal reportHughes 269A · Leander, LAInadequate maintenance and a fatigue failure of a #1 cylinder connecting rod bolt. A factor was the lack of suitable terrain available to the pilot for a forced landing.Aug 1, 1994 · N9062G · Substantial damageNTSB FTW94FA258Accident · 1 fatalField investigationFinal reportAir Tractor AT-301 · Hunter, ARInadvertent stall due to pilot's failure to maintain airspeed. A factor was the pilot's over confidence in his personal ability.Aug 1, 1994 · N23358 · Substantial damageNTSB LAX94LA303Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Scottsdale, AZThe pilot's failure to refuel appropriately, the altitude and airspeed at the time the engine stoppage occurred were factors in the accident.Jul 30, 1994 · N6749D · Substantial damageNTSB SEA94LA200Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Connell, WAThe pilot's failure to maintain airspeed while conducting aerial application activities.Jul 29, 1994 · N3649Y · DestroyedNTSB MIA94LA185Accident · No injuriesLimited investigationFinal reportCessna 152 · Bunnell, FLThe pilot-in-command's improper use of carburetor heat. The carburetor icing conditions were a factor.Jul 27, 1994 · N68165 · Substantial damageNTSB FTW94LA248Accident · Serious injuriesLimited investigationFinal reportScorpion 133 · Fredricksburg, TXThe pilot's inadequate compensation for wind conditions. Factors were the gusty wind and the non-certificated pilot's inadequate training.Jul 25, 1994 · N845H · Substantial damageNTSB SEA94FA194Accident · 2 fatalField investigationFinal reportHughes 369HS · Seaside, ORInflight collision with terrain for undetermined reasons.Jul 24, 1994 · N7771F · DestroyedNTSB SEA94FA190Accident · 1 fatalField investigationFinal reportBell 206B III · Syracuse, UTUndeterminedJul 24, 1994 · N820CW · DestroyedNTSB LAX94LA297Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Murphy Springs, IDThe pilot's improper in-flight decision to maneuver in a canyon at such low altitude that he could not out climb the adjacent rising terrain.Jul 24, 1994 · N51AR · Substantial damageNTSB CHI94LA241Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Eckelson, NDthe pilot's failure to maintain clearance from a transmission wire. A factor associated with the accident is the transmission wire.Jul 23, 1994 · N7301Y · Substantial damageNTSB FTW94FA241Accident · 1 fatalField investigationFinal reportSchweizer G-164B · Foules, LAThe pilot's failure to maintain obstacle clearance.Jul 21, 1994 · N6617Q · DestroyedNTSB SEA94LA179Accident · Serious injuriesLimited investigationFinal reportKaman HH43F · John Day, ORFailure of a turbine compressor wheel. The lack of suitable terrain for an autorotation/forced landing was a factor.Jul 19, 1994 · N324WN · Substantial damageNTSB CHI94LA233Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Tribune, KSthe pilot's failure to maintain clearance above the corn crop during the swath run.Jul 19, 1994 · N6580Z · Substantial damageNTSB ATL94LA142Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Samson, ALThe failure of the aileron torque tube bolt from fatigue, which resulted in an inflight loss of aircraft control and collision with terrain.Jul 18, 1994 · N4242X · Substantial damageNTSB SEA94LA183Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Pilot Rock, ORDirectional control was not maintained for undetermined reasons.Jul 17, 1994 · N9645A · Substantial damageNTSB ANC94LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Fairbanks, AKThe failure of the pilot to maintain the appropriate airspeed. A factor in the accident was the gusty wind.Jul 17, 1994 · N7883D · Substantial damageNTSB ATL94LA140Accident · Minor injuriesLimited investigationFinal reportCessna A188A · Cochran, GAThe pilot's failure to maintain airspeed and clearance from trees during an aerial application maneuver. Factors were the trees at the perimeter of the field, and the gusting tail wind conditions at the time of the accident.Jul 16, 1994 · N5657J · Substantial damageNTSB CHI94LA232Accident · No injuriesLimited investigationFinal reportCessna 180 · Battle Lake, MNloss of engine power due to fuel exhaustion which resulted from inaccurate fuel consumption calculations. A factor related to the accident was the inaccurately placarded fuel tanks.Jul 15, 1994 · N333QB · Substantial damageNTSB LAX94FA282Accident · 1 fatalField investigationFinal reportCessna 172M · Running Springs, CAthe flying pilot's operation of the aircraft at an altitude that did not provide sufficient terrain clearance necessary to recover from an inadvertent, pilot-induced stall.Jul 12, 1994 · N64193 · DestroyedNTSB FTW94GA232Accident · 3 fatalFinal reportBell 206L-3 · Mimbres, NMThe pilot's improper decision to attempt to hover out of ground effect under adverse conditions while exceeding the maximum allowable weight for that maneuver. Factors in the accident were: high density altitude and the tailwind.Jul 12, 1994 · N3178B · DestroyedNTSB ATL94FA137Accident · 2 fatalField investigationFinal reportCessna 150L · Greenville, TNThe failure of the pilot to maintain sufficient terrain clearance, and his inadvertent stall at low altitude.Jul 12, 1994 · N18714 · Substantial damage