NTSB investigations
8,203 cases where the first occurrence 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250) 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" = 250) 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 SEA07LA250Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Morgan, UTThe pilot's failure to maintain control of the glider while maneuvering on final approach to landing, which resulted in an collision with a tree. A factor was the wind gust.NTSB LAX07FA258Accident · 2 fatalField investigationFinal reportRaytheon A36 · Cameron Park, CAThe airplane's sudden encounter with a wind shift during the initial takeoff climb that resulted in degraded climb performance and a stall mush condition. Contributing to the accident was the airplane's over gross weight condition, high density altitude, the…NTSB SEA07LA242Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Blythe, CAThe pilot's failure to maintain adequate airspeed which resulted in a stall. A contributing factor was the high density altitude.NTSB MIA07LA136Accident · 2 fatalLimited investigationFinal reportApollo North America Tundra · Zephyrhills, FLImproper in-flight maneuvering that resulted in the weight-shift-aircraft's design limits being exceeded, wing failure, and a loss of control.NTSB CHI07CA281Accident · No injuriesData collectionFinal reportRobinson R-22 Beta · St. Clair Rgnl., MOThe pilot overcorrected following a loss of control while practicing a hovering turn.NTSB DEN07LA145Accident · 1 fatalLimited investigationFinal reportAdams Airborne Australia O · Taos, NMThe pilot's intentional low altitude flight in a confined area and an inadvertent stall/spin. Contributing factors in this accident were the blind/box canyon and the aircraft's low airspeed.NTSB LAX07LA257Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Standard Cirrus · Heber, UTThe pilot's failure to maintain sufficient airspeed during landing, resulting in an inadvertent stall/spin, undershoot and collision with the ground.NTSB ATL07CA107Accident · Serious injuriesData collectionFinal reportMcNicholas S-12 · Cambridge, MDThe non certificated pilot's failure to remove the control lock prior to taxi and takeoff.NTSB ANC07CA084Accident · No injuriesData collectionFinal reportCessna 180 · Skwentna, AKThe pilot's inadequate compensation for wind conditions during takeoff initial climb, which resulted in the airplane descending uncontrolled into high vegetation. Factors contributing to the accident were wind gusts and a crosswind.NTSB SEA07IA237Incident · No injuriesIncident investigationFinal reportRaytheon Cobra · Whetstone, AZThe student pilot's failure to follow proper procedures, specifically not verifying that the mode switch was in the automatic position before changing the pilot address, which resulted in a loss of aircraft control. Contributing to the accident was the flight…NTSB NYC07LA201Accident · Serious injuriesLimited investigationFinal reportSukhoi SU-31 · Markham, VAThe pilot's failure to maintain aircraft control. Contributing to the accident were a fuel leak as reported by the pilot, the pilot's diverted attention, a low cloud ceiling, and fog.NTSB DEN07LA142Accident · Serious injuriesLimited investigationFinal reportBell 206-L4 · Mullinville, KSThe pilot's failure to maintain main rotor rpm resulting in an uncontrolled descent, collision with transmission wires, and a hard landing. A contributing factor was the tranmission wires.NTSB CHI07CA275Accident · Minor injuriesData collectionFinal reportWeaver, David A Pulsar 912XP · Plato Center, ILthe pilot's failure to maintain airspeed. Factors were the pilot's lack of familiarity with the aircraft and pilot's failure to maintain altitude.NTSB NYC07FA196Accident · Serious injuriesField investigationFinal reportLiberty Aerospace XL2 · Ormond Beach, FLThe student pilot's failure to maintain aircraft control during an attempted go-around.NTSB MIA07LA133Accident · Serious injuriesLimited investigationFinal reportBeech B36TC · Clearwater, FLThe pilot's improper rotation and climb during the takeoff which resulted in a stall/mush, a descent, and an impact with the ground.NTSB CHI07LA272Accident · 1 fatalLimited investigationFinal reportClifford Titan Tornado II · Henning, MNThe inadvertent stall and low airspeed while maneuvering. A contributing factor was the low altitude of the maneuver.NTSB ANC07MA083Accident · 5 fatalMajor investigationFinal reportde Havilland DHC-2 · Ketchikan, AKAn inadvertent aerodynamic stall resulting from the pilot's poor decision-making and inadequate planning and execution when he took off toward nearby rising terrain, in strong winds, under circumstances where his options for maneuvering were severely limited…NTSB NYC07FA193Accident · 2 fatalField investigationFinal reportCessna 172N · Rochester, NYThe pilot's failuire to maitain adequate airspeed during a turning maneuver which resulted in an inadvertent stall.NTSB LAX07CA256Accident · No injuriesData collectionFinal reportCessna 150L · Keystone Height, FLthe student pilot's excessive retraction of flaps and failure to attain an adequate airspeed during a go-around that led to a stall/mush.NTSB DFW07LA183Accident · 1 fatalLimited investigationFinal reportHuggles Sonex · Bonham, TXThe pilot's failure to maintain control of the airplane on take off, which resulted in an inadvertent stall and subsequent collision with terrain.NTSB DEN07FA136Accident · 2 fatalField investigationFinal reportZlin Aviation s.r.o. Savage · Mosquero, NMThe pilot's failure to maintain airspeed while maneuvering, resulting in an aerodynamic stall. Contributing to the accident was the conflicting airspeed information provided by the manufacturer, the incorrect airspeed indicator markings, and the high density…NTSB DEN07LA137Accident · No injuriesLimited investigationFinal reportMooney M20R · Wichita, KSthe pilot's improper flare and recovery from a bounced landing. Contributing factors are the lack of experience of the pilot and the delayed remedial action of the airline transport pilot rated passenger.NTSB ANC07FA082Accident · 2 fatalField investigationFinal reportMaule M-5-180C · Arctic Village, AKThe pilot's failure to maintain sufficient airspeed to avoid a stall/spin while maneuvering.NTSB SEA07CA229Accident · Serious injuriesData collectionFinal reportQuicksilver Manufacturing GT-500 · Newberg, ORThe pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall and uncontrolled descent to terrain impact. A contributing factor was the pilot's lack of certification.NTSB SEA07CA227Accident · Minor injuriesData collectionFinal reportMapes Kitfox V · Silverdale, WAThe pilot's failure to maintain adequate airspeed during takeoff initial climb, which resulted in an inadvertent stall and uncontrolled descent to terrain impact.NTSB ANC07LA079Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Big Lake, AKThe student pilot's failure to maintain adequate airspeed to avoid an inadvertent stall while maneuvering.NTSB SEA07FA231Accident · 1 fatalField investigationFinal reportSchempp-Hirth Ventus-CM · Benton, CAThe pilot's failure to maintain aircraft control while maneuvering and the inadvertent entry into a stall/spin. Contributing to the accident were the mountainous terrain conditions, unfavorable wind conditions, and the terrain-induced turbulent wind…NTSB LAX07CA259Accident · Serious injuriesData collectionFinal reportSix Chutter SR7 · Toledo, WAA hard landing following the pilot's in-flight loss of control.NTSB CHI07CA258Accident · No injuriesData collectionFinal reportAeronca 7AC · Westerly, RIThe pilot's failure to maintain control of the airplane during landing which resulted in the overload failure of the right main landing gear. The overload failure of the right main landing gear was a factor.NTSB LAX07LA240Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Polson, MTa flight control jam for undetermined reasons.NTSB SEA07FA223Accident · 4 fatalField investigationFinal reportRobinson R44 II · Easton, WAThe pilot's improper planning/decision in attempting a downwind takeoff under high density altitude conditions that resulted in a loss of control and impact with terrain. Contributing to the accident were the helicopter's gross weight in excess of the maximum…NTSB DEN07CA131Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Erie, COThe student pilot's failure to maintain rotor rpm resulting in a loss of aircraft control during a simulated 180 degree auto-rotation. Contributing to the accident was the inadequate flight status supervision by the flight instructor and the student pilot's…NTSB SEA07FA218Accident · 2 fatalField investigationFinal reportMooney M20E · Tonasket, WAThe pilot's failure to maintain an adequate airspeed during initial climb following an aborted landing that resulted in a stall/spin. The pilot's misjudged speed and distance that resulted in a failure to attain a proper touchdown point was a factor.NTSB MIA07CA128Accident · Minor injuriesData collectionFinal reportEngineering & Research Ercoupe 415-C · Valkaria, FLThe pilot's failure to maintain airspeed which resulted in an inadvertent stall and subsequent collision with the runway.NTSB LAX07CA237Accident · Minor injuriesData collectionFinal reportBeech C35 · Redlands, CAthe pilot's failure to maintain an adequate airspeed, which resulted in a stall.NTSB DFW07LA171Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Marks, MSThe loss of control and hard landing as result of the loss of tail rotor effectiveness. A contributing factor was the prevailing dark night conditions.NTSB CHI07CA239Accident · No injuriesData collectionFinal reportCessna 150H · Cook, MNThe pilot not maintaining airspeed leading to the stall/mush encountered during takeoff and the unsuitable terrain the pilot selected during the forced landing. Factors were the vehicle encountered during the forced landing and the ditch the pilot steered the…NTSB SEA07TA214Accident · Serious injuriesFinal reportBell 214ST · McCall, IDThe pilot's inadequate planned approach that led to settling with power. Contributing to the accident was the external load becoming snagged in the water, and the high density altitude.NTSB NYC07FA176Accident · 2 fatalField investigationFinal reportCessna 150B · Campbellton, FLThe pilot's failure to maintain airspeed during the initial climb after takeoff, which resulted in an inadvertent stall.NTSB DEN07CA128Accident · No injuriesData collectionFinal reportCessna 182T · Grand Junction, COThe pilot's failure to maintain aircraft control during the landing.NTSB CHI07CA232Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-33A · Warrensburg, MOThe flight instructor's failure to maintain adequate airspeed and aircraft control, which resulted in a stall while on final approach. A factor in the accident were the two fences.NTSB ATL07CA108Accident · No injuriesData collectionFinal reportEvektor Aerotechnic Sportstar · Shirley, NYThe student pilot's failure to maintain adequate airspeed resulting in a stall. Contributing to the accident was the student pilots failure to relinquish the flight controls when instructed to do so.NTSB NYC07LA175Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Collegeville, PAThe pilot's inadequate recovery from a bounced landing.NTSB NYC07LA174Accident · 1 fatalLimited investigationFinal reportWolfe Titan · Surry, VAThe pilot's failure to maintain aircraft control for undetermined reasons. Contributing to the accident was the pilot's lack of recent experience.NTSB NYC07FA173Accident · 1 fatalField investigationFinal reportCessna 150L · Hammondsport, NYThe pilot's inadequate in flight decision and failure to maintain aircraft control during cruise flight. Contributing to the accident were inadequate preflight planning, dark night and poor weather conditions.NTSB DEN07CA123Accident · No injuriesData collectionFinal reportHorton Aviat ChristEagle II · Salida, COThe pilot's failure to maintain aircraft control during the landing, causing the airplane to depart the runway and impact the VASIs.NTSB CHI07CA228Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Oshkosh, WIThe pilot's failure to maintain adequate airspeed during landing which resulted in an inadvertent stall and subsequent impact with the ground.NTSB DFW07LA169Accident · No injuriesLimited investigationFinal reportBell 206L-3 · High Island 138The loss of control as result of the pilot's failure to maintain rotor RPM during takeoff.NTSB CHI07CA223Accident · Minor injuriesData collectionFinal reportBush Caddy USA LSA · Chadron, NEThe pilot's failure to maintain control of the aircraft during landing. A contributing factor was the gusty, crosswind condition.NTSB CHI07CA222Accident · No injuriesData collectionFinal reportCessna 150J · Waldron, MOThe student pilot's failure to maintain directional control during the go-around. The cornfield was a factor.