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 ANC10CA055Accident · No injuriesData collectionFinal reportCessna 180 · Cooper Landing, AKThe pilot's failure to maintain airspeed during takeoff, resulting in an uncontrolled descent and collision with terrain.NTSB WPR10LA307Accident · 1 fatalLimited investigationFinal reportCessna 172N · Angels Camp, CAThe pilot’s failure to maintain airplane control while maneuvering.NTSB CEN10LA334Accident · 1 fatalLimited investigationFinal reportDrone Paul E Pulsar III · Carmi, ILThe pilot's failure to maintain adequate airspeed after an aborted landing, which resulted in an aerodynamic stall and impact with terrain.NTSB ANC10LA053Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 · Unalaska, AKThe pilot's inappropriate low altitude maneuvering, which resulted in a collision with terrain.NTSB WPR10LA306Accident · No injuriesLimited investigationFinal reportLuscombe 11A · Merced, CAThe pilot’s inability to maintain airplane control during cruise flight due to the failure of the elevator trim tab as a result of missing hardware for the elevator control cable bellcrank to elevator torque tube attachment bracket.NTSB WPR10LA299Accident · 1 fatalLimited investigationFinal reportOliver Vans RV-9A · May, IDThe pilot's failure to maintain control of the airplane during maneuvering flight due to spatial disorientation. Contributing to the accident was the pilot's ingestion of an impairing level of over-the-counter medication.NTSB WPR10LA297Accident · 2 fatalLimited investigationFinal reportBernhard Vans RV8 · Truckee, CAThe pilot's failure to maintain airplane control during a steep turn to final approach, which resulted in an inadvertent aerodynamic stall.NTSB WPR10FA295Accident · 1 fatalField investigationFinal reportKaman Aerospace K-1200 · Donnelly, IDThe collision of two counter-rotating main rotor blades for undetermined reasons, which resulted in a loss of control.NTSB WPR10LA293Accident · 2 fatalLimited investigationFinal reportRans Coyote II S6 · Lincoln, CAThe pilot’s failure to maintain adequate airspeed while in a turn, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the increased drag on the airplane with the doors removed.NTSB CEN10RA319Accident · 9 fatalForeign investigationCessna 208 · Felipe Carrillo Puerto, MexicoOn June 13, 2010, approximately 1800 central daylight time, a Cessna 208B, XA-TWK, was substantially damaged upon impact with terrain following a loss of control during the initial climb from the Felipe Carrillo Puerto airstrip, Felipe Carrillo Puerto,…NTSB CEN10FA320Accident · 2 fatalField investigationFinal reportBeech A36 · Lidderdale, IAThe pilot's decision to initiate the flight in marginal weather conditions and his loss of aircraft control.NTSB ERA10LA302Accident · 1 fatalLimited investigationFinal reportBeech 60 · Edenton, NCThe flight instructor’s initiation of a simulated single engine scenario at or below the airplane’s minimum single engine control speed, resulting in a loss of airplane control. Contributing to the accident was the flight instructor’s failure to set full…NTSB CEN10FA310Accident · 1 fatalField investigationFinal reportAir Tractor AT602 · Knobel, ARThe pilot did not maintain control of the airplane while maneuvering at low altitude.NTSB WPR10LA276Accident · Serious injuriesLimited investigationFinal reportCzech Aircraft Works Sportcruiser · San Diego, CAThe inadvertent opening of the aircraft canopy during the takeoff climb, which distracted the pilot and resulted in his failure to maintain aircraft control. Contributing to the accident was a lack of guidance in the manufacturer's pilot operating handbook…NTSB WPR10FA277Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Spokane, WAA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation and the student pilot's failure to maintain main rotor rpm.…NTSB ANC10FA048Accident · 1 fatalField investigationFinal reportCessna U206F · Anchorage, AKThe pilot’s decision to load the airplane well beyond its allowable weight and center of gravity limits, resulting in a loss of control during the initial climb. Contributing to the severity of the injuries was the pilot’s decision to allow two child…NTSB WPR10LA271Accident · No injuriesLimited investigationFinal reportShaffer William C Quicksilver MX II SP · Visalia, CAThe pilot's inadequate compensation for the gusty crosswind conditions and failure to maintain runway alignment while landing.NTSB WPR10LA274Accident · Serious injuriesLimited investigationFinal reportSmithwick/Treidel Tukan · Prairie, IDThe pilot's loss of control of the weight-shift-controlled airplane during takeoff for undetermined reasons.NTSB CEN10FA277Accident · Serious injuriesField investigationFinal reportAveko Sro VL-3 LSA · Boyd, TX***This report was modified on November 15, 2012. Please see the docket for this accident to view the original report with revisions shown.*** The pilots’ failure to avoid and recover from the prohibited maneuver of aerodynamic spin during a training flight,…NTSB CEN10LA275Accident · 2 fatalLimited investigationFinal reportBellanca 7GCBC · Watertown, SDThe pilot's loss of airplane control while conducting aerobatic, low-altitude maneuvers. Contributing to the accident was the pilot's impairmant due to alcohol.NTSB CEN10CA294Accident · No injuriesData collectionFinal reportHolden Frank Joseph Rans S6ES · Waxahachie, TXThe pilot's failure to attain adequate airspeed during takeoff, resulting in a stall/msuh.NTSB CEN10CA290Accident · Minor injuriesData collectionFinal reportAeronca 0-58B · Jefferson, TXThe pilot's failure to maintain control of the airplane on during initial climb.NTSB CEN10CA270Accident · No injuriesData collectionFinal reportAeropro CZ Eurofox LSA · Belton, TXThe pilot's loss of directional control during landing.NTSB CEN10CA263Accident · No injuriesData collectionFinal reportPiper J-3 · Parker, COThe pilot's failure to maintain control of the airplane while landing in gusting winds.NTSB WPR10LA258Accident · 1 fatalLimited investigationFinal reportRice GN-1 AIR Campier · Paulden, AZThe pilot's loss of airplane control for undetermined reasons while on final approach to land.NTSB ERA10CA278Accident · No injuriesData collectionFinal reportCessna 172S · East Haddam, CTThe pilot's delayed decision to attempt a go-around, and his subsequent failure to maintain directional control while landing.NTSB ERA10LA280Accident · 1 fatalLimited investigationFinal reportGardner Douglas P VAN/RV8A · Sebring, FLThe pilot's failure to maintain control of the airplane during the landing approach.NTSB CEN10LA266Accident · Serious injuriesLimited investigationFinal reportHall Thomas K Kitfox Speedster · Defiance, OHThe pilot's failure to maintain control of the airplane while performing low-altitude maneuvers.NTSB WPR10LA259Accident · 1 fatalLimited investigationFinal reportSocata TB-20 · Happy Camp, CAThe pilot’s inadequate preflight planning and decision to continue to operate under visual flight rules into instrument meteorological conditions, which resulted in an encounter with an embedded thunderstorm and rain showers and moderate to severe turbulence,…NTSB ERA10LA277Accident · 1 fatalLimited investigationFinal reportRutter Herbert G Long EZ · Wakefield, VAThe pilot’s failure to properly align the airplane with the final approach path to the runway and his subsequent loss of control during his attempts to correct the flight path. Contributing to the accident was the pilot’s progressive cognitive decline due to…NTSB ERA10CA276Accident · No injuriesData collectionFinal reportCessna P210N · Cambridge, NYThe pilot's loss of directional control during takeoff.NTSB ERA10CA269Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Glens Falls, NYThe pilot's failure to maintain directional control during a takeoff attempt.NTSB WPR10FA239Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Redmond, ORThe pilot's failure to maintain airspeed, which resulted in a stall and collision with terrain.NTSB CEN10CA249Accident · Minor injuriesData collectionFinal reportQuicksilver GT-500 · Big Lake, TXThe pilot's loss of control when the airplane unexpectedly encountered a downdraft shortly after takeoff.NTSB ERA10CA262Accident · Minor injuriesData collectionFinal reportHiller UH12 · Sarasota, FLThe pilot's delayed remedial action to maintain main rotor rpm, which resulted in a loss of lift and hard landing.NTSB WPR10CA233Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Lake Havasu City, AZThe student pilot's failure to maintain aircraft control during a go-around, resulting in a stall/mush.NTSB CEN10LA243Accident · No injuriesLimited investigationFinal reportMooney M20G · Benton, ARThe pilot's failure to maintain directional control of the airplane during the aborted takeoff.NTSB WPR10FA228Accident · 1 fatalField investigationFinal reportCessna U206G · Yuma, AZThe pilot's loss of situational awareness and failure to maintain aircraft control while maneuvering at low altitude. Contributing to the accident was glare from the rising sun.NTSB WPR10CA229Accident · No injuriesData collectionFinal reportAviat A-1B · Moab, UTThe pilot's inadequate crosswind compensation resulting in a loss of directional control and impact with bushes.NTSB CEN10CA239Accident · No injuriesData collectionFinal reportRemos G-3/600 · Fort Worth, TXThe student pilot’s loss of control and the instructor’s delayed remedial action.NTSB CEN10FA233Accident · 2 fatalField investigationFinal reportJetProp DLX Piper PA46 · New Albany, INThe pilot’s failure to maintain airspeed in instrument meteorological conditions, which resulted in an aerodynamic stall.NTSB WPR10CA236Accident · No injuriesData collectionFinal reportBeech 76 · Willows, CAThe student pilot's inadequate compensation for the gusting crosswind conditions and the certified flight instructor's inadequate supervision, resulting in a loss of directional control during landing.NTSB ANC10CA034Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Willow, AKThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.NTSB ERA10FA246Accident · 2 fatalField investigationFinal reportBeech 58 · Bear Branch, KYThe pilot's improper in-flight planning/decision, his continued flight into adverse weather (icing conditions), and failure to maintain an adequate airspeed during the emergency descent.NTSB WPR10FA211Accident · 2 fatalField investigationFinal reportAirBorne WindSport Edge XT-912-L · Captain Cook, HIThe pilot’s intentional in-flight maneuvers that exceeded the structural limits of the aircraft, which resulted in structural failure of the wings.NTSB CEN10LA216Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Madison, INThe pilot’s failure to maintain control of the airplane. Contributing to the accident was the pilot’s decision to conduct the flight with known physiological impairment and his use of unapproved sedating medication, both of which likely impaired his ability…NTSB ERA10FA232Accident · 1 fatalField investigationFinal reportMaule M5-235C · Zellwood, FLThe pilot's failure to maintain airspeed while maneuvering after takeoff, which resulted in an aerodynamic stall, loss of aircraft control, and collision with trees.NTSB CEN10CA212Accident · No injuriesData collectionFinal reportCessna 172M · Coldwater, KSThe pilot's failure to compensate for gusting crosswinds resultuing in the loss of directional control while landing.NTSB WPR10LA208Accident · Minor injuriesLimited investigationFinal reportBibbee Cozy Mark IV · North Las Vegas, NVThe airplane's inability to recover from a stall due to the builder's failure to comply with design specifications and update the pilot’s operating handbook, which would have highlighted the discrepancies in the airplane's build-up.NTSB ERA10LA221Accident · Serious injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Millbrook, NYThe pilot's failure to maintain aircraft control after takeoff while he was distracted by trying to hold shut the unlocked cockpit canopy. Contributing to the accident was the pilot's failure to lock the canopy prior to takeoff, and the inadequate guidance in…