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 CEN21LA291Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Loveland, COThe flight instructor’s failure to maintain aircraft control during the landing flare and subsequent attempted go-around with a strong quartering crosswind.NTSB CEN21FA290Accident · 2 fatalClass 3 · FieldFinal reportAmerican AA-1A · Cleburne, TXThe canopy moving fully open during flight, which resulted in the pilot’s distraction and a subsequent aerodynamic stall/spin and loss of control.NTSB CEN21LA288Accident · No injuriesClass 3 · LimitedFinal reportVining SD1 Minisport · Butler, OHThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power, which resulted in an aerodynamic stall and impact with terrain. The reason for the partial loss of engine power could not be determined based on available information.NTSB WPR21LA245Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Big Bear City, CAThe pilot’s inadequate flare and subsequent loss of airplane control during an aborted landing in gusting wind, which resulted in impact with trees.NTSB WPR21FA233Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-22-135 · White City, ORThe pilot’s failure to maintain control of the airplane during a go-around, which resulted in a collision with trees. Contributing to the accident was the pilot’s impairment due to his medical conditions and the effects of his medications.NTSB CEN21LA301Accident · No injuriesClass 4 · LimitedFinal reportChristen Industries A-1 · Wilmington, OHThe pilot’s failure to maintain directional control during takeoff with gusting winds, which resulted in an inflight collision with a fence.NTSB ERA21FA258Accident · 2 fatalClass 3 · FieldFinal reportCessna 150 · Yulee, FLThe flight instructor’s decision to conduct slow flight training at an altitude below the flight school’s minimum recovery altitude and his delayed remedial action when an aerodynamic stall occurred.NTSB CEN21FA277Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR20 · Conway, ARThe pilot’s failure to maintain adequate airspeed, which resulted in an aerodynamic stall and spin. Contributing to the accident was the failure of the pilot to perform an adequate preflight inspection, to include removal of the pitot tube cover.NTSB WPR21FA228Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR20 · Truckee, CAThe student pilot’s exceedance of the airplane’s critical angle of attack during a turn and the flight instructor’s delayed remedial action, resulting in an aerodynamic stall and a subsequent impact with terrain.NTSB WPR21FA227Accident · 1 fatalClass 3 · FieldFinal reportCovey Tri Quickie · Gila Bend, AZThe pilot’s exceedance of the airplane’s critical angle of attack during the takeoff initial climb, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the accident was the reduced airplane performance due to high density…NTSB ERA21FA253Accident · 1 fatalClass 3 · FieldFinal reportVans RV6 · Buckingham, PAAn exhaust system leak that resulted in failure of the oil quick drain, a loss of oil lubrication, an in-flight fire, and the pilot’s subsequent loss of airplane control.NTSB ERA21LA247Accident · Minor injuriesClass 3 · LimitedFinal reportGarrison Ronald L Zodiac 601 XL · Cumberland, MDAn inadvertent release of the canopy, which allowing the canopy to open during flight and led to an inflight loss of airplane control. Contributing to the accident was the lack of any safeguard to prevent the inadvertent opening of the canopy.NTSB ERA21FA239Accident · 1 fatalClass 3 · FieldFinal reportSchweizer SGS 1-35 · Wurtsboro, NYThe pilot’s low-altitude release from tow for reasons that could not be determined, and his subsequent exceedance of the glider’s critical angle of attack while returning to the runway, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA21LA244Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Sanford, METhe pilot’s failure to maintain directional control while landing in gusting wind conditions.NTSB GAA21WA174Accident · 2 fatalClass 5 · ForeignCessna 172 · Mitungyy-Meru, KenyaNTSB WPR21FA211Accident · 2 fatalClass 3 · FieldFinal reportTextron 172S · Eden, UTThe flight instructor’s improper aeronautical decision-making, which led to an encounter with a downdraft at a low altitude in mountainous terrain and resulted in the instructor’s loss of airplane control and an impact with terrain.NTSB ERA21LA236Accident · Minor injuriesClass 4 · LimitedFinal reportMaxson Phil Zodiac CH601XL · Winder, GAPilot’s inadequate supervision of the pilot rated passenger’s actions, which led to a high descent rate and collision with obstacles.NTSB ERA21FA234Accident · 7 fatalClass 3 · FieldFinal reportCessna 501 · Smyrna, TNThe pilot’s loss of airplane control during climb due to spatial disorientation.NTSB WPR21LA218Accident · Minor injuriesClass 4 · LimitedFinal reportBeech A36 · Sulphur Creek, IDThe pilot’s inability to maintain airplane control during takeoff when the airplane encountered a tailwind and gusting winds which resulted in an aborted takeoff and forced landing to rough terrain.NTSB CEN21FA238Accident · 2 fatalClass 3 · FieldFinal reportLancair Evolution · McDermott, OHThe pilot’s failure to recognize and avoid airframe icing conditions, which resulted in a loss of airplane performance and a subsequent loss of control and in-flight break-up.NTSB WPR21FA210Accident · 1 fatalClass 3 · FieldFinal reportMark Coby Early Bird Jenny · Stoneville, NCThe pilot’s exceedance of the airplane’s critical angle of attack during the takeoff initial climb, which resulted in an aerodynamic stall and a loss of control.NTSB WPR21FA203Accident · 1 fatalClass 3 · FieldFinal reportDassault Mirage F-1 · Las Vegas, NVThe pilot’s exceedance of the airplane’s critical angle of attack on approach and failure to fly a traffic pattern track consistent with a no-flap configuration. Contributing to the accident was the failure of the airplane’s flaps to extend while in the…NTSB ERA21LA226Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Lincoln Park, NJThe pilot's loss of directional control during an aborted landing in crosswind conditions.NTSB CEN21FA230Accident · 1 fatalClass 3 · FieldFinal reportSub-Sonex JSX-2 · Shreveport, LAThe pilot’s failure to maintain clearance with the water while performing aerobatics, resulting in the airplane’s impact into a lake. Contributing was the pilot’s decision to perform aerobatics at low altitude.NTSB ERA21FA225Accident · 2 fatalClass 3 · FieldFinal reportFlight Design Ctsw · Winterville, NCThe pilot’s exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall and a loss of control.NTSB ERA21FA224Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-31P · Myrtle Beach, SCThe mechanic’s inadvertent installation of the elevator trim tabs in reverse, which resulted in the pitch trim system operating opposite of the pilot’s input and the pilot’s subsequent loss of control.NTSB WPR21LA204Accident · Serious injuriesClass 3 · LimitedFinal reportMcclure B J Glasair III · Eugene, ORThe pilot’s loss of airplane control during the approach to landing due to an asymmetrical flap deployment for reasons that could not be determined based on the available evidence.NTSB WPR21LA201Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Minden, NVThe pilot’s failure to maintain airplane control while on approach in microburst or windshear conditions, which resulted in impact with a runway sign.NTSB CEN21LA223Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-502A · Clayton, LAThe pilot’s loss of airplane control resulting in an aerodynamic stall while executing a steep turnaround during an aerial application flight.NTSB GAA21WA116Accident · 2 fatalClass 4 · ForeignRobinson R66 · Dvina Bay, RussiaNTSB CEN21LA228Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Pinecreek, MNThe pilot’s failure to maintain control of the airplane in gusting crosswind conditions.NTSB CEN21LA226Accident · Serious injuriesClass 4 · LimitedFinal reportI.C.A.-Brasov IS-28B2 · Hampshire, ILThe flight instructor’s failure to maintain aircraft control resulting in the exceedance of the glider’s critical angle of attack following the breakage of the weak/safety link during a winch launch, which resulted in an aerodynamic stall and spin, and…NTSB WPR21LA222Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Las Vegas, NVThe flight instructor’s failure to compensate for a downdraft during takeoff, which resulted in a loss of control and collision with terrain.NTSB ERA21LA215Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Daytona Beach, FLBoth pilots’ failure to maintain control during the landing flare and the flight instructor’s failure to maintain control during an attempted go-around, in gusting quartering headwind conditions, which resulted in the exceedance of the airplane’s critical…NTSB ERA21LA216Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Gulf Shores, ALThe flight instructor’s delayed remedial action, which resulted in a loss of control during an attempted go-around.NTSB CEN21LA216Accident · No injuriesClass 3 · LimitedFinal reportAerospatiale AS350 B2 Ecureuil · Yukon, OKThe pilot receiving instruction’s untimely and unidentified inadvertent activation of the hydraulic cut-off switch, which turned off the hydraulic system while the helicopter was at slow airspeed followed by a rapid power increase, which resulted in a loss of…NTSB ERA21LA220Accident · No injuriesClass 4 · LimitedFinal reportDouglas K Thompson Justaircraft Superst · Brunswick, METhe pilot’s inadequate compensation for the prevailing wind conditions, which resulted in a loss of directional control during the approach and landing.NTSB CEN21FA209Accident · 4 fatalClass 3 · FieldFinal reportMitsubishi MU2B · Hattiesburg, MSThe pilot’s failure to maintain control of the airplane during the night instrument approach which resulted in an inadvertent aerodynamic stall from which the pilot was unable to recover.NTSB WPR21LA180Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Cuba, NMThe pilot's failure to maintain lateral control during takeoff after an encounter with a gusting wind, which resulted in a wing strike.NTSB ERA21LA202Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Martinsville, VAThe pilot’s improper pitch control during a go-around in gusting crosswind conditions, which resulted in a tail strike and a runway excursion.NTSB WPR21LA179Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30B · Corvallis, ORThe pilot’s failure to maintain airplane control during a simulated engine out landing which resulted in impact with terrain.NTSB ERA21FA195Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 429 · Eden, NCThe impact of the main rotor blades with the tail boom during low-altitude maneuvers, which severed the tail rotor drive shaft and resulted in a loss of control and impact with terrain.NTSB CEN21LA200Accident · 1 fatalClass 3 · LimitedFinal reportAeropro CZ S R O A240 · Richmond, INThe noninstrument-rated pilot’s intentional flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of airplane control.NTSB CEN21FA199Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Port Aransas, TXThe pilot’s failure to maintain adequate airspeed during the go-around, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall.NTSB ERA21LA191Accident · 1 fatalClass 3 · LimitedFinal reportRobinson Helicopter R44 · Forkston, PAThe pilot’s inadequate preflight weather planning, which resulted in an inadvertent encounter with instrument meteorological conditions at night, spatial disorientation, and collision with terrain.NTSB CEN21FA198Accident · 4 fatalClass 3 · FieldFinal reportPiper PA-46-310P · Danville, ARThe pilot’s improper decision to continue flight in an area of moderate-to-heavy icing conditions, which resulted in exceedance of the airplane’s anti-icing system capabilities, a degradation of aircraft performance, and subsequent aerodynamic stall.NTSB CEN21LA197Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Faribault, MNThe student pilot’s failure to maintain control during takeoff in gusty wind conditions and the flight instructor’s delayed remedial action, which resulted in the airplane colliding with trees and subsequently the ground.NTSB WPR21FA170Accident · 1 fatalClass 3 · FieldFinal reportConsolidated Vultee BT-13A · Camas, WAThe pilot’s exceedance of the airplane’s critical angle of attack during an aborted landing, resulting in an aerodynamic stall and impact with terrain.NTSB ERA21FA189Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28RT-201T · Brownsville, TNThe student pilot’s continued visual flight rules flight into night instrument meteorological conditions, which resulted in spatial disorientation and a rapid uncontrolled descent into terrain. Contributing to the accident were the self-induced and external…NTSB ANC21LA032Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Tyonek, AKThe pilot’s loss of directional control while dragging the surface of an ice- and snow-covered lake in gusting wind conditions, which resulted in an impact with a tree.