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 MIA03LA182Accident · 1 fatalLimited investigationFinal reportMooney M20J · Atlantic OceanPilot incapacitation due to a cardiovascular event which led to loss of control and subsequent impact with water.Sep 14, 2003 · N205Z · DestroyedNTSB SEA03LA190Accident · 2 fatalLimited investigationFinal reportCessna 182 · Challis, IDThe pilot's failure to maintain clearance from trees while maneuvering. Factors include mountainous terrain and trees.Sep 13, 2003 · N5547B · DestroyedNTSB LAX03CA287Accident · Minor injuriesData collectionFinal reportAviat Pitts S-2C · Mountain View, CAthe pilot's failure to maintain an adequate clearance with the runway during a low altitude aerobatic maneuver.Sep 13, 2003 · N57BC · Substantial damageNTSB SEA03LA189Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Diamond, ORLoss of engine power for undetermined reasons during hover.Sep 12, 2003 · N48020 · Substantial damageNTSB FTW03LA223Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Farwell, TXThe pilot's failure to maintain airspeed while maneuvering which resulted in an inadvertent stall.Sep 12, 2003 · N61353 · DestroyedNTSB ANC03LA112Accident · No injuriesLimited investigationFinal reportDusseau Kitfox · Nikiski, AKA loss of engine power for an undetermined reason, which resulted in an overrun during the emergency landing, and subsequent nose over in swampy terrain.Sep 11, 2003 · N20TZ · Substantial damageNTSB FTW03LA216Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Kisatchie, LAA loss of engine power due to water contamination in the fuel system.Sep 9, 2003 · N197AA · Substantial damageNTSB ANC03LA111Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-160 · Skwentna, AKThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall, and subsequent in-flight collision with terrain. A factor associated with the accident was a downdraft.Sep 8, 2003 · N4418Z · Substantial damageNTSB CHI03FA301Accident · 1 fatalField investigationFinal reportAeronca 11BC · Colfax, WIThe pilot failed to maintain adequate airspeed while maneuvering which resulted in an inadvertent stall. A factor associated with the accident was the low altitude at which the pilot was maneuvering.Sep 7, 2003 · N4103E · Substantial damageNTSB LAX03CA279Accident · No injuriesData collectionFinal reportBell 206B · Long Beach, CAthe pilot's inadequate remedial action in response to a loss of tail rotor effectiveness.Sep 6, 2003 · N59506 · Substantial damageNTSB ATL03FA136Accident · 1 fatalField investigationFinal reportBeech BE-55 · Winder, GAThe pilot's inadequate preflight preparation in which he failed to secure the cabin door which diverted his attention and resulted in the failure to maintain directional control.Sep 6, 2003 · N62JF · DestroyedNTSB SEA03LA185Accident · 1 fatalLimited investigationFinal reportAeronca 65-CA · Polson, MTThe pilot's failure to maintain clearance from an object while maneuvering and alcohol impairment. Transmission wires, dark night conditions, and drug impairment were factors.Sep 4, 2003 · N33865 · Substantial damageNTSB MIA03TA175Accident · Serious injuriesFinal reportCessna 172P · Jay, FL**This case was modified on 2/18/2016. Refer to the public docket for this accident to view the changes.** Loss of engine power for undetermined reasons.Sep 3, 2003 · N52615 · Substantial damageNTSB LAX03LA271Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Watsonville, CAthe non-instrument rated pilot's intentional continuance of VFR flight into instrument meteorological conditions and failure to maintain clearance with terrain.Aug 31, 2003 · N707JH · Substantial damageNTSB ATL03FA134Accident · 2 fatalField investigationFinal reportBeech BE-35 · Kingsport, TNThe certified flight instructor's mismanagement of the fuel, resulting in a loss of engine power and his failure to maintain airspeed, which resulted in a stall.Aug 31, 2003 · N4289B · DestroyedNTSB LAX03CA277Accident · Minor injuriesData collectionFinal reportPZL PW-5 · Yreka, CAthe pilot's inadequate in-flight planning/decision and failure to maintain airspeed resulted in an inadvertent stall. A factor in the accident was the downdraft.Aug 30, 2003 · N105PS · Substantial damageNTSB LAX03CA263Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Pauma Valley, CAthe pilot's failure to maintain an adequate airspeed, which resulted in a stall. The rising terrain was a factor.Aug 25, 2003 · N15285 · Substantial damageNTSB FTW03LA204Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Winnsboro, LAThe pilot's inadequate inflight planning, which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Aug 25, 2003 · N301AF · Substantial damageNTSB FTW03LA203Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Ozona, TXThe pilot's decision to hover out of ground effect, which resulted in a loss of tail rotor effectiveness. A contributing factor was the lack of suitable terrain.Aug 25, 2003 · N731BA · Substantial damageNTSB MIA03LA170Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Panama City, FLThe pilot's failure to follow the airplane manufacturer's recommendation to not use automobile fuel in the airplane resulting in deterioration of the fuel tank sealant, fuel starvation of the engine from fuel system contamination, and subsequent collision…Aug 23, 2003 · N40PA · Substantial damageNTSB CHI03LA327Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau EA200 · Sugar Grove, ILA loss of engine power due to the pilot's inadvertent deactivation of the magnetos, and the pilot's selection of the wrong runway for the forced landing. Factors were the low altitude and the unsuitable terrain encountered during the forced landing.Aug 23, 2003 · N9PB · Substantial damageNTSB CHI03LA289Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Westside, IAThe pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power. Contributing factors were the unsuitable terrain encountered, and the terrace/embankment.Aug 22, 2003 · N5007G · Substantial damageNTSB FTW03LA199Accident · No injuriesLimited investigationFinal reportCessna T188C · Colorado City, TXThe loss of engine power due to failure of the crankshaft. A contributing factor was low altitude flight.Aug 20, 2003 · N3872J · Substantial damageNTSB FTW03LA197Accident · Minor injuriesLimited investigationFinal reportBell 206B · Mason, TXThe pilot's failure to maintain clearance with the power line. A contributing factor was the sunglare.Aug 20, 2003 · N9877Z · Substantial damageNTSB CHI03LA278Accident · 1 fatalLimited investigationFinal reportAyres S2R-G6 · Breckenridge, MIThe pilot's failure to maintain clearance from the powerlines during the aerial application pass rendering the airplane uncontrollable. The powerlines were a factor.Aug 19, 2003 · N23EG · DestroyedNTSB CHI03LA273Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T660 · Blytheville, ARThe pilot's inadequate visual lookout and altitude/clearance not being maintained from the transmission wires. A factor to the accident was the transmission wires.Aug 19, 2003 · N4114A · DestroyedNTSB CHI03LA272Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Brandon, WIThe pilot failed to maintain clearance from the corn crop during an aerial application maneuver. Additional factors were the terrain induced turbulence and the corn crop.Aug 19, 2003 · N4346Y · Substantial damageNTSB ATL03FA127Accident · 2 fatalField investigationFinal reportBoeing PT-17 Stearman · Tuckasegee, NCThe pilot's failure to maintain visual lookout which resulted in an in-flight collision with trees. A factor was drug impairment.Aug 17, 2003 · N38998 · DestroyedNTSB ANC03FA096Accident · 2 fatalField investigationFinal reportReims 406 · Barrow, AKAn in-flight collision with ocean waters while maneuvering for an undetermined reason.Aug 17, 2003 · N6591L · Substantial damageNTSB SEA03LA170Accident · 1 fatalLimited investigationFinal reportAvid Magnum · Greenwater, WAThe pilot's failure to maintain aircraft control while manuevering for undetermined reasons.Aug 16, 2003 · N2054F · Substantial damageNTSB CHI03LA261Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Aplington, IAThe pilot not maintaining proper altitude/clearance from the wire during the aerial application flight. The factor to the accident was the power line.Aug 14, 2003 · N4339S · Substantial damageNTSB SEA03FA169Accident · Serious injuriesField investigationFinal reportAerospatiale AS350D · Webb, IDAn over temperature condition within the gas generator turbine which led to first stage turbine blade fatigue as well as first stage blade track warping and consequent blade tip rub. The fatigue and blade tip rub ultimately led to blade separation and failure…Aug 13, 2003 · N57731 · Substantial damageNTSB CHI03LA263Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Sparta, MIThe loss of engine power due to fuel exhaustion and the inadvertent stall/spin encountered. The inadequate fuel supply, airspeed not being maintained, low altitude, and terrain were factors to the accident.Aug 13, 2003 · N8563L · DestroyedNTSB CHI03LA254Accident · No injuriesLimited investigationFinal reportWeatherly 620A · Doland, SDThe pilot's failure to maintain clearance from the wires and directional control not being possible due to the failure of the brake system. Factors contributing to the accident were the wires, the trees, and the failure of the brake system.Aug 10, 2003 · N4656M · Substantial damageNTSB DEN03FA137Accident · 1 fatalField investigationFinal reportCessna 182P · Antonito, COThe pilot's improper in-flight planning/decision and his failure to maintain clearance from the trees. Factors contributing to the accident were the low altitude, the trees, and the mountainous terrain.Aug 5, 2003 · N1344S · DestroyedNTSB NYC03FA173Accident · 2 fatalField investigationFinal reportLearjet 35A · Groton, CTThe first officer's inadvertent retraction of the flaps during the low altitude maneuvering, which resulted in the inadvertent stall and subsequent in-flight collision with a residential home. Factors in the accident were the captain's decision to perform a…Aug 4, 2003 · N135PT · DestroyedNTSB IAD03FA069Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Galion, OHThe pilot's improper in-flight decision making and flight into known adverse weather conditions while maneuvering to land. Also causal was the pilot's failure to regard the pre-flight weather briefing. Factors were the thunderstorm, rain, wind gusts and hail.Aug 2, 2003 · N577SK · DestroyedNTSB CHI03LA243Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Mitchell, SDThe pilot's inadequate visual lookout and not maintaining clearance from the power line during the low level aerial application maneuver. A related factor was the power line.Aug 2, 2003 · N4923X · Substantial damageNTSB LAX03CA250Accident · Minor injuriesData collectionFinal reportTexas Helicopter OH-13E-M74 · Tulare, CAthe pilot's failure to maintain clearance with the wires due to an inadequate visual lookout.Jul 30, 2003 · N51852 · Substantial damageNTSB FTW03TA190Accident · Minor injuriesFinal reportHughes 269A · Freer, TXLoss of engine power for undetermined reasons.Jul 30, 2003 · N81170 · Substantial damageNTSB SEA03LA160Accident · Minor injuriesLimited investigationFinal reportHughes 269C-1 · Scappoose, ORThe helicopter encountering a ground resonance condition following a failure to maintain hovering flight. Contributing factors to the accident included the pilot's failure to maintain rotor RPM and the high pressure state of the landing gear shock absorbing…Jul 29, 2003 · N61442 · Substantial damageNTSB SEA03LA158Accident · No injuriesLimited investigationFinal reportHughes 269C · Melba, IDThe pilot's failure to maintain control of the helicopter due to his failure to maintain rotor rpm. Factors contributing to the accident were the corn crop, and the pilot's abrupt maneuver to avoid obstacles.Jul 28, 2003 · N171FF · Substantial damageNTSB CHI03LA232Accident · No injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Stephen, MNThe pilot's failure to maintain clearance from the transmission line and the pilot's continued operation with known deficiencies in equipment. Factors to the accident were the power lines and the low altitude the pilot was flying at.Jul 28, 2003 · N67ND · Substantial damageNTSB LAX03FA241Accident · 5 fatalField investigationFinal reportBell 206B · Waialeale,Kauai, HIThe pilot's failure to maintain adequate terrain clearance/altitude while descending over mountainous terrain, and his continued flight into adverse weather. Factors contributing to the accident were clouds and a low ceiling.Jul 23, 2003 · N37741 · DestroyedNTSB LAX03LA239Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Hamilton City, CAThe pilot's failure to maintain adequate airspeed to avert stalling during a low altitude turn.Jul 22, 2003 · N477Y · Substantial damageNTSB ANC03LA082Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Ketchikan, AKThe improper installation of a bolt in the gas generator governor linkage by company maintenance personnel, which resulted in a loss of the bolt, a loss of engine power while maneuvering, and subsequent forced landing and collision with trees. Factors…Jul 21, 2003 · N1091S · Substantial damageNTSB MIA03LA146Accident · 1 fatalLimited investigationFinal reportSonerai Sonerai IIB · Lakeland, FLThe pilot's decision to conduct low level flight and his failure to maintain obstacle clearance.Jul 20, 2003 · N224RB · DestroyedNTSB LAX03LA236Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Porterville, CAFatigue-induced failure of bolts in the helicopter's rotor drive flange, which resulted in a total loss of torque to the rotor drive shaft.Jul 20, 2003 · N4774S · Substantial damageNTSB SEA03FA143Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · White Bird, IDThe failure of the pilot to maintain clearance with terrain while maneuvering. Factors contributing to the accident included the impairment of the pilot due to carbon monoxide exposure and the trees.Jul 17, 2003 · C-GBEN · DestroyedNTSB CHI03LA214Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · Staples, MNThe fatigue fracture of the oil jet flange resulting in a total engine failure during the aerial application.Jul 17, 2003 · N3299A · Destroyed