# NTSB investigations: Stinson 108-1: In flight encounter with weather

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 LAX87LA143](https://openairdocs.org/ntsb/LAX87LA143.md): Stinson 108-1 · Saugus, CA · Accident · No injuries · Limited investigation · Final report · Mar 13, 1987 · N8185K · Substantial damage
  > Upon contacting ATC, the plt requested an ILS apch and that he was low on fuel. The controller cleared the plt to the ILS. Just inside the outer marker the controller advised the plt that he was dangerously low and to climb immediately. The plt was observed…
- [NTSB SEA86LA251](https://openairdocs.org/ntsb/SEA86LA251.md): Stinson 108-1 · Grangeville, ID · Accident · 2 fatal · Limited investigation · Final report · Apr 27, 1986 · N8165K · Destroyed
  > Plt called fss over lws for wx brief lws-bke-boi. VFR not recommended for route, mountains obscured in rain showers. Plt called fss 30 min later, reported lost in clouds attempting route. Radio contact lost before location established (2305 MST, 04-26-86).…
- [NTSB NYC83LA216](https://openairdocs.org/ntsb/NYC83LA216.md): Stinson 108-1 · Tully, NY · Accident · No injuries · Limited investigation · Final report · Aug 18, 1983 · N8470K · Destroyed
  > At 2,000 ft near syracuse the plt decided he had enough fuel to continue on to his home base at cortland. He added full power to climb back to 3,000 ft & encountered turbulence. With full power & 80 KTS indicated the acft was losing altitude. The acft…
- [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…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9230404')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=9230404&occurrence=240

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