OpenAirDocs.org

NTSB investigations

18,849 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 CEN20LA273Accident · Serious injuriesClass 3 · LimitedFinal reportAerospatiale AS355 · Rifle, COA loss of tail rotor effectiveness, the pilot’s subsequent loss of helicopter control, and collision with terrain.Jul 11, 2020 · N708AC · DestroyedNTSB CEN20LA272Accident · 1 fatalClass 3 · LimitedFinal reportGolden Circle Air T-Bird · Grosse Ile, MIThe noncertificated pilot’s failure to maintain clearance from trees while maneuvering at low altitude in gusting wind conditions. Contributing to the accident was the pilot’s lack of flight experience.Jul 11, 2020 · N50JH · Substantial damageNTSB CEN20LA278Accident · 1 fatalClass 3 · LimitedFinal reportGrumman G164 · Springfield, COThe pilot’s loss of visibility in the cockpit due to foam created by the chemicals loaded in the hopper, which resulted in collision with terrain. Contributing to the accident was the combining of chemicals known to produce foam and the pilot’s failure to…Jul 10, 2020 · N6917K · DestroyedNTSB CEN20LA270Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 188 · Pembina, NDThe pilot’s failure to maintain control during an aerial spray turnaround in high crosswind conditions.Jul 9, 2020 · C-GWWE · DestroyedNTSB CEN20LA282Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Venice, LAA partial loss of engine power for reasons that could not be determined based on available evidence.Jul 8, 2020 · N7186K · Substantial damageNTSB CEN20LA262Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F35 · Ravenna, TXElectrical and engine problems for reasons that could not be determined based on available evidence.Jul 5, 2020 · N4219B · Substantial damageNTSB CEN20LA287Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Des Arc, ARA total loss of engine power for reasons that could not be determined from all available evidence.Jul 3, 2020 · N8506E · Substantial damageNTSB CEN20LA259Accident · Minor injuriesClass 3 · LimitedFinal reportSopwith Type 9400 · Van Alstyne, TXAn inflight loss of aileron control due to movement of a control connector.Jul 3, 2020 · N5539 · Substantial damageNTSB CEN20LA265Accident · Serious injuriesClass 3 · LimitedFinal reportTitan Titan Tornado · Marksville, LAThe student pilot’s failure to ensure sufficient fuel onboard, which resulted in a total loss of engine power due to fuel exhaustion, which resulted in impact with terrain.Jul 2, 2020 · N5082N · Substantial damageNTSB WPR20CA197Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Pioche, NVThe pilot’s decision to fly at low level over mountainous terrain and his inability to recover when the helicopter encountered a downdraft that resulted in a collision with terrain.Jun 28, 2020 · N7530B · Substantial damageNTSB ERA20LA229Accident · Serious injuriesClass 3 · LimitedFinal reportBell 206 · Coconut Creek, FLThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s failure to recognize the illumination of the low-fuel caution light.Jun 25, 2020 · N5013G · Substantial damageNTSB WPR20LA191Accident · 1 fatalClass 3 · LimitedFinal reportEnstrom 280 · Hayden, IDThe total loss of power while maneuvering at low altitude due to the detonation of two engine cylinders and damaged spark plugs.Jun 24, 2020 · N280MM · DestroyedNTSB CEN20LA245Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182 · Winfield, TXThe total loss of engine power due to the pilot’s improper fuel management, which led to fuel starvation. Contributing to the accident was the low altitude at which the loss of engine power occurred.Jun 24, 2020 · N958HP · Substantial damageNTSB CEN20CA240Accident · No injuriesClass 4 · Data collectionFinal reportSchweizer 269C · Sheffield, TXThe pilot's failure to maintain adequate clearance from a fence while hovering.Jun 21, 2020 · N298TH · Substantial damageNTSB ERA20LA220Accident · 1 fatalClass 3 · LimitedFinal reportRobinson R66 · Pikeville, NCThe pilot’s failure to see and avoid a small diameter wire during low altitude agricultural spraying operations. Contributing to the accident was the pilot’s insufficient property survey.Jun 18, 2020 · N4QW · Substantial damageNTSB CEN20LA234Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT402 · Pine Bluff, ARThe pilot’s exceedance of the airplane’s critical angle of attack, which led to an aerodynamic stall and a loss of airplane control. Contributing was a partial loss of engine power for undetermined reasons.Jun 17, 2020 · N1532H · Substantial damageNTSB ERA20LA217Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT502 · Atmore, ALThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall, spin, and loss of control.Jun 16, 2020 · N879JA · Substantial damageNTSB CEN20CA230Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R22 · El Campo, TXThe pilot's failure to maintain adequate clearance from the rice vegetation, which resulted in the helicopter's impact with terrain.Jun 16, 2020 · N797SH · Substantial damageNTSB ERA20LA216Accident · No injuriesClass 3 · LimitedFinal reportBell 47G · Atoka, TNA total loss of engine power due to a blocked fuel line; the reason for the blockage could not be determined based on the available evidence.Jun 15, 2020 · N473TT · Substantial damageNTSB WPR20CA179Accident · No injuriesClass 4 · Data collectionFinal reportAyres S2R · Lenore, IDThe pilot's failure to maintain clearance from power lines while maneuvering during an aerial application flight, which resulted in a wire strike.Jun 12, 2020 · N40226 · DestroyedNTSB CEN20CA229Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna T188 · McCurtain, OKThe pilot's failure to maintain the proper airspeed during a low altitude aerial application maneuver and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodymanic stall at too low of an altiutde to recover.Jun 12, 2020 · N2085J · Substantial damageNTSB WPR20LA170Accident · 1 fatalClass 3 · LimitedFinal reportKitfox Kitfox · Lander, WYThe inexperienced pilot’s exceedance of the airplane’s critical angle-of-attack during a turn at high density altitude, which resulted in an accelerated stall and impact with water. Contributing to the accident was the pilot’s poor judgment to continue the…Jun 7, 2020 · N595KF · Substantial damageNTSB CEN20LA214Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172 · New Washington, INA high velocity descent and impact with terrain for undetermined reasons.Jun 6, 2020 · N13520 · DestroyedNTSB WPR20LA169Accident · 3 fatalClass 3 · LimitedFinal reportCessna 175 · Redlands, CAThe noncertificated pilot’s visual flight rules flight into instrument meteorological conditions and subsequent impact with terrain.Jun 5, 2020 · N9217B · Substantial damageNTSB WPR20CA171Accident · Minor injuriesClass 4 · Data collectionFinal reportEnstrom 480 · Murphy, IDThe pilot's failure to maintain clearance from a power line while maneuvering during an aerial application flight.Jun 4, 2020 · N130JS · Substantial damageNTSB WPR20LA163Accident · 3 fatalClass 3 · LimitedFinal reportBell 206 · Fairfield, CAThe pilot’s failure to maintain adequate clearance from powerlines while conducting external load operations, which resulted in the main rotor contacting a wire and a subsequent collision with terrain.Jun 2, 2020 · N65PJ · Substantial damageNTSB WPR20LA157Accident · 1 fatalClass 3 · LimitedFinal reportCub Crafters CCK-1865 · Valley Center, CAThe pilot's exceedance of the airplane's critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall and subsequent loss of control.Jun 1, 2020 · N303KP · Substantial damageNTSB CEN20LA201Accident · 4 fatalClass 3 · LimitedFinal reportPiper PA28 · Carlinville, ILThe pilot’s attempted recovery from a steep descent which inadvertently exceeded the ultimate load factor of the airframe and resulted in a low-level inflight breakup.May 31, 2020 · N8991W · DestroyedNTSB CEN20WA438Accident · 1 fatalClass 5 · ForeignPitts S2 · Carcassonne, FranceMay 30, 2020 · F-GIZZ · DestroyedNTSB CEN20CA180Accident · Minor injuriesClass 4 · Data collectionFinal reportRotorway Exec · Rochester, INThe pilot's failure to maintain control of the helicopter during lift off. Contributing to the accident was the pilot's lack of recent experience flying a helicopter.May 16, 2020 · N311RM · Substantial damageNTSB WPR20LA147Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Tucson, AZThe pilot improper fuel management, which resulted in running the left fuel tank empty and a subsequent total loss of engine power due to fuel starvation.May 14, 2020 · N63931 · Substantial damageNTSB ERA20CA184Accident · No injuriesClass 4 · Data collectionFinal reportBell OH-58C · Livingston, NYThe pilot's failure to maintain obstacle clearance while maneuvering at low altitude at night, which resulted in the helicopter striking a tree.May 14, 2020 · N183MP · Substantial damageNTSB WPR20LA144Accident · No injuriesClass 3 · LimitedFinal reportMooney M20J · Phoenix, AZA total loss of engine power due to oil starvation for reasons that could not be determined due to a lack of available evidence, which resulted in impact with terrain during a subsequent forced landing.May 13, 2020 · N201HH · Substantial damageNTSB ERA20CA178Accident · Minor injuriesClass 4 · Data collectionFinal reportSchempp Hirth Ventus 2CT · Stuarts Draft, VAA loss of thermal lift during a motor glider flight, which resulted in an off-airport landing. Contributing to the accident was the pilot's delayed attempted engine start.May 11, 2020 · N514TW · Substantial damageNTSB ANC20CA049Accident · No injuriesClass 4 · Data collectionFinal reportCessna 185 · Palmer, AKThe pilot’s decision to attempt to " water ski" atop a remote river in a wheel-equipped airplane, resulting in a loss of control and a nose over.May 6, 2020 · N185SZ · Substantial damageNTSB CEN20LA168Accident · 1 fatalClass 3 · LimitedFinal reportYakovlev YAK 52 · Palmyra, ILA loss of control during a low-altitude aerobatic maneuver.May 2, 2020 · N27YK · DestroyedNTSB CEN20LA167Accident · 1 fatalClass 3 · LimitedFinal reportMD Helicopter 369 · Houston, TXAn uncommanded right yaw that occurred for reasons that could not be determined based on the available evidence, which resulted in a loss control.May 2, 2020 · N8375F · Substantial damageNTSB ERA20LA160Accident · No injuriesClass 3 · LimitedFinal reportHughes 369 · Pylesville, MDThe loss of engine power due to fuel starvation as a result of unporting of the fuel tank supply pickup while the helicopter was maneuvered to move a conductor wire. Contributing to the accident was the helicopter’s inappropriate configuration for the type of…Apr 25, 2020 · N9159F · Substantial damageNTSB ERA20WA174Accident · 2 fatalForeign investigationVans RV7 · Toledo, BrazilThe government of Brazil has notified the NTSB of an accident involving an amateur-built VANS RV7 airplane that occurred on April 23, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…Apr 23, 2020 · PP-ZCA · DestroyedNTSB WPR20CA125Accident · Minor injuriesData collectionFinal reportCessna 172 · Yakima, WAThe pilot's failure to attain sufficient altitude during a go-around, which resulted in impact with hilly terrain.Apr 20, 2020 · N75765 · Substantial damageNTSB DCA20LA100Accident · Serious injuriesClass 3 · LimitedFinal reportSikorsky S61 · Camp Dwyer, AfghanistanFatigue cracking of the auxiliary servo cylinder’s pedal damper check valve housing and its bolts, which caused the sudden and uncommanded movement of the helicopter’s left pedal and a subsequent left yaw that continued until ground impact. Contributing to…Apr 20, 2020 · N908CH · Substantial damageNTSB ERA20CA151Accident · No injuriesData collectionFinal reportPipistrel Sinus · Townsend, TNThe motor glider's encounter with atmospheric lift conditions that were not sufficient to maintain flight, which necessitated a forced landing and resulted in impact with vegetation. Contributing to the accident was the pilot's delayed decision to restart the…Apr 10, 2020 · N711MK · Substantial damageNTSB ERA20LA149Accident · 1 fatalClass 3 · LimitedFinal reportPipistrel Italia Sinus 912 LSA · Marathon, FLThe pilot’s loss of control of the motorized glider, which resulted in an aerodynamic stall and collision with a residential home and postimpact fire. The reason for the loss of control could not be determined due to the condition of the wreckage.Apr 9, 2020 · N6263R · DestroyedNTSB CEN20LA143Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT 502 · Pecan Gap, TXThe pilot did not maintain adequate clearance from tree, which resulted in a collision with a tree and subsequent impact with terrain.Apr 8, 2020 · N9185D · DestroyedNTSB ERA20LA145Accident · 1 fatalClass 3 · LimitedFinal reportSchempp Hirth Standard Cirrus · Groveland, FLThe pilot’s exceedance of the glider’s critical angle of attack following his premature termination of the tow for reasons that could not be determined, which resulted in an aerodynamic stall/spin during a turn back to the departure airport.Apr 7, 2020 · N271BL · Substantial damageNTSB WPR20LA118Accident · 1 fatalClass 3 · LimitedFinal reportKolb Firestar 2 · La Center, WAA loss of control for reasons that could not be determined based on the available information.Apr 6, 2020 · N90KL · Substantial damageNTSB CEN20CA144Accident · No injuriesData collectionFinal reportRobinson R22 · Seymour, TXThe pilot's failure to maintain clearance from a tree while maneuvering at low altitude.Apr 6, 2020 · N7007X · Substantial damageNTSB CEN20CA139Accident · Serious injuriesData collectionFinal reportRans S-12 Airaile · Hillrose, COThe noncertificated pilot's diverted attention while looking at a fire during low-altitude flying, which resulted in a collision with power lines.Apr 4, 2020 · UNREG · Substantial damageNTSB CEN20LA136Accident · 2 fatalClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Audubon, IAThe pilot’s failure to recognize and avoid the power line during the low-altitude flight. Contributing to the accident was the pilot’s fatigue, which affected the pilot’s ability to see and avoid the power line.Mar 31, 2020 · N107EH · DestroyedNTSB GAA21WA049Accident · 1 fatalClass 4 · ForeignCessna 177 · Ebermannstadt, GermanyMar 16, 2020 · D-EDRB · Destroyed