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 SEA72DYI10Accident · No injuriesClosedStinson 108-1 · Klamath Flls, ORJan 2, 1972 · N8336K · Substantial damage NTSB MIA72FLD41Accident · No injuriesClosedStinson 108-1 · Oklawaha, FLDec 24, 1971 · N8470K · Substantial damage NTSB ANC72DAA19Accident · No injuriesClosedStinson 108-1 · Black Rapids, AKOct 5, 1971 · N8535K · Substantial damage NTSB ANC72DAG52Accident · Minor injuriesClosedStinson 108 · Willow, AKAug 26, 1971 · N40121 · Substantial damage NTSB SEA72DYC07Accident · No injuriesClosedStinson 108-1 · Salem, ORJul 18, 1971 · N9023K · Substantial damage NTSB OAK71DVA94Accident · No injuriesClosedStinson 108-1 · Lone Pine, CAJun 20, 1971 · N9193K · Substantial damage NTSB CHI71DDJ47Accident · No injuriesClosedStinson 108-1 · Milwaukee, WIApr 4, 1971 · N9155K · Substantial damage NTSB OAK71FXQ32Accident · Serious injuriesClosedStinson 108 · Gerlach, NVMar 24, 1971 · N97000 · Substantial damage NTSB CHI71FBD60Accident · No injuriesClosedStinson 108-1 · Joliet, ILMar 20, 1971 · N97933 · Substantial damage NTSB SEA71FVQ18Accident · Serious injuriesClosedStinson 108-1 · Lorane, ORJan 28, 1971 · N8373K · Destroyed NTSB FTW71AF032Accident · 1 fatalClosedStinson 108-1 · Beaumont, TXDec 15, 1970 · N9094K · Destroyed NTSB MKC71FCJ21Accident · No injuriesClosedStinson 108-1 · Lincoln, NESep 7, 1970 · N9059K · Substantial damage NTSB CHI71DBD18Accident · No injuriesClosedStinson 108-1 · Ridott, ILAug 30, 1970 · N8986K · Destroyed NTSB SEA71FVQ04Accident · No injuriesClosedStinson 108-1 · Springfield, ORAug 1, 1970 · N97934 · Substantial damage NTSB CHI71FBQ04Accident · No injuriesClosedStinson 108-1 · Ludlow, ILJul 21, 1970 · N9215K · Substantial damage NTSB CHI70FGG25Accident · Minor injuriesClosedStinson 108-1 · New Lexingtn, OHJun 6, 1970 · N8888K · Substantial damage NTSB OAK70DVD25Accident · No injuriesClosedStinson 108-1 · Point Arena, CAMay 30, 1970 · N9145K · Substantial damage NTSB CHI70FDW17Accident · No injuriesClosedStinson 108-1 · Hudson, MIMay 19, 1970 · N8414K · Substantial damage NTSB MIA70FKW04Accident · No injuriesClosedStinson 108-1 · Knoxville, TNApr 4, 1970 · N8721K · Substantial damage NTSB MKC70DDD12Accident · No injuriesClosedStinson 108-1 · Belfield, NDFeb 25, 1970 · N8364K · Substantial damage NTSB CHI70FBM05Accident · No injuriesClosedStinson 108-1 · Dowagiac, MIFeb 1, 1970 · N9176K · Substantial damage NTSB NYC70F0195Accident · No injuriesClosedStinson 108-1 · Southwick, MAOct 19, 1969 · N97954 · Substantial damage NTSB MIA70D0312Accident · No injuriesClosedStinson 108-1 · Alma, GAOct 5, 1969 · N8518K · Substantial damage NTSB NYC70F0151Accident · No injuriesClosedStinson 108-1 · Perkasie, PASep 29, 1969 · N8915K · Substantial damage NTSB ANC70D0073Accident · No injuriesClosedStinson 108-1 · Delta Junctn, AKSep 25, 1969 · N9010K · Substantial damage NTSB IAD70F0083Accident · Serious injuriesClosedStinson 108-1 · Prince George, VASep 13, 1969 · N8503K · Destroyed NTSB FTW70F0195Accident · Minor injuriesClosedStinson 108-1 · De Quincy, LASep 7, 1969 · N8912K · Destroyed NTSB NYC70A0030Accident · 2 fatalClosedStinson 108-1 · Colton, NYSep 1, 1969 · N97789 · Destroyed NTSB NYC70D0129Accident · No injuriesClosedStinson 108 · Poestenkill, NYAug 7, 1969 · N97992 · Substantial damage NTSB DEN70F0053Accident · Minor injuriesClosedStinson 108-1 · Albuquerque, NMAug 6, 1969 · N9164K · Destroyed NTSB CHI70D0146Accident · No injuriesClosedStinson 108 · Elyria, OHJul 1, 1969 · N97960 · Substantial damage NTSB CHI70F0067Accident · Minor injuriesClosedStinson 108 · Lombard, ILJun 8, 1969 · N8941K · Substantial damage NTSB SEA69A0059Accident · 3 fatalClosedAeronca 7AC · Snohomish, WAJun 2, 1969 · N85071 · 2 aircraft · Destroyed NTSB NYC70F0013Accident · Serious injuriesClosedStinson 108-1 · Babylon, NYMay 18, 1969 · N8458K · Substantial damage NTSB FTW69F0448Accident · Minor injuriesClosedStinson 108-1 · Pearland, TXApr 6, 1969 · N8761K · Destroyed NTSB NYC69F0349Accident · Minor injuriesClosedStinson 108 · Aliquippa, PAFeb 16, 1969 · N8539K · Substantial damage NTSB FTW69F0388Accident · No injuriesClosedStinson 108-1 · Kaplan, LAFeb 9, 1969 · N8766K · Substantial damage NTSB SEA69D0180Accident · No injuriesClosedStinson 108 · Vancouver, WADec 8, 1968 · N97887 · Substantial damage NTSB MIA69D0284Accident · Minor injuriesClosedStinson 108 · Fort Myers, FLDec 2, 1968 · N8923K · Substantial damage NTSB NYC69D0254Accident · No injuriesClosedStinson 108-1 · Shirley, MANov 16, 1968 · N9154K · Substantial damage NTSB ANC69D0064Accident · No injuriesClosedStinson 108-1 · Fairbanks, AKOct 12, 1968 · N8724K · Substantial damage NTSB CHI69D0312Accident · No injuriesClosedStinson 108-1 · Northbrook, ILOct 2, 1968 · N8849K · Substantial damage NTSB CHI69D0209Accident · No injuriesClosedStinson 108-1 · Freeland, MIAug 13, 1968 · N8546K · Substantial damage NTSB NYC69D0131Accident · No injuriesClosedStinson 108-1 · Central City, PAAug 11, 1968 · N8212K · Substantial damage NTSB SEA69D0062Accident · No injuriesClosedStinson 108-1 · Warden, WAAug 6, 1968 · N9105K · Substantial damage NTSB CHI69D0239Accident · No injuriesClosedStinson 108-1 · Fremont, OHAug 3, 1968 · N97797 · Substantial damage NTSB OAK69D0071Accident · Minor injuriesClosedStinson 108-1 · Livermore, CAJul 29, 1968 · N97882 · Substantial damage NTSB SEA69F0105Accident · Minor injuriesClosedStinson 108-1 · Ten Mile, ORJul 7, 1968 · N8510K · Destroyed NTSB NYC69F0004Accident · Minor injuriesClosedStinson 108-1 · Mendon, NYJun 16, 1968 · N8603K · Substantial damage NTSB NYC68D0445Accident · No injuriesClosedStinson 108 · Oxford, MAApr 16, 1968 · N355C · Substantial damage