NTSB investigations: Stinson 108-3, 1994
6 cases on aircraft the registry lists as Stinson 108-3. 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 | 21 |
|---|---|
| 1965 | 16 |
| 1966 | 13 |
| 1967 | 16 |
| 1968 | 18 |
| 1969 | 10 |
| 1970 | 11 |
| 1971 | 17 |
| 1972 | 12 |
| 1973 | 8 |
| 1974 | 9 |
| 1975 | 8 |
| 1976 | 12 |
| 1977 | 9 |
| 1978 | 12 |
| 1979 | 6 |
| 1980 | 7 |
| 1981 | 2 |
| 1982 | 3 |
| 1983 | 2 |
| 1984 | 5 |
| 1985 | 2 |
| 1986 | 3 |
| 1987 | 3 |
| 1988 | 2 |
| 1989 | 3 |
| 1990 | 4 |
| 1991 | 2 |
| 1992 | 5 |
| 1993 | 1 |
| 1994 | 6 |
| 1995 | 1 |
| 1996 | 6 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 6 |
| 2002 | 4 |
| 2003 | 5 |
| 2004 | 2 |
| 2007 | 1 |
| 2008 | 3 |
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 2 |
| 2015 | 3 |
| 2016 | 5 |
| 2018 | 2 |
| 2019 | 5 |
| 2020 | 4 |
| 2021 | 2 |
| 2022 | 2 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 3 |
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\") = 1994
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9230408'))
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") = 1994
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9230408'))
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 LAX94FA354Accident · 4 fatalField investigationFinal reportStinson 108-3 · Shelter Cove, CAInadequate preflight by the pilot, which resulted in fuel starvation and loss of engine power, improper (or delayed) positioning of the fuel selector to the fullest tank, and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced…NTSB SEA94LA204Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Bend, ORImproper use of the carburetor heat by the pilot, which resulted in a loss of engine performance. A factor related to the accident was: rough terrain in the emergency landing area.NTSB SEA94LA173Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Ione, WAThe pilot's failure to maintain directional control. Factors include the pilot's fatigue, and trees near the side of the runway.NTSB CHI94LA208Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Warren, MNthe pilot's improper use of the parking brake.NTSB LAX94LA195Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Ramona, CAThe pilot of the other aircraft failed to maintain an adequate visual lookout.NTSB LAX94LA128Accident · 1 fatalLimited investigationFinal reportStinson 108-3 · Redlands, CAThe 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…