NTSB investigations
8,203 cases where the first occurrence 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250) 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 DEN00LA163Accident · 2 fatalLimited investigationFinal reportNicholson Thorp T-18CWS · Tooele, UTFailure by the pilot to maintain control of the airplane during aerobatic maneuvers as a result of his alcohol impairment. Factors were: The pilot's inadequate planning and decision making and the inadequate altitude he choose for maneuvering.NTSB DEN00FA164Accident · 2 fatalField investigationFinal reportNorth American SNJ-5 · Steamboat Spg, COthe pilot's inadvertent entry into a spin while performing aerobatics.NTSB ANC00LA112Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mcgrath, AKThe pilot's inadequate removal of frost from the airplane, and the inadvertent stall during takeoff. A factor was wind gusts.NTSB LAX00FA322Accident · 4 fatalField investigationFinal reportPiper PA-46-310P · So. Lake Tahoe, CAThe pilot's in-flight loss of control in the takeoff initial climb for undetermined reasons.NTSB CHI00LA281Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Blakesburg, IAThe pilot failed to add full power during a go around which resulted in descreased airspeed and a subsequent stall. A factor associated with the accident was the airplane stopped on the edge of the airstrip.NTSB SEA00LA174Accident · No injuriesLimited investigationFinal reportBeard Lancair 320 · Bend, ORThe pilot's failure to take adequate remedial action upon encountering aircraft control difficulties during landing. Factors included gusty wind conditions and the pilot's failure to maintain aircraft control during landing.NTSB NYC00FA245Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Lexington, VAThe pilot's attempted VFR flight into instrument meteorological conditions that resulted in spatial disorientation. A factor in this accident was the pilot's inadequate preflight planning.NTSB LAX00FA319Accident · 2 fatalField investigationFinal reportCessna 150L · Laton, CAfailure of the pilot to maintain an adequate airspeed while maneuvering, resulting in a stall at an altitude too low to allow recovery.NTSB CHI00FA276Accident · 2 fatalField investigationFinal reportBeech E-55 · Grafton, ILThe pilot not maintaining aircraft control and altitude/clearance from the river. Factors to the accident included the pilot not obtaining an air traffic control clearance prior to departure into instrument meteorological conditions, the pilot becoming…NTSB MIA00LA252Accident · 1 fatalLimited investigationFinal reportPitts S1-T · Vero Beach, FLthe pilot's failure to maintain control in flight, which resulted in an uncontrolled descent, and collision with the ground.NTSB SEA00LA172Accident · Serious injuriesLimited investigationFinal reportCessna 411 · Boise, IDAircraft control was not maintained during approach for landing.NTSB NYC00LA241Accident · No injuriesLimited investigationFinal reportFreund Wittman W10 · Valley City, OHThe pilot's failure to maintain aircraft control during the takeoff. A factor in this accident was the crosswind condition.NTSB MIA00LA247Accident · No injuriesLimited investigationFinal reportCessna 182Q · Fayetteville, TNthe pilot's failure to maintain adequate airspeed during the takeoff/initial climb, which resulted in an inadvertent stall/mush and collision with the runway that resulted in substantial damage to the airplane.NTSB MIA00LA245Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Berlin, GAthe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall and collision with terrain.NTSB SEA00LA169Accident · Serious injuriesLimited investigationFinal reportClearwaters RAF 2000 · Leahy, WAA loss of control for undetermined reasons.NTSB FTW00FA236Accident · 1 fatalField investigationFinal reportCessna 150 · Collinsville, OKthe pilot's failure to maintain control of the aircraft while maneuvering after takeoff, which resulted in an inadvertent stall/spin and impact with terrain.NTSB CHI00LA264Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Mackinac Island, MIthe pilot not maintaining aircraft control in response to the uncommanded roll, and the excessive descent to the runway resulting in the hard landing. Factors relating to the accident were the pilot's attempted recovery from the uncommanded roll, the high…NTSB CHI00FA262Accident · 2 fatalField investigationFinal reportBell OH-58C · Watertown, WIThe spatial disorientation by the pilot during continued flight into instrument conditions and the inadequate surveillance by the operator. The inoperative attitude indicator and night conditions were contributing factors.NTSB MIA00LA241Accident · 1 fatalLimited investigationFinal reportBurgess AIR Command · Punta Gorda, FLThe pilot's failure to maintain aircraft control while performing aerobatic flight resulting in an in-flight loss of control, inadvertent stall, and subsequent in-flight collision with power lines, fence, and terrain. Contributing to the accident was the…NTSB LAX00LA305Accident · No injuriesLimited investigationFinal reportCessna 172 · Flagstaff, AZThe pilot's improper go-around procedure and his failure to maintain directional control on landing.NTSB MIA00LA239Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Zephyrhills, FLThe student pilot's failure to maintain airspeed on final approach resulting in an inadvertent stall/spin and subsequent in-flight collision with terrain.NTSB FTW00LA234Accident · Minor injuriesLimited investigationFinal reportCessna 152 · San Antonio, TXThe pilot's failure to maintain aircraft control. A factor was the crosswind.NTSB DEN00LA152Accident · No injuriesLimited investigationFinal reportRosenbarger Lancair IV · Artesia, NMFailure by the pilot in command to maintain control of the aircraft during initial climb following takeoff.NTSB CHI00FA263Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Watertown, WIAircraft control not being maintained during initial climb resulting in a stall/mush. Factors to the accident were the pilot's inadequate preflight planning/preparation, the pilot operating over the airplane's certified maximum gross weight, and the pilot…NTSB SEA00LA165Accident · Serious injuriesLimited investigationFinal reportLadd Nieuport 11 · White Pine, MTThe pilot's failure to maintain adequate airspeed during takeoff after becoming airborne. Contributing factors were his lack of overall recent flight experience and the stall.NTSB FTW00LA230Accident · Minor injuriesLimited investigationFinal reportAeronca 65-CA · Liberty Hill, TXthe pilot's inadvertent activation of the left rudder control, which resulted in a loss of control while in cruise flight.NTSB CHI00LA257Accident · 1 fatalLimited investigationFinal reportAyres S2R-600 · Bad Axe, MIThe inadvertent stall/spin encountered by the pilot. A factor was the low altitude.NTSB NYC00LA230Accident · No injuriesLimited investigationFinal reportRedsell Windrose · Marion, OHThe pilot's failure to maintain control of the glider. Factors in this accident were the strong crosswinds, and thermals, which existed during the flight.NTSB NYC00FA226Accident · 1 fatalField investigationFinal reportCessna 172 · Davis, WVThe pilot-in-command's inadequate weather evaluation, which resulted in a takeoff with a tailwind, and a subsequent inadvertent stall. Factors were a high gross weight, a high density altitude, and a tailwind.NTSB NYC00FA225Accident · 1 fatalField investigationFinal reportGrumman American AA-5 · Cherry Valley, NYThe pilot's improper decision to continue the flight into deteriorating weather, which resulted in his failure to maintain control of the airplane. Factors in the accident were the dark night, fog, low ceiling, and the pilot's inadequate preflight planning.NTSB LAX00LA294Accident · No injuriesLimited investigationFinal reportDickenson Avid Magnum · Ely, NVThe pilot's inadequate compensation for a gusting crosswind that resulted in a loss of directional control and subsequent collision with the ground.NTSB ATL00FA079Accident · 3 fatalField investigationFinal reportCessna 172H · Peachtree City, GAThe pilot's improper use of takeoff checklist procedures, and his failure to maintain flying speed, which resulted in a stall and subsequent collision with the ground. Factors: A factor was the landing flaps were not retracted.NTSB MIA00LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Crossville, TNThe pilot's inadequate compensation for wind and his failure to maintain obstacle clearance. The crosswind was a contributing factor.NTSB MIA00LA234Accident · 1 fatalLimited investigationFinal reportEachon Time Warp Spitfire 9 · Lakeland, FLa loss of control which resulted in an inadvertent stall at too low an altitude to allow recovery. Factors in this accident were, the pilot/owner did not verify that the airplane was balanced before the flight, and he did not perform any weight or balance…NTSB ATL00TA080Accident · No injuriesFinal reportBell OH-58C · Tampa, FLThe pilot's improper use of flight controls that resulted in low rotor induced oscillation during a practice autorotation.NTSB FTW00LA226Accident · No injuriesLimited investigationFinal reportCessna 182M · Shawnee, OKThe pilot's failure to maintain control of the airplane during the landing flare/touchdown. A factor was the gusty wind condition.NTSB CHI00LA240Accident · Minor injuriesLimited investigationFinal reportThompson Avid Mark IV · Springfield, MOthe pilot's inadequate preflight planning, his failure to abort the takeoff, and the inadequate airspeed. Factors included the tall runway grass, the quartering tailwind, and the trees.NTSB LAX00GA286Accident · 1 fatalFinal reportBell 206L-1 · Montello, NVThe loss of control in hovering flight and impact with terrain for undetermined reasons.NTSB CHI00LA239Accident · Minor injuriesLimited investigationFinal reportKollier Pitts S1C · Salem, INThe pilot failed to maintain control of the airplane during an intentional inverted flat spin and the initial control inputs he used in an attempt to recover were improper. A factor associated with the accident was the pilot became disoriented during the…NTSB SEA00LA151Accident · Serious injuriesLimited investigationFinal reportKokenge Glastar · Butte, MTA loss of aircraft control for undetermined reasons.NTSB CHI00FA234Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Beloit, KSthe inadvertent stall. Factors relating to the accident were the pilot's low altitude, his abrupt pull up, the power lines, and his lack of recent flying experience.NTSB FTW00LA222Accident · Serious injuriesLimited investigationFinal reportRomero SEA REY · Tulsa, OKThe loss of control by the pilot due to incapacitation for unknown reasons.NTSB ATL00LA070Accident · 2 fatalLimited investigationFinal reportLeslie Briggs Glasair III · Smithfield, NCThe pilot's failure to maintain flying speed during an emergency landing which lead to an inadvertent stall/spin. A factor was the pilot's failure to secure the cockpit canopy prior to takeoff.NTSB NYC00LA213Accident · 2 fatalLimited investigationFinal reportSchwarz Zodiac CH 601 · Wooster, OHThe pilot's loss of control of the airplane while turning from base onto final, which resulted in an inadvertent stall/spin. A factor was the pilot's improper loading of the airplane, outside the weight and balance limitations.NTSB SEA00LA144Accident · Serious injuriesLimited investigationFinal reportEiriavion PIK 20E · Hamilton, MTThe pilot's entering an inadvertent stall condition during a high angle of bank turn (maneuvering), and the lack of adequate altitude in which to successfully recover before ground impact.NTSB NYC00LA178Accident · No injuriesLimited investigationFinal reportCianchette Lionheart · Batavia, NYThe pilot's failure to attain adequate airspeed before liftoff, which resulted in a stall/mush. A factor was the pilot's lack of experience in the type of airplane.NTSB NYC00FA209Accident · 1 fatalField investigationFinal reportCessna 210D · Ashland, VAThe failure of the pilot to maintain control of the airplane due to spatial disorientation. Factors were the dark night, low ceiling and fog.NTSB DEN00LA139Accident · No injuriesLimited investigationFinal reportFudold Avid - Magnum · Walden, COThe pilot's inadvertent stall/mush during a go-around attempt. A contributing factor was the high density altitude weather condition.NTSB MIA00LA228Accident · 1 fatalLimited investigationFinal reportQuicksilver MXL II Sport · Clyo, GAThe failure of the pilot to maintain control of the aircraft due to impairment by use of drugs, and the resultant uncontrolled descent and in-flight collision with the terrain.NTSB MIA00LA227Accident · Minor injuriesLimited investigationFinal reportBell 206A-1 · Bennettsville, SCThe pilot's failure to use proper remedial action to counteract a loss of tail rotor effectiveness resulting in collision with terrain during the subsequent uncontrolled descent.