Skip to content

NTSB investigations: Stinson 108-3

318 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, newest first

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."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.\"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."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 CHI76FEC64Accident · No injuriesClosedStinson 108-3 · Deckerville, MISep 18, 1976 · N6108M · Substantial damage NTSB CHI76FEM58Accident · No injuriesClosedStinson 108-3 · Cedar Springs, MISep 5, 1976 · N6580M · Substantial damage NTSB DEN76DTC36Accident · Minor injuriesClosedStinson 108 · Casper, WYJun 29, 1976 · N512C · Substantial damage NTSB CHI76FEK17Accident · No injuriesClosedStinson 108-3 · Delaware, OHJun 2, 1976 · N6898M · Substantial damage NTSB NYC76DNA39Accident · No injuriesClosedStinson 108-3 · Oak Bluffs, MAMay 23, 1976 · N6275M · Substantial damage NTSB SEA76FYC34Accident · No injuriesClosedStinson 108-3 · Goldendale, WAMay 9, 1976 · N6699M · Substantial damage NTSB FTW76DPD39Accident · No injuriesClosedStinson 108-3 · Vernon, TXMay 4, 1976 · N646C · Substantial damage NTSB ANC76FAA29Accident · Serious injuriesClosedStinson 108-3 · Koyuk, AKMar 21, 1976 · N6946M · Substantial damage NTSB ANC76DAG87Accident · No injuriesClosedStinson 108 · Willow, AKFeb 1, 1976 · N691C · Substantial damage NTSB OAK76DXQ13Accident · No injuriesClosedStinson 108-3 · Winnemucca, NVSep 1, 1975 · N6355M · Substantial damage NTSB OAK76DVG24Accident · Minor injuriesClosedStinson 108-3 · Walnut Grove, CAAug 29, 1975 · N6768M · Substantial damage NTSB SEA76DYA03Accident · No injuriesClosedStinson 108-3 · Idaho Falls, IDJul 13, 1975 · N511C · Substantial damage NTSB LAX76DUJ02Accident · No injuriesClosedStinson 108-3 · Springerville, AZJul 3, 1975 · N6425M · Substantial damage NTSB LAX75DUJ90Accident · No injuriesClosedStinson 108-3 · Tucson, AZJun 7, 1975 · N871C · Substantial damage NTSB NYC75FHM21Accident · Minor injuriesClosedStinson 108-3 · Teterboro, NJMay 28, 1975 · N6961M · Substantial damage NTSB CHI75DEP49Accident · No injuriesClosedStinson 108-3 · Sturtevant, WIApr 10, 1975 · N508C · Substantial damage NTSB MIA75FKJ46Accident · No injuriesClosedStinson 108-3 · Luverne, ALMar 14, 1975 · N6328M · Destroyed NTSB FTW75FQG33Accident · Minor injuriesClosedStinson 108-3 · Plains, TXNov 27, 1974 · N6192M · Substantial damage NTSB CHI75FEV12Accident · No injuriesClosedStinson 108 · Savoy, ILNov 12, 1974 · N596C · Substantial damage NTSB MKC75DCJ33Accident · No injuriesClosedStinson 108-3 · Alliance, NEOct 16, 1974 · N4123C · Substantial damage NTSB ANC75DAG39Accident · No injuriesClosedStinson 108-3 · Skwentna, AKSep 24, 1974 · N958C · Substantial damage NTSB CHI75DEP26Accident · Minor injuriesClosedStinson 108-3 · Kenosha, WISep 21, 1974 · N899C · Substantial damage NTSB LAX75DUJ24Accident · Serious injuriesClosedStinson 108-3 · Grnd Canyon, AZSep 1, 1974 · N4056C · Destroyed NTSB MKC75FCG02Accident · Minor injuriesClosedStinson 108-3 · Harrisonville, MOJul 14, 1974 · N6782M · Substantial damage NTSB MKC74DCD23Accident · No injuriesClosedStinson 108 · Sheldon, IAMar 5, 1974 · N6688M · Substantial damage NTSB ANC74DAG91Accident · No injuriesClosedStinson 108-3 · Nicholi, AKFeb 25, 1974 · N6203M · Substantial damage NTSB LAX74DUG33Accident · No injuriesClosedStinson 108-3 · Apple Vally, CADec 23, 1973 · N6206M · Substantial damage NTSB MIA74DLD01Accident · No injuriesClosedStinson 108-3 · Ft.Pierce, FLJul 4, 1973 · N6954M · Substantial damage NTSB LAX73FUJ83Accident · Serious injuriesClosedStinson 108-3 · Tucson, AZJun 9, 1973 · N6099M · Substantial damage NTSB ANC73FAA25Accident · No injuriesClosedStinson 108-3 · Fairbanks, AKJun 3, 1973 · N6177M · Substantial damage NTSB CHI73AC093Accident · 3 fatalClosedStinson 108-3 · Freeland, MIMay 27, 1973 · N4125C · Destroyed NTSB CHI73FEA31Accident · No injuriesClosedStinson 108-3 · Carmel, INApr 5, 1973 · N747C · Substantial damage NTSB SEA73DYE27Accident · Minor injuriesClosedStinson 108-3 · Anacortes, WAFeb 18, 1973 · N6585M · Substantial damage NTSB SEA73DYA16Accident · Minor injuriesClosedStinson 108-3 · New Meadows, IDFeb 3, 1973 · N771C · Substantial damage NTSB CHI73FEC18Accident · No injuriesClosedStinson 108-3 · Brighton, MIDec 17, 1972 · N6769M · Substantial damage NTSB ANC73DAG59Accident · Minor injuriesClosedStinson 108-3 · Talkeetna, AKNov 7, 1972 · N857C · Substantial damage NTSB MKC73DCD38Accident · No injuriesClosedStinson 108-3 · Mason City, IANov 5, 1972 · N4097C · Substantial damage NTSB CHI73FEI16Accident · No injuriesClosedStinson 108-3 · Elyria, OHOct 13, 1972 · N547C · Substantial damage NTSB NYC73DHA07Accident · Minor injuriesClosedStinson 108-3 · Moscow, PASep 16, 1972 · N742C · Substantial damage NTSB OAK73DXQ16Accident · No injuriesClosedStinson 108 · Reno, NVSep 8, 1972 · N6200M · Substantial damage NTSB NYC72FNC42Accident · Serious injuriesClosedStinson 108-3 · Princeton, MEApr 30, 1972 · N6070M · Substantial damage NTSB LAX72DUJ96Accident · No injuriesClosedStinson 108-3 · Pierce Fery, AZApr 30, 1972 · N817C · Substantial damage NTSB OAK72DVD40Accident · No injuriesClosedStinson 108-3 · Oakland, CAApr 18, 1972 · N6295M · Substantial damage NTSB ANC72DAH05Accident · No injuriesClosedStinson 108-3 · Spenard, AKMar 17, 1972 · N857C · Substantial damage NTSB SEA72FTA13Accident · Minor injuriesClosedStinson 108-3 · Red Lodge, MTFeb 26, 1972 · N6984M · Substantial damage NTSB NYC72FNC21Incident · 1 fatalClosedStinson 108-3 · Princeton, MEJan 7, 1972 · N6070M · Minor damage NTSB CHI72DEA14Accident · No injuriesClosedStinson 108-3 · Acton, INOct 2, 1971 · N6919M · Destroyed NTSB MKC72FCG17Accident · Serious injuriesClosedStinson 108-3 · Amazonia, MOSep 10, 1971 · N559C · Substantial damage NTSB CHI72AC020Accident · 1 fatalClosedStinson 108-3 · Fowlerville, MISep 5, 1971 · N6480M · Destroyed NTSB NYC72DHM10Accident · No injuriesClosedStinson 108 · Kingston, NYAug 17, 1971 · N742C · Substantial damage