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 CEN09LA056Accident · 1 fatalLimited investigationFinal reportCessna 182M · Basalt, COThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in his loss of control of the airplane in flight.NTSB WPR09LA032Accident · 1 fatalLimited investigationFinal reportUniversal Globe · Wallace, CAThe pilot's incapacitation during cruise for unknown reasons that resulted in a loss of aircraft control.NTSB ERA09LA043Accident · 1 fatalLimited investigationFinal reportMiller J Kirtley RV-6 · Martinsville, VAThe pilot's failure to maintain aircraft control during the initial climb after an aborted landing. Contributing to the accident was the pilot's impairment from an over-the-counter sedating antihistamine.NTSB ERA09CA044Accident · Minor injuriesData collectionFinal reportQuicksilver II Mxlii · Knoxville, PAThe reason for this occurrence was undetermined.NTSB WPR09CA031Accident · No injuriesData collectionFinal reportPiper PA-22-135 · San Manuel, AZThe pilot's failure to maintain lateral aircraft control that resulted in collision with terrain during landing.NTSB CEN09CA079Accident · No injuriesData collectionFinal reportPiper PA18-150 · Colorado Springs, COLoss of directional control due to an encounter with a weather phenomena at rotation.NTSB CEN09CA050Accident · No injuriesData collectionFinal reportAeronca 7CCM · Chadron, NEThe pilot's failure to maintain direction control of the airplane. Contributing to the accident was the pilot's lack of experience.NTSB ANC09LA009Accident · Minor injuriesLimited investigationFinal reportConstrucciones Aeronauticas CASA-212 · Toksook Bay, AKThe flight crew’s inability to adjust/increase power to the right engine during the landing approach due to an in-flight disconnect of the engine power control linkage, resulting in a loss of control of the airplane. Contributing to the accident was the…NTSB WPR09LA026Accident · 2 fatalLimited investigationFinal reportSilfvast Starduster TOO · Cedar Fort, UTThe pilot's failure to maintain an adequate airspeed and/or angle of attack to avoid a stall/spin during an aerobatic maneuver.NTSB ERA09FA029Accident · 2 fatalField investigationFinal reportPiper PA-24 · Red Hill, VAThe pilot's failure to maintain aircraft control due to an improper repair to the stabilator, which resulted in an in-flight failure of the stabilator. Contributing to the accident was the descent in turbulence, at airspeeds above the maximum structural…NTSB CEN09LA034Accident · Serious injuriesLimited investigationFinal reportRans S-12XL · Breckenridge, TXThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall.NTSB ERA09LA026Accident · Serious injuriesLimited investigationFinal reportCessna 175A · Foley, ALThe pilot’s failure to maintain adequate airspeed during initial climb, resulting in a stall and collision with terrain. Contributing to the accident was the pilot’s lack of recent experience.NTSB CEN09WA033Accident · 2 fatalForeign investigationCirrus Design SR22 · Zurich, SwitzerlandUnder the jurisdiction and control of the Swiss Government.NTSB WPR09LA016Accident · 1 fatalLimited investigationFinal reportHeisler Lancair Legacy · Parowan, UTThe pilot failed to secure the canopy prior to takeoff, resulting in his inability to control the aircraft during the takeoff. Contributing to the accident was the pilot’s impairment from prescription medications and possible obstructive sleep apnea.NTSB ERA09LA020Accident · No injuriesLimited investigationFinal reportSikorsky S-76C · New York, NYThe failure of the flightcrew to stabilize the helicopter over its confined landing area during a hovering left-pedal turn, resulting in tail rotor blade contact with a perimeter fence component and a subsequent loss of directional control. Contributing to…NTSB ERA09LA019Accident · 1 fatalLimited investigationFinal reportHargett Sky Ranger II · Rock Hill, SCThe non-certificated pilot's failure to maintain airspeed, which resulted in an inadvertent stall and a subsequent impact with the ground. Contributing to the accident were the pilot's lack of training and his impairment due to recent use of marijuana.NTSB CEN09FA012Accident · 2 fatalField investigationFinal reportBell 206 · Conroe, TXA loss of control for undetermined reasons.NTSB ERA09LA013Accident · 1 fatalLimited investigationFinal reportSabre Tukan · Mohawk, TNThe pilot's loss of control in flight due to a lack of flight experience or instruction. Contributing to the accident was the pilot's impairment due to the recent use of marijuana and a prescription painkiller.NTSB CEN09FA010Accident · 2 fatalField investigationFinal reportMaule MXT-7-180A · Santa Teresa, NMThe pilot's decision to takeoff and fly into a thunderstorm.NTSB WPR09LA010Accident · Serious injuriesLimited investigationFinal reportBell 206B · Cougar, WAThe pilot's failure to maintain clearance between his external load and trees while maneuvering. Contributing to the accident were hilly terrain and trees.NTSB CEN09CA013Accident · Minor injuriesData collectionFinal reportPegasus Quantum · West Terre Haute, INThe pilot's failure to adequately compensate for the crosswind during the go-around. Contributing to the accident was the crosswind condition and the trees.NTSB CEN09CA006Accident · Minor injuriesData collectionFinal reportBeech 23 · Chesaning, MIThe pilot's failure to adequately compensate for the gusting wind conditions during landing. Contributing to the accident were the gusting winds.NTSB WPR09FA005Accident · 1 fatalField investigationFinal reportIniziative Industriali Italian SKY Arrow 600 · Malibu, CAThe pilot's failure to maintain aircraft control during a low-altitude maneuver. Contributing to the accident was the pilot's decision to perform a maneuver at a low altitude that was insufficient to allow him to recover from the loss of control. Contributing…NTSB CEN09CA025Accident · Serious injuriesData collectionFinal reportHolmes William E Predator · Branson, MOThe pilot's failure to maintain directional control. Contributing to the accident was the wing's failure to open all cells for undetermined reasons and the trees near the runway.NTSB WPR09LA004Accident · 1 fatalLimited investigationFinal reportBonde TF-51D · Sandy Valley, NVThe pilot's failure to maintain adequate airspeed while maneuvering to land, resulting in an aerodynamic stall. Contributing to the accident was the pilot's diverted attention while attempting to extend the landing gear.NTSB WPR09CA003Accident · No injuriesData collectionFinal reportBeech 76 · Eloy, AZThe pilot’s failure to maintain aircraft control during landing. Contributing to the accident were the crosswind wind conditions and terrain induced turbulence.NTSB ANC09FA003Accident · 1 fatalField investigationFinal reportAntonovich Anton B Challenger II · Chugiak, AKThe pilot’s failure to maintain control of the airplane while maneuvering, resulting in an in-flight collision with trees. Contributing to the accident was the pilot's lack of experience.NTSB LAX08FA301Accident · Serious injuriesField investigationFinal reportCessna 172S · Fullerton, CAThe pilot's failure to follow the takeoff checklist and verify the proper flap setting before takeoff.NTSB ANC09FA001Accident · 2 fatalField investigationFinal reportCessna U206C · Anchorage, AKA loss of engine power during takeoff/initial climb for an undetermined reason, and the pilot's decision to make an abrupt and steep low altitude turn toward an intersecting runway, resulting in an aerodynamic stall and loss of aircraft control.NTSB NYC08CA328Accident · No injuriesData collectionFinal reportHood Junior Ace · Ashville, ALThe pilot's improper flare while landing. Contributing to the accident was the airplane's lack of yaw control as reported by the pilot.NTSB DFW08LA238Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Leadville, COThe flight instructor's failure to maintain control of the airplane while maneuvering at low altitude.NTSB NYC08CA325Accident · No injuriesData collectionFinal reportAeronca 7AC · Mt. Pleasant, SCThe pilot's failure to maintain aircraft control during an emergency maneuver. Contributing to the accident was the failure of the left magneto.NTSB LAX08FA300Accident · 1 fatalField investigationFinal reportBeech A36 · Carlsbad, CAThe pilot's failure to maintain control during the instrument approach and attempted go-around.NTSB DFW08FA237Accident · 2 fatalField investigationFinal reportCessna 320D · Collinsville, OKThe crews' failure to maintain adequate airspeed, which resulted in an aerodynamic stall close to the ground.NTSB DFW08CA239Accident · No injuriesData collectionFinal reportGier Travis H Aventura II · Montgomery, TXThe pilot's failure to maintain control of the airplane during takeoff. A contributing factor was the wind gust.NTSB SEA08LA213Accident · Serious injuriesLimited investigationFinal reportBell 206B · Woods Landing-Jelm, WYThe pilot's encounter with a loss of tail rotor effectiveness event and his failure to maintain directional control while maneuvering. Contributing to the accident were the tailwind condition and the sloping, uneven terrain.NTSB NYC08FA324Accident · 1 fatalField investigationFinal reportCessna 402 · Vineyard Haven, MAA loss of aircraft control due to spatial disorientation.NTSB DEN08CA164Accident · No injuriesData collectionFinal reportBice David E Bearhawk · Double Eagle Airport, NMThe pilot flared high and failed to maintain directional control. Contributing to the accident were the pilot's unfamiliarity with the airplane and the crosswind.NTSB LAX08WA305Accident · 1 fatalForeign investigationBell 206 · Douglas Camp, Papua New GuineaOn September 25, 2008, at 1012 local time, a Bell 206L3, Papua New Guinea (PNG) registry P2-HBC, crashed in a remote area near Douglas Camp (PNG) under unknown circumstances while reportedly performing long line operations. The helicopter was operated by Heli…NTSB SEA08CA208Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Flagstaff, AZThe pilot's decision to attempt a takeoff in a high density altitude high gross weight condition that exceeded the takeoff performance capability of the helicopter. The pilot's failure to maintain adequate rotor rpm was also causal. Contributing factors were…NTSB DEN08IA160IncidentIncident investigationFinal reportRaytheon Cobra · Whetstone, AZA total off of engine power resulting from an overheated piston, and the pilot's subsequent failure to send a proper command to the UAS. Contributing to the accident was the operation of the engine at high power for an extended period with a lean fuel setting.NTSB NYC08FA319Accident · 1 fatalField investigationFinal reportPiper PA-32 · Atlanta, GAA loss of aircraft control for undetermined reasons.NTSB DFW08FA233Accident · 2 fatalField investigationFinal reportPiper Aerostar PA-60-602P · Kremmling, COThe pilot’s failure to maintain aircraft control, resulting in an aerodynamic stall and spin.NTSB DEN08FA155Accident · 2 fatalField investigationFinal reportCessna 172L · York, NEThe student pilot's failure to maintain aircraft control, and the flight instructor's failure to take remedial action, for undetermined reasons.NTSB CHI08FA282Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Woodruff, WIThe pilot’s failure to maintain airspeed during a missed approach leading to the inadvertent stall. Contributing to the accident were the pilot’s lack of experience in the type of operation conducted, the certificate holder’s loss of operational control, and…NTSB ANC08LA122Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's failure to maintain sufficient airspeed to preclude a stall while maneuvering at a low altitude, resulting in an uncontrolled descent and collision with terrain.NTSB NYC08CA309Accident · No injuriesData collectionFinal reportBell 206B · Eutaw, ALThe pilot's inadequate preflight inspection.NTSB DFW08TA225Accident · Serious injuriesFinal reportDiamond Aircraft Industries DA-20-C-1 · Pueblo, COThe student pilot's inability to maintain aircraft control due to an encounter with wake turbulence from a preceding larger aircraft. Contributing to the accident was the instructor pilot's failure to intervene.NTSB ANC08CA119Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Coldfoot, AKThe pilot's failure to attain/maintain sufficient flying speed during initial climb.NTSB MIA08CA191Accident · No injuriesData collectionFinal reportAirframes Unlimited USA-1B · Surry, VAThe pilot's improper handling of the powered parachute during takeoff/initial climb.