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 ATL97LA011Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Abbeyville, ALThe loss of engine power for undetermined reasons.Oct 31, 1996 · N6756K · Substantial damageNTSB SEA97LA022Accident · 1 fatalLimited investigationFinal reportCollier Q200 · Estacada, ORinadequate maintenance adjustment by the owner/pilot/mechanic, by not using safety wire to secure the throttle arm clamping screw, which resulted in a loose clamping screw and rotation of the throttle arm with respect to the butterfly valve shaft. The lack of…Oct 29, 1996 · N200CQ · Substantial damageNTSB CHI97LA016Accident · 1 fatalLimited investigationFinal reportHughes 369 · Vestaburg, MIfailure of the pilot to maintain clearance with the wires.Oct 28, 1996 · N9251F · Substantial damageNTSB NYC97FA011Accident · 2 fatalField investigationFinal reportYakovlev YAK-18T · Berlin, NJan inadequate preflight by unknown person(s), sometime before the flight, by failing to avoid a hydraulic lock (from oil seepage) in the #5 cylinder, which resulted in a bent connecting rod, subsequent failure of the #5 piston, and loss of engine power. Also…Oct 27, 1996 · N9418 · DestroyedNTSB MIA97LA012Accident · Minor injuriesLimited investigationFinal reportAir Tractor 400 · Sylvester, GAWas the pilots intentional disregard for operating the engine contrary to the flight manuals for intentionally exceeding the maximum engine temperature, resulting in creep failure of one of the compressor turbine blades.Oct 21, 1996 · N73080 · Substantial damageNTSB FTW97LA019Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Throckmorton, TXfailure of the pilot to maintain clearance of a transmission wire during pullup from a swath run. The proximity of the transmission wire was a related factor. The installation of wire cutter equipment on the landing gear might have prevented or reduced the…Oct 18, 1996 · N4549Z · DestroyedNTSB LAX97LA014Accident · 1 fatalLimited investigationFinal reportCunningham Rotorway Exec · Mather, CAexcessive maneuvering by the pilot, which allowed the main rotor blades to contact and sever the tail rotor system and allowed mast bumping to occur.Oct 13, 1996 · N18WC · DestroyedNTSB IAD97LA006Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Springfield, OHfailure of the pilot to maintain obstacle clearance, while maneuvering at low altitudes. A related factor was the quartering tail wind.Oct 13, 1996 · N42719 · Substantial damageNTSB ATL97LA002Accident · Serious injuriesLimited investigationFinal reportBell UH-IB · Bennettsville, SCthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate supply of usable fuel. A factor relating to the accident was: an inoperative left boost pump, which increased the amount of unusable fuel…Oct 12, 1996 · N846MC · DestroyedNTSB SEA97LA011Accident · 2 fatalLimited investigationFinal reportAero Vodochody Aero. Works L-29 · Tillamook, ORfailure of the pilot to maintain control of the aircraft, while maneuvering behind an F4F aircraft. The lack of altitude for a recovery was a related factor.Oct 11, 1996 · N7150A · DestroyedNTSB SEA97GA008Accident · 2 fatalFinal reportPiper PA-18-150 · Holden, UTThe first pilot's failure to maintain adequate airspeed while maneuvering the airplane in close proximity to the ground. This subsequently led to an aerodynamic stall and uncontrolled descent into the ground. Factors contributing to the accident include the…Oct 10, 1996 · N91017 · DestroyedNTSB CHI97LA004Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Nunda, SDfailure of maintenance personnel to properly torque the six accessory drive bolts, which resulted in fatigue failure of the undertorqued bolts.Oct 6, 1996 · N7925J · Substantial damageNTSB CHI97LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Silver Lake, INfuel starvation due to an inadequate preflight and the pilot performed a low altitude maneuver which prevented him from selecting suitable terrain for landing. Additional factors included the loose fuel cap, fuel siphoning, and unreliable fuel gauges.Oct 5, 1996 · N5749H · DestroyedNTSB NYC97LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Coudersport, PAthe pilot's improper in-flight planning/decision, and his failure to ensure that adequate airspeed would be maintained, while maneuvering at low altitude to photograph a residence. The rising terrain and lack of altitude were related factors.Oct 4, 1996 · N5154E · DestroyedNTSB FTW97LA009Accident · Serious injuriesLimited investigationFinal reportYoung Cozy MK IV · Pueblo, COthe pilot/builder's improper design change which resulted in a loss of control following an intentional stall. A factor was an erroneous weight-and-balance calculation.Oct 4, 1996 · N96PJ · Substantial damageNTSB FTW97FA002Accident · 1 fatalField investigationFinal reportBell EAA Biplane P · Manzanola, COfailure of the pilot to maintain sufficient altitude/clearance above the terrain, while performing a low altitude maneuver. A factor relating to the accident was the pilot's lack of familiarity with this make and model of aircraft.Oct 2, 1996 · N145DB · DestroyedNTSB MIA96TA236Accident · No injuriesFinal reportBell 206B III · Flamingo, FLthe wire strike protection guide became entangled in a mangrove branch which resulted in helicopter control not being maintained.Sep 30, 1996 · N2113Z · Substantial damageNTSB MIA96LA235Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Borinquen, PRthe pilot failed to maintain control of the aircraft while hover taxing. Factors in this accident were wind gusts and a tailwind.Sep 29, 1996 · N1397X · Substantial damageNTSB MIA96LA234Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Wassau Island, GAthe pilot's inadequate preflight and planning which resulted in fuel exhaustion.Sep 27, 1996 · N151JP · Substantial damageNTSB SEA96LA220Accident · No injuriesLimited investigationFinal reportRalph Taylor Royal T · Kent, WAin-flight collision with an unknown object.Sep 25, 1996 · N2554 · Substantial damageNTSB MIA96LA232Accident · 1 fatalLimited investigationFinal reportAir Tractor 402 · Slocomb, ALThe pilot's failure to maintain airspeed.Sep 24, 1996 · N9130M · DestroyedNTSB FTW96TA400Accident · No injuriesFinal reportCessna T188C · Snyder, TXThe pilot's failure to maintain clearance with a pole resulting in the separation of the left aileron and a loss of aircraft control. A factor was the haze.Sep 24, 1996 · N9537J · Substantial damageNTSB IAD96LA151Accident · 1 fatalLimited investigationFinal reportCessna 150C · Liberty, KYthe pilot's failure to maintain adequate altitude, while maneuvering at a low altitude, which resulted in in-flight collision with trees.Sep 23, 1996 · N1947Z · DestroyedNTSB CHI96LA344Accident · Minor injuriesLimited investigationFinal reportRozendaal Smith Innovation · Hampton, IAthe pilot's failure to refuel the airplane and his improper decision to perform a low altitude manuever with a low fuel supply.Sep 22, 1996 · N2982 · Substantial damageNTSB LAX96LA342Accident · No injuriesLimited investigationFinal reportBell 206B · Van Nuys, CAthe pilot's improper in-flight planning/decision to turn right instead of left.Sep 21, 1996 · N909CM · Substantial damageNTSB LAX96FA340Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Caliente, CAimproper in-flight planning/decision by the flight instructor (CFI) by allowing the airplane to flying into a box canyon area, and his failure to maintain adequate airspeed, which resulted in an inadvertent stall and collision with wooded terrain. The CFI's…Sep 21, 1996 · N2393W · DestroyedNTSB ATL96LA130Accident · 1 fatalLimited investigationFinal reportAir Tractor 402 · Mayersville, MSthe pilot's misjudgment of his ground speed and distance to trees during the swath run, and his delayed pull-up at the end of the swath run, which resulted in his failure to remain clear of the trees. The tail wind and location of the trees were related…Sep 21, 1996 · N1517G · Substantial damageNTSB SEA96LA216Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Gillette, WYfailure of the pilot to see-and-avoid the obstruction (power line). The powerline was a related factor.Sep 19, 1996 · N8789C · Substantial damageNTSB ATL96LA129Accident · Minor injuriesLimited investigationFinal reportBell 47G-4A (Soloy) · Belmont, MSfailure of the aft universal joint of the tail rotor drive shaft, due to inadequate lubrication by company maintenance personnel. A factor relating to the accident was the pilot's delay in discontinuing the flight after noting a progressively worse tail rotor…Sep 19, 1996 · N23PH · Substantial damageNTSB SEA96FA214Accident · 1 fatalField investigationFinal reportMudry CAP 10B · Fairchild Afb, WAloss of control due to a jammed aileron pushpull tube, due to improper installation/routing of electrical wire bundles through the right aileron bellcrank mechanism by unknown person(s).Sep 14, 1996 · N25AK · DestroyedNTSB SEA96TA213Accident · No injuriesFinal reportBell 206B-3 · St Regis, MTfailure of the pilot to maintain clearance from electrical transmission lines. The proximity of transmission lines was a related factor.Sep 13, 1996 · N47MA · Substantial damageNTSB ANC96FA158Accident · 2 fatalField investigationFinal reportChampion 7EC · May Creek, AKfailure of the pilot to maintain adequate airspeed, while maneuvering and/or flying at low altitude, which resulted in a stall and collision with the terrain. A factor relating to the accident was: the pilot allowed the weight and balance (aft…Sep 13, 1996 · N9061B · DestroyedNTSB FTW96TA383Accident · No injuriesFinal reportBell 47G-3B-1 · Rangely, COthe pilot's excessive cyclic control input during a low altitude operation, and his failure to maintain altitude/clearance from high vegetation (sage brush). The proximity of high vegetation was a related factor.Sep 10, 1996 · N1335X · Substantial damageNTSB FTW97LA029Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Stanton, TXPilot's failure to maintain clearance with a wire resulting in the separation of the rudder and a loss of aircraft control.Sep 8, 1996 · N57871 · Substantial damageNTSB CHI96FA332Accident · 1 fatalField investigationFinal reportTaylorcraft BC-12D · Bellaire, MIthe pilot's improper remedial action, while recovering from an intentional stall, which resulted in an inadvertent spin and collision with the terrain. The lack of altitude for recovery was a related factor.Sep 8, 1996 · N43687 · Substantial damageNTSB ANC96FA149Accident · 2 fatalField investigationFinal reportChampion 7GCBC · Glennallen, AKfailure of the pilot to maintain adequate airspeed, while maneuvering a low altitude, which resulted in an inadvertent stall and an uncontrolled collision with the terrain. A factor related to the accident was: the pilot's use of a medication with sedative…Sep 8, 1996 · N88359 · Substantial damageNTSB SEA96LA211Accident · No injuriesLimited investigationFinal reportCessna 172M · Pacific City, ORthe pilot's failure to see-and-avoid the transmission line. Factors relating to the accident were: the pilot's low altitude flight, and the transmission line.Sep 7, 1996 · N12382 · Substantial damageNTSB MIA96LA226Accident · Serious injuriesLimited investigationFinal reportAir Tractor 301 · St Clair, ALfailure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall and uncontrolled descent to ground.Sep 5, 1996 · N8563S · DestroyedNTSB SEA96TA207Accident · Minor injuriesFinal reportBell 206L-3 · Sheridan, WYthe pilot's improper in-flight planning/decision, concerning maneuvers to position the helicopter for aerial application; and inadvertent loss of tail rotor effectiveness, which resulted in loss of directional control and subsequent collision with the…Sep 4, 1996 · N253EV · Substantial damageNTSB ANC96LA145Accident · No injuriesLimited investigationFinal reportTaylorcraft F21B · Kenai, AKthe pilot's improper fuel managment, which resulted in loss of engine power due to fuel exhaustion.Sep 4, 1996 · N4417P · Substantial damageNTSB FTW96LA371Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Meadow, TXThe pilot's failure to maintain clearance from the transmission wire. A factor was the lack of suitable terrain for a forced landing.Sep 3, 1996 · N3166H · Substantial damageNTSB ANC96FA141Accident · 3 fatalField investigationFinal reportCessna 172 · Eagle River, AKThe first pilot's failure to maintain sufficient distance/altitude from terrain. A box canyon and mountainous terrain are factors in the accident.Sep 3, 1996 · N8739B · DestroyedNTSB NYC96LA179Accident · No injuriesLimited investigationFinal reportPiper J-3 · Wildwood, NJThe pilot's failure to maintain sufficient altitude during a low altitude maneuver.Sep 2, 1996 · N92085 · Substantial damageNTSB CHI96LA325Accident · 1 fatalLimited investigationFinal reportKarr Titan Tornado · Union Pier, MIthe pilot not obtaining/maintaining altitude/clearance. Factors were the pilot not maintaining aircraft control and intentional aerobatics.Sep 1, 1996 · N238PW · DestroyedNTSB FTW96GA365Accident · 2 fatalFinal reportPiper PA-23-250 · Jennings, LAThe pilot's failure to maintain clearance. Factors were the pilot's lack of recent experience in the make and model of airplane, the dark night, and fog.Aug 31, 1996 · N14196 · DestroyedNTSB FTW96LA372Accident · No injuriesLimited investigationFinal reportHardie KIT FOX XL · Monticello, ARthe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Aug 30, 1996 · N42JH · Substantial damageNTSB FTW96LA370Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Plains, TXfailure of the pilot to maintain control of the airplane, while maneuvering after a swath run, which subsequently resulted in a collision with the terrain. A factor relating to the accident was: the adverse wind condition (gusty wind and possible windshear).Aug 30, 1996 · N1558N · Substantial damageNTSB MIA96LA219Accident · Serious injuriesLimited investigationFinal reportFlightstar 2SL · Kiln, MSfailure of the pilot to maintain adequate airspeed, while maneuvering after takeoff, which resulted in an inadvertent stall and subsequent in-flight collision with terrain.Aug 29, 1996 · UNREG · Substantial damageNTSB FTW96LA363Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Oklahoma City, OKthe student pilot's inadequate preflight planning/preparation, and subsequent fuel exhaustion due to an inadequate supply of fuel. Factors relating to the accident were: the student's lack of experience in this make and model of aircraft, darkness, and lack…Aug 29, 1996 · N9253U · Substantial damageNTSB CHI96LA319Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Pittsburg, KSthe pilot diverted his attention and failed to maintain sufficient altitude and clearance with the terrain. Factors relating to the accident were: darkness, and the pilot performing low altitude flight at night.Aug 29, 1996 · N47558 · Substantial damage