# NTSB investigations: Stinson 108-2, 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 GAA17CA153](https://openairdocs.org/ntsb/GAA17CA153.md): Stinson 108 · Valparaiso, IN · Accident · No injuries · Data collection · Final report · Feb 20, 2017 · N9277K · Substantial damage
  > The pilot’s failure to maintain directional control while landing with a crosswind.
- [NTSB CHI98LA278](https://openairdocs.org/ntsb/CHI98LA278.md): Stinson 108-1 · Bloomington, IN · Accident · Serious injuries · Limited investigation · Final report · Jul 27, 1998 · N483C · Destroyed
  > A loss of engine power due to a fractured number 5 and number 6 cylinder connecting rods for undetermined reasons.
- [NTSB CHI83LA189](https://openairdocs.org/ntsb/CHI83LA189.md): Stinson 108-2 · Greencastle, IN · Accident · Minor injuries · Limited investigation · Final report · Apr 25, 1983 · N9703K · Destroyed
  > The acft experienced power loss at about 300 feet AGL after takeoff. The pilot landed in a cornfield after attempting a restart of the engine. The pilot had put 5 gallons of fuel in the right tank on the day of the accident in preparation for a test flight.…
- [NTSB CHI78DEX13](https://openairdocs.org/ntsb/CHI78DEX13.md): Stinson 108-2 · Connersville, IN · Accident · No injuries · Closed · Feb 26, 1978 · N9451K · Substantial damage
- [NTSB CHI68F0336](https://openairdocs.org/ntsb/CHI68F0336.md): Piper PA-22 · Greenfield, IN · Accident · Serious injuries · Closed · Sep 10, 1967 · N3740P · 2 aircraft · Substantial damage
- [NTSB CHI68D0160](https://openairdocs.org/ntsb/CHI68D0160.md): Stinson 108 · Hobart, IN · Accident · No injuries · Closed · Jun 30, 1967 · N9788K · Substantial damage
- [NTSB CHI67D0532](https://openairdocs.org/ntsb/CHI67D0532.md): Stinson 108-2 · Clinton, IN · Accident · No injuries · Closed · Feb 2, 1967 · N9276K · Substantial damage
- [NTSB CHI66A0060](https://openairdocs.org/ntsb/CHI66A0060.md): Piper PA-23 · Knox, IN · Accident · 3 fatal · Closed · Dec 19, 1965 · N1100P · 2 aircraft · Destroyed

## 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 ('9230406'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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