Skip to content

Fatal NTSB investigations: Stinson 108-3

27 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.

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 ('9230408')) 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 ('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."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 ('9230408'))
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 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…Sep 5, 1994 · N6446M · Destroyed 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…Feb 20, 1994 · N6009M · Destroyed NTSB CHI92FA211Accident · 2 fatalField investigationFinal reportStinson 108-3 · Boonville, MOInadequate preflight planning, and exceeding the performance capability of the airplane by the pilot-in-command.Jul 25, 1992 · N948C · Destroyed NTSB FTW88DPJ05Accident · 1 fatalFinal reportStinson 108-3 · Collinsville, OKThe pilot experienced a loss of engine power during the takeoff leg. Post accident investigation revealed that the fuel selector was in the near closed position. This position only allowed a small percentage of the fuel to flow but would allow operation in…Jun 6, 1988 · N4108C · Destroyed NTSB FTW87FA179Accident · 1 fatalField investigationFinal reportStinson 108-3 · Kirbyville, TXThe pilot approached the Kirbyville airport in preparation for landing, witnesses stated that smoke was observed coming from the engine area. The aircraft impacted 30 foot pine trees, & control was lost. The aircraft struck a large tree approximately 5 feet…Jul 27, 1987 · N744C · Destroyed NTSB CHI86FA179Accident · 2 fatalField investigationFinal reportStinson 108-3 · Shiocton, WIWitnesses rprtd that prior to the acdnt, the acft was flying at a very low level, near treetop level, over residences, a ball park & a lake park. Subsequently, the acft collided with a utility pole & trees, then crashed into a private residence & burst into…Jul 26, 1986 · N6567M · Destroyed NTSB ANC84FA169Accident · 1 fatalField investigationFinal reportStinson 108 · Hayes River, AKThe plt was on a low level flt to spot wild game when the acft crashed on a gravel drainage bar. A witness stated the acft was flying 5 to 6 ft AGL when the accident occurred.Sep 9, 1984 · N6660M · Destroyed NTSB SEA84FA111Accident · 4 fatalField investigationFinal reportStinson 108-3 · Portland, ORThe plt was briefed on the weather along his intended route of flt & VFR flt was not recommended. The acft departed vancouver, WA, and flew to tigard, OR. It was observed to depart tigard at about 1810 PDT. Numerous witnesses reported that at about 1815, they…May 20, 1984 · N20Q · Destroyed NTSB SEA83FA018Accident · 2 fatalField investigationFinal reportStinson 108-3 · Lynnwood, WAThe eng failed approaching the arpt at low altitude. The acft struck trees during a descending turn toward a power company right-of-way. Investigation revealed that the impulse drive springs on both magnetos had failed in fatigue. The springs are not assigned…Nov 13, 1982 · N6943M · Destroyed NTSB IAD78FA010Accident · 1 fatalClosedStinson 108-3 · Knoxville, TNJul 27, 1977 · N6734M · Destroyed NTSB CHI73AC093Accident · 3 fatalClosedStinson 108-3 · Freeland, MIMay 27, 1973 · N4125C · Destroyed NTSB NYC72FNC21Incident · 1 fatalClosedStinson 108-3 · Princeton, MEJan 7, 1972 · N6070M · Minor damage NTSB CHI72AC020Accident · 1 fatalClosedStinson 108-3 · Fowlerville, MISep 5, 1971 · N6480M · Destroyed NTSB LAX71FUM30Accident · 2 fatalClosedStinson 108 · Ocotillo, CAMar 2, 1971 · N729C · Destroyed NTSB SEA71AS036Accident · 1 fatalClosedStinson 108-3 · Azalea, ORJan 23, 1971 · N6065M · Destroyed NTSB LAX69A0060Accident · 1 fatalClosedStinson 108-3 · Sta Monica, CAApr 20, 1969 · N6485M · Destroyed NTSB MIA69A0028Accident · 2 fatalClosedStinson 108-3 · Ft.Lauderdale, FLNov 28, 1968 · N4174C · Destroyed NTSB CHI68A0108Accident · 2 fatalClosedStinson 108-3 · Put-In-Bay, OHJun 10, 1968 · N6780M · Destroyed NTSB MKC68A0069Accident · 2 fatalClosedStinson 108-3 · Dubuque, IAMay 26, 1968 · N6932M · Destroyed NTSB NYC68A0003Accident · 2 fatalClosedStinson 108-3 · Woodstock, CTJul 6, 1967 · N595C · Destroyed NTSB FTW67D0380Accident · 3 fatalClosedStinson 108 · Matamoros, MexicoDec 31, 1966 · N6879M · Destroyed NTSB OAK66A0043Accident · 1 fatalClosedStinson 108-3 · Incoln, NEApr 2, 1966 · N6317M · Destroyed NTSB MIA66A0056Accident · 3 fatalClosedStinson 108-3 · Lawndale, NCNov 11, 1965 · N6733M · Destroyed NTSB SEA66A0028Accident · 1 fatalClosedStinson 108-3 · Augusta, MTOct 28, 1965 · N348 · Destroyed NTSB NYC66A0032Accident · 1 fatalClosedStinson 108-3 · Milroy, PASep 5, 1965 · N6353M · Destroyed NTSB MIA66A0012Accident · 1 fatalClosedStinson 108-3 · Oliver Sprgs, TNJul 19, 1965 · N6773M · Destroyed NTSB MIA65A0070Accident · 1 fatalClosedStinson 108-3 · Bunnell, FLJan 1, 1965 · N525C · Destroyed