NTSB investigations: Stinson 108-2, 1988
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\") = 1988
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") = 1988
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 ATL88LA180Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Avon, OHThe acft was on initial climb out when the eng quit. The acft was at an estimated altitude of 100 ft and over trees at the time of the power loss. The plt attempted to return to the airstrip. The acft landed hard in a nose down position off to the side of the…NTSB DEN88FA107Accident · 2 fatalField investigationFinal reportStinson 108-2 · Mosca, COAfter purchasing acft, plt and plt-rated friend (both airline plts) were joined by plt's wife and departed falcon field, mesa, AZ, en route to MN. The trio stopped in alamosa, CO, for night. They departed alamosa (elevation 7608 ft MSL) the next morning and…NTSB LAX88LA177Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Temecula, CADuring the landing roll in a direct crosswind, the aircraft began to weather vane. The pilot was unable to maintain control of the aircraft which veered off the runway where it collided with the terrain and nosed over. There were no reported mechanical…NTSB NYC88LA124Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Warwick, NYDuring takeoff and landing practice, the aircraft veered left off of the runway despite reported full right rudder application by the pilot. The aircraft continued to roll across the grass and came to rest after colliding with a construction ditch.NTSB SEA88LA063Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Cashmere, WAThe acft touched down near midfield while landing on an 1800 ft long downsloping runway. When the pilot rapidly applied throttle for go-around, the engine faltered. He applied hard braking to stop on the runway and the aircraft nosed over.