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 NYC03CA194Accident · Minor injuriesData collectionFinal reportunknown Avid Flyer · Covington, NYThe pilot's failure to abort the takeoff.NTSB LAX03CA279Accident · No injuriesData collectionFinal reportBell 206B · Long Beach, CAthe pilot's inadequate remedial action in response to a loss of tail rotor effectiveness.NTSB FTW03FA212Accident · 2 fatalField investigationFinal reportCessna 172L · New Braunfels, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during takeoff.NTSB NYC03LA195Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Somerville, NJThe pilot's delay in executing a go-around, which resulted in an encounter with wake turbulence from a helicopter. A factor in the accident was the wake turbulence.NTSB ANC03LA108Accident · No injuriesLimited investigationFinal reportCessna 206 · Kaktovik, AKThe pilot's failure to maintain airspeed during takeoff which resulted in a loss of control during initial climb. Factors associated with the accident were wet and muddy runway conditions, and the pilot's selection of an unsuitable takeoff area.NTSB ANC03LA107Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Koliganek, AKThe pilot's failure to maintain adequate airspeed during an aborted landing, which resulted in an inadvertent stall and subsequent collision with terrain.NTSB LAX03LA273Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · North Las Vegas, NVthe pilot's failure to maintain an adequate airspeed during approach for the airplane's flight configuration, which resulted in an inadvertent stall and impact with terrain.NTSB LAX03CA272Accident · No injuriesData collectionFinal reportCessna 182J · Marble Canyon, AZthe failure of the pilot to retract the flaps and attain a sufficient airspeed during the attempted go-around, which resulted in a stall. The full nose-up trim was a contributing factor.NTSB LAX03LA270Accident · 1 fatalLimited investigationFinal reportBeech K35 · Gerlach, NVthe pilot's failure to maintain an adequate airspeed resulting in a stall mush and collision with terrain.NTSB LAX03CA277Accident · Minor injuriesData collectionFinal reportPZL PW-5 · Yreka, CAthe pilot's inadequate in-flight planning/decision and failure to maintain airspeed resulted in an inadvertent stall. A factor in the accident was the downdraft.NTSB SEA03FA173Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Warm Lake, IDThe pilot's failure to maintain adequate airspeed during final approach resulting in a stall/spin. Contributing factors were the rapidly rising terrain and trees.NTSB NYC03MA183Accident · 2 fatalMajor investigationFinal reportBeech 1900D · Yarmouth, MAThe improper replacement of the forward elevator trim cable, and subsequent inadequate functional check of the maintenance performed, which resulted in a reversal of the elevator trim system and a loss of control in-flight. Factors were the flightcrew's…NTSB LAX03CA263Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Pauma Valley, CAthe pilot's failure to maintain an adequate airspeed, which resulted in a stall. The rising terrain was a factor.NTSB FTW03LA203Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Ozona, TXThe pilot's decision to hover out of ground effect, which resulted in a loss of tail rotor effectiveness. A contributing factor was the lack of suitable terrain.NTSB NYC03FA180Accident · 1 fatalField investigationFinal reportAero Vodochody L-39ZO · Forest Hill, MDThe pilot's in-flight decision to delay application of engine power to account for the engine's slow response to throttle input, which resulted in an inadvertent stall and subsequent collision with a residential area. A factor related to the accident was the…NTSB FTW03LA206Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · McKinney, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall during landing. A contributing factor was flaring too high.NTSB CHI03LA287Accident · No injuriesLimited investigationFinal reportStaudacher S-1000 · Newberry, MIThe pilot's inadequate compensation for the wind conditions, resulting in aircraft control not being maintained during the landing approach. Contributing factors to the accident were the gusting crosswind and the VASI system.NTSB MIA03FA167Accident · 2 fatalField investigationFinal reportPiper PA-31 · Clearwater, FLThe failure of the flightcrew to maintain airspeed (Vs) resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with the ground.NTSB ATL03LA129Accident · Serious injuriesLimited investigationFinal reportWilliam Allen MONI-1 · Timberlake, NCThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent collision with the ground.NTSB ANC03LA095Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Tyonek, AKThe pilot's failure to adequately compensate for wind conditions and maintain aircraft control during the initial climb, which resulted in a loss of control and in-flight collision with terrain. Factors associated with the accident are a crosswind and wind…NTSB SEA03LA170Accident · 1 fatalLimited investigationFinal reportAvid Magnum · Greenwater, WAThe pilot's failure to maintain aircraft control while manuevering for undetermined reasons.NTSB CHI03LA269Accident · 2 fatalLimited investigationFinal reportHolden Pulsar · Willmar, MNThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin.NTSB CHI03LA266Accident · No injuriesLimited investigationFinal reportCessna 172G · Bowdon, NDThe pilot's failure to maintain adequate airspeed which led to a stall. Contributing to the accident was the pilot's lack of experience, the crosswind condition, wind gusts and power lines.NTSB LAX03LA256Accident · No injuriesLimited investigationFinal reportCessna 150G · Angwin, CAThe pilot's failure to maintain control of the airplane during an attempted go-around, which resulted in a hard landing. Also causal was the pilot's failure to maintain directional control.NTSB LAX03FA254Accident · 1 fatalField investigationFinal reportCessna 340A · Bishop, CAthe pilot's in-flight loss of control due to a Somatogravic illusion and/or spatial disorientation. Factors in the accident were the dark lighting conditions and the pilot's lack of familiarity with the airplane.NTSB ANC03FA094Accident · 3 fatalField investigationFinal reportBeech V35-B · Skagway, AKThe pilot's failure to maintain adequate airspeed and subsequent inadvertent stall, which resulted in a collision with trees during takeoff-initial climb. Factors contributing to the accident were terrain features consisting of a ravine and rising terrain on…NTSB CHI03FA251Accident · 1 fatalField investigationFinal reportCessna 182G · Topeka, KSThe pilot's failure to maintain adequate airspeed resulting in a stall during takeoff. Contributing factors were the low altitude he was at during the takeoff, and the trees.NTSB ANC03LA092Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Healy, AKThe pilot's inadequate compensation for wind conditions and failure to maintain aircraft control after encountering wind gusts during the landing flare/touchdown which resulted in an in-flight collision with trees and subsequent nose over. A factor…NTSB NYC03FA173Accident · 2 fatalField investigationFinal reportLearjet 35A · Groton, CTThe first officer's inadvertent retraction of the flaps during the low altitude maneuvering, which resulted in the inadvertent stall and subsequent in-flight collision with a residential home. Factors in the accident were the captain's decision to perform a…NTSB CHI03FA239Accident · No injuriesField investigationFinal reportGerlach Skyraider II · Oshkosh, WIThe pilot's failure to abort the takeoff, his improper use of flaps during the takeoff, and his failure to attain sufficient airspeed resulting in an inadvertent stall and subsequent impact with a road.NTSB LAX03LA251Accident · Serious injuriesLimited investigationFinal reportBeech 77 · French Valley, CAThe pilot's attempted low altitude flight maneuver during a go-around, which resulted in his loss of control of the airplane and subsequent in-flight collision with terrain.NTSB NYC03CA170Accident · No injuriesData collectionFinal reportBell 47G-2A · Jackson, NJPilot's inadequate preflight inspection and failure to remove a pesticide spraying hose from the helicopter prior to takeoff, which resulted in a loss of control.NTSB LAX03LA245Accident · Minor injuriesLimited investigationFinal reportHogarty Lancair IV P · North Las Vegas, NVThe pilot's premature lift-off before airspeed was attained resulting in a stall. A factor associated with the accident was a high density altitude.NTSB LAX03GA244Accident · 2 fatalFinal reportBell 206L-3 · Whiteriver, AZThe pilot's failure to maintain a minimum translational lift airspeed while maneuvering in high density altitude conditions at near maximum required torque and above the in ground effect hover altitude, that resulted in a loss of tail rotor effectiveness and…NTSB DEN03FA136Accident · 4 fatalField investigationFinal reportMooney M20C · Blanding, UTthe pilot's failure to maintain airspeed which resulted in a stall/spin.NTSB CHI03LA228Accident · Minor injuriesLimited investigationFinal reportFerence Varieze · Macomb, MIThe pilot's failure to secure the window canopy before takeoff and his failure to maintain directional control which resulted in a loss of control. The pilot's diverted attention is a contributing factor.NTSB SEA03FA148Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Tulalip, WAA loss of control for unknown reasons.NTSB LAX03LA239Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Hamilton City, CAThe pilot's failure to maintain adequate airspeed to avert stalling during a low altitude turn.NTSB SEA03CA144Accident · Minor injuriesData collectionFinal reportWSK PZL Mielec PZL-M-18 · Burley, IDThe pilot's failure to remove the elevator gust lock prior to flight. Factors include the pilot's inadequate preflight.NTSB LAX03LA237Accident · 1 fatalLimited investigationFinal reportThompson Quickie Q2 · Tehachapi, CAThe pilot's inadvertent entry into a pilot induced oscillation and failure to maintain airplane control during the takeoff initial climb. A contributing factor was the pilot's likely impairment by an over-the-counter drug substance that degraded his physical…NTSB DEN03FA133Accident · 3 fatalField investigationFinal reportGrumman American AA-5B · Steamboat Sprng, COThe pilot's failure to maintain terrain clearance. Contributing factors include the pilot's inadequate preflight planning/preparation, high density altitude, and mountainous conditions.NTSB CHI03LA216Accident · 1 fatalLimited investigationFinal reportCessna 172H · Isle, MNThe pilot's failure to maintain adequate airspeed which resulted in a stall. The trees, high density altitude, and the soft field were additional factors.NTSB SEA03LA140Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A · Zurich, MTThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB NYC03LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Gaithersburg, MDThe student pilot's failure to maintain directional control during an aborted landing.NTSB SEA03LA134Accident · No injuriesLimited investigationFinal reportArcher S-18T · Arlington, WAThe pilot's failure to maintain an airspeed above Vs (stalling speed) while making a close-in base-to-final turn.NTSB ANC03FA075Accident · 1 fatalField investigationFinal reportCessna 206 · English Bay, AKThe pilot's failure to maintain adequate airspeed during an aborted landing, resulting in an inadvertent stall and subsequent collision with water. Factors were the high velocity crosswind conditions, the pilot's inadequate compensation for the wind…NTSB SEA03LA132Accident · Serious injuriesLimited investigationFinal reportHanks Avid Flyer · Toledo, WAThe pilot's failure to maintain aircraft control during a simulated emergency descent. Inadequate remedial action was a factor.NTSB DEN03LA129Accident · Minor injuriesLimited investigationFinal reportDavis Zenair Stol 701 · Aurora, COthe pilot's failure to attain adequate airspeed and establish a climb resulting in a stall/mush and collision with the ground. Contributing factors were his premature turn onto the downwind leg, and the plowed/furrowed terrain.NTSB DEN03LA124Accident · No injuriesLimited investigationFinal reportPZL Wilga 104-80 · Santa Fe, NMthe pilot's failure to maintain airspeed which resulted in a stall.NTSB CHI03FA202Accident · 1 fatalField investigationFinal reportCessna 150L · Schaumburg, ILThe pilot not maintaining airplane control and the inadvertent stall he encountered during initial climb.