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 ATL98LA125Accident · Serious injuriesLimited investigationFinal reportHopkins Buckeye Industries Dream Machine 582 · Franklin, NCThe non-certificated pilot's inadequate judgement of the required climb rate, and his failure to attain clearance from obstacles.Sep 16, 1998 · UNREG · Substantial damageNTSB FTW98FA399Accident · 1 fatalField investigationFinal reportCessna 172N · Montezuma Crk, UTThe pilot's attempted aerobatic maneuver and the subsequent inadvertent stall/spin. A factor was his intentional low altitude flight.Sep 14, 1998 · N737NH · DestroyedNTSB FTW98LA395Accident · Serious injuriesLimited investigationFinal reportMaule M-5-235C · Mimbres, NMThe pilot's failure to maintain aircraft control while maneuvering. Factors were a low altitude turn into a crosswind and a high density altitude.Sep 13, 1998 · N9218E · Substantial damageNTSB MIA98LA244Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Malone, FLa loss of engine power due to a chaffed ignition wires, resulting in a forced landing and subsequent impact with trees.Sep 9, 1998 · N3652X · Substantial damageNTSB CHI98LA348Accident · No injuriesLimited investigationFinal reportCessna A185F · Bottineau, NDThe partial loss of engine power for undetermined reasons, and the pilot's excessive use of brake pressure which resulted in the aircraft nosing over..Sep 4, 1998 · N1005F · Substantial damageNTSB CHI98LA332Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Decker, INThe pilot's failure to maintain obstacle clearance resulting in a collision with a fence.Sep 4, 1998 · N75068 · Substantial damageNTSB FTW98LA383Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Portales, NMThe pilot's failure to maintain adequate altitude/clearance during an aerial application. Also causal was the inadvertent ground loop/swerve during the landing.Sep 2, 1998 · N50620 · DestroyedNTSB ANC98LA138Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Dillingham, AKThe pilot's failure to maintain clearance with terrain. Contributing factors were the pilot's delayed remedial action (course reversal), low ceilings, rain, fog, and mountainous terrain.Sep 2, 1998 · N139F · Substantial damageNTSB MIA98LA236Accident · No injuriesLimited investigationFinal reportHall Revolution Mini 500 · Hattiesburg, MSThe failure of the pilot to maintain main rotor rpm during a forward hover and the cyclic grip separating during the resultant bounced landing resulting in the pilot losing cyclic control and the main rotor contacting the tail boom. A factor in the accident…Aug 30, 1998 · N9GH · Substantial damageNTSB LAX98LA279Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Big Bear, CAThe pilot's encounter with an unfavorable wind condition, which caused the aircraft to descend at a rate that exceeded the aircraft's climb capability.Aug 29, 1998 · N56856 · DestroyedNTSB FTW98FA377Accident · 2 fatalField investigationFinal reportJodel F11-3 · Beeville, TXThe failure of the pilot-in-command to maintain obstacle clearance during an intentional low altitude maneuver.Aug 29, 1998 · N8122 · DestroyedNTSB CHI98LA355Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · N. Ottawa Twp., MNA loss of engine power due to a worn piston ring. A related factor was the owner exceeded the manufacturer's recommended engine overhaul.Aug 28, 1998 · N4543F · DestroyedNTSB LAX98TA278Accident · No injuriesFinal reportAerospatiale SA316B · Porterville, CAThe pilot's failure to maintain adequate in-flight clearance between the bucket and trees resulting in the entanglement/separation of the long line and subsequent impact with and separation of the tail rotor assembly. A factor was the trees.Aug 27, 1998 · N605RA · Substantial damageNTSB ATL98LA121Accident · Serious injuriesLimited investigationFinal reportRockwell S-2R · Colquitt, GAThe pilot's inadequate visual lookout, and his failure to maintain adequate clearance of known equipment, resulted in the collision with the field irrigation system.Aug 25, 1998 · N5506X · DestroyedNTSB FTW98LA367Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Naturita, COPartial loss of engine power resulting from heat induced deterioration of the gas generator turbine. Factors were a forced landing in hilly unsuitable terrain containing mature trees.Aug 22, 1998 · N49525 · Substantial damageNTSB ATL98LA117Accident · No injuriesLimited investigationFinal reportAir Tractor 401 · Holly Bluff, MSThe malfunction of the carburetor which resulted in improper fuel flow to the engine.Aug 22, 1998 · N10103 · Substantial damageNTSB FTW98LA368Accident · No injuriesLimited investigationFinal reportMassey Christen Eagle II · Galveston, TXThe inflight structural failure of the wing spars for the lower wings due to an undetermined reason.Aug 20, 1998 · N72BJ · Substantial damageNTSB ATL98LA116Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Myrtle Beach, SCThe pilot's inadequate preflight planning of fuel required for the flight that resulted in fuel exhaustion and the total loss of engine power. A factor was the pilot continued flight operation with known deficiencies in equipment.Aug 19, 1998 · N78583 · Substantial damageNTSB NYC98LA169Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Jackson Twnshp, NJThe flight (check pilot) instructor's excessive pull-up maneuver and his inadvertent entry into a low altitude stall/spin.Aug 16, 1998 · N89144 · DestroyedNTSB MIA98LA226Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Conway, SCThe total failure of the left wing forward and aft attachment fitting due to corrosion and fatigue during a banner tow pick-up resulting in a subsequent in-flight collision with terrain.Aug 15, 1998 · N3981Z · Substantial damageNTSB FTW98FA358Accident · 1 fatalField investigationFinal reportCessna 172N · Cord, ARThe pilot's performance of low altitude flight and his failure to maintain obstacle clearance.Aug 15, 1998 · N6323G · Substantial damageNTSB SEA98FA164Accident · 2 fatalField investigationFinal reportNorth American SNJ-5C · Winlock, WAThe pilot's failure to maintain adequate altitude during attempted low-level aerobatics.Aug 14, 1998 · N766CA · DestroyedNTSB CHI98LA312Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Shelton, NEThe pilot mismanaged the fuel which led to fuel starvation and subsequent loss of engine power.Aug 14, 1998 · N88782 · Substantial damageNTSB MIA98LA222Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAThe pilot's failure to maintain airspeed resulting in a stall.Aug 12, 1998 · N8654L · Substantial damageNTSB IAD98FA092Accident · 1 fatalField investigationFinal reportAustin Revolution Mini 500 · Northampton, PAthe improper maintenance adjustment and the failure to properly torque the pitch-change link barrel by the owner/builder which resulted in main rotor to tailboom contact and main rotor separation.Aug 11, 1998 · N2XK · DestroyedNTSB LAX98LA262Accident · No injuriesLimited investigationFinal reportCessna 150M · Santa Paula, CAFailure of the number one cylinder due to a fatigue crack that had originated from corrosion pits at the cooling fin.Aug 10, 1998 · N704UV · Substantial damageNTSB SEA98GA159Accident · No injuriesFinal reportBell 212 · Juntura, ORThe pilot-in-command's failure to maintain proper clearance between the long line cable and hell hole structure resulting in airframe contact and binding of the cable. This resulted in separation/disabling of the fuel control solenoid and a subsequent…Aug 8, 1998 · N291B · Substantial damageNTSB FTW98LA355Accident · No injuriesLimited investigationFinal reportCrane Quicksilver Sport 2 · Glenn Heights, TXThe loss of engine power as the result of the owner/pilot's failure to install and adjust the proper carburetor jets. A factor was the lack of suitable terrain for the forced landing.Aug 8, 1998 · N4562G · Substantial damageNTSB CHI98LA306Accident · Minor injuriesLimited investigationFinal reportRockwell S2R · Kindred, NDthe pilot did not maintain clearance with obstructions along his flight path.Aug 8, 1998 · N5524X · DestroyedNTSB ATL98LA107Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Dothan, ALFuel Exhaustion due to the pilot's improper fuel consumption calculations. A factor was the power line.Aug 8, 1998 · N5033X · Substantial damageNTSB FTW98LA356Accident · No injuriesLimited investigationFinal reportHughes 269B · Uvalde, TXThe pilot's failure to maintain control during a vertical, out of ground effect takeoff which resulted in a hard emergency landing. Factors were; the exceeded hover performance of the helicopter, the high density altitude, and the lack of suitable terrain for…Aug 7, 1998 · N9425F · Substantial damageNTSB FTW98LA345Accident · Minor injuriesLimited investigationFinal reportFennell VP2 · Collinsville, OKThe loose throttle control cable resulting in the loss of engine power. A factor was the pilot's decision to intentionally stall the airplane close to the ground during the forced landing to an open field.Aug 6, 1998 · N2099J · DestroyedNTSB FTW98FA344Accident · 4 fatalField investigationFinal reportCessna T210N · Creede, COThe pilot's failure to maintain flying airspeed and the subsequent stall/spin. A contributing factor was high density altitude.Aug 6, 1998 · N2WF · DestroyedNTSB LAX98LA255Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Nelson, CAThe pilot's failure to maintain an adequate ground clearance altitude while applying chemicals to a rice field.Aug 3, 1998 · N8388 · DestroyedNTSB MIA98TA215Accident · No injuriesFinal reportHughes TH-55A · Savannah, GAThe loss of engine power for an undetermined reason, resulting in a forced landing, and an in-flight collision with a ditch. A factor in this accident was a high density altitude.Jul 31, 1998 · N998MC · DestroyedNTSB CHI98LA291Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Plainview, MNThe pilot's not achieving the proper descent rate prior to touchdown. A factor related to the accident was fuel starvation due to a low fuel level.Jul 30, 1998 · N90529 · Substantial damageNTSB MIA98LA214Accident · No injuriesLimited investigationFinal reportBell 47-D1 · Monticello, MSthe pilot's failure to maintain control of the helicopter while maneuvering resulting in the main rotor blades striking the ground.Jul 29, 1998 · N1016A · Substantial damageNTSB MIA98LA209Accident · No injuriesLimited investigationFinal reportCessna A-188B · Zolfo Springs, FLTotal loss of engine power due to catastrophic internal engine failure caused by migration of a counterweight retaining.Jul 27, 1998 · N21676 · Substantial damageNTSB SEA98LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Columbus, MTPartial loss of power for undetermined reasons. Factors include the pilot's selection of unsuitable terrain for a precautionary landing.Jul 26, 1998 · N1252C · Substantial damageNTSB ANC98FA110Accident · 2 fatalField investigationFinal reportYakovlev YAK-54 · Anchorage, AKThe pilot's inadequate remedial action to recover from an inverted spin, while performing aerobatics. Contributing factors were the lower than recommended entry altitude for a spin and the pilot's lack of familiarity with the accident airplane.Jul 26, 1998 · N354AM · DestroyedNTSB ANC98LA109Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Skwentna, AKA loss of engine power due to a fractured number three cylinder intake manifold flange, and the pilot's inability to maintain the proper rate of descent during the autorotation flare. A contributing factor associated with the accident was the downwind…Jul 25, 1998 · N8622U · Substantial damageNTSB SEA98LA147Accident · Minor injuriesLimited investigationFinal reportPilgrim Steen Skybolt · Curtis, WALoss of control for undetermined reasons.Jul 24, 1998 · N21SP · Substantial damageNTSB SEA98LA146Accident · Serious injuriesLimited investigationFinal reportGarlick UH-1H · Libby, MTA failure of the external load cable, which became entangled in the tail rotor.Jul 24, 1998 · N83NW · Substantial damageNTSB FTW98TA328Accident · Minor injuriesFinal reportBell 206L-3 · Reklaw, TXThe pilot's failure to maintain proper alignment in that the external load was not centered during sling operation, which resulted in entanglement of the load with the landing gear, and the loss of aircraft control.Jul 24, 1998 · N42489 · Substantial damageNTSB LAX98LA240Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Tracy, CAThe failure of the pilot to maintain an adequate clearance with the telephone wires.Jul 22, 1998 · N7442 · DestroyedNTSB FTW98LA327Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Englewood, COAn encounter with unanticipated windshear or a downdraft.Jul 22, 1998 · N8350N · DestroyedNTSB LAX98LA238Accident · No injuriesLimited investigationFinal reportAyres S2R · Shafter, CAThe pilot's failure to maintain an adequate clearance from the irrigation standpipe due to glare from the rising sun.Jul 21, 1998 · N8960Q · Substantial damageNTSB NYC98LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Philippi, WVWas the failure of an exhaust valve. A factor in the accident was the unsuitable landing area encountered by the pilot.Jul 20, 1998 · N69193 · Substantial damageNTSB FTW98FA316Accident · 1 fatalField investigationFinal reportNord Stampe SV4C · Ovilla, TXthe pilot's failure to maintain control of the aircraft while performing aerobatic maneuvers.Jul 20, 1998 · N123SV · DestroyedNTSB SEA98LA142Accident · No injuriesLimited investigationFinal reportSocata Rallye 235E · Kalispell, MTThe pilot-in-command's improper fuel management, resulting in fuel starvation. Related factors were insufficient altitude available for effective remedial action, and lack of suitable terrain for a forced landing.Jul 18, 1998 · N301RA · Substantial damage