NTSB investigations: Stinson 108-3, 1968
18 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\") = 1968
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") = 1968
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 MIA69A0028Accident · 2 fatalClosedStinson 108-3 · Ft.Lauderdale, FLNTSB MKC69D0256Accident · No injuriesClosedStinson 108-3 · Hill City, KSNTSB SEA69D0137Accident · No injuriesClosedStinson 108-3 · Seattle, WANTSB MKC69D0255Accident · No injuriesClosedStinson 108-3 · Beaumont, KSNTSB SEA69D0113Accident · No injuriesClosedStinson 108-3 · Gooding, IDNTSB NYC69D0183Accident · No injuriesClosedStinson 108-3 · Dublin, PANTSB MKC69F0093Accident · Minor injuriesClosedStinson 108-3 · Grassy Bute, NDNTSB CHI69F0024Accident · No injuriesClosedStinson 108-3 · Petersburg, MINTSB MIA69F0073Accident · Serious injuriesClosedStinson 108-3 · Kennesaw, GANTSB CHI69F0026Accident · Minor injuriesClosedStinson 108-3 · Flushing, MINTSB CHI68A0108Accident · 2 fatalClosedStinson 108-3 · Put-In-Bay, OHNTSB SEA68D0326Accident · No injuriesClosedStinson 108-3 · Omak, WANTSB MKC68A0069Accident · 2 fatalClosedStinson 108-3 · Dubuque, IANTSB CHI68F0765Accident · No injuriesClosedStinson 108-3 · Belleville, MINTSB NYC68F0414Accident · Minor injuriesClosedStinson 108-3 · Warren, PANTSB FTW68D0497Accident · No injuriesClosedStinson 108-3 · Beaver, OKNTSB SEA68F0254Accident · No injuriesClosedStinson 108-3 · Yakima, WANTSB DEN68F0215Accident · Minor injuriesClosedStinson 108-3 · Boulder, CO