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 CHI01LA151Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402B · Mount Vernon, SDthe pilot not maintaining aircraft control while maneuvering close to the ground.NTSB IAD01LA061Accident · Serious injuriesLimited investigationFinal reportStampe ET Renard SV-4 · Rhinebeck, NYThe pilot's failure to maintain climb, and his failure to maintain adequate airspeed.NTSB SEA01IA113Incident · No injuriesIncident investigationFinal reportCessna 172S · Monroe, ORA degradation of aircraft control for undetermined reasons.NTSB MIA01LA149Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Greensboro, NCthe pilot's failure to maintain airspeed during takeoff/initial climb, which resulted in an inadvertent stall, an uncontrolled descent, and collision with trees.NTSB MIA01LA147Accident · No injuriesLimited investigationFinal reportRussell Heyn Rans S-6 · Swainsboro, GAthe failure of the pilot to properly compensate for a crosswind and for gusty conditions during takeoff/initial climb, which resulted in an inflight loss of control and collision with the ground.NTSB FTW01LA134Accident · No injuriesLimited investigationFinal reportCessna 182K · Victoria, TXthe pilot's inadequate preflight inspection which resulted in an unsecured seat which slipped aft on takeoff.NTSB NYC01LA130Accident · No injuriesLimited investigationFinal reportContinental Copters Tom Cat Mark 5A · Benton, PAThe pilot's inadequate preflight inspection, which resulted in a takeoff with a hose still attached and a subsequent dynamic rollover.NTSB SEA01FA106Accident · 1 fatalField investigationFinal reportPiper PA-12 · Augusta, MTThe pilot's failure to maintain adequate airspeed after takeoff resulting in an inadvertent stall at low a altitude.NTSB LAX01FA194Accident · 3 fatalField investigationFinal reportCessna 210A · Escondido, CAthe pilot's spatial disorientation and lack of instrument flight proficiency that resulted in a loss of directional control and the airplane's subsequent in-flight collision with the ground.NTSB CHI01LA149Accident · 1 fatalLimited investigationFinal reportGeertz Zenith CH 200 · Kankakee, ILThe loss of control on initial climbout for undetermined reasons.NTSB CHI01LA147Accident · 1 fatalLimited investigationFinal reportCessna 150H · Protem, MOThe overload of the flap control cable for undetermined reasons resulting in aircraft control not being possible. The trees were a factor.NTSB FTW01FA129Accident · 1 fatalField investigationFinal reportCessna 150 · Pryor, OKthe failure of the glider pilot to maintain aircraft control and his delay in releasing the towrope. A contributing factor was the glider's worn elevator trim friction, which resulted in its disengagement.NTSB ATL01LA061Accident · No injuriesLimited investigationFinal reportConrad Menzel SA-300 Starduster · Jackson, MSThe pilot failure to maintain directional control during a crosswind landing.NTSB NYC01FA128Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Danvers, MAThe pilot's failure to maintain aircraft control. Factors in the accident were the dark night, low ceiling, reduced visibility, and the pilot's decision to attempt a visual flight rules flight in marginal weather conditions.NTSB FTW01LA125Accident · 2 fatalLimited investigationFinal reportGideon Wittman Tailwind W8 · Manvel, TXthe flight instructor's failure to maintain control of the airplane during a touch-and-go landing, for an undetermined reason.NTSB LAX01LA188Accident · No injuriesLimited investigationFinal reportWright Avid Flyer · Show Low, AZthe pilot's failure to maintain control of the airplane during a go-around, which resulted in an in-flight collision with terrain and a nose down. A contributing factor was the turbulence.NTSB LAX01LA187Accident · Minor injuriesLimited investigationFinal reportBennett Glastar · Grass Valley, CAThe pilot's failure to arrest the excessive descent rate. A contributing factor was the gusty wind conditions.NTSB FTW01LA121Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350-B2 · Houston, TXthe failure of the pilot to maintain control of the helicopter following an inadvertent deactivation of the hydraulic system, during final approach. A contributory factor was the unguarded hydraulic cut-off switch.NTSB CHI01LA138Accident · 1 fatalLimited investigationFinal reportBrault Glasair SH2F · Green Bay, WIThe pilot allowed the airspeed to get too low and inadvertently stalled the airplane.NTSB DEN01FA098Accident · 1 fatalField investigationFinal reportBeech King Air B90 · San Jon, NMthe pilot's failure to maintain aircraft control due to his incapacitation for an undetermined reason. A contributing factor was the subsequent inadvertent stall/spin to the ground.NTSB FTW01FA117Accident · 2 fatalField investigationFinal reportConvair BT-13A · Odessa, TXthe pilot's failure to maintain the minimum required airspeed for flight, which resulted in a loss of control while performing a go-around. A contributing factor to the accident was the gusty tailwind condition.NTSB LAX01LA176Accident · No injuriesLimited investigationFinal reportLeonard Walters Avid Magnum · Lake Shasta, CAA loss of control on final approach due to encountering a strong wind gust and downdraft.NTSB SEA01LA092Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Grants Pass, ORThe pilot's failure or inability to maintain proper runway alignment during landing. Factors included gusty crosswind conditions and the pilot's lack of experience in crosswind landings.NTSB ATL01FA059Accident · 1 fatalField investigationFinal reportCessna 150 G · Dunlap, TNThe pilot's failure to maintain flying speed that resulted in a stall and subsequent loss of control in flight.NTSB SEA01FA089Accident · 2 fatalField investigationFinal reportRobinson R44 · Gorst, WAAn abrupt application of the tail rotor/anti-torque pedal by an unknown pilot resulting in tail rotor contact with the tail boom. Tail rotor blades and empennage assembly separation, and trees were factors.NTSB SEA01LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Corvallis, ORThe student instructor's failure to maintain the airplane's minimum control airspeed during a practice single-engine approach, and the flight instructor's failure to direct or accomplish a timely go-around, resulting in loss of aircraft control with…NTSB CHI01LA133Accident · No injuriesLimited investigationFinal reportCessna 172M · West Chicago, ILThe inadequate compensation for the crosswind by the student pilot. Additional factors included the student pilot's lack of total flight time, the runway sign and the crosswind.NTSB CHI01FA136Accident · No injuriesField investigationFinal reportCessna 172S · Springfield, MOthe excessive touchdown airspeed by the pilot.NTSB CHI01LA131Accident · 1 fatalLimited investigationFinal reportMadsen Lancair 320 · Valparaiso, INThe pilot not maintaining aircraft control during the initial climb after takeoff and the inadvertent stall/spin. A factor to the accident was the pilot's total lack of experience in accident airplane.NTSB DEN01FA094Accident · 1 fatalField investigationFinal reportCessna 208B · Steamboat Spngs, COan inadvertent stall during an instrument approach, which resulted in a loss of control. Contributing factors were the pilot's attention being diverted by an abnormal indication, conditions conducive to airframe icing, and the pilot's lack of total experience…NTSB ANC01LA053Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Chefornak, AKThe pilot's inadvertent stall/mush during the final phase of the landing approach. A factor associated with the accident is a crosswind.NTSB NYC01LA113Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Hodgenville, KYThe pilot's failure to maintain runway alignment during landing. A factor in the accident was the pilot's lack of experience in conducting soft field landings.NTSB FTW01LA123Accident · No injuriesLimited investigationFinal reportCessna 172P · Pleasanton, TXthe student pilot's failure to maintain directional control during the landing flare/touchdown. Contributory factors were the gusty wind and the student pilot's lack of total flight experience.NTSB FTW01LA108Accident · No injuriesLimited investigationFinal reportCartercopters Cartercopter · Olney, TXthe pilot's failure to maintain directional control during the takeoff initial climb. Contributory factors were the pilot's lack of experience with the aircraft and the soft terrain.NTSB CHI01LA127Accident · No injuriesLimited investigationFinal reportCessna 172M · Eveleth, MNThe pilot's inadequate compensation for the crosswind conditions which resulted in the loss of aircraft control. Factors associated with the accident were the gusty crosswind condition, the pilot's lack of experience, and the trees which were contacted.NTSB LAX01LA141Accident · 1 fatalLimited investigationFinal reportMotley Vans RV-6A · Baker, CAThe pilot's failure to maintain an adequate airspeed while maneuvering at low altitude, which led to an inadvertent stall/spin. The wind gusts were a factor.NTSB FTW01LA114Accident · Serious injuriesLimited investigationFinal reportBoykin B J B8M · Clarksville, ARthe pilot's inadequate preflight inspection, which resulted in a loose control stick on takeoff, rendering the aircraft uncontrollable.NTSB FTW01LA106Accident · No injuriesLimited investigationFinal reportCessna 172G · N. Little Rock, ARthe pilot's delayed go-around on landing.NTSB LAX01FA152Accident · 1 fatalField investigationFinal reportCessna 310F · Carmel Valley, CAThe in-flight loss of control of the airplane in instrument meteorological conditions for undetermined reasons.NTSB NYC01FA102Accident · 1 fatalField investigationFinal reportCessna 152 · La Grange, KYThe student pilot's failure to maintain adequate airspeed while maneuvering the airplane at low altitude. A factor was the pilot's overconfidence in his abilities.NTSB IAD01LA045Accident · No injuriesLimited investigationFinal reportCessna 182N · Cedarville, NJThe pilot's failure to maintain directional control during the landing flare. A factor was the wind gusts.NTSB DEN01FA088Accident · 1 fatalField investigationFinal reportBeech 35 · Glenwood Sprgs, COthe pilot's failure to maintain aircraft control, and the subsequent inadvertent stall/mush to the ground. Contributing factors were the pilot's lack of experience in make/model airplane, the high density altitude weather condition, and the pilot's attempted…NTSB CHI01FA117Accident · 1 fatalField investigationFinal reportBeech F35 · Oshkosh, WIThe pilot's failure to maintain adequate airspeed which resulted in a stall. The low altitude was a contributing factor.NTSB MIA01LA122Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Dade City, FLthe pilot's inadequate recovery from a bounced landing, and loss of directional control which resulted in an in-flight collision with a fence during the go-around, resulting in a subsequent forced landing in a pasture.NTSB LAX01FA144Accident · 1 fatalField investigationFinal reportSchleicher ASW-20 · Williams, CAThe failure of the pilot to attach the elevator control rod to the elevator, resulting in a loss of pitch control and subsequent ground impact. Additional factors were the failure to complete a positive control check and the lack of clear guidance in the…NTSB FTW01FA100Accident · 1 fatalField investigationFinal reportFairchild PT-19A · Midland, TXthe pilot's failure to maintain airspeed which resulted in an inadvertant stall during initial takeoff climb. A contributing factor was wind gusts.NTSB NYC01LA097Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Hagerstown, MDThe pilot's failure to maintain runway alignment during the landing phase. A factor in the accident was a sudden change in wind direction and speed.NTSB MIA01TA121Accident · Minor injuriesFinal reportBell OH-58C · Panama City, FLThe poor in-flight planning by the pilot for failure to maintain adequate airspeed while maneuvering to begin spray operations resulting in the loss of tail rotor effectiveness, subsequent in flight loss of control, and in flight collision with terrain.NTSB FTW01LA097Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Roe, ARthe inadvertent stall by the pilot while maneuvering at low altitude. A contributory factor was the tailwind.NTSB DEN01FA082Accident · 2 fatalField investigationFinal reportSandell Zenith CH 200 · Canon City, COthe pilot in command inadvertently allowing the airplane to stall/spin. Contributing factors were the pilot's total lack of experience in airplane make/model, and high wind conditions.