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 ANC72DAG19Accident · No injuriesClosedStinson 108-3 · Anchorage, AKAug 16, 1971 · N6175M · Substantial damage NTSB ANC72FAG41Accident · No injuriesClosedStinson 108-3 · Bethel, AKAug 12, 1971 · N6031M · Substantial damage NTSB SEA72FYA01Accident · No injuriesClosedStinson 108-3 · Boise, IDJul 17, 1971 · N6392M · Substantial damage NTSB IAD72FIG04Accident · No injuriesClosedStinson 108-3 · Wiley Ford, WVJul 14, 1971 · N936C · Substantial damage NTSB CHI71FEM82Accident · No injuriesClosedStinson 108-3 · Wayland, MIMay 23, 1971 · N717C · Substantial damage NTSB NYC71FGM47Accident · No injuriesClosedStinson 108-3 · Delmont, PAMay 20, 1971 · N6214M · Substantial damage NTSB CHI71DEI55Accident · No injuriesClosedStinson 108 · Warren, OHMay 7, 1971 · N6095M · Substantial damage NTSB MKC71FCG63Accident · No injuriesClosedStinson 108-3 · Bahner, MOApr 28, 1971 · N6431M · Substantial damage NTSB MKC71FCG61Accident · No injuriesClosedStinson 108-3 · Gravois Mills, MOApr 28, 1971 · N6614M · Destroyed NTSB FTW71DPJ39Accident · No injuriesClosedStinson 108-3 · Shattuck, OKApr 9, 1971 · N6946M · Substantial damage NTSB NYC71FHG11Accident · Serious injuriesClosedStinson 108-3 · Mercersburg, PAMar 28, 1971 · N6529M · Substantial damage NTSB LAX71FUM30Accident · 2 fatalClosedStinson 108 · Ocotillo, CAMar 2, 1971 · N729C · Destroyed NTSB SEA71AS036Accident · 1 fatalClosedStinson 108-3 · Azalea, ORJan 23, 1971 · N6065M · Destroyed NTSB FTW71FPA20Accident · No injuriesClosedStinson 108-3 · Midlothian, TXDec 21, 1970 · N910C · Substantial damage NTSB LAX71FUA33Accident · Minor injuriesClosedStinson 108-3 · Torrance, CADec 13, 1970 · N6927M · Substantial damage NTSB DEN71DXD34Accident · No injuriesClosedStinson 108-3 · Campo, COOct 31, 1970 · N6278M · Substantial damage NTSB CHI72DDJ17Accident · Minor injuriesClosedStinson 108-3 · Bruce, WISep 20, 1970 · N960C · Substantial damage NTSB MKC71DDD06Accident · No injuriesClosedStinson 108-3 · Detroit Lks, MNAug 15, 1970 · N737C · Substantial damage NTSB MKC71FCA16Accident · Minor injuriesClosedStinson 108-3 · Mountain View, MOJul 29, 1970 · N6142M · Substantial damage NTSB CHI71FDW07Accident · No injuriesClosedStinson 108-3 · Drayton Plns, MIJul 13, 1970 · N6208M · Substantial damage NTSB IAD71FIG04Accident · Serious injuriesClosedStinson 108-3 · Springfield, WVJul 12, 1970 · N4207C · Destroyed NTSB DEN70FQA28Accident · No injuriesClosedStinson 108-3 · Pie Town, NMJul 3, 1970 · N6724M · Substantial damage NTSB CHI70FDW14Accident · No injuriesClosedStinson 108-3 · Flushing, MIMay 20, 1970 · N712C · Substantial damage NTSB LAX70DVA13Accident · No injuriesClosedStinson 108-3 · Bakersfield, CAMay 3, 1970 · N6308M · Substantial damage NTSB MKC70D0226Accident · No injuriesClosedStinson 108-3 · St.Charles, MOSep 21, 1969 · N6545M · Substantial damage NTSB ANC70F0067Accident · Serious injuriesClosedStinson 108-3 · Cantwell, AKSep 20, 1969 · N622C · Destroyed NTSB MKC70D0144Accident · No injuriesClosedStinson 108-3 · Mcgregor, IAAug 12, 1969 · N6427M · Substantial damage NTSB DEN70F0066Accident · No injuriesClosedStinson 108-3 · Silver City, NMAug 9, 1969 · N6539M · Substantial damage NTSB MIA70D0047Accident · No injuriesClosedStinson 108-3 · Venice, FLJun 21, 1969 · N6713M · Substantial damage NTSB NYC69F0447Accident · Serious injuriesClosedStinson 108-3 · Hornell, NYMay 17, 1969 · N6340M · Substantial damage NTSB LAX69A0060Accident · 1 fatalClosedStinson 108-3 · Sta Monica, CAApr 20, 1969 · N6485M · Destroyed NTSB CHI69D0499Accident · Minor injuriesClosedStinson 108 · Laurel, INFeb 26, 1969 · N4147C · Substantial damage NTSB NYC69D0326Accident · No injuriesClosedStinson 108-3 · Basking Ridge, NJFeb 25, 1969 · N713C · Substantial damage NTSB LAX69D0238Accident · Minor injuriesClosedStinson 108-3 · Mortmar, CAJan 4, 1969 · N6902M · Substantial damage NTSB MIA69A0028Accident · 2 fatalClosedStinson 108-3 · Ft.Lauderdale, FLNov 28, 1968 · N4174C · Destroyed NTSB MKC69D0256Accident · No injuriesClosedStinson 108-3 · Hill City, KSOct 27, 1968 · N856C · Substantial damage NTSB SEA69D0137Accident · No injuriesClosedStinson 108-3 · Seattle, WAOct 26, 1968 · N6283M · Substantial damage NTSB MKC69D0255Accident · No injuriesClosedStinson 108-3 · Beaumont, KSOct 26, 1968 · N6676M · Substantial damage NTSB SEA69D0113Accident · No injuriesClosedStinson 108-3 · Gooding, IDOct 13, 1968 · N4017C · Substantial damage NTSB NYC69D0183Accident · No injuriesClosedStinson 108-3 · Dublin, PASep 7, 1968 · N6866M · Substantial damage NTSB MKC69F0093Accident · Minor injuriesClosedStinson 108-3 · Grassy Bute, NDJul 24, 1968 · N891C · Substantial damage NTSB CHI69F0024Accident · No injuriesClosedStinson 108-3 · Petersburg, MIJun 24, 1968 · N6428M · Substantial damage NTSB MIA69F0073Accident · Serious injuriesClosedStinson 108-3 · Kennesaw, GAJun 16, 1968 · N635C · Substantial damage NTSB CHI69F0026Accident · Minor injuriesClosedStinson 108-3 · Flushing, MIJun 15, 1968 · N980C · Substantial damage NTSB CHI68A0108Accident · 2 fatalClosedStinson 108-3 · Put-In-Bay, OHJun 10, 1968 · N6780M · Destroyed NTSB SEA68D0326Accident · No injuriesClosedStinson 108-3 · Omak, WAJun 9, 1968 · N6822M · Substantial damage NTSB MKC68A0069Accident · 2 fatalClosedStinson 108-3 · Dubuque, IAMay 26, 1968 · N6932M · Destroyed NTSB CHI68F0765Accident · No injuriesClosedStinson 108-3 · Belleville, MIMay 17, 1968 · N4120C · Substantial damage NTSB NYC68F0414Accident · Minor injuriesClosedStinson 108-3 · Warren, PAMar 31, 1968 · N6686M · Destroyed NTSB FTW68D0497Accident · No injuriesClosedStinson 108-3 · Beaver, OKMar 18, 1968 · N6175M · Substantial damage