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 CHI98FA123Accident · 1 fatalField investigationFinal reportCessna 180J · Ashland, WIthe pilot failing to maintain separation from the trees. Factors contributing to this accident were the trees and the pilot being too low in altitude.Apr 15, 1998 · N828CE · DestroyedNTSB IAD98LA046Accident · No injuriesLimited investigationFinal reportLet L-23 · New Castle, VAThe pilot's failure to maintain adequate airspeed during the turn to reverse direction. A factor was his improper use of the speed brake.Apr 12, 1998 · N55BR · Substantial damageNTSB CHI98LA121Accident · Serious injuriesLimited investigationFinal reportExtra Flugzeugbau EA-300 · Chenoa, ILthe pilot experienced GLOC (G induced loss of consciousness) while performing an aerobatic maneuver. Fatigue was a factor.Apr 12, 1998 · N301NL · Substantial damageNTSB FTW98LA179Accident · Minor injuriesLimited investigationFinal reportWsk Pzl Mielec PZL-M-18 · Carlisle, ARThe pilot's inadequate preflight and inflight planning/decision, which resulted in fuel exhaustion and the lost of engine power. A factor was the lack of suitable terrain for a forced landing.Apr 10, 1998 · N7046Y · Substantial damageNTSB MIA98LA128Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-19B · Hamptonville, NCThe pilot's failure to maintain airspeed (VSO) while maneuvering at a low altitude.Apr 9, 1998 · N297B · Substantial damageNTSB SEA98FA062Accident · 1 fatalField investigationFinal reportMooney M20F · Lodgepole, MTThe pilot's failure to maintain clearance from the terrain after flying into an area of known adverse weather. Factors include low ceilings, fog, snow showers, drizzle, and trees along his intended route.Apr 6, 1998 · N9131V · DestroyedNTSB FTW98LA175Accident · No injuriesLimited investigationFinal reportNorth American Harvard 2 · Weiner, ARThe pilot's failure to maintain clearance from wires.Apr 5, 1998 · N92871 · Substantial damageNTSB MIA98LA120Accident · No injuriesLimited investigationFinal reportBell 205 · Wewahitchka, FLThe pilot's loss of control as a result of erratic flight control movement due to a surge in hydraulic pressure for undetermined reasons.Apr 3, 1998 · N508DD · DestroyedNTSB CHI98LA116Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Sabetha, KSThe loss of engine power for undetermined reasons.Apr 3, 1998 · N7108Z · Substantial damageNTSB MIA98LA115Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAThe pilot's failure to maintain adequate airspeed, which resulted in a stall. Contributing factors were the pilot's lack experience in this category of aircraft. An additional factor was the inadequate upgrade training provided by the company that owned the…Apr 2, 1998 · N6847Z · DestroyedNTSB SEA98FA056Accident · 3 fatalField investigationFinal reportCessna P210N · Royal City, WAAttempted VFR flight into IMC and terrain clearance was not maintained. A low ceiling was a factor.Mar 31, 1998 · CGBFM · DestroyedNTSB MIA98LA114Accident · No injuriesLimited investigationFinal reportSouthwest Florida SW204 · Indiantown, FLA loss of engine power due to turbine blade failure caused by operating the engine in an over temperature and over speed condition. Contributing to the accident was the pilot's failure to observe the helicopter's maximum gross lift-off weight limit resulting…Mar 31, 1998 · N106CP · Substantial damageNTSB FTW98LA163Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Riviera, TXThe pilot's failure to maintain terrain clearance while performing an evasive maneuver to avoid a charging bull, resulting in a tail rotor blade strike and the failure of the tail rotor drive shaft. Factors were the charging bull and the lack of suitable…Mar 31, 1998 · N2628B · Substantial damageNTSB SEA98FA055Accident · No injuriesField investigationFinal reportEnstrom F28F · Baker, ORFatigue failure of the steel tubing pylon structure. Factors include inadequate inspection by maintenance personnel of damage after a previous accident.Mar 30, 1998 · N171HH · Substantial damageNTSB FTW98LA161Accident · Serious injuriesLimited investigationFinal reportGrumman G-164 · St. Joseph, LAThe pilot's failure to maintain clearance from the trees. A factor was the lack of suitable terrain for the ensuing forced landing.Mar 28, 1998 · N617Y · DestroyedNTSB ANC98LA031Accident · No injuriesLimited investigationFinal reportCessna 172A · Paxson, AKThe pilots failure to maintain terrain clearance while flying into a box canyon, and an inadvertent stall during his attempt to reverse direction.Mar 25, 1998 · N7339T · DestroyedNTSB LAX98LA120Accident · No injuriesLimited investigationFinal reportBeech C35 · Rio Linda, CAthe pilot's inadequate fuel management which led to fuel exhaustion.Mar 23, 1998 · N8948A · Substantial damageNTSB NYC98LA079Accident · No injuriesLimited investigationFinal reportEnstrom F280F · New Alexandria, PAA bird strike.Mar 20, 1998 · N66JV · Substantial damageNTSB LAX98LA116Accident · No injuriesLimited investigationFinal reportAyres S2R · Willows, CAThe pilot's failure to maintain adequate altitude/clearance from the wires.Mar 19, 1998 · N32064 · Substantial damageNTSB FTW98FA151Accident · 1 fatalField investigationFinal reportAir Tractor AT-502 · Mcgehee, ARThe pilot's inadvertent flight into adverse weather conditions resulting in the loss of control due to spatial disorientation. Factors were the fog and low ceiling, and the inadequate flight instruments available to the pilot.Mar 19, 1998 · N10035 · DestroyedNTSB LAX98FA112Accident · 2 fatalField investigationFinal reportGough-Herrman Christen Eagle II · Lake Berryessa, CAwas the pilot-in-command's failure to maintain control of the aircraft. Contributing to the accident was the improper altitude.Mar 14, 1998 · N331GH · DestroyedNTSB ATL98LA055Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Marianna, FLThe failure of maintenance personnel to secure the magneto cover that resulted in water contamination and the subsequent loss of engine power. A factor was rough and uneven terrain.Mar 14, 1998 · N8626H · Substantial damageNTSB SEA98LA054Accident · No injuriesLimited investigationFinal reportSnow 600-S2C · Bickleton, WAThe pilot's mismanagement of the fuel which led to fuel exhaustion. A related factor was unsuitable terrain.Mar 13, 1998 · N1640S · DestroyedNTSB SEA98LA045Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402A · Moreland, IDThe pilot's failure to maintain aircraft control resulting in an inadvertent stall/spin. A factor was his lack of familiarity in the make/model.Mar 13, 1998 · N50963 · DestroyedNTSB CHI98LA102Accident · 1 fatalLimited investigationFinal reportPiper PA-32-260 · Mc Cordsville, INThe pilot's failure to maintain airspeed and control of the airplane. Factors were his self-induced pressure.Mar 12, 1998 · N55059 · Substantial damageNTSB LAX98GA110Accident · 1 fatalFinal reportChristen Industries A-1 · Lebec, CAThe trainee-pilot's failure to maintain altitude during a low level turn. Contributing factors were the pilot-in-command's diverted attention inside the airplane, his failure to report the trainee's deficient airplane handling abilities, and the shoulder…Mar 11, 1998 · N9615G · DestroyedNTSB FTW98FA145Accident · 1 fatalField investigationFinal reportDuci'S Vans RV-3 · Elbert, COin-flight failure of the right wing spar (for an undetermined reason) as the pilot was performing aerobatic flight. The airplane's excessive gross weight (for aerobatics) was a related factor.Mar 8, 1998 · N99HV · DestroyedNTSB LAX98LA108Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Hollister, CAThe failure of the maintenance personnel to recognize and repair the chafed area of the tail rotor driveshaft, which resulted in an in-flight separation of the tail fin and hub assembly.Mar 7, 1998 · N204DR · DestroyedNTSB MIA98LA092Accident · No injuriesLimited investigationFinal reportCessna 188B · Houston, MScorrosion and subsequent disconnect of the left aileron control rod end fitting, which resulted in a loss of aileron (roll) control, a forced landing, and subsequent impact with the terrain. A factor related to the accident was: improper lubrication of the…Mar 4, 1998 · N53382 · Substantial damageNTSB SEA98FA042Accident · 6 fatalField investigationFinal reportCessna T303 · Midvale, IDThe pilot's failure to maintain aircraft control.Mar 3, 1998 · N727RT · DestroyedNTSB SEA98FA040Accident · 2 fatalField investigationFinal reportFreije Lancair IV · Garwood, IDThe pilot's failure to maintain aircraft control after entering known adverse weather. Related factors were, the pilot's failure to follow the published IFR departure procedures, low ceilings and snow, and the pilot's lack of recent instrument experience.Feb 26, 1998 · N109GF · DestroyedNTSB LAX98LA103Accident · No injuriesLimited investigationFinal reportAir Tractor 301-300 · Woodland, CAThe failure of the pilot to adequately monitor his fuel consumption, which resulted in fuel exhaustion.Feb 26, 1998 · N8828S · Substantial damageNTSB SEA98LA039Accident · No injuriesLimited investigationFinal reportCessna 150F · Fife, WAThe fracture separation of an exhaust valve head, followed by the total failure of the associated piston. A factor was the soft terrain at the location of the forced landing.Feb 24, 1998 · N8794G · Substantial damageNTSB NYC98LA067Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5 · Brookville, OHThe pilot's misjudgment of the fuel supply.Feb 22, 1998 · N5625L · DestroyedNTSB SEA98LA038Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Stanwood, WAThe pilot's failure to apply carburetor heat. Factors included carburetor icing conditions and soft terrain in the forced landing area.Feb 19, 1998 · N48493 · Substantial damageNTSB ATL98LA045Accident · No injuriesLimited investigationFinal reportPitts S-2A · New Smyrna Beac, FLThe loss of engine power for undetermined reasons, and, the jammed engine starter drive assembly, that prevented an engine restart in flight. A factor was the soft terrain.Feb 17, 1998 · N32TP · Substantial damageNTSB MIA98FA079Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Fort Pierce, FLThe pilot's continued visual flight rules into instrument flight rules conditions and his failure to maintain altitude after encountering instrument flight rules conditions resulting in the aircraft colliding with powerlines and crashing. A factor in the…Feb 14, 1998 · N15091 · DestroyedNTSB FTW98FA127Accident · 1 fatalField investigationFinal reportIreneusz Rans S-12 · Rockwall, TXThe pilot's failure to maintain clearance while performing low altitude flight over the water.Feb 14, 1998 · N95EW · Substantial damageNTSB ATL98LA042Accident · No injuriesLimited investigationFinal reportAviat A-1 · Clearwater, FLfailure of the pilot to maintain adequate airspeed, while maneuvering to pick up a banner, which led to a stall, loss of altitude, and collision with the water.Feb 14, 1998 · N49364 · Substantial damageNTSB LAX98LA089Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Chico, CAFuel exhaustion due to the pilot's failure to ensure that an adequate fuel supply was onboard. A contributing factor was related to the fuel quantity gage's erroneous indication of fuel.Feb 13, 1998 · N4027Z · Substantial damageNTSB FTW98LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Port Lavaca, TXThe pilot's failure to maintain clearance from the power line. Factors were the gusty winds, the pilots lack of experience in the type of operation, inadequate training and insufficient standards/requirements by the company/operator management, and the power…Feb 6, 1998 · N5207R · Substantial damageNTSB MIA98GA069Accident · 4 fatalFinal reportBell UH-1H · Savannah, TNfailure of the flight crew to maintain sufficient altitude/clearance from the pole and workman. Related factors were: the gusty wind condition, inadequate communication/coordination between the flight crew and ground personnel, and an improper external system…Feb 3, 1998 · N30TV · DestroyedNTSB SEA98LA033Accident · 2 fatalLimited investigationFinal reportSherman Executive · Stayton, ORMain rotor strike and separation of the tail boom for undetermined reasons.Jan 31, 1998 · N50499 · DestroyedNTSB MIA98FA064Accident · 1 fatalField investigationFinal reportCessna 170A · Miami, FLfailure of the pilot to maintain adequate airspeed during a banner pickup, which resulted in an inadvertent stall and collision with the terrain. The lack of altitude for a stall recovery was a related factor.Jan 31, 1998 · N1200D · Substantial damageNTSB FTW98LA107Accident · Serious injuriesLimited investigationFinal reportSutton Tierra II · Woodson, ARThe pilot's inability to maintain control of the airplane for undetermined reasons.Jan 27, 1998 · N131WH · Substantial damageNTSB LAX98LA079Accident · 1 fatalLimited investigationFinal reportHughes 369D · Pacific Ocean (Pacific Ocean)The pilot's failure to adequately compensate for the wind condition and failure to maintain a proper rate of descent which resulted in the inadvertent loss of tail rotor effectiveness during a downwind turn.Jan 24, 1998 · N521ZZ · DestroyedNTSB ATL98IA039Incident · No injuriesIncident investigationFinal reportRobinson R-44 · Miami, FLAn inadequate service bulletin which did not require measurement of the cyclic trim assembly shaft and did not identify all helicopters in which shaft wear could lead to restricted movement of the lateral cyclic trim.Jan 23, 1998 · N972SA · No damageNTSB CHI98LA083Accident · Minor injuriesLimited investigationFinal reportNerstrom-Tailwind W-8 · Lodi, WIthe pilot's failure to maintain a proper altitude due to the whiteout conditions. Factors associated with the accident were the low pass performed by the pilot and the visual illusion created by the whiteout conditions.Jan 20, 1998 · N12038 · DestroyedNTSB FTW98FA100Accident · 1 fatalField investigationFinal reportAir Tractor 502B · Eudora, ARThe pilot's failure to maintain adequate airspeed while attempting an aerobatic manueverJan 16, 1998 · N6093U · DestroyedNTSB FTW98TA099Accident · No injuriesFinal reportBell 47G-3B-1 · Magdalena, NMThe pilot's failure to maintain adequate main rotor rpm. A factor was a lack of recent experience in the type of operation being performed.Jan 15, 1998 · N7901S · Substantial damage