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 FTW95FA106Accident · 1 fatalField investigationFinal reportCessna 150 · Arnaudville, LAThe pilot's failure to maintain adequate airspeed while circling at low altitude, which resulted in an inadvertent stall and subsequent collision with terrain (wooded river bank). A factor relating to the accident was: the pilot's use of a drug that was not…Feb 4, 1995 · N6464T · DestroyedNTSB LAX95LA096Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Chowchilla, CAthe in-flight failure and separation of the main rotor hub due to a fatigue crack.Feb 3, 1995 · N9293Z · DestroyedNTSB LAX95LA091Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Pixley, CAthe total failure of the number three cylinder. The wet and soft terrain were factors in this accident.Feb 1, 1995 · N705Y · Substantial damageNTSB FTW95LA105Accident · Minor injuriesLimited investigationFinal reportBell 47G-4A · El Indio, TXThe loss of tail rotor effectiveness. A factor was the gusty right quartering tailwind.Feb 1, 1995 · N6SR · DestroyedNTSB FTW95FA102Accident · 2 fatalField investigationFinal reportCessna 150L · Needville, TXLoss of control at an altitude insufficient for recovery after one of the two pilots on board attempted an aerobatic maneuver.Jan 27, 1995 · N1493Q · DestroyedNTSB LAX95LA087Accident · 1 fatalLimited investigationFinal reportStevens S-8 · Tucson, AZThe pilot's failure to maintain adequate control of the airplane to avoid a collision with the ground.Jan 23, 1995 · N66191 · DestroyedNTSB MIA95GA062Accident · 1 fatalFinal reportHughes 369E · Tampa, FLThe pilot's failure to maintain aircraft control as a result of becoming spatially disoriented while maneuvering. Contributing to the accident was the dark night with no visible horizon.Jan 19, 1995 · N4TP · DestroyedNTSB NYC95FA050Accident · 3 fatalField investigationFinal reportAgusta A109C · Jackson Twp, PAThe pilot's improper in-flight planning/decision and failure to maintain control of the airplane after becoming spatially disoriented. Factors related to the accident were: darkness and the adverse weather conditions.Jan 18, 1995 · N1WD · DestroyedNTSB LAX95FA078Accident · 3 fatalField investigationFinal reportCessna 182R · Wrightwood, CAthe pilot's loss of aircraft control and subsequent inadvertent stall/spin following an encounter with a localized mountain wave condition and turbulence while conducting a search mission in close proximity to mountainous terrain.Jan 14, 1995 · N9706E · DestroyedNTSB FTW95LA091Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Marshall, ARThe pilot's continued flight into adverse deteriorating weather conditions. A factor was the weather and rising terrain.Jan 14, 1995 · N9590W · DestroyedNTSB FTW95LA089Accident · No injuriesLimited investigationFinal reportInterstate S-1A · Amarillo, TXAn inflight fire, the reason for which was undetermined.Jan 12, 1995 · N37239 · DestroyedNTSB FTW95GA090Accident · No injuriesFinal reportHughes 269C · Dumont, TXThe loss of engine power due to overstress fractures of the #3 cylinder connecting rod cap bolts. The origin of the fractures could not be determined.Jan 12, 1995 · N796 · DestroyedNTSB LAX95LA075Accident · No injuriesLimited investigationFinal reportKaman HH43 · Glendale, AZThe pilot's failure to maintain an adequate visual lookout to avoid a collision with a tree during an aerial application swath run.Jan 10, 1995 · N321WN · Substantial damageNTSB CHI95DTK01Accident · 1 fatalFinal reportGay RV-4 · Lennox, SDThe pilot's failure to maintain adequate altitude while performing aerobatic maneuvers. The pilot's impairment of judgment and performance due to drugs was a factor.Jan 8, 1995 · N29PG · DestroyedNTSB SEA95LA035Accident · No injuriesLimited investigationFinal reportCessna 152 · Lehi, UTThe pilot's failure to maintain altitude/clearance above the terrain. Factors include the pilot inadvertently becoming lost/disoriented, his improper inflight decision to attempt to maneuver through unfamiliar mountainous terrain to his original destination,…Dec 29, 1994 · N24741 · Substantial damageNTSB LAX95LA064Accident · No injuriesLimited investigationFinal reportRockwell S2R Thrush Cmdr · Yuma, AZa forced landing due to an engine failure of the no.1 cylinder.Dec 29, 1994 · N8455V · Substantial damageNTSB MIA95LA044Accident · No injuriesLimited investigationFinal reportBell 206B · Miami, FLInadequate supervision by the pilot-in-command (CFI) for failure to note reduction in clearance between the tail rotor and an embankment.Dec 20, 1994 · N163BH · Substantial damageNTSB CHI95LA060Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Bowling Green, MOInadequate design of the reserve parachute cable housing, which resulted in an inadvertent deployment of the parachute, and subsequent collision with, and jamming of, the aircraft's horizontal stabilizer, necessitating a forced landing.Dec 17, 1994 · N6090B · Substantial damageNTSB FTW95LA066Accident · Serious injuriesLimited investigationFinal reportCessna 182R · Eagle Nest, NMThe pilot's flight into rising terrain without sufficient altitude and climb performance available to clear the trees and terrain. A factor was the pilot becoming lost and disoriented.Dec 16, 1994 · N182X · Substantial damageNTSB LAX95LA052Accident · No injuriesLimited investigationFinal reportBell 206B · Julian, CAthe failure of the pilot to maintain a proper alignment during hover in a mountainous area.Dec 15, 1994 · N37AJ · Substantial damageNTSB LAX95LA051Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Oasis, CAthe pilot's improper inflight decision by selecting an inadequate terrain clearance altitude over mountainous terrain.Dec 15, 1994 · N6236L · DestroyedNTSB ANC95LA020Accident · No injuriesLimited investigationFinal reportCessna 207 · Saint Mary'S, AKThe pilot's decision to continue visual flight into instrument meteorological conditions. Factors associated with the accident are the pilot's failure to maintain adequate altitude/clearance from terrain, and the whiteout weather conditions.Dec 13, 1994 · N7340U · Substantial damageNTSB LAX95LA050Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 · Tehachapi, CAthe pilot's poor in-flight planning/decision and inadequate airspeed. The downdraft and trees were factors in this accident.Dec 11, 1994 · N3950A · Substantial damageNTSB LAX95FA043Accident · 2 fatalField investigationFinal reportSiai-Marchetti SF260C · North Las Vegas, NVthe pilot's failure to maintain control of the airplane by inadvertently allowing the flying passenger to enter a stall/spin. Factors in the accident were the passenger's interference with the pilot's attempted recovery from the spin, and the pilot's lack of…Dec 3, 1994 · N58FD · DestroyedNTSB CHI95DCA01Accident · 1 fatalFinal reportYakovlev YAK-52 · Caruthersville, MOThe insufficient altitude (300 feet above the airport) at which an aerobatic maneuver was attempted by the pilot.Nov 29, 1994 · N2215C · DestroyedNTSB ATL95LA019Accident · 2 fatalLimited investigationFinal reportWeeks Glasair SH2F · Timmonsville, SCThe pilot's continued operation into known adverse weather conditions with a known aircraft deficiency, and his ensuing spatial disorientation, which resulted in ground impact during an uncontrolled descent.Nov 27, 1994 · N169DW · DestroyedNTSB FTW95LA054Accident · Serious injuriesLimited investigationFinal reportGlaser-Dirks DG-600 · Alamogordo, NMThe inadvertent stall.Nov 26, 1994 · N7020P · Substantial damageNTSB MIA95LA028Accident · No injuriesLimited investigationFinal reportBellanca 14-13 · Tunica, MSThe pilot's delay in obtaining ATC assistance after becoming lost/disoriented resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident was failure of the pilot to navigate using the VOR system.Nov 24, 1994 · N74232 · Substantial damageNTSB MIA95FA027Accident · 2 fatalField investigationFinal reportChampion 7ECA · Arcadia, FLThe failure of the dual-student to maintain airspeed while maneuvering resulting in an inadvertent stall and uncontrolled descent. Contributing to the accident was improper supervision of the dual-student by the flight instructor.Nov 23, 1994 · N7579F · Substantial damageNTSB MIA95LA024Accident · Serious injuriesLimited investigationFinal reportAyres S2R-R1820 · Arcadia, FLFailure of the engine due to a undetermined failure in the engine power section.Nov 21, 1994 · N3097B · DestroyedNTSB MIA95FA023Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Daytona Beach, FLThe pilot's failure to maintain aircraft control while maneuvering in instrument flight conditions during an instrument approach, resulting in the pilot becoming spatially disoriented, and a subsequent in-flight collision with terrain. Contributing to the…Nov 20, 1994 · N9420J · DestroyedNTSB SEA95LA023Accident · Serious injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Yamhill, ORFailure of the pilot to maintain adequate altitude/clearance, while maneuvering to a hover, which allowed the external load cable/hook to become snagged and to rebound into the path of the main rotor blades.Nov 19, 1994 · N4258V · Substantial damageNTSB BFO95LA013Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Magnolia, DEthe pilot's failure to maintain adequate rotor rpm while hovering.Nov 19, 1994 · N40411 · DestroyedNTSB ATL95LA016Accident · No injuriesLimited investigationFinal reportCessna 182A · Johns Island, SCA loss of engine power due to a partially blocked fuel line to the gascolator.Nov 19, 1994 · N3724D · Substantial damageNTSB MIA95FA021Accident · 2 fatalField investigationFinal reportPiper PA-18 · Bainbridge, GAInadvertent stall/spin and altitude inadequate for recovery by the pilot-in-command (CFI).Nov 18, 1994 · N5418H · DestroyedNTSB FTW95FA050Accident · 2 fatalField investigationFinal reportCessna 172P · Deming, NMThe pilot's failure to maintain sufficient altitude and clearance in moutainous terrain. Factors were rising terrain and gusty, high wind conditions.Nov 18, 1994 · N54378 · DestroyedNTSB FTW95FA047Accident · 1 fatalField investigationFinal reportGrumman-Schweizer G-164B · Wisner, LAThe pilot's failure to maintain minimum required airspeed for flight. A factor was the pilot's lack of total experience in the type of aircraft.Nov 16, 1994 · N48398 · Substantial damageNTSB LAX95FA037Accident · 3 fatalField investigationFinal reportCessna 172K · Springerville, AZthe pilot's failure to maintain the proper airspeed, which resulted in an inadvertent stall/spin. The pilot's diverted attention and overconfidence in the aircraft's ability to fly slow were factors in this accident.Nov 15, 1994 · N7178G · DestroyedNTSB ATL95FA014Accident · 2 fatalField investigationFinal reportCessna 172H · Louisville, GAThe pilot's failure to maintain clearance from trees during a low pass maneuver. A factor was the trees at the vicinity of the low pass.Nov 13, 1994 · N8200L · DestroyedNTSB LAX95FA033Accident · 1 fatalField investigationFinal reportSchweizer 269C · Valencia, CAthe pilot's failure to maintain adequate clearance from a dirt embankment while performing an undetermined maneuver.Nov 11, 1994 · N60TA · DestroyedNTSB FTW95LA041Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Johnson City, TXThe pilot's failure to maintain clearance with the trailer while landing.Nov 11, 1994 · N888CG · Substantial damageNTSB SEA95FA017Accident · 4 fatalField investigationFinal reportBeech 58P · Great Falls, MTThe pilot's failure to maintain airspeed. A factor to the accident was: inadequate aircraft preflight.Nov 8, 1994 · N180PB · Substantial damageNTSB FTW95LA039Accident · No injuriesLimited investigationFinal reportHughes 269A · Monticello, ARThe loss of engine power due to a fatigued rod end bolt. A factor was the lack of suitable terrain for landing.Nov 8, 1994 · N10415 · Substantial damageNTSB NYC95LA021Accident · 2 fatalLimited investigationFinal reportBoeing A-75N1 · Sayville, NYA loss of control in flight by the pilot(s) while maneuvering, with insufficient altitude for recovery.Nov 5, 1994 · N48190 · DestroyedNTSB MIA95FA018Accident · 2 fatalField investigationFinal reportBölkow BO-105S · Perry, FLFailure of the pilot to maintain sufficient clearance from the power line, while buzzing (at low altitude).Nov 4, 1994 · N911LF · DestroyedNTSB SEA95LA015Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Gillette, WYThe pilot in command's failure to maintain clearance with terrain. Factors contributing were the snow covered terrain and low ceiling resulting in poor contrast.Nov 3, 1994 · N7566K · Substantial damageNTSB ATL95LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Rock Hill, SCThe student pilot's poor judgement and his failure to maintain clearance from obstacles.Nov 2, 1994 · N48720 · Substantial damageNTSB LAX95LA023Accident · No injuriesLimited investigationFinal reportGlen A. Senecal 5151 · Apple Valley, CAthe manufacturer's (owner/operator) improper balancing of the aileron flight controls which resulted in a cable separation due to overload from the aileron flutter. The rough/uneven terrain was also a factor.Oct 29, 1994 · N5246G · Substantial damageNTSB SEA95LA013Accident · No injuriesLimited investigationFinal reportHiller UH-12E4 · Morton, WAA leak in the fuel filler cap and water in the fuel system. A factor to the accident was: inadequate preflight.Oct 28, 1994 · N80NW · Substantial damageNTSB LAX95FA020Accident · 2 fatalField investigationFinal reportCessna T337H · Douglas City, CAThe improper in-flight decision of the pilot to fly in dark night time conditions in mountainous terrain during adverse weather conditions.Oct 28, 1994 · N1497S · Destroyed