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 ANC74DAG88Accident · No injuriesClosedStinson 108 · Soldotna, AKJan 31, 1974 · N97326 · Substantial damage NTSB MIA74FLA22Accident · Minor injuriesClosedStinson 108 · Baker, FLNov 18, 1973 · N97378 · Substantial damage NTSB CHI74FEE02Accident · Minor injuriesClosedStinson 108 · Wheeling, ILJul 5, 1973 · N9177K · Substantial damage NTSB FTW73FPG48Accident · No injuriesClosedStinson 108 · Pine Bluff, ARApr 23, 1973 · N40134 · Substantial damage NTSB MIA73DKJ49Accident · No injuriesClosedStinson 108 · Wetumpka, ALMar 28, 1973 · N97546 · Substantial damage NTSB MIA73FLD53Accident · No injuriesClosedStinson 108-1 · Ft.Pierce, FLJan 23, 1973 · N97632 · Substantial damage NTSB MIA73FLD43Accident · Minor injuriesClosedStinson 108 · Lake Alfred, FLDec 13, 1972 · N97400 · Substantial damage NTSB LAX73AL025Accident · 1 fatalClosedStinson 108 · Ukiah, CADec 5, 1972 · N97366 · Destroyed NTSB NYC73DGM03Accident · No injuriesClosedStinson 108 · Central City, PAJul 29, 1972 · N40105 · Substantial damage NTSB FTW72FPM12Accident · Minor injuriesClosedStinson 108-1 · Calera, OKNov 7, 1971 · N97441 · Substantial damage NTSB DEN72FTE40Accident · No injuriesClosedStinson 108-2 · Watkins, CONov 4, 1971 · N97086 · Substantial damage NTSB ANC72DAG67Accident · No injuriesClosedStinson 108 · Anchorage, AKOct 20, 1971 · N44BS · Substantial damage NTSB OAK72DVA18Accident · No injuriesClosedStinson 108-1 · Porterville, CASep 5, 1971 · N9041K · Substantial damage NTSB NYC71FHM32Accident · No injuriesClosedStinson 108 · Washingtonvlle, NYJun 19, 1971 · N97320 · Substantial damage NTSB NYC71FFJ33Accident · No injuriesClosedStinson 108-1 · Skaneateles, NYMay 19, 1971 · N9198K · Substantial damage NTSB MKC71AK035Accident · 3 fatalClosedStinson 108-3 · Ste Genevieve, MODec 18, 1970 · N6823M · Destroyed NTSB CHI71FGG16Accident · Minor injuriesClosedStinson 108 · Nelsonville, OHOct 18, 1970 · N97212 · Substantial damage NTSB FTW71DQG37Accident · No injuriesClosedStinson 108 · Shallowater, TXSep 7, 1970 · N97152 · Substantial damage NTSB FTW71FPJ05Accident · Serious injuriesClosedStinson 108-1 · Edmond, OKJun 25, 1970 · N97835 · Substantial damage NTSB LAX70FUQ29Accident · Minor injuriesClosedStinson 108 · Santa Paula, CAMay 21, 1970 · N97292 · Substantial damage NTSB OAK70A0006Accident · 4 fatalClosedStinson 108 · Searchlight, NVJul 22, 1969 · N97585 · Destroyed NTSB LAX70A0003Accident · 2 fatalClosedStinson 108 · Compton, CAJul 12, 1969 · N39480 · Destroyed NTSB NYC70D0017Accident · No injuriesClosedStinson 108 · Wolfeboro, NHJun 18, 1969 · N97699 · Substantial damage NTSB CHI69F0671Accident · No injuriesClosedStinson 108 · Vicksburg, MIMay 26, 1969 · N97510 · Substantial damage NTSB LAX69F0347Accident · Serious injuriesClosedStinson 108 · Summit, CAMay 3, 1969 · N97471 · Destroyed NTSB MKC69F0061Accident · No injuriesClosedStinson 108 · Osseo, MNJul 19, 1968 · N40110 · Substantial damage NTSB MIA68D0532Accident · Minor injuriesClosedStinson 108-1 · Chipley, FLApr 28, 1968 · N97195 · Substantial damage NTSB MKC68F0494Accident · Serious injuriesClosedStinson 108 · Potosi, MOMar 2, 1968 · N97564 · Destroyed NTSB DIA68A0019Accident · 3 fatalClosedStinson 108 · Cairo, WVNov 10, 1967 · N97702 · Destroyed NTSB CHI68F0514Accident · Serious injuriesClosedStinson 108 · Wellington, OHNov 10, 1967 · N97319 · Substantial damage NTSB MIA68A0044Accident · 1 fatalClosedLuscombe 8C · Temple Terrac, FLNov 5, 1967 · N28708 · 2 aircraft · Destroyed NTSB SEA68D0198Accident · No injuriesClosedStinson 108 · Enterprise, ORNov 4, 1967 · N97408 · Substantial damage NTSB CHI68F0404Accident · No injuriesClosedStinson 108-1 · Brookville, OHOct 28, 1967 · N97364 · Substantial damage NTSB CHI68F0396Accident · Serious injuriesClosedStinson 108 · Moweaqua, ILOct 22, 1967 · N40114 · Substantial damage NTSB NYC68F0219Accident · Minor injuriesClosedStinson 108-1 · New Hudson, NYOct 1, 1967 · N97518 · Substantial damage NTSB CHI68F0029Accident · Minor injuriesClosedStinson 108-2 · Washington Is, WIJul 4, 1967 · N8102K · Substantial damage NTSB NYC67D0682Accident · No injuriesClosedStinson 108 · Montauk, NYJun 7, 1967 · N97527 · Substantial damage NTSB OAK68D0076Accident · No injuriesClosedStinson 108 · Jackson, CAMay 20, 1967 · N97602 · Substantial damage NTSB MKC68D0043Accident · No injuriesClosedStinson 108 · Lewellen, NEMay 8, 1967 · N97152 · Substantial damage NTSB NYC67F0595Accident · No injuriesClosedStinson 108-1 · University Prk, PAApr 18, 1967 · N8866K · Substantial damage NTSB MIA67D0482Accident · No injuriesClosedStinson 108 · Lake Wales, FLMar 17, 1967 · N75295 · Substantial damage NTSB OAK67D0184Accident · No injuriesClosedStinson 108 · Columbia, CADec 23, 1966 · N97358 · Substantial damage NTSB LAX67D0187Accident · No injuriesClosedStinson 108 · Mormon Lake, AZNov 13, 1966 · N97417 · Substantial damage NTSB NYC67D0339Accident · No injuriesClosedStinson 108-1 · Linden, NJOct 13, 1966 · N40152 · Substantial damage NTSB CHI70A0049Accident · 4 fatalClosedStinson 108-1 · Hudson, MIOct 9, 1966 · N8984K · Destroyed NTSB CHI67F0254Accident · No injuriesClosedStinson 108-1 · Solon Springs, WIOct 2, 1966 · N40110 · Substantial damage NTSB NYC67D0265Accident · No injuriesClosedStinson 108 · Red Hook, NYSep 17, 1966 · N97320 · Substantial damage NTSB NYC67D0254Accident · No injuriesClosedStinson 108 · Richland, NYSep 15, 1966 · N97488 · Substantial damage NTSB FTW67F0196Accident · Minor injuriesClosedStinson 108 · St.Francisvlle, LASep 4, 1966 · N97163 · Substantial damage NTSB CHI67D0309Accident · No injuriesClosedStinson 108 · Stockton, ILAug 22, 1966 · N40139 · Substantial damage