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 ATL94LA026Accident · No injuriesLimited investigationFinal reportCessna 150 · Griffin, GAFuel starvation caused by foreign matter blockage of the fuel tank vent system.Dec 4, 1993 · N4092J · Substantial damageNTSB CHI94LA043Accident · Serious injuriesLimited investigationFinal reportCleveland Piel Emeraude CP-304 · Warrensburg, MOthe intentional entry of a stall/spin by the student pilot.Dec 2, 1993 · N7631C · Substantial damageNTSB ATL94LA025Accident · Minor injuriesLimited investigationFinal reportSikorsky H34-G · Walterboro, SCThe seizure of the aircraft throttle to engine linkage for unknown reasons.Dec 1, 1993 · N8503J · Substantial damageNTSB MIA94FA031Accident · 1 fatalField investigationFinal reportMooney M20E · Jacksonville, FLFailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall. A factor related to the accident was: the lack of altitude for recovery from a stall.Nov 30, 1993 · N9241V · Substantial damageNTSB MIA94FA030Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Daytona Beach, FLLoss of aircraft control for an undetermined reason.Nov 30, 1993 · N43079 · DestroyedNTSB MIA94LA029Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Moore Haven, FLFailure of the pilot-in-command to maintain aircraft control following loss of engine power for undetermined reasons.Nov 26, 1993 · N130HA · Substantial damageNTSB LAX94LA057Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Buckeye, AZA loss of engine power due to fuel system contamination. A factor in the accident was the soft terrain in the landing area.Nov 26, 1993 · N50412 · Substantial damageNTSB LAX94FA058Accident · 3 fatalField investigationFinal reportSiai-Marchetti F-260 · Santa Monica, CAthe dual student pilot's failure to maintain minimum air speed in flight which resulted in an inadvertent stall/spin. Contributing to the accident was the improper weight and balance, inadequate altitude, and inadequate supervision.Nov 26, 1993 · N126MJ · DestroyedNTSB MIA94LA026Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Labelle, FLThe pilot-in-command exceeding the structural limits of the airplane's design limits by in-flight over-stress that resulted in damage to the gear extension system, fuselage and control surfaces.Nov 21, 1993 · N5755P · Substantial damageNTSB LAX94LA066Accident · No injuriesLimited investigationFinal reportYakovlev YAK-55M · Greenfield, CAUndetermined.Nov 20, 1993 · N7090L · Substantial damageNTSB LAX94LA054Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Salinas, CAa fatigue failure of the torsion-tension bar pin due to fretting corrosion. A factor in this accident was an inadequate quality of material utilized in the manufacture of the pin.Nov 20, 1993 · N161HA · Substantial damageNTSB SEA94LA036Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Pasco, WAThe pilot in command's failure to maintain clearance with the irrigation sprinkler system.Nov 18, 1993 · N8818Q · DestroyedNTSB NYC94FA027Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Kinnelon, NJThe loss of engine power for undetermined reasons.Nov 18, 1993 · N43791 · DestroyedNTSB FTW94FA036Accident · 2 fatalField investigationFinal reportCessna 152 · Guthrie, OKWas the pilot-in-command continued VFR flight into IMC. A factor was fog.Nov 18, 1993 · N45968 · Substantial damageNTSB SEA94LA246Accident · 2 fatalLimited investigationFinal reportFlake Talon XP · Estacada, ORFailure of the pilot to maintain sufficient altitude and/or clearance from mountainous terrain. Factors relating to the accident were: the terrain condition and flight into an area with adverse weather and unfavorable winds.Nov 14, 1993 · UNREG · Substantial damageNTSB SEA94LA031Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Kirkland, WAThe pilot in command's failure to maintain clearance with the tree. A factor contributing to the accident was the pilot in command's ostentatious display.Nov 13, 1993 · N2446J · DestroyedNTSB LAX94LA043Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Salinas, CAThe pilot's improper handling of the helicopter which resulted in overloading of the rotor system in a maneuvering turn during aerial application of chemical, and subsequent failure of the main rotor paddle assembly.Nov 13, 1993 · N149HA · DestroyedNTSB SEA94LA030Accident · Minor injuriesLimited investigationFinal reportHawkins & Powers UH-1B · North Bend, WATotal failure of the intermediate gearbox. The lack of suitable terrain for an autorotation was a factor.Nov 12, 1993 · N91NW · Substantial damageNTSB LAX94FA048Accident · 4 fatalField investigationFinal reportBeech V-35 · Shaver Lake, CAAn in-flight breakup of the airplane following the pilot's continued VFR flight into IMC conditions during which directional control of the airplane was not maintained, and the design limits of the airplane were exceeded. The pilot's inadequate evaluation of…Nov 12, 1993 · N630AW · DestroyedNTSB BFO94FA005Accident · 2 fatalField investigationFinal reportCessna 152 · Walkersville, MDImproper planning/decision by the instructor pilot (CFI) by teaching stalls and slow flight to a pre-solo student on a dark night, and the instructor's failure to maintain (or regain) control of the airplane, due to spatial disorientation. Factor's related to…Nov 11, 1993 · N47456 · DestroyedNTSB FTW94FA031Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Longview, TXPoor judgment of the pilot due to impairment from consumption of alcohol and use of a drug (marijuana), and his failure to correct a descent, while maneuvering at low altitude. A factor related to the accident was: the pilot's psychological condition.Nov 10, 1993 · N6651P · DestroyedNTSB CHI94LA034Accident · 1 fatalLimited investigationFinal reportCessna 175 · Hot Springs, SDThe failure of the pilots to maintain sufficient altitude to ensure terrain clearance. Factors which contributed to the accident were: the dark night and rising terrain.Nov 10, 1993 · N7112M · Substantial damageNTSB SEA94LA029Accident · No injuriesLimited investigationFinal reportBell 47G3B2 · Toledo, WATransmission shear bolts failed causing a loss of power to the rotor system, and the pilot encountered unsuitable terrain during his autorotation attempt.Nov 9, 1993 · N8169J · Substantial damageNTSB MIA94LA016Accident · Minor injuriesLimited investigationFinal reportLovern Pitts S1C · Miami, FLInadequate preflight by the pilot-in-command resulting in the total loss of engine power due to fuel exhaustion.Nov 7, 1993 · N55SR · Substantial damageNTSB LAX94LA037Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Sacramento, CAImproper remedial action by the student pilot. Lack of total experience is a factor.Nov 6, 1993 · N803EH · Substantial damageNTSB FTW94FA025Accident · 2 fatalField investigationFinal reportCessna 152 · Van Horn, TXWas the pilot's attempt to perform aerobatics at low altitude and the inadvertent stall. A factor was the pilot's ostentatious display.Nov 6, 1993 · N4674L · DestroyedNTSB LAX94LA033Accident · No injuriesLimited investigationFinal reportRobinson R22A · Santa Rosa, CAthe separation of the tail rotor due to a collision with a mylar balloon and the subsequent hard landing during an autorotation. A factor in the accident was the dark night lighting conditions which limited the pilot's ability to see and avoid the balloon.Oct 31, 1993 · N8452Z · Substantial damageNTSB FTW94FA023Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Saratoga, ARThe pilot-in-command's performance of aerobatics at an altitude where it was not possible to maintain clearance.Oct 30, 1993 · N130KS · Substantial damageNTSB FTW94LA021Accident · 1 fatalLimited investigationFinal reportBell 206B · W. Cameron 240The pilot's failure to maintain proper altitude while maneuvering. Factors were his continued flight into known adverse weather and his self-induced pressure to complete the flight.Oct 29, 1993 · N360S · DestroyedNTSB ATL94FA010Accident · 1 fatalField investigationFinal reportGrumman American AA-5A · Richmond Hill, GAThe pilot's failure to maintain an adequate altitude above the water. And his physical impairment due to drugs.Oct 29, 1993 · N26462 · Substantial damageNTSB LAX94LA027Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Mokuleia, HIthe student pilot's misjudgement of descent rate and terrain clearance while manuevering along a ridgeline. Factors in the accident were the downdrafts and the mountainous/hilly nature of the terrain.Oct 28, 1993 · N7779S · Substantial damageNTSB LAX94LA026Accident · No injuriesLimited investigationFinal reportCessna 177B · Pleasant Grove, CAThe failure of the starter to turn the engine over due to inadequate maintenance and inspection.Oct 28, 1993 · N18174 · Substantial damageNTSB DCA94GA010Accident · 3 fatalClass 1Final reportBeech 300/F · Front Royal, VAthe failure of the pilot-in-command to ensure that the airplane remained in visual meteorological conditions over mountainous terrain, and the failure of the Federal Aviation Administration executives and managers responsible for the FAA flying program to:…Oct 26, 1993 · N82 · DestroyedNTSB CHI94LA025Accident · No injuriesLimited investigationFinal reportCessna 150M · Franklin, WIFailure of the instructor pilot (CFI) to use carburetor heat during the simulated engine failure, which resulted in carburetor ice and loss of engine power. Factors related to the accident were: carburetor icing conditions and the crop in the emergency…Oct 26, 1993 · N9259U · Substantial damageNTSB CHI94LA024Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Woonsocket, SDthe pilot misjudging the airplane's clearance under the wires. Factors related to the accident were the performance of a low pass and the wires which were contacted.Oct 26, 1993 · N39952 · DestroyedNTSB SEA94FA018Accident · 1 fatalField investigationFinal reportCessna 172K · North Bend, ORLoss of control while in flight due to pilot incapacitation from atherosclerotic heart disease.Oct 22, 1993 · N79405 · DestroyedNTSB CHI94LA022Accident · No injuriesLimited investigationFinal reportHiller UH12E · Sioux Rapids, IAthe Pilot in Command failed to maintain clearance with the terrain while proceeding up an upslope.Oct 22, 1993 · N4026S · DestroyedNTSB ATL94FA007Accident · 4 fatalField investigationFinal reportBeech S-35 · Carrollton, GAWas the pilot's failure to maintain control of the airplane during a missed approach which resulted in a stall. A factor was the pilot's failure to follow IFR procedures.Oct 22, 1993 · N8688Q · DestroyedNTSB LAX94LA017Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA-315 · Beckwourth, CAwas the worn collective servo causing a hydraulic lock and not allowing the pilot to lower the collective. This condition caused the main rotor blades rpm to decay.Oct 18, 1993 · N49511 · Substantial damageNTSB MIA94LA012Accident · No injuriesLimited investigationFinal reportCessna 172M · Culebra, PRThe poor in-flight decision of the pilot-in-command to bank the airplane while flying low level instead of climbing to avoid collision with a bird. Contributing to the accident was the pilot's failure to maintain clearance from the water.Oct 16, 1993 · N16582 · Substantial damageNTSB FTW94LA012Accident · Serious injuriesLimited investigationFinal reportCessna A188 · Burleson, TXWas the pilot's inadvertent entry into a stall. A factor was his abrupt maneuvering of the airplane at low altitude.Oct 15, 1993 · N8020V · DestroyedNTSB SEA94FA014Accident · 2 fatalField investigationFinal reportCessna 172P · Kelso, WAThe pilot's failure to follow the published missed approach procedure. Factors in the accident were: the weather and mountainous terrain.Oct 14, 1993 · N115FR · DestroyedNTSB CHI94LA013Accident · No injuriesLimited investigationFinal reportHughes 269A · Coldwater, MIthe fatigue failure of the tailboom support strut attachment lug.Oct 12, 1993 · N7032U · Substantial damageNTSB LAX94FA009Accident · 2 fatalField investigationFinal reportNorth American T-6G · Green Valley, CAthe CFI's failure to maintain the proper altitude while flying over mountainous terrain, and his inadvertent flight into instrument weather conditions. Contributing factors were the CFI's improper in-flight decision to fly at the low altitude and his…Oct 11, 1993 · N7765C · DestroyedNTSB CHI94FA010Accident · 2 fatalField investigationFinal reportCessna R182 · Herbster, WIFailure of the pilot to maintain clearance from trees.Oct 11, 1993 · N6422S · DestroyedNTSB SEA94LA015Accident · 1 fatalLimited investigationFinal reportVarga 2150A · Burns, ORPoor in-flight planning/decision and an inadvertent stall/spin. A factor to the accident was an excessive pull-up.Oct 10, 1993 · N5074V · DestroyedNTSB FTW94FA009Accident · 1 fatalField investigationFinal reportPiper PA-36-285 · Estelline, TXClearance not maintained by the pilot.Oct 10, 1993 · N57577 · DestroyedNTSB SEA94LA011Accident · No injuriesLimited investigationFinal reportCessna 172M · Longbranch, WAThe instructor pilot's failure to follow procedures. Factors include carburetor icing conditions and soft terrain in the landing area.Oct 8, 1993 · N9932Q · Substantial damageNTSB SEA94LA010Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Marysville, WAThe student pilot's failure to maintain altitude.Oct 7, 1993 · N8072V · DestroyedNTSB CHI94LA007Accident · Minor injuriesLimited investigationFinal reportBoeing 75N1 · St Paul, MNFailure of the pilot to maintain proper altitude.Oct 6, 1993 · N81235 · Substantial damage