# NTSB investigations: Cessna 172RG, 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 NYC97LA158](https://openairdocs.org/ntsb/NYC97LA158.md): Cessna 172 RG · Quinton, VA · Accident · No injuries · Limited investigation · Final report · Aug 3, 1997 · N9647B · Substantial damage
  > The pilot's failure to identify an unsafe landing gear condition. A factor in the accident was the loss of electrical power.
- [NTSB NYC94FA119](https://openairdocs.org/ntsb/NYC94FA119.md): Cessna 172RG · Kiptopeka, VA · Accident · 1 fatal · Field investigation · Final report · Jul 11, 1994 · N6624R · 2 aircraft · Destroyed
  > Inadequate visual lookout by the flightcrew of the helicopter. A factor related to the accident was: failure of the departure controller to issue a traffic advisory.
- [NTSB BFO90DID01](https://openairdocs.org/ntsb/BFO90DID01.md): Cessna 172RG · Onancock, VA · Accident · 2 fatal · Final report · Aug 20, 1990 · N6599R · Substantial damage
  > The inflight loss of control because the pilot experienced spatial disorientation. Other factors related to the accident are VFR flight into IMC, night conditions.
- [NTSB BFO88LA048](https://openairdocs.org/ntsb/BFO88LA048.md): Cessna 172RG · Mathew, VA · Accident · No injuries · Limited investigation · Final report · May 14, 1988 · N6449R · Substantial damage
  > The plt stated he did a soft field takeoff using 10 degs of flaps. The acft lifted off at about 55 to 60 KTS but according to the plt, was unable to climb out of groundeffect. Since he was too FAR down the rwy to abort the takeoff the plt increased pitch to…
- [NTSB ATL84FA095](https://openairdocs.org/ntsb/ATL84FA095.md): Cessna 172RG · Chesapeake, VA · Accident · 1 fatal · Field investigation · Final report · Feb 12, 1984 · N5299U · Destroyed
  > Prior to departure, the plt was twice advised that the destination wx was below most users minimums. The non-instrument rated plt then departed dulles arpt on an IFR flt plan in IMC. After departure, he did not follow assigned headings, & for a period of…

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

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