# NTSB investigations: Stinson 108-3: 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 ATL04LA007](https://openairdocs.org/ntsb/ATL04LA007.md): Stinson 108-3 · Lake Placid, FL · Accident · No injuries · Limited investigation · Final report · Oct 5, 2003 · N831C · Substantial damage
  > The pilot's failure to maintain airspeed which resulted in an inadvertent stall.
- [NTSB FTW93LA225](https://openairdocs.org/ntsb/FTW93LA225.md): Stinson 108-3 · Osceola, AR · Accident · No injuries · Limited investigation · Final report · Aug 1, 1993 · N4021C · Substantial damage
  > Inadvertent stall. Factors were the improper latching of the engine cowling by the pilot and his inadequate preflight inspection.
- [NTSB FTW87LA187](https://openairdocs.org/ntsb/FTW87LA187.md): Stinson 108-3 · Hereford, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 3, 1987 · N6809M · Destroyed
  > The acft was taking off from a state hwy with a truck blocking traffic at the end of a 2,500 foot stretch. The plt elected to tkof toward the truck, however, during the tkof run, he realized that he could not clear the truck and pulled up sharply. Drng the…
- [NTSB ANC86LA101](https://openairdocs.org/ntsb/ANC86LA101.md): Stinson 108 · Hope, AK · Accident · Serious injuries · Limited investigation · Final report · Jul 5, 1986 · N936C · Destroyed
  > The plt stalled the acft during final apch to a small gravel airstrip. The plt had not received training as a student plt nor did he hold any FAA plt or medical certificate.
- [NTSB DEN84LA135](https://openairdocs.org/ntsb/DEN84LA135.md): Stinson 108-3 · Mcville, ND · Accident · Serious injuries · Limited investigation · Final report · Apr 22, 1984 · N631C · Substantial damage
  > The acft collided with the ground, left wing 1st, during an apch to land. The plt stated that the acft apparently stalled. A patrolman noted an odor of alcohol in the plt's breath. A blood/alcohol test showed an alcohol level of 0.19%. The plt's last medical…

## 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 ('9230408')
    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=9230408&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.
