NTSB investigations, 2013
23 cases where the sequence of events included Loss of lift.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 7 |
| 2010 | 21 |
| 2011 | 14 |
| 2012 | 24 |
| 2013 | 23 |
| 2014 | 18 |
| 2015 | 22 |
| 2016 | 19 |
| 2017 | 13 |
| 2018 | 18 |
| 2019 | 17 |
| 2020 | 11 |
| 2021 | 8 |
| 2022 | 13 |
| 2023 | 3 |
| 2024 | 7 |
| 2025 | 7 |
| 2026 | 4 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 2013
AND 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 year(c."eventDate") = 2013 AND 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 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.