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 ATL96LA076Accident · Serious injuriesLimited investigationFinal reportHiller UH12-E · Huger, SCThe blocked fuel vent line that resulted in engine stoppage. A factor was tall trees that intervened the helicopter's flight path.Apr 3, 1996 · N14MQ · Substantial damageNTSB LAX96LA146Accident · Serious injuriesLimited investigationFinal reportLuckett Flybaby 1A · Castiac, CAThe pilot's improper in-flight planning/decision. The terrain condition and low ceiling were related factors.Mar 29, 1996 · N71658 · DestroyedNTSB NYC96LA079Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1C · Groton, NYthe pilot's inadequate fuel management, and his improper use of the fuel selector valve, which resulted in fuel starvation and the subsequent collision with bails of hay during the forced landing.Mar 27, 1996 · N9974U · Substantial damageNTSB NYC96LA077Accident · No injuriesLimited investigationFinal reportRobinson R22-BETA · Fairfield, NJthe flight instructor's inadequate supervision in that he delayed corrective action in recovering the low rotor RPM resulting in a loss of control.Mar 23, 1996 · N221CW · Substantial damageNTSB ANC96LA037Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Cantwell, AKThe undetermined loss of engine power and lack of suitable terrain to make a forced landing.Mar 23, 1996 · N2431M · Substantial damageNTSB MIA96LA103Accident · No injuriesLimited investigationFinal reportRobinson R-22-BETA · Bunnell, FLthe flight instructor's failure to properly supervise the dual student and take corrective action before control was lost. Contributing to the accident was the dual student's overcontrol of the helicopter during hover.Mar 22, 1996 · N21077 · Substantial damageNTSB CHI96FA116Accident · 1 fatalField investigationFinal reportCirrus VK30 · Duluth, MNthe inadequate handling/performance design capabilities of the airplane which resulted in the inability to recover from an aft center of gravity spin. Factors were the lack of any antispin or deep stall recovery devices, and the aft center of gravity.Mar 22, 1996 · N44VK · DestroyedNTSB FTW96FA151Accident · 1 fatalField investigationFinal reportSukhoi SU-29 · New Orleans, LAThe in-flight loss of a bolt in the elevator control system due to improper installation by unknown person(s), which resulted in a disconnection of the elevator control system that rendered the airplane uncontrollable.Mar 21, 1996 · N729SU · DestroyedNTSB ATL96LA068Accident · No injuriesLimited investigationFinal reportBell 205A-1 · Grove Hill, ALfatigue failure of the vertical fin forward spar in an area that was not accessible to inspection. A factor relating to the accident was: guidance for inspection of the area (where the fatigue occurred) was insufficiently defined by the manufacturer.Mar 21, 1996 · N68HJ · Substantial damageNTSB SEA96LA070Accident · Minor injuriesLimited investigationFinal reportBell 206B · La Grande, ORthe pilot's failure to maintain clearance with trees after pulling up from an aerial application spray run.Mar 18, 1996 · N57362 · Substantial damageNTSB LAX96LA137Accident · 1 fatalLimited investigationFinal reportBumford GR-7 · Temecula, CAfailure of the pilot to maintain control of the airplane, while performing an aerobatic maneuver, which resulted in inadvertent entry into a spin. Factors relating to the accident were: the pilot's lack of recent experience in fixed wing aircraft, his lack of…Mar 17, 1996 · N555GR · DestroyedNTSB FTW96LA149Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28A · Killeen, TXThe pilot's improper planning/decision, which resulted in fuel exhaustion and a loss of engine power, due to an inadequate supply of fuel. A factor relating to the accident was: lack of suitable terrain for an emergency landing (autorotation).Mar 16, 1996 · N9574 · Substantial damageNTSB MIA96FA099Accident · 1 fatalField investigationFinal reportBeech A23A · Sarasota, FLThe pilot's failure to maintain airspeed while maneuvering (VSO) resulting in an inadvertent in-flight loss of control (stall/spin) and subsequent in-flight collision with terrain.Mar 15, 1996 · N2300W · DestroyedNTSB FTW96LA148Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Texarkana, ARa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Mar 15, 1996 · N4540C · Substantial damageNTSB CHI96LA108Accident · 1 fatalLimited investigationFinal reportBishop-Christian Eagle II · Cambridge, INthe pilot allowed the airplane to enter a flat spin, while performing an acrobatic maneuver, and was unable to recover before ground impact. Factors relating to the accident were: the pilot's overconfidence in his personal ability, and his lack of familiarity…Mar 15, 1996 · N219RC · DestroyedNTSB FTW96LA147Accident · Minor injuriesLimited investigationFinal reportBell 206BIII · Houma, LAthe pilot's attempted maneuver which exceeded the dynamic capability of the helicopter.Mar 12, 1996 · N115FH · Substantial damageNTSB CHI96LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Camp Lake, WIFailure of the pilot to maintain clearance from trees that were located beside the runway.Mar 12, 1996 · N2966U · Substantial damageNTSB ANC96LA029Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Ketchikan, AKloss of engine power for undetermined reason(s). A factor relating to the accident was: the lack of a suitable area for an emergency landing.Mar 4, 1996 · N739YR · Substantial damageNTSB CHI96FA099Accident · Serious injuriesField investigationFinal reportMcDonnell Douglas 369E · Manhattan, KSImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor relating to the accident was: pressure to meet a work schedule.Mar 3, 1996 · N7065C · Substantial damageNTSB FTW96LA135Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Winchester, ARFailure of the engine master rod. A factor relating to the accident was: the lack of suitable terrain for a forced landing, due to the proximity of a power line and trees.Feb 27, 1996 · N431BL · Substantial damageNTSB FTW96LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Dewitt, ARa loss of engine power due to the malfunction of the carburetor as a result of an improper overhaul. A factor was the unsuitable terrain for the forced landing.Feb 24, 1996 · N48435 · Substantial damageNTSB FTW96LA131Accident · No injuriesLimited investigationFinal reportRobinson R22B · Garland, TXFailure of the pilot to maintain sufficient altitude and tail rotor clearance from the terrain, while demonstrating rearward movement in a hover.Feb 24, 1996 · N8141L · Substantial damageNTSB MIA96LA086Accident · 1 fatalLimited investigationFinal reportNorth American SNJ-5 · West Palm Beach, FLFailure of the pilot to maintain adequate altitude/clearance above the water, while performing a low level maneuver (wing over). The pilot's ostentatious display of aerobatic flight was a related factor.Feb 23, 1996 · N4LH · DestroyedNTSB IAD96LA045Accident · Serious injuriesLimited investigationFinal reportAdvanced Technology Ultra Sport 254 · West Point, VAthe pilot's failure to maintain control of the helicopter during low altitude flight/maneuvering, which resulted in the helicopter impacting terrain. A related factor was the pilot's lack of flight experience in the make and model of helicopter.Feb 20, 1996 · N254AS · DestroyedNTSB ATL96FA051Accident · 1 fatalField investigationFinal reportSukhoi SU-31 · Immokalee, FLthe manufacturer's improper composite curing process, which resulted in wing spar voids and subsequent failure of the wing during aerobatic flight.Feb 20, 1996 · N31MX · DestroyedNTSB CHI96FA091Accident · 2 fatalField investigationFinal reportHughes 369D · Dweese, NEthe pilot's improper in-flight planning and decision, and his lack of total experience in the type of operation. A factor was the crosswind.Feb 19, 1996 · N5141Y · DestroyedNTSB LAX96FA114Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · New River, AZfailure of the pilot to maintain proper altitude/clearance above the terrain, while performing an aerobatic maneuver.Feb 18, 1996 · N2596Z · DestroyedNTSB FTW96LA125Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Dallas, TXFailure of the unqualified helicopter pilot to maintain control of the helicopter. Factors relating to the accident were: his lack of total experience in helicopters and his improper decision to attempt to hover without appropriate training/endorsement for…Feb 17, 1996 · N8897F · Substantial damageNTSB FTW96LA121Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Carrizo Springs, TXa loss of engine power for undetermined reasons, and the pilot's improper touchdown.Feb 16, 1996 · N67065 · Substantial damageNTSB ATL96LA048Accident · 2 fatalLimited investigationFinal reportMcrae Titan Acft Tornado · Pahokee, FLthe pilot's failure to maintain airspeed while maneuvering.Feb 15, 1996 · N6234X · Substantial damageNTSB MIA96FA078Accident · 3 fatalField investigationFinal reportAero Commander 500S · Manati, PRFailure of the flight crew, for undetermined reasons, to recover from a stall and resulting uncontrolled descent. This resulted in the aircraft colliding with the terrain while in a 45-60 degree nose down attitude at a slow speed.Feb 11, 1996 · N79NU · DestroyedNTSB FTW96FA136Accident · 2 fatalField investigationFinal reportMbb BO-105 · Gulf Of MexicoThe pilot's failure to maintain clearance from the ocean for unknown reasons.Feb 10, 1996 · N126EH · DestroyedNTSB LAX96LA194Accident · No injuriesLimited investigationFinal reportBell 206B · Barstow, CAfailure of the pilot to maintain adequate terrain clearance, while maneuvering around a ground vehicle at low altitude.Feb 6, 1996 · N16726 · Substantial damageNTSB SEA96TA046Accident · Minor injuriesFinal reportChristen Industries A-1 · Lakeview, ORfailure of the pilot to maintain altitude/clearance from the terrain (snow covered, frozen lake). Factors relating to the accident were: the pilot's attention being diverted to a perceived safety hazard, and lack of visual cues for pilot perception of…Feb 2, 1996 · N2866B · Substantial damageNTSB MIA96LA074Accident · 1 fatalLimited investigationFinal reportYakovlev YAK-52 · Boynton Beach, FLPilot impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his failure to maintain sufficient altitude above the terrain while performing an aerobatic maneuver. Factors relating to the accident were: the pilot's…Feb 2, 1996 · N77YK · DestroyedNTSB MIA96FA067Accident · Serious injuriesField investigationFinal reportMitsubishi MU-2B-60 · West Columbia, SCa total loss of power on one engine for undetermined reasons, and the pilot-in-command's failure to maintain airspeed (VMC) resulting in an in-flight loss of control. Contributing to the accident was the wind gusts encountered while on final approach to land.Jan 19, 1996 · N50KW · DestroyedNTSB FTW96LA096Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Mandeville, LAthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his failure to maintain sufficient altitude/clearance from obstructions (power lines) at night.Jan 15, 1996 · N714JV · Substantial damageNTSB LAX96FA095Accident · 1 fatalField investigationFinal reportPiper J2 · Lancaster, CAfailure of the pilot to maintain adequate airspeed, while maneuvering from crosswind to downwind after takeoff, which resulted in an inadvertent stall/spin and collision with terrain.Jan 13, 1996 · N17261 · DestroyedNTSB FTW96FA089Accident · 1 fatalField investigationFinal reportCessna A150M · Vinita, OKFailure of the pilot to recover from a spin. Factors relating to the accident were: the pilot's ostentatious display and the lack of altitude (terrain clearance) for recovery from the aerobatic maneuver and subsequent spin.Jan 13, 1996 · N8125V · DestroyedNTSB SEA96LA042Accident · No injuriesLimited investigationFinal reportCessna 182 · Grantsville, UTthe failure of the #5 exhaust valve rocker boss, and the subsequent sticking of the exhaust valve in the closed position. Factors include wet, soft terrain in the only available landing area.Jan 12, 1996 · N91130 · Substantial damageNTSB LAX96LA093Accident · 1 fatalLimited investigationFinal reportBell 47-G5 · Pope Valley, CAthe pilot misjudged the clearance between the broadcaster and the truck resulting in the broadcaster's cables becoming entangled with the truck.Jan 12, 1996 · N1309X · DestroyedNTSB FTW96LA095Accident · No injuriesLimited investigationFinal reportSchweizer 269C · San Ygnacio, TXFailure of the rotor drive system clutch assembly (separation of the swedge ball from the end of the clutch control cable), which resulted in disengagement of the rotor drive system, while the helicopter was in lateral movement at low altitude.Jan 12, 1996 · N3623T · Substantial damageNTSB FTW96LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Collbran, COThe pilot's intentional flight at low altitude, which resulted in inadequate terrain clearance to compensate for a downdraft. The downdraft was a related factor.Jan 12, 1996 · N2132J · Substantial damageNTSB SEA96LA041Accident · No injuriesLimited investigationFinal reportCessna 172K · Park City, MTInadequate visual lookout by the pilot, and his failure to maintain sufficient altitude/clearance from the transmission line.Jan 6, 1996 · N172NS · Substantial damageNTSB MIA96LA050Accident · 2 fatalLimited investigationFinal reportNanchang China CJ6A · Planterville, SCfailure of the pilot to maintain sufficient altitude or clearance from trees.Dec 28, 1995 · N3104U · DestroyedNTSB ATL96FA027Accident · 2 fatalField investigationFinal reportPiper J-3-C65 · Belzoni, MSfailure of the student pilot to maintain adequate airspeed, while maneuvering, which resulted in a stall/spin and subsequent collision with the ground.Dec 26, 1995 · N3615K · Substantial damageNTSB SEA96FA034Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Kapowsin, WAthe pilot's failure to maintain aircraft control and terrain clearance. Turbulence was a factor.Dec 24, 1995 · N4008Z · Substantial damageNTSB CHI96FA065Accident · 2 fatalField investigationFinal reportMumm Lancair · Morris, MNthe partially blocked elevator and improper installation of the elevator bob weight by the owner/builder which prevented full travel of the elevator control system. Factors relating to this accident were the intentional stall and inability to adequately…Dec 23, 1995 · N2114Z · DestroyedNTSB LAX96FA076Accident · 1 fatalField investigationFinal reportHughes 369D · Feather Falls, CAthe pilot's failure to jettison his external load after it came in contact with trees and terrain. The pilot's failure to maintain altitude/clearance above trees and hilly terrain was a related factor.Dec 20, 1995 · N8395F · DestroyedNTSB ATL96LA025Accident · 1 fatalLimited investigationFinal reportMoravan Zlin Z50 LA · Springfield, TNthe pilot's failure to maintain control of the aircraft.Dec 20, 1995 · N6660B · Destroyed