NTSB investigations
5,010 cases where the sequence of events included 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' 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" = '240' 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 WPR15FA200Accident · 1 fatalField investigationFinal reportManiscalco Great Lakes · Corona, CAThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack while maneuvering, which resulted in a stall/spin at too low an altitude to allow recovery. Contributing to the accident was the pilot's improper…NTSB GAA15CA148Accident · No injuriesData collectionFinal reportMooney M20R · West Mifflin, PAThe pilot's failure to maintain pitch control during landing, which resulted in a bounce and loss of control during landing, followed by a runway excursion, and collision with terrain during an attempt to abort the landing.NTSB ERA15WA255Accident · 3 fatalForeign investigationRobinson R44 - II · Makarakskiy, RussiaOn June 27, 2015, at 0820 coordinated universal time, a Robinson Helicopter R44 II, Russian registration RA-05765, was damaged while attempting to depart from Makarakskiy, Russia. The pilot and two passengers were fatally injured. The flight was destined for…NTSB CEN15FA282Accident · 1 fatalField investigationFinal reportChristen Industries Pitts S-2B · Cameron, MOThe pilot’s failure to maintain airplane control during a low-level aerobatic flight maneuver.NTSB CEN15FA281Accident · 1 fatalField investigationFinal reportStuhlmiller Robert Europa · Beloit, OHThe pilot’s incapacitation in flight due to a cardiovascular event.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 GAA15CA138Accident · Serious injuriesData collectionFinal reportQuicksilver MXL II Sport · Ute, IAThe pilot's failure to maintain sufficient airspeed to prevent an inadvertent aerodynamic stall, and impact with terrain.NTSB ERA15LA251Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · East Moriches, NYThe pilot's failure to maintain directional control while taking off in a crosswind, which resulted in a collision with a tree.NTSB GAA15CA133Accident · No injuriesData collectionFinal reportSchempp-Hirth Ventus 2C · Hobbs, NMThe pilot's improper compensation for gusty wind conditions which resulted in impact with terrain short of the runway.NTSB ERA15FA245Accident · 1 fatalField investigationFinal reportCzech Sport Piper Sport · Holly Ridge, NCThe pilot’s failure to maintain airplane control after the cockpit canopy opened during initial climb. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.NTSB WPR15LA193Accident · 1 fatalLimited investigationFinal reportBell 47G 5 · Salinas, CAThe non-instrument-rated pilot's visual flight rules flight into instrument meteorological conditions, which resulted in his spatial disorientation and loss of helicopter control. Contributing to the accident was the pilot's impairment by high-dose opioid use.NTSB CEN15FA278Accident · 1 fatalField investigationFinal reportCessna 172 · Shreveport, LAThe pilot's loss of airplane control during initial climb after takeoff for reasons that could not be determined because an examination of the airframe and engine did not reveal any preimpact anomalies.NTSB CEN15FA277Accident · 1 fatalField investigationFinal reportNorthwing Design Apache Sport · Taos, NMThe powered-lift aircraft's departure from controlled flight for reasons that could not be determined from the available information.NTSB GAA15CA122Accident · No injuriesData collectionFinal reportContinental Copters Tomcat MK5A · Elk Mound, WIThe pilot's failure to maintain a positive rate of climb after taking off from the service truck, which resulted in the helicopter impacting terrain.NTSB CEN15FA269Accident · 1 fatalField investigationFinal reportGrumman American Avn. AA-5 · Fredericksburg, TXThe pilot's failure to maintain adequate airspeed following a partial loss of engine power during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Also causal was the mechanic's…NTSB ANC15CA040Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Soldotna, AKThe pilot's loss of directional control during takeoff in gusty crosswind conditions.NTSB CEN15LA280Accident · No injuriesLimited investigationFinal reportBeech G58 · Taylorville, ILThe flight instructor’s failure to verify that the left engine was operational, which resulted in insufficient engine power being available during an attempted go-around and his subsequent loss of airplane control. Contributing to the accident was the…NTSB CEN15FA267Accident · 4 fatalField investigationFinal reportBeech A36 · Huggins, MOThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack, which resulted in an aerodynamic stall and loss of control.NTSB CEN15FA264Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Kadoka, SDThe pilot's failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in the airplane’s wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall.NTSB GAA15CA109Accident · Minor injuriesData collectionFinal reportKretsinger Bensen B8M · Maple Plain, MNThe pilot's failure to maintain airspeed, resulting in a loss of control, and a collision with terrain.NTSB ERA15WA236Accident · 3 fatalForeign investigationBeech C90 - GTI · Belo Horizonte City, BrazilOn June 7, 2015, about 1823 UTC, a Textron Aviation C90GTi, Brazil registration PR-AVG, experienced a loss of control shortly after takeoff and crashed into a house near Belo Horizonte-Pampulha Airport (SBBH), Belo Horizonte City, Minas Gerais, Brazil. The…NTSB CEN15WA260Accident · 2 fatalForeign investigationVans RV-7A · Zagreb, CroatiaOn June 7, 2015, at 1430 coordinated universal time, a Van's Aircraft RV-7A, Croatian registered 9A-DVM, owned and piloted by the accident pilot, was destroyed when it impacted terrain near Zagreb, Croatia. Visual meteorological conditions prevailed at the…NTSB GAA15CA136Accident · No injuriesData collectionFinal reportCessna 172H · Cottonwood Falls, KSThe pilot's failure to attain adequate airspeed to climb the airplane out of ground effect, which resulted in an aerodynamic stall and a collision with terrain.NTSB GAA15CA111Accident · No injuriesData collectionFinal reportCessna 177 · Clewiston, FLThe pilot's improper level off and flare in crosswind conditions, which resulted in a loss of control and hard landing.NTSB CEN15FA257Accident · 1 fatalField investigationFinal reportMorse Frank L Rebel · Eagle, CO, COThe pilot’s failure to maintain control of the airplane while landing in gusty, crosswind conditions that likely exceeded the recommended limitation of the airplane.NTSB CEN15FA255Accident · 2 fatalField investigationFinal reportCub Crafters CC18-180 · Raton, NMThe pilot's failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB CEN15LA276Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Branch, LAAn exceedance of the airplane's takeoff/climb capability, which resulted in a stall during initial climb at an altitude that was too low for recovery.NTSB GAA15CA105Accident · No injuriesData collectionFinal reportRans S 12XL · Sharpsville, INThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with a building.NTSB CEN15LA295Accident · Serious injuriesLimited investigationFinal reportWaco UPF 7 · Montrose, COThe pilot's failure to attain suitable altitude while flying over high mountainous terrain in downdraft conditions.NTSB CEN15LA253Accident · 1 fatalLimited investigationFinal reportSchleicher ASW27 - 18E · Lamy, NMA loss of glider control for reasons that could not be determined based on the available evidence and the glider’s severe fragmentation.NTSB WPR15LA176Accident · 1 fatalLimited investigationFinal reportAyres S2R T34 · Blythe, CAThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB WPR15FA174Accident · 1 fatalField investigationFinal reportPiper PA 22-135 · Livermore, CAA loss of control for reasons that could not be determined, because examination of the airframe and engine revealed no anomalies that would have precluded normal operation.NTSB ERA15LA231Accident · 1 fatalLimited investigationFinal reportBeech A36 · Siler City, NCThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall.NTSB ERA15LA230Accident · Serious injuriesLimited investigationFinal reportSea & Sky Inc DBA Krucker Acft Cygnet · Panama City Beach, FLThe pilot's loss of aircraft control, which resulted in an aerodynamic stall.NTSB CEN15FA249Accident · 2 fatalField investigationFinal reportMonnett John T JR Sonex SA · Oshkosh, WIThe pilot's failure to maintain sufficient airspeed following a loss of engine power during initial takeoff climb, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. The reason for the loss of…NTSB CEN15FA245Accident · 3 fatalField investigationFinal reportBeech A36 · Plainview, TXThe pilot’s decision to take off ahead of an approaching severe thunderstorm, which resulted in an encounter with hazardous weather conditions that led to a loss of airplane control.NTSB ERA15LA228Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Churchville, MDThe pilot's improper reduction of the fuel mixture while the airplane was descending on the final leg of the traffic pattern, which resulted in a total loss of engine power and subsequent aerodynamic stall.NTSB WPR15WA172Accident · 1 fatalForeign investigationRobinson R22 - Beta · Mitchell, AustraliaOn May 28, 2015 about 1620 local time, a Robinson R-22 helicopter, Australian registration VH-HRW, collided with terrain near Mitchell, Queensland, Australia. The helicopter sustained substantial damage, and the pilot was fatally injured. The investigation is…NTSB GAA15CA094Accident · No injuriesData collectionFinal reportCessna 182E · Galion, OHThe pilot's failure to maintain adequate airspeed on final approach, which resulted in an in-flight loss of control and hard landing.NTSB CEN15FA240Accident · 1 fatalField investigationFinal reportYakovlev YAK 52 · Syracuse, KSThe pilot’s failure to maintain airplane control while maneuvering at low altitude, which resulted in the airplane’s wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall .NTSB GAA15LA085Accident · Serious injuriesLimited investigationFinal reportDestiny 2000 · Eltopia, WAThe flight instructor’s failure to tell the student pilot to abort the takeoff after the powered parachute experienced wing oscillations, which resulted in the student pilot’s loss of aircraft control during initial climb and subsequent impact with terrain.…NTSB GAA15CA088Accident · Minor injuriesData collectionFinal reportCessna 172M · Sussex, NJThe pilot's failure to remove the gust lock during the preflight inspection, resulting in a loss of control and collision with trees during takeoff.NTSB ERA15CA229Accident · Minor injuriesData collectionFinal reportWilson Michael A Challenger II · Lebanon, TNThe non-certificated pilot's failure to maintain airspeed during takeoff, which resulted in an aerodynamic stall, uncontrolled descent, and collision with terrain. Contributing to the accident was the pilot's lack of training and flight experience in the…NTSB CEN15WA390Accident · 2 fatalForeign investigationAvions Robin DR400 · Arras, FranceOn May 21, 2015 about 1245 UTC, a Robin DR400-140B airplane, French registration F-GBUP, impacted into a cultivated field near the Arras-Roclincourt Airport (LFQD), Arras, France. One pilot and a passenger were killed. Another pilot was seriously injured. The…NTSB ERA15LA218Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Kearny, NJThe deliberate concealment and reuse of an unairworthy tail rotor driveshaft by unknown personnel, which resulted in an overstress separation at a bonded flange adapter as a result of driveshaft imbalance.NTSB ERA15FA215Accident · 2 fatalField investigationFinal reportBeech 95 B55 (T42A) · Saltville, VAThe pilot’s flight into developing rain showers and updrafts, which resulted in a loss of airplane control and collision with terrain. Contributing to the accident were the pilot’s continued flight into forecast adverse weather conditions, and his reliance on…NTSB GAA15CA077Accident · No injuriesData collectionFinal reportCessna 150M · Wellington, KSThe student pilot's improper flare and loss of control which resulted in a hard landing.NTSB CEN15FA232Accident · 4 fatalField investigationFinal reportPiper PA 24-260 · Spring Branch, TXThe pilot's failure to maintain control during takeoff due to his impairment from marijuana. Contributing to the accident was the pilot’s impaired decision to fly after using a disqualifying drug.NTSB ANC15WA067Accident · 1 fatalForeign investigationKevin D. Yarnevich Kitfox · Surrey, CanadaNTSB WPR15FA158Accident · 2 fatalField investigationFinal reportPiper PA 46 350P · Spokane, WAThe mechanic's incorrect installation of two aileron cables and the subsequent inadequate functional checks of the aileron system before flight by both the mechanic and the pilot, which prevented proper roll control from the cockpit, resulting in the pilot's…