NTSB investigations: Stinson 108-3, CA
33 cases on aircraft the registry lists as Stinson 108-3. 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
| 1964 | 2 |
|---|---|
| 1965 | 2 |
| 1966 | 3 |
| 1967 | 1 |
| 1969 | 2 |
| 1970 | 2 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1978 | 4 |
| 1989 | 1 |
| 1992 | 1 |
| 1994 | 3 |
| 1996 | 1 |
| 2001 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2012 | 1 |
| 2016 | 1 |
| 2020 | 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.\"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 ('9230408'))
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 ('9230408'))
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 WPR21LA064Accident · No injuriesClass 3 · LimitedFinal reportStinson 108-3 · El Monte, CAA loss of directional control during the landing roll due to an undetermined failure of the tailwheel assembly.NTSB WPR16CA077Accident · No injuriesData collectionFinal reportStinson 108 3 · Livermore, CAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was maintenance personnel's failure to detect the worn tailwheel assembly during the airplane's annual inspection.NTSB WPR12CA129Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Santa Clarita, CAThe pilot's delayed decision to abandon the landing attempt, which resulted in the airplane colliding with rising terrain. Contributing to the accident was the pilot's decision to land with a tailwind.NTSB WPR10CA391Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Bridgeport, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR10LA072Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Clarksburg, CAThe pilot’s improper touchdown point and excessive airspeed during landing, which resulted in a runway overrun.NTSB LAX02LA006Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Rosamond, CAThe pilot's failure to attain sufficient airspeed during the attempted takeoff, which resulted in a stall/mush. The airplane's failure to accelerate was due to a disintegrated bearing on the camshaft. The pilot's failure to make a timely abort decision was a…NTSB LAX96LA193Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Compton, CAThe pilot of the other aircraft's failure to see and avoid N6WR. A factor in the accident was the narrow, confined nature of the taxiway, which restricted the Stinson pilot's ability to perform clearing turns while taxiing.NTSB LAX94FA354Accident · 4 fatalField investigationFinal reportStinson 108-3 · Shelter Cove, CAInadequate preflight by the pilot, which resulted in fuel starvation and loss of engine power, improper (or delayed) positioning of the fuel selector to the fullest tank, and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced…NTSB LAX94LA195Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Ramona, CAThe pilot of the other aircraft failed to maintain an adequate visual lookout.NTSB LAX94LA128Accident · 1 fatalLimited investigationFinal reportStinson 108-3 · Redlands, CAThe pilot's impairment of judgment and performance due to alcohol, which led to his improper planning/decision, and his failure to maintain proper altitude. Factors related to the accident were: darkness and the pilot's lack of training/certification for…NTSB LAX92LA282Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Montague, CAThe disintegration of the left wheel during the landing roll out and the resultant inability of the pilot to maintain directional control of the aircraft. A factor in the accident was the soft nature of the terrain encountered by the aircraft after leaving…NTSB LAX89LA153Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Livermore, CADirectional control not maintained by the pilot. Unfavorable wind, high wind, and gusts were contributing factors.NTSB OAK79FVM05Accident · No injuriesClosedStinson 108-3 · San Carlos, CANTSB OAK78DVD06Accident · No injuriesClosedStinson 108-3 · Concord, CANTSB LAX78FUA25Accident · No injuriesClosedStinson 108-3 · Long Beach, CANTSB OAK78DVM13Accident · Minor injuriesClosedStinson 108-3 · Carmel Valley, CANTSB LAX77FUA13Accident · Serious injuriesClosedStinson 108-3 · Santa Ana, CANTSB OAK76DVG24Accident · Minor injuriesClosedStinson 108-3 · Walnut Grove, CANTSB LAX74DUG33Accident · No injuriesClosedStinson 108-3 · Apple Vally, CANTSB OAK72DVD40Accident · No injuriesClosedStinson 108-3 · Oakland, CANTSB LAX71FUM30Accident · 2 fatalClosedStinson 108 · Ocotillo, CANTSB LAX71FUA33Accident · Minor injuriesClosedStinson 108-3 · Torrance, CANTSB LAX70DVA13Accident · No injuriesClosedStinson 108-3 · Bakersfield, CANTSB LAX69A0060Accident · 1 fatalClosedStinson 108-3 · Sta Monica, CANTSB LAX69D0238Accident · Minor injuriesClosedStinson 108-3 · Mortmar, CANTSB LAX67F0306Accident · Serious injuriesClosedStinson 108-3 · Kernville, CANTSB LAX67D0178Accident · No injuriesClosedStinson 108-3 · Van Nuys, CANTSB OAK67D0061Accident · No injuriesClosedStinson 108 · Crescent City, CANTSB OAK66D0269Accident · No injuriesClosedStinson 108-3 · Santa Rosa, CANTSB LAX66D0145Accident · No injuriesClosedStinson 108-3 · Riverside, CANTSB OAK65F0010Accident · No injuriesClosedStinson 108-3 · Fresno, CANTSB UNK65X1182Accident · Serious injuriesClosedStinson 108-3 · Van Nuys, CANTSB UNK64X1799Accident · No injuriesClosedStinson 108 · El Monte, CA