NTSB investigations
251 cases where the sequence of events included Loss of lift.
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\" = '500' 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" = '500' 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 CEN12LA331Accident · Minor injuriesLimited investigationFinal reportBaldwin Skybolt · Stuttgart, ARThe pilot's inadequate preflight planning, which resulted in the airplane’s overweight takeoff from an airstrip with a high density altitude and subsequent collision with terrain.NTSB ERA12CA281Accident · No injuriesData collectionFinal reportPiper J3C-65 · Plantation Key, FLThe pilot’s failure to maintain adequate control of the airplane and ensure clearance from trees.NTSB WPR12CA157Accident · No injuriesData collectionFinal reportFisher HP-14 Sailplane · Nampa, IDThe pilot’s incorrect positioning of the wing flaps during the landing approach, which resulted in a loss of lift and hard landing.NTSB ERA12TA251Accident · Minor injuriesFinal reportBell 407 · Delray Beach, FLThe pilot’s improper response to a simulated engine failure and the instructor’s delayed and improper remedial action.NTSB WPR12LA116Accident · No injuriesLimited investigationFinal reportBeech S35 · Dixie Valley, NVThe airplane’s encounter with forecast low-level windshear conditions during takeoff, which resulted in a loss of lift.NTSB WPR12LA104Accident · No injuriesLimited investigationFinal reportBeech G18 · Hollister, CAThe pilot’s failure to maintain adequate airspeed during the initial climb, which resulted in an aerodynamic stall and a subsequent hard landing, loss of directional control, and ground loop.NTSB CEN12CA131Accident · Serious injuriesData collectionFinal reportInfinity Power Parachutes Classic 2002 · Alanson, MIThe powered parachute’s encounter with a downdraft/windshear during takeoff, which resulted in a loss of lift.NTSB WPR12CA072Accident · No injuriesData collectionFinal reportSchweizer SGS 1-26B · Murrieta, CAThe glider's encounter with insufficient atmospheric lift to maintain soaring flight.NTSB WPR11FA415Accident · Serious injuriesField investigationFinal reportCessna 172M · Santa Monica, CAThe student pilot’s misjudged approach and landing attempt. Contributing to the accident was a lack of airspeed due to a blocked pitot tube.NTSB WPR11CA411Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-32 · Warner Springs, CAThe pilot’s inadequate altitude to clear a ridgeline while maneuvering over a mountainous area.NTSB ERA11CA465Accident · No injuriesData collectionFinal reportLet L 33 Solo · Wakefield, VAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, resulting in an off-airport landing.NTSB ERA11CA460Accident · No injuriesData collectionFinal reportMooney M20R · West Chester, PAThe pilot did not maintain adequate airspeed during a go-around, which resulted in an aerodynamic stall.NTSB WPR11CA342Accident · No injuriesData collectionFinal reportSchleicher ASW-27 · Preston, IDThe glider's impact with crops during the off-airport landing.NTSB WPR11CA486Accident · No injuriesData collectionFinal reportSchleicher ASW-27 · Brigham City, UTThe glider pilot did not take timely action to locate a safe outlanding area after entering an area where atmospheric lift was not sufficient to maintain soaring flight.NTSB ERA11CA340Accident · No injuriesData collectionFinal reportMooney M-20G · Monroeville, PAThe pilot’s failure to maintain airplane control during takeoff.NTSB ERA11CA288Accident · Minor injuriesData collectionFinal reportSchleicher ASW-27 · Athens, TNThe pilot's inadequate visual lookout resulting in a collision with power lines while making an off-airport landing.NTSB CEN11LA318Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Yancey, TXThe loss of engine power due to the unintentional closure of the fuel shutoff valve.NTSB WPR11CA208Accident · No injuriesData collectionFinal reportDoktor Fiberglas H101 Salto · Peoria, AZThe glider's encounter with turbulence and loss of lift, which resulted in a ditching in a lake.NTSB ERA11LA216Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Culpeper, VAMechanical failure of the transmission for reasons that could not be determined because the transmission could not be torn down.NTSB ERA11CA206Accident · Serious injuriesData collectionFinal reportRolladen-Schneider LS-3 · Winchester, TNThe glider pilot's delayed response to changing weather conditions, which resulted in an off-airport landing into trees.NTSB ERA11WA119Accident · 1 fatalForeign investigationAvions Robin DR400 · Guidonia Montecelio, ItalyOn January 11, 2011, about 1430 universal coordinated time, an Avions Pierre Robin, DR400/180R, Italian registration I-ITAV, crashed during takeoff, while towing a glider, and was destroyed by fire. The airplane was departing Guidonia Airport (LIRG), Guidonia…NTSB CEN11CA057Accident · Serious injuriesData collectionFinal reportSix Chuter SR7 · Winnie, TXThe collapse of the powered parachute's canopy on short final for undetermined reasons, resulting in a loss of lift.NTSB CEN11CA037Accident · No injuriesData collectionFinal reportCessna 182K · Henderson, TXThe pilot's failure to maintain control of the airplane during the landing flare, which resulted in a hard landing.NTSB WPR11LA013Accident · No injuriesLimited investigationFinal reportBeech C24 · Blanding, UTThe pilot’s failure to attain a climb gradient sufficient to clear the rising terrain, which resulted in his decision to make a forced landing on a road.NTSB WPR10FA449Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Las Vegas, NVThe pilot's inability to maintain a positive rate of climb after takeoff for undetermined reasons.NTSB ERA10LA450Accident · No injuriesLimited investigationFinal reportAir Tractor AT402 · Pompano Beach, FLThe pilot's delayed decision to abort the takeoff, which resulted in a runway overrun and a subsequent collision with obstacles and terrain. Contributing to the accident was the airplane's high gross weight.NTSB CEN10CA507Accident · No injuriesData collectionFinal reportLet L-23 Super Blanik · Socorro, NMA loss of lift that resulted in an off-airport landing.NTSB CEN10LA227Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Glenwood, NMThe pilot's decision to attempt a takeoff from an unimproved airstrip with a high density altitude.NTSB WPR10CA389Accident · No injuriesData collectionFinal reportLet L 33 Solo · Adelanto, CAThe pilot’s inability to make it to the airport as a result of his inadequate planning for the gusting headwinds.NTSB ERA10LA377Accident · No injuriesLimited investigationFinal reportCessna 172N · Waynesboro, VAThe pilot's failure to follow the short-field takeoff procedures published in the Pilot's Operating Handbook.NTSB WPR10LA356Accident · 1 fatalLimited investigationFinal reportParker RS-15 Sailplane · Marysvale, UTThe glider's encounter with insufficient atmospheric lift to maintain soaring flight.NTSB CEN10CA388Accident · No injuriesData collectionFinal reportSchweizer SGS 1-26B · Waynesville, OHThe student pilot's delayed decision that resulted in insufficent altitude to return to the departure airport.NTSB CEN10CA378Accident · No injuriesData collectionFinal reportCessna 206 · Albuquerque, NMThe pilot's improper recovery from a bounced landing.NTSB ERA10WA338Accident · 2 fatalForeign investigationBolkow BO105 · Buenos Aires, ArgentinaOn June 18, 2010, about 1118 universal Coordinated Time (UTC),an Bolkow BO-105, Argentina registration LV-WJX, operated by a private owner on a business flight, to photograph a automobile accident, collided with tall trees, overhead power lines, and struck…NTSB ERA10LA318Accident · Serious injuriesLimited investigationFinal reportGlenn H Curtiss Museum Hudson Flyer · Penn Yan, NYThe pilot’s failure to maintain altitude after takeoff.NTSB WPR10CA288Accident · No injuriesData collectionFinal reportBurkhart Grob G103C Twin III Acro · Minden, NVThe pilot's encounter with an area of degraded lift during cruise flight, resulting in a forced off-airport landing.NTSB ERA10CA291Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1-36 · Jacksonville, FLThe glider pilot’s delayed decision to divert following a loss of thermal lift.NTSB ERA10LA267Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · Clearwater, FLThe overweight condition of the airplane due to the pilot's inadequate preflight planning, resulting in the airplane's degraded climb performance. Contributing to the accident was the pilot's retraction of the flaps prior to reaching the manufacturer's…NTSB ERA10CA260Accident · Serious injuriesData collectionFinal reportSchleicher ASW-20C · Unionville, PAThe pilot's lack of remedial action in response to a loss of altitude, which led to a forced landing in unsuitable terrain.NTSB WPR10CA215Accident · No injuriesData collectionFinal reportPZL-Swidnik PW-5 · Marana, AZThe pilot's inability to find thermal lift. Contributing to the accident was the failure of a computer that provided glide information and vertical speed instrumentation as a result of an improperly routed electrical cable that caused a short in the…NTSB ERA10LA190Accident · No injuriesLimited investigationFinal reportRobinson R22 · Miami, FLA loss of main rotor rpm for undetermined reasons.NTSB ERA10CA176Accident · No injuriesData collectionFinal reportRolladen-Schneider LS-4 · Jasper, TNThe inadequate in-flight planning by the glider pilot to intentionally cross a ridge at low altitude, resulting in the in-flight collision with trees.NTSB ERA09CA479Accident · No injuriesData collectionFinal reportJonker JS-1B · Tullahoma, TNThe pilot's failure to maintain a proper glidepath while on approach, resulting in landing short of the runway.NTSB CEN09CA516Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Harlan, IAThe pilot's failure to perform accurate weight and balance calculations which resulted in exceeding the maximum takeoff weight and the airplane's climb capability.NTSB WPR09CA389Accident · No injuriesData collectionFinal reportEiriavion PIK 20B · Marana, AZA loss of lift that resulted in an off-airport landing.NTSB WPR09CA344Accident · No injuriesData collectionFinal reportSchweizer SGS 1-26A · Lake Riverside, CAA loss of lift which necessitated a forced landing in a field.NTSB CEN09CA273Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · New Braunfels, TXThe pilot's failure to maintain adequate main rotor rpm during a practice autorotation. Contributing to the accident was the instructor pilot's delayed remedial action.NTSB WPR09LA160Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 · Prescott, AZThe pilot's failure to maintain adequate main rotor rpm while maneuvering at a low altitude.NTSB CEN09CA180Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · O'Donnell, TXThe pilot's failure to maintain control while performing a quick stop maneuver to an out of ground effect (OGE) hover. Contributing to the accident was the high density altitude and near calm wind condition.NTSB CEN09RA052Accident · 1 fatalForeign investigationBeech 200 · Punta Chivato, MexicoOn November 3, 2008 at approximately 1800 pacific standard time (PST) a twin-engine turbo prop, Beechcraft BE200, N200JL, was destroyed when it impacted terrain shortly after takeoff from Punta Chivato Airstrip, located near Punto Chivato, Baja California…