NTSB investigations
346 cases where the sequence of events included 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '270' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '270' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA16LA330Accident · Serious injuriesLimited investigationFinal reportTatkovsky James G Safari · Andover, NHThe noncertificated pilot’s failure to maintain helicopter control during initial climb.NTSB GAA16CA470Accident · No injuriesData collectionFinal reportCessna 182 · Diller, NEThe pilot's failure to go around after overshooting his intended touchdown point, which resulted in impact with farm equipment and terrain during an aborted landing attempt.NTSB GAA16CA478Accident · No injuriesData collectionFinal reportCessna 180 · Clemson, SCThe pilot’s loss of directional control during the takeoff roll, which resulted in a runway excursion.NTSB CEN16FA346Accident · 2 fatalField investigationFinal reportBellanca 7ECA · Moss Hill, TXThe pilot's loss of control attempting to recover from a low-level aerobatic maneuver. Contributing to the accident was the pilot's decision to attempt the low-level maneuver which significantly reduced any margin for error.NTSB ERA16CA313Accident · No injuriesData collectionFinal reportBell Helicopter Textron Canada 429 · Rikers Island, NYThe pilot’s overcontrolling of the helicopter during an aborted slope landing from a hover, which resulted in a main rotor blade strike.NTSB CEN16FA341Accident · 1 fatalField investigationFinal reportBeech A36 · Bentonville, ARThe pilot's failure to monitor and/or transmit his position over the uncontrolled airport's common traffic advisory frequency, and his decision to continue the takeoff when he observed conflicting traffic on the runway.NTSB WPR16FA169Accident · 1 fatalField investigationFinal reportBoeing A75N1(PT17) · Madras, ORThe pilot's failure to maintain clearance from the runway during a low-level aerobatic maneuver. Contributing to the accident was a high density altitude and the pilot's failure to plan/adequately compensate for high density altitude conditions.NTSB GAA16CA440Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Palmer, AKThe pilot's excessive brake application during the landing roll resulting in a nose over.NTSB ERA16FA279Accident · 1 fatalField investigationFinal reportCessna 414 · Destin, FLThe pilot's loss of control due to spatial disorientation shortly after takeoff, while maneuvering over water during dark night conditions.NTSB GAA16CA396Accident · Minor injuriesData collectionFinal reportCessna 150 · Williamsburg, VAAn evasive maneuver during the landing flare to avoid deer on the runway, which resulted in a collision with trees and terrain during a go-around. Contributing to the accident was the lack of an airport perimeter fence.NTSB ERA16CA229Accident · No injuriesData collectionFinal reportCessna 182T · Crystal River, FLThe pilot's failure to execute a go-around following an unstabilized approach, which resulted in a bounced landing and runway excursion.NTSB GAA16CA339Accident · Minor injuriesData collectionFinal reportHughes 269B · Princeton, CAThe uncertificated pilot's failure to maintain pitch and directional control, which resulted in an impact with terrain and a rollover.NTSB CEN16FA215Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Jonesboro, ARThe pilot's failure to maintain helicopter control during takeoff. Contributing to the accident was the pilot's impairment due to his combined use of alcohol and diphenhydramine, which led to his improper decision to fly after drinking alcohol and degraded…NTSB ERA16LA213Accident · No injuriesLimited investigationFinal reportCessna 310 · Apopka, FLThe intermittent failure of the left brake master cylinder, which resulted in asymmetric braking and the subsequent loss of directional control during the landing roll.NTSB GAA16CA298Accident · No injuriesData collectionFinal reportCessna 182 · Stanley, IDThe pilot's failure to attain an adequate climb gradient, which resulted in a collision with a tree and subsequent substantial damage to the left wing and aileron.NTSB GAA16CA315Accident · No injuriesData collectionFinal reportSeela Gerald L Glasair SH 2F · State College, PAThe pilot's hard landing in gusting wind conditions. Contributing to the accident were the pilot's unfamiliarity with the newly purchased airplane's throttle resulting in an unstable approach, and the pilot's ability to compensate for the wind.NTSB GAA16CA288Accident · No injuriesData collectionFinal reportCessna 172 · Henderson, ARThe pilot's decision to abort the takeoff, which resulted in a hard landing and nose landing gear collapse.NTSB GAA16CA274Accident · Minor injuriesData collectionFinal reportKoons Donald H Cygnet · Zanesville, OHThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, and a nose over.NTSB GAA16CA265Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Laurel, MTThe pilot's loss of directional control during the landing touchdown, resulting in a runway excursion and substantial damage to the both wings.NTSB GAA16CA266Accident · Minor injuriesData collectionFinal reportCessna 177 · Pine Bluff, ARThe pilot’s failure to maintain adequate airspeed and her exceedance of the airplane’s critical angle-of-attack during a low-altitude turn, which resulted in an aerodynamic stall.NTSB GAA16CA283Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Spring Branch, TXThe pilot's failure to maintain helicopter control while hovering in gusting tailwind conditions, resulting in the tailboom striking a light pole and impact with terrain.NTSB GAA16CA243Accident · No injuriesData collectionFinal reportPiper PA-28 · Crystal River, FLThe student pilot's failure to maintain directional control during the takeoff, which resulted in runway excursion and collision with a ditch. Contributing to the accident was the improper flap retraction procedure employed by the pilot during takeoff.NTSB ERA16FA133Accident · 2 fatalField investigationFinal reportCessna 340 · Tampa, FLThe intentional low altitude maneuvering during takeoff in response to a near-miss with an airplane departing from a converging runway, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.NTSB GAA16CA151Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Riverside, CAThe student pilot's incorrect action performance by not applying sufficient pressure to the right anti-torque pedal, resulting in an uncontrollable left yaw, and ground impact.NTSB DCA16WA122Incident · No injuriesForeign investigationBoeing 737 · Malaga, SpainThe government of Spain has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on March 12, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…NTSB WPR16LA075Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R66 · Torrance, CAA vibration of the helicopter, which resulted in an autorotation to soft terrain and subsequent impact of the tail boom with the main rotor. The reason for the vibration could not be determined because postaccident examination revealed no malfunctions or…NTSB GAA16CA141Accident · No injuriesData collectionFinal reportMaule M 4 · Anchorage, AKThe inadvertent rudder input by the passenger, resulting in a runway excursion during takeoff and collision with a taxiway sign.NTSB WPR16FA067Accident · 2 fatalField investigationFinal reportFlight Design Ctls · Springville, CAThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude in hilly terrain, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident were the…NTSB CEN16LA096Accident · 1 fatalLimited investigationFinal reportRaymond Z Brown Condor · Centralia, ILThe failure of the prerotator belt, which impeded the engine's timing belt and resulted in a loss of engine power at low altitude.NTSB ERA16FA097Accident · 3 fatalField investigationFinal reportBrook Aaron D Lancair IV P · Albany, GAThe pilots' failure to maintain control during a takeoff attempt in a high-performance airplane. Contributing to the accident were the pilots' decision to operate the airplane above its maximum gross weight and with an aft center of gravity and their lack of…NTSB ERA16FA084Accident · 1 fatalField investigationFinal reportEros 1600 · Lebanon, TNA failure of the front cylinder piston due to the pilot's improper maintenance, which resulted in a total loss of engine power after takeoff. Contributing to the accident was the pilot's decision to return to the runway at low altitude following the loss of…NTSB CEN16LA052Accident · No injuriesLimited investigationFinal reportCessna 208B · Chicago, ILThe failure of the driver of the service vehicle to yield to the taxiing airplane, which resulted in a near-collision and tail strike.NTSB GAA16CA013Accident · No injuriesData collectionFinal reportBeech F33 · Marana, AZThe student pilot's failure to maintain sufficient airspeed during the base to final turn resulting in an inadvertent aerodynamic stall and impact with terrain during recovery by the flight instructor.NTSB ERA16FA005Accident · 1 fatalField investigationFinal reportPiper PA 38-112 · Jasper, GAThe student pilot's failure to accurately determine the airplane's fuel state, subsequent fuel exhaustion, and a total loss of engine power during initial climb. Contributing to the accident was the flight instructor's inadequate oversight of the student…NTSB CEN15LA436Accident · No injuriesLimited investigationFinal reportBeech C35 · Belen, NMThe total loss of engine power due to contamination in the fuel system.NTSB CEN15FA422Accident · 2 fatalField investigationFinal reportPierce, Henry Bushby Mustang II · Granbury, TXThe pilot's exceedance of the airplane's critical angle of attack resulting in an aerodynamic stall and collision with terrain.NTSB GAA15LA296Accident · No injuriesLimited investigationFinal reportBell 206 · Ozark, ALThe pilot's failure to maintain clearance from terrain while hovering, which resulted in the helicopter's skid impacting terrain, subsequent abnormal airframe vibrations, and a hard landing during the subsequent hovering autorotation.NTSB ERA15FA348Accident · 1 fatalField investigationFinal reportAerofab Lake LA-4-250 · Somerset, NJThe pilot's attempted 180-degree return to the runway immediately after takeoff in dark night conditions, which resulted in collision with trees and terrain. Also causal was the pilot's inadequate preflight inspection, which resulted in a takeoff with…NTSB WPR15FA256Accident · 2 fatalField investigationFinal reportPiper PA28 · Santee, CAThe pilots' failure to maintain airplane control following a partial loss of engine power after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the partial loss of engine power due to a failure of the right magneto.NTSB ERA15CA329Accident · No injuriesData collectionFinal reportCessna 195 · Lancaster, NYThe pilot's excessive application of brake pressure, which resulted in the airplane nosing over.NTSB GAA15CA262Accident · No injuriesData collectionFinal reportAero Commander 500 B · The Dalles, ORA motor vehicle's runway incursion causing the premature rotation of the departing airplane, which resulted in a tail strike.NTSB ERA15LA311Accident · Serious injuriesLimited investigationFinal reportThomas A Siminski Zenith CH 750 · Allentown, PAA partial loss of engine power due to the No. 1 spark plug being liberated from the cylinder head due to the stripped threads in the cylinder head. Contributing to the accident was the pilot’s decision to attempt to return to the airport while at a low…NTSB GAA15CA224Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Caldwell, IDThe helicopter flight instructor's delayed remedial action during an autorotation resulting in a loss of control and impact with terrain.NTSB GAA15CA221Accident · No injuriesData collectionFinal reportBell 47D1 · Clanton, ALThe student pilot's abrupt cyclic and collective inputs during the approach to land which resulted in abnormal runway contact and a subsequent tail boom strike by the main rotor blades.NTSB GAA15CA154Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Eagle Lake, TXThe pilot's failure to secure the iPad during flight, resulting in an inadvertent cyclic input, and collision with terrain.NTSB GAA15CA081Accident · Serious injuriesData collectionFinal reportCitabria 7GCBC · Winnsboro, SCThe pilot's execution of a steep left turn at low altitude during an aborted landing, which resulted in an aerodynamic stall, and a collision with terrain.NTSB ERA15FA175Accident · 1 fatalField investigationFinal reportBedecorp BD-22 · Fort Pierce, FLThe pilot's excessive pitch control inputs to the airplane’s sidestick control, which resulted in an overstress of the airframe and its subsequent in-flight breakup. Contributing to the accident was the pilot's decision to operate the airplane contrary to the…NTSB ERA15LA168Accident · Minor injuriesLimited investigationFinal reportTrick Trikes 582 Cyclone Storm · Live Oak, FLThe student pilot applicant’s failure to clear the engine during a prolonged descent of a simulated engine failure and his subsequent rapid throttle input at the completion of the maneuver, which resulted in the engine’s failure to respond. Contributing to…NTSB GAA15CA010Accident · No injuriesData collectionFinal reportJabiru USA Sport J250 SP · Hondo, TXThe student pilot's failure to maintain directional control during landing roll, which resulted in a loss of control. Contributing to this accident was the flight instructor's delayed remedial action.NTSB WPR15FA125Accident · 1 fatalField investigationFinal reportBAE Systems MK-67 Hawk · Yuma, AZThe pilot’s initiation of an early rotation during takeoff, which led to an aerodynamic stall and loss of airplane control. Contributing to the accident were the pilot's use of nose up pitch trim and the operator's policy to use nose-up pitch trim during…