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 MIA97LA230Accident · No injuriesLimited investigationFinal reportCessna R172E · Mary Esther, FLThe loss of engine power for undetermined reasons.Aug 6, 1997 · N2427 · Substantial damageNTSB IAD97LA106Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Willimantic, CTThe student pilot misunderstood the flight instructor's instructions and reduced the engine power to idle, and the Certificated Flight Instructor's delayed remedial action.Aug 6, 1997 · N717GT · Substantial damageNTSB ANC97LA117Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Farewell, AKthe pilot's failure to maintain adequate control of the airplane resulting in an inadvertent stall/mush at low altitude. Factors to the accident were the pilot's low altitude flight maneuver and the gusty winds.Aug 5, 1997 · N1606A · Substantial damageNTSB CHI97LA235Accident · No injuriesLimited investigationFinal reportCessna A188A · Norfolk, NEthe pilot's improper in-flight planning/decision, and failure or inability to control the airplane after encountering wake turbulence at low altitude during an aerial application maneuver. A related factor was the low altitude of the airplane when the wake…Aug 3, 1997 · N9902G · Substantial damageNTSB FTW97LA300Accident · No injuriesLimited investigationFinal reportPoor Boys Toys Exec 90 · Patricia, TXThe failure of the pilot to maintain terrain clearance with the crops during a surveying flight. A factor was the pilots diverted attention.Aug 1, 1997 · N596PB · Substantial damageNTSB FTW97LA291Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Abernathy, TXThe pilot's failure to use carburetor heat during serious carburetor icing conditions, and the flight instructor's inadequate supervision. Factors were the icing conditions and the lack of suitable terrain for the forced landing.Jul 31, 1997 · N32185 · Substantial damageNTSB SEA97FA178Accident · 2 fatalField investigationFinal reportCessna 172M · Clackamas, ORThe pilot's failure to maintain adequate airspeed in a steep turn and his concurrent failure to maintain adequate altitude, resulting in an accelerated stall at an altitude insufficient for recovery. Factors include the pilot's intentional low altitude flight…Jul 28, 1997 · N80222 · Substantial damageNTSB MIA97LA221Accident · No injuriesLimited investigationFinal reportCessna 188 · Benson, NCThe pilot's failure to maintain a visual lookout during a swath run resulting in an in-flight collision with a cable, subsequent loss of engine power, forced landing, and an in-flight collision with terrain. Contributing to the accident was a total loss of…Jul 28, 1997 · N53240 · DestroyedNTSB LAX97FA259Accident · 2 fatalField investigationFinal reportPiper J3C-85 · Bullhead City, AZimproper judgement of the pilot by intentionally performing low level maneuvers, and his misjudgment of a level-off over water.Jul 28, 1997 · N3339N · DestroyedNTSB CHI97LA228Accident · No injuriesLimited investigationFinal reportCessna 188B · Halstead, KSthe pilot failed to maintain adequate clearance from the transmission wires. Factors included the malfunctioning of the wire cutter and pilot fatigue.Jul 28, 1997 · N4864Q · Substantial damageNTSB CHI97LA225Accident · No injuriesLimited investigationFinal reportSorrell SNS-7 · Tomahawk, WIThe pilot encountered a tailplane stall. The factors involved were the pilot conducted a low altitude flight maneuver and encountered engine torque effect.Jul 27, 1997 · N774HB · DestroyedNTSB SEA97LA177Accident · 2 fatalLimited investigationFinal reportCessna 182G · Big Creek, IDThe flightcrew's failure to maintain clearance from trees. A factor was trees north of the departure end of the airstrip.Jul 25, 1997 · N3134S · DestroyedNTSB LAX97LA248Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Buttonwillow, CAfailure of the pilot to maintain adequate clearance from a utility pole (obstruction) during aerial application. The obstruction was a related factor.Jul 21, 1997 · N919SF · DestroyedNTSB IAD97LA102Accident · 1 fatalLimited investigationFinal reportLardas Renegade Spirit · Boonsboro, MDThe pilot's failure to maintain control of his homebuilt airplane during a low level maneuver after a loss of engine power due to undetermined reasons. A factor in the accident was the pilot's alcohol impairment.Jul 21, 1997 · N416RS · DestroyedNTSB FTW97LA276Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Palestine, ARThe pilot's failure to maintain clearance with the wire transmission line due to his diverted attention.Jul 21, 1997 · N8031K · DestroyedNTSB SEA97LA172Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Pingree, IDThe pilot-in-command's failure to maintain adequate clearance with the power lines. A contributing factor was the unmarked power lines.Jul 20, 1997 · N6550 · DestroyedNTSB SEA97LA171Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Yamhill, ORLoss of engine power for undetermined reasons.Jul 20, 1997 · N1105B · Substantial damageNTSB FTW97FA274Accident · 1 fatalField investigationFinal reportHillam Rans S-9 · Mckinney, TXloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in a stall and collision with the terrain.Jul 20, 1997 · N1678N · DestroyedNTSB ATL97LA107Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Leesburg, FLthe pilot's inadvertent entry into a secondary stall and spin, as engine power faltered during application of power, while recovering from an intentional stall. The hesitation (faltering) of power and the pilot's diverted attention were related factors.Jul 20, 1997 · N98879 · Substantial damageNTSB ATL97LA106Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Bunnell, FLthe pilot's failure to ensure the airplane had adequate airspeed for banner pickup/towing operations, which resulted in a stall/mush and subsequent contact with the terrain.Jul 19, 1997 · N4138Y · Substantial damageNTSB NYC97GA148Accident · Serious injuriesFinal reportSchweizer 269C · Baltimore, MDA total loss of engine power which was a result of incomplete and improper engine overhaul by company maintenance personnel. A factor in the accident was the unsuitable forced landing area terrain.Jul 18, 1997 · N6129Q · DestroyedNTSB LAX97LA257Accident · No injuriesLimited investigationFinal reportFronsman Rotorway Exec · Lakeport, CAan undetermined failure of the oil system (lines or filter), while hovering, which resulted in an engine compartment fire that erupted and subsequently destroyed the helicopter after it was landed.Jul 18, 1997 · N6323F · DestroyedNTSB LAX97LA247Accident · No injuriesLimited investigationFinal reportSikorsky S-58T · Page, AZan engine failure resulting from the fracture of two power turbine blades, which had been previously subjected to a hot or hung start.Jul 18, 1997 · N47B · Substantial damageNTSB NYC97FA144Accident · 2 fatalField investigationFinal reportCessna TR182 · Seaside Heights, NJfailure of the pilot to maintain sufficient altitude/clearance above water, while maneuvering over the ocean during a dark moonless night. Related factors were: darkness, the pilot's probable illusion of altitude, spatial disorientation, and lack of…Jul 13, 1997 · N737PK · DestroyedNTSB MIA97LA211Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-26B · Eustis, FLan in-flight separation of the right wing, and subsequent impact with trees. Factors in this accident were thermal lift and turbulence in clouds.Jul 12, 1997 · N9927J · DestroyedNTSB FTW97LA263Accident · Serious injuriesLimited investigationFinal reportBronner Steen Skybolt · Brazoria, TXa fuel leak at a wobble pump fuel hose clamp, which resulted in loss of fuel and fuel exhaustion. A related factor was the lack of suitable terrain for a forced landing.Jul 12, 1997 · N773HD · Substantial damageNTSB CHI97LA211Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Springfield, ILfailure of the pilot to maintain safe altitude/clearance from the terrain. Factors relating to this accident were: the hazy weather condition, the resultant difficulty in keeping the other airplane in sight, and the pilot's diverted attention, while looking…Jul 12, 1997 · N30136 · Substantial damageNTSB FTW97FA262Accident · 4 fatalField investigationFinal reportRyan Navion B · Garfield, COfailure of the pilot to maintain adequate airspeed, during a turn to reverse direction, which resulted in a stall and collision with a pole and a building. High density altiitude was a related factor.Jul 11, 1997 · N5401K · DestroyedNTSB SEA97LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-135 · Biddle, MTThe pilot-in-command's failure to maintain adequate airspeed which resulted in a stall/mush. A factor contributing to the accident was the tailwind condition on takeoff.Jul 8, 1997 · N3253B · DestroyedNTSB LAX97GA235Accident · 1 fatalFinal reportBell BHT-206L-1 · Highland, CALoss of engine power due to fuel contamination. Also causal was the ingestion of entrapped air that occurred during an abrupt maneuver and fuel-borne contamination that caused the fuel system check valves to leak, resulted in a lower than expected fuel level…Jul 7, 1997 · N27591 · DestroyedNTSB CHI97LA204Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Donnelly, MNundetermined event resulting in the broken connecting rod and cylinder.Jul 7, 1997 · N6633K · Substantial damageNTSB SEA97LA163Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Creek, IDThe pilot-in-command's inadequate terrain clearance and failure to maintain directional control. Also, the overload of the aircraft's left main landing gear strut assembly. Factors contributing to the accident were high density altitude conditions, downdrafts…Jul 5, 1997 · N4249Z · Substantial damageNTSB CHI97LA194Accident · 2 fatalLimited investigationFinal reportCessna 170B · Karlin, MIthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his inadequate visual lookout while buzzing, which resulted in failure to see-and-avoid the top (ground/static) wires of an electrical power line.Jul 5, 1997 · N2416D · DestroyedNTSB FTW97LA251Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Powderly, TXThe inadvertent stall due to the pilot's diverted attention to an open service door. A factor was the inadequate preflight inspection by the pilot.Jul 4, 1997 · N3888L · Substantial damageNTSB FTW97LA252Accident · Serious injuriesLimited investigationFinal reportBell 206B · New Iberia, LAthe pilot's improper in-flight planning/decision. A related factor was his failure to follow the company procedure of maintaining visual contact with the external long-line cable, while hovering with it attached.Jul 3, 1997 · N49661 · Substantial damageNTSB CHI97LA199Accident · No injuriesLimited investigationFinal reportSnow S2C · Viola, ILthe pilot's inadequate preflight planning/preparation by failing to ensure there was an inadequate supply of fuel for the flight, which led to fuel exhaustion, loss of engine power, and a forced landing. Uneven terrain in the emergency landing area was a…Jul 3, 1997 · N1684S · Substantial damageNTSB CHI97LA193Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Satanta, KSThe pilot did not maintain aircraft control and the reason for the loss of engine power was undetermined.Jul 2, 1997 · N10397 · Substantial damageNTSB SEA97LA156Accident · No injuriesLimited investigationFinal reportStiritz Eipper MX II · Newport, WAThe failure of the owner/builder to adequately inspect his homebuilt aircraft, which subsequently led to the failure of the right wing lift cable attach bolt and resulted in the collapse of the right wing during flight.Jun 30, 1997 · N15TJ · Substantial damageNTSB FTW97LA242Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Edna, TXfailure of the pilot to maintain clearance from a guy wire, during a swath run.Jun 30, 1997 · N4396S · Substantial damageNTSB ANC97FA092Accident · 2 fatalField investigationFinal reportCessna 207A · Nome, AKThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain adequate clearance from an obstruction (antenna tower). Factors in the accident were low ceilings and visibility, and the pilot's lack of familiarity with…Jun 28, 1997 · N207SP · DestroyedNTSB FTW97LA238Accident · No injuriesLimited investigationFinal reportCessna 305A · Watkins, COThe pilot inadvertently stalling the airplane at an altitude insufficient for a safe recovery. A factor was the tailwind.Jun 27, 1997 · N5225G · DestroyedNTSB CHI97FA187Accident · Serious injuriesField investigationFinal reportPiper PA-22-108 · Lenox Township, MIThe pilot's failure to follow the procedures and directives as listed on the placard in the aircraft resulting in fuel starvation and subsequent engine failure.Jun 25, 1997 · N4882Z · Substantial damageNTSB FTW97LA232Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9B · El Indio, TXthe pilot's inadequate preflight, subsequent fuel starvation, and failure of the pilot to reposition the fuel selector to another tank (perform emergency procedure) after the loss of engine power, which resulted in a forced landing and subseqent nose-over.…Jun 23, 1997 · N7684V · Substantial damageNTSB NYC97LA125Accident · 1 fatalLimited investigationFinal reportShafer SONERAI-I · W.Hampton Beach, NYfailure of the number two pilot (N77TY) to follow race procedures, and failure of the number three pilot (N20CS) to turn and avoid the number two airplane, when it decelerated into the number three pilot's blind spot.Jun 22, 1997 · N20CS · 2 aircraft · DestroyedNTSB CHI97LA181Accident · No injuriesLimited investigationFinal reportCessna 172M · Grosse Ile, MIthe instructor pilot's inadequate planning/decision, resulting in an inadvertent stall situation.Jun 22, 1997 · N4491R · Substantial damageNTSB MIA97LA192Accident · 1 fatalLimited investigationFinal reportUnknown Kolb Firestar II · Orlando, FLInadvertent stall by the pilot while turning from the upwind to the crosswind leg. Contributing to the accident was the pilots lack of total experience in the make and model airplane.Jun 21, 1997 · UNREG · Substantial damageNTSB CHI97LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Faulkton, SDthe pilot's inability to see the power lines and the power lines. Factors contributing to this accident were the trees and the sunglare.Jun 21, 1997 · N7378Z · DestroyedNTSB SEA97LA147Accident · 1 fatalLimited investigationFinal reportWolf Smith M/P DSA-1 · Bend, ORAn inflight propeller blade separation, and a subsequent evasive turn to avoid traffic by the pilot at an inadequate airspeed resulting in an accelerated stall. Factors were excessive power output of the installed engine, an aircraft taking off in the…Jun 20, 1997 · N168RW · DestroyedNTSB MIA97LA190Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Edwards, MSfailure of the distributor drive gear in the right magneto, resulting in loss of engine power and a forced landing. The lack of suitable terrain for a forced landing was a related factor.Jun 20, 1997 · N6816Q · Substantial damageNTSB ATL97LA087Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301A · Labelle, FLfailure of the pilot to maintain adequate airspeed during a turn-around maneuver, which resulted in an aerodynamic stall/mush and collision with the terrain.Jun 20, 1997 · N23728 · Substantial damage