NTSB investigations, 2021
8 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\") = 2021
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") = 2021 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 CEN22LA078Accident · Minor injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 407 · Bridgeport, TXThe pilot’s failure to maintain adequate main rotor RPM during an autorotation which resulted in a hard landing. Contributing to the accident was the pilot’s improper placement of the throttle during the initial practice power-on recovery autorotation.NTSB WPR22LA007Accident · Serious injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-32 · San Juan Baptista, CAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which necessitated a forced landing.NTSB CEN21LA471Accident · Serious injuriesClass 4 · LimitedFinal reportJust Highlander · West Cobb, ARThe airplane’s encounter with gusting wind conditions and low-level wind shear on final approach, which resulted in a loss of control, an aerodynamic stall, and a subsequent hard landing.NTSB WPR21LA290Accident · Minor injuriesClass 4 · LimitedFinal reportBurkhart Grob G 103 Twin II · Levan, UTThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight which resulted in an off-airport landing and a collision with a fence.NTSB ERA21LA280Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Bishopville, SCThe flight instructor’s inadequate supervision of the student during a go-around, which resulted in a loss of lift and a subsequent collision with the VASI lights.NTSB WPR21LA235Accident · Minor injuriesClass 4 · LimitedFinal reportHPH Glasflugel · Winthrop, WAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.NTSB ERA21LA276Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-26E · Willimantic, CTThe failure of the student to achieve the proper touchdown point resulting in landing undershoot.NTSB ERA21LA395Accident · Serious injuriesClass 4 · LimitedFinal reportSchempp Hirth Ventus C · Wagener, SCImpact with trees during a forced landing in atmospheric lift conditions that were insufficient to maintain flight. Contributing was the pilot’s delayed decision to return to the airport.