# NTSB investigations: Stinson 108-3: In flight collision with object

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 FTW01LA192](https://openairdocs.org/ntsb/FTW01LA192.md): Stinson 108-3 · Dover, AR · Accident · Minor injuries · Limited investigation · Final report · Aug 18, 2001 · N6898M · Substantial damage
  > the pilot's delay in aborting the landing.
- [NTSB LAX94LA128](https://openairdocs.org/ntsb/LAX94LA128.md): Stinson 108-3 · Redlands, CA · Accident · 1 fatal · Limited investigation · Final report · Feb 20, 1994 · N6009M · Destroyed
  > The pilot's impairment of judgment and performance due to alcohol, which led to his improper planning/decision, and his failure to maintain proper altitude. Factors related to the accident were: darkness and the pilot's lack of training/certification for…
- [NTSB CHI92FA211](https://openairdocs.org/ntsb/CHI92FA211.md): Stinson 108-3 · Boonville, MO · Accident · 2 fatal · Field investigation · Final report · Jul 25, 1992 · N948C · Destroyed
  > Inadequate preflight planning, and exceeding the performance capability of the airplane by the pilot-in-command.
- [NTSB CHI86FA179](https://openairdocs.org/ntsb/CHI86FA179.md): Stinson 108-3 · Shiocton, WI · Accident · 2 fatal · Field investigation · Final report · Jul 26, 1986 · N6567M · Destroyed
  > Witnesses rprtd that prior to the acdnt, the acft was flying at a very low level, near treetop level, over residences, a ball park & a lake park. Subsequently, the acft collided with a utility pole & trees, then crashed into a private residence & burst into…
- [NTSB FTW84LA173](https://openairdocs.org/ntsb/FTW84LA173.md): Stinson 108-3 · Blanco, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 12, 1984 · N4004C · Destroyed
  > According to the plt, the acft was standing unattended with the eng running at 1000 RPM when an inexperienced person attempted to shut down the eng. He reportedly pushed the throttle in, instead of pulling it out & the acft jumped the chocks. According to 2…

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

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

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