OpenAirDocs.org

NTSB investigations

18,849 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 CEN12LA553Accident · Minor injuriesLimited investigationFinal reportSchleicher ASG29-15M · Uvalde, TXThe glider pilot’s inadequate visual lookout and collision avoidance just after joining a thermal in which other gliders were operating, which resulted in a midair collision with another glider.Aug 17, 2012 · F-CIFB · 2 aircraft · Minor damageNTSB CEN12LA552Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Tribune, KSThe pilot's failure to maintain clearance from a corn crop.Aug 17, 2012 · N6006J · Substantial damageNTSB CEN12CA555Accident · Minor injuriesData collectionFinal reportBrown Mitch Challenger II · Dexter, MOThe operation of an airplane by a noncertificated pilot and his failure to maintain clearance from power lines during low-level flight.Aug 15, 2012 · N167MB · Substantial damageNTSB CEN12CA544Accident · Serious injuriesData collectionFinal reportSchweizer, N36289 G-164B · Kaplan, LAThe pilot's failure to maintain clearance from power lines during the aerial application flight.Aug 15, 2012 · N36289 · Substantial damageNTSB CEN12CA546Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · Hanley Falls, MNThe pilot’s failure to maintain clearance from a guy wire during an agricultural application pass.Aug 14, 2012 · N1021D · Substantial damageNTSB WPR12CA351Accident · Minor injuriesData collectionFinal reportRobinson R22 · Monticello, UTThe pilot's failure to maintain adequate main rotor rpm while maneuvering at a low altitude, which resulted in the helicopter settling and subsequently colliding with the ground. Contributing to the accident was that the pilot had insufficient altitude to…Aug 11, 2012 · N7135J · Substantial damageNTSB ERA12LA500Accident · No injuriesLimited investigationFinal reportBeech V35B · Effingham, SCThe pilot's failure to avoid an encounter with known adverse weather conditions, which resulted in an in-flight upset, temporary loss of control, and loading of the airframe, engine, and propeller that led to the in-flight separation of the propeller and the…Aug 11, 2012 · N11JK · Substantial damageNTSB CEN12LA637Accident · No injuriesLimited investigationFinal reportSackman Sackman Special · Ste. Genevieve, MOThe loss of engine power during a low level maneuver due to oil starvation for reasons that could not be determined during postaccident examination.Aug 11, 2012 · N4760R · Substantial damageNTSB CEN12FA534Accident · 1 fatalField investigationFinal reportBeech G18 - S · Taylorville, ILThe pilot's failure to maintain adequate airspeed and use the appropriate flaps setting during sport-parachuting operations, which resulted in an aerodynamic stall/spin and a subsequent loss of control. Contributing to the accident was the pilot’s failure to…Aug 11, 2012 · N697Q · Substantial damageNTSB WPR12LA347Accident · Minor injuriesLimited investigationFinal reportHiller UH-12D · Deer Island, ORA loss of helicopter control while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Aug 7, 2012 · N47035 · Substantial damageNTSB CEN12LA525Accident · No injuriesLimited investigationFinal reportBell 214ST · Avalon, TXMaintenance personnel’s failure to properly torque the retaining nut and install the cotter pin that secured the helicopter’s tail rotor counterweight bellcrank. Contributing to the accident was the lack of detailed maintenance records that documented…Aug 7, 2012 · N409SB · Substantial damageNTSB CEN12LA524Accident · No injuriesLimited investigationFinal reportCessna 177B · Carthage, TXThe loss of engine power during a low-level aerial observation flight as the result of the wearing of the rocker arm tip due to a thin carburized case layer, which resulted in a forced landing.Aug 7, 2012 · N17201 · Substantial damageNTSB CEN12CA533Accident · No injuriesData collectionFinal reportThrush S-2R · Newkirk, OKThe pilot’s failure to maintain clearance from power lines.Aug 7, 2012 · N5596X · Substantial damageNTSB CEN12FA521Accident · No injuriesField investigationFinal reportAyres S2R-T34 · Lakin, KSThe pilot's failure to maintain clearance from the corn during an aerial application flight.Aug 6, 2012 · N365SM · Substantial damageNTSB CEN12FA517Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Imperial, NEThe pilot’s failure to maintain adequate clearance from rising terrain while flying toward the rising sun, which interfered with his ability to see the terrain.Aug 4, 2012 · N36286 · Substantial damageNTSB ERA12CA495Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Alexander, NYThe pilot's inadequate visual lookout and failure to maintain altitude during aerial application, which resulted in controlled flight into terrain.Aug 2, 2012 · N6802L · Substantial damageNTSB ERA12LA493Accident · No injuriesLimited investigationFinal reportSikorsky S-58JT · Middletown, DEThe pilot's failure to recognize that the helicopter was experiencing tail rotor dynamic instability and to take immediate corrective actions during an external load lift, which resulted in the failure of a tail rotor blade.Aug 1, 2012 · N126GW · Substantial damageNTSB CEN12LA549Accident · No injuriesLimited investigationFinal reportCessna 182D · Rose Hill, KSThe inadvertent deployment of a skydiver's parachute, which struck the right horizontal stabilizer.Jul 28, 2012 · N8882X · Substantial damageNTSB CEN12CA484Accident · Serious injuriesData collectionFinal reportBell 47G-2A · Austin, INThe pilot did not maintain clearance from terrain during a low-level aerial application flight and lost control of the helicopter.Jul 27, 2012 · N652HA · Substantial damageNTSB WPR12LA328Accident · Serious injuriesLimited investigationFinal reportHughes Helicopters 369E · The Dalles, ORThe loss of engine power due to fuel starvation, which resulted from the fuel tank supply pickup becoming unported while the helicopter was pulling power lines.Jul 26, 2012 · N427WC · Substantial damageNTSB ERA12LA482Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Green Creek, NJThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel starvation while maneuvering.Jul 26, 2012 · N4361M · Substantial damageNTSB CEN12IA498Incident · No injuriesIncident investigationFinal reportAmerican Champion 8KCAB · Oshkosh, WIThe failure of the pilot’s seat bottom frame due to the manufacturer’s improper production, installation, and inspection of that seat bottom, which resulted in a temporary loss of control during an air show performance.Jul 26, 2012 · N60GK · No damageNTSB CEN12LA480Accident · Minor injuriesLimited investigationFinal reportScotts-Bell 47 47G-2A · Akeley, MNThe pilot’s failure to maintain helicopter control during low altitude agricultural operations.Jul 25, 2012 · N73252 · Substantial damageNTSB ERA12LA477Accident · No injuriesLimited investigationFinal reportHughes 269C · St. Petersburg, FLThe pilot's failure to assure that the lateral friction control was released prior to flight.Jul 24, 2012 · N9679F · Substantial damageNTSB CEN12LA466Accident · 1 fatalLimited investigationFinal reportToman Jack JR Skystar Kitfox 4 · Cross Lake, MNThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's impairment due to marijuana.Jul 22, 2012 · N602JT · Substantial damageNTSB CEN12LA483Accident · Serious injuriesLimited investigationFinal reportEipper Quicksilver MXL II · Goodrich, MIThe operation of an unregistered and unairworthy airplane by a non-certificated pilot. Contributing to the accident was the non-certificated pilot’s improper preflight inspection, which resulted in a total loss of engine power due to water/debris…Jul 21, 2012 · UNREG · Substantial damageNTSB CEN12CA464Accident · Serious injuriesData collectionFinal reportBertram William J Bertram 2000 · Shiocton, WIThe pilot’s distraction with taking photographs, which resulted in his failure to maintain sufficient altitude to avoid the guy wire.Jul 21, 2012 · N115WB · Substantial damageNTSB ERA12FA467Accident · 1 fatalField investigationFinal reportBrenholt Larry R RV-4 · Cedartown, GAThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions and his failure to maintain airspeed while maneuvering for a forced landing, which resulted in an aerodynamic stall and collision with terrain.Jul 20, 2012 · N25UA · Substantial damageNTSB CEN12LA491Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Fergus Falls, MNA total loss of engine power due to a cracked No. 2 cylinder head.Jul 20, 2012 · N4638 · Substantial damageNTSB ERA12FA465Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Berlin, MDPilot incapacitation of unknown origin, which resulted in the airplane’s loss of control and an inadvertent aerodynamic stall/spin.Jul 19, 2012 · N4330Z · Substantial damageNTSB ERA12LA468Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · North Myrtle Beach, SCA total loss of engine power due to carburetor icing.Jul 18, 2012 · N2991Z · Substantial damageNTSB CEN12LA453Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402B · Britt, IAThe pilot’s failure to maintain clearance from power transmission lines during an agricultural application operation. Contributing to the accident was the pilot’s distracted attention due to personal cell phone use during flight operations.Jul 17, 2012 · N4843J · Substantial damageNTSB ERA12LA453Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · North Myrtle Beach, SCThe pilot's inadequate use of carburetor heat during cruise flight, which resulted in a partial loss of engine power and subsequent forced landing.Jul 15, 2012 · N8048D · Substantial damageNTSB WPR12CA303Accident · No injuriesData collectionFinal reportSud Aviation/Eurocopter Alouette II SE313B · Glenn, CAThe pilot's inadequate compensation for a tailwind while hovering, which resulted in a loss of directional control.Jul 13, 2012 · N45VX · Substantial damageNTSB CEN12LA440Accident · 1 fatalLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Darksville, MOThe pilot did not maintain clearance from a tree line at the completion of an agricultural spray run.Jul 13, 2012 · N6846Q · Substantial damageNTSB CEN12LA437Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Mott, NDThe rupture of a corroded oil line, which resulted in a total loss of engine power due to oil starvation.Jul 12, 2012 · N8801L · Substantial damageNTSB WPR12LA301Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Cheyenne, WYThe pilot's failure to maintain clearance with a power line. Contributing to the accident was the sun's glare.Jul 10, 2012 · N4831R · Substantial damageNTSB ERA12WA463Accident · 1 fatalClass 5 · ForeignPiper PA36 · San Alberto, ColombiaOn July 10, 2012, about 1230 universal coordinated time, a Piper PA-36-375, Colombian registration HK2210, operated by Aeropenort LTDA. Agropecuaria del Norte, was substantially damaged when it collided with trees, during an aerial application flight near San…Jul 10, 2012 · HK2210 · Substantial damageNTSB CEN12LA508Accident · Serious injuriesLimited investigationFinal reportCessna 172M · South Wayne, WIInternal engine component failures, which resulted from oil starvation due to debris in the oil system.Jul 10, 2012 · N12504 · Substantial damageNTSB WPR12FA298Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Murrieta, CAThe pilot's failure to maintain clearance from high vegetation while making a hovering turn, which resulted in a dynamic rollover.Jul 9, 2012 · N7527Y · Substantial damageNTSB CEN12CA435Accident · No injuriesData collectionFinal reportBell 47G-3B-2 · Treynor, IAThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Jul 9, 2012 · N2919W · Substantial damageNTSB CEN12LA458Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Egeland, NDThe partial loss of engine power for reasons that could not be determined during postaccident examinations.Jul 7, 2012 · N6583 · Substantial damageNTSB CEN12LA427Accident · Serious injuriesLimited investigationFinal reportMurray Richard F Aircam BY Lockwood · Taos, NMThe pilot's decision to fly in gusty wind conditions at low altitude over mountainous terrain contrary to guidance in the airplane flight manual and subsequent loss of airplane control due to wind and turbulence.Jul 7, 2012 · N984AT · Substantial damageNTSB CEN12FA421Accident · 1 fatalField investigationFinal reportBeech E90 · Karnack, TXThe pilot's inadvertent flight into thunderstorm activity, which resulted in the loss of airplane control and the subsequent exceedance of the airplane's design limits and in-flight breakup. Contributing to the accident was the failure of air traffic control…Jul 7, 2012 · N987GM · DestroyedNTSB ERA12WA451Accident · 1 fatalForeign investigationEmbraer EMB820 · Espinosa Municipality, BrazilOn July 6, 2012, at 1340 Universal Coordinated Time (UTC), a Piper PA-31-350 (Embraer 820C), Brazilian registration PT-ENG, operated by Microsurvev Aerogeof. E Cons. Cient. Ltda, was destroyed during a forced landing following a loss of power to both engines.…Jul 6, 2012 · PT-ENG · DestroyedNTSB CEN12CA431Accident · No injuriesData collectionFinal reportSchweizer 269C · Denton, TXThe flight instructor and student pilot exceeded the helicopter's takeoff performance, which resulted in low rotor rpm and settling.Jul 6, 2012 · N565LH · Substantial damageNTSB ANC12CA067Accident · No injuriesData collectionFinal reportCessna 207A · Kotlik, AKThe pilot's failure to maintain altitude/clearance from terrain during cruise flight at low altitude, which resulted in an in-flight collision with water. A contributing factor was the pilot’s diverted attention to adjust the engine power.Jul 6, 2012 · N2162C · Substantial damageNTSB WPR12FA295Accident · 2 fatalField investigationFinal reportTL Ultralight Sro Stingsport · Piru, CAThe pilot’s failure to recover from a stall, which resulted in a spin. Contributing to the accident was the instructor’s inadequate remedial action.Jul 5, 2012 · N177N · Substantial damageNTSB ERA12LA429Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Tallahassee, FLThe pilot’s failure to maintain awareness of the helicopter’s altitude while attempting to troubleshoot the clutch actuator warning light, which resulted in an inadvertent descent and impact with water. Contributing to the accident was the pilot's possible…Jul 4, 2012 · N561CH · Substantial damageNTSB CEN12CA423Accident · Serious injuriesData collectionFinal reportEipper Quicksilver · Manvel, NDThe non-certificated pilot’s failure to maintain clearance from a wheat field.Jul 3, 2012 · UNREG · Substantial damage