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 SEA68F0254Accident · No injuriesClosedStinson 108-3 · Yakima, WAMar 13, 1968 · N6116M · Substantial damage NTSB DEN68F0215Accident · Minor injuriesClosedStinson 108-3 · Boulder, COFeb 11, 1968 · N524C · Substantial damage NTSB NYC68D0256Accident · No injuriesClosedStinson 108-3 · Mongaup Valley, NYOct 13, 1967 · N6935M · Destroyed NTSB NYC68F0231Accident · Minor injuriesClosedStinson 108-3 · Oyster Bay, NYOct 7, 1967 · N6247M · Destroyed NTSB UNK67X0159Accident · Minor injuriesClosedStinson 108-3 · Wauchula, FLSep 22, 1967 · N6019M · Substantial damage NTSB MKC68D0226Accident · No injuriesClosedStinson 108-3 · Painton, MOSep 9, 1967 · N625C · Substantial damage NTSB CHI68F0264Accident · Serious injuriesClosedStinson 108-3 · Lore City, OHSep 7, 1967 · N6421M · Substantial damage NTSB DEN68D0093Accident · Serious injuriesClosedStinson 108-3 · Gallup, NMSep 4, 1967 · N6237M · Substantial damage NTSB CHI68F0208Accident · No injuriesClosedStinson 108-3 · Flushing, MIAug 28, 1967 · N712C · Substantial damage NTSB NYC68A0003Accident · 2 fatalClosedStinson 108-3 · Woodstock, CTJul 6, 1967 · N595C · Destroyed NTSB NYC68D0039Accident · No injuriesClosedStinson 108-3 · Amityville, NYJun 8, 1967 · N6247M · Substantial damage NTSB NYC68D0033Accident · No injuriesClosedStinson 108-3 · St.Regis Falls, NYMay 30, 1967 · N6759M · Substantial damage NTSB OAK68D0086Accident · No injuriesClosedStinson 108-3 · Las Vegas, NVMay 27, 1967 · N6425M · Substantial damage NTSB MIA67D0564Accident · Minor injuriesClosedStinson 108-3 · Satsuma, FLMay 20, 1967 · N6964M · Substantial damage NTSB FTW67F0580Accident · Serious injuriesClosedStinson 108-3 · Whitney, TXApr 14, 1967 · N6625M · Destroyed NTSB NYC67D0544Accident · No injuriesClosedStinson 108-3 · Spring Valley, NYFeb 27, 1967 · N6961M · Substantial damage NTSB MKC67F0460Accident · Minor injuriesClosedStinson 108-3 · Lincoln, NEFeb 26, 1967 · N831C · Substantial damage NTSB LAX67F0306Accident · Serious injuriesClosedStinson 108-3 · Kernville, CAFeb 5, 1967 · N6584M · Substantial damage NTSB FTW67D0380Accident · 3 fatalClosedStinson 108 · Matamoros, MexicoDec 31, 1966 · N6879M · Destroyed NTSB FTW67D0336Accident · No injuriesClosedStinson 108-3 · Houston, TXNov 26, 1966 · N798C · Substantial damage NTSB NYC67F0372Accident · Serious injuriesClosedStinson 108-3 · New Castle, PANov 13, 1966 · N6970M · Destroyed NTSB SEA67D0195Accident · No injuriesClosedStinson 108-3 · Malta, MTOct 19, 1966 · N659C · Substantial damage NTSB LAX67D0178Accident · No injuriesClosedStinson 108-3 · Van Nuys, CAOct 8, 1966 · N671C · Substantial damage NTSB MIA67F0209Accident · No injuriesClosedStinson 108-3 · Marietta, GASep 10, 1966 · N885C · Substantial damage NTSB SEA67F0133Accident · No injuriesClosedStinson 108-3 · Hamilton, MTAug 22, 1966 · N6669M · Substantial damage NTSB OAK67D0061Accident · No injuriesClosedStinson 108 · Crescent City, CAAug 10, 1966 · N6356M · Substantial damage NTSB CHI67F0090Accident · Minor injuriesClosedStinson 108 · Mishawaka, INJul 10, 1966 · N4002C · Substantial damage NTSB OAK66D0269Accident · No injuriesClosedStinson 108-3 · Santa Rosa, CAMay 1, 1966 · N6312M · Substantial damage NTSB OAK66A0043Accident · 1 fatalClosedStinson 108-3 · Incoln, NEApr 2, 1966 · N6317M · Destroyed NTSB LAX66F0325Accident · No injuriesClosedStinson 108-3 · Minden, NVMar 21, 1966 · N620C · Substantial damage NTSB NYC66D0445Accident · No injuriesClosedStinson 108-3 · Hartford, CTJan 11, 1966 · N4213C · Substantial damage 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 CHI66D0436Accident · Minor injuriesClosedStinson 108-3 · Portage, WIOct 24, 1965 · N1000M · Substantial damage NTSB LAX66D0145Accident · No injuriesClosedStinson 108-3 · Riverside, CAOct 20, 1965 · N923C · Substantial damage NTSB NYC66A0032Accident · 1 fatalClosedStinson 108-3 · Milroy, PASep 5, 1965 · N6353M · Destroyed NTSB ANC66D0028Accident · No injuriesClosedStinson 108-3 · Gold King, AKAug 30, 1965 · N6629M · Substantial damage NTSB CHI66F0181Accident · No injuriesClosedStinson 108-3 · Springfield, ILAug 12, 1965 · N726C · Substantial damage NTSB MIA66A0012Accident · 1 fatalClosedStinson 108-3 · Oliver Sprgs, TNJul 19, 1965 · N6773M · Destroyed NTSB NYC66F0188Accident · No injuriesClosedStinson 108-3 · Amherst, NYJul 18, 1965 · N860C · Substantial damage NTSB CHI66F0166Accident · No injuriesClosedStinson 108 · Lac Duflambeu, WIJul 8, 1965 · N6865M · Substantial damage NTSB MKC66D0079Accident · No injuriesClosedStinson 108-3 · Branson, MOJun 20, 1965 · N6082M · Substantial damage NTSB OAK65F0010Accident · No injuriesClosedStinson 108-3 · Fresno, CAMar 27, 1965 · N6679M · Destroyed NTSB MKC65F0130Accident · No injuriesClosedStinson 108-3 · St Paul, MNMar 21, 1965 · N653C · Substantial damage NTSB NYC65F0072Accident · No injuriesClosedStinson 108-3 · Clinton, MDMar 1, 1965 · N6756M · Minor damage NTSB UNK65X1224Accident · No injuriesClosedStinson 108 · Fallon, NVJan 3, 1965 · N6322M · Substantial damage NTSB MIA65A0070Accident · 1 fatalClosedStinson 108-3 · Bunnell, FLJan 1, 1965 · N525C · Destroyed NTSB UNK65X1182Accident · Serious injuriesClosedStinson 108-3 · Van Nuys, CADec 29, 1964 · N6641M · Destroyed NTSB UNK65X0945Accident · No injuriesClosedStinson 108-3 · Croton, NYDec 7, 1964 · N4087C · Substantial damage NTSB UNK65X0507Accident · No injuriesClosedStinson 108-3 · Plympton, MANov 1, 1964 · N4145C · Substantial damage