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 ERA17LA031Accident · Minor injuriesLimited investigationFinal reportHaddow William H Pitts Special S 1 · New Bern, NCA loss of biplane control during aerobatic maneuvers for reasons that could not be determined because a portion of the biplane's flight control system was not recovered and could not be tested.NTSB ANC17FA003Accident · 1 fatalField investigationFinal reportCessna 172 · Palmer, AKThe student pilot's exceedance of the airplane's critical angle of attack during a steep climbing turn following a touch-and-go landing, which resulted in an aerodynamic stall at too low of an altitude to recover.NTSB ERA17CA030Accident · Minor injuriesData collectionFinal reportKolb Fire FLY · West Middlesex, PAThe noncertificated pilot’s loss of airplane control while maneuvering at a low altitude.NTSB CEN17FA028Accident · 1 fatalField investigationFinal reportAviat A-1C-180 · Clarksville, TXThe pilot's failure to maintain sufficient airspeed during the landing approach, which resulted in exceedance of the airplane's critical angle of attack and an aerodynamic stall.NTSB CEN17WA086Accident · 1 fatalForeign investigationMooney M20K · Saarbrucken, GermanyOn October 27, 2016, about 0946 UTC, a Mooney M20T, N400MW, owned and operated by a private individual, impacted on the runway at the Saarbrucken-Ensheim Airport (EDDR), Saarbrucken, Germany. The pilot on board was fatally injured and the airplane was…NTSB CEN17FA026Accident · 1 fatalField investigationFinal reportRoe Cleo Wittman Tailwind W10 · Pearland, TXThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during a climbing turn after takeoff, which resulted in an aerodynamic stall/spin. Contributing to the accident was the pilot's inadequate training…NTSB CEN17LA032Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Ingleside, TXThe pilot's failure to maintain proper yaw and roll control during takeoff, which resulted in excessive adverse yaw upon liftoff.NTSB GAA17CA040Accident · No injuriesData collectionFinal reportPiper PA 20S · Arcadia, FLThe pilot's improper pitch and power control during landing in a straight float-equipped airplane on grass in crosswind conditions, which resulted in a loss of directional control.NTSB GAA17CA034Accident · No injuriesData collectionFinal reportYakovlev YAK · Tracy, CAThe pilot’s unstabilized approach and delayed application of full throttle for a go-around, which resulted in an uncontrolled descent.NTSB WPR17LA015Accident · No injuriesLimited investigationFinal reportRyan W Gross Arion Lighting · Mesa, AZThe pilot's failure to maintain airplane control during takeoff/initial climb due to his inexperience in the airplane make and model and his refusal to obtain training in the airplane.NTSB CEN17FA024Accident · 2 fatalField investigationFinal reportBeech C23 · Osage Beach, MOThe pilot's loss of control while maneuvering shortly after takeoff. Contributing to the loss of control was the pilot's attempt to climb with the flaps fully extended.NTSB GAA17CA035Accident · Minor injuriesData collectionFinal reportPiper PA 28 · Fresno, CAThe pilot’s exceedance of the airplane’s critical angle of attack during departure due to being distracted by looking for his phone.NTSB ERA17LA024Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cedar Key, FLA partial loss of engine power due to a stuck exhaust valve and the noncertificated pilot's inadequate preflight planning, which resulted in the airplane being overloaded, both of which led to the airplane's inability to attain a positive climb rate.…NTSB GAA17CA030Accident · Minor injuriesData collectionFinal reportAir Tractor AT 502 · Paragould, ARThe pilot's failure to avoid electrical wires during low-altitude maneuvering, which resulted in a wire strike.NTSB WPR17FA008Accident · 1 fatalField investigationFinal reportCessna 182D · South Lake Tahoe, CAThe noninstrument-rated pilot's decision to depart on and continue a flight over mountainous terrain into forecast instrument metrological conditions, icing, and hazardous wind conditions that exceeded the airplanes performance capabilities and resulted in an…NTSB GAA17CA026Accident · Serious injuriesData collectionFinal reportPiper PA 28 · Latrobe, PAThe pilot’s unstabilized approach, which resulted in the airplane’s wing striking the ground while the pilot was maneuvering to realign with the runway.NTSB ANC17WA030Accident · 4 fatalForeign investigationCessna 500 · Kelowna, CanadaOn October 14, 2016, a Cessna C500 (Citation) departed Kelowna Airport (CYLW) at 0510 Universal Coordinated Time (UTC) for a flight to Calgary/Springbank Airport (CYBW), with a pilot and three passengers aboard. Shortly after departure, the aircraft…NTSB DCA17WA010Accident · No injuriesForeign investigationPiper PA28 · Jozini, South AfricaThe government of South Africa has notified the NTSB of an accident involving a PIPER PA28 airplane that occurred on October 13, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…NTSB GAA17CA020Accident · No injuriesData collectionFinal reportRemos Remos GX · Lowell, ARThe pilot’s decision to take off with a prevailing tailwind and insufficient distance to ensure obstacle clearance, which resulted in a collision with a tree.NTSB GAA17CA012Accident · No injuriesData collectionFinal reportCessna 172 · Ocean Springs, MSThe pilot's failure to maintain airplane control while landing in windy conditions.NTSB CEN17FA005Accident · 1 fatalField investigationFinal reportBeech D95A · Hitchcock, TXThe flight instructor's loss of control during an aerodynamic stall demonstration, which resulted in an inadvertent spin from which he was unable to recover. Contributing to the accident was the flight instructor's lack of familiarity with the airplane's…NTSB CEN17WA008Accident · 1 fatalForeign investigationNorth American P-51D · East Anglia, United KingdomThis is preliminary information, subject to change, and may contain errors. The foreign authority was the source of this information. On October 2, 2016, at 1438 Coordinated Universal Time (UTC), a North American P-51D, British registration G-MSTG, impacted…NTSB CEN17LA004Accident · No injuriesLimited investigationFinal reportVolaircraft 10A · Mandan, NDThe student pilot’s failure to maintain the proper approach path on landing, which resulted in impact with terrain short of the runway.NTSB CEN17LA001Accident · Serious injuriesLimited investigationFinal reportDrake Kitfox Speedster · Jennings, LAThe pilot’s failure to maintain adequate airspeed during takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and subsequent aerodynamic stall.NTSB CEN16LA386Accident · Serious injuriesLimited investigationFinal reportBell 407 · Lawton, OKThe pilot's loss of helicopter control during landing, which resulted in a hard landing and collision with a wall.NTSB GAA16CA514Accident · No injuriesData collectionFinal reportCessna 205 · Ellington, CTThe pilot's exceedance of the airplane's critical angle-of-attack during the initial climb after an attempted go-around, which resulted in an aerodynamic stall.NTSB GAA16CA515Accident · Serious injuriesData collectionFinal reportCessna 172 · Pittsfield, MAThe student pilot’s failure to maintain an appropriate descent rate and runway alignment during the landing flare, which resulted in the airplane touching down left of the runway and impacting a ditch.NTSB CEN16WA384Accident · 2 fatalForeign investigationCessna 206 · Lake Kuashkuapishiu, CanadaOn September 25, 2016, a Cessna U206F airplane, C-FWBQ, collided with terrain after departing from Lake Kuashkuapishiu, Quebec. The pilot was seriously injured and two passengers were fatally injured. This investigation is under the jurisdiction and control…NTSB ERA16WA334Accident · 4 fatalForeign investigationBeech E55 · Campinapolis, BrazilOn September 22, 2016, about 2210 universal time coordinated, a Beech E55, Brazilian registration PR-DTA, was destroyed when it impacted terrain near Campinapolis, Brazil. The airplane departed the Santa Genoveva Airport (SBGO), Goiana, Brazil, and was…NTSB GAA16CA501Accident · No injuriesData collectionFinal reportPiper PA28R · Ottumwa, IAThe pilot receiving instruction's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack during a simulated engine failure and landing, which resulted in an aerodynamic stall. Contributing to the accident was the…NTSB GAA16CA495Accident · No injuriesData collectionFinal reportPiper PA 11 · Grand Isle, VTThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during a simulated engine failure and forced landing with a tailwind, which resulted in an aerodynamic stall.NTSB CEN16LA379Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Chesterfield, MOThe pilot's unstable approach and subsequent loss of airplane control during an attempted go-around.NTSB CEN16FA372Accident · Serious injuriesField investigationFinal reportAgusta A109 · Alexandria, MNThe pilot's excessive cyclic input during a missed approach maneuver in night instrument meteorological conditions, which resulted in a loss of control and spiraling descent into terrain.NTSB ERA16FA316Accident · 1 fatalField investigationFinal reportCessna A188 · Alapaha, GAThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude during aerial application operations, which resulted in the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall and spin.NTSB GAA16CA490Accident · No injuriesData collectionFinal reportPiper PA 28 · Parkersburg, WVThe flight instructor’s delayed remedial action during the approach for landing, which resulted in impact with terrain short of the runway threshold. Contributing to the accident was the student pilot’s failure to maintain an appropriate descent rate during…NTSB GAA16CA488Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Cedar City, UTThe flight instructor’s delayed remedial action while providing hover instruction in gusting wind conditions, which resulted in dynamic roll-over.NTSB WPR16FA178Accident · 3 fatalField investigationFinal reportPiper PA 28R-201T · Reno, NVThe pilot's decision to depart with the airplane loaded above its maximum gross weight and at or just beyond its aft center of gravity limitations, which resulted in a loss of control during the initial climb. Contributing to the accident was the pressure to…NTSB CEN16CA383Accident · Minor injuriesData collectionFinal reportMooney M20D · Brodhead, WIThe pilot's loss of airplane control during initial climb due to an excessively nose-high attitude. Contributing to the accident was the pilot's failure to properly set the elevator trim before takeoff in accordance with the Before Takeoff checklist.NTSB ANC16FA065Accident · 1 fatalField investigationFinal reportHefty Polar Cub · Anchorage, AKThe pilot's severe impairment from carbon monoxide poisoning in flight, which resulted in a loss of control and a subsequent collision with trees and terrain.NTSB GAA16CA482Accident · No injuriesData collectionFinal reportPiper PA18 · Gulkana, AKThe pilot’s failure to maintain clearance from a tree while maneuvering at low altitude.NTSB ERA16CA314Accident · Minor injuriesData collectionFinal reportQuicksilver Manufacturing Sport 2S · Cleveland, GAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB ANC16LA062Accident · Serious injuriesClass 3 · LimitedFinal reportDehavilland DHC-2 · Kodiak, AKThe pilot's failure to maintain adequate airspeed during the initial climb and turn after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.NTSB DCA16WA237Accident · No injuriesForeign investigationCessna 210 · Naivasha, Nakuru County, KenyaThe Kenya Air Accident Investigation Department (AAID) has notified the NTSB of an accident involving a Cessna 210 airplane that occurred on September 08, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAID's investigation under…NTSB CEN16FA361Accident · 1 fatalField investigationFinal reportPiper PA 46-310P · Chariton, IAThe non-instrument-rated pilot's loss of control due to spatial disorientation in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations and a subsequent in-flight breakup. Contributing to the…NTSB GAA16CA469Accident · Minor injuriesData collectionFinal reportRainbow Sky Reach Bushcat · Frankfort, KYThe pilot's exceedance of the airplane's critical angle-of-attack while maneuvering at low altitude, which resulted in an aerodynamic stall.NTSB GAA16CA462Accident · No injuriesData collectionFinal reportAir Tractor AT · Hondo, TXThe pilot’s failure to maintain clearance from an antenna atop a tower while maneuvering at a low altitude and the airplane’s subsequent impact with terrain during an attempted off-airport landing.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 CEN16LA363Accident · Serious injuriesLimited investigationFinal reportCGS Hawk Aero II · Holland, MIThe improper installation of quick release connectors in the fuel lines, which was not in accordance with the engine manufacturer's maintenance instructions and allowed air to be introduced into the fuel system and resulted in a partial loss of engine power.…NTSB CEN16LA347Accident · 1 fatalLimited investigationFinal reportHaggenmacher Bensen · Bryant, ARThe pilot’s loss of gyroplane control during an intentional high-speed pass, which resulted in the gyroplane porpoising and impacting terrain. Contributing to the accident was the pilot’s decision to conduct the flight in an aircraft in which he had little…NTSB CEN16FA344Accident · 2 fatalField investigationFinal reportAves Douglas James RV 6 · Viborg, SDThe pilot's failure to maintain airplane control, which resulted in the airplane exceeding its critical angle of attack, an aerodynamic stall, and subsequent flat spin into terrain.