# NTSB investigations: Cessna 120, 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 NYC98LA007](https://openairdocs.org/ntsb/NYC98LA007.md): Cessna 120 · Prince George, VA · Accident · No injuries · Limited investigation · Final report · Oct 6, 1997 · N1856N · Substantial damage
  > The pilot's failure to attain takeoff climb, and his delay in aborting the takeoff. A contributing factor was soft terrain.
- [NTSB BFO89LA008](https://openairdocs.org/ntsb/BFO89LA008.md): Cessna 207 · Topping, VA · Accident · No injuries · Limited investigation · Final report · Nov 12, 1988 · N73114 · 2 aircraft · Minor damage
  > The pilot of N76470 departed on rwy 18 and followed the noise abatement procedure before turning downwind for rwy 18. The pilot of N73114 departed the grass rwy 18 and flew the noise abatement procedure prior to turning to a heading of 070 deg to depart the…
- [NTSB BFO85FA070](https://openairdocs.org/ntsb/BFO85FA070.md): Cessna 120 · Afton, VA · Accident · 2 fatal · Field investigation · Final report · Aug 24, 1985 · N1812V · Destroyed
  > The plt and his wife departed waynesboro arpt in reported VFR wx conditions at aprx 1700 hrs. According to the assistantarpt mgr the ceiling was about 2500 ft however, the mountain tops were obscured in the direction the acft flew towards. At about 1710 hrs…
- [NTSB IAD80FID11](https://openairdocs.org/ntsb/IAD80FID11.md): Cessna 120 · Camp Hill, VA · Accident · Serious injuries · Closed · Mar 18, 1980 · N72193 · Destroyed
- [NTSB IAD70DIJ05](https://openairdocs.org/ntsb/IAD70DIJ05.md): Cessna 120 · Dublin, VA · Accident · No injuries · Closed · Aug 26, 1970 · N72544 · Substantial damage
- [NTSB NYC67D0346](https://openairdocs.org/ntsb/NYC67D0346.md): Cessna 120 · Waynesboro, VA · Accident · No injuries · Closed · Nov 5, 1966 · N1805N · 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 ('2071402'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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