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 NYC01LA057Accident · No injuriesLimited investigationFinal reportMooney M-20J · Trenton, NJThe flight instructor's improper decision to allow his student to land in close proximity to a hovering helicopter.NTSB CHI01FA044Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Milltown, WIThe flight instructor's inadequate supervision of the flight, the flightcrew not maintaining control of the airplane, and the flight instructor's delayed remedial action which resulted in the inadvertent spin. Factors to the accident were the inadvertent spin…NTSB NYC01LA047Accident · No injuriesLimited investigationFinal reportCessna 152 · Cross Keys, NJThe overstress separation of the control yoke from the control column.NTSB FTW01FA023Accident · 1 fatalField investigationFinal reportHall Glasair III · Gilmer, TXthe pilot's performance of aerobatic maneuvers at a low altitude and his failure to maintain aircraft control. A contributing factor was the pilot's lack of aerobatic experience.NTSB NYC01LA038Accident · No injuriesLimited investigationFinal reportCessna 172K · Hagerstown, MDThe pilot's failure to remove the gust lock from the control column before takeoff, and his failure to abort the takeoff.NTSB ATL01LA010Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Everglades City, FLThe pilot's failure to maintain control of the aircraft during landing.NTSB MIA01LA026Accident · 1 fatalLimited investigationFinal reportJ and J Tukan · Hayesville, NCThe ultralight pilot's in-flight loss of control for unknown reasons resulting in an in-flight collision with the terrain.NTSB LAX01LA038Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-36 · Lake Elsinore, CAThe pilot's misjudged altitude approaching the airstrip and his failure to maintain airspeed resulted in the glider's collision with trees.NTSB SEA01FA017Accident · 2 fatalField investigationFinal reportCessna 425 · Idaho Falls, IDThe pilot-in-command's failure to maintain adequate airspeed with an asymmetric thrust condition, resulting in a loss of aircraft control. A factor was an asymmetric engine thrust condition, which was present for undetermined reasons.NTSB LAX01FA036Accident · 2 fatalField investigationFinal reportPiper PA28-200 · Teec Nos Pos, AZIn-flight loss of control resulting in airframe structural failure. Contributing to the accident was the pilot's inadvertant visual flight into instrument meteorological conditions.NTSB MIA01LA023Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Daytona Beach, FLThe CFI's inadequate supervision of the dual student and the dual student's loss of directional control during landing.NTSB CHI01FA026Accident · 1 fatalField investigationFinal reportLuscombe 8A · Des Moines, IAThe pilot not maintaining aircraft control during the final turn, and the pilot's improper decision to fly the tight pattern to the closer runway. Factors relating to the accident were the pilot's inadequate distance/altitude in the traffic pattern and the…NTSB LAX01LA029Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Gorman, CAthe pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall. A contributing factor was the pilot's use of impairing medications.NTSB LAX01LA031Accident · No injuriesLimited investigationFinal reportCessna 182S · French Valley, CAThe pilot's failure to follow procedures and directives contained in the information manual. Contributing to the accident was the flight instructor examiner/passenger's inattention to the sequence of events.NTSB FTW01FA013Accident · 1 fatalField investigationFinal reportCessna 210 · Oklahoma City, OKthe pilot's loss of control of the aircraft during initial/takeoff climb. Contributing factors were the night conditions, low ceilings, and the pilot's lack of flight experience in actual instrument meteorological conditions at night.NTSB LAX01FA024Accident · 2 fatalField investigationFinal reportCessna 152 · Alpine, CAThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall and collision with terrain.NTSB NYC01LA019Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1A · White Plains, NYAn improperly planned approach which resulted in an inadvertent stall.NTSB MIA01LA013Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Knoxville, TNThe pilot's failure to maintain Vs during takeoff/initial climb, which resulted in an inadvertent stall/mush, an uncontrolled descent, and an impact with the ground. Factors in the accident were the pilot's improper preflightplanning/preparation and failure…NTSB LAX01LA020Accident · 1 fatalLimited investigationFinal reportRyan ST3KR · Georgetown, CAThe airplane's encounter with a strong updraft at the end of the runway that induced an increase in the wing's angle of attack to the critical point, which resulted in an inadvertent stall and spin.NTSB CHI01FA017Accident · 2 fatalField investigationFinal reportBeech 95-C55 · Homer, NEThe inadequate remedial action the flightcrew had during the stall recovery maneuver and the flight instructor's inadequate supervision. A factor was the intentional stall the flightcrew was performing.NTSB LAX01LA013Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Grand Canyon, AZThe pilot's in-flight loss of control during liftoff due to his improper planning and decisions. Related factors were the high density altitude and helicopter weight condition, and the lack of a suitable takeoff area.NTSB FTW01FA003Accident · 1 fatalField investigationFinal reportBeech B19 · Umbarger, TXThe pilot's loss of control due to spatial disorientation. Contributing factors were the low ceilings, the dark night illumination, the lack of visual cues, and the pilot's lack of instrument flight qualification or experience.NTSB CHI01MA006Accident · 2 fatalClass 1 · MajorFinal reportCanadair CL600-2B16 · Wichita, KSthe pilot’s excessive takeoff rotation, during an aft center of gravity (c.g.) takeoff, a rearward migration of fuel during acceleration and takeoff and consequent shift in the airplane’s aft c.g. to aft of the aft c.g. limit, which caused the airplane to…NTSB NYC01LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Shirley, NYThe pilot's failure to maintain directional control during an aborted landing.NTSB LAX01FA003Accident · 1 fatalField investigationFinal reportCessna 182S · Santa Rosa, CAthe pilot's loss of airplane control due to spatial disorientation. A related factor was the low ceiling.NTSB CHI01LA002Accident · 1 fatalLimited investigationFinal reportMoseler RAF 2000 GTX SE · Muskegon, MIThe main rotor contacting with the vertical stabilizer, the loss of the vertical stabilizer, and the aircraft control not possible by the pilot.NTSB NYC01FA001Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Seven Springs, PAThe pilot's improper recovery from a bounced landing.NTSB DEN00LA183Accident · 2 fatalLimited investigationFinal reportErcoupe 415-C · Tucumcari, NMloss of control during initial climb following takeoff by an unqualified person.NTSB DEN00FA182Accident · 1 fatalField investigationFinal reportSukhoi SU-26MX · Telluride, COthe pilot's failure to maintain aircraft control while maneuvering, and the subsequent inadvertent stall/spin to the ground. A contributing factor was the high density altitude weather condition.NTSB ATL00LA095Accident · 2 fatalLimited investigationFinal reportWilliam J. Knowles KNOWLES-THORP KT-18 · Opa-Locka, FLThe pilot's failure to maintain flying airspeed during initial climb, resulting in an inadvertent stall/spin.NTSB SEA00LA193Accident · No injuriesLimited investigationFinal reportHughes 269B · Laurel, MTFailure to maintain aircraft control during hover operations. Inadequate remedial action by the pilot was a factor.NTSB FTW00FA268Accident · 2 fatalField investigationFinal reportCessna 152 · Navasota, TXthe pilot's failure to maintain control of the airplane due to spatial disorientation. Contributory factors were the clouds, dark night light conditions, the pilot's lack of total instrument flight time, and the pilot's self-induced pressure to complete the…NTSB NYC00LA266Accident · Serious injuriesLimited investigationFinal reportMorrison RANS-12 · Warrenton, VAThe pilot's inadequate airspeed which resulted in the inadvertent stall. A factor related to the accident was the gusting wind condition.NTSB SEA00LA186Accident · 1 fatalLimited investigationFinal reportde Havilland DH-100 MK.6 · Ontario, ORThe pilot's failure to maintain adequate airspeed during low-altitude maneuvering flight, resulting in an accelerated stall and spin. A factor was the pilot's intentional low-altitude maneuvering flight.NTSB CHI00LA305Accident · No injuriesLimited investigationFinal reportCessna 172 · Buffalo, MOThe inadvertent stall during a go-around. Factors relating to this accident were the student pilot's improper in-flight decisions and his failure to raise the flaps during the go around.NTSB LAX00LA343Accident · Serious injuriesLimited investigationFinal reportBell 206BIII · Ojai, CAthe pilot encountered a loss of tail rotor effectiveness which led to an uncontrolled rotation and subsequent hard landing. Factors were unfavorable wind conditions, density altitude, and uneven terrain.NTSB FTW00LA266Accident · No injuriesLimited investigationFinal reportCessna 150K · New Orleans, LAThe pilot's failure to maintain control of the aircraft during an aborted landing. A factor was the crosswind.NTSB DEN00FA175Accident · 2 fatalField investigationFinal reportBeech S35 · Longmont, COThe pilot/passenger's failure to maintain aircraft control, and the pilot in command's inadequate supervision of the flight. A factor was the pilot/passenger's lack of experience in aircraft type.NTSB DEN00FA169Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Englewood, COthe pilot's failure to maintain aircraft control, which resulted in a collision with terrain. A contributing factor was the high-density altitude weather condition.NTSB ANC00LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Sleetmute, AKThe loss of aircraft control precipitated by the pilot's inadvertent stall. Factors associated with the accident are the disengagement of the stabilizer trim system, which resulted in reduced aircraft control, an inadvertent stall by the pilot, and a large…NTSB ANC00LA118Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Sparrevohn, AKThe pilot's inadvertent stall/mush during the final approach to land. Factors associated with the accident are the pilot's misjudged flare, and the rough and uneven terrain.NTSB NYC00LA258Accident · Serious injuriesLimited investigationFinal reportBeech 33-F33A · Warwick, NYThe pilot's improper decision to fully retract flaps during a go-around.NTSB MIA00FA265Accident · 2 fatalField investigationFinal reportBeech 58P · Brookhaven, MSThe poor in-flight planning/decision by the pilot for flying a close-in downwind leg, improper aircraft handling by the pilot for his executing a 70-75 degree angle of bank turning base to final while circling to land, and inadvertent stall/mush of the…NTSB CHI00LA292Accident · Minor injuriesLimited investigationFinal reportCessna 182S · Ellington, MOThe pilot's failure to maintain control of the aircraft during the aborted landing. Contributing to the accident was the rich mixture caused by an obstruction in the regulator section of the fuel servo.NTSB NYC00LA253Accident · No injuriesLimited investigationFinal reportCessna 177RG · Elmer, NJThe instructor's failure to take remedial action.NTSB IAD00LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Headwaters, VAPilot's failure to maintain aircraft control during take-off, which resulted in a stall.NTSB MIA00FA260Accident · 1 fatalField investigationFinal reportBeech B-95 · Odessa, FLthe pilot's failure to maintain Vmc, which resulted in a loss of control, and collision with the ground. Contributing to the accident was the pilot's decision to feather a propeller powered by an operational engine, while at a low altitude.NTSB NYC00FA248Accident · 3 fatalField investigationFinal reportPiper PA-32R-301 · South Kingstown, RIThe pilot's loss of control, and his subsequent overstress of the airplane after a vacuum system failure during flight in instrument meteorological conditions. Factors included the instrument meteorological conditions, a sheared coupling on the vacuum pump,…NTSB MIA00LA259Accident · No injuriesLimited investigationFinal reportEugene L. Capozzi VAN RV-6A · Bayou La Batre, ALThe pilots failure to maintain airspeed during final approach result in the aircraft stalling and descending uncontrolled until ground impact.NTSB LAX00LA323Accident · No injuriesLimited investigationFinal reportCessna 172N · North Las Vegas, NVThe failure of the pilot-in-command to maintain proper airspeed during the aborted landing go-around which resulted in a stall/mush and impact with terrain.