NTSB investigations, 2015
17 cases where the defining event was Loss of lift.
Cases per year
| 2009 | 6 |
|---|---|
| 2010 | 15 |
| 2011 | 7 |
| 2012 | 19 |
| 2013 | 18 |
| 2014 | 13 |
| 2015 | 17 |
| 2016 | 8 |
| 2017 | 8 |
| 2018 | 11 |
| 2019 | 10 |
| 2020 | 9 |
| 2021 | 5 |
| 2022 | 10 |
| 2023 | 2 |
| 2024 | 6 |
| 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\") = 2015
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '500')
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") = 2015 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '500') 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 ERA15LA375Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Ventus 2CT · Blacksburg, VAA loss of thermal lift during a motor glider flight, which resulted in an off-airport landing. Contributing to the accident was the pilot’s failure to maintain adequate clearance from power lines during the off-airport landing attempt.NTSB CEN15LA402Accident · Serious injuriesLimited investigationFinal reportViking Dragonfly · Freeport, ILThe airplane’s degraded climb performance due to its being over its maximum gross weight and a hole in the engine exhaust.NTSB CEN15WA363Accident · Minor injuriesForeign investigationBell 206 - L1 · Lake Peten Izta, GuatemalaOn August 7, 2015, about 1128 Universal Coordinated Time, a Bell 206-L1, Guatemalan-registered TG-MIX, operated by Aereo Services, was substantially damaged when it impacted Lake Peten Itza, Guatemala. Visual meteorological conditions prevailed at the time of…NTSB WPR15LA232Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW 20B · Logan, UTThe pilot’s failure to maintain glider control when it encountered a strong downdraft while maneuvering near a ridgeline.NTSB CEN15LA335Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502B · Virden, ILThe pilot’s failure to establish a proper airspeed during takeoff with the airplane near its maximum gross weight and with a quartering tailwind.NTSB WPR15LA219Accident · Minor injuriesLimited investigationFinal reportGarlick UH1H · Walla Walla, WAThe helicopter’s reduction in aerodynamic lift while operating in variable wind conditions for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures that would have…NTSB ANC15LA056Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Dillingham, AKThe pilot's failure to attain adequate airspeed during initial climb after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's improper decision to continue a takeoff even though the airplane was not airborne by the…NTSB CEN15LA301Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-140 · Oakdale, LAThe pilot's inadequate preflight planning resulting in the airplane not having adequate performance to climb and clear the trees off the end of the dirt runway.NTSB GAA15CA147Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Kailua-Kona, HIThe flight instructor's decision to conduct a high altitude pinnacle landing without adequate power, which resulted in the helicopter impacting terrain during the approach. Contributing to the accident was the density altitude at the high altitude pinnacle…NTSB ERA15CA242Accident · Serious injuriesData collectionFinal reportPenell Mark A Rans S-10 KIT · Kirkville, NYPilot's failure to maintain airspeed while maneuvering during the initial climb, which resulted in a loss of lift and subsequent off airport landing. Contributing to the accident was the pilot's failure to abort the takeoff after recognizing the airplane's…NTSB ERA15LA238Accident · No injuriesLimited investigationFinal reportCessna T210 · Palmyra, PAThe pilot's delay in conducting an aborted landing and his subsequent failure to establish a proper airspeed during the attempted go-around on a hot day, which resulted in the airplane’s inability to climb and a subsequent stall/mush.NTSB GAA15CA109Accident · Minor injuriesData collectionFinal reportKretsinger Bensen B8M · Maple Plain, MNThe pilot's failure to maintain airspeed, resulting in a loss of control, and a collision with terrain.NTSB CEN15LA276Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Branch, LAAn exceedance of the airplane's takeoff/climb capability, which resulted in a stall during initial climb at an altitude that was too low for recovery.NTSB GAA15CA062Accident · No injuriesData collectionFinal reportIssoire Siren PIK 30 · Deer Park, WAA loss of lift, which precipitated a forced off airport landing, and collision with terrain.NTSB CEN15LA252Accident · No injuriesLimited investigationFinal reportMichael Wilson Murphy Spirit · Livingston, TXThe pilot’s failure to maintain adequate airspeed, which increased the induced drag and led to the engine having insufficient power to overcome the drag and climb the airplane and resulted in a forced landing and the subsequent collapse of the main landing…NTSB GAA15CA028Accident · Minor injuriesData collectionFinal reportLet L23 - NO Series · Los Alamitos, CAThe inadvertent deployment of the air brakes during initial climb, resulting in a loss of lift. Contributing to the accident was the pilot's failure to identify and remediate the cause.NTSB CEN15LA183Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Gordonville, TXThe pilot's decision to depart from an upsloping, soft grass runway at or near the airplane's maximum gross weight and with a high density altitude, which increased the airplane's ground roll and placed the airplane in close proximity to trees during the…