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 LAX89DVD04Accident · Minor injuriesFinal reportTravel Air 4000 · Lodi, CAThe failure of the pilot to see and avoid power lines, while distracted by a moving vehicle on the ground.Jul 25, 1989 · N1592 · DestroyedNTSB MKC89FA165Accident · 2 fatalField investigationFinal reportBeech C23 · Neligh, NEFailure of the pilot to maintain adequate airspeed after intiating a steep climbing maneuver from low altitude. Factors related to the accident were: the pilot's lack of total flying experience and lack of sufficient altitude.Jul 23, 1989 · N66295 · DestroyedNTSB ATL89LA184Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Alabaster, ALThe glider pilot's poor evaluation of area weather conditions during the flight, which necessitated an off-airport precautionary landing and led to a collision with rough terrain during the landing rollout. Factors contributing to the accident were the…Jul 23, 1989 · N65943 · Substantial damageNTSB ATL89DKJ07Accident · 1 fatalFinal reportCessna A188B · Town Creek, ALThe inadvertent stall at an altitude inadequate to effect a safe recovery.Jul 22, 1989 · N5618G · DestroyedNTSB LAX89FA241Accident · 3 fatalField investigationFinal reportCessna 177 · Hesperia, CAAn inflight collision with a power line while maneuvering at low altitude shortly after departure on a dark night over an area with few ground reference lights. The reasons for the aircraft's flight path and altitude profile are undetermined. A factor in the…Jul 21, 1989 · N30039 · DestroyedNTSB MIA89LA202Accident · No injuriesLimited investigationFinal reportBell TH-13T · Jay, FLInadequate planning/decision by the pilot and his failure to maintain clearance from the power line. Contributing factors were: light conditions at dusk, transmission (power) lines, and the pilot's lack of visual cues (visual perception) at dusk.Jul 20, 1989 · N65212 · Substantial damageNTSB DEN89LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Crested Butte, COFailure of the pilot to maintain sufficient altitude while flying over mountainous terrain. The terrain and weather conditions were related factors.Jul 19, 1989 · N5673W · Substantial damageNTSB DEN89LA170Accident · Minor injuriesLimited investigationFinal reportPiper PA-36 · Haswell, COInadequate visual lookout by the pilot (failed to see & avoid) which resulted in his failure to maintain clearance from the obstruction. Contributing factors were: the unmarked guy wire & the pilot's lack of visual cues (visual perception).Jul 17, 1989 · N57622 · DestroyedNTSB LAX89FA239Accident · 1 fatalField investigationFinal reportChristen Industries A-1 Husky · Somerton, AZFailure of the pilot to maintain adequate airspeed, which resulted in a stall. The lack of altitude for recovery was a related factor.Jul 14, 1989 · N29162 · DestroyedNTSB FTW89DRA07Accident · 1 fatalFinal reportLowe/Bensen KB-2 · Wharton, TXPoor judgement by the student pilot by performing excessive/low altitude maneuvers, which resulted in his failure to maintain sufficient clearance (altitude) above the open field. His lack of familiarity with the aircraft was a contributing factor.Jul 14, 1989 · N7037K · DestroyedNTSB ANC89LA123Accident · Serious injuriesLimited investigationFinal reportDe Havilland DHC-2 · Kodiak, AKPilot-in-command's continued VFR flight into know IFR flt conditions, resulting in a collision with rising terrain.Jul 13, 1989 · N5354G · Substantial damageNTSB MKC89DCJ03Accident · 1 fatalFinal reportCessna A-188B · Hay Springs, NEThe pilot's delay in intiating a climb at the end of a swath run.Jul 12, 1989 · N79291 · Substantial damageNTSB DEN89LA168Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Hatton, NDImproper in-flight planning/decision by the pilot and his failure to maintain sufficient clearance above the ground. The tailwind, high obstruction (shelter belt), and downdraft were contributing factors.Jul 12, 1989 · N3269L · DestroyedNTSB CHI89LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Iola, WIThe improper preflight planning by the pilot in command resulting in the airplane fuel quantity being near the unusable quantity which resulted in total loss of engine power due to fuel starvation while maneuvering. Contributing to the accident was the pilots…Jul 12, 1989 · N4054J · Substantial damageNTSB BFO89FA057Accident · 1 fatalField investigationFinal reportBellanca 7KCAB · Berlin, MDPilot failure to maintain adequate airspeed, resulting in an aerodynamic stall. Contributing to the accident was the low altitude at which the stall occurred.Jul 12, 1989 · N57417 · DestroyedNTSB ANC89DAG01Accident · No injuriesFinal reportScorpion II · Anchorage, AKUnqualified person at the flight controls, who was unable to maintain control of the helicopter. The nearby building (airport facility) was a contributing factor.Jul 12, 1989 · N5577G · Substantial damageNTSB SEA89LA132Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Middleton, IDThe pilot did not maintain an adequate visual lookout. A factor was the guy wires at the edge of the field.Jul 11, 1989 · N5571X · Substantial damageNTSB MIA89LA196Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Minter City, MSFailure of the pilot to see and avoid the powerline. The power line was a contributing factor.Jul 11, 1989 · N4967X · Substantial damageNTSB FTW89FA132Accident · 1 fatalField investigationFinal reportCessna 152 · Arlington, TXPoor judgement of the pilot, due to impairment from consumption of alcohol, and his failure to maintain proper altitude while maneuvering. Factors related to the accident were: darkness, the pilot's recent use of drugs, and his lack of flight experience.Jul 11, 1989 · N49056 · DestroyedNTSB DEN89LA167Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Wh Sulphur Spgs, MTThe pilot failed to maintain adequate airspeed during an aerial application maneuver and inadvertently allowed the aircraft to mush into the ground. Unfavorable wind and turbulence were considered to be contributing factors.Jul 11, 1989 · N6663Z · Substantial damageNTSB MKC89LA158Accident · Minor injuriesLimited investigationFinal reportBristow KR-2 · Perry, IAFuel starvation caused by fuel contamination.Jul 10, 1989 · N1066 · Substantial damageNTSB MKC89FA156Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Medicine Lodge, KSThe pilot misjudged clearance above a house (residence) that he was buzzing and allowed the aircraft to collide with the attached antenna.Jul 9, 1989 · N5379P · DestroyedNTSB DEN89FA162Accident · 2 fatalField investigationFinal reportCessna 150K · Louisville, COInadequate supervision by the instructor pilot (CFI) and flight in known adverse weather conditions. Factors related to the accident were: inadequate preflight planning/preparation by the CFI, his lack of experience in the type of operation, and the weather…Jul 9, 1989 · N6342G · DestroyedNTSB DEN89DTI03Accident · 1 fatalFinal reportCessna T188C · Red Lodge, MTImproper inflight decision by the pilot and his failure to attain sufficient altitude. Rising terrain, high density altitude, and trees were considered to be contributing factors.Jul 9, 1989 · N2165J · DestroyedNTSB BFO89LA056Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Bealeton, VAWater in the fuel, which resulted in a momentary loss of power during an inverted low pass, and the pilot's failure to plan the maneuver to allow for appropriate remedial action.Jul 9, 1989 · N56940 · DestroyedNTSB ATL89DLT04Accident · Minor injuriesFinal reportPitts S-1 · Butler, TNThe failure of the pilot to maintain clearance from the surface during an impromptu acrobatic maneuver.Jul 9, 1989 · N8336 · Substantial damageNTSB LAX89LA265Accident · Minor injuriesLimited investigationFinal reportSikorsky S-58T · Susanville, CAThe pilot's inflight decision to enter a descent when he lost yaw control of the aircraft. Turbulent weather conditions and an abrupt touchdown were factors in the accident.Jul 8, 1989 · N6306 · Substantial damageNTSB LAX89LA237Accident · No injuriesLimited investigationFinal reportCessna 150K · Woodland, CAThe pilot's poor judgement in not assuring an adequate fuel supply was on board for the flight.Jul 8, 1989 · N6352G · Substantial damageNTSB FTW89DPJ08Accident · Serious injuriesFinal reportGrumman G-164 · Guymon, OKFailure of the upper right engine mount (firewall attach bolt) due to fatigue, and failure of the lower right mounting bolt for an unknown reason, which allowed overload failure of the two remaining mounting bolts and separation of the engine.Jul 8, 1989 · N788Y · Substantial damageNTSB CHI89FA129Accident · 2 fatalField investigationFinal reportPiper PA-18 · Roscommon, MILoss of control in flight while maneuvering and the failure to perform remedial action by the PIC.Jul 8, 1989 · N2336J · DestroyedNTSB ATL89FA175Accident · 2 fatalField investigationFinal reportBeech A45 · Troy, ALThe pilot's improper use of the airplane flight controls during a aerobatic maneuver at low altitude due to his lack of aerobatic experience. A contributing factor was the pilot's overconfidence in his ability to perform the maneuver.Jul 8, 1989 · N7973A · DestroyedNTSB ATL89DKJ06Accident · Serious injuriesFinal reportPiper PA-25-235 · Goodway, ALThe in-flight separation of the left wing which failed because of a corrosion induced fatigue fracture.Jul 8, 1989 · N6941Z · DestroyedNTSB ANC89LA116Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Killey River, AKThe pilot failed to assure sufficient alt was obtained to compensate for the downdrafts near the ridge line.Jul 6, 1989 · N88273 · Substantial damageNTSB MKC89DPG02Accident · 1 fatalFinal reportRockwell S-2R · Reyno, ARImproper in-flight planning/decision by the pilot which resulted in a tight maneuver at inadequate airspeed and a subsequent stall. A contributing factor was the presence of high obstructions (trees).Jul 5, 1989 · N4931X · DestroyedNTSB MKC89FA153Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Broken Bow, NEImproper planning/decision by the pilot by performing acrobatic flight with baggage in the rear cockpit of the aircraft, which probably restricted movement of the flight controls and resulted in uncontrolled flight and a spin.Jul 4, 1989 · N8636V · DestroyedNTSB LAX89DVG07Accident · No injuriesFinal reportSchweizer G-164B · Willows, CAFailure of the connecting rod on #1 cylinder of the aircraft powerplant.Jul 4, 1989 · N3627G · Substantial damageNTSB MKC89LA150Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Jonesboro, ARThe pilot's encounter with unsuitable terrain during a forced landing made necessary by the separation of three feet of one of the propeller blades.Jul 3, 1989 · N8976Q · DestroyedNTSB MKC89DER01Accident · 1 fatalFinal reportCessna T188C · Wannaska, MNThe pilot-in-command did not maintain airspeed, resulting in an inadvertent stall.Jul 3, 1989 · N9438J · Substantial damageNTSB CHI89DEP06Accident · Minor injuriesFinal reportAeronca 15AC · Fort Atkinson, WIWater contamination of the fuel and the pilot's inadequate preflight. Factors related to the accident were: lack of suitable terrain for a forced landing & trees.Jul 3, 1989 · N1271H · Substantial damageNTSB MKC89LA148Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Stockville, NETotal failure of the powerplant caused by a broken cylinder.Jul 2, 1989 · N6629Q · Substantial damageNTSB FTW89LA120Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Austin, TXThe pilot's improper inflight planning/decision, which resulted in a situation where he was unable to maintain adequate rotor RPM. Factors related to the accident were: high temperature, tailwind, and trees.Jul 2, 1989 · N888CG · DestroyedNTSB DEN89DTI02Accident · 1 fatalFinal reportMusick/Terratorn Tierra II · Lewistown, MTThe unqualified pilot allowed the aircraft to become airborne while taxiing at high speed, he failed to maintain control of the aircraft, and he inadvertently allowed it to enter a stall/spin and crashed. Factors related to the accident were: his failure to…Jul 2, 1989 · N349SM · DestroyedNTSB NYC89LA152Accident · Minor injuriesLimited investigationFinal reportSchweizer 1-26 · Elmira, NYAn inadvertent encounter with a downdraft.Jul 1, 1989 · N2746H · Substantial damageNTSB FTW89LA124Accident · No injuriesLimited investigationFinal reportAero Commander Lark 100-180 · Gonzales, TXFailure of the aircraft engine, for undetermined reasons, during a low altitude maneuver.Jul 1, 1989 · N3634X · Substantial damageNTSB ANC89LA112Accident · No injuriesLimited investigationFinal reportCessna 185F · Dillingham, AKImproper planning/decision by the pilot & a strong downdraft.Jul 1, 1989 · N6305E · Substantial damageNTSB SEA89LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Snoqualmie Pass, WAImproper in-flight planning/descision by the pilot, which resulted in the aircraft entering a box canyon with insufficient speed and altitude to maneuver out of the confined area. Factors related to the accident were: the pilot's continued flight into known…Jun 30, 1989 · N56759 · DestroyedNTSB MKC89GA147Accident · 2 fatalFinal reportMaule MX-7 · Atlantic, IAFailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which led to an inadvertent stall and loss of control. A contributing factor was the lack of altitude to recover from a stall.Jun 30, 1989 · N6131M · Substantial damageNTSB LAX89FA229Accident · 1 fatalField investigationFinal reportCessna 152 · Cordes, AZThe pilot misjudged his altitude, while maneuvering at low altitude over mountainous terrain. Factors related to the accident were: high density altitude, mountainous terrain, and diversion of the pilot's attention.Jun 30, 1989 · N5199Q · DestroyedNTSB CHI89LA126Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Sebewaing, MIPilot's inattentive aircraft handling which resulted in his failure to detect and prevent the aircraft's descent into the wheat field.Jun 30, 1989 · N2154K · Substantial damageNTSB ATL89DKG04Accident · 1 fatalFinal reportAir Tractor AT-301 · Americus, GAThe pilot's failure to properly survey the area in which he would be conducting aerial application flights and his failure to see and avoid powerlines while performing aerial application.Jun 29, 1989 · N8773S · Destroyed