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 GAA22WA180Accident · Minor injuriesClass 5 · ForeignBell 206 · Santa Ana Mountain, ColombiaNTSB GAA22WA063Accident · 4 fatalClass 4 · ForeignRockwell 114 · Redcliffe, AustraliaNTSB CEN22FA080Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-300 · Bloomington, INThe pilot’s failure to follow the instrument landing system (ILS) course guidance, which resulted in the pilot’s loss of airplane control during the instrument approach. Contributing to the accident was the presence of turbulence and low-level wind shear.NTSB ERA22LA090Accident · 2 fatalClass 3 · LimitedFinal reportAerofab Lake LA-4-250 · Auburndale, FLA bird strike, which resulted in a loss of control while flying at low altitude over a lake.NTSB ERA22LA089Accident · 1 fatalClass 3 · LimitedFinal reportCirrus Design SR22 · Knoxville, TNThe pilot’s encounter with a wake vortex from a preceding airplane, which resulted in a roll upset at an altitude too low for recovery. Contributing to the accident was the failure of ATC to issue a wake turbulence cautionary advisory.NTSB CEN22LA077Accident · No injuriesClass 4 · LimitedFinal reportHughes 269A · Crowley, TXThe student pilot’s encounter with a loss of tail rotor effectiveness during hover, and the flight instructor’s delayed remedial action that resulted in an emergency landing and impact with terrain.NTSB GAA22WA049Accident · 1 fatalClass 5 · ForeignRans S12 · Szadek, PolandNTSB CEN22FA070Accident · 1 fatalClass 3 · FieldFinal reportCessna 310J · Inola, OKThe loss of airplane control for reasons that could not be determined based on the available evidence.NTSB WPR22LA061Accident · 1 fatalClass 3 · LimitedFinal reportMoul Willis RV-3 · Bermuda Dunes, CAThe pilot’s improper positioning of the fuel shutoff valve, which resulted in a loss of engine power, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack, resulting in an aerodynamic stall and loss of control.NTSB ERA22FA086Accident · 1 fatalClass 3 · FieldFinal reportSwearingen SA226 · Bedford, NHThe pilot’s failure to secure and feather the left engine and increase power on the right engine after a perceived loss of engine power in the left engine, which resulted in a loss of control and impact with terrain just short of the runway. Contributing to…NTSB ERA22FA085Accident · 2 fatalClass 3 · FieldFinal reportBeech V35 · Crab Orchard, KYThe noninstrument-rated pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control and collision with terrain. Contributing to the accident was…NTSB CEN22LA068Accident · Serious injuriesClass 4 · LimitedFinal reportCHR International Safari 400 · McKinney, TXThe pilot did not remove the cyclic control lock during preflight, which resulted in a loss of control during the initial hover.NTSB CEN22FA067Accident · 2 fatalClass 3 · FieldFinal reportPiper PA 28-140 · Houston, TXThe student pilot’s decision to depart into night instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB ERA22FA083Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Statesboro, GAThe pilot’s decision to initiate a visual flight rules flight into dark night instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of control shortly after takeoff.NTSB CEN22FA064Accident · 1 fatalClass 3 · FieldFinal reportVans RV-4 · Walsenburg, COThe pilot’s failure to maintain clearance from terrain while intentionally maneuvering in a canyon at low altitude. Contributing to the accident was the pilot’s decision to enter a canyon environment at a low altitude, and the sudden change in wind conditions…NTSB WPR22FA055Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-31-350 · Medford, ORThe pilot’s failure to maintain aircraft control during the initial climb into clouds due to spatial disorientation, which resulted in an uncontrolled descent and collision with terrain.NTSB CEN22LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Tahlequah, OKA loss of yaw control while on final approach, which resulted in the pilot performing an off-runway landing, and a subsequent nose over. The reason for the loss of yaw control could not be determined based on the available evidence.NTSB WPR22FA053Accident · 1 fatalClass 3 · FieldFinal reportRussell W Dyer Vortex · Lakeport, CAThe pilot’s loss of control for reasons that could not be determined and the delayed remedial action to recover from the power pushover event.NTSB CEN22LA061Accident · Serious injuriesClass 4 · LimitedFinal reportExperimental Nieuport-12 · Midland, TXThe pilot’s loss of directional control during a high-speed taxi operation and subsequent collision with terrain during the inadvertent flight.NTSB CEN22FA053Accident · 1 fatalClass 3 · FieldFinal reportBell 206 · Perry, OKA loss of lateral control during a hover that resulted in an impact with terrain. Based on the available evidence, the reason for the loss of lateral control could not be determined.NTSB WPR22LA050Accident · Serious injuriesClass 4 · LimitedFinal reportAlon A2 · Frazier Park, CAThe pilot’s failure to maintain adequate airspeed while on approach for landing which, resulted in an aerodynamic stall and collision with terrain.NTSB WPR22FA048Accident · 1 fatalClass 3 · FieldFinal reportZenith Zodiac CH601XL · Temecula, CAThe failure of the airplane’s canopy latch system, which resulted in the canopy opening in flight and a loss of airplane control. Contributing to the accident was the lack of a secondary canopy latch as recommended by the kit manufacturer.NTSB CEN22FA042Accident · 3 fatalClass 3 · FieldFinal reportCessna T310R · Chadron, NEThe incapacitating effects of a myocardial infarction (heart attack), which resulted in the pilot's loss of airplane control and impact with terrain.NTSB ERA22LA070Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Old Bridge, NJThe student pilot’s loss of control during a go-around, which resulted in an aerodynamic stall.NTSB CEN22LA043Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Wheeling, ILThe student pilot’s improper landing flare, which resulted in a hard landing. Contributing was the student pilot’s self-induced pressure to land after being admonished by the controller.NTSB ERA22LA069Accident · Serious injuriesClass 4 · LimitedFinal reportK Copters 47G-2 · Lancaster, PAThe flight instructor’s failure to ensure a positive transfer of aircraft control, which resulted in a loss of control and collision with terrain.NTSB CEN22LA041Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Miamisburg, OHThe student pilot’s failure to maintain control of the helicopter during a low-altitude hover shortly after liftoff.NTSB CEN22FA035Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802A · Estes Park, COThe airplane’s encounter with severe to extreme turbulence associated with mountain wave rotor cloud activity, which resulted in loss of airplane control.NTSB CEN22FA032Accident · 2 fatalClass 3 · FieldFinal reportBeech E-90 · Boyne City, MIThe pilot’s failure to maintain sufficient airspeed and his exceedance of the airplane’s critical angle of attack while in icing conditions, which resulted in an aerodynamic stall and subsequent ground impact.NTSB GAA22WA028Accident · 1 fatalClass 5 · ForeignJust Escapade · York, United KingdomNTSB ERA22LA062Accident · Serious injuriesClass 4 · LimitedFinal reportMaxair Drifter · Sebring, FLThe non-certificated pilot’s decision to operate the airplane without flight training or a pilot certificate and his loss of control shortly after takeoff, which resulted in an aerodynamic stall at low altitude and collision with terrain.NTSB ERA22FA058Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Branchville, NJThe flight instructor’s failure to recover from a steep spiral turn during an instructional flight.NTSB ERA22FA056Accident · 1 fatalClass 3 · FieldFinal reportZenith CH601 · Oak Hill, FLA loss of airplane control while maneuvering at low altitude.NTSB CEN22LA034Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Fort Davis, TXThe pilot’s encounter of a downdraft from which there was insufficient altitude to recover.NTSB ERA22FA050Accident · 1 fatalClass 3 · FieldFinal reportMooney M20F · Villa Rica, GAThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and spin.NTSB ANC22FA005Accident · 1 fatalClass 3 · FieldFinal reportGerald Jones 2+2 · Kodiak, AKThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB CEN22FA029Accident · 1 fatalClass 3 · FieldFinal reportVans RV · Harrison, MIThe pilot’s failure to maintain adequate airspeed and exceedance of the airplane’s critical angle of attack during landing approach, which resulted in an aerodynamic stall.NTSB WPR22FA026Accident · 1 fatalClass 3 · FieldFinal reportAyres S-2R · Shafter, CAThe pilot’s decision to depart into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control.NTSB ERA22LA043Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-28-236 · Orleans, MAThe pilot’s spatial disorientation and subsequent loss of airplane control while maneuvering over water in dark night conditions.NTSB ERA22FA036Accident · 1 fatalClass 3 · FieldFinal reportVans RV4 · Chattahoochee, FLThe pilot’s failure to properly secure the canopy before takeoff, allowing the canopy to open and then separate in flight, which resulted in the pilot’s failure to maintain control of the airplane for reasons that could not be determined based on the…NTSB CEN22FA023Accident · 2 fatalClass 3 · FieldFinal reportBeech P35 · Harrison, NEThe pilot’s decision to continue the flight into instrument and icing conditions, which resulted in loss of control and impact with terrain. Contributing to the accident was the pilot’s failure to obtain a timely weather briefing.NTSB WPR22FA023Accident · 1 fatalClass 3 · FieldFinal reportMooney M20M · Snoqualmie, WAThe pilot’s decision to fly the airplane into known icing conditions, which resulted in a loss of airplane control and collision with terrain.NTSB ANC22LA004Accident · 1 fatalClass 3 · LimitedFinal reportGregg Origer PA-18 Replica · Willow, AKThe pilot's exceedance of the airplane’s critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and loss of control.NTSB CEN22LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Wadsworth, OHThe student pilot’s failure to maintain aircraft control during the final approach resulting in a bounced landing.NTSB CEN22FA019Accident · 2 fatalClass 3 · FieldFinal reportAmerican Champion 8KCAB · Marengo, WIThe pilot’s failure to maintain adequate airspeed during the steep turn, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Also causal was the pilot’s decision to conduct steep turns without sufficient altitude to…NTSB ERA22LA025Accident · Serious injuriesClass 4 · LimitedFinal reportPipistrel Apis-Bee · Columbia, SCThe pilot’s failure to maintain control of the glider during the landing approach, which resulted in an aerodynamic stall and subsequent impact with the runway.NTSB ERA22FA024Accident · 2 fatalClass 3 · FieldFinal reportMooney M20J · Holly Ridge, NCThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in a stall/mush during takeoff and initial climb. Contributing to the accident was the pilot’s loading the airplane near its maximum allowable gross weight and near its aft cg…NTSB GAA22WA039Accident · 1 fatalClass 5 · ForeignCessna 401 · Tapachula, MexicoNTSB WPR22FA012Accident · 1 fatalClass 3 · FieldFinal reportRockwell 112 · Three Points, AZThe pilot’s failure to maintain proper airspeed while maneuvering, which resulted in the exceedance of the airplane’s critical angle of attack and the airplane entering an aerodynamic stall.NTSB ERA22LA018Accident · Serious injuriesClass 3 · LimitedFinal reportZ-Hi-Max 1400 · Benton, PAThe pilot’s loss of control and encounter with an aerodynamic stall during a planned low-altitude turn toward the airport after takeoff.