Skip to content

Fatal NTSB investigations: Stinson 108-2

25 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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."highestInjuryLevel" = 'Fatal' 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

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.\"highestInjuryLevel\" = 'Fatal'
    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."highestInjuryLevel" = 'Fatal'
  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

Run 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 SEA93LA054Accident · 1 fatalLimited investigationFinal reportStinson 108-2 · Fruit Heights, UTVFR flight into IMC conditions was attempted by the pilot. Factors include rain, snow, and fog.Jan 16, 1993 · N8004K · Destroyed NTSB ANC92LA033Accident · 1 fatalLimited investigationFinal reportStinson 108-2 · Cube Cove, AKThe encounter of windshear during the final approach and the pilot's improper in flight planning and decisions by electing to land downwind. Factor in this accident was the rough and uneven terrain.Feb 9, 1992 · N905D · Substantial damage NTSB SEA91FA119Accident · 2 fatalField investigationFinal reportStinson 108-2 · Gold Bar, WAThe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to remain clear of the obstacles (trees). The adverse weather condition (fog) was a related factor.May 25, 1991 · N9715K · Destroyed NTSB NYC89FA086Accident · 6 fatalField investigationFinal reportBeech A36 · Glen Falls, NYFailure of both pilots to see-and-avoid each other. Related factors were: failure of the Beech aircrew to make a normal left turn out of traffic and the Stinson pilot's visual perception due to sunglare.Feb 19, 1989 · N1DQ · 2 aircraft · Destroyed 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…May 13, 1988 · N354C · Destroyed NTSB ANC86FA116Accident · 2 fatalField investigationFinal reportStinson 108-2 · Willow, AKAbout 5 to 10 min prior to the acdnt, svrl witnesses in the vicinity of the Willow arpt saw the acft headed southbound. They rprtd the eng was running rough, but they saw no smoke or fire. Aprx 3 mi further south, other witnesses saw the acft make a 180 deg…Jul 28, 1986 · N942D · Destroyed NTSB LAX82FVM13Accident · 4 fatalFinal reportStinson 108-2 · Morgan Hill, CAThe pilot was observed making repeated low passes in the vicinity of the crash site. This was also close to the home of one of the passengers. The final pass was made in a westerly direction over a dam at about 50 ft AGL. Just beyond the dam, the pilot made a…Mar 27, 1982 · N9455K · Destroyed NTSB ANC77FA031Accident · 2 fatalClosedStinson 108-2 · Merrill Pass, AKFeb 18, 1977 · N97274 · Substantial damage NTSB DEN76AD056Accident · 4 fatalClosedStinson 108-2 · Kamas, UTJun 29, 1976 · N8015K · Destroyed NTSB SEA76AS048Accident · 1 fatalClosedStinson 108-2 · Dundee, ORMay 14, 1976 · N9728K · Destroyed NTSB NYC76AN047Accident · 1 fatalClosedStinson 108-2 · Bellows Falls, VTOct 29, 1975 · N9464K · Destroyed NTSB CHI75AC088Accident · 1 fatalClosedStinson 108-2 · Jackson, MIMay 18, 1975 · N9508K · Destroyed NTSB SEA75AS041Accident · 2 fatalClosedStinson 108-2 · Gimlet, IDMay 17, 1975 · N9632K · Destroyed NTSB DEN73AD052Accident · 2 fatalClosedStinson 108-2 · Montrose, COJun 4, 1973 · N9548K · Destroyed NTSB NYC72AN070Accident · 3 fatalClosedCessna 170B · Fallston, PANov 28, 1971 · N2535D · 2 aircraft · Destroyed NTSB SEA72AS009Accident · 2 fatalClosedStinson 108-2 · Port Angeles, WASep 3, 1971 · N890D · Destroyed NTSB MIA69F0416Accident · 1 fatalClosedStinson 108-2 · Russellville, ALFeb 21, 1969 · N97478 · Destroyed NTSB SEA69A0026Accident · 2 fatalClosedStinson 108 · Vancouver, WANov 10, 1968 · N422C · Destroyed NTSB SEA68A0040Accident · 2 fatalClosedStinson 108-2 · Tigard, ORNov 5, 1967 · N963D · Substantial damage NTSB CHI67A0111Accident · 2 fatalClosedStinson 108-2 · Chandlerville, ILMar 30, 1967 · N9302K · Destroyed NTSB ANC66A0037Accident · 1 fatalClosedStinson 108-2 · Anchorage, AKApr 18, 1966 · N9278K · Destroyed NTSB CHI66A0060Accident · 3 fatalClosedPiper PA-23 · Knox, INDec 19, 1965 · N1100P · 2 aircraft · Destroyed NTSB MIA65A0113Accident · 1 fatalClosedStinson 108 · Mt Ulla, NCMay 15, 1965 · N985D · Destroyed NTSB UNK64X1212Accident · 2 fatalClosedStinson 108-2 · St John, UTApr 7, 1964 · N430C · Destroyed NTSB UNK64X1037Accident · 1 fatalClosedStinson 108-2 · Breckenridge, TXMar 25, 1964 · N9353K · Destroyed