Skip to content

NTSB investigations: Stinson 108-2, WA

16 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

19682026

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."eventStateOrRegion" = 'WA' 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

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\" = 'WA' 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" = 'WA' 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

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 LAX07CA269Accident · Minor injuriesData collectionFinal reportStinson 108-2 · Port Townsend, WAThe pilot's failure to adequately compensate for a wind conditions and maintain directional control during the touchdown and a subsequent aborted landing attempt.Sep 8, 2007 · N228C · Substantial damage NTSB SEA01LA041Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Arlington, WAThe pilot's failure to maintain directional control during landing roll.Jan 20, 2001 · N228C · Substantial damage 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.Nov 8, 1998 · N9755K · Substantial damage NTSB SEA97LA045Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Richland, WAfailure of the pilot to see-and-avoid an ultralight aircraft that was taxiing and had stopped in front of him.Jan 4, 1997 · N9467K · Substantial damage NTSB SEA97LA039Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Friday Harbor, WAfailure of the engine (powerplant) for undetermined reason(s). A factor relating to the accident include: being over water at the time of power failure.Dec 20, 1996 · N233C · Destroyed 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 SEA88LA063Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Cashmere, WAThe acft touched down near midfield while landing on an 1800 ft long downsloping runway. When the pilot rapidly applied throttle for go-around, the engine faltered. He applied hard braking to stop on the runway and the aircraft nosed over.Mar 19, 1988 · N9660K · Destroyed 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…Mar 11, 1986 · N388C · Destroyed NTSB SEA81FA033Accident · Serious injuriesClosedStinson 108-2 · Ellensburg, WAMay 3, 1981 · N9279K · Destroyed NTSB SEA73FYE29Accident · No injuriesClosedStinson 108 · Kent, WAMar 17, 1973 · N9150K · Substantial damage NTSB SEA73DYG16Accident · No injuriesClosedStinson 108-2 · Republic, WAOct 23, 1972 · N201C · Substantial damage NTSB SEA73DYG12Accident · No injuriesClosedStinson 108 · Connell, WAAug 12, 1972 · N217C · Substantial damage NTSB SEA73FYG08Accident · Serious injuriesClosedStinson 108-2 · Asotin, WAAug 3, 1972 · N9572K · Destroyed NTSB SEA72AS009Accident · 2 fatalClosedStinson 108-2 · Port Angeles, WASep 3, 1971 · N890D · Destroyed NTSB SEA69D0261Accident · No injuriesClosedStinson 108-2 · Bellevue, WAMay 15, 1969 · N9714K · Substantial damage NTSB SEA69A0026Accident · 2 fatalClosedStinson 108 · Vancouver, WANov 10, 1968 · N422C · Destroyed