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 CEN17LA275Accident · Minor injuriesLimited investigationFinal reportGolden Circle Air T-BIRD II · Dunn Center, NDThe pilot's failure to maintain airplane control, his inadequate quartering tailwind correction during takeoff, and his decision to continue the takeoff to the south with insufficient road length remaining.NTSB WPR17FA155Accident · 2 fatalField investigationFinal reportEvolution 19 Lancair Evolution · Mesa, AZThe pilot's failure to maintain adequate airspeed while maneuvering for landing, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent stall/spin. Contributing to the accident was the pilot's distraction due to a failure…NTSB GAA17CA417Accident · No injuriesData collectionFinal reportPerner/Pitts S1S · Brenham, TXThe pilot's failure to maintain lateral/bank and yaw control during a go-around.NTSB ERA17LA252Accident · No injuriesLimited investigationFinal reportCessna R172 · Naples, METhe pilot's failure to maintain airplane control during landing.NTSB CEN17FA270Accident · 2 fatalField investigationFinal reportNorth American/Aero Classics P 51 · Cummings, KSThe loss of airplane control while maneuvering at low altitude for reasons that could not be determined.NTSB WPR17LA154Accident · No injuriesClass 3 · LimitedFinal reportBeech D55 · Hailey, IDThe pilot’s loss of directional control during landing.NTSB WPR17FA151Accident · 2 fatalField investigationFinal reportPiper PA 44-180 · Marineland, FLA loss of control in flight for reasons that could not be determined based on the available information, which resulted in an in-flight breakup.NTSB GAA17CA404Accident · Minor injuriesData collectionFinal reportEurocopter AS 350 · King Vale, CAThe pilot’s failure to maintain clearance from trees while landing in a dusty, unimproved landing zone.NTSB GAA17CA406Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 · Wilkes-Barre, PAThe flight instructor's delayed remedial action to maintain helicopter altitude during hover flight instruction, which resulted in the helicopter skid contacting a crack in the runway and a dynamic rollover.NTSB WPR17LA145Accident · Serious injuriesLimited investigationFinal reportPiper L 21B · Big Timber, MTThe pilot's decision to fly at low altitude in the vicinity of power lines, which resulted in a wire strike.NTSB CEN17FA259Accident · 1 fatalField investigationFinal reportAir Tractor AT 602 · Cash, ARThe pilot's incapacitation due to a cardiac event, which resulted in a loss of airplane control.NTSB CEN17FA258Accident · 2 fatalField investigationFinal reportPiper PA 28-181 · Waterford, OHThe pilot's loss of airplane control due to spatial disorientation in instrument meteorological conditions.NTSB GAA17CA386Accident · Minor injuriesData collectionFinal reportAlexander Schleicher ASH 31 MI · Ely, NVThe pilot’s failure to maintain the proper airspeed and his exceedance of the glider’s critical angle of attack, which resulted in a stall/spin.NTSB ERA17WA228Accident · 1 fatalForeign investigationBell 206 · Republic of Buryatia, RussiaThe government of Russia has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on July 05, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the provisions of…NTSB GAA17CA384Accident · Minor injuriesData collectionFinal reportCessna P210 · Willits, CAThe pilot’s failure to maintain directional control while landing in gusting wind conditions. Contributing to the accident was the pilot’s failure to go around after the unstabilized approach.NTSB ERA17LA229Accident · Serious injuriesLimited investigationFinal reportAviat A-1C-180 · Dillwyn, VAThe pilot's selection of a grass airstrip that was of insufficient length for landing, and his exceedance of the airplane's critical angle of attack during the go-around, which resulted in an aerodynamic stall.NTSB ERA17FA226Accident · 1 fatalField investigationFinal reportLuscombe 8 · Remsen, NYThe pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall at an altitude too low for him to recover.NTSB GAA17CA421Accident · No injuriesData collectionFinal reportAviat A 1 · Dixie, IDThe pilot's failure to maintain an appropriate glidepath to landing with sun glare and downdraft conditions, which resulted in the airplane landing in a ravine short of the runway.NTSB GAA17CA379Accident · No injuriesData collectionFinal reportAmerican General Acft AG5 · Rio Vista, CAThe student pilot’s failure to maintain directional control during a go-around in gusting wind conditions.NTSB ERA17FA231Accident · 1 fatalField investigationFinal reportCessna 152 · Homestead, FLThe pilot's loss of control due to spatial disorientation while maneuvering in night conditions over an area devoid of ground reference lights.NTSB CEN17LA250Accident · 1 fatalLimited investigationFinal reportNorth American T-28A · Moorhead, MNControlled descent into terrain due to engine issues, the reason for which could not be determined because examination of the engine revealed no evidence of malfunctions or failures that would have precluded normal operation.NTSB WPR17FA139Accident · 2 fatalField investigationFinal reportNorth Wing Uum Sport X2 912 · Chelan, WAThe flight instructor's failure to maintain control of the aircraft while demonstrating a spiral dive, which resulted in a loss of control. Contributing to the accident was the instructor's decision to demonstrate a spiral dive maneuver at an altitude that…NTSB ERA17FA222Accident · 4 fatalField investigationFinal reportPiper PA23 · Chatsworth, GAThe noninstrument-rated pilot's continued visual flight rules flight into adverse weather conditions, which resulted in an encounter with severe convective activity, spatial disorientation, a loss of airplane control, and a subsequent in-flight breakup.…NTSB CEN17FA249Accident · 1 fatalField investigationFinal reportFlight Design Ctsw · Monticello, IAThe pilot's decision to fly with his large dog in the two-seat, light sport airplane, and the dog's likely contact with the flight controls during landing, which resulted in the pilot's loss of airplane control and a subsequent aerodynamic stall when the…NTSB CEN17FA248Accident · 6 fatalField investigationFinal reportCessna 421C · Catawba, WIA loss of control and subsequent in-flight breakup for reasons that could not be determined based on the available information.NTSB GAA17CA375Accident · No injuriesData collectionFinal reportUrbanczyk Miroslaw Radio Flyer · Tehachapi, CAThe noncertificated pilot’s failure to maintain clearance from residential buildings and trees in gusting wind conditions.NTSB GAA17CA370Accident · Minor injuriesData collectionFinal reportAero-Ace CE 1 · Cottonwood, AZThe pilot’s failure to maintain directional control during takeoff in gusting crosswind conditions.NTSB CEN17WA243Accident · 2 fatalForeign investigationPiper L4 · Liberecký, CzechiaOn June 25, 2017, at 1200 Coordinated Universal Time, a Piper L4, OM-M038, impacted terrain after takeoff from Hodkovice Airport (LKHD), Liberecký, Czech Republic. The airplane was destroyed. The pilot sustained serious injuries, and the passenger sustained…NTSB GAA17CA368Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Discus 2B · Bishop, CAThe pilot’s exceedance of the glider’s critical angle of attack while maneuvering over rising mountainous terrain, which resulted in an aerodynamic stall.NTSB GAA17CA360Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Portales, NMThe pilot's decision to fly the airplane under transmission lines while maneuvering at low altitude in high-density altitude conditions, which resulted in subsequent collision with terrain.NTSB GAA17CA356Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Matagorda, TXThe pilot’s failure to maintain helicopter control during an agricultural flight in gusting wind conditions.NTSB CEN17WA237Accident · 1 fatalForeign investigationAmateur Construction Kolb Firefly · Luffenhall, United KingdomOn June 20, 2017, about 0920 Coordinated Universal Time (UTC), a Kolb Firefly ultralite, British registration G-CEPN, impacted terrain under unknown circumstances near Newell Lane, Luffenhall, Hertfordshire, England. The pilot, the sole occupant on board, was…NTSB ANC17LA033Accident · No injuriesClass 2 · LimitedFinal reportPiper PA 12 · Skwentna, AKThe pilot's failure to properly secure the external load, which resulted in the load shifting during flight, interference with the water rudder cable, and a subsequent loss of controlNTSB GAA17CA342Accident · Minor injuriesData collectionFinal reportAir Tractor AT 802 · Pocahontas, ARThe pilot's failure to maintain lateral/bank control during the initial climb in turbulent conditions.NTSB CEN17LA232Accident · Serious injuriesLimited investigationFinal reportBell-Tellijohn 47G · Hastings, MNThe pilot's failure to maintain helicopter control for reasons that could not be determined because postaccident examination of the helicopter did not reveal any preimpact mechanical malfunctions or anomalies that would have precluded normal operation.NTSB GAA17CA340Accident · Minor injuriesData collectionFinal reportSportine Aviacija LAK 12 · Reno, NVThe glider pilot’s failure to maintain proper pitch during an aerotow takeoff.NTSB GAA17CA338Accident · No injuriesData collectionFinal reportPiper PA 28 · Estherville, IAThe student pilot's failure to maintain crosswind correction during a go-around in gusting wind conditions.NTSB CEN17FA227Accident · 2 fatalField investigationFinal reportBeech E 90 · Ruidoso, NMThe pilot's failure to maintain clearance from terrain after takeoff during dark night conditions.NTSB GAA17CA337Accident · No injuriesData collectionFinal reportCessna 172 · Ravenna, OHThe flight instructor's failure to perform a go-around during final approach, which resulted in an aerodynamic stall and a hard landing. Contributing to the accident was the flight instructor's failure to brief the student pilot on the positive transfer of…NTSB GAA17CA334Accident · Minor injuriesData collectionFinal reportPiper PA28R · Geneva, OHThe pilot’s failure to maintain a proper landing flare in variable wind conditions, which resulted in the airplane landing on the left edge of the runway and impacting trees.NTSB CEN17LA210Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 · Kenosha, WIThe pilot's loss of helicopter control during landing to a dolly.NTSB ERA17FA195Accident · 1 fatalField investigationFinal reportPiper PA23 · San Juan, PRThe pilot's failure to maintain adequate airspeed, properly correct for left yaw, and his exceedance of the airplane's critical angle of attack during initial climb, which resulted in an aerodynamic stall and subsequent uncontrolled descent into water.NTSB CEN17FA209Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Dimmitt, TXThe pilot's incapacitation due to scarring from previous heart attacks and severe hypertrophy of the left ventricular wall which resulted in arrhythmia and a loss of control while maneuvering at low altitude.NTSB WPR17FA118Accident · 1 fatalField investigationFinal reportCessna 150M · Banning, CAThe flight instructor's decision to continue the takeoff in gusting tailwind and high density altitude conditions, which significantly reduced airplane performance, and his subsequent exceedance of the airplane's critical angle of attack during the initial…NTSB GAA17CA319Accident · Minor injuriesData collectionFinal reportMagnaghi Aeronautica SKY Arrow LSA · Chapman, KSThe pilot's failure to maintain lateral/bank control during the takeoff climb in gusting crosswind conditions.NTSB CEN17WA211Accident · 2 fatalForeign investigationLake LA-4-200 · Muskoka, Ontario, CanadaOn June 2, 2017, at 2113 coordinated universal time, a Lake LA-4-200 Buccaneer, C-GZSW, was destroyed on impact with terrain after takeoff from Muskoka Airport (CYQA), Muskoka, Ontario, Canada. After takeoff, the pilot attempted to return to the airport, and…NTSB WPR17LA112Accident · Minor injuriesLimited investigationFinal reportCessna 175 · El Monte, CAThe flight instructor's delayed remedial action, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall and loss of control. Contributing to the accident was the student pilot's failure to maintain runway alignment…NTSB WPR17FA108Accident · 2 fatalField investigationFinal reportPiper PA 30 · Haines, AKThe pilot's decision to turn toward the inoperative engine after conducting a low-level pass, which resulted in an aerodynamic stall at too low an altitude to recover. Contributing to the accident was the pilot's decision to perform the flight and the engine…NTSB GAA17CA322Accident · No injuriesData collectionFinal reportPiper PA28 · Gilbert, SCThe pilot's improper glidepath in variable wind conditions, which resulted in the airplane impacting terrain short of the runway threshold.NTSB ANC17FA026Accident · 2 fatalField investigationFinal reportArctic S 1B2 · Salcha, AKThe pilot's failure to maintain adequate airspeed while maneuvering in high winds, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's improper decision to load the…