NTSB investigations: Stinson 108-2, 1984
5 cases on aircraft the registry lists as Stinson 108-2. 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 | 14 |
|---|---|
| 1965 | 15 |
| 1966 | 11 |
| 1967 | 11 |
| 1968 | 11 |
| 1969 | 14 |
| 1970 | 9 |
| 1971 | 14 |
| 1972 | 11 |
| 1973 | 8 |
| 1974 | 7 |
| 1975 | 10 |
| 1976 | 7 |
| 1977 | 9 |
| 1978 | 6 |
| 1979 | 5 |
| 1980 | 5 |
| 1981 | 2 |
| 1982 | 5 |
| 1983 | 3 |
| 1984 | 5 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 2 |
| 1988 | 5 |
| 1989 | 3 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 4 |
| 1994 | 1 |
| 1995 | 4 |
| 1996 | 4 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 3 |
| 2003 | 2 |
| 2004 | 3 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 3 |
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 4 |
| 2016 | 4 |
| 2017 | 5 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 2 |
| 2023 | 1 |
| 2024 | 2 |
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 ('9230406'))
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 ('9230406'))
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 LAX85LA060Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Chino, CAWhen the plt received ldg instructions the wind was reported as being calm. During ldg flare on rwy 26, at 2 ft AGL, a gust was encountered. The gust was from the acft's 7 o'clock position & the plt was unable to maintain control of the acft. He stated that…NTSB CHI85LA061Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Sterling, ILThe acft ground looped & cartwheeled while landing during a personal flt. The plt lacked experience in tailwheel type acft.NTSB FTW85LA013Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Booker, TXPlt arrived at destination at dusk. Lighted wind tetrahedron was out of service. Plt executed low pass in unsuccesful attempt to see windsock. Plt was aware of strong surface winds (about 35 KTS), presumed to be from sw, from recent frontal passage and…NTSB ANC84LA187Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Cairn Mountain, AKThe acft crashed during a takeoff from a remote airstrip. The plt stated that he walked the strip prior to starting the takeoff. He said that immediately after liftoff the acft began to drift left. Before he was able to make a correction the tail of the acft…NTSB SEA84LA106Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Carson City, NVAccording to the plt, the wind was from 230 deg at 12 gusting 18 KTS. He said that he had just lifted the tailwheel when a 'dust devil' push the acft to the right of the rwy. The acft then struck sage brush & a barbed wire fence & nosed over.