Final NTSB investigations, 2020
9 cases where the sequence of events included Loss of lift.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 7 |
| 2010 | 20 |
| 2011 | 13 |
| 2012 | 24 |
| 2013 | 23 |
| 2014 | 18 |
| 2015 | 21 |
| 2016 | 19 |
| 2017 | 13 |
| 2018 | 16 |
| 2019 | 15 |
| 2020 | 9 |
| 2021 | 8 |
| 2022 | 13 |
| 2023 | 3 |
| 2024 | 7 |
| 2025 | 6 |
| 2026 | 3 |
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\") = 2020
AND c.\"completionStatus\" = 'Completed'
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") = 2020 AND c."completionStatus" = 'Completed' 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 WPR20CA273Accident · No injuriesClass 4 · Data collectionFinal reportSchweizer SGS233 · Warner Springs, CAThe pilot's inability to maintain altitude due to a loss of thermal lift, which resulted in an off-airport landing.NTSB CEN20CA307Accident · Serious injuriesClass 4 · Data collectionFinal reportVans Vans RV 6 · Imperial, NEThe pilot's inadequate preflight performance planning and his decision not to utilize all available runway during high density altitude operations which led to an inflight loss of control and subsequent collision with terrain.NTSB CEN20CA277Accident · Minor injuriesClass 4 · Data collectionFinal reportKitfox Kitfox Sport · Rand, COThe encounter with the downdrafts during the attempted takeoff, which resulted in decreased airplane's climb performance and subsequent impact with terrain.NTSB ERA20LA219Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · McAlpin, FLThe pilot’s failure to abort the takeoff after recognizing poor airplane acceleration, the reason for which could not be determined based on available evidence. Contributing to the accident was the pilot’s likely inadvertent initiation of the takeoff with the…NTSB CEN20CA218Accident · No injuriesClass 4 · Data collectionFinal reportGlasflugel Mosquito · Alvarado, TXThe pilot's decision to divert to the private airport and his subsequent failure to maintain directional control while landing on a turf runway that contained tall grass.NTSB CEN20LA203Accident · Minor injuriesClass 3 · LimitedFinal reportMagni Magni M 16 · Cape Girardeau, MOThe student pilot’s decision to take off with inadequate runway remaining, and his subsequent failure to attain proper airspeed, which resulted in the gyroplane’s descent into terrain.NTSB WPR20CA151Accident · No injuriesClass 4 · Data collectionFinal reportLet L 33 Solo · Arlington, WAThe loss of lift while on final approach which resulted in a hard off-airport landing.NTSB ERA20CA178Accident · Minor injuriesClass 4 · Data collectionFinal reportSchempp Hirth Ventus 2CT · Stuarts Draft, 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 delayed attempted engine start.NTSB ERA20CA151Accident · No injuriesData collectionFinal reportPipistrel Sinus · Townsend, TNThe motor glider's encounter with atmospheric lift conditions that were not sufficient to maintain flight, which necessitated a forced landing and resulted in impact with vegetation. Contributing to the accident was the pilot's delayed decision to restart the…