NTSB investigations: Stinson 108-2
5 cases on aircraft the registry lists as Stinson 108-2, where the first occurrence was “In flight collision with object”. 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
| 1982 | 2 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1998 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9230406')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9230406')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 SEA99LA012Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Rainier, WAThe pilot's failure to maintain clearance from objects in the approach path. Factors include the marked wires near the end of the runway.NTSB MKC88FA003Accident · Serious injuriesField investigationFinal reportStinson 108-2 · Wakeeney, KSThe owner & his son, who were both plts, initiated a midfield takeoff from their pvt dirt airstrip which was on soft uneven terrain. The son rprtd that near the end of the strip, power was 'cut.' The acft contd about 200' beyond the dep end of the strip &…NTSB SEA86FA075Accident · Serious injuriesField investigationFinal reportStinson 108-2 · La Conner, WAPlt was on approach for water landing in a canal used during previous summer for floatplane ops at dusk. Plt was looking for a specific boat moored in canal as landing mark, extended approach path beyond normal touchdown point. Acft struck telephone cable…NTSB SEA83LA026Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Hood River, ORThe aircraft was heavily loaded and took longer than normal for takeoff. The acceleration was marginal. At the end of the runway, when the pilot pulled up over the wires, the airspeed decayed. The pilot maneuvered to avoid houses and large trees and flew into…NTSB ANC82FAA18Accident · Minor injuriesFinal reportStinson 108 · Fairbanks, AKThe acft collided with power lines during final approach. The plt reported he encountered a downdraft type of windshear.