Skip to content

Fatal NTSB investigations: Stinson 108-1

18 cases on aircraft the registry lists as Stinson 108-1. 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

19652026

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 ('9230404')) 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 ('9230404'))
  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 ('9230404'))
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 WPR09LA022Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Concrete, WAThe loss of engine power during initial climb due to the pilot's improper exhaust system maintenance, which resulted in restriction of the carburetor's air intake.Oct 23, 2008 · N97946 · Substantial damage NTSB CHI03LA037Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Frankenmuth, MIThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Dec 12, 2002 · N8469K · Destroyed NTSB SEA98LA072Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Toledo, WAPartial loss of power for undetermined reasons.May 7, 1998 · N8659K · Substantial damage NTSB SEA93LA117Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Brigham City, UTThe premature liftoff by the PIC and his failure to attain proper rate of climb. Factors relating to the accident were the gusty crosswind weather conditions, the failure of the PIC to use all available runway, and transmission wires.May 21, 1993 · N8589K · Destroyed NTSB DEN90FA182Accident · 3 fatalField investigationFinal reportStinson 108-1 · Gallup, NMThe pilot inadvertently stalling his aircraft at an insufficient altitude to effect a recovery. A factor was high density attitude.Sep 8, 1990 · N8631K · Destroyed NTSB SEA86LA251Accident · 2 fatalLimited investigationFinal reportStinson 108-1 · Grangeville, IDPlt called fss over lws for wx brief lws-bke-boi. VFR not recommended for route, mountains obscured in rain showers. Plt called fss 30 min later, reported lost in clouds attempting route. Radio contact lost before location established (2305 MST, 04-26-86).…Apr 27, 1986 · N8165K · Destroyed NTSB LAX83LUQ02Accident · 2 fatalFinal reportStinson 108 · Santa Barbara, CAThe aircraft collided with a power line as the pilot was flying at low altitude near a highway at dusk. After hitting the power line, the plane fell to the ground and burned. Witnesses reported there was a low cloud cover and light rain. One witness stated…Nov 23, 1982 · N222W · Destroyed NTSB IAD78DA042Accident · 1 fatalClosedStinson 108 · Ocean City, MDJan 27, 1978 · N8980K · Destroyed NTSB SEA76AS051Accident · 4 fatalClosedStinson 108-1 · Burley, IDMay 23, 1976 · N8480K · Destroyed NTSB MIA73AM041Accident · 2 fatalClosedStinson 108-1 · Ocala, FLOct 16, 1972 · N8529K · Destroyed NTSB FTW71AF032Accident · 1 fatalClosedStinson 108-1 · Beaumont, TXDec 15, 1970 · N9094K · Destroyed NTSB NYC70A0030Accident · 2 fatalClosedStinson 108-1 · Colton, NYSep 1, 1969 · N97789 · Destroyed NTSB SEA69A0059Accident · 3 fatalClosedAeronca 7AC · Snohomish, WAJun 2, 1969 · N85071 · 2 aircraft · Destroyed NTSB CHI68A0074Accident · 2 fatalClosedPiper PA-28 · Ranklin, INFeb 18, 1968 · N9516W · 2 aircraft · Destroyed NTSB FTW68A0073Accident · 1 fatalClosedStinson 108-1 · Gladewater, TXJan 30, 1968 · N97947 · Destroyed NTSB OAK66A0060Accident · 2 fatalClosedStinson 108-1 · Samoa, CAJun 27, 1966 · N9225K · Destroyed NTSB SEA66A0048Accident · 1 fatalClosedStinson 108 · Port Angeles, WAMar 21, 1966 · N8930K · No damage NTSB LAX65A0088Accident · 1 fatalClosedStinson 108-1 · Newport Beach, CAMay 10, 1965 · N8655K · Destroyed