NTSB investigations: Stinson 108-3, 2019
5 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\") = 2019
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") = 2019
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 ANC19TA055Accident · Serious injuriesClass 4Final reportStinson 108 · Tyonek, AKThe pilot’s exceedance of the airplane’s critical angle of attack during a short field takeoff, which resulted in an aerodynamic stall and loss of control.NTSB CEN19LA281Accident · Minor injuriesClass 3 · LimitedFinal reportStinson 108 · Grand Rapids, MNA loss of engine power after takeoff for undetermined reasons.NTSB WPR19LA207Accident · No injuriesClass 3 · LimitedFinal reportStinson 108 · Klamath Falls, ORThe mechanic’s failure to identify an engine performance issue, which led to a partial loss of engine power. Contributing to the accident was the pilot’s decision to operate the airplane with a known mechanical deficiency.NTSB WPR19LA179Accident · Minor injuriesClass 3 · LimitedFinal reportStinson 108 · Caldwell, IDA total loss of engine power during approach due to a failed piston. The reason for the piston failure could not be determined based on the available information.NTSB GAA19CA263Accident · No injuriesData collectionFinal reportStinson 108 · Soldotna, AKThe pilot's overapplication of the brakes during landing on a soft runway, which resulted in a nose-over.