NTSB investigations
5,010 cases where the sequence of events included 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CHI08FA224Accident · 2 fatalField investigationFinal reportMoser Georg Lancair Legacy FG · Oshkosh, WIThe pilot's failure to maintain adequate airspeed during approach, which resulted in an aerodynamic stall and subsequent loss of control.NTSB CHI08CA225Accident · Serious injuriesData collectionFinal reportAero Commander 200D · Tecumseh, MIThe pilot flaring too high, and his inadvertent pilot-induced oscillation during the landing flare/touchdown. Contributing to the accident was the collapse of the nose landing gear.NTSB CHI08FA222Accident · Minor injuriesField investigationFinal reportPiper PA-22 · Oshkosh, WIThe pilot's failure to maintain adequate airspeed while taking off in gusting winds, which resulted in an aerodynamic stall and subsequent loss of control.NTSB CHI08CA218Accident · No injuriesData collectionFinal reportCessna T188C · Marion, IAThe pilot not maintaining airspeed while performing an aerial application maneuver and the inadvertent stall he encountered. Contributing to the accident was the gust of wind during the maneuver.NTSB SEA08CA167Accident · No injuriesData collectionFinal reportErcoupe 415-C · Corona, CAThe pilot's inadequate compensation for wind conditions and failure to maintain an adequate airspeed, resulting in a stall/mush. Contributing to the accident was the gusty crosswind conditions.NTSB NYC08CA257Accident · Minor injuriesData collectionFinal reportCessna 172S · Stevensville, MDThe flight instructor's inadequate remedial action following the student pilot's improper recovery from a bounced landing.NTSB CHI08CA223Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Ambia, INThe altitude/clearance not obtained/maintained by the pilot while maneuvering over an agricultural field during an aerial application. Contributing factors were the sunglare in the direction of flight, the low altitude of the operation, and the upslope of the…NTSB DFW08CA199Accident · No injuriesData collectionFinal reportGrumman G-164A · Newport, ARThe pilot's failure to maintain aircraft control. Contributing factors were the high temperature and tailwind.NTSB LAX08FA244Accident · 2 fatalField investigationFinal reportCessna A185F · Shelton, WAThe pilot's failure to attain and maintain adequate airspeed during initial climb, which resulted in an aerodynamic stall.NTSB DEN08LA127Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Ventus A · Midlothian, TXThe pilot's inability to maintain aircraft control due to an incapacitating cardiac event. Contributing to the accident was the pilot's poor decision to fly with known serious medical issues.NTSB CHI08CA205Accident · Minor injuriesData collectionFinal reportHowell FW2C80TR · Washington, IAThe low airspeed and proper climb rate not attained by the pilot during takeoff and the inadvertent stall by the pilot.NTSB SEA08CA165Accident · No injuriesData collectionFinal reportAntares - Balaban MA33 · Byron, CAThe pilot's failure to maintain an adequate airspeed, which resulted in a stall/mush.NTSB DFW08CA195Accident · Minor injuriesData collectionFinal reportGrumman 164A · Lake Providence, LAThe pilot's failure to maintain control of the airplane while maneuvering during an aerial application. Contributing to the accident was the wind gust.NTSB LAX08CA237Accident · No injuriesData collectionFinal reportCessna 172 · Salmon, IDThe pilot's decision to take off in known adverse wind conditions that lead to an encounter with a windshear, the resulting inability of the pilot to maintain airspeed, and a stall/mush into the terrain.NTSB DFW08LA196Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Petersburg, TXA partial loss of engine power due to the substandard and incomplete maintenance of the engine.NTSB CHI08FA196Accident · 1 fatalField investigationFinal reportCzech Aircraft Works Sport Cruiser · Newark, ILThe pilot's failure to maintain control of the airplane in the landing pattern. Contributing to the severity of injuries was the failure of the pilot's shoulder harness.NTSB CHI08CA201Accident · Minor injuriesData collectionFinal reportGrumman G-164D · Esmond, NDThe pilot's delay in advancing the throttle during the takeoff which resulted in inadequate airspeed and the subsequent stall/mush. Factors associated with the accident were the leaking hopper, the pilot continuing to operate the airplane with the known…NTSB LAX08FA233Accident · 3 fatalField investigationFinal reportHughes 369D · Price, UTThe pilot's inadequate preflight performance planning for the takeoff and the loading that exceeded the lift performance capability of the helicopter.NTSB DFW08FA190Accident · 3 fatalField investigationFinal reportPiper PA-22 · Kemp, TXThe pilot's failure to maintain adequate airspeed while maneuvering, which led to an aerodynamic stall and subsequent loss of control.NTSB DEN08LA124Accident · 1 fatalLimited investigationFinal reportAerotek Pitts S-2A · Cleveland, TXthe pilot's failure to maintain aircraft control during his attempted performance of aerobatic maneuvers shortly after takeoff.NTSB DEN08CA126Accident · No injuriesData collectionFinal reportCessna 152 · Mc Alester, OKThe student pilot's improper flare and improper recovery from a bounced landing.NTSB LAX08LA231Accident · 1 fatalLimited investigationFinal reportNichols Rans S-14 · Benson, AZThe pilot’s failure to maintain an adequate airspeed while maneuvering for landing, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot's impairment from recent marijuana use.NTSB SEA08FA161Accident · 1 fatalField investigationFinal reportCessna 441 · Sunriver, ORThe pilot's misjudged landing flare and improper recovery from a bounced landing, and the pilot's failure to maintain directional control during the go-around after one of the airplane's propellers struck the runway.NTSB NYC08CA250Accident · No injuriesData collectionFinal reportCessna 172 N · Williamstown, NJThe student pilot's inability to maintain directional control during the attempted aborted landing. Contributing to the severity of the accident were the trees.NTSB DFW08CA185Accident · Minor injuriesData collectionFinal reportStits SA3A · St Louis, MOThe pilot's failure to maintain control of the airplane during takeoff.NTSB ANC08FA087Accident · 3 fatalField investigationFinal reportIversen Glastar SH-4 · Kenai, AKThe pilot's failure to maintain adequate airspeed during maneuvering flight, which resulted in an aerodynamic stall and uncontrolled descent to the ground. Contributing to the accident was the airplane's overgross weight condition.NTSB CHI08CA192Accident · Minor injuriesData collectionFinal reportBell 47G-3B · Port Edwards, WIThe pilot failed to maintain control of the helicopter when he inadvertently flared the helicopter and the rotor rpm decayed as a result of sustaining bee stings during an aerial application flight. Contributing to the accidnet included the bees and the low…NTSB MIA08LA134Accident · 1 fatalLimited investigationFinal reportDouglas A. Pohl Lancair IV-P · Hollywood, FLA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain aircraft control which resulted in an aerodynamic stall.NTSB DEN08LA119Accident · 1 fatalLimited investigationFinal reportShannon Kevin RV-8 · Valera, TXThe pilot's failure to maintain adequate airspeed during a forced landing, which led to an aerodynamic stall, following a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's mismanagement of fuel and the low altitude at…NTSB NYC08FA239Accident · 1 fatalField investigationFinal reportJahns Vans RV-7 · Neptune, NJAn in-flight loss of control for undetermined reasons.NTSB NYC08CA241Accident · Minor injuriesData collectionFinal reportStol UC-1 Twin Bee · Bunnell, FLThe flight instructor's inadequate recovery from a bounced landing.NTSB DEN08LA118Accident · No injuriesLimited investigationFinal reportMooney M20M · Elbert, COThe pilot's failure to maintain aircraft control during a go-around, resulting in an aerodynamic stall. Contributing to the accident was the high density altitude.NTSB LAX08CA209Accident · Minor injuriesData collectionFinal reportAerostar International S-77A · Boulder, COAn encounter with a sudden gust of wind, which rendered the balloon uncontrollable and led to a collision with a tree.NTSB DFW08CA188Accident · No injuriesData collectionFinal reportBell 47G-3B · Mullen, NEThe plot's distraction with the chemical load resulting the failure to maintain control of the helicopter. A factor was no suitable terrain for landing.NTSB CHI08CA174Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Greenwood, ILThe student pilot's inadequate compensation for the gusting crosswind, and the flight instructor's delayed remedial actions that resulted in a loss of control during the go-around maneuver. Contributing to the accident was the gusting wind condition.NTSB ANC08LA083Accident · No injuriesLimited investigationFinal reportBell UH-1B · Iliamna, AKThe failure of company maintenance personnel to ensure the helicopter was properly maintained, resulting in a severe in-flight vibration due to collective bounce. Contributing to the accident was loose and worn bearings on the helicopter's stabilizer bar,…NTSB ANC08FA079Accident · 1 fatalField investigationFinal reportPiper PA-18 · Wasilla, AKThe pilot's failure to maintain directional control while landing in a gusty crosswind.NTSB NYC08FA231Accident · 4 fatalField investigationFinal reportBeech 95-B55 · Jasper, ALThe pilot's intentional visual flight into known instrument meteorological conditions, resulting in spatial disorientation and a subsequent loss of control in flight. Contributing to the accident was the overweight and aft-center-of-gravity condition of the…NTSB NYC08CA236Accident · Minor injuriesData collectionFinal reportGlasflugel Standard Libelle · Front Royal, VAAircraft control was not maintained during cruise flight. Contributing to the accident was turbulence and inadvertent flight into adverse weather.NTSB LAX08CA205Accident · Serious injuriesData collectionFinal reportLa Moutte Trike · Weizer, IDThe pilot's failure to maintain adequate airspeed, which resulted in a stall.NTSB DFW08FA170Accident · 5 fatalField investigationFinal reportCessna U206F · Santa Rosa, NMThe pilot's failure to maintain safe flying airspeed for undetermined reasons resulting in an inadvertent stall.NTSB DFW08CA171Accident · Minor injuriesData collectionFinal reportMooney M20 · Lake Ft Gibson, OKThe pilot's loss of control while maneuvering the aircraft.NTSB MIA08CA127Accident · Minor injuriesData collectionFinal reportLima Sky Raider I · Homestead, FLThe pilot's failure to maintain airspeed during initial climb.NTSB LAX08CA173Accident · Minor injuriesData collectionFinal reportBeech A36 · Ryegate, MTThe pilot's failure to abort the takeoff when the ground roll acceleration profile was determined to be insufficient for takeoff. Contributing to the accident was the shifting wind conditions.NTSB NYC08LA228Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Toms River, NJThe failure of the pilot's seat to engage or remain engaged due to the improper inspection of the worn seat tracks.NTSB LAX08CA189Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Laramie, WYThe pilot's failure to attain and maintain an adequate airspeed during a go around, that resulted in a stall/mush. Contributing to the accident was the tailwind condition.NTSB DFW08LA167Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Bethany, MOThe pilot's decision to take off with a known deficiency.NTSB DEN08FA114Accident · 2 fatalField investigationFinal reportAero Commander 500S · Linwood, KSThe pilot-in-training inadvertently shutting off both engine fuel control valves causing a loss of power in both engines, and the pilot's failure to maintain control of the airplane resulting in a stall. Contributing to the accident was the chief pilot's…NTSB DFW08CA168Accident · Minor injuriesData collectionFinal reportGrumman G-164 · Tallulah, LAThe pilot's failure to maintain aircraft control. Contributing to the accident was the pilot's failure to maintain adequate airspeed.NTSB CHI08CA168Accident · No injuriesData collectionFinal reportWolseley Motors SE5-A · Seymour, INThe pilot/builder's failure to manufacture the airplane with an appropriate engine thrust angle. Contributing to the accident was the pilot/builder's adjustment of the horizontal stabilizer which rendered the airplane uncontrollable.