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 CHI68A0074Accident · 2 fatalClosedPiper PA-28 · Ranklin, INFeb 18, 1968 · N9516W · 2 aircraft · Destroyed NTSB FTW68A0073Accident · 1 fatalClosedStinson 108-1 · Gladewater, TXJan 30, 1968 · N97947 · Destroyed NTSB LAX68D0330Accident · Minor injuriesClosedStinson 108-1 · Redlands, CAJan 21, 1968 · N8233K · Substantial damage NTSB FTW68D0394Accident · Minor injuriesClosedStinson 108-1 · Gueydan, LADec 25, 1967 · N8238K · Substantial damage NTSB NYC68D0375Accident · No injuriesClosedStinson 108-3 · Berlin, NJDec 23, 1967 · N97062 · Substantial damage NTSB OAK68F0257Accident · Serious injuriesClosedStinson 108-1 · San Jose, CANov 26, 1967 · N97074 · Substantial damage NTSB CHI68F0282Accident · Minor injuriesClosedStinson 108-1 · Hidalgo, ILAug 25, 1967 · N8290K · Substantial damage NTSB CHI68D0401Accident · No injuriesClosedStinson 108 · Wild Rose, WIAug 5, 1967 · N9142K · Substantial damage NTSB FTW68O0006Accident · No injuriesClosedStinson 108-1 · Reynosa, MexicoJul 31, 1967 · N8706K · Substantial damage NTSB NYC68F0030Accident · No injuriesClosedStinson 108-1 · Mt.Pocono, PAJul 5, 1967 · N8420K · Substantial damage NTSB CHI68D0014Accident · No injuriesClosedStinson 108-1 · Scottsburg, INMay 26, 1967 · N8361K · Substantial damage NTSB CHI68F0025Accident · No injuriesClosedStinson 108-1 · Lake City, MIMay 6, 1967 · N8874K · Substantial damage NTSB MKC67F0568Accident · Minor injuriesClosedStinson 108-1 · Papillion, NEApr 27, 1967 · N8855K · Substantial damage NTSB NYC68D0029Accident · No injuriesClosedStinson 108-1 · Brookhaven, NYApr 9, 1967 · N40182 · Substantial damage NTSB NYC67D0495Accident · No injuriesClosedStinson 108-1 · Erie, PAFeb 14, 1967 · N8992K · Substantial damage NTSB ANC67D0064Accident · No injuriesClosedStinson 108-1 · King Salmon, AKNov 19, 1966 · N97650 · Substantial damage NTSB CHI67F0304Accident · No injuriesClosedStinson 108-1 · Columbus, OHOct 30, 1966 · N8389K · Substantial damage NTSB NYC67D0365Accident · No injuriesClosedStinson 108-1 · Leechburg, PAOct 21, 1966 · N8701K · Substantial damage NTSB LAX67D0179Accident · No injuriesClosedStinson 108-1 · Bakersfield, CAOct 15, 1966 · N8594K · Substantial damage NTSB NYC67D0279Accident · No injuriesClosedStinson 108-2 · So.Plainfield, NJSep 19, 1966 · N9774K · Substantial damage NTSB NYC67F0364Accident · No injuriesClosedPiper PA-23 · Medford, NJSep 10, 1966 · N4923P · 2 aircraft · Substantial damage NTSB LAX67D0085Accident · No injuriesClosedStinson 108-1 · Lancaster, CAAug 4, 1966 · N8680K · Substantial damage NTSB SEA67D0154Accident · No injuriesClosedStinson 108 · Orcas Island, WAJul 31, 1966 · N8200K · Substantial damage NTSB CHI67F0057Accident · No injuriesClosedStinson 108 · Plymouth, MIJul 4, 1966 · N8554K · Substantial damage NTSB NYC67F0040Accident · No injuriesClosedStinson 108-1 · Lindenhurst, NYJul 1, 1966 · N8332K · Substantial damage NTSB OAK66A0060Accident · 2 fatalClosedStinson 108-1 · Samoa, CAJun 27, 1966 · N9225K · Destroyed NTSB NYC67D0042Accident · No injuriesClosedStinson 108-1 · Monroeville, PAJun 12, 1966 · N8325K · Substantial damage NTSB SEA67F0064Accident · No injuriesClosedStinson 108-1 · Eugene, ORJun 11, 1966 · N8510K · Substantial damage NTSB NYC67D0001Accident · No injuriesClosedStinson 108-1 · Mercer, PAJun 5, 1966 · N8995K · Substantial damage NTSB CHI67F0007Accident · Minor injuriesClosedStinson 108-1 · Kenoska, WIJun 1, 1966 · N9055K · Substantial damage NTSB DEN66F0321Accident · No injuriesClosedStinson 108 · Mesa, AZMay 7, 1966 · N97919 · Substantial damage NTSB NYC66F0604Accident · Minor injuriesClosedStinson 108-1 · Little Falls, NYApr 23, 1966 · N97003 · Substantial damage NTSB SEA66F0260Accident · No injuriesClosedStinson 108 · Pacific City, ORMar 31, 1966 · N97805 · Substantial damage NTSB MKC66F0489Accident · Minor injuriesClosedStinson 108-1 · Waynesville, MOMar 31, 1966 · N8153K · Destroyed NTSB SEA66A0048Accident · 1 fatalClosedStinson 108 · Port Angeles, WAMar 21, 1966 · N8930K · No damage NTSB NYC66D0551Accident · No injuriesClosedStinson 108-1 · Mohrsville, PAMar 20, 1966 · N97870 · Substantial damage NTSB DEN66D0259AccidentClosedStinson 108 · Buckeye, AZMar 17, 1966 · N9147K · Substantial damage NTSB MIA66D0472Accident · No injuriesClosedStinson 108 · Merritt Is, FLMar 8, 1966 · N97806 · Substantial damage NTSB CHI66F0594Accident · No injuriesClosedStinson 108-1 · Sparta, MIFeb 26, 1966 · N8437K · Substantial damage NTSB NYC66F0558Accident · Minor injuriesClosedStinson 108-1 · Shirley, MAFeb 20, 1966 · N8314K · Substantial damage NTSB MKC66F0407Accident · No injuriesClosedStinson 108-1 · Camdenton, MOFeb 12, 1966 · N8783K · Substantial damage NTSB SEA66F0194Accident · Minor injuriesClosedStinson 108-1 · Springfield, ORDec 28, 1965 · N8641K · Substantial damage NTSB NYC66D0355Accident · No injuriesClosedStinson 108-1 · Mechanicsburg, PANov 20, 1965 · N8535K · Substantial damage NTSB DEN66F0172Accident · No injuriesClosedStinson 108 · Sandy, UTNov 20, 1965 · N9168K · Substantial damage NTSB CHI66F0329Accident · No injuriesClosedStinson 108-1 · Grand Rapids, MISep 28, 1965 · N8220K · Substantial damage NTSB NYC66F0259Accident · No injuriesClosedStinson 108 · Ocean City, MDSep 26, 1965 · N9209K · Substantial damage NTSB NYC66F0263Accident · No injuriesClosedStinson 108-2 · Alexandria, VASep 16, 1965 · N9774K · Substantial damage NTSB ANC66D0036Accident · No injuriesClosedStinson 108-1 · Klukwan, AKSep 7, 1965 · N9121K · Substantial damage NTSB NYC66F0211Accident · Serious injuriesClosedStinson 108-1 · Castine, MESep 6, 1965 · N97988 · Destroyed NTSB FTW66D0271Accident · No injuriesClosedStinson 108-1 · Houston, TXAug 25, 1965 · N312C · Destroyed