NTSB investigations
3,842 cases where the defining event was Loss of control in flight.
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '240') 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 ERA16WA315Accident · 2 fatalForeign investigationAir Tractor AT502 · Sorriso, BrazilOn September 1, 2016, about 1905 coordinated universal time, a privately owned and operated Air Tractor AT-502B, Brazilian registration PR-SLV, experienced an in-flight loss of control and impacted terrain near Sorriso Municipality, State of Mato Grosso,…NTSB CEN16LA343Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Hibbing, MNThe pilot's failure to maintain aircraft control, which resulted in impact with terrain near the runway.NTSB WPR16FA170Accident · 2 fatalField investigationFinal reportCessna 182 · Clinton, MTThe sudden right turn on approach to landing for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR16WA190Accident · 1 fatalForeign investigationXtremeair XA42 · Zhangye Ganzhou, ChinaOn August 27, 2016, at 1047 local time, an XtremeAir XA-42, N344XA, operated by Southern Aircraft Consultancy Inc. collided with the ground during an aerobatic maneuver at an airshow near the Zhangye Ganzhou Airport, China. The airplane was operating under…NTSB ERA16LA301Accident · Minor injuriesLimited investigationFinal reportMeans Rober C Rotorway Exec · Iron Station, NCThe pilot’s failure to maintain adequate clearance from the ground while hovering, which resulted in separation of the forward section of the right skid tube with counterweight attached, a sudden center of gravity (CG) shift outside the normal operating…NTSB CEN16LA329Accident · Serious injuriesLimited investigationFinal reportCollins RV6A · Pekin, ILThe pilot's failure to latch the canopy before takeoff, and his subsequent distraction and failure to maintain control while attempting to close the open canopy, which resulted in an aerodynamic stall.NTSB CEN16WA345Accident · No injuriesForeign investigationRobinson R44 · Plasy, CzechiaNTSB CEN16FA315Accident · 1 fatalField investigationFinal reportHughes 269C · Howe, TXThe improper execution of an autorotation following the loss of engine power, which resulted in an uncontrolled descent into terrain. Contributing to the accident was the flight instructor's lack of remedial action during the autorotation.NTSB CEN16CA319Accident · No injuriesData collectionFinal reportCessna 172S · Arlington, TXThe student pilot's improper recovery from a bounced landing.NTSB ERA16LA286Accident · Minor injuriesLimited investigationFinal reportCessna 177 · McDonough, NYThe pilot’s improper recovery from a slow flight configuration at low altitude, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot’s decision to operate at low…NTSB CEN16FA308Accident · 1 fatalField investigationFinal reportPzl-Bielsko SZD 55-1 · Channahon, ILThe glider pilot's failure to maintain adequate pitch control while being towed and his subsequent failure to maintain adequate airspeed control after releasing from the towline, which resulted in the glider exceeding its critical angle of attack and an…NTSB CEN16FA307Accident · 1 fatalField investigationFinal reportWilson BUGATTI-DEMONGE 100P · Burns Flat, OKThe pilot's failure to maintain airspeed following an engine anomaly during the initial climb after takeoff, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was an…NTSB CEN16LA332Accident · No injuriesLimited investigationFinal reportPiper PA 25-235 · Miller, MOThe mechanic's improper installation of the left aileron swage fitting, which resulted in an inflight loss of control.NTSB DCA16WA218Accident · 4 fatalForeign investigationRobinson R44 · Lusikisuki, near Port John, Eastern Cape Province, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Robinson R44 helicopter that occurred on August 03, 2016. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…NTSB CEN16LA300Accident · Serious injuriesLimited investigationFinal reportWings AN Things Avid Flyer · Bluffton, INThe loss of roll control during climb for reasons that could not be determined because postaccident examination of the airframe revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN16FA304Accident · 1 fatalField investigationFinal reportSchweizer 269C 1 · Jeanerette, LAThe pilot's loss of helicopter control for reasons that could not be determined based on available evidence.NTSB WPR16LA156Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Prescott, AZThe flight instructor’s delayed remedial action to address a low rotor rpm condition, which resulted in an excessive descent rate and a subsequent hard landing.NTSB WPR16FA154Accident · 1 fatalField investigationFinal reportSperling Richard G Lancair 360 · The Dalles, ORThe pilot's loss of control during an aborted landing. Contributing to the accident was the pilot's failure to extend the landing gear before touchdown.NTSB GAA16CA411Accident · No injuriesData collectionFinal reportBeech F33 · Blythe, CAThe pilot's failure to attain adequate airspeed to climb and her exceedance of the airplane's critical angle-of-attack during takeoff initial climb at night, which resulted in an aerodynamic stall at low altitude.NTSB GAA16CA406Accident · No injuriesData collectionFinal reportCessna 177 · Kalispell, MTThe airplane's hard landing during an aborted takeoff, following an encounter with a downdraft during takeoff initial climb from a remote mountain airstrip, resulting in an uncontrolled descent, attempt to land on the runway remaining, and subsequent nose…NTSB ANC16CA053Accident · No injuriesData collectionFinal reportCessna U206G · Sleetmute, AKThe pilot's failure to maintain adequate airspeed during the initial climb after taking off from a wet runway and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN16LA293Accident · No injuriesLimited investigationFinal reportBoam Larry Rans S 7 · Oshkosh, WIThe pilot's failure to maintain airplane control on takeoff, which resulted in his remedial action to induce an aerodynamic stall and the subsequent impact with terrain.NTSB CEN16LA291Accident · 1 fatalLimited investigationFinal reportAir Tractor AT602 · David City, NEThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN16FA295Accident · 1 fatalField investigationFinal reportMooney M20J · Holmen, WIThe pilot's loss of airplane control during an instrument approach. Contributing to the accident was the pilot's lack of instrument flight proficiency.NTSB WPR16FA152Accident · 4 fatalField investigationFinal reportCessna 310B · Columbia, CAThe pilot's failure to maintain control during takeoff initial climb for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN16LA283Accident · Serious injuriesLimited investigationFinal reportBristell E-LSA · Oshkosh, WIThe pilot’s exceedance of the airplane’s critical angle of attack on short final approach, which resulted in an inadvertent aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot’s distraction with other traffic in the…NTSB ERA16LA267Accident · Serious injuriesLimited investigationFinal reportTemple Benjamin Freedom Master FM-2 · East Haddam, CTThe pilot’s loss of airplane control during the initial climb.NTSB CEN16FA278Accident · 2 fatalField investigationFinal reportHarris-Runyan Skybolt 300 · Fairmont, OKThe pilot's delay in recovering from an aerobatic maneuver resulting in collision with terrain.NTSB CEN16FA276Accident · 1 fatalField investigationFinal reportPiper PA 30 · Plainfield, ILThe pilot's failure to maintain airplane control during an en route climb near convective activity, which resulted in an aerodynamic stall, an uncontrolled descent, and a subsequent in-flight breakup due to an exceedance of the airplane's design load…NTSB GAA16CA384Accident · Minor injuriesData collectionFinal reportBoeing A75 · St. James, MOThe pilot's loss of control while performing an aerobatic maneuver resulting in an inadvertent spin and collision with trees and terrain.NTSB ERA16CA259Accident · Minor injuriesData collectionFinal reportHirn Associates Zodiac CH601XL · Hedgesville, WVThe pilot’s inadvertent activation of the elevator trim, which resulted in a premature takeoff and subsequent loss of airplane control and collision with trees.NTSB ANC16WA044Accident · 1 fatalForeign investigationNorth American T28 · Cold Lake, CanadaOn July 17, 2016, about 1951 Coordinated Universal Time, a Canadian registered North American Aviation T-28B airplane, C-GKKD, owned and operated by a private individual, impacted terrain near Cold Lake, Alberta, Canada, while performing aerobatic maneuvers…NTSB CEN16LA266Accident · 1 fatalLimited investigationFinal reportToevs Titanium Explorer · Whitewater, KSThe loss of aircraft control for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN16WA279Accident · 1 fatalForeign investigationRans S6 · Murcia, SpainOn July 15, 2016, about 1910 coordinated universal time (UTC), a Rans S-6, EC-YDQ, sustained substantial damage when it impacted terrain after a loss of control while landing at the Los Garranchos Airport, Murcia, Spain. The pilot received fatal injuries. The…NTSB ERA16WA262Accident · 5 fatalForeign investigationCessna TU206 · Charrasquera, ColombiaOn July 11, 2016, about 1507 coordinated universal time, a Cessna TU206G airplane, Colombian registration HK2940, was destroyed when it impacted dense jungle near Charrasquera-San Jose del Guaviare, Colombia. The Colombian certificated pilot and four…NTSB GAA16CA372Accident · Minor injuriesData collectionFinal reportBell OH 58 · Surprise, AZWhile at a low altitude, the pilot's decision to do an abrupt descending right downwind turn which resulted in flying through his own vortices and an impact with terrain.NTSB CEN16LA260Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Kennett, MOThe pilot's failure to maintain clearance from power lines while maneuvering during the aerial application flight.NTSB CEN16WA257Accident · 2 fatalForeign investigationCirrus SR22 · Madrid, Spain, SpainOn July 5, 2016, about 1940 coordinated universal time, a Cirrus SR22 single engine airplane, serial number 2558, registry EC-KJO, was destroyed after impacting terrain and obstructions while landing at Cuatro Vientos Airport at Madrid, Spain. The two…NTSB ERA16FA238Accident · 1 fatalField investigationFinal reportGerdts Mark E RV7A · Weston, FLThe pilot's loss of airplane control for reasons that could not be determined based on the available evidence.NTSB CEN16LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA 25-235 · Arlington, WIThe pilot’s failure to establish proper airspeed and angle-of-attack during takeoff with the airplane at its maximum gross weight in elevated density altitude and gusting tailwind conditions, which resulted in an aerodynamic stall.NTSB CEN16FA240Accident · 2 fatalField investigationFinal reportAeronca 11AC · Frankenmuth, MIThe pilot's loss of control for undetermined reasons based on available information.NTSB ERA16WA256Accident · 4 fatalForeign investigationCessna 182 · Belem, BrazilOn July 2, 2016, about 1625 coordinated universal time (1325 local time), a Cessna 182E, Brazilian registration PT-DJH, operated by Aerotur Taxi Aereo LTDA, was destroyed after it impacted the ground shortly after takeoff from Julio Cesar Airport (SBJC),…NTSB ERA16CA239Accident · Serious injuriesData collectionFinal reportPiper PA 22-160 · Harrisonburg, VAThe pilot's loss of directional control during takeoff in gusting crosswind conditions.NTSB WPR16LA137Accident · No injuriesLimited investigationFinal reportRockwell International S 2R · Brawley, CAThe airplane’s inability to climb and subsequent impact with terrain for reasons that could not be determined based on the available information.NTSB ERA16LA236Accident · No injuriesLimited investigationFinal reportPiper PA34 · Winnsboro, SCThe pilot's failure to maintain sufficient airspeed during a go-around, and the flight instructor's delayed remedial action, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the…NTSB CEN16LA245Accident · Serious injuriesLimited investigationFinal reportEvolution Revo · Holland, MIThe flight instructor's failure to maintain aircraft control during landing as a result of his failure to adjust the electric trim to the proper position for landing.NTSB GAA16CA335Accident · Minor injuriesData collectionFinal reportRans Employee Flying Club Rans S 6S · Richwood, OHThe pilot's exceedance of the critical angle of attack during an initial climb of an aborted landing, which resulted in an inadvertent aerodynamic stall and impact with terrain.NTSB WPR16FA126Accident · 1 fatalField investigationFinal reportPiper PA 23-150 · Hayward, CAThe failure of the left engine due to water contamination and the pilot's subsequent failure to maintain single-engine minimum control airspeed, which resulted in an uncontrolled descent. Contributing to the accident was the pilot's lack of total and recent…NTSB ERA16CA246Accident · No injuriesData collectionFinal reportMooney M20 · Clifton, TNThe flight's encounter with unforecast extreme turbulence, which resulted in a loss of airplane control and structural damage.NTSB ANC16RA037Accident · 3 fatalForeign investigationCirrus SR20 · Muan, South KoreaOn June 17, 2016 , about 1515 local time, a Cirrus SR20 airplane, Republic of Korea registration number HL1210, operated by the pilot, was destroyed following a loss of control while on approach to Muan International Airport, Republic of Korea. The flight…