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 WPR14FA282Accident · 3 fatalField investigationFinal reportPiper PA 28R-180 · Lake Elsinore, CAThe pilot's failure to maintain airplane control when the landing gear unintentionally extended while maneuvering at low altitude and airspeed, which increased the airplane’s drag and decreased its ability to climb over the rising terrain.NTSB WPR14CA228Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Leeds, UTThe pilot's failure to confirm the flaps had been retracted during takeoff, which resulted in a loss of lift and subsequent collision with terrain.NTSB WPR14LA220Accident · Serious injuriesLimited investigationFinal reportAero Commander Callair A 9B · Gardiner, MTThe pilot’s inadequate preflight planning and his subsequent takeoff with the airplane over its allowable gross weight in high density altitude conditions, which degraded the airplane’s climb performance and led to a subsequent forced landing.NTSB CEN14CA275Accident · Serious injuriesData collectionFinal reportUnknown Buccaneer SX · Wagoner, OKThe pilot's failure to maintain aircraft control following a loss of engine power during takeoff. Contributing was the pilot's inadequate fuel management that led to fuel starvation/exhaustion and the loss of engine power.NTSB ERA14CA220Accident · Serious injuriesData collectionFinal reportSchleicher ASW 20 · Monroe, GAThe pilot's improper selection of an off-airport landing site and his subsequent failure to maintain clearance from trees during an off airport landing.NTSB WPR14LA169Accident · Minor injuriesLimited investigationFinal reportPiper PA30 - NO Series · Bullhead City, AZThe pilot's mismanagement of the throttle and propeller controls during the attempted go-around after encountering turbulence, which resulted in his failure to maintain adequate airspeed and climb rate and a subsequent forced landing and impact with terrain.…NTSB ERA14LA164Accident · Serious injuriesLimited investigationFinal reportFarace Thomas Scott Kitfox II · Vicksburg, MSThe airplane’s low-level encounter with a downdraft that maximum engine power could not overcome.NTSB WPR14CA138Accident · Minor injuriesData collectionFinal reportDG Flugzeugbau DG 1000S · Wrightwood, CAThe pilot's inadequate in-flight planning/decision to maneuver the glider where the lift was not sufficient to maintain flight, resulting in an off airport landing.NTSB ERA14CA126Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Ventus 2B · Burnsville, NCThe pilot's improper use of the spoilers, which resulted in an uncontrolled descent and subsequent impact with trees.NTSB WPR14CA101Accident · No injuriesData collectionFinal reportEnstrom Helicopter 280C · Showlow, AZThe pilot's failure to maintain main rotor RPM during the takeoff run in a high density altitude environment, which resulted in a loss of aircraft control and collision with terrain.NTSB CEN14CA039Accident · Minor injuriesData collectionFinal reportWohaska John Parsons Stiles Gyro · Festus, MOThe pilot's improper propeller adjustment, which resulted in decreased performance and a loss of aircraft control.NTSB ERA13CA420Accident · Minor injuriesData collectionFinal reportRolladen-Schneider LS 6 · Sussex, NJThe pilot's improper selection of an off-airport landing site, and his subsequent failure to maintain clearance from trees during a crosswind landing in gusty wind conditions.NTSB ERA13CA415Accident · No injuriesData collectionFinal reportHawker Beechcraft G36 · Edgartown, MAThe pilot's failure to achieve a proper takeoff profile prior to raising the landing gear resulting in a collision with terrain.NTSB CEN13CA573Accident · No injuriesData collectionFinal reportSchweizer SGS 2 33A · Hampshire, ILThe student pilot's inadequate compensation for landing area conditions during an off-airport landing which resulted in a collision with an obstruction.NTSB WPR13CA395Accident · No injuriesData collectionFinal reportBeech C-50 · Homedale, IDThe pilot's delayed action to arrest a loss of altitude on short final, which resulted in a loss of aircraft control and collision with a fence post.NTSB ERA13LA370Accident · No injuriesLimited investigationFinal reportBeech C23 · Bingham, METhe pilot's inadequate preflight planning, which resulted in his attempt to take off from a short, turf runway in high-density altitude conditions under which the airplane was unable to attain a positive climb rate to clear trees.NTSB ERA13LA339Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Farmingdale, NJThe airplane’s loss of lift shortly after picking up a banner for reasons that could not be determined because postaccident examinations revealed no anomalies that would have precluded normal operation.NTSB WPR13CA333Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-33A · Hood River, ORThe glider encountered atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in an off airport landing on rough terrain.NTSB WPR13CA325Accident · No injuriesData collectionFinal reportBoeing E75 · Bozeman, MTThe pilot’s failure to maintain adequate airspeed during a turn, which resulted in a loss of lift and collision with terrain.NTSB WPR13LA315Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 · Alta, UTThe flight instructor's decision to follow a route over mountainous terrain in conditions that exceeded the helicopter’s ability to maintain terrain clearance.NTSB ERA13CA316Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Blairstown, NJThe flight's encounter with a downdraft from a ridge shortly after takeoff resulting in a loss of lift and collision with terrain during an uncontrolled descent.NTSB WPR13LA295Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Fielding, UTThe pilot's failure to maintain rotor rpm while traversing a canyon in high-density altitude and gusting wind conditions.NTSB CEN13LA371Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Campbell, NEThe pilot's decision to continue with the takeoff roll despite the airplane's difficulty becoming airborne The high-density altitude likely contributed to the airplane's reduced performance.NTSB ERA13CA298Accident · No injuriesData collectionFinal reportBellanca 7KCAB · East Aurora, NYThe pilot's failure to maintain aircraft control during a rejected takeoff on a soft turf runway with a gusty wind, resulting in the airplane nosing over.NTSB ERA13LA264Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1B · Williamson, SCThe pilot’s decision to takeoff with a quartering tailwind at high density altitude, close to gross takeoff weight, on a short turf runway with trees at the departure end.NTSB ERA13CA272Accident · No injuriesData collectionFinal reportPdps Pzl-Bielsko SZD-55-1 · Henderson, NCA loss of aerodynamic lift that resulted in a forced landing to unsuitable terrain.NTSB WPR13CA225Accident · No injuriesData collectionFinal reportCessna 172N · Newcastle, WYThe student pilot's failure to attain the proper touchdown point, which resulted in an undershoot of the runway.NTSB CEN13LA273Accident · Serious injuriesLimited investigationFinal reportPhillips Zenith 250 · Taos, NMThe pilot’s improper decision to take off in gusting wind conditions and the airplane’s loss of climb performance following an encounter with turbulence and downdrafts.NTSB WPR13LA217Accident · No injuriesLimited investigationFinal reportRobinson R44 II · Pomeroy, WAThe pilot's failure to ensure that the helicopter was properly loaded, which resulted in the helicopter being in excess of its maximum allowable gross weight and led to a loss of main rotor rpm on takeoff. Contributing to the accident were the ground…NTSB WPR13LA209Accident · No injuriesLimited investigationFinal reportCessna 172N · Henderson, NVThe pilot’s inadequate preflight planning, including operating in excess of the maximum certified gross weight and center of gravity limits at a high density altitude, which resulted in the airplane’s inability to maintain a positive rate of climb after…NTSB WPR13CA218Accident · No injuriesData collectionFinal reportSchleicher ASW-27 · Middletown, CAThe glider’s encounter with atmospheric lift conditions not sufficient to maintain flight, which resulted in a forced landing on rough terrain.NTSB CEN13LA199Accident · No injuriesLimited investigationFinal reportRyan Navion · Broomfield, COThe pilot's inadequate preflight planning and decision to take off at a high density altitude and in gusting wind conditions.NTSB ANC13CA028Accident · No injuriesData collectionFinal reportCessna 185B · Flat, AKThe pilot's inadequate compensation for gusting, variable wind conditions during initial climb after takeoff.NTSB WPR13CA068Accident · No injuriesData collectionFinal reportRobinson R22 · Logan, UTThe flight instructor’s delayed remedial action and inadequate supervision during a practice autorotation, which resulted in a failure to maintain adequate main rotor rpm. Contributing to the accident was the wet landing surface.NTSB CEN13CA079Accident · Minor injuriesData collectionFinal reportSchweizer SGS 2-32 · Boulder, COThe glider pilot's inability to locate an area of thermal lift.NTSB WPR13FA061Accident · 3 fatalField investigationFinal reportPiper PA28 · Aurora, UTThe pilot's failure to maintain clearance with terrain while maneuvering in a remote mountainous region. Contributing to the accident was the pilot's improper decision to traverse the remote mountainous area in high-density altitude conditions with the…NTSB WPR13CA019Accident · Serious injuriesData collectionFinal reportQuicksilver Mfg MXL II Sport · Live Oak, CAThe pilot’s failure to compensate for turbulent conditions, which resulted in a loss of altitude.NTSB WPR13LA007Accident · Serious injuriesLimited investigationFinal reportSchleicher ASH25M · Kamuela, HIThe pilot’s failure to maintain control of the glider after it encountered atmospheric conditions while maneuvering where the lift was not sufficient to maintain flight, which resulted in a stall and impact with terrain during the subsequent approach to land.NTSB WPR12LA426Accident · No injuriesLimited investigationFinal reportBell 206 - B · Mammoth Lakes, CAThe pilot’s inability to maintain sufficient main rotor rpm while maneuvering in high density altitude conditions, which resulted in a precautionary landing and subsequent rollover.NTSB CEN12LA578Accident · 2 fatalLimited investigationFinal reportDestiny XLT · Hart, MIThe partial deflation of the powered parachute canopy when the pilot flew the aircraft into an area with gusty wind conditions. Contributing to the accident were the modifications that changed the flying characteristics of the parachute.NTSB WPR12CA351Accident · Minor injuriesData collectionFinal reportRobinson R22 · Monticello, UTThe pilot's failure to maintain adequate main rotor rpm while maneuvering at a low altitude, which resulted in the helicopter settling and subsequently colliding with the ground. Contributing to the accident was that the pilot had insufficient altitude to…NTSB ERA12CA462Accident · Serious injuriesData collectionFinal reportInfinity Infinity 2003 · Wilmore, KYA loss of lift on initial climb for unreported reasons, which resulted in a collision with trees and the ground.NTSB WPR12CA304Accident · No injuriesData collectionFinal reportSchempp Hirth Nimbus II · Redmond, ORA loss of aerodynamic lift that resulted in a forced landing on unsuitable terrain.NTSB WPR12LA283Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Stanley, IDThe pilot’s inadequate preflight planning and decision to takeoff at a density altitude outside of the airplane’s takeoff performance envelope, with a tailwind, and near the airplane’s maximum gross weight, which resulted in the airplane’s inability to climb…NTSB WPR12CA278Accident · No injuriesData collectionFinal reportSchweizer SGS 1-36 · Bishop, CAThe glider’s encounter with insufficient atmospheric lift to maintain soaring flight, which resulted in an off-airport landing.NTSB WPR12CA288Accident · Minor injuriesData collectionFinal reportDg-Flugzeugbau DG-500MB · Richland, WAThe failure of the spoilers to retract because the right wing spoiler’s lower plate became jammed, which resulted in the glider not having enough lift to make it to the runway surface.NTSB WPR12FA274Accident · 4 fatalField investigationFinal reportCessna 172 · Veneta, ORThe pilot’s failure to maintain adequate airspeed and altitude to clear trees during the initial climb after takeoff.NTSB CEN12CA375Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Ipswich, SDThe pilot's failure to abort the takeoff, which resulted in a runway excursion.NTSB CEN12LA359Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Santa Teresa, NMThe sudden decrease in headwind during takeoff in a gusty wind and near a passing train, which resulted in a loss of lift and main rotor rpm. Contributing to the accident was the pilot's decision to operate the helicopter near its maximum performance…NTSB CEN12CA361Accident · No injuriesData collectionFinal reportCessna 172H · Moscow Mills, MOThe pilot's failure to maintain control of the airplane during takeoff in a gusty crosswind, which resulted in a runway excursion.