# NTSB investigations: Stinson 108-1, 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 BFO93LA104](https://openairdocs.org/ntsb/BFO93LA104.md): Stinson 108-1 · Culpeper, VA · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 1993 · N9014K · Substantial damage
  > The pilot's failure to maintain directional control during landing rollout. A factor related to the accident include a ditch.
- [NTSB BFO86LA004](https://openairdocs.org/ntsb/BFO86LA004.md): Stinson 108-1 Voyager · The Plains, VA · Accident · No injuries · Limited investigation · Final report · Oct 19, 1985 · N8422K · Substantial damage
  > While flying straight and level at 3100 feet MSL, over Virginia route 66 and route 245, the engine began to vibrate to the extent that the plt thought that it might separate from the airframe. The plt selected a field and set up an approach. On final, the plt…
- [NTSB IAD70F0083](https://openairdocs.org/ntsb/IAD70F0083.md): Stinson 108-1 · Prince George, VA · Accident · Serious injuries · Closed · Sep 13, 1969 · N8503K · Destroyed
- [NTSB NYC66F0263](https://openairdocs.org/ntsb/NYC66F0263.md): Stinson 108-2 · Alexandria, VA · Accident · No injuries · Closed · Sep 16, 1965 · N9774K · Substantial damage
- [NTSB UNK64X0161](https://openairdocs.org/ntsb/UNK64X0161.md): Stinson 108-1 · Chesapeake, VA · Accident · No injuries · Closed · Jan 5, 1964 · N97861 · 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 ('9230404'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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