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 FTW92LA113Accident · 1 fatalLimited investigationFinal reportBoeing A75N1 · Lawton, OKThe pilots'decision to fly into marginal VFR weather. A factor was the guy wire and fog.Apr 11, 1992 · N52653 · Substantial damageNTSB MIA92FA108Accident · 2 fatalField investigationFinal reportGlobe GC1-B · Miami, FLAn abrupt pitch up maneuver during acrobatic flight resulting in an overload failure of the right wing spar.Apr 9, 1992 · N90379 · DestroyedNTSB ATL92LA075Accident · No injuriesLimited investigationFinal reportKaman HH-43F · Manteo, NCThe pilot's improper use of the flight controls, in that he inadvertently activated the tail rotor pedals. Factors in the accident were the cross wind, and the slope of the landing area.Apr 9, 1992 · N100PL · Substantial damageNTSB FTW92LA108Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Chromo, COEncounter with down draft.Apr 7, 1992 · N3358T · Substantial damageNTSB LAX92LA166Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1B · Cucamonga, CAThe pilot's failure to maintain an adequate altitude to avoid colliding into the rising terrain of the box canyon. A factor in the accident was the pilot having been distracted by an engine gage.Apr 5, 1992 · N3319K · DestroyedNTSB LAX92FA169Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Cucamonga, CAThe pilot's failure to maintain an adequate altitude to avoid the rising terrain of the box canyon, and, his failure to maintain an adequate airspeed margin above stall while maneuvering in an attempt to reverse course. A factor in the accident was the pilot…Apr 5, 1992 · N302CB · DestroyedNTSB LAX92FA164Accident · Serious injuriesField investigationFinal reportCessna 172N · Claremont, CAThe pilots improper preflight and inflight planning/decisions, his continued VFR flight into IMC conditions, and his failure to initiate timely remedial actions.Apr 5, 1992 · N1333E · Substantial damageNTSB FTW92LA103Accident · No injuriesLimited investigationFinal reportSnow S2C · Roby, TXThe pilot's inadvertent stall of the airplane while maneuvering and subsequent loss of control.Apr 3, 1992 · N1619S · Substantial damageNTSB LAX92LA159Accident · No injuriesLimited investigationFinal reportBell 206BIII · Kaaawa, HIAn engine flame out due to the pilot's intentional flight through an irrigation sprinkler system water stream in order to wash the helicopter.Apr 1, 1992 · N3200N · Substantial damageNTSB FTW92LA109Accident · No injuriesLimited investigationFinal reportCessna T188C · Cordel, OKThe animals in the landing area. A factor was the loss of engine power for undetermined reasons.Mar 31, 1992 · N2695J · Substantial damageNTSB FTW92LA101Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Weatherford, OKFuel starvation due to a mechanical failure of the fuel selector. A factor was the lack of suitable terrain.Mar 30, 1992 · N1268W · Substantial damageNTSB DEN92DTE01Accident · 2 fatalFinal reportVans RV-4 · Bennett, COLoss of control by the pilot in command. A factor was: aircraft weight and balance limits exceeded.Mar 29, 1992 · N14BA · DestroyedNTSB BFO92LA049Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Phillipsburg, OHThe loss of control due to inadequate rotor RPM.Mar 28, 1992 · N133MB · Substantial damageNTSB LAX92FA149Accident · Serious injuriesField investigationFinal reportAyres S2R-T34 · Bakersfield, CAA catastrophic wing spar failure precipitated by hidden corrosion and the restricted view of the area of corrosion by the airplane's wing structure.Mar 23, 1992 · N59SK · DestroyedNTSB BFO92FLQ01Accident · 1 fatalFinal reportJames D. Riehm Rotorway Exec · Bowling Green, KYThe pilot's failure to maintain adequate rotor RPM which resulted in the inflight loss of control. Contributing to the accident was the pilot's lack of experience and overconfidence in his ability.Mar 23, 1992 · N191JD · Substantial damageNTSB ANC92LA051Accident · Minor injuriesLimited investigationFinal reportAeronca 15AC · Port Alsworth, AKThe pilot inadvertently conducted VFR flight into IMC conditions. Contributing factors were low ceilings, snow, rain, icing conditions, and whiteout conditions.Mar 23, 1992 · N1469H · Substantial damageNTSB LAX92LA148Accident · Minor injuriesLimited investigationFinal reportCessna 150M · San Andreas, CAThe flight instructor's poor inflight planning/decision by performing a 360 degree turn maneuver at a low altitude.Mar 22, 1992 · N2869V · DestroyedNTSB LAX92LA146Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Huron, CAA separation of the control rotor cuff due to fatigue.Mar 21, 1992 · N93478 · DestroyedNTSB FTW92LA093Accident · Serious injuriesLimited investigationFinal reportBoeing A-75N1 · Edna, TXThe pilot's failure to maintain control of the airplane and the subsequent stall. A factor was the pilot's diversion of attention.Mar 19, 1992 · N53084 · DestroyedNTSB CHI92DCJ02Accident · 2 fatalFinal reportExtra Flugzeugbau 300 · Grant, NEThe pilot's inadequate aircraft control while performing aerobatic maneuvers.Mar 15, 1992 · N300MT · Substantial damageNTSB MIA92LA096Accident · 2 fatalLimited investigationFinal reportAnkerman, Donald L. SX300 · Okeechobee, FLFailure of the pilot-in-command to maintain airspeed (vs) resulting in inadvertent stall/mush.Mar 11, 1992 · N11AG · DestroyedNTSB ANC92LA046Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A-150 · Golovin, AKProper altitude was not maintained. Factors to the accident were: inadvertent VFR flight into IMC, fog, snow, and night.Mar 10, 1992 · N7685D · Substantial damageNTSB SEA92LA057Accident · 2 fatalLimited investigationFinal reportRobert L. Rice Davis DA-2A · Billings, MTThe failure of the pilot to maintain terrain clearance. Factors relating to the accident were the pilot's lack of experience and the rising terrain in the area.Mar 8, 1992 · N48BR · DestroyedNTSB SEA92LA056Accident · 1 fatalLimited investigationFinal reportAero Commander S-2R · Dufur, ORThe pilot in command's misjudgment of clearance with the power lines. Factors contributing to the accident were: object (transmission wire) and safety system (not installed).Mar 8, 1992 · N1763S · DestroyedNTSB FTW92LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Mangum, OKThe pilot's failure to maintain proper airplane altitude. A factor was the dark night.Mar 8, 1992 · N8287W · Substantial damageNTSB ATL92LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawrenceville, GALoss of engine power for undetermined reasons.Mar 8, 1992 · N67772 · Substantial damageNTSB ATL92LA056Accident · Serious injuriesLimited investigationFinal reportJR. Ace E · Statesville, NCThe pilot's failure to maintain altitude during a steep turn at low level.Mar 8, 1992 · N1337M · Substantial damageNTSB ANC92FA044Accident · Serious injuriesField investigationFinal reportBell 214B-1 · Hobart Bay, AKFatigue failure of the compressor assembly impeller, and inadequate quality control by the manufacturer. A factor which contributed to the accident was the mountainous/hilly terrain.Mar 6, 1992 · N314RM · Substantial damageNTSB FTW92GA080Accident · No injuriesFinal reportBell 206B III · Falfurrias, TXThe pilot's failure to maintain directional control due to his ability to maintain an adequate visual lookout being restricted. Factors were the observer's delay in informing the pilot of the rearward drift and the dark night conditions.Mar 3, 1992 · N3201R · Substantial damageNTSB LAX92LA134Accident · No injuriesLimited investigationFinal reportBell 206BIII · Glenbrook, NVFailure of the pilot-in-command to follow the helicopter's performance data while translating out of translational lift to and out of ground effect.Mar 2, 1992 · N59613 · Substantial damageNTSB LAX92LA133Accident · Minor injuriesLimited investigationFinal reportHelio HST-550A · Salome, AZThe pilot's inadequate in-flight planning, improper altitude, and delaying the required remedial action to prevent the collision with the mountain. Contributing to the accident was the unfavorable wind and downdraft conditions.Mar 1, 1992 · N550HZ · DestroyedNTSB LAX92LA131Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Vernalis, CAThe operator's failure to properly comply with an airworthiness directive affecting the second-stage turbine wheel assembly. Contributing to this accident was the uncontained failure of the second-stage turbine wheel and the rough/uneven terrain.Feb 29, 1992 · N5408 · Substantial damageNTSB MIA92LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Michigan City, MSPartial loss of engine power due to undetermined reasons.Feb 28, 1992 · N6341B · Substantial damageNTSB NYC92LA066Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Gibson Island, MDThe pilot's failure to maintain proper altitude and clearance with water, which resulted in an in flight collision with water. Contributing to the accident was the pilot allowed the airplane to descend while making a right turn.Feb 23, 1992 · N96023 · Substantial damageNTSB LAX92LA365Accident · 2 fatalLimited investigationFinal reportChristen Industries Eagle II · Point Reyes Stn, CAImproper preflight planning by the pilot in command by exceeding the airplane's maximum acrobatic gross weight and exceeding the aft aerobatic center of gravity limit. Contributing to the accident was the pilot's decision to perform acrobatic maneuvers which…Feb 23, 1992 · N24CE · DestroyedNTSB LAX92LA125Accident · No injuriesLimited investigationFinal reportCessna 182N · San Ardo, CAThe pilot's inadequate preflight inspection. Contributing to this accident was water contamination in the fuel and the soft soil landing area.Feb 23, 1992 · N8948G · Substantial damageNTSB FTW92FA073Accident · Serious injuriesField investigationFinal reportCessna 150 · Clarksville, ARThe pilots inadvertent stall. A factor was the operator's inadequate supervision.Feb 22, 1992 · N7896E · Substantial damageNTSB SEA92FA049Accident · 2 fatalField investigationFinal reportCessna 150M · Pullman, WAPoor inflight planning/decision. Factors to the accident were bright night conditions and clearance not maintained.Feb 17, 1992 · N66473 · DestroyedNTSB LAX92FA120Accident · 7 fatalField investigationFinal reportPiper PA-31T-II · Big Bear, CAThe pilot's poor judgement in continuing visual flight into instrument meteorological conditions, in mountainous terrain obscured by clouds. Factors in the accident were: the pilot's failure to obtain a preflight weather briefing, the weather conditions, and…Feb 17, 1992 · N60AW · DestroyedNTSB LAX92LA118Accident · Minor injuriesLimited investigationFinal reportAvions Mudry CAP-10B · Santa Paula, CAThe failure of the airplanes's left wing spar due to stress overloading caused by pre-existing compression failures in the laminate.Feb 15, 1992 · N64ND · DestroyedNTSB NYC92FA059Accident · 3 fatalField investigationFinal reportPiper PA-32-301 · Heath, OHAn inadvertent stall with insufficient altitude for recovery. An additional cause was the pilot's self induced pressure to complete the fight in known adverse weather, and to deviate from the published instrument approach procedure. Factors related to the…Feb 14, 1992 · N4380T · DestroyedNTSB FTW92LA069Accident · Serious injuriesLimited investigationFinal reportRalph Legate Stits Skycoup · Conway, ARThe pilot's failure to maintain proper clearance with the guy wire. A factor was the fuel starvation caused by failure of the carburetor float.Feb 13, 1992 · N92RL · DestroyedNTSB SEA92FA046Accident · 2 fatalField investigationFinal reportGrumman American AA-5B · West Glacier, MTThe inflight encounter with IMC weather by the non-instrument rated pilot. Factors relating to the accident were the weather conditions, the mountainous/hilly terrain, and lack of instrument qualification by the pilot.Feb 12, 1992 · CGRRZ · DestroyedNTSB FTW92FA067Accident · 2 fatalField investigationFinal reportCessna 150M · Covington, OKThe pilot failed to maintain proper object clearance. A factor was his decision to perform the low pass.Feb 9, 1992 · N3966V · DestroyedNTSB DEN92LA032Accident · No injuriesLimited investigationFinal reportCessna 172 · Delta, COA complete power loss for undetermined reasons. A factor in the accident was: unsuitable terrain on which to conduct an emergency landing.Feb 9, 1992 · N8242B · Substantial damageNTSB MIA92LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Fernandina Bch, FLSpatial disorientation and failure of the pilot-in-command to set the altimeter to the field elevation prior to departure. Contributing to the accident was the pilot's lack of total and recent experience.Feb 8, 1992 · N8346B · Substantial damageNTSB LAX92FA112Accident · 2 fatalField investigationFinal reportCessna 150H · N. Palm Springs, CAThe pilot's failure to maintain airspeed during low altitude maneuvers as a result of his physical impairment due to alcohol and drugs. Factors which contributed to the accident were: the pilot's poor judgement in buzzing his work locale, and his failure to…Feb 7, 1992 · N22357 · DestroyedNTSB LAX92LA110Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Greenfield, CAThe pilot's failure to maintain adequate altitude during an intentionally performed low altitude flight in mountainous terrain. Contributing factors related to the pilot's visual perception of the canyon area because of changes in the ambient lighting…Feb 5, 1992 · N8507H · DestroyedNTSB LAX92LA109Accident · 1 fatalLimited investigationFinal report85 Manista KB-2 · Rosamond, CAThe pilot's failure to maintain main rotor RPM adequate to avoid flapping. Factors which contributed to the accident were related to the pilot's performance of an excessively abrupt maneuver.Feb 4, 1992 · N169RM · DestroyedNTSB CHI92FAMS1Accident · 2 fatalMissing aircraftFinal reportBeech 95-BE55 · Benton Harbor, MIUndetermined.Feb 3, 1992 · N1123B · Destroyed