Skip to content

NTSB investigations: Stinson 108-1

283 cases on aircraft the registry lists as Stinson 108-1. 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 ('9230404')) 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 ('9230404'))
  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 ('9230404'))
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 CHI66F0227Accident · No injuriesClosedStinson 108-1 · Wilmington, ILAug 22, 1965 · N8982K · Substantial damage NTSB CHI66D0190Accident · No injuriesClosedStinson 108-1 · Youngstown, OHAug 6, 1965 · N8715K · Substantial damage NTSB SEA66D0114Accident · No injuriesClosedStinson 108 · Sultan, WAJul 30, 1965 · N8760K · Substantial damage NTSB MIA66F0144Accident · Serious injuriesClosedStinson 108 · Booneville, NCJul 5, 1965 · N8450K · Substantial damage NTSB CHI65F0184Accident · No injuriesClosedStinson 108 · Delaware, OHMay 30, 1965 · N8389K · Substantial damage NTSB CHI65F0199Accident · No injuriesClosedStinson 108 · Walbridge, OHMay 22, 1965 · N8194K · Substantial damage NTSB NYC66D0052Accident · No injuriesClosedStinson 108-1 · Bridgeville, PAMay 16, 1965 · N8914K · Substantial damage NTSB MKC65F0140Accident · No injuriesClosedStinson 108-1 · Hugoton, KSMay 15, 1965 · N8334K · Substantial damage NTSB LAX65A0088Accident · 1 fatalClosedStinson 108-1 · Newport Beach, CAMay 10, 1965 · N8655K · Destroyed NTSB FTW66F0009Accident · No injuriesClosedStinson 108-1 · Texarkana, ARMar 14, 1965 · N8755K · Substantial damage NTSB MIA65F0041Accident · No injuriesClosedStinson 108-1 · Hampton, SCMar 7, 1965 · N97091 · Substantial damage NTSB CHI65F0056Accident · No injuriesClosedStinson 108-2 · Hinsdale, ILFeb 20, 1965 · N9712K · Substantial damage NTSB UNK65X1025Accident · No injuriesClosedStinson 108-1 · Groveland, FLDec 16, 1964 · N8645K · Substantial damage NTSB UNK65X0702Accident · No injuriesClosedStinson 108-1 · Collegeville, PANov 14, 1964 · N9202K · Substantial damage NTSB UNK65X0674Accident · Minor injuriesClosedStinson 108-1 · Greenville, MINov 12, 1964 · N8945K · Substantial damage NTSB UNK65X0655Accident · No injuriesClosedStinson 108-1 · Painesville, OHNov 11, 1964 · N97761 · Substantial damage NTSB UNK64X4138Accident · Minor injuriesClosedStinson 108-1 · Corona, CASep 25, 1964 · N97984 · Destroyed NTSB UNK64X3822Accident · No injuriesClosedStinson 108-1 · Ardmore, OKSep 6, 1964 · N8149K · Substantial damage NTSB UNK64X3273Accident · No injuriesClosedStinson 108 · Montour, IDAug 8, 1964 · N97935 · Substantial damage NTSB UNK64X3114Accident · Minor injuriesClosedStinson 108-1 · Mulege Baja, MexicoJul 30, 1964 · N801 · Destroyed NTSB UNK64X3044Accident · No injuriesClosedStinson 108-2 · Woonsocket, RIJul 26, 1964 · N875D · Substantial damage NTSB UNK64X2976Accident · Minor injuriesClosedStinson 108 · Madison, TNJul 22, 1964 · N8268K · Destroyed NTSB UNK64X2667Accident · No injuriesClosedStinson 108-1 · Ganges Tnshp, MIJul 5, 1964 · N8874K · Substantial damage NTSB UNK64X2375Accident · No injuriesClosedStinson 1081 · Peoria, ILJun 19, 1964 · N8543K · Substantial damage NTSB UNK64X2053Accident · No injuriesClosedStinson 108 · Anaconda, MTMay 31, 1964 · N8599K · Substantial damage NTSB UNK64X1448Accident · No injuriesClosedStinson 108 · Aitkin, MNApr 25, 1964 · N8545K · Substantial damage NTSB UNK64X1434Accident · No injuriesClosedStinson 108 · Greenville, MIApr 24, 1964 · N211C · Substantial damage NTSB UNK64X1170Accident · No injuriesClosedStinson 108-1 · Minden, NVApr 4, 1964 · N9100K · Substantial damage NTSB UNK64X1134Accident · No injuriesClosedStinson 108 · Orville, CAApr 2, 1964 · N8555K · Substantial damage NTSB UNK64X1029Accident · No injuriesClosedStinson 108-1 · Vineland, NJMar 24, 1964 · N9110K · Destroyed NTSB UNK64X0988Accident · Minor injuriesClosedStinson 108 · Halfday, ILMar 20, 1964 · N97579 · Destroyed NTSB UNK64X0680Accident · No injuriesClosedStinson 108-1 · Grain Valley, MOFeb 23, 1964 · N97989 · Substantial damage NTSB UNK64X0161Accident · No injuriesClosedStinson 108-1 · Chesapeake, VAJan 5, 1964 · N97861 · Substantial damage