# NTSB investigations, CO: Dragged wing,rotor,pod,float or tail/skid

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 DEN03LA097](https://openairdocs.org/ntsb/DEN03LA097.md): Bell 206B III · Broomfield, CO · Accident · No injuries · Limited investigation · Final report · May 31, 2003 · N382SP · Substantial damage
  > the student pilot's failure to maintain aircraft control and the instructor's inadequate supervision.
- [NTSB DEN03FA090](https://openairdocs.org/ntsb/DEN03FA090.md): Hughes 269C · Watkins, CO · Accident · 1 fatal · Field investigation · Final report · May 28, 2003 · N9643F · Destroyed
  > failure of both pilots to initiate a timely recovery from a practice autorotation. A contributing factor was the instructor's inadequate supervision of the pilot receiving instruction.
- [NTSB FTW98LA168](https://openairdocs.org/ntsb/FTW98LA168.md): Boeing A75N (PT-17) · Grand Junction, CO · Accident · No injuries · Limited investigation · Final report · Mar 24, 1998 · N59448 · Substantial damage
  > Failure by the pilot to maintain control of the aircraft during landing roll. Factors were variable winds and the pilot's lack of recent experience in make and model.
- [NTSB DEN89LA140](https://openairdocs.org/ntsb/DEN89LA140.md): Schweizer 1-26E · Elbert, CO · Accident · No injuries · Limited investigation · Final report · Jun 18, 1989 · N65910 · Substantial damage
  > The pilot's improper inflight planning which placed the aircraft too FAR from the runway to complete a normal landing.
- [NTSB DEN86LA158](https://openairdocs.org/ntsb/DEN86LA158.md): Beaver Evans VP-1 · Glade Park, CO · Accident · No injuries · Limited investigation · Final report · Jun 8, 1986 · N23RB · Substantial damage
  > The plt said that during the take-off roll, high grass restricted the acft from attaining sufficient airspeed to achieve flt. According to the plt the acft struck a barbed wire fence, substantially damaging the acft.
- [NTSB DEN83FTE10](https://openairdocs.org/ntsb/DEN83FTE10.md): Douglas DC-3C · Englewood, CO · Accident · No injuries · Final report · May 30, 1983 · N29958 · Substantial damage
  > The acft dragged a wing during landing touchdown in IMC weather conditions. The pilot had broken out misaligned with therwy. As the airspeed decayed during the transition from IFR to VFR the co-pilot took control because he thought he couldsee the rwy better.…

## 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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 160)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=160&state=CO

---
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.
