NTSB investigations
3,840 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 CEN23LA381Accident · Serious injuriesClass 4 · LimitedFinal reportGeorge Stone KIT FOX Model 3 · Scottsburg, INThe student pilot’s failure to maintain airplane control after takeoff that resulted in an impact with terrain.NTSB CEN23FA340Accident · 1 fatalClass 3 · FieldFinal reportRichards Heavylift Helo UH-1H · Oakdale, ILAn in-flight loss of control for undetermined reasons.NTSB WPR23FA287Accident · 3 fatalClass 3 · FieldFinal reportBeech P35 · Upland, CAThe pilot’s exceedance of the airplane’s critical angle of attack, for reasons that could not be determined, which resulted in a subsequent aerodynamic stall and impact with a building.NTSB WPR23FA286Accident · 1 fatalClass 3 · FieldFinal reportRisen 915 iS · Glendive, MTThe pilot’s failure to maintain airspeed, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall/spin.NTSB CEN23LA335Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Tyler, MNThe pilot’s improper flap position during takeoff, which resulted in degraded climb performance and a collision with terrain.NTSB ERA23FA313Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28R · Churchville, MDThe pilot’s exceedance of the airplane’s critical angle of attack during initial climb, which resulted in an aerodynamic stall/spin and loss of control that the pilot did not recover from.NTSB CEN23FA320Accident · Minor injuriesClass 3 · FieldFinal reportHeath V-Strut · Oshkosh, WIThe 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 CEN23FA315Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Houston, TXThe student pilot’s loss of airplane control in dark night conditions.NTSB GAA23WA208AccidentClass 5 · ForeignCessna 208B · Chrcynno, PolandNTSB GAA23WA209Accident · 1 fatalClass 5 · ForeignExtra 300 · Selänpää, FinlandNTSB GAA23WA277Accident · Serious injuriesClass 5 · ForeignCessna 172 · Novosibirsk,, RussiaNTSB CEN23FA304Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Osage Beach, MOThe pilot’s failure to properly set the stabilator trim before takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.NTSB GAA23WA247AccidentClass 5 · ForeignBell AB47G · Arles, FranceNTSB WPR23LA265Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Emmett, IDThe instructor’s failure to maintain airspeed during a simulated turning autorotation, which resulted in a hard landing.NTSB CEN23FA284Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-30 · Sherman, TXThe pilot’s failure to maintain control during a forced landing following a loss of engine power. Contributing was the pilot’s failure to feather the left propeller following the loss of engine power.NTSB GAA23WA283Accident · No injuriesClass 5 · ForeignRobinson R44 · Warszawa, PolandNTSB WPR23LA255Accident · Serious injuriesClass 3 · LimitedFinal reportAvia Stroitel AC-5M · North Plains, ORThe pilot’s failure to maintain control of the motor glider, which resulted in an inflight overstress separation of the right wing during a high-speed, high-wing-load spiral dive recovery. Contributing to the accident was the inadequately manufactured wing…NTSB GAA23WA196Accident · Minor injuriesClass 5 · ForeignThrush S2R · Magdelena, ColombiaNTSB ERA23LA287Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Myrtle Beach, SCThe pilot’s failure to maintain control of the helicopter during a hover taxi, which resulted in a rollover.NTSB DCA23LA340Accident · No injuriesClass 4 · LimitedFinal reportSupernal SUP83-1 · California City, CAErroneous signal processing that resulted in a total loss of propulsion power.NTSB GAA23WA204AccidentClass 5 · ForeignMalloy T150 · South Scarle, United KingdomNTSB WPR23LA243Accident · No injuriesClass 3 · LimitedFinal reportKitfox 2 · Cave Junction, ORThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB GAA23WA191Accident · Serious injuriesClass 5 · ForeignIcon A5 · Donam Port, North KoreaNTSB CEN23LA260Accident · No injuriesClass 4 · LimitedFinal reportSharp Glennis Escapade · Bolivar, MOThe pilot’s failure to maintain aircraft control during a soft-field takeoff after encountering a wind gust.NTSB CEN23LA255Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Westhope, NDThe pilot’s failure to maintain aircraft control that resulted in an impact with terrain after takeoff.NTSB CEN23LA247Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · Cedar Lake, INThe failure of the flight instructor to attain/maintain aircraft control while maneuvering, which resulted in an uncontrolled descent and impact with the lake.NTSB CEN23LA245Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Louise, TXThe pilot’s failure to maintain directional control in gusting wind conditions.NTSB GAA23WA168Accident · No injuriesClass 5 · ForeignMooney M20R · Toledo, SpainNTSB WPR23LA233Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Elko, NVThe pilot’s loss of control after encountering a dust devil during takeoff.NTSB CEN23LA240Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC-65 · Sibley, IAThe pilot’s failure to maintain adequate airspeed on final approach resulting in the airplane inadvertently exceeding the critical angle of attack and entering an inadvertent aerodynamic stall.NTSB CEN23LA427Accident · Minor injuriesClass 4 · LimitedFinal reportQuad City Challenger · Indianola, MSThe non-certificated pilot’s loss of control during the night landing.NTSB CEN23FA239Accident · 2 fatalClass 3 · FieldFinal reportMooney M20R · Watertown, WIThe pilot’s loss of control due to spatial disorientation while operating in instrument meteorological conditions. Contributing to the accident was the pilot’s impairment from the prohibited substance; however, the extent of impairment could not be determined.NTSB CEN23LA238Accident · No injuriesClass 4 · LimitedFinal reportMooney M10 · Gassville, ARThe pilot’s failure to maintain control of the airplane during takeoff with a quartering tailwind.NTSB ERA23FA266Accident · 1 fatalClass 3 · FieldFinal reportWonder Michael S Harmon Rocket · Porter, NYThe pilot’s failure to maintain control of the airplane while initiating a low-altitude aerobatic maneuver, which resulted in impact with trees and terrain. Contributing to the accident was the pilot’s high-risk behavior.NTSB ERA23LA296Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Lumberton, NJThe student pilot’s improper flight control inputs and the flight instructor’s delayed remedial action during takeoff, which resulted in a runway excursion and impact with the runway edge lights.NTSB WPR23FA219Accident · 2 fatalClass 3 · FieldFinal reportSteen Skybolt · Rio Vista, CAThe pilots’ exceedance of the airplane's critical angle of attack while maneuvering to land, which resulted in an aerodynamic stall and subsequent loss of control.NTSB ERA23FA258Accident · 2 fatalClass 3 · FieldFinal reportCirrus SR22 · Jamestown, NYThe pilots’ failure to maintain airplane control following an anomalous engine indication during the initial climb, which resulted in a loss of control and parachute deployment at an altitude too low for the system to operate effectively. Contributing to the…NTSB WPR23LA214Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206B · Filer, IDThe pilot’s improper anti-torque pedal inputs during takeoff, which resulted in a loss of helicopter control during takeoff and subsequent dynamic rollover.NTSB WPR23FA208Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-31-325 · Tupelo, MSThe pilot's exceedance of the airplane's critical angle of attack while maneuvering after takeoff for reasons that could not be determined, which resulted in an aerodynamic stall and subsequent loss of control.NTSB CEN23LA228Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164 · Saffell, ARThe airplane’s encounter with a dust devil after takeoff, which resulted in a loss of lift, and a subsequent loss of control. Contributing to the accident was the presence of a dust devil in the airplane’s flight path.NTSB CEN23LA219Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Pontiac, MIThe flight crew’s inadequate compensation for gusting wind, and the flight instructor’s delayed remedial action, which resulted in impact with the ground.NTSB CEN23LA209Accident · No injuriesClass 4 · LimitedFinal reportKolb Firestar SS · Lodi, WIThe pilot’s failure to maintain control during takeoff.NTSB CEN23LA205Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 8KCAB · Larchwood, IAThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack during initial climb after takeoff, which resulted in an aerodynamic stall and impact with the ground.NTSB GAA23WA158Accident · 2 fatalClass 5 · ForeignCessna 172 · Monagas, VenezuelaNTSB WPR23LA200Accident · No injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B3 · San Diego, CAThe pilot’s failure to maintain altitude during a hover taxi due to distraction resulting from the unanticipated activation of strobing lights while using night vision googles.NTSB WPR23LA194Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CCX-2300 · Spanish Fork, UTThe pilot's decision to attempt an unfamiliar takeoff technique, his failure to maintain pitch control during takeoff, and his subsequent decision to retract flaps at a low altitude, which resulted in a descent into a building.NTSB ERA23LA240Accident · 1 fatalClass 3 · LimitedFinal reportCessna R182 · Macon, NCThe pilot’s failure to properly set the elevator trim before takeoff, which resulted in a loss of control during takeoff.NTSB CEN23LA193Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32RT · DeKalb, ILThe pilot’s failure to maintain aircraft control during a go-around in gusting winds. Contributing was the presence of windshear.NTSB CEN23LA191Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Genoa, ILThe pilot’s failure to maintain airplane control during a go-around.NTSB ERA23FA234Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-25-235 · Hollywood, FLThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and loss of aircraft control.