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 ANC98FA145Accident · 5 fatalField investigationFinal reportde Havilland DHC-2 · Port Alsworth, AKThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Factors associated with this accident were the pilot's unfamiliarity with the geographic area, the low clouds, his becoming disoriented, and the blind canyon into which…NTSB SEA98LA175Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Stanley, IDThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB NYC98LA183Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Chatham, MAthe failure of the pilot to maintain airspeed during a go-around and which resulted in an inadvertent stall. Factors in the accident were the pilot's lack of total experience and the gusting crosswinds.NTSB NYC98LA181Accident · No injuriesLimited investigationFinal reportCessna 305A · Louisville, KYThe pilot's improper inflight decision, and his failure to maintain adequate airspeed which resulted in a stall.NTSB NYC98LA175Accident · Minor injuriesLimited investigationFinal reportStubler Taylor Titch · Lock Haven, PAThe pilot's failure to maintain control of the airplane. A factor in the accident was the pilot's decision to use his left hand to actuate the flap handle located on the right side of the cockpit, while on final and over the runway.NTSB FTW98LA414Accident · No injuriesLimited investigationFinal reportPitts S-2B · Sherman, TXThe failure of the pilot in command to maintain directional control of the airplane during the landing flare. A factor was the gusty, crosswind condition.NTSB IAD98LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Dayton, OHthe pilot's inadequate recovery from a bounced landing.NTSB CHI98LA346Accident · No injuriesLimited investigationFinal reportNeedham Glastar · Allison, IAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB IAD98FA103Accident · 2 fatalField investigationFinal reportBeech T-34B · Quantico, VAThe failure of the flight instructor to maintain airspeed which resulted in an inadvertent stall/spin.NTSB FTW98FA378Accident · 2 fatalField investigationFinal reportMooney M20F · Fort Collins, COThe pilot's inadvertent stall/mush due to his excessive angle of bank during his traffic pattern turn to base. Factors were the pilot's improper downwind altitude, the pilot not properly setting his Kollsman Window in his altimeter, and the high density…NTSB ANC98LA129Accident · Minor injuriesLimited investigationFinal reportDrake Kitfox III · Aniak, AKThe pilot's inadequate in-flight planning/decision, and an inadvertent stall. Factors in the accident were the pilot/owner's improper installation and pitch setting of the propeller assembly, and a tailwind.NTSB FTW98FA372Accident · 3 fatalField investigationFinal reportCessna 175A · Erie, COThe pilot's failure to maintain flying speed (above stall speed) and the subsequent stall/spin. Contributing factors were the tailwind, high density altitude, and aircraft overweight conditions.NTSB IAD98FA097Accident · 1 fatalField investigationFinal reportCessna 182N · Painesville, OHThe pilot's failure to maintain adequate airspeed, while maneuvering back toward the runway resulting in an inadvertent stall. Also causal was the pilot's inadequate preflight inspection which resulted in his failure to secure the oil filler cap. A…NTSB FTW98FA365Accident · 1 fatalField investigationFinal reportCessna 150F · Wilton, ARThe pilot's failure to maintain minimum required airspeed for flight, which resulted in an inadvertent stall. Factors were the pilot's improper use of flaps during the takeoff climb and the high density altitude.NTSB NYC98LA170Accident · 1 fatalLimited investigationFinal reportKite Kitfox IV 1200 · Granby, NYThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB LAX98LA271Accident · Minor injuriesLimited investigationFinal reportClark Barnett J4B2 · Marysville, CAThe pilot's inadequate rigging of the rotor blades and rudder, which led to an inability to maintain control of the gryocopter. The pilot's inadequate landing flare in soft terrain, which resulted in a nose low touchdown and subsequent nose over, and, his…NTSB FTW98LA363Accident · Serious injuriesLimited investigationFinal reportAero Commander S2R · Beeville, TXThe pilot's failure to maintain aircraft control and the ensuing inadvertent stall.NTSB FTW98LA371Accident · No injuriesLimited investigationFinal reportBell 47G · Monette, ARThe pilot's failure to maintain control. A factor was his lack of total flight experience in helicopters.NTSB CHI98LA317Accident · No injuriesLimited investigationFinal reportBeech C23 · North Platte, NEthe pilot's not compensating for wind conditions and failure to maintain control of the aircraft. A factor was the crosswind.NTSB IAD98FA094Accident · 1 fatalField investigationFinal reportBeech A-36 · Amelia, OHthe pilot's loss of control in flight due to spatial disorientation. A related factor was the fog.NTSB FTW98LA390Accident · No injuriesLimited investigationFinal reportBeech E35 · Fort Worth, TXThe pilot's failure to maintain aircraft control during takeoff initial climb. A factor was the pilot lifting off the aircraft prematurely.NTSB CHI98LA311Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Decatur, INthe pilot's failure to maintain adequate airspeed during the takeoff and his premature raising of the flaps which resulted in the stall/mush condition.NTSB CHI98LA320Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Lac Du Flambeau, WIthe pilot's failure to maintain adequate airspeed and the subsequent inadvertant stall.NTSB CHI98LA305Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Edgeley, NDThe pilot's failure to maintain flying airspeed resulting in a stall/mush condition during the initial climb. Contributing factors were the high density altitude, high aircraft weight, and pilot's delayed jettison of the load, as well as the roadway and crop.NTSB FTW98LA356Accident · No injuriesLimited investigationFinal reportHughes 269B · Uvalde, TXThe pilot's failure to maintain control during a vertical, out of ground effect takeoff which resulted in a hard emergency landing. Factors were; the exceeded hover performance of the helicopter, the high density altitude, and the lack of suitable terrain for…NTSB FTW98FA344Accident · 4 fatalField investigationFinal reportCessna T210N · Creede, COThe pilot's failure to maintain flying airspeed and the subsequent stall/spin. A contributing factor was high density altitude.NTSB MIA98FA219Accident · 4 fatalField investigationFinal reportSocata TBM-700 · Spearfish, SDThe pilot's failure to maintain control of the airplane while turning to base leg. Contributing factors were low ceilings, clouds, and the pilot's failure to adhere to both the published approach procedures and the published minimum decent altitude.NTSB CHI98FA299Accident · 2 fatalField investigationFinal reportCessna 140 · St. Joseph, MOthe pilot not maintaining a proper final approach glide path to avoid an encounter with wake turbulence. A factor in this accident was the pilot not being able to control the airplane after its encounter with wake turbulence.NTSB NYC98FA161Accident · 2 fatalField investigationFinal reportCessna 150M · Worthington, MAThe pilot's failure to maintain airspeed due to diverted attention.NTSB CHI98FA296Accident · 1 fatalField investigationFinal reportCessna 340A · Chicago, ILthe pilot's improper use of the throttle in not using full power for takeoff, the pilot's failure to use proper aborted takeoff procedures, and the inadvertant stall/mush. A factor associated with the accident was inadequate preflight/planning by the pilot.NTSB FTW98FA340Accident · 1 fatalField investigationFinal reportPiper J3C-85 · Seminole, TXThe pilot's failure to maintain aircraft control.NTSB MIA98LA214Accident · No injuriesLimited investigationFinal reportBell 47-D1 · Monticello, MSthe pilot's failure to maintain control of the helicopter while maneuvering resulting in the main rotor blades striking the ground.NTSB MIA98LA210Accident · Serious injuriesLimited investigationFinal reportProgressive Aerodyne Searey · Clermont, FLThe pilot's failure to maintain directional control and his failure to maintain obstacle (hangar)clearance.NTSB LAX98LA245Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Torrance, CAThe failure of the pilot to maintain an adequate airspeed margin during the go-around attempt, which resulted in a stall/mush.NTSB ANC98FA110Accident · 2 fatalField investigationFinal reportYakovlev YAK-54 · Anchorage, AKThe pilot's inadequate remedial action to recover from an inverted spin, while performing aerobatics. Contributing factors were the lower than recommended entry altitude for a spin and the pilot's lack of familiarity with the accident airplane.NTSB FTW98FA333Accident · 4 fatalField investigationFinal reportCessna 182P · Jal, NMThe pilot's failure to maintain adequate airspeed. Contributing factors were high density altitude and excessive airplane weight.NTSB SEA98LA147Accident · Minor injuriesLimited investigationFinal reportPilgrim Steen Skybolt · Curtis, WALoss of control for undetermined reasons.NTSB FTW98TA328Accident · Minor injuriesFinal reportBell 206L-3 · Reklaw, TXThe pilot's failure to maintain proper alignment in that the external load was not centered during sling operation, which resulted in entanglement of the load with the landing gear, and the loss of aircraft control.NTSB FTW98LA318Accident · No injuriesLimited investigationFinal reportCessna 172H · Commerce, TXThe pilot's inadequate compensation for the crosswind resulting in a loss of control. A factor was the crosswind.NTSB CHI98LA277Accident · Serious injuriesLimited investigationFinal reportMarchetti Avenger Gryo Plane · Mentone, INthe pilot's lack of familiarity with the gyroplane's performance, and his improper in-flight decision to reduce engine power to idle which aggravated the gyroplane's nose down pitch and exceeded the gyroplane's back stick authority.NTSB CHI98LA265Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Ironwood, MIthe pilot's not compensating for wind conditions and his allowing an inadvertent stall. A factor was wind gusts.NTSB SEA98LA145Accident · 1 fatalLimited investigationFinal reportBaggarley Glasair II-FT · Vernonia, ORA loss of aircraft control for undetermined reasons.NTSB IAD98LA082Accident · Minor injuriesLimited investigationFinal reportMiehl Team HI-MAX-1700R · Jamestown, NYthe pilot's failure to obtain proper airspeed and his subsequent loss of directional control.NTSB FTW98FA316Accident · 1 fatalField investigationFinal reportNord Stampe SV4C · Ovilla, TXthe pilot's failure to maintain control of the aircraft while performing aerobatic maneuvers.NTSB NYC98LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Rockland, METhe pilot's failure to attain adequate airspeed during the takeoff, which resulted in a stall.NTSB LAX98LA239Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe failure of the pilot to maintain directional control of the aircraft during takeoff.NTSB IAD98LA080Accident · No injuriesLimited investigationFinal reportAeronca 7FC · Somesville, METhe pilot's inadequate planning and decision, which fail to consider the effect of takeoff in the direction of the sunlight, which resulted in the pilot encountering sunglare and the loss of aircraft control.NTSB NYC98LA151Accident · No injuriesLimited investigationFinal reportCessna A185F · Moneta, VAThe pilot's failure to maintain airspeed which resulted in a stall and subsequent collision with water.NTSB NYC98LA145Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Chateaugay, NYBinding in the control yoke for undetermined reasons.NTSB NYC98LA144Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Madison, CTWas the failure of the pilot to maintain directional control of the airplane during an aborted landing. A factor was the winds which were variable and gusty.