# NTSB investigations: Cessna 177, VA

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 ERA15LA354](https://openairdocs.org/ntsb/ERA15LA354.md): Cessna 177 · Moneta, VA · Accident · Serious injuries · Limited investigation · Final report · Sep 13, 2015 · N2835X · Substantial damage
  > The pilot's premature retraction of the wing flaps and his subsequent failure to maintain pitch control during an attempted go-around, which resulted in the airplane exceeding its critical angle-of-attack and an aerodynamic stall. Contributing to the accident…
- [NTSB NYC04CA200](https://openairdocs.org/ntsb/NYC04CA200.md): Cessna 177 · Warrenton, VA · Accident · No injuries · Data collection · Final report · Aug 29, 2004 · N2975X · Substantial damage
  > The pilot's incorrect aborted landing procedure, which resulted in a collision with terrain.
- [NTSB BFO88LA017](https://openairdocs.org/ntsb/BFO88LA017.md): Cessna 177 · Petersburg, VA · Accident · Minor injuries · Limited investigation · Final report · Feb 6, 1988 · N313AC · Substantial damage
  > The plt hand-propped the engine when he was unable to start it using the starter. The acft had just been refueled and it was standing next to the fuel pumps. The plt pushed the acft away from the pumps before he tried to hand-prop it. After the third…
- [NTSB IAD77DID19](https://openairdocs.org/ntsb/IAD77DID19.md): Cessna 177 · Waynesboro, VA · Accident · No injuries · Closed · May 14, 1977 · N29306 · Substantial damage
- [NTSB IAD76DID38](https://openairdocs.org/ntsb/IAD76DID38.md): Cessna 177 · Roanoke, VA · Accident · No injuries · Closed · Aug 13, 1976 · N2336Y · Substantial damage
- [NTSB NYC72DIA05](https://openairdocs.org/ntsb/NYC72DIA05.md): Cessna 177 · Manassas, VA · Accident · No injuries · Closed · Sep 9, 1971 · N29562 · Substantial damage
- [NTSB IAD71AI053](https://openairdocs.org/ntsb/IAD71AI053.md): Cessna 177 · New Castle, VA · Accident · 4 fatal · Closed · May 27, 1971 · N2271Y · Destroyed
- [NTSB DIA69F0132](https://openairdocs.org/ntsb/DIA69F0132.md): Cessna 177 · Waynesboro, VA · Accident · Serious injuries · Closed · Dec 20, 1968 · N3165T · 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" = 'VA' 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 ('2073704'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2073704&state=VA

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