# NTSB investigations: Stinson 108-1, 1982

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 LAX83LUQ02](https://openairdocs.org/ntsb/LAX83LUQ02.md): Stinson 108 · Santa Barbara, CA · Accident · 2 fatal · Final report · Nov 23, 1982 · N222W · Destroyed
  > The aircraft collided with a power line as the pilot was flying at low altitude near a highway at dusk. After hitting the power line, the plane fell to the ground and burned. Witnesses reported there was a low cloud cover and light rain. One witness stated…
- [NTSB SEA82DA158](https://openairdocs.org/ntsb/SEA82DA158.md): Stinson 108-1 · Twin Falls, ID · Accident · No injuries · Final report · Sep 8, 1982 · N97781 · Substantial damage
  > Pilot ground looped while doing touch and go landings. Wind 5 KTS.
- [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…

## 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 year(c."eventDate") = 1982
  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&year=1982

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