NTSB investigations: Stinson 108-2, CO
13 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
| 1968 | 2 |
|---|---|
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 2 |
| 1976 | 1 |
| 1977 | 1 |
| 1983 | 1 |
| 1988 | 1 |
| 2003 | 1 |
| 2020 | 1 |
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 c.\"eventStateOrRegion\" = 'CO' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'CO' AND c."eventCountry" = 'USA'
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 CEN20LA345Accident · No injuriesClass 3 · LimitedFinal reportStinson 108 · Glenwood Springs, COThe pilot’s loss of directional control upon landing due to a sheared tailwheel locking pin.NTSB DEN03LA036Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Elbert, COthe pilot's inability to maintain aircraft control resulting in the ground loop. Factors relating to the accident were the crosswinds and the wind gusts.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 DEN83LA088Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Aspen, COWhile inbound, the plt checked the ATIS which was reporting a wind from 350 deg at 10 KTS. He continued inbound, and when he checked with the tower, the wind was from 350 deg at 6 KTS. The plt was cleared to land on the rwy of his choice, he stated that he…NTSB DEN77FTE76Accident · No injuriesClosedStinson 108-2 · Boulder, CONTSB DEN76FTE95Accident · No injuriesClosedStinson 108-2 · Peyton, CONTSB DEN75DTE20Accident · No injuriesClosedStinson 108 · Montrose, CONTSB DEN74DTE87Accident · No injuriesClosedStinson 108-2 · Holyoke, CONTSB DEN73AD052Accident · 2 fatalClosedStinson 108-2 · Montrose, CONTSB DEN73DTE15Accident · No injuriesClosedStinson 108-2 · Pueblo, CONTSB DEN72DTE58Accident · No injuriesClosedStinson 108-3 · Lamar, CONTSB DEN69F0122Accident · Minor injuriesClosedStinson 108-2 · Aurora, CONTSB DEN69D0088Accident · Minor injuriesClosedStinson 108-2 · Aurora, CO