# NTSB investigations: Stinson 108-1, IN

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 CHI91LA251](https://openairdocs.org/ntsb/CHI91LA251.md): Stinson 108-1 · Elwood, IN · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 1991 · N8619K · Substantial damage
  > A premature lift-off which resulted in a mush/stall. A factor related to the accident was lack of total experience in type of operation.
- [NTSB CHI82DA272](https://openairdocs.org/ntsb/CHI82DA272.md): Stinson 108-1 · Laporte, IN · Accident · No injuries · Final report · Jul 24, 1982 · N97904 · Substantial damage
  > The pilot/mechanic was preparing to make an annual inspection of the aircraft. He was in the process of flight testing the plane to find defects when engine stoppage occurred. While landing in a bean field. The left tire blew out and the left gear dug into…
- [NTSB CHI68A0074](https://openairdocs.org/ntsb/CHI68A0074.md): Piper PA-28 · Ranklin, IN · Accident · 2 fatal · Closed · Feb 18, 1968 · N9516W · 2 aircraft · Destroyed
- [NTSB CHI68D0014](https://openairdocs.org/ntsb/CHI68D0014.md): Stinson 108-1 · Scottsburg, IN · Accident · No injuries · Closed · May 26, 1967 · N8361K · 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" = 'IN' 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=IN

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