Skip to content

NTSB investigations: Stinson 108, CA

25 cases on aircraft the registry lists as Stinson 108. 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 ('9230402')) 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 ('9230402'))
  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 ('9230402'))
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 LAX07CA152Accident · No injuriesData collectionFinal reportStinson 108 · Auburn, CAThe pilot's failure to maintain an adequate airspeed during an aborted landing that resulted in a stall/mush.May 5, 2007 · N97648 · Substantial damage NTSB LAX05CA246Accident · Minor injuriesData collectionFinal reportStinson 108 · Hesperia, CAthe pilot's failure to maintain directional control during landing rollout.Jul 26, 2005 · N97492 · Substantial damage NTSB LAX96LA329Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Quincy, CAthe pilot's over leaning of the fuel mixture, which resulted in the initial loss of engine power; and continued fuel starvation, resulting from the pilot's inadvertent mispositioning of the fuel selector valve during an attempted restart of the engine.Sep 8, 1996 · N97337 · Substantial damage NTSB LAX92LA013Accident · No injuriesLimited investigationFinal reportStinson 108-8 · Susanville, CAAn inadvertent stall due to the failure of the pilot to maintain a correct airspeed during the approach.Oct 12, 1991 · N87607 · Substantial damage NTSB LAX89LA298Accident · No injuriesLimited investigationFinal reportStinson 108 · Cool, CAFailure of the #2 piston. Failure of the mechanic to properly overhaul the engine was a related factor.Sep 1, 1989 · N97628 · Substantial damage NTSB LAX89LA168Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Avalon, CAThe pilot's inadequate compensation for the downdrafts he encountered and the delay in his decision to perform a go-around.Apr 22, 1989 · N97169 · Substantial damage NTSB LAX87LA194Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Healdsburg, CADuring what was supposed to be a taxi test, the plt decided to takeoff when he lost control of the acft. The acft veered to the right off the rwy and collided with the terrain. The plt had flown the acft for the first time with the owner the day before the…Apr 5, 1987 · N9216K · Substantial damage NTSB LAX87LA148Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Rio Vista, CAThe aircraft nosed over in soft soil after a forced landing. The aircraft's engine failed during the departure climb and the pilot was unable to restart it. The pilot accomplished a forced landing to a field. The aircraft nosed over when the nose gear became…Mar 17, 1987 · N97115 · Substantial damage NTSB LAX85FA038Accident · 1 fatalField investigationFinal reportStinson Voyager 150 · Meadow Vista, CAThe acft collided with terrain while maneuvering northeast of auburn airport during a VFR personal flt. The plt advised sacramento TRACON that he had auburn arpt in sight. However, TRACON observed N97638 fly over & pass auburn arpt in a northerly direction &…Nov 3, 1984 · N97638 · Destroyed NTSB LAX84LA365Accident · No injuriesLimited investigationFinal reportStinson 108 · Camarillo, CAA prospective buyer in the left seat was initiating a takeoff in a tail wheel acft when the acft ground looped and the right main landing gear collapsed. The owner in the right seat was unable to correct the situation in time. The buyer had professed…Jun 23, 1984 · N97205 · Substantial damage NTSB OAK77DVD33Accident · No injuriesClosedStinson 108-1 · Healdsburg, CAMay 14, 1977 · N97115 · Substantial damage NTSB OAK76DVD13Accident · No injuriesClosedStinson 108 · Willets, CASep 19, 1975 · N97249 · Substantial damage NTSB OAK76DVG08Accident · No injuriesClosedStinson 108 · Vacaville, CAJul 19, 1975 · N97342 · Substantial damage NTSB LAX74FUQ33Accident · Serious injuriesClosedStinson 108 · Santa Paula, CAApr 7, 1974 · N40198 · Substantial damage NTSB LAX73AL025Accident · 1 fatalClosedStinson 108 · Ukiah, CADec 5, 1972 · N97366 · Destroyed NTSB OAK72DVA18Accident · No injuriesClosedStinson 108-1 · Porterville, CASep 5, 1971 · N9041K · Substantial damage NTSB LAX70FUQ29Accident · Minor injuriesClosedStinson 108 · Santa Paula, CAMay 21, 1970 · N97292 · Substantial damage NTSB LAX70A0003Accident · 2 fatalClosedStinson 108 · Compton, CAJul 12, 1969 · N39480 · Destroyed NTSB LAX69F0347Accident · Serious injuriesClosedStinson 108 · Summit, CAMay 3, 1969 · N97471 · Destroyed NTSB OAK68D0076Accident · No injuriesClosedStinson 108 · Jackson, CAMay 20, 1967 · N97602 · Substantial damage NTSB OAK67D0184Accident · No injuriesClosedStinson 108 · Columbia, CADec 23, 1966 · N97358 · Substantial damage NTSB OAK66D0187Accident · Minor injuriesClosedStinson 108-1 · Healdsburg, CAFeb 6, 1966 · N8156K · Destroyed NTSB LAX66D0233Accident · No injuriesClosedStinson 108 · Hemet, CADec 6, 1965 · N97648 · Substantial damage NTSB UNK65X0519Accident · Serious injuriesClosedStinson 108 · Arvin, CANov 1, 1964 · N8386K · Destroyed NTSB UNK64X1025Accident · Serious injuriesClosedStinson 108 · Palmdale, CAMar 23, 1964 · N97244 · Destroyed