# Final NTSB investigations, CO: Loss of lift

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB CEN22FA240](https://openairdocs.org/ntsb/CEN22FA240.md): HPH Spol Sro Glasflugel 304 MS · Rifle, CO · Accident · 1 fatal · Class 3 · Field · Final report · Jun 9, 2022 · N249SD · Destroyed
  > The glider’s encounter with gusting tailwind and downdraft conditions that the pilot was unable to overcome.
- [NTSB CEN22LA110](https://openairdocs.org/ntsb/CEN22LA110.md): Diamond Aircraft Ind DA20-C1 · Fort Carson, CO · Accident · No injuries · Class 4 · Limited · Final report · Jan 25, 2022 · N974DA · Substantial damage
  > The windshear encounter on short final approach, which resulted in an excessive decent rate and ground impact.
- [NTSB CEN20CA277](https://openairdocs.org/ntsb/CEN20CA277.md): Kitfox Kitfox Sport · Rand, CO · Accident · Minor injuries · Class 4 · Data collection · Final report · Jul 12, 2020 · N702KS · Substantial damage
  > The encounter with the downdrafts during the attempted takeoff, which resulted in decreased airplane's climb performance and subsequent impact with terrain.
- [NTSB CEN19LA162](https://openairdocs.org/ntsb/CEN19LA162.md): Robinson R44 · Last Chance, CO · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 8, 2019 · N4504L · Substantial damage
  > The pilot's failure to maintain adequate main rotor rpm while descending with a tailwind during an aerial application maneuver, which resulted in an uncontrolled descent into terrain.
- [NTSB GAA19CA208](https://openairdocs.org/ntsb/GAA19CA208.md): Airframes Unlimited Outlaw · Elizabeth, CO · Accident · Serious injuries · Data collection · Final report · Apr 15, 2019 · N5622D · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his subsequent decision to initiate a turn, which resulted in the powered parachute’s descent and impact with a fence.
- [NTSB CEN13LA199](https://openairdocs.org/ntsb/CEN13LA199.md): Ryan Navion · Broomfield, CO · Accident · No injuries · Limited investigation · Final report · Mar 15, 2013 · N4276K · Substantial damage
  > The pilot's inadequate preflight planning and decision to take off at a high density altitude and in gusting wind conditions.
- [NTSB CEN13CA079](https://openairdocs.org/ntsb/CEN13CA079.md): Schweizer SGS 2-32 · Boulder, CO · Accident · Minor injuries · Data collection · Final report · Nov 29, 2012 · N9929J · Substantial damage
  > The glider pilot's inability to locate an area of thermal lift.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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."eventStateOrRegion" = 'CO' AND c."eventCountry" = 'USA'
  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
```

This list as a web page: https://openairdocs.org/ntsb-events/500/sequence?state=CO&status=final

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.
