NTSB investigations: Stinson 108, 1984
4 cases on aircraft the registry lists as Stinson 108. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1964 | 15 |
|---|---|
| 1965 | 13 |
| 1966 | 17 |
| 1967 | 13 |
| 1968 | 3 |
| 1969 | 5 |
| 1970 | 5 |
| 1971 | 6 |
| 1972 | 3 |
| 1973 | 5 |
| 1974 | 5 |
| 1975 | 8 |
| 1976 | 6 |
| 1977 | 5 |
| 1978 | 3 |
| 1979 | 4 |
| 1980 | 1 |
| 1981 | 3 |
| 1982 | 2 |
| 1983 | 4 |
| 1984 | 4 |
| 1985 | 2 |
| 1987 | 6 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 3 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 1 |
| 1997 | 2 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2023 | 2 |
| 2024 | 2 |
| 2025 | 4 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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\") = 1984
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9230402'))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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") = 1984
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9230402'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB LAX85FA038Accident · 1 fatalField investigationFinal reportStinson Voyager 150 · Meadow Vista, CAThe 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 FTW85LA033Accident · No injuriesLimited investigationFinal reportStinson 108 · Sandia, TXThe plt was attempting a night landing at an unlighted airport. Plt stated he elecuted a low angle approach, knowing of elevated and wooded terrain off the end of the runway. On sighting trees to his left, he initiated a go-around but struck other trees…NTSB LAX84LA365Accident · No injuriesLimited investigationFinal reportStinson 108 · Camarillo, CAA prospective buyer in the left seat was initiating a takeoff in a tail wheel acft when the acft ground looped and the right main landing gear collapsed. The owner in the right seat was unable to correct the situation in time. The buyer had professed…NTSB SEA84FA032Accident · 1 fatalField investigationFinal reportStinson 108-1 · Vashon, WAJust 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…