# NTSB investigations: Cessna 177B, 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 ERA23LA094](https://openairdocs.org/ntsb/ERA23LA094.md): Cessna 177 · Franklin, VA · Accident · Minor injuries · Class 4 · Limited · Final report · Dec 26, 2022 · N177D · Substantial damage
  > The pilot’s failure to maintain clearance from trees during the initial climb following an aborted precautionary landing. Contributing to the outcome were the inoperative runway lights, which reduced the likelihood that the pilot could successfully land the…
- [NTSB ERA13LA258](https://openairdocs.org/ntsb/ERA13LA258.md): Cessna 177B · Herndon, VA · Accident · Minor injuries · Limited investigation · Final report · May 31, 2013 · N177FG · Substantial damage
  > The pilot’s inadequate preflight planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.
- [NTSB IAD02LA060](https://openairdocs.org/ntsb/IAD02LA060.md): Cessna 177B · Chesterfield, VA · Accident · Minor injuries · Limited investigation · Final report · Jun 18, 2002 · N2182C · Substantial damage
  > pilot's improper flare, which resulted in a hard landing at night.
- [NTSB BFO86FA044](https://openairdocs.org/ntsb/BFO86FA044.md): Cessna 177B · Springfield, VA · Accident · 1 fatal · Field investigation · Final report · Sep 6, 1986 · N34953 · Substantial damage
  > According to the plt, the eng bgn running rough drg flt, then clrd & ran smoothly again. He rprtd he elected to abort the flt & made a turn, then svrl min later, the eng lost pwr. Drg an emerg lndg in a parking lot, the l main gear hit anauto & fatally…
- [NTSB IAD78FIA01](https://openairdocs.org/ntsb/IAD78FIA01.md): Cessna 177 · Nokesville, VA · Accident · Minor injuries · Closed · Dec 4, 1977 · N35104 · Substantial damage
- [NTSB IAD76DID35](https://openairdocs.org/ntsb/IAD76DID35.md): Cessna 177 · Danville, VA · Accident · No injuries · Closed · Jul 12, 1976 · N34829 · Substantial damage
- [NTSB IAD75DIJ09](https://openairdocs.org/ntsb/IAD75DIJ09.md): Cessna 177B · Volney, VA · Accident · No injuries · Closed · Dec 17, 1974 · N34477 · Destroyed
- [NTSB IAD74FIA15](https://openairdocs.org/ntsb/IAD74FIA15.md): Cessna 177B · Winchester, VA · Accident · Minor injuries · Closed · May 6, 1974 · N34636 · 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 ('2073708'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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