NTSB investigations
288 cases where the first occurrence was “Abrupt maneuver”.
Cases, newest first
Query with SQL
duckdb -csv -c "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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 100) 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.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 100) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB FTW01FA129Accident · 1 fatalField investigationFinal reportCessna 150 · Pryor, OKthe failure of the glider pilot to maintain aircraft control and his delay in releasing the towrope. A contributing factor was the glider's worn elevator trim friction, which resulted in its disengagement.NTSB ANC01LA037Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Fairbanks, AKThe flight instructor's inadequate supervision of the flight during the landing flare. A factor in the accident was the student's abrupt airplane control.NTSB DEN01FA044Accident · 2 fatalField investigationFinal reportAero Vodochody Aero. Works L-39CT · Watkins, COThe pilot's failure to maintain aircraft control, and the subsequent inadvertent stall/mush. Factors were the pilot's diverted attention due to the failure of the rear canopy's acrylic transparency and the loss of communication with his back seat passenger,…NTSB ATL01LA013Accident · No injuriesLimited investigationFinal reportBeech BE-23-A24R · Jackson, MSDeer on the runway, which forced the pilot to make an evasive maneuver forcing him to the side of the runway and striking the marker lights.NTSB LAX01LA039Accident · No injuriesLimited investigationFinal reportMesserschmitt-Boelkow-Blohm BO-105CBS-5 · Parumph, NVThe pilot's failure to verify the presence of wires near the remote landing site during the high reconnaissance, and his misjudgement of the clearance from the ground during the attempted hovering turn to avoid the wire obstacle. Factors were the dark night…NTSB CHI01LA020Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Pulaski, WIthe evasive maneuver initiated by the pilot. Factors were the presence of the skydiver on the runway, and the pilot's selection of a closed runway.NTSB ANC00LA132Accident · No injuriesLimited investigationFinal reportEurocopter AS-350B-3 · Ketchikan, AKThe pilot's inadvertent activation of the collective flight stop/emergency fuel augmentation switch, which resulted in engine and main rotor overspeeds, thereby precipitating failures of the tail rotor drive shaft coupling and power turbine blades. A factor…NTSB CHI00LA269Accident · Serious injuriesLimited investigationFinal reportBoeing 737-322 · Chicago, ILthe evasive maneuver performed by the pilot. A factor was the activation of the collision avoidance system.NTSB CHI00LA228Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Harbor Springs, MIthe pilot selected the wrong runway direction in which to land and he did not perform a go-around when he realized the landing approach was too high. Factors associated with the accident were the tailwind condition, the improper glidepath, and the intentional…NTSB ANC00LA080Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nikiski, AKA bear running onto the landing area during the landing flare. A factor associated with the accident was the high vegetation on the edge of the airstrip.NTSB ANC00LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Lake, AKThe pilot's excessive application of heel brakes. A factor associated with this accident was the pilot's lack of experience in the make and model of airplane.NTSB IAD00IA032Incident · No injuriesIncident investigationFinal reportBoeing 767-332 · New York City, NYThe first officer's failure to maintain control of the airplane during climb out over water at night, which was a result of spatial disorientation. Factors in the incident were the cloud layer and dark night.NTSB MIA00FA102Accident · 2 fatalField investigationFinal reportMcDonnell Douglas HU-600N · Miami, FLThe pilot's ostentatious display and in-flight decision to perform an abrupt low altitude pitch up maneuver (aerobatic flight). This resulted in the main rotor blades colliding with and separating the tail boom assembly while maneuvering, and the helicopters…NTSB MIA99LA272Accident · Serious injuriesLimited investigationFinal reportBoeing 767-332 · Atlanta, GAFAA approach/departure controller's improper service and failure to coordinate and resolve a conflict between aircraft prior to effecting a frequency change, and the improper application of visual separation rules to a flight in the clouds, resulting the crew…NTSB FTW99FA211Accident · 2 fatalField investigationFinal reportCessna 177 · Wagoner, OKThe pilot's inadvertent stall while performing an abrupt maneuver at low altitude.NTSB CHI99LA169Accident · 1 fatalLimited investigationFinal reportHornbeck Glassair · Johnson City, KSThe pilot's intentional low altitude performance of aerobatics.NTSB FTW99LA152Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Cherry Valley, ARThe pilot's inadvertent stall due to his evasive maneuver to avoid colliding with a truck on the runway. A factor was the runway incursion by the truck.NTSB NYC99FA097Accident · 1 fatalField investigationFinal reportIves Sonerai II-L · Eastford, CTInadequate welding of the airplane's spar-box by the owner/builder, which resulted in a total spar-box failure in-flight. A factor in the accident was the pilot's decision to perform aerobatics.NTSB MIA99LA039Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Fort Lauderdale, FLan abrupt maneuver in response to a traffic avoidance system alert, resulting in a flight attendant falling and breaking a leg.NTSB CHI99LA027Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Monticello, INlow altitude stall and an ostentatious display by the pilot. Factors associated with this accident were the performance of a low altitude maneuver and an abrupt pullup by the pilot.NTSB IAD98GA110Accident · 1 fatalFinal reportHughes OH-6A · Newark, TXFailure of the Instructor Pilot to control the helicopter's rate of descent during a demonstrated autorotation. Contributing to the accident were the Operator's lack of: a. Instructor Pilot standardization procedures, and b. Specific or adequate flight…NTSB ANC98LA155Accident · No injuriesLimited investigationFinal reportPiper PA-12 · New Stuyahok, AKThe pilot's selection of an unsuitable takeoff area and his intentional ground loop maneuver. A factor associated with the accident was trees.NTSB NYC98LA169Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Jackson Twnshp, NJThe flight (check pilot) instructor's excessive pull-up maneuver and his inadvertent entry into a low altitude stall/spin.NTSB IAD98FA086Accident · 2 fatalField investigationFinal reportConsolidated-Vultee BT-13A · Stevensville, MDThe pilot-in-command's failure to maintain aircraft control while buzzing a building.NTSB ANC98FA079Accident · 1 fatalField investigationFinal reportCessna 185 · Big Lake, AKThe pilot's performance of a low level maneuver. Factors were the pilot's overconfidence in his personal ability, his lack of experience in the type of airplane, and his failure to maintain adequate clearance from terrain.NTSB LAX98FA171Accident · 2 fatalField investigationFinal reportVans RV-8 · Ripley, CAthe intentional or unintentional sudden application of aft elevator control by an undetermined aircraft occupant that exceeded the design stress limits of the aircraft. The aircraft gross weight, which exceeded the maximum allowable for aerobatics, and…NTSB IAD98FA061Accident · 1 fatalField investigationFinal reportSukhoi SU-29 · Manassas, VAThe pilot's failure to maintain adequate altitude/clearance during an aerobatic maneuver.NTSB IAD98FA049Accident · 2 fatalField investigationFinal reportFairchild Hiller FH-1100 · Stevensville, MDThe pilot's abrupt, low-g maneuver, which resulted in mast bumping and separation of the main rotor system.NTSB LAX98LA132Accident · Minor injuriesLimited investigationFinal reportBellanca BL17-30A · Prescott, AZThe pilot's failure to attain directional control after swerving off the runway and impacting a ditch.NTSB ANC97FA159Accident · 1 fatalField investigationFinal reportde Havilland DHC-2 · Ketchikan, AKThe pilot's excessive climb and turning maneuver at low altitude, the pilot's inadvertent stall, and the intentional operation of the airplane with the required stall warning system disabled. Factors associated with this accident were the pilot's…NTSB CHI97FA300Accident · 2 fatalField investigationFinal reportBeech T34B · Fremont, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall. Also causal was the pilot's ostentatious display.NTSB CHI97LA225Accident · No injuriesLimited investigationFinal reportSorrell SNS-7 · Tomahawk, WIThe pilot encountered a tailplane stall. The factors involved were the pilot conducted a low altitude flight maneuver and encountered engine torque effect.NTSB ANC97LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Fairbanks, AKThe pilot's initiation of an abrupt, evasive maneuver, and his failure to maintain directional control of the airplane. Factors in the accident were an undetermined object crossing the runway and the passenger's rudder control interference during the evasive…NTSB LAX97GA235Accident · 1 fatalFinal reportBell BHT-206L-1 · Highland, CALoss of engine power due to fuel contamination. Also causal was the ingestion of entrapped air that occurred during an abrupt maneuver and fuel-borne contamination that caused the fuel system check valves to leak, resulted in a lower than expected fuel level…NTSB LAX97LA227Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G-103-TWIN II · Jacumba, CAThe pilot's abrupt rotation, which resulted in the breaking of the tow rope. A factor was the low altitude when the tow rope broke, precluding a landing on the runway.NTSB FTW97FA207Accident · 1 fatalField investigationFinal reportCanadair F-86E MK.6 · Broomfield, COInadequate planning and decision making by the pilot in starting the aerobatic maneuver at an insufficient altitude to successfully complete the maneuver.NTSB CHI97LA137Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Paragon, INthe pilot did not maintain aircraft control. The factors involved were aerobatics were performed and improper use of aircraft.NTSB CHI97FA116Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Holland, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent impact with trees and then a residence. A related factor was turbulence.NTSB LAX97LA061Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-600N · Flagstaff, AZThe pilot's inattention to the altitude and inadvertent late entry into an autorotation maneuver below the established minimum test altitude with a helicopter operating at maximum gross weight in a high density altitude environment that led to a subsequent…NTSB LAX97LA014Accident · 1 fatalLimited investigationFinal reportCunningham Rotorway Exec · Mather, CAexcessive maneuvering by the pilot, which allowed the main rotor blades to contact and sever the tail rotor system and allowed mast bumping to occur.NTSB CHI97LA010Accident · 2 fatalLimited investigationFinal reportDellicker Starduster TOO SA300 · Eaton Rapids, MIthe pilot's failure to maintain adequate airspeed and subsequent inadvertent stall of the airplane. A factor was the ostentatious display.NTSB IAD96LA137Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Waterford, OHthe pilot's decision to abruptly maneuver the airplane with insufficient altitude to recover.NTSB ANC96LA113Accident · No injuriesLimited investigationFinal reportSportsman 2+2 · Wasilla, AKThe pilot's failure to maintain control of the airplane which resulted in an inadvertent stall/mush. A factor associated with the accident was the pilot's low altitude skidding maneuver.NTSB NYC96LA148Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-11 · Westerly, RIinsufficient information from the manufacturer in the airplane flight manual and flightcrew operating manual regarding the hazards of applying force to the control wheel or column while the autopilot is engaged and adjusting the pitch thumbwheel during a…NTSB FTW96LA269Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-340-200 · Dfw Airport, TXThe flightcrew's abrupt maneuver/descent in response to a TCAS RA. Factors were the company assignment of the captain to the crew position with a lack of captain training.NTSB LAX96LA231Accident · Serious injuriesLimited investigationFinal reportVans RV6 · Inyokern, CAthe pilot's failure to maintain control of his airplane and stalled while intentionally performing a low altitude maneuver on base leg in a high density altitude environment.NTSB CHI96LA202Accident · No injuriesLimited investigationFinal reportPiper PA-44 · Grand Forks, NDthe instructor pilot used an improper procedure when he demonstrated a rejected takeoff and he misjudged the flare.NTSB LAX96LA207Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-600 · Thermal, CAinadequate design of the stress limits for cyclic control of the helicopter.NTSB LAX96LA037Accident · 1 fatalLimited investigationFinal reportNorth American AT-6D · Richvale, CAthe attempt by the pilot to execute an aerobatic maneuver with inadequate altitude to effect recovery before impacting terrain.NTSB FTW95LA244Accident · 1 fatalLimited investigationFinal reportWalter W. Bell Lazer Edge · El Reno, OKThe pilot's failure to maintain control resulting in an inadvertent stall/spin. Factors were the pilot's performance of aerobatic maneuvers at the low altitude.