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 DFW06CA003Accident · No injuriesData collectionFinal reportHarms KitFox Series 5 · La Porte, TXThe pilot's failure to obtain/maintain adequate airspeed on takeoff, which resulted in two hard landings and subsequent loss of control.NTSB CHI06CA001Accident · No injuriesData collectionFinal reportPyramid Aventura II · Lake City, MIThe pilot's failure to obtain or maintain airspeed which resulted in the encountered stall/mush. An additional cause was the pilot's failure to maintain clearance from trees during his precautionary landing. The trees were a factor.NTSB ATL06CA002Accident · Serious injuriesData collectionFinal reportPiper PA-28-181 · Pageland, SCThe pilots failure to maintain flying speed during the go-around, which resulted in a stall and the subsequent collision with trees.NTSB MIA06LA001Accident · Serious injuriesLimited investigationFinal reportPilatus PC-6/B2-H2 · Deland, FLThe pilot's incorrect setting of the stabilizer trim and his failure to maintain adequate airspeed during takeoff initial climb, which resulted in a stall. A factor contributing to the accident was an inadvertent stall. A factor contributing to the severity…NTSB DFW06CA001Accident · No injuriesData collectionFinal reportCessna 195 · Addison, TXThe pilot's failure to maintain directional control while landing. A contributing factor was the wind gusts.NTSB DFW05FA251Accident · 2 fatalField investigationFinal reportCessna 150M · Crystal Springs, MSThe pilot's failure to retract the flaps during the go-around and his failure to maintain airspeed, which resulted in an inadvertent stall. A contributing factor was the dark night conditions.NTSB SEA05MA202Accident · 3 fatalMajor investigationFinal reportAgusta A109A II · Edmonds, WALoss of control for an undetermined reason during maneuvering flight, which resulted in an in-flight collision with water.NTSB CHI05LA276Accident · 1 fatalLimited investigationFinal reportStits Playboy SA3B Lightning · Kimball, NEThe inadvertent stall and low airspeed by the pilot following takeoff. Contributing factors were the low altitude at the time of occurrence, the high density altitude, and the propeller.NTSB SEA05FA201Accident · 2 fatalField investigationFinal reportCessna P210N · Salmon, IDThe pilot's failure to obtain airspeed during the initial takeoff climb, which resulted in a stall/mush and subsequent collision with terrain.NTSB MIA05CA163Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Opa Locka, FLThe pilot's failure to maintain airspeed, during a banner pick up, resulting in a stall/mush and collision with terrain during the uncontrolled descent.NTSB IAD05CA148Accident · No injuriesData collectionFinal reportSchweizer SGS-2-33A · Windsor, VAThe solo student pilot's loss of control during landing.NTSB IAD05LA142Accident · 2 fatalLimited investigationFinal reportAir Creation Clipper 912 · Millstone, NJThe pilot's failure to maintain control of the airplane, which resulted in an uncontrolled descent and impact with trees.NTSB NYC05CA146Accident · No injuriesData collectionFinal reportCessna 172P · Mitchellville, MDThe pilot's failure to maintain directional control during landing.NTSB LAX05LA315Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Fall River Mill, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain runway alignment during landing.NTSB ANC05LA149Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Wasilla, AKThe pilot's failure to maintain adequate airspeed while maneuvering over wildlife, which resulted in an uncontrolled descent and subsequent collision with trees. A factor contributing to the accident was an inadvertent stall.NTSB DFW05CA250Accident · No injuriesData collectionFinal reportRobinson R44 · Batesville, TXThe pilot's failure to maintain rotor rpm and his subsequent encounter with settling with power.NTSB DEN05CA145Accident · No injuriesData collectionFinal reportCessna 172S · Cedar City, UTthe student pilot's failure to maintain aircraft control during the landing. Factors contributing to the accident were the improper flare and improper recovery from a bounced landing.NTSB LAX05LA305Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Bisbee, AZthe pilot's failure to lean the mixture in accordance with the pilot operating handbook specified procedures, which resulted in a power deficiency, a degraded climb capability, and the inability to attain/maintain an adequate airspeed that led to a stall/mush…NTSB SEA05LA196Accident · No injuriesLimited investigationFinal reportCessna 152 · Olympia, WAThe pilot's loss of aircraft control during landing roll, and airplane's subsequent inadvertent ground loop.NTSB DEN05LA141Accident · 2 fatalLimited investigationFinal reportDenight 100D2 · Hudson, COthe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin.NTSB NYC05LA142Accident · No injuriesLimited investigationFinal reportRaytheon BE-390 · Rockland, METhe pilot's failure to maintain aircraft control during landing.NTSB DFW05FA240Accident · 3 fatalField investigationFinal reportCessna 175B · Cleveland, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall/spin. A contributing factor was the low altitude.NTSB CHI05CA271Accident · No injuriesData collectionFinal reportBell 206B · Elk Point, SDThe loss of directional control for undetermined reasons which led to the pilot not being able to maintain clearance from the embankment during the forced landing. The rising embankment was a factor.NTSB ANC05FA144Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Nenana, AKThe pilot's failure to maintain minimum airspeed to avoid a stall while maneuvering, which resulted in a loss of control, a stall/spin, and impact with terrain. Factors associated with the accident were an aerobatic maneuver, and a stall/spin.NTSB IAD05LA138Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Rangeley, MEA malfunction of the yaw damper system due to fluid contamination. Factors in the accident were the air condition exhaust vent design and the design stress limits of the airplane were exceeded.NTSB LAX05CA295Accident · Minor injuriesData collectionFinal reportRicardo Lopez RAF 2000 Gtxse · Wickenburg, AZthe pilot's failure to obtain and maintain an adequate airspeed and rotor speed during takeoff.NTSB NYC05LA141Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Marstons Mills, MAThe pilot's failure to attain a climb during takeoff which resulted in a diminished climb rate and subsequent collision with trees. Factors were the turf runway and a tailwind.NTSB IAD05CA134Accident · Serious injuriesData collectionFinal reportLamont Aventura II · Hope, METhe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin and subsequent impact with water. A factor to the accident was the wind gusts.NTSB DEN05CA138Accident · No injuriesData collectionFinal reportRobinson R44 II · Jackson, WYthe pilot's failure to maintain aircraft control during initial takeoff climb resulting in an uncontrolled descent and impact with terrain. A contributing factor was the pilot's encounter in settling with power.NTSB DEN05CA136Accident · Minor injuriesData collectionFinal reportCessna T207A · Telluride, COthe pilot's improper in-flight planning/decision and failure to maintain aircraft control. Contributing factors were the pilot's failure to maintain airspeed which resulted in an inadvertent stall, and the rising terrain and encounter with downdrafts.NTSB CHI05LA261Accident · 1 fatalLimited investigationFinal reportPiper PA-28-235 · Faulkton, SDThe pilot's failure to maintain control of the airplane due to spatial disorientation during initial climb after takeoff into night instrument meteorological conditions. Factors were the fog and the dark night.NTSB LAX05FA290Accident · 2 fatalField investigationFinal reportCessna 172RG · Avalon, CAan in-flight loss of control for undetermined reasons.NTSB DFW05LA239Accident · Minor injuriesLimited investigationFinal reportBell 206B · New Orleans, LAThe pilot's failure to maintain directional control after encountering a loss of tail rotor effectiveness. A contributing factor was the lack of suitable terrain.NTSB DEN05CA135Accident · Minor injuriesData collectionFinal reportAviat A-1B · Sheridan, WYpilot's failure to maintain aircraft control during the aborted landing. A contributing factor was the pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB ANC05CA139Accident · No injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot's failure to maintain adequate airspeed during takeoff initial climb, which resulted in an inadvertent stall/mush, and subsequent in-flight collision with trees. A factor contributing to the accident was a tailwind.NTSB LAX05LA289Accident · Serious injuriesLimited investigationFinal reportBell 206B · Long Beach, CAthe pilot's decision not to release the banner when it became entangled on itself, which resulted in the banner tow rope becoming ensnarled with the tail rotor system.NTSB DFW05LA229Accident · 1 fatalLimited investigationFinal reportCessna A188B · Blytheville, ARThe pilot's failure to maintain control of the aircraft for undetermined reasons.NTSB LAX05LA286Accident · 1 fatalLimited investigationFinal reportCessna 172 · Yuma, AZthe pilot's failure to maintain an adequate airspeed on short final, which resulted in an inadvertent stall.NTSB DEN05LA131Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Duchesne, UTthe loss of control during external load operations for undetermined reasons.NTSB ANC05LA133Accident · No injuriesLimited investigationFinal reportCessna 206 · Yakutat, AKThe pilot's selection of unsuitable terrain for takeoff, and his failure to maintain adequate airspeed during takeoff initial climb from a remote airstrip, which resulted in the airplane descending to the ground and colliding with soft terrain beyond the end…NTSB LAX05CA284Accident · Serious injuriesData collectionFinal reportSchweizer SGS-2-32 · Waialua, HIthe pilot's inadvertent spin entry while practicing a stall maneuver and his failure to regain control of the glider before impacting a lake.NTSB DFW05LA252Accident · Minor injuriesLimited investigationFinal reportBell 206B · Myrtle Grove, LAThe pilot's loss of control in flight for undetermined reasons.NTSB CHI05LA250Accident · 1 fatalLimited investigationFinal reportPorterfield FP-65 · Sedalia, MOThe pilot's failure to maintain sufficient airspeed and the inadvertent stall/spin resulting in an in-flight loss of control and collision with terrain.NTSB LAX05LA324Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Mountain City, NVThe pilot's failure to maintain airspeed while maneuvering in mountainous terrain, which led to a stall and impact with trees and terrain.NTSB LAX05LA283Accident · 1 fatalLimited investigationFinal reportAvions Robin R.2160 · Avalon, CAThe flight instructor's unsuccessful recovery from a spin. The underlying reason was not determined.NTSB DEN05LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Ogden, UTthe flight instructor's failure to maintain adequate airspeed resulting in an inadvertent stall. Contributing factor's include the flight instructor's improper pre-flight planning and decision in accepting the intersection departure, and the flight…NTSB LAX05CA282Accident · No injuriesData collectionFinal reportBellanca 7ECA · San Jose, CAthe pilot's failure to maintain directional control of the airplane during the landing flare, which resulted in a collision with an runway sign.NTSB CHI05CA245Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Hector, MNThe pilot's failure to achieve adequate airspeed on takeoff which resulted in the airplane entering a stall/mush when it flew out of ground effect while crossing a large drainage ditch on takeoff.NTSB ANC05CA132Accident · No injuriesData collectionFinal reportCessna 172 · Tyonek, AKThe pilot's inadequate compensation for wind conditions during takeoff-initial climb, which resulted in a loss of control, and subsequent in-flight collision with a creek. A factor associated with the accident is a sudden windshift.NTSB SEA05FA181Accident · 2 fatalField investigationFinal reportPiper PA-14 · Challis, IDThe pilot's failure to maintain aircraft control and the subsequent inadvertent stall/spin to the ground. A contributing factor was the pilot's diverted attention while spotting/locating Rocky Mountain Bighorn sheep.