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 LAX92LA105Accident · 1 fatalLimited investigationFinal reportCessna 170B · Austin, NVThe pilot's delay in reversing direction, his continued flight into instrument meteorological conditions, his failure to maintain adequate airspeed and inadvertent stall while maneuvering to reverse direction. Contributing to the accident was weather…Jan 28, 1992 · N39HP · Substantial damageNTSB MIA92LA069Accident · No injuriesLimited investigationFinal reportBell 47D1 · Cross City, FLPartial loss of engine power due to undetermined reasons and unsuitable terrain encountered during the autorotative landing.Jan 27, 1992 · N93067 · Substantial damageNTSB MIA92FA059Accident · 2 fatalField investigationFinal reportCessna 150L · Lake Alfred, FLThe pilot-in-command's inadvertent accelerated stall while buzzing at an altitude that precluded recovery.Jan 11, 1992 · N6032J · DestroyedNTSB LAX92LA087Accident · No injuriesLimited investigationFinal reportRobinson R22B · Lake Hughes, CAThe failure of the pilot to maintain rotor RPM while maneuvering and his misjudgement of the landing flare. A factor in the accident was the pilot's lack of total experience.Jan 11, 1992 · N2634N · Substantial damageNTSB SEA92LA036Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-35C · Hood River, ORPoor preflight planning and preparation along with the pilot's restricted visibility. Factors to the accident were: clouds and VFR flight into IMC.Jan 5, 1992 · N2818H · DestroyedNTSB CHI92DCJ01Accident · 2 fatalFinal reportPiper PA-18-125 · Ashby, NEThe pilot's failure to maintain aircraft control while maneuvering.Jan 5, 1992 · N1217A · Substantial damageNTSB MIA92LA054Accident · 1 fatalLimited investigationFinal reportSmith/Davis DA-2A · Holly Springs, MSThe pilot-in-command's improper management of fuel. This resulted in the airplane experiencing fuel exhaustion, forced landing, and in flight collision with terrain.Jan 4, 1992 · N3093 · DestroyedNTSB FTW92LA054Accident · 2 fatalLimited investigationFinal reportAlvin D. Campbell KR-2 · San Marcos, TXThe modification of the canopy hinge system which resulted in the loss of aircraft control due to an inflight canopy separation.Jan 4, 1992 · N651AC · DestroyedNTSB CHI92FA066Accident · 1 fatalField investigationFinal reportPiper PA-31P · Mosinee, WIAn inflight fire with the cabin heater as the origin, and unsuitable terrain in which to make a forced landing. A factor related to the accident was the soft terrain.Jan 2, 1992 · N500BH · DestroyedNTSB ANC92LA024Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Nome, AKThe pilot inadvertently stalled the airplane. Contributing to the accident was inadequate altitude.Jan 2, 1992 · N1930A · Substantial damageNTSB NYC92FA052Accident · 2 fatalField investigationFinal reportAeronca 7AC · Salisbury, CTThe pilot's failure to maintain airspeed while performing low altitude aerobatic maneuvers, resulting in a stall with insufficient altitude to recover. Factors related to the accident were the pilot's overconfidence in his ability to perform these maneuvers,…Dec 28, 1991 · N3103E · DestroyedNTSB CHI92FA062Accident · 2 fatalField investigationFinal reportCessna 172M · Sanford, MIThe pilot-in-command's failure to maintain a visual lookout to avoid a wire strike. Factors were the pilot-in-command's intentional low level flight, his failure to maintain proper altitude, and the transmission wires.Dec 27, 1991 · N6623H · DestroyedNTSB NYC92FA050Accident · 3 fatalField investigationFinal reportBeech A36 · Wilmington, OHThe failure of the pilots to maintain adequate terrain clearance. Factors which contributed to the accident were: the night conditions, reduced visibility due to fog, and the likelihood that the pilots diverted their attention to the operation of the loran…Dec 26, 1991 · N236JS · DestroyedNTSB LAX92LA070Accident · 2 fatalLimited investigationFinal reportBellanca 7KCAB · Happy Camp, CAThe excessive nature of the maneuvers attempted by the pilot at a low altitude during the takeoff initial climb, the failure of the pilot to maintain proper pitch attitude and airspeed to avoid an aerodynamic stall, and inadequate altitude to perfrom…Dec 25, 1991 · N1679G · DestroyedNTSB LAX92FA067Accident · 2 fatalField investigationFinal reportCessna 152 · Ventura, CAThe failure of the pilot to maintain adequate altitude above the ground to recover from an inadvertent stall. Contributing to the accident was the pilot's handling of the aircraft specifically an excessive angle of attack which resulted in reduced airspeed…Dec 22, 1991 · N69028 · DestroyedNTSB SEA92LA030Accident · Minor injuriesLimited investigationFinal reportArtic S-1B2 · Lysite, WYThe pilot's failure to maintain clearance with terrain. Factors contributing to the accident were rising terrain, downdrafts, and the pilot's inadequate compensation for wind conditions.Dec 21, 1991 · N71AT · Substantial damageNTSB NYC92LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Goshen, NYThe loss of engine power resulting from the ingestion of a foreign object into the carburetor and the subsequent forced landing in trees. A factor related to the accident was the maintenance performed on the airplane by unauthorized personnel.Dec 18, 1991 · N55685 · Substantial damageNTSB MIA92LA048Accident · Serious injuriesLimited investigationFinal reportPiper J-4E · Timmonsville, SCTotal loss of engine power (nonmechanical) due to inadequate fuel consumption calculation by the pilot-in-command, resulting in an engine failure due to fuel exhaustion, a forced landing, and in-flight collision with terrain.Dec 15, 1991 · N38153 · Substantial damageNTSB FTW92LA047Accident · No injuriesLimited investigationFinal reportCessna 182D · Carlisle, ARThe parachute jumper's reserve parachute inadvertently opening, for undetermined reasons, resulting in the jumper impacting the right horizontal stabilizer.Dec 15, 1991 · N8883X · Substantial damageNTSB MIA92LA042Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Charlotte, NCThe pilot in commands failure to maintain tailrotor ground clearance while hovering resulting in the tail striking the ground and the subsequent separation of the tailrotor and gearbox.Dec 12, 1991 · N206CM · Substantial damageNTSB CHI92DEV01Accident · Serious injuriesFinal reportQuickie Quickie 1 · Carmi, ILAn engine bearing seizure and a premature forced landing flare.Dec 11, 1991 · N1V · Substantial damageNTSB LAX92FA058Accident · 5 fatalField investigationFinal reportPiper PA31-350 · Temple Bar, AZThe pilot-in-command's poor inflight decision by not electing to proceed to an alternate airport and to continue to the flight under visual flight rules into instrument meteorological conditions. The low ceilings and visibilities across the flight route and…Dec 10, 1991 · N350MR · DestroyedNTSB FTW92LA038Accident · No injuriesLimited investigationFinal reportCessna 172B · Tulsa, OKClearance was not maintained and the airplane struck a wire. A factor was the aircraft had been stolen by two unknown individuals.Dec 5, 1991 · N6947X · Substantial damageNTSB LAX92LA046Accident · 2 fatalLimited investigationFinal reportBellanca 7ECA · Fremont, CAThe pilot-in-command's failure to maintain an airspeed above the stall speed. His over confidence in his personal ability, lack of familiarity with the aircraft, and his inadequate training in acrobatic flight were factors in the accident.Nov 19, 1991 · N36243 · DestroyedNTSB MIA92LA031Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Mariner · Ocala, FLThe pilot-in-command's improper use of collective control and throttle during recovery from an autorotation which resulted in loss of rotor RPM and a subsequent hard landing.Nov 17, 1991 · N4072U · Substantial damageNTSB FTW92FA022Accident · 2 fatalField investigationFinal reportCessna 310C · Waller, TXThe loss of directional control as result of the velocity minimum control airspeed not being maintained. A factor was that the maneuver was initiated at an inadequate altitude too low for the pilot to recover.Nov 16, 1991 · N6704T · DestroyedNTSB MIA92LA029Accident · Minor injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Florida City, FLPartial loss of engine power due to a loose intake manifold. Also, improper maintenance by an unknown person.Nov 15, 1991 · N4506K · Substantial damageNTSB MIA92LA028Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Groveland, FLPoor in-flight planning/decision by the pilot-in-command resulting in the off airport landing. Contributing to the accident was his lack of total experience.Nov 14, 1991 · N2890H · Substantial damageNTSB CHI92FA027Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Coffeyville, KSThe pilot's failure to maintain sufficient airspeed (above stall speed) during the emergency procedure. Related factors are the pilot's poor planning/decision, inattentiveness, and the weather (low ceiling, gusty tailwinds).Nov 14, 1991 · N5935P · DestroyedNTSB LAX92LA041Accident · Serious injuriesLimited investigationFinal reportBell 206B · Hilo, HIThe inadvertent encounter with a loss of tail rotor effectiveness phenomena and the resultant pilot inflight loss of control.Nov 9, 1991 · N16712 · Substantial damageNTSB MIA92GA024Accident · 1 fatalFinal reportCessna 172N · Okeechobee, FLThe pilot-in-command's failure to maintain altitude during a low pass at night. Contributing factors were the pilot's likely spatial disorientation due to the lack of surface visual clues, the dark night conditions, and the patchy fog conditions.Nov 8, 1991 · N739WS · DestroyedNTSB ANC92LA014Accident · No injuriesLimited investigationFinal reportCessna 170 · Whiskey Gulch, AKThe pilot's failure to maintain an airspeed above stalling during maneuvering flight. A factor relating to the accident was operating at an altitude inadequate in which to effect recovery.Nov 7, 1991 · N2584V · Substantial damageNTSB LAX92LA039Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Williams, AZThe pilot's failure to maintain visual lookout.Nov 4, 1991 · N5337K · DestroyedNTSB NYC92FA026Accident · 2 fatalField investigationFinal reportPiper L-3 · Plymouth, MAThe improper decision by the non-instrument-rated pilot to attempt VFR flight in instrument meteorological conditions, at a low altitude, which resulted in a collision with the water. Factors related to the accident were: the overconfidence of the pilot in…Nov 3, 1991 · N6AN · DestroyedNTSB NYC92LA024Accident · No injuriesLimited investigationFinal reportMaule M5-235C · Jim Thorpe, PAThe pilot's improper use of carburetor heat, resulting in carburetor ice and a loss of engine power and subsequent forced landing in trees. A factor related to the accident was the pilot's lack of experience in this make and model airplane.Nov 2, 1991 · N5634K · Substantial damageNTSB CHI92FA022Accident · 2 fatalField investigationFinal reportRockwell AC 690B · Milton, KSIncapacitation of the pilot in command, followed by the loss of control and an inflight breakup with a unqualified person on the controls.Nov 2, 1991 · N799V · DestroyedNTSB BFO92FA005Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · West Wardsboro, VTThe pilot's flight into known adverse weather. Contributing to the accident was the pilot's inadequate flight and weather planning.Oct 31, 1991 · N8855J · DestroyedNTSB FTW92FA014Accident · 2 fatalField investigationFinal reportBeech A36 · Marble Falls, TXThe pilot's performance of acrobatic maneuvers at an altitude too low to allow for recovery.Oct 27, 1991 · N7246H · DestroyedNTSB MIA92FA017Accident · Serious injuriesField investigationFinal reportCessna 152 · Valkaria, FLThe pilot-in-command's failure to maintain altitude while maneuvering. This resulted in the pilot becoming spatially disoriented and an in-flight collision with terrain. Contributing to the accident was the pilot's decision to operate the airplane with known…Oct 26, 1991 · N24431 · DestroyedNTSB LAX92FA025Accident · Minor injuriesField investigationFinal reportAerospatiale AS350B · Scottsdale, AZAn undetermined malfunction of the hydraulic system in which the system was locked, preventing the movement of the flight controls, and loss of directional control.Oct 26, 1991 · N9001S · Substantial damageNTSB NYC92DHA01Accident · 1 fatalFinal reportJesse Knight Long EZ · Milford, PAThe pilot's inadequate visual lookout.Oct 23, 1991 · N172JK · Substantial damageNTSB ATL92LA015Accident · No injuriesLimited investigationFinal reportBellanca 8JCAB · Morristown, TNThe pilot's failure to maintain a proper altitude during a low pass. A factor in this accident was the pilot's overconfidence in his personal ability.Oct 20, 1991 · N3770 · Substantial damageNTSB ATL92LA012Accident · Serious injuriesLimited investigationFinal reportDon Jackman Pitts S-1S · Franklinville, NCThe failure of the pilot to maintain proper clearance from the power line.Oct 19, 1991 · N4241Z · Substantial damageNTSB SEA92FA013Accident · 3 fatalField investigationFinal reportCessna 172N · Columbus, MTThe pilot in command's operation at too low an altitude over the river and his failure to maintain adequate clearance from the power lines. Factors contributing to the accident were the wires crossing the river and the pilot in command's poor judgement in…Oct 18, 1991 · N733QL · DestroyedNTSB SEA92FA222Accident · 3 fatalField investigationFinal reportMaule M-5-235C · Moran, WYThe pilot's failure to maintain clearance and altitude from terrain while maneuvering, and his failure to adequately compensate for the wind conditions. Factors contributing to the accident are terrain-induced turbulence, unfavorable winds, gusty high winds,…Oct 16, 1991 · N19AR · DestroyedNTSB LAX92LA014Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350D · Hilo, HI1) A loss of engine power due to the ingestion of gasses from the active volcano vent, and 2) the pilots inflight decision to hover downwind in close proximity to the vent.Oct 14, 1991 · N35961 · Substantial damageNTSB DEN92LA003Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Telluride, COThe pilot flying the aircraft at a height above ground level which was inadequate for recovery from an encounter with down drafts. A factor was: down draft encounter.Oct 13, 1991 · N4488Z · Substantial damageNTSB SEA92LA005Accident · No injuriesLimited investigationFinal reportHughes 269B · Hillsboro, ORThe failure to maintain rotor RPM. Factors include inadequate preflight planning, overconfidence in aircraft's ability, and non-suitable terrain.Oct 12, 1991 · N9474F · Substantial damageNTSB FTW92DPJ02Accident · 1 fatalFinal reportPiper PA-25 · Warner, OKThe complete loss of engine power for undetermined reason.Oct 10, 1991 · N8516L · DestroyedNTSB MIA92FA008Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Key West, FLFailure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin at an altitude that was too low for recovery. A factor related to the accident was: the pilot's failure to jettison the banner when the stall was encountered.Oct 8, 1991 · N4155Y · Substantial damage