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 MIA69F0416Accident · 1 fatalClosedStinson 108-2 · Russellville, ALFeb 21, 1969 · N97478 · Destroyed NTSB CHI69D0486Accident · No injuriesClosedStinson 108-2 · Superior, WIFeb 13, 1969 · N962D · Substantial damage NTSB OAK69D0181Accident · No injuriesClosedStinson 108-2 · Atwater, CADec 5, 1968 · N9425K · Substantial damage NTSB SEA69A0026Accident · 2 fatalClosedStinson 108 · Vancouver, WANov 10, 1968 · N422C · Destroyed NTSB MKC69D0245Accident · No injuriesClosedStinson 108-2 · Sharon Sprgs, KSOct 29, 1968 · N9807K · Substantial damage NTSB NYC69D0187Accident · No injuriesClosedStinson 108-2 · Hallstead, PASep 28, 1968 · N9372K · Substantial damage NTSB DEN69F0122Accident · Minor injuriesClosedStinson 108-2 · Aurora, COSep 19, 1968 · N8096K · Destroyed NTSB DEN69D0088Accident · Minor injuriesClosedStinson 108-2 · Aurora, COAug 9, 1968 · N8124K · Substantial damage NTSB LAX69D0006Accident · No injuriesClosedStinson 108-2 · Riverside, CAJun 4, 1968 · N9804K · Substantial damage NTSB CHI69D0015Accident · No injuriesClosedStinson 108-2 · Burkhardt, WIMay 31, 1968 · N9472K · Substantial damage NTSB MKC69D0050Accident · No injuriesClosedStinson 108-2 · Rich Hill, MOMay 28, 1968 · N337C · Substantial damage NTSB FTW68F0584Accident · No injuriesClosedStinson 108-2 · Alexandria, LAMay 5, 1968 · N361C · Substantial damage NTSB MKC68F0580Accident · Serious injuriesClosedStinson 108-2 · Menomonie, WIApr 27, 1968 · N973D · Destroyed NTSB OAK68D0263Accident · No injuriesClosedStinson 108-2 · Santa Cruz, CADec 10, 1967 · N9403K · Substantial damage NTSB SEA68A0040Accident · 2 fatalClosedStinson 108-2 · Tigard, ORNov 5, 1967 · N963D · Substantial damage NTSB ANC68D0087Accident · No injuriesClosedStinson 108-2 · Pilot Point, AKSep 21, 1967 · N9510K · Substantial damage NTSB CHI68F0336Accident · Serious injuriesClosedPiper PA-22 · Greenfield, INSep 10, 1967 · N3740P · 2 aircraft · Substantial damage NTSB ANC68D0028Accident · No injuriesClosedStinson 108 · Anchorage, AKJul 27, 1967 · N8531K · Substantial damage NTSB CHI68D0160Accident · No injuriesClosedStinson 108 · Hobart, INJun 30, 1967 · N9788K · Substantial damage NTSB FTW67F0625Accident · No injuriesClosedStinson 108-2 · Wright City, TXMay 26, 1967 · N9601K · Substantial damage NTSB NYC67F0666Accident · No injuriesClosedStinson 108-2 · Matamoras, PAMay 10, 1967 · N9403K · Substantial damage NTSB CHI67A0111Accident · 2 fatalClosedStinson 108-2 · Chandlerville, ILMar 30, 1967 · N9302K · Destroyed NTSB FTW67D0473Accident · No injuriesClosedStinson 108 · Abilene, TXMar 26, 1967 · N8012K · Substantial damage NTSB CHI67D0532Accident · No injuriesClosedStinson 108-2 · Clinton, INFeb 2, 1967 · N9276K · Substantial damage NTSB MKC67D0265Accident · No injuriesClosedStinson 108-2 · Ely, MNOct 12, 1966 · N9475K · Substantial damage NTSB SEA67D0185Accident · No injuriesClosedStinson 108-2 · Laurel, MTSep 11, 1966 · N967D · Substantial damage NTSB LAX67D0126Accident · No injuriesClosedStinson 108-2 · Baker, CASep 10, 1966 · N479C · Substantial damage NTSB CHI67F0111Accident · No injuriesClosedStinson 108 · Rockford, ILAug 6, 1966 · N9302K · Substantial damage NTSB ANC67F0001Accident · No injuriesClosedStinson 108-2 · Anchorage, AKJun 11, 1966 · N9638K · Substantial damage NTSB FTW66F0686Accident · No injuriesClosedStinson 108-2 · Shreveport, LAJun 3, 1966 · N8012K · Substantial damage NTSB ANC66A0037Accident · 1 fatalClosedStinson 108-2 · Anchorage, AKApr 18, 1966 · N9278K · Destroyed NTSB ANC66D0102Accident · No injuriesClosedStinson 108-2 · Nondalton, AKApr 13, 1966 · N9297K · Substantial damage NTSB OAK66D0213Accident · No injuriesClosedStinson 108-2 · Concord, CAApr 10, 1966 · N9305K · Substantial damage NTSB SEA66D0236Accident · No injuriesClosedStinson 6A · Burley, IDMar 26, 1966 · N9718K · Substantial damage NTSB MKC66D0337Accident · No injuriesClosedStinson 108-2 · Panoro, IAJan 1, 1966 · N9551K · Substantial damage NTSB CHI66A0060Accident · 3 fatalClosedPiper PA-23 · Knox, INDec 19, 1965 · N1100P · 2 aircraft · Destroyed NTSB SEA66D0131Accident · No injuriesClosedStinson 108-2 · Bonner Ferry, IDSep 10, 1965 · N265C · Substantial damage NTSB NYC66F0227Accident · No injuriesClosedStinson 108-2 · Franklin, PASep 6, 1965 · N964D · Substantial damage NTSB NYC66F0235Accident · Minor injuriesClosedStinson 108-2 · Oak Hill, WVSep 4, 1965 · N9429K · Substantial damage NTSB MKC66D0225Accident · No injuriesClosedStinson 108-2 · Huron, SDSep 1, 1965 · N9532K · Substantial damage NTSB CHI66F0152Accident · Minor injuriesClosedStinson 108-2 · Beaver Dam, WIJul 24, 1965 · N286C · Destroyed NTSB CHI66F0113Accident · Minor injuriesClosedStinson 108-2 · Kenosha, WIJun 24, 1965 · N9519K · Destroyed NTSB ANC66D0062Accident · No injuriesClosedStinson 108-2 · Bethel, AKJun 23, 1965 · N9688K · Substantial damage NTSB CHI66F0110Accident · No injuriesClosedStinson 108-2 · Freeland, MIJun 11, 1965 · N9344K · Substantial damage NTSB MIA65A0113Accident · 1 fatalClosedStinson 108 · Mt Ulla, NCMay 15, 1965 · N985D · Destroyed NTSB NYC65F0140Accident · Minor injuriesClosedStinson 108-2 · Ashland, VAApr 20, 1965 · N9717K · Destroyed NTSB NYC65F0116Accident · No injuriesClosedStinson 108-2 · Allentown, PAApr 11, 1965 · N386C · Substantial damage NTSB CHI65D0122Accident · No injuriesClosedStinson 108-1 · Chagrin Falls, OHApr 10, 1965 · N8514K · Substantial damage NTSB NYC65F0059Accident · Minor injuriesClosedStinson 108-2 · Rocky Hill, NJMar 14, 1965 · N9622K · Substantial damage NTSB UNK65X1436Accident · No injuriesClosedStinson 108-2 · Columbus, GAFeb 19, 1965 · N8019K · Substantial damage