Skip to content

NTSB investigations: Stinson 108-1, CA

27 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

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."eventStateOrRegion" = 'CA' 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 ('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.\"eventStateOrRegion\" = 'CA' 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 ('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."eventStateOrRegion" = 'CA' 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 ('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 WPR23LA359Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-1 · San Diego, CAThe pilot’s failure to maintain directional control during landing in gusty wind conditions that resulted in a ground loop.Sep 27, 2023 · N9128K · Substantial damage NTSB WPR14LA079Accident · No injuriesLimited investigationFinal reportStinson 108 1 · Lodi, CAThe fatigue failure of the crankshaft, which resulted in a total loss of engine power and subsequent forced landing.Dec 27, 2013 · N8848K · Substantial damage NTSB LAX07LA040Accident · No injuriesLimited investigationFinal reportStinson 108-1 · San Jose, CAPartial loss of engine power due to a seized exhaust valve during cruise flight. Rough terrain at the forced landing site was a contributing factor.Nov 20, 2006 · N97949 · Substantial damage NTSB LAX01LA131Accident · Serious injuriesLimited investigationFinal reportStinson 108-1 · Redlands, CAA total loss of engine power during cruise flight over rough terrain for undetermined non-mechanical reasons.Mar 31, 2001 · N8158K · Substantial damage NTSB LAX00LA200Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Los Angeles, CAThe pilot's loss of directional control during landing rollout due to the pilot's foot becoming wedged under a rudder pedal, which restricted its movement.May 21, 2000 · N8398K · Substantial damage NTSB LAX94LA093Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Rubidoux, CAthe pilot's inadequate compensation for the existing cross wind condition.Jan 13, 1994 · N8286K · Substantial damage NTSB LAX87LA143Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Saugus, CAUpon contacting ATC, the plt requested an ILS apch and that he was low on fuel. The controller cleared the plt to the ILS. Just inside the outer marker the controller advised the plt that he was dangerously low and to climb immediately. The plt was observed…Mar 13, 1987 · N8185K · Substantial damage NTSB LAX86LA255Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Quincy, CAThe commercial plt/cfi, attempted to takeoff when a left 40 deg, 15 to 25 knot crosswind existed. The plt lost directional control of the acft, & when attempting to abort the takeoff the acft's gear collapsed & the acft collided with a drainage ditch. The plt…Jun 16, 1986 · N97201 · Substantial damage NTSB LAX85LA266Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Hesperia, CAWhile en route, the plt noted thunderstorms & towering cumulus clouds over the tehachapi mountains & elected to divert to Hesperia. He stated that all fields within range had 'severe winds and storms closing.' He said that during the landing at Hesperia,…Jun 2, 1985 · N97935 · Substantial damage 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 LAX80FUG57Accident · No injuriesClosedStinson 108-1 · Banning, CASep 20, 1980 · N8717K · Substantial damage NTSB LAX80DVA31Accident · No injuriesClosedStinson 108-1 · Farmersville, CAApr 17, 1980 · N97836 · Substantial damage NTSB OAK76FVD54Accident · Minor injuriesClosedStinson 108-1 · Antioch, CAAug 31, 1976 · N8456K · Destroyed NTSB OAK76DVD04Accident · No injuriesClosedStinson 108-1 · Concord, CAAug 17, 1975 · N9092K · Substantial damage NTSB LAX75D4G23Accident · No injuriesClosedStinson 108-1 · Rubidoux, CADec 1, 1974 · N8358K · Substantial damage NTSB LAX73FUG51Accident · Serious injuriesClosedStinson 108-1 · B.Bear City, CAApr 26, 1973 · N8579K · Destroyed NTSB OAK71DVA94Accident · No injuriesClosedStinson 108-1 · Lone Pine, CAJun 20, 1971 · N9193K · Substantial damage NTSB OAK70DVD25Accident · No injuriesClosedStinson 108-1 · Point Arena, CAMay 30, 1970 · N9145K · Substantial damage NTSB OAK69D0071Accident · Minor injuriesClosedStinson 108-1 · Livermore, CAJul 29, 1968 · N97882 · Substantial damage NTSB LAX68D0330Accident · Minor injuriesClosedStinson 108-1 · Redlands, CAJan 21, 1968 · N8233K · Substantial damage NTSB OAK68F0257Accident · Serious injuriesClosedStinson 108-1 · San Jose, CANov 26, 1967 · N97074 · Substantial damage NTSB LAX67D0179Accident · No injuriesClosedStinson 108-1 · Bakersfield, CAOct 15, 1966 · N8594K · Substantial damage NTSB LAX67D0085Accident · No injuriesClosedStinson 108-1 · Lancaster, CAAug 4, 1966 · N8680K · Substantial damage NTSB OAK66A0060Accident · 2 fatalClosedStinson 108-1 · Samoa, CAJun 27, 1966 · N9225K · Destroyed NTSB LAX65A0088Accident · 1 fatalClosedStinson 108-1 · Newport Beach, CAMay 10, 1965 · N8655K · Destroyed NTSB UNK64X4138Accident · Minor injuriesClosedStinson 108-1 · Corona, CASep 25, 1964 · N97984 · Destroyed NTSB UNK64X1134Accident · No injuriesClosedStinson 108 · Orville, CAApr 2, 1964 · N8555K · Substantial damage