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 GAA22WA290Accident · 1 fatalClass 5 · ForeignMeriwether Jon Arion Lightning · Kenora, CanadaNTSB CEN22LA426Accident · No injuriesClass 4 · LimitedFinal reportMossman Michael D Zenair CH 601 HD · Lebanon, INThe loss of lateral/bank control during takeoff due to the pilot’s decision to operate the airplane with a known fuel imbalance.NTSB WPR22LA362Accident · No injuriesClass 4 · LimitedFinal reportAngus Watt Zenair Stolch 750 · Howe, IDThe pilot’s failure to maintain adequate airspeed during the landing approach, which resulted in an aerodynamic stall.NTSB GAA22WA285Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Chinchilla, AustraliaNTSB ERA22FA426Accident · 2 fatalClass 3 · FieldFinal reportChampion Aeronca 7AC · Bridgeton, NJThe pilot's exceedance of the airplane’s critical angle of attack shortly after takeoff, which resulted in an aerodynamic stall, loss of control, and impact with terrain.NTSB WPR22FA350Accident · 1 fatalClass 3 · FieldFinal reportAerovodochody L-29 Delfin · Reno, NVThe pilot’s in-flight incapacitation due to G-induced loss of consciousness, which resulted in a subsequent impact with terrain.NTSB GAA22WA289Accident · 2 fatalClass 5 · ForeignEvektor EV97 · Sesso, Reggio Emilia, ItalyNTSB ERA22LA424Accident · Minor injuriesClass 3 · LimitedFinal reportRockwell International 700 · Sevierville, TNThe total loss of engine power to the twin-engine airplane during final approach due to fuel exhaustion. Contributing to the accident was the pilot’s failure to maintain aircraft control during the approach to land, which resulted in a runway excursion and…NTSB ERA22FA422Accident · 2 fatalClass 3 · FieldFinal reportWren Ronnie D Titan II · Citra, FLThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain airspeed while recovering from an aerobatic maneuver, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot’s use of…NTSB WPR22FA348Accident · 2 fatalClass 3 · FieldFinal reportTrom Wayne Vans RV6A · Aztec, AZThe total loss of engine power for reasons that could not be determined based on available evidence. Contributing to the accident was the pilot’s decision to turn away from a suitable emergency landing surface, his failure to maintain adequate airspeed as the…NTSB WPR22FA347Accident · 2 fatalClass 3 · FieldFinal reportSkiles Kenneth C RV-6A · Preston, IDThe non-instrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.NTSB CEN22FA416Accident · 1 fatalClass 3 · FieldFinal reportPipistrel Italia S R L Sinus 912 LSA · Waller, TXThe pilot’s failure to maintain aircraft control, which led to an aerodynamic stall at an altitude where recovery was not possible.NTSB ERA22LA419Accident · No injuriesClass 4 · LimitedFinal reportAutogyro USA Calidus · Jasper, GAThe pilot’s failure to maintain control of the gyroplane during a touch-and-go landing.NTSB ERA22FA405Accident · 1 fatalClass 3 · FieldFinal reportBeech 95-B55 · Hartwell, GAThe pilot’s spatial disorientation and subsequent loss of airplane control following a perceived undetermined problem with the airplane’s gyroscopic instrumentation.NTSB WPR22FA338Accident · 2 fatalClass 3 · FieldFinal reportCzech Sport Piper Sport · Santa Monica, CAThe pilot’s inability to maintain control of the airplane during the landing flare due to the passenger’s excessive control inputs, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall.NTSB WPR22LA339Accident · Minor injuriesClass 3 · LimitedFinal reportBell 205A-1 · Cougar, WAThe helicopter’s encounter with downdrafts during a low-altitude hovering maneuver while dipping for water.NTSB CEN22FA406Accident · 2 fatalClass 3 · FieldFinal reportCessna 182 · Cleveland, TNThe pilot’s loss of airplane control while operating in instrument meteorological conditions.NTSB WPR22LA333Accident · Serious injuriesClass 3 · LimitedFinal reportBell 407 · Mount Baldy, CAThe pilot’s failure to ensure the throttle was properly positioned before commencing an approach to land, which resulted in a low rotor rpm condition and impact with terrain. Contributing to the accident was a worn throttle detent.NTSB GAA22WA268Accident · 4 fatalClass 5 · ForeignCessna 551 · Baltic Sea, LatviaNTSB GAA22WA265Accident · 2 fatalClass 3 · ForeignRobinson R66 · Zapallar, ChileNTSB DCA22MA193Accident · 10 fatalClass 1 · MajorFinal reportDehavilland DHC-3 · Freeland, WAThe in-flight unthreading of the clamp nut from the horizontal stabilizer trim actuator barrel due to a missing lock ring, which resulted in the horizontal stabilizer moving to an extreme trailing-edge-down position rendering the airplane’s pitch…NTSB WPR22FA331Accident · 1 fatalClass 3 · FieldFinal reportYakovlev YAK-11 · Shafter, CAThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the loss of engine oil pressure shortly after takeoff.NTSB GAA22WA267Accident · No injuriesClass 5 · ForeignBell 205 · La Ronge, SK, CanadaNTSB ERA22FA391Accident · 1 fatalClass 3 · FieldFinal reportAeronca 7AC · Jacksboro, TNThe pilot's exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall and loss of control.NTSB WPR22LA329Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 Clipper 1 · Deadhorse, AKThe pilot's failure to maintain helicopter control during a descent, which resulted in a collision with terrain.NTSB GAA22WA263Accident · 1 fatalClass 5 · ForeignPitts S1S · Shobdon, United KingdomNTSB ERA22FA384Accident · 2 fatalClass 3 · FieldFinal reportMXR Technologies MX2 · Osteen, FLThe pilot’s loss of airplane control while performing aerobatic maneuvers, which resulted in the airplane entering an inverted flat spin that continued until the airplane impacted terrain.NTSB WPR22FA311Accident · 1 fatalClass 3 · FieldFinal reportSmyth Sidewinder TD · Wichita Falls, TXThe pilot’s inexperience with the airplane and inadequate takeoff procedures, which led to exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.NTSB WPR22LA328Accident · No injuriesClass 4 · LimitedFinal reportFall Martin Super CUB · Stanley, IDThe pilot’s failure to maintain airplane control during takeoff with a crosswind.NTSB WPR22LA310Accident · Serious injuriesClass 3 · LimitedFinal reportStucker Gary Banty · Camarillo, CAThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB DCA22WA194AccidentClass 5 · ForeignUvify IFO · Darwin, AustraliaNTSB WPR22LA307Accident · No injuriesClass 4 · LimitedFinal reportRans S20 · Bountiful, UTThe pilot’s improper landing flare and subsequent loss of airplane control during a go-around when the airplane stalled and collided with the ground.NTSB WPR22FA304Accident · 2 fatalClass 3 · FieldFinal reportAviat A-1A · Yellow Pine, IDThe pilot's failure to maintain adequate airspeed during an initial climb, which resulted in the exceedance of the critical angle of attack, subsequent aerodynamic stall, and impact with terrain. Contributing was the pilot’s decision to operate the airplane…NTSB WPR22LA302Accident · Minor injuriesClass 3 · LimitedFinal reportGoddard Dick Sim Bensen B-8M · Corona, CAThe fatigue failure of the engine mount resulting in a loss of engine power and directional control while maneuvering.NTSB CEN22LA390Accident · No injuriesClass 4 · LimitedFinal reportAero Commander 100-180 · Pueblo, COThe flight instructor’s failure to maintain adequate airspeed during the demonstrated soft-field takeoff, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB ERA22FA368Accident · 3 fatalClass 3 · FieldFinal reportPiper PA32 · Metz, WVThe non-instrument-rated pilot’s intentional visual flight into instrument meteorological conditions based on latent weather information, which resulted in the airplane entering extreme precipitation, a loss of aircraft control, and in-flight break-up.NTSB ANC22FA066Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-12 · Arctic Village, AKThe pilot’s decision to depart in turbulent and gusting wind conditions, which resulted in a loss of control and impact with terrain.NTSB CEN22FA375Accident · 1 fatalClass 3 · FieldFinal reportSonex Waiex · Maxwell, CAA loss of control in flight for undetermined reasons that resulted in an impact with terrain.NTSB GAA22WA277Accident · No injuriesClass 5 · ForeignPiper PA-28-140 · Gloucestershire, United KingdomNTSB GAA22WA269Accident · 2 fatalClass 5 · ForeignShort SC7 · Piotrków Trybunalski, PolandNTSB ERA22FA354Accident · 1 fatalClass 3 · FieldFinal reportPiper J3C-65 · Cynthiana, KYThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall while maneuvering to land with approaching convective activity.NTSB ERA22FA350Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-502 · Cheneyville, LAThe pilot’s loss of control after exceeding the airplane’s critical angle of attack for reasons that could not be determined.NTSB ERA22FA344Accident · 2 fatalClass 3 · FieldFinal reportHarvey J Brock Tango 2 · Melrose, FLA loss of control for undetermined reasons.NTSB CEN22LA362Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Longmont, COThe flight instructor’s failure to properly supervise the student pilot, which resulted in a continued unstablized approach for landing, and the instructor’s delayed recovery that resulted in a loss of control and impact with terrain.NTSB ERA22FA343Accident · Serious injuriesClass 3 · FieldFinal reportEurocopter AS350 · Andalusia, ALThe pilot’s acute incapacitation by a syncopal episode, which resulted in the helicopter departing controlled flight and colliding with terrain.NTSB CEN22LA440Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Merrill, WIThe student pilot's failure to maintain adequate roll control during takeoff with a quartering tailwind.NTSB WPR22LA267Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Cedar City, UTThe student pilot’s failure to maintain rotor rpm and airspeed and the flight instructor's inadequate remedial action to regain helicopter control during the straight-in autorotation which resulted in a hard landing.NTSB WPR22FA266Accident · 2 fatalClass 3 · FieldFinal reportHolland Mike RV9A · Tryon, NEThe non-instrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, exceedance of the airplane’s design limitations, and in-flight breakup of the airplane…NTSB WPR22FA264Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28-235 · Seguin, TXThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude after being distracted when the engine cowling opened during flight, which led to a loss of control and subsequent impact with terrain. Contributing to the accident was the…NTSB CEN22FA331Accident · 2 fatalClass 3 · FieldFinal reportColumbia Helicopters CH-47D · North Fork, IDThe failure of the flight crew to properly secure a company-issued iPad, leading to its migration into and jamming of the copilot’s left pedal, preventing the pilot from arresting a left yaw, and resulting in a loss of control.