Skip to content

NTSB investigations: Stinson 108

186 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, 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 ('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.\"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."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 MIA67D0121Accident · No injuriesClosedStinson 108-3 · Wauchula, FLAug 3, 1966 · N6944M · Substantial damage NTSB CHI67D0219Accident · No injuriesClosedStinson 108 · Grays Lake, ILJul 10, 1966 · N39468 · Substantial damage NTSB CHI67F0077Accident · No injuriesClosedStinson 108 · Ravenna, MIJul 4, 1966 · N97616 · Substantial damage NTSB SEA67D0039Accident · Serious injuriesClosedStinson 108 · Buhl, IDJun 25, 1966 · N97306 · Destroyed NTSB FTW67D0024Accident · No injuriesClosedStinson 108 · Tulsa, OKJun 21, 1966 · N97424 · Substantial damage NTSB MIA67F0095Accident · Serious injuriesClosedStinson 108-2 · Atlanta, GAJun 12, 1966 · N40155 · Destroyed NTSB CHI66F0760Accident · No injuriesClosedStinson 108-1 · Walbridge, OHMay 1, 1966 · N97510 · 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 MIA66F0299Accident · No injuriesClosedStinson 108-1 · Plantation, FLOct 17, 1965 · N8472K · Substantial damage NTSB NYC66F0293Accident · No injuriesClosedStinson 108-1 · Westfield, MAOct 8, 1965 · N97376 · Substantial damage NTSB NYC66F0266Accident · No injuriesClosedStinson 108 · Amherst, NYSep 22, 1965 · N97498 · Substantial damage NTSB ANC66AA011Accident · 2 fatalClosedStinson 108-2 · Council, AKSep 12, 1965 · N314C · Destroyed NTSB CHI66D0342Accident · Minor injuriesClosedStinson 108 · Hanoverton, OHSep 9, 1965 · N97662 · Substantial damage NTSB ANC66F0027Accident · Minor injuriesClosedStinson 108 · Fairbanks, AKAug 19, 1965 · N40160 · Substantial damage NTSB CHI66D0183Accident · Minor injuriesClosedStinson 108 · Put In Bay, OHJul 3, 1965 · N8173K · Destroyed NTSB NYC65F0238Accident · No injuriesClosedStinson 108 · Kingwood, WVMay 16, 1965 · N97709 · Destroyed NTSB CHI65F0164Accident · No injuriesClosedStinson 108-2 · Holland, MIMay 15, 1965 · N8052K · Substantial damage NTSB DEN65D0071Accident · No injuriesClosedStinson 108 · Worland, WYApr 24, 1965 · N97328 · Substantial damage NTSB MIA65F0089Accident · No injuriesClosedStinson 108-3 · Pink Hill, NCApr 22, 1965 · N6302M · Substantial damage NTSB NYC65F0112Accident · No injuriesClosedStinson 108 · Weedsport, NYApr 4, 1965 · N97488 · Substantial damage NTSB UNK65X1084Accident · 2 fatalClosedStinson 108 · Salem, ORDec 21, 1964 · N97562 · Destroyed NTSB UNK65X0519Accident · Serious injuriesClosedStinson 108 · Arvin, CANov 1, 1964 · N8386K · Destroyed NTSB UNK64X3867Accident · No injuriesClosedBeechcraft C18 · Brownsburg, INSep 7, 1964 · N44569 · 2 aircraft · Minor damage NTSB UNK64X3552Accident · No injuriesClosedStinson 108 · Aliquippa, PAAug 23, 1964 · N8320K · Substantial damage NTSB UNK64X3547Accident · 2 fatalClosedStinson 108 · Morgan, TXAug 22, 1964 · N39497 · Destroyed NTSB UNK64X3538Accident · No injuriesClosedStinson 108 · Marion, IAAug 22, 1964 · N97656 · Substantial damage NTSB UNK64X3517Accident · No injuriesClosedStinson 108-2 · Des Moines, IAAug 21, 1964 · N9478K · Substantial damage NTSB UNK64X3174Accident · No injuriesClosedStinson 108 · Ashfork, AZAug 2, 1964 · N97623 · Substantial damage NTSB UNK64X2002Accident · Minor injuriesClosedStinson 108-1 · Suffolk, VAMay 29, 1964 · N9066K · Destroyed NTSB UNK64X1756Accident · Minor injuriesClosedStinson 108 · Barnesville, MDMay 13, 1964 · N40190 · Destroyed NTSB UNK64X1611Accident · No injuriesClosedStinson 108 · Chelan, WAMay 4, 1964 · N97626 · Substantial damage NTSB UNK64X1547Accident · No injuriesClosedStinson 108 · Flanigan, NVMay 1, 1964 · N97272 · Destroyed NTSB UNK64X1025Accident · Serious injuriesClosedStinson 108 · Palmdale, CAMar 23, 1964 · N97244 · Destroyed NTSB UNK64X0498Accident · No injuriesClosedStinson 108 · Glidden, WIFeb 8, 1964 · N97431 · Substantial damage NTSB UNK64X0413Accident · Minor injuriesClosedStinson 108-3 · Silver City, NCJan 31, 1964 · N651C · Substantial damage