# Final NTSB investigations: Stinson SR-8C

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 NYC91LA014](https://openairdocs.org/ntsb/NYC91LA014.md): Stinson SR8C · Lakeville, MA · Accident · Minor injuries · Limited investigation · Final report · Oct 20, 1990 · N17116 · Substantial damage
  > The pilot misjudged his altitude above the lake water and allowed the airplane to descend while making a left turn. Factor's related to the accident were: calm winds causing the lake water to be glassy.
- [NTSB BFO87LA067](https://openairdocs.org/ntsb/BFO87LA067.md): Stinson SR8B · Lynchburg, VA · Accident · Minor injuries · Limited investigation · Final report · Sep 27, 1987 · N16182 · Substantial damage
  > The pilot diverted to falwell airport due to deteriorating weather and uneven fuel consumption indication between the left and right fuel tanks. During the landing approach for runway 28 the pilot noted the upslope of the runway surface. The pilot misjudged…
- [NTSB MKC77FER31](https://openairdocs.org/ntsb/MKC77FER31.md): Stinson SR-8C · Eveleth, MN · Accident · No injuries · Closed · Apr 10, 1977 · N52875 · 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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8631408'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=8631408&status=final

---
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.