Skip to content

NTSB investigations: Stinson 108-2

264 cases on aircraft the registry lists as Stinson 108-2. 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 ('9230406')) 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 ('9230406'))
  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 ('9230406'))
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 CHI80DEM19Accident · No injuriesClosedStinson 108-2 · Marquette, MIMar 16, 1980 · N8563K · Substantial damage NTSB LAX80DUM10Accident · No injuriesClosedStinson 108-2 · Borrego Sprngs, CAFeb 5, 1980 · N9698K · Destroyed NTSB DEN79FQA43Accident · No injuriesClosedStinson 108-2 · Mid Valley, NMJul 29, 1979 · N45CG · Substantial damage NTSB IAD79FKM18Accident · No injuriesClosedStinson 108 · Mooresville, NCJul 4, 1979 · N474C · Substantial damage NTSB NYC79DFA22Accident · No injuriesClosedStinson 108-2 · Saranac Lake, NYJun 15, 1979 · N9583K · Substantial damage NTSB OAK79FVD14Accident · No injuriesClosedStinson 108-2 · Tiburon, CAMar 4, 1979 · N388C · Substantial damage NTSB DEN79DTC08Accident · No injuriesClosedStinson 108-2 · Lander, WYFeb 21, 1979 · N9835K · Substantial damage NTSB ANC79DAD01Accident · Minor injuriesClosedStinson 108 · Angoon, AKNov 28, 1978 · N341C · Substantial damage NTSB ANC78DAA38Accident · Minor injuriesClosedStinson 108-2 · Totatlanika Rv, AKAug 31, 1978 · N374C · Substantial damage NTSB MKC78DER40Accident · No injuriesClosedStinson 108-2 · Minneapolis, MNJun 15, 1978 · N916D · Substantial damage NTSB ANC78DAG32Accident · No injuriesClosedStinson 108-2 · Wasilla, AKMar 17, 1978 · N143C · Substantial damage NTSB CHI78DEX13Accident · No injuriesClosedStinson 108-2 · Connersville, INFeb 26, 1978 · N9451K · Substantial damage NTSB ANC78FAG26Accident · Minor injuriesClosedStinson 108-2 · Glenallen, AKFeb 21, 1978 · N9542K · Substantial damage NTSB OAK77DVA56Accident · No injuriesClosedStinson 108 · Groveland, CASep 17, 1977 · N9825K · Substantial damage NTSB DEN77FTE76Accident · No injuriesClosedStinson 108-2 · Boulder, COAug 20, 1977 · N9389K · Substantial damage NTSB MKC77DTK25Accident · No injuriesClosedStinson 108-2 · Ft Thompson, SDJun 11, 1977 · N392C · Substantial damage NTSB MIA77FLD61Accident · Serious injuriesClosedStinson 108-2 · Frostproof, FLMay 30, 1977 · N371C · Substantial damage NTSB NYC77DFA24Accident · No injuriesClosedStinson 108 · Potsdam, NYMay 15, 1977 · N9314K · Substantial damage NTSB DEN77DTC07Accident · No injuriesClosedStinson 108-2 · Laramie, WYMar 12, 1977 · N992D · Substantial damage NTSB DEN77DTC06Accident · No injuriesClosedStinson 108-2 · Rock Springs, WYMar 6, 1977 · N9567K · Substantial damage NTSB ANC77FA031Accident · 2 fatalClosedStinson 108-2 · Merrill Pass, AKFeb 18, 1977 · N97274 · Substantial damage NTSB MKC77FCD07Accident · No injuriesClosedStinson 108 · Griswold, IAJan 7, 1977 · N8035K · Substantial damage NTSB DEN76FTE95Accident · No injuriesClosedStinson 108-2 · Peyton, COSep 6, 1976 · N9320K · Substantial damage NTSB ANC76FAA56Accident · Minor injuriesClosedStinson 108-2 · Delta Junction, AKSep 2, 1976 · N9199K · Substantial damage NTSB MKC76FCJ62Accident · No injuriesClosedStinson 108-2 · Mccook, NEAug 6, 1976 · N9661K · Substantial damage NTSB DEN76AD056Accident · 4 fatalClosedStinson 108-2 · Kamas, UTJun 29, 1976 · N8015K · Destroyed NTSB SEA76AS048Accident · 1 fatalClosedStinson 108-2 · Dundee, ORMay 14, 1976 · N9728K · Destroyed NTSB ANC76DAA34Accident · No injuriesClosedStinson 108-2 · Fairbanks, AKApr 18, 1976 · N904D · Substantial damage NTSB DEN76DTM22Accident · No injuriesClosedStinson 108-2 · Bryce Canyon, UTMar 13, 1976 · N9698K · Substantial damage NTSB IAD76FIG07Accident · Minor injuriesClosedStinson 108 · Davidsonville, MDNov 29, 1975 · N9520K · Substantial damage NTSB NYC76AN047Accident · 1 fatalClosedStinson 108-2 · Bellows Falls, VTOct 29, 1975 · N9464K · Destroyed NTSB ANC76DAG56Accident · No injuriesClosedStinson 108-2 · Gulkana, AKOct 17, 1975 · N9462K · Substantial damage NTSB NYC76DNC08Accident · Minor injuriesClosedStinson 108 · Bangor, MEAug 10, 1975 · N9368K · Substantial damage NTSB OAK75DVM38Accident · No injuriesClosedStinson 108-2 · Morgan Hill, CAJun 20, 1975 · N9502K · Substantial damage NTSB LAX75O0028Accident · Serious injuriesClosedStinson 108-2 · Bahia De L.A., MexicoJun 14, 1975 · N9512K · Destroyed NTSB LAX75FUG46Accident · Serious injuriesClosedStinson 108-2 · Rubidoux, CAJun 6, 1975 · N9765K · Destroyed NTSB CHI75AC088Accident · 1 fatalClosedStinson 108-2 · Jackson, MIMay 18, 1975 · N9508K · Destroyed NTSB SEA75AS041Accident · 2 fatalClosedStinson 108-2 · Gimlet, IDMay 17, 1975 · N9632K · Destroyed NTSB CHI75FEP41Accident · No injuriesClosedStinson 108-2 · Dodgeville, WIMar 2, 1975 · N9401K · Substantial damage NTSB SEA75DTI14Accident · No injuriesClosedStinson 108-2 · Wisdom, MTOct 27, 1974 · N9815K · Substantial damage NTSB DEN75DTE20Accident · No injuriesClosedStinson 108 · Montrose, COAug 29, 1974 · N9416K · Substantial damage NTSB IAD75FIG02Accident · No injuriesClosedStinson 108-2 · Laurel, MDAug 15, 1974 · N9730K · Substantial damage NTSB CHI75FEC07Accident · No injuriesClosedStinson 108 · Dansville, MIJul 29, 1974 · N9805K · Substantial damage NTSB DEN74DTE87Accident · No injuriesClosedStinson 108-2 · Holyoke, COJun 28, 1974 · N321C · Substantial damage NTSB MIA74DKJ30Accident · No injuriesClosedStinson 108 · Dothan, ALApr 7, 1974 · N925D · Substantial damage NTSB FTW74FPA15Accident · Serious injuriesClosedStinson 108-2 · Dallas, TXJan 13, 1974 · N972D · Substantial damage NTSB SEA74DTI13Accident · No injuriesClosedStinson 108-2 · Plains, MTNov 9, 1973 · N9610K · Substantial damage NTSB NYC74DGT10Accident · No injuriesClosedStinson 108-2 · East Waterford, PASep 28, 1973 · N9745K · Substantial damage NTSB MKC74FCA08Accident · No injuriesClosedStinson 108-2 · Kennett, MOSep 10, 1973 · N9532K · Substantial damage NTSB ANC74FAA08Accident · No injuriesClosedStinson 108-2 · North Pole, AKAug 26, 1973 · N9525K · Substantial damage