Skip to content

NTSB investigations: Stinson 108-2, CA

30 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

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 ('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\" = '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 ('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" = '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 ('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 WPR11LA307Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Columbia, CAThe airplane’s failure to climb at a sufficient rate to clear trees and terrain beyond the end of the runway for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have…Jul 5, 2011 · N9351K · Substantial damage NTSB LAX06CA263Accident · No injuriesData collectionFinal reportStinson 108-2 · Grass Valley, CAfailure of the pilot to maintain directional control on the landing rollout due to inadequate compensation for a gusty crosswind condition and an attempt to turn at an excessive taxi speed.Aug 17, 2006 · N9818K · Substantial damage NTSB LAX04LA225Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Susanville, CAthe pilot's failure to perform a proper preflight inspection of the airplane and ensure that the oil cap was secured, which resulted in a descent into terrain due to his obstructed view out of the windshield.May 31, 2004 · N9816K · Substantial damage NTSB LAX95LA083Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Lodi, CAthe pilot's inadequate compensation for the existing crosswind wind condition and his failure to maintain proper alignment with the runway.Jan 21, 1995 · N9359K · Substantial damage NTSB LAX90LA044Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Rialto, CAThe pilot's failure to maintain directional control during landing. Contributing factors were the gusty crosswind conditions.Dec 3, 1989 · N334K · Substantial damage NTSB LAX88LA177Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Temecula, CADuring the landing roll in a direct crosswind, the aircraft began to weather vane. The pilot was unable to maintain control of the aircraft which veered off the runway where it collided with the terrain and nosed over. There were no reported mechanical…May 11, 1988 · N9570K · Substantial damage NTSB LAX85LA378Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Carpinteria, CADuring a x-c pleasure flt all eng pwr was suddenly lost when the plt heard a 'loud bang.' The plt made an emergency ldg on a polo field. During ldg flare the plt stalled the acft. The resulting hard touchdown substantially damaged the acft. Exam of the acft's…Sep 1, 1985 · N9782K · Substantial damage NTSB LAX85LA060Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Chino, CAWhen the plt received ldg instructions the wind was reported as being calm. During ldg flare on rwy 26, at 2 ft AGL, a gust was encountered. The gust was from the acft's 7 o'clock position & the plt was unable to maintain control of the acft. He stated that…Dec 6, 1984 · N426C · Substantial damage NTSB LAX82FVM13Accident · 4 fatalFinal reportStinson 108-2 · Morgan Hill, CAThe pilot was observed making repeated low passes in the vicinity of the crash site. This was also close to the home of one of the passengers. The final pass was made in a westerly direction over a dam at about 50 ft AGL. Just beyond the dam, the pilot made a…Mar 27, 1982 · N9455K · Destroyed NTSB LAX80DUM10Accident · No injuriesClosedStinson 108-2 · Borrego Sprngs, CAFeb 5, 1980 · N9698K · Destroyed NTSB OAK79FVD14Accident · No injuriesClosedStinson 108-2 · Tiburon, CAMar 4, 1979 · N388C · Substantial damage NTSB OAK77DVA56Accident · No injuriesClosedStinson 108 · Groveland, CASep 17, 1977 · N9825K · Substantial damage NTSB OAK75DVM38Accident · No injuriesClosedStinson 108-2 · Morgan Hill, CAJun 20, 1975 · N9502K · Substantial damage NTSB LAX75FUG46Accident · Serious injuriesClosedStinson 108-2 · Rubidoux, CAJun 6, 1975 · N9765K · Destroyed NTSB OAK73DVG61Accident · No injuriesClosedStinson 108-2 · Weed, CAMay 7, 1973 · N9529K · Substantial damage NTSB OAK73FVD03Accident · Minor injuriesClosedStinson 108-2 · Concord, CAJul 14, 1972 · N9870K · Substantial damage NTSB LAX71DUG76Accident · No injuriesClosedStinson 108 · Blythe, CAApr 24, 1971 · N926D · Substantial damage NTSB OAK71FXQ34Accident · No injuriesClosedStinson 108-2 · Stead, CAApr 12, 1971 · N228C · Substantial damage NTSB LAX70FUA08Accident · Minor injuriesClosedStinson 108 · Fullerton, CAJan 30, 1970 · N946D · Substantial damage NTSB LAX70F0165Accident · No injuriesClosedStinson 108-2 · Saugus, CASep 27, 1969 · N9614K · Destroyed NTSB OAK70F0103Accident · Serious injuriesClosedStinson 108-2 · Stockton, CASep 1, 1969 · N9305K · Substantial damage NTSB OAK69D0181Accident · No injuriesClosedStinson 108-2 · Atwater, CADec 5, 1968 · N9425K · Substantial damage NTSB LAX69D0006Accident · No injuriesClosedStinson 108-2 · Riverside, CAJun 4, 1968 · N9804K · Substantial damage NTSB OAK68D0263Accident · No injuriesClosedStinson 108-2 · Santa Cruz, CADec 10, 1967 · N9403K · Substantial damage NTSB LAX67D0126Accident · No injuriesClosedStinson 108-2 · Baker, CASep 10, 1966 · N479C · Substantial damage NTSB OAK66D0213Accident · No injuriesClosedStinson 108-2 · Concord, CAApr 10, 1966 · N9305K · Substantial damage NTSB UNK64X2651Accident · Minor injuriesClosedBoeing A75 · Corcoran, CAJul 4, 1964 · N53229 · 2 aircraft · Substantial damage NTSB UNK64X2145Accident · No injuriesClosedStinson 1082 · Oroville, CAJun 6, 1964 · N9640K · Substantial damage NTSB UNK64X1277Accident · No injuriesClosedStinson 108 · Redding, CAApr 12, 1964 · N418C · Substantial damage NTSB UNK64X0446Accident · No injuriesClosedStinson 108-2 · San Jose, CAFeb 2, 1964 · N9553K · Substantial damage