# NTSB investigations: Stinson 108: Loss of control - in flight

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 LAX07CA152](https://openairdocs.org/ntsb/LAX07CA152.md): Stinson 108 · Auburn, CA · Accident · No injuries · Data collection · Final report · May 5, 2007 · N97648 · Substantial damage
  > The pilot's failure to maintain an adequate airspeed during an aborted landing that resulted in a stall/mush.
- [NTSB LAX92LA013](https://openairdocs.org/ntsb/LAX92LA013.md): Stinson 108-8 · Susanville, CA · Accident · No injuries · Limited investigation · Final report · Oct 12, 1991 · N87607 · Substantial damage
  > An inadvertent stall due to the failure of the pilot to maintain a correct airspeed during the approach.
- [NTSB LAX87LA194](https://openairdocs.org/ntsb/LAX87LA194.md): Stinson 108 · Healdsburg, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 5, 1987 · N9216K · Substantial damage
  > During what was supposed to be a taxi test, the plt decided to takeoff when he lost control of the acft. The acft veered to the right off the rwy and collided with the terrain. The plt had flown the acft for the first time with the owner the day before the…
- [NTSB LAX85FA038](https://openairdocs.org/ntsb/LAX85FA038.md): Stinson Voyager 150 · Meadow Vista, CA · Accident · 1 fatal · Field investigation · Final report · Nov 3, 1984 · N97638 · Destroyed
  > The acft collided with terrain while maneuvering northeast of auburn airport during a VFR personal flt. The plt advised sacramento TRACON that he had auburn arpt in sight. However, TRACON observed N97638 fly over & pass auburn arpt in a northerly direction &…
- [NTSB SEA84FA032](https://openairdocs.org/ntsb/SEA84FA032.md): Stinson 108-1 · Vashon, WA · Accident · 1 fatal · Field investigation · Final report · Jan 5, 1984 · N97016 · Destroyed
  > Just after taking off in IMC at night, the acft crashed near the departure end of rwy 36. According to a witness, the acft climbed after takeoff to about 200 ft above the trees, then entered a descent & disappeared behind a tree line. After crashing, the acft…

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

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

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