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 NYC95DEI01Accident · 1 fatalFinal reportStaudacher S-600 · Wellington, OHloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in a stall and collision with the ground.NTSB LAX95IA128Incident · No injuriesIncident investigationFinal reportATR 42 · Las Vegas, NVan unexpected lateral control movement associated with in-flight turbulence.NTSB 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.NTSB LAX95IA086Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Albuquerque, NMmaintenance personnel inadvertently overservicing the left main landing gear strut with nitrogen that, during rotation with the aircraft weight on the strut reduced, gave the pilots a rolling sensation to the right.NTSB 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.NTSB BFO95LA016Accident · No injuriesLimited investigationFinal reportCessna 150M · Manville, NJthe certificated flight instructor's failure to maintain adequate supervision of the student pilot and ensure control of the airplane during the landing flare/touchdown. The student pilot's lack of total experience and improper aircraft handling were related…NTSB FTW94LA283Accident · 2 fatalLimited investigationFinal reportWalton Skybolt · Collinsville, OKThe pilot's failure to maintain airspeed resulting in an inadvertent stall.NTSB CHI94LA294Accident · 1 fatalLimited investigationFinal reportWatson KR-2 · Pekin, ILAircraft control not maintained by the pilot and the subsequent stall. A factor associated with the accident was the pilot's lack of recent flight experience.NTSB FTW94FA158Accident · 1 fatalField investigationFinal reportBell 47G-2 · Tulsa, OKIn flight loss of control due to the pilot's improper use of the cyclic and collective controls when he maneuvered abruptly to avoid colliding with a flock of birds. Factors were the birds and the inflight separation of the left synchronized elevator.NTSB FTW94FA140Accident · 2 fatalField investigationFinal reportCessna 150M · Arroyo City, TXThe pilot's inadvertent stall during the pull up. Factors were the low pass, his ostentatious display, and his inability to recover from the stall due to insufficient altitude.NTSB LAX94LA190Accident · 2 fatalLimited investigationFinal reportBushby Mustang II · Byron, CAan abrupt maneuver by the pilot that initiated an in-flight separation of the tail and wing sections during acrobatic flight.NTSB CHI94DCQ01Accident · 1 fatalFinal reportRobert O. ELY STARDUSTER-II SA300 · Baxter Springs, KSthe pilot's failure to maintain altitude during an aerobatic maneuver on takeoff. A factor related to the accident was the pilot performing an aerobatic maneuver.NTSB MIA94LA060Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Naples, FLThe flight instructor's delayed reaction to take control of the helicopter. Contributing factors were the student pilot's improper use of cyclic and collective controls and his failure to release the flight controls to the flight instructor.NTSB NYC94FA040Accident · 2 fatalField investigationFinal reportAero Commander 500A · White Mills, PAwas the fracture and separation of the airplane wing, and the subsequent loss of control and collision with trees, as a result of the pilot's repeated performance of acrobatic maneuvers, which exceeded the design limits of the airplane.NTSB MIA94LA026Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Labelle, FLThe pilot-in-command exceeding the structural limits of the airplane's design limits by in-flight over-stress that resulted in damage to the gear extension system, fuselage and control surfaces.NTSB FTW94LA012Accident · Serious injuriesLimited investigationFinal reportCessna A188 · Burleson, TXWas the pilot's inadvertent entry into a stall. A factor was his abrupt maneuvering of the airplane at low altitude.NTSB CHI94LA008Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Bristol, INthe pilot's abrupt maneuver (intentional swerve) and main gear collapse during the landing roll on a short grass strip.NTSB BFO93LA123Accident · 1 fatalLimited investigationFinal reportRolando Rans S-10 · Numidia, PAThe excessive maneuver attempted by the pilot which resulted in a loss of control in flight and an inadvertent spin at an altitude insufficient for recovery.NTSB SEA93FA151Accident · 1 fatalField investigationFinal reportPiper PA-12 · Laramie, WYPoor inflight planning and an inadvertent stall.NTSB CHI93MA143Accident · 2 fatalMajor investigationFinal reportBeech C99 · Shelton, NEThe deliberate disregard for the federal aviation regulations, gp express procedures, and prudent concern for safety by the two pilots in their decision to execute an aerobatic maneuver during a scheduled check ride flight, and the failure of gp express…NTSB ATL93LA076Accident · No injuriesLimited investigationFinal reportCessna 180 · Jonesboro, GAThe pilot's abrupt and excessive swerve to avoid a deer on the runway. A factor was the strong crosswind that precluded the pilot's directional control recovery.NTSB LAX93LA171Accident · Minor injuriesLimited investigationFinal reportMong SPORT-S · Fallbrook, CAFailure of the pilot to visually clear the runway before starting the takeoff ground run. Factors in the accident were inadequate airspeed at the time of liftoff which resulted in an aerodynamic stall.NTSB FTW93FA108Accident · 2 fatalField investigationFinal reportChampion 7ECA · Dublin, TXThe pilot's attempted maneuver which led to his entry into an inadvertent stallNTSB FTW93FA100Accident · Serious injuriesField investigationFinal reportBoeing 727-200 · Houston, TXThe failure of the pilot of the T-38A to follow flight advisories. A factor which contributed to the accident was the development of a letter of agreement between the FAA and NASA which was not in accordance with ICAO procedures.NTSB DCA93IA027Incident · No injuriesIncident investigationFinal reportAerospatiale ATR42-300 · Newark, NJThe flightcrew's failure to follow approved procedures that required a minimum propeller spped while flying in icing condition. Contributing to the loss of roll control were the encounters with severe turbulence and icing conditions.NTSB CHI93FA075Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Wichita, KSAn improper use of the flight controls by the pilot-in-command.NTSB FTW93LA022Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Commerce, TXThe pilot's failure to maintain aircraft control and the inadvertent stall. A factor was the pilot's evasive maneuver to avoid an undetermined object.NTSB ATL92LA178Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Boone, NCThe pilot's failure to abort the take off, and his abrupt pull up with insufficient airspeed to continue flight. Factors were the inadequate airspeed and the inadvertent stall.NTSB CHI92LA253Accident · No injuriesLimited investigationFinal reportLake LA-4 · Pontiac, MIThe instructor pilot's directing a turn to change heading in the flare.NTSB LAX92LA336Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · San Francisco, CAThe improper installation of the towbar. Contributing to the accident was a disconnected tow bar during push back.NTSB CHI92DEC03Accident · 1 fatalFinal reportJarrell RV-3 · Jackson, MIAn overload and total failure of the rear wing attach fitting.NTSB FTW92LA191Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · N. Little Rock, ARThe pilot's inadvertent entry into a stall.NTSB MIA92LA124Accident · No injuriesLimited investigationFinal reportCessna 172-P · Daytona Beach, FLThe delayed remedial action by the pilot-in-command (CFI) to the student's pushing the control yoke forward on short final approach.NTSB LAX92LA109Accident · 1 fatalLimited investigationFinal report85 Manista KB-2 · Rosamond, CAThe pilot's failure to maintain main rotor RPM adequate to avoid flapping. Factors which contributed to the accident were related to the pilot's performance of an excessively abrupt maneuver.NTSB FTW92LA044Accident · No injuriesLimited investigationFinal reportHiller-Osborn UH-12D · Rio Medina, TXThe pilot's improper flare during touchdown.NTSB FTW92FA014Accident · 2 fatalField investigationFinal reportBeech A36 · Marble Falls, TXThe pilot's performance of acrobatic maneuvers at an altitude too low to allow for recovery.NTSB FTW92IA010Incident · No injuriesIncident investigationFinal reportBoeing 747-300 · Houston, TXThe pilot's failure to attain proper runway alignment prior to touchdown and his failure to initiate a go around to remedy the situation. A factor was the low altitude at which he initiated the side step maneuver for which he was cleared.NTSB FTW92DPJ01Accident · 1 fatalFinal reportAyres S2R-T15 · Cordell, OKInadvertent stall. A factor was that the aircraft weight and balance limitations were exceeded.NTSB ATL91LA171Accident · No injuriesLimited investigationFinal reportCessna 150L · Pickens, SCThe panicked, intentional interference of the flight controls by the student.NTSB DEN91LA122Accident · No injuriesLimited investigationFinal reportStinson 108 · Steamboat Sprin, COA swerve initiated by the pilot in command to avoid a collision with a deer during takeoff roll.NTSB FTW91FA142Accident · 2 fatalField investigationFinal reportCessna 170A · Heath, TXThe inadvertent stall following an abrupt pull up while maneuvering at low altitude, and the pilot's impairment due to to alcohol and drug consumption.NTSB FTW91FA104Accident · 1 fatalField investigationFinal reportCessna C182R · Big Spring, TXThe pilot's failure to recover from an aerobatic maneuver due to insufficient altitude.NTSB LAX91LA250Accident · Minor injuriesLimited investigationFinal reportEagle DW-1 · Stockton, CAFailure of the pilot to maintain an adequate visual outlook to detect power transmission wires in his flight path resulting in an abrupt maneuver and subsequent inadvertent stall.NTSB NYC91FA123Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Hancock Village, NYThe loss of aircraft control and subsequent collision with trees after the pilot became physically incapacitated.NTSB CHI91DEP03Accident · 1 fatalFinal reportAir Command 503 · Tomahawk, WIThe pilot-in-command's abrupt movement of the flight controls which resulted in loss of rotor RPM and eventual departure from controlled flight. A factor contributing was ice accumulation on the pilot's face resulting in pilot incapacitation (visual…NTSB LAX91DXQ01Accident · Minor injuriesFinal reportPitts S-1E · Carson City, NVThe pilot's failure to maintain directional control during takeoff roll and the abrupt pullup to a premature takeoff.NTSB CHI91GA014Accident · 1 fatalFinal reportCessna 172P · Williamsburg, IAThe pilot-in-command's abrupt pull-up to avoid an obstacle. Contributing was the pilot-in-command's diverted attention to activities on the ground.NTSB NYC91LA002Accident · 2 fatalLimited investigationFinal reportForney 415D · Morrisville, NYThe pilot executing a left turn at an altitude insufficient to clear a corn field located in close proximity to the departure runway.NTSB LAX90DUQ02Accident · 1 fatalFinal reportFolland Gnat T-1 · Mojave, CAThe pilots failure to correct a descent during a low level aerobactics.NTSB DEN90LA175Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-19 · Alamogordo, NMThe pilot's failure to maintain control of the glider, which resulted in the pilot induced oscillations.