NTSB investigations: Stinson 108-3
8 cases on aircraft the registry lists as Stinson 108-3, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 2002 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9230408')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9230408')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
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 IAD02LA064Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Mifflintown, PAOn-ground carburetor icing.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 CHI93LA004Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Mountain, WIThe pilot's failure to refuel the airplane.NTSB ANC91LA157Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Cantwell, AKThe engine power loss for undetermined reasons and the lack of suitable terrain for a forced landing.NTSB SEA90LA123Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Worley, IDImproper planning/decision by the pilot, which resulted in an inadequate supply of fuel and fuel exhaustion. The high vegetation (wheat crop) and rough terrain (rut) were related factors.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…NTSB ANC84LA069Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Soldotna, AKThe acft was established in normal cruise when the engine quit. The pilot attempted restarts with negative results. The acft made a forced landing and collided with trees. Post accident examination revealed water in the fuel tanks & lines.NTSB SEA82FA093Accident · Serious injuriesField investigationFinal reportStinson 108-3 · Lopez Island, WAThe aircraft engine stopped at 400 feet AGL during climbout. The pilot executed a turn at minimum airspeed and landed the aircraft on a golf course. The landing gear and engine mounts failed. Investigation revealed the aircraft's fuel tanks were empty.