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 DEN01LA154Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Kemmerer, WYloss of tail rotor effectiveness while hovering. A contributing factor was the wind gust.NTSB SEA01MA163Accident · 3 fatalMajor investigationFinal reportKawasaki KV-107-II · Emigrant, MTThe loss of control during cruise/climb flight for undetermined reasons.NTSB CHI01FA298Accident · 1 fatalField investigationFinal reportSpears RV-6 · Grayslake, ILThe pilot inadvertently stalled the airplane. A factor was the impairment due to marihuana.NTSB CHI01FA297Accident · 3 fatalField investigationFinal reportBeech A23 · Stevens Point, WIthe pilot not obtaining/maintaining aircraft control.NTSB LAX01LA294Accident · 1 fatalLimited investigationFinal reportHarter Kitfox Classic · Sedona, AZThe failure of the pilot to initiate a course reversal in a timely manner after flying into a box canyon and his failure to maintain airspeed during the attempted course reversal, which resulted in a stall spin.NTSB SEA01LA160Accident · Serious injuriesLimited investigationFinal reportShank Kitfox Model II · Battle Ground, WAThe pilot's failure to maintain adequate airspeed during climbout.NTSB FTW01LA198Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Miami, OKThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB FTW01TA194Accident · Minor injuriesFinal reportPiper PA-18-150 · Van Horn, TXThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor contributing to the accident was the high density altitude.NTSB NYC01FA212Accident · 1 fatalField investigationFinal reportPitts S-2B · Shirley, NYThe pilot under instruction's failure to maintain adequate airspeed, and the flight instructor's inadequate remedial action during a simulated engine-out approach, which resulted in an inadvertent stall, and subsequent ground impact.NTSB FTW01LA187Accident · Serious injuriesLimited investigationFinal reportBeech F33C · Sugarland, TXthe pilot's inadvertent stall of the airplane during the base/final approach for landing which resulted in a collision with terrain. A contributing factor was the pilot's diverted attention to an open cockpit door.NTSB ANC01LA119Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Glennallen, AKThe pilot's inadequate compensation for wind conditions during takeoff. A factor associated with the accident was a variable wind.NTSB MIA01FA223Accident · 3 fatalField investigationFinal reportBeech A23 · Blairsville, GAThe failure of the pilot to maintain airspeed resulting in an inadvertent stall an subsequent in-flight collision with trees then the ground during the uncontrolled descent.NTSB ATL01FA094Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Rienzi, MSThe pilot experienced spatial disorientation, which resulted in an in-flight loss of control and subsequent collision with trees and terrain. A factor was the dark night condition.NTSB LAX01LA283Accident · No injuriesLimited investigationFinal reportAerospatiale AS 355F1 · Vinton, CAThe pilot's selection of an unsuitable landing site, which caused "brown-out" conditions during departure liftoff and resulted in loss of control of the helicopter.NTSB NYC01LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · Newark, OHThe student pilot's failure to maintain aircraft control during an aborted landing. A factor in this accident was the crosswind conditions.NTSB LAX01LA281Accident · 2 fatalLimited investigationFinal reportJohnson Lancair 360 · Placerville, CAIn-flight loss of control for undetermined reasons.NTSB LAX01LA280Accident · Serious injuriesLimited investigationFinal reportHumphreys Stitts SA6B · Elko, NVThe failure of the pilot-in-command to reverse course in a timely manner after flying into a box canyon. Factors in the accident were the pilot's lack of familiarity with the aircraft and the local terrain.NTSB DEN01LA147Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Peyton, COThe pilot's improper go-around procedure and his failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor was the pilot's lack of total experience.NTSB LAX01FA277Accident · Minor injuriesField investigationFinal reportMD Helicopters 600N · Fountain Hills, AZthe manufacturer's pilot's failure to maintain yaw control and main rotor speed while recovering from an unusual attitude induced by the customer pilot's inadequate control inputs while maneuvering at low altitude. The manufacturer's pilot's inadequate…NTSB FTW01LA179Accident · 1 fatalLimited investigationFinal reportPdps PZL-Bielsko SZD-55-1 · Uvalde, TXthe pilot's failure to maintain aircraft control during the base turn, which resulted in an inadvertant stall/spin.NTSB NYC01LA208Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Gasport, NYThe pilot's failure to obtain a proper climb airspeed which resulted in an inadvertent stall and subsequent impact with a hangar.NTSB CHI01LA273Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Hazelton, NDthe pilot's ostentatious display when he performed a low level manuever and stalled the airplane.NTSB LAX01MA272Accident · 6 fatalMajor investigationFinal reportEurocopter AS350-B2 · Meadview, AZThe pilot’s loss of control of the helicopter for undetermined reasons.NTSB MIA01LA211Accident · Serious injuriesLimited investigationFinal reportBeech BE-200 · Sandersville, GAThe pilot-in command's failure to maintain airspeed during the approach, resulting in an inadvertent stall and in-flight collision with the terrain during an uncontrollable descent.NTSB CHI01LA272Accident · No injuriesLimited investigationFinal reportCessna 152 · Peru, ILThe pilot's inadequate recovery from a bounced landing. Factors associated with the accident were improper touchdown point, rough terrain, and the nose gear collapse.NTSB NYC01LA206Accident · Minor injuriesLimited investigationFinal reportSchweizer 300C · Cicero, NYThe pilot's failure to maintain directional control while hovering, and the CFI's delayed remedial action.NTSB NYC01FA201Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Sedgwick, METhe failure of the pilot to maintain control while maneuvering.NTSB FTW01LA172Accident · Serious injuriesLimited investigationFinal reportBell 206-L1 · Wc 173the pilot's failure to maintain yaw control of the helicopter during approach.NTSB CHI01LA258Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Crane Lake, MNThe inadvertant control interference by the passenger's knee leading to the pilot's directional control of the floatplane not being possible.NTSB LAX01LA269Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Fort Bragg, CAthe pilot's failure to maintain airspeed while making a precautionary landing resulting in an inadvertent stall.NTSB FTW01LA173Accident · No injuriesLimited investigationFinal reportCurtis-Travel Air 4000 · Morrilton, ARthe pilot's failure to maintain aircraft control during takeoff. Contributing factors were the pilot's lack of experience in the accident airplane, and the rough/uneven runway.NTSB NYC01LA198Accident · Minor injuriesLimited investigationFinal reportMoran Europa Monowheel · Oxford, CTThe pilot's failure to maintain directional control during an aborted landing.NTSB IAD01FA089Accident · 2 fatalField investigationFinal reportBell 206B · Baltimore, MDThe pilot's improper decision to maneuver in an environment conducive to a loss of tail rotor effectiveness, and his inadequate recovery from the resultant unanticipated right yaw.NTSB NYC01FA193Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Xenia, OHThe flight instructor's failure to maintain aircraft control while maneuvering, which resulted in an inadvertent spin.NTSB MIA01LA202Accident · 2 fatalLimited investigationFinal reportLancair 360 · St. Marys, GAThe flight instructor/pilot in command's continued flight into known adverse weather, which resulted in a loss of control, and uncontrolled descent, and the airplane crashing into the Atlantic Ocean.NTSB IAD01LA090Accident · No injuriesLimited investigationFinal reportSteen Skybolt · Warrenton, VAThe pilot's failure to maintain directional control during landing, and the flight instructor's delayed remedial action.NTSB DEN01FA133Accident · 1 fatalField investigationFinal reportWilson Glastar · Henefer, UTthe pilot's failure to maintain aircraft control for an undetermined reason.NTSB SEA01FA145Accident · 6 fatalField investigationFinal reportPiper PA-32-260 · Puyallup, WAThe pilot's failure to maintain adequate airspeed during departure resulting in a stall. Trees were a factor in the accident.NTSB CHI01LA250Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G102 STD Astir III · Faribault, MNThe pilot's failure to maintain adequate airspeed during the landing which resulted in a stall.NTSB CHI01FA247Accident · Minor injuriesField investigationFinal reportBeech C35 · Oshkosh, WIThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB NYC01LA190Accident · 1 fatalLimited investigationFinal reportHolsclaw Barnett J4B · Titusville, PAThe pilot's failure to maintain control while maneuvering. A factor was the pilot's lack of experience in type of gyroplane.NTSB NYC01FA189Accident · 1 fatalField investigationFinal reportPiper PA-46-350 · Westfield, MAThe pilot's failure to maintain aircraft control while maneuvering during a go-around.NTSB FTW01FA171Accident · 4 fatalField investigationFinal reportCessna 205 · De Queen, ARthe pilot's VFR flight into IMC, which resulted in spatial disorientation and a loss of aircraft control. A contributing factor to the accident was the pilot's lack of total instrument flight time.NTSB DEN01LA131Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Spanish Fork, UTthe pilot's inadequate compensation for the wind conditions which resulted in a loss of control during landing. A contributing factor was the gusty crosswind.NTSB CHI01LA254Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Wall, SDThe student pilot failed to maintain a proper glidepath, failed to obtain proper climb rate, and executed the go-around improperly. Additional factors included the pilot's lack of experience, the crop, and the soft, wet ground.NTSB CHI01FA244Accident · 1 fatalField investigationFinal reportSchuchart Stoddard HamiltonSH3 · Oshkosh, WIThe inadvertent stall/spin by the pilot.NTSB MIA01TA194Accident · Minor injuriesFinal reportBell 206B-III · Jacksonville, FLthe pilot's failure to recognize and correct for unanticipated right yaw/loss of tail rotor effectiveness (LTE) during an approach to hover at a low altitude, which resulted in a loss of control and the helicopter descending and colliding with a house and the…NTSB LAX01LA259Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Placerville, CAInadequate airspeed during climb out following an aborted landing that was precipitated by the pilot's misjudged speed/distance on final approach. Also, contributing to the accident was the pilot's inexperience in the type of operation, his failure to…NTSB CHI01LA238Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Hastings, NEAircraft control not being maintained by the pilot which resulted in the encountered settling with power flight condition during the initial climb. Factors to the accident were the reported variable winds during the takeoff and the corn crop.NTSB CHI01FA235Accident · 1 fatalField investigationFinal reportPayne Giles G-202 · Oshkosh, WIThe pilot failed to maintain aircraft control which resulted in an inadvertant stall. Factors with the accident were the pilot misjudged the approach and the pilot's lack of total experience in the Giles G-202.