# NTSB investigations: Cessna 172L, 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 CEN21LA119](https://openairdocs.org/ntsb/CEN21LA119.md): Cessna 172 · Silt, CO · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 31, 2021 · N4376Q · Destroyed
  > The pilot’s failure to avoid powerlines while flying at low altitude.
- [NTSB GAA16CA058](https://openairdocs.org/ntsb/GAA16CA058.md): Cessna 172 · Greeley, CO · Accident · No injuries · Data collection · Final report · Nov 15, 2015 · N4256Q · 2 aircraft · Substantial damage
  > The pilot of the following airplane failed to maintain adequate spacing during the taxi to the runway, resulting in a collision with the lead airplane.
- [NTSB DEN99LA085](https://openairdocs.org/ntsb/DEN99LA085.md): Cessna 172L · Gunnison, CO · Accident · No injuries · Limited investigation · Final report · May 25, 1999 · N172KB · Substantial damage
  > The pilot's inadvertent stall/mush immediately after takeoff. Factors were the high density altitude weather condition, and the pilot's total lack of experience in type of operation.
- [NTSB FTW96LA290](https://openairdocs.org/ntsb/FTW96LA290.md): Cessna 172L · Johnstown, CO · Accident · No injuries · Limited investigation · Final report · Jul 1, 1996 · N19682 · Substantial damage
  > failure of the pilot to maintain proper altitude/clearance from obstructions, while buzzing.
- [NTSB FTW94LA106](https://openairdocs.org/ntsb/FTW94LA106.md): Cessna 172L · Buena Vista, CO · Accident · No injuries · Limited investigation · Final report · Mar 18, 1994 · N7876G · Substantial damage
  > The improper supervision of the instructor pilot. A factor was the loss of directional control by the student pilot.
- [NTSB DEN79FTE52](https://openairdocs.org/ntsb/DEN79FTE52.md): Cessna 172 · Lindon, CO · Accident · Minor injuries · Closed · Jun 24, 1979 · N3920Q · Destroyed
- [NTSB DEN78FTE71](https://openairdocs.org/ntsb/DEN78FTE71.md): Cessna 172L · Louviers, CO · Accident · Serious injuries · Closed · Jul 3, 1978 · N4258Q · Substantial damage
- [NTSB DEN78DTE44](https://openairdocs.org/ntsb/DEN78DTE44.md): Cessna 172L · Falcon, CO · Accident · No injuries · Closed · Apr 2, 1978 · N4376Q · Substantial damage
- [NTSB DEN73FTE54](https://openairdocs.org/ntsb/DEN73FTE54.md): Cessna 172 · Salida, CO · Accident · No injuries · Closed · Feb 10, 1973 · N9859G · Substantial damage
- [NTSB DEN72DTE44](https://openairdocs.org/ntsb/DEN72DTE44.md): Cessna 172 · Fountain, CO · Accident · Minor injuries · Closed · Nov 20, 1971 · N4339Q · Substantial damage

## 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.aircraft_model_code IN ('2072432'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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