# NTSB investigations: Lycoming AEIO-360 series, CO

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 GAA17CA125](https://openairdocs.org/ntsb/GAA17CA125.md): Great Lakes 2T1A · Canon City, CO · Accident · No injuries · Data collection · Final report · Jan 28, 2017 · N16GL · Substantial damage
  > The pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was the pilot’s unstabilized approach.
- [NTSB CEN11CA485](https://openairdocs.org/ntsb/CEN11CA485.md): Bellanca 8KCAB · Greeley, CO · Accident · No injuries · Data collection · Final report · Jul 16, 2011 · N731JD · Substantial damage
  > The pilot's loss of directional control during landing, resulting in a runway excursion.
- [NTSB DEN06FA018](https://openairdocs.org/ntsb/DEN06FA018.md): American Champion 8KCAB · Calhan, CO · Accident · 1 fatal · Field investigation · Final report · Nov 21, 2005 · N70MT · Destroyed
  > the pilot's failure to maintain aircraft control. Factors contributing to the accident were the low altitude, and the resultant stall/spin.
- [NTSB DEN01FA053](https://openairdocs.org/ntsb/DEN01FA053.md): Ross G-202 · Grand Junction, CO · Accident · 1 fatal · Field investigation · Final report · Feb 16, 2001 · N39HR · Destroyed
  > the pilot's inadvertent entry into a spin while performing aerobatic maneuvers. A contributing factor was the pilot's lack of aerobatic experience.
- [NTSB FTW95LA381](https://openairdocs.org/ntsb/FTW95LA381.md): Great Lakes 2T-1A-2 · Boulder, CO · Accident · No injuries · Limited investigation · Final report · Sep 4, 1995 · N5761G · Substantial damage
  > Failure by the pilot to maintain control of the aircraft during landing roll.
- [NTSB DEN88LA027](https://openairdocs.org/ntsb/DEN88LA027.md): Piper PA-24-180 · Broomfield, CO · Accident · No injuries · Limited investigation · Final report · Nov 23, 1987 · N7291P · Substantial damage
  > The private pilot was flying to build time. After an hour of flight, the plt returned to the home airport and attempted to land. Landing gear would not extend properly and manual gear extension did not help. All gear was partially extended and would not…
- [NTSB DEN82DA188](https://openairdocs.org/ntsb/DEN82DA188.md): Piper PA-24-180 · Pueblo, CO · Accident · Serious injuries · Final report · Sep 6, 1982 · N7291P · Substantial damage
  > The aircraft landed at rueblo, CO for fuel on a return flight to Texas. After landing, the pilot asked a female attendant if there were any liquor stores open. The pilot returned to the airport about 1/2 hour later and observed the pilot carrying a brown…

## 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41522', '41601'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=41522&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.
