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 SEA04FA133Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Ontario, ORThe pilot's failure to maintain airspeed resulting in an aerodynamic stall while maneuvering for an approach to land.NTSB SEA04CA132Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Waitsburg, WAThe pilot's failure to maintain aircraft control and his inadequate compensation for the wind conditions during the landing. Gusts and high vegetation were factors.NTSB LAX04LA261Accident · No injuriesLimited investigationFinal reportEurocopter France AS350 B2 · Peach Springs, AZThe pilot's selection of downwind takeoff direction and improper use of the collective control prior to reaching translational lift, which resulted in a settling with power condition and a collision with the ground. Also causal was the pilot's failure to…NTSB LAX04LA259Accident · No injuriesLimited investigationFinal reportNorth American T28B · Apple Valley, CAThe pilot's failure to maintain an adequate airspeed during the conclusion of a low pass, which led to a stall/mush.NTSB ANC04LA075Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Talkeetna, AKThe pilot's inadequate compensation for the wind conditions during cruise flight, which resulted in the airplane impacting the lake. A factor associated with the accident was a downdraft, and low altitude flight.NTSB DEN04CA102Accident · Minor injuriesData collectionFinal reportMooney M20S · Farmington, NMthe pilot's failure to maintain airspeed resulting in a stall. A contributing factor was the pilot's diverted attention.NTSB NYC04LA162Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Norfolk, VAThe pilot's failure to complete an autorotation due to the restrictive movement of the collective control.NTSB CHI04FA177Accident · 1 fatalField investigationFinal reportRobinson R-22 Beta · Rochester, MNThe loss of control due to the student pilot's failure to maintain rotor RPM and the flight instructor's inadequate supervision.NTSB SEA04LA124Accident · No injuriesLimited investigationFinal reportMooney M20R · Hailey, IDThe pilot's improper flare, failure to maintain directional control, and inadequate remedial action, which resulted in the airplane impacting a taxiway sign along the side of the runway. A factor contributing to the accident was the taxiway sign.NTSB SEA04CA122Accident · Minor injuriesData collectionFinal reportRobinson R22 Mariner · Hillsboro, ORThe pilot's failure to maintain aircraft control resulting in an uncontrolled descent and subsequent roll over. Low altitude flight and the pilot's encounter with settling with power were contributing factors.NTSB FTW04LA174Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1 · Gordonville, TXThe pilot's premature lift-off and his failure to abort the takeoff. Contributing factors were the soft and muddy runway conditions and the unfavorable winds.NTSB DEN04CA097Accident · No injuriesData collectionFinal reportCessna 172E · La Junta, COthe student pilot's failure to maintain aircraft control and adequate airspeed during the go-around resulting in an inadvertent stall. Contributing to the accident was the low airspeed and altitude.NTSB LAX04LA254Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350-B2 · Scottsdale, AZInadvertent in-flight engagement of the collective down lock, which resulted in an uncontrolled descent and ground impact. The collective down lock engagement was caused by the improper installation and/or adjustment of the collective locking system, which…NTSB CHI04CA168Accident · No injuriesData collectionFinal reportPeck Vans RV-4 · Palmyra, WIThe pilot's failure to maintain proper airspeed resulting in the inadvertent stall during the go-around. The overload failure of the left main landing gear was a contributing factor.NTSB SEA04LA119Accident · 2 fatalLimited investigationFinal reportApco Powered Parachute · Wolf Point, MTThe pilot's loss of control as a result of trying a low altitude quick turning maneuver. A factor was the pilot's lack of experience in the aircraft.NTSB LAX04CA252Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Casa Grande, AZthe pilot misjudged the flare resulting in a bounced landing. Also causal was the pilot's inadequate recovery from the bounced landing resulting in a loss of directional control.NTSB IAD04CA026Accident · Minor injuriesData collectionFinal reportLake LA-250 · Deep River, CTThe pilot's improper recovery from a bounced water landing.NTSB NYC04CA146Accident · No injuriesData collectionFinal reportCessna 172P · Springfield, OHThe pilot's failure to maintain adequate airspeed resulting in a stall and hard landing.NTSB DEN04LA093Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Heber City, UTthe pilot's failure to maintain aircraft control during the aborted landing. Contributing factors were the pilot's failure to maintain runway alignment, the fence, and the ditch.NTSB CHI04CA169Accident · Minor injuriesData collectionFinal reportBellanca 8GCBC · Mankato, MNThe pilot's improper decision to initiate the flight given the crosswind wind condition. Additional causes were the pilot's inadequate compensation for the crosswind and his subsequent failure to maintain aircraft control. The crosswind and the runway light…NTSB CHI04CA163Accident · No injuriesData collectionFinal reportGrumman G-164A · Hutchinson, MNThe pilot's failure to maintain airspeed during the low altitude turn after takeoff. A factor to the accident was the low altitude and the swampy terrain condition.NTSB ATL04TA137Accident · No injuriesFinal reportBell 206B · Graysville, ALThe pilot's inadequate compensation for a tailwind and his failure to maintain directional control resulting in a loss of tail rotor effectiveness. A factor was the pilot's improper in-flight decision to hover with a tailwind.NTSB SEA04CA116Accident · No injuriesData collectionFinal reportChampion 7GCB · Florence, ORPilot's improper touchdown point during landing. A sand mound was a factor in the accident.NTSB ATL04CA135Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Gulf Shores, ALThe pilot's failure to maintain airspeed that resulted in a stall and the subsequent collision with the ground.NTSB SEA04LA110Accident · 1 fatalLimited investigationFinal reportQuicksilver MXL · Mountain Home, IDThe pilot's failure to maintain aircraft control during an undetermined in-flight operational phase resulting in an uncontrolled descent into the terrain. Factors include strong gusty winds in the area of the accident.NTSB LAX04GA243Accident · 1 fatalFinal reportWSK PZL Mielec M-18A · St. George, UTThe pilot's failure to maintain an adequate airspeed margin, resulting in a stall and loss of control.NTSB LAX04FA241Accident · 1 fatalField investigationFinal reportCessna 337 · Carson City, NVthe pilot's failure to maintain an adequate airspeed while maneuvering during a go-around that led to an inadvertent stall spin.NTSB CHI04CA140Accident · No injuriesData collectionFinal reportCessna 150H · Mount Pleasant, MIThe pilot's improper decision to takeoff downwind from the rough field and his failure to maintain aircraft control. A factor to the accident was the rough/uneven alfalfa field and the tailwind experienced during the takeoff.NTSB MIA04LA096Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Williston, FLThe pilot's failure to maintain airspeed (Vso) while maneuvering, which resulted in a stall/mush, an uncontrolled descent, and impact with terrain.NTSB LAX04LA240Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Peoria, AZthe pilot's failure to maintain a proper pitch attitude during tow operations and his failure to maintain an adequate airspeed, which resulted in an inadvertent stall/spin.NTSB DEN04LA089Accident · 1 fatalLimited investigationFinal reportHispano Aviacion HA-200 · Pueblo, COThe pilot's failure to maintain adequate airspeed resulting in an accelerated stall at an altitude too low for recovery. A factor was the pilot's lack of experience in the aircraft make and model.NTSB ATL04FA130Accident · 2 fatalField investigationFinal reportCessna 172F · Madisonville, TNThe pilot's failure to maintain airspeed while maneuvering on a touch and go landing resulting in a stall and collision with the ground.NTSB CHI04CA154Accident · Serious injuriesData collectionFinal reportMooney M20C · Golden, MOThe pilot's failure to maintain directional control and his failure to maintain clearance from the trees. The trees were a contributing factor.NTSB FTW04LA153Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402 · Tucker, ARThe pilot's failure to maintain control while manuevering during aerial application which resulted in impact with terrain.NTSB LAX04CA233Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Brentwood, CAthe student's improper use of the cyclic control, the flight instructor's inadequate supervision, and his delayed remedial action. A factor in the accident was the CFI's diverted attention.NTSB FTW04LA149Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Benton, ARThe student pilot's failure to maintain airspeed resulting in an inadvertent stall during a go-around.NTSB CHI04CA136Accident · No injuriesData collectionFinal reportCessna 172P · Milwaukee, WIThe CFI failed to maintain adequate airspeed during the go-around which resulted in an inadvertent stall.NTSB NYC04FA137Accident · 1 fatalField investigationFinal reportCessna 182C · Kutztown, PAThe towplane pilot's failure to maintain a climb while towing a glider for undetermined reasons, which resulted in the early release of the glider and the tow plane's subsequent impact with trees.NTSB CHI04CA132Accident · No injuriesData collectionFinal reportCessna 150 · Midland, MIThe student pilot failed to maintain control of the airplane during the go-around. A factor associated with the accident was the student's lack of experience.NTSB LAX04FA223Accident · 2 fatalField investigationFinal reportBoeing B75N1 · Mesa, AZthe pilot's failure to maintain an adequate airspeed while performing aerobatics that resulted in an inadvertent stall and spin.NTSB NYC04CA134Accident · Serious injuriesData collectionFinal reportCessna 172M · Worcester, MAThe pilot's improper recovery from a bounced landing, and his inadequate compensation for wind conditions. A factor in the accident was the gusting wind.NTSB FTW04FA144Accident · 2 fatalField investigationFinal reportAviat A-1 · Harwood, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during takeoff.NTSB CHI04LA131Accident · 1 fatalLimited investigationFinal reportZorn EAA Sport Bi-Plane · Mazon, ILThe pilot's failure to maintain airspeed while maneuvering which resulted in a stall. A factor associated with the accident was the pilot's unfamiliarity with the handling characteristics of the airplane.NTSB NYC04LA133Accident · Serious injuriesLimited investigationFinal reportMosher Avid Heavy Hauler · Fitchburg, MAThe malfunction of the elevator control system, resulting in a forced landing.NTSB DEN04LA081Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Peyton, COthe pilot's inadequate in-flight planning and decision making and his failure to maintain aircraft control during the landing flare which resulted in impact with terrain. Contributing factors include the pilot's failure to perform a go-around and the wind…NTSB DEN04FA078Accident · 1 fatalField investigationFinal reportAir Borne Windsports Pty. Edge Wing X · Carter, WYThe non-certificated pilot's failure to maintain adequate airspeed resulting in a stall. Factors contributing to the accident include the non-certificated pilot's improper judgment and the his lack of experience.NTSB FTW04LA138Accident · No injuriesLimited investigationFinal reportCessna 172 · Decatur, TXThe student pilot's failure to follow the flight instructor's instructions and relinquish the controls, and the flight instructor's delay in initiating a go-around.NTSB SEA04LA090Accident · No injuriesLimited investigationFinal reportBell 206B · Auburn, WALoss of control for undetermined reasons.NTSB IAD04LA022Accident · 1 fatalLimited investigationFinal reportMasak Scimitar · Alexandria, PAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A factor was the turbulent wind conditions.NTSB MIA04FA086Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Venice, FLFailure of the pilot to recover from an improper landing flare resulting in his failure to maintain airspeed (Vs), an inadvertant stall, loss of control, and inflight collision with terrain during an uncontrolled descent.