# NTSB investigations: Continental C145 series, 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 ERA24LA150](https://openairdocs.org/ntsb/ERA24LA150.md): Cessna 170 · Chesapeake, VA · Accident · No injuries · Class 4 · Limited · Final report · Mar 21, 2024 · N9269A · Substantial damage
  > The pilot’s failure to maintain directional control during landing, which resulted in a ground loop, runway excursion, and subsequent landing gear collapse.
- [NTSB GAA17CA091](https://openairdocs.org/ntsb/GAA17CA091.md): Cessna 170 · Martinsville, VA · Accident · No injuries · Data collection · Final report · Dec 5, 2016 · N9002A · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll.
- [NTSB NYC03LA141](https://openairdocs.org/ntsb/NYC03LA141.md): Cessna 170B · Brandy Station, VA · Accident · No injuries · Limited investigation · Final report · Jun 29, 2003 · N2741C · Substantial damage
  > The pilot's improper flare and his improper recovery from a bounced landing.
- [NTSB IAD02LA034](https://openairdocs.org/ntsb/IAD02LA034.md): Cessna 170 · Fredericksburg, VA · Accident · Serious injuries · Limited investigation · Final report · Feb 23, 2002 · N3832V · Substantial damage
  > The unauthorized modification of the air control box by unknown persons, and the failure of subsequent mechanics to note and correct the deficiency. Factors included the carburetor icing conditions and the unsuitable terrain mandated by the forced landing.
- [NTSB BFO90LA033](https://openairdocs.org/ntsb/BFO90LA033.md): Cessna 170B · Winchester, VA · Accident · No injuries · Limited investigation · Final report · Apr 1, 1990 · N2521C · Substantial damage
  > The pilot's failure to assure that the airplane would clear the fence after takeoff.
- [NTSB IAD74DIJ07](https://openairdocs.org/ntsb/IAD74DIJ07.md): Aeronca 15AC · Covington, VA · Accident · Minor injuries · Closed · Sep 30, 1973 · N1122H · Substantial damage
- [NTSB IAD71FIA04](https://openairdocs.org/ntsb/IAD71FIA04.md): Globe GC-1B · Manassas, VA · Accident · No injuries · Closed · Aug 15, 1970 · N78111 · Substantial damage
- [NTSB DIA69F0019](https://openairdocs.org/ntsb/DIA69F0019-109766.md): Cessna 170 · Richmond, VA · Accident · No injuries · Closed · Jul 1, 1968 · N2416D · 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.engine_model_code IN ('17012'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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