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 ANC74FAA04Accident · No injuriesClosedStinson 108-2 · North Pole, AKAug 20, 1973 · N9743K · Substantial damage NTSB DEN73AD052Accident · 2 fatalClosedStinson 108-2 · Montrose, COJun 4, 1973 · N9548K · Destroyed NTSB OAK73DVG61Accident · No injuriesClosedStinson 108-2 · Weed, CAMay 7, 1973 · N9529K · Substantial damage NTSB SEA73FYE29Accident · No injuriesClosedStinson 108 · Kent, WAMar 17, 1973 · N9150K · Substantial damage NTSB SEA73DYG16Accident · No injuriesClosedStinson 108-2 · Republic, WAOct 23, 1972 · N201C · Substantial damage NTSB SEA73DYG12Accident · No injuriesClosedStinson 108 · Connell, WAAug 12, 1972 · N217C · Substantial damage NTSB DEN73DTE15Accident · No injuriesClosedStinson 108-2 · Pueblo, COAug 6, 1972 · N9416K · Substantial damage NTSB SEA73FYG08Accident · Serious injuriesClosedStinson 108-2 · Asotin, WAAug 3, 1972 · N9572K · Destroyed NTSB ANC73DAA04Accident · No injuriesClosedStinson 108-2 · Mt Mckinley, AKJul 24, 1972 · N904D · Substantial damage NTSB OAK73FVD03Accident · Minor injuriesClosedStinson 108-2 · Concord, CAJul 14, 1972 · N9870K · Substantial damage NTSB FTW72FPM30Accident · Serious injuriesClosedStinson 108-2 · Catoosa, OKMay 12, 1972 · N395C · Substantial damage NTSB NYC72DGM45Accident · No injuriesClosedStinson 108-2 · Scottsdale, PAMay 11, 1972 · N9464K · Substantial damage NTSB MKC72FER47Accident · No injuriesClosedStinson 108-2 · Rosemont, MNMar 18, 1972 · N9256K · Substantial damage NTSB DEN72DTE58Accident · No injuriesClosedStinson 108-3 · Lamar, COFeb 13, 1972 · N160C · Substantial damage NTSB MIA72DKT55Accident · No injuriesClosedStinson 108-2 · Marco Island, FLFeb 12, 1972 · N184C · Substantial damage NTSB NYC72AN070Accident · 3 fatalClosedCessna 170B · Fallston, PANov 28, 1971 · N2535D · 2 aircraft · Destroyed NTSB ANC72DAG79Accident · No injuriesClosedStinson 108-2 · Kodiak, AKNov 24, 1971 · N9510K · Substantial damage NTSB SEA72AS009Accident · 2 fatalClosedStinson 108-2 · Port Angeles, WASep 3, 1971 · N890D · Destroyed NTSB LAX72DUJ35Accident · Minor injuriesClosedStinson 108 · Page, AZSep 2, 1971 · N998D · Substantial damage NTSB NYC72AN024Accident · No injuriesClosedCessna 150K · Frederick, MDAug 13, 1971 · N6273G · 2 aircraft · Minor damage NTSB ANC72DAG14Accident · No injuriesClosedStinson 108-2 · Seward, AKJul 31, 1971 · N9689K · Substantial damage NTSB NYC72FFA04Accident · Minor injuriesClosedStinson 108-2 · Malone, NYJul 25, 1971 · N9453K · Destroyed NTSB ANC72DAG12Accident · No injuriesClosedStinson 108-2 · Kodiak, AKJul 25, 1971 · N9574K · Destroyed NTSB ANC71DAA28Accident · No injuriesClosedStinson 108-2 · Fairbanks, AKMay 26, 1971 · N9743K · Substantial damage NTSB NYC71FFJ34Accident · No injuriesClosedStinson 108-2 · Endicott, NYMay 17, 1971 · N925D · Substantial damage NTSB ANC71FAG87Accident · Serious injuriesClosedStinson 108-2 · Seldovia, AKMay 9, 1971 · N8064K · Destroyed NTSB LAX71DUG76Accident · No injuriesClosedStinson 108 · Blythe, CAApr 24, 1971 · N926D · Substantial damage NTSB OAK71FXQ34Accident · No injuriesClosedStinson 108-2 · Stead, CAApr 12, 1971 · N228C · Substantial damage NTSB SEA71FDA15Accident · No injuriesClosedStinson 108-2 · Alzada, MTMar 19, 1971 · N171C · Substantial damage NTSB CHI71FBJ32Accident · Minor injuriesClosedStinson 108-2 · Greenville, MIOct 7, 1970 · N9418K · Substantial damage NTSB DEN71FQA16Accident · No injuriesClosedStinson 108-2 · Espanola, NMSep 30, 1970 · N9558K · Substantial damage NTSB ANC71DAG24Accident · No injuriesClosedStinson 108-2 · Kenai, AKSep 14, 1970 · N97978 · Substantial damage NTSB MKC71DCG19Accident · No injuriesClosedStinson 108 · Ethel, MOAug 15, 1970 · N8040K · Substantial damage NTSB ANC71DAA09Accident · Minor injuriesClosedStinson 108-2 · Nome, AKAug 11, 1970 · N365C · Substantial damage NTSB DEN70FQA23Accident · No injuriesClosedStinson 108-2 · Albuquerque, NMMay 29, 1970 · N2638 · Substantial damage NTSB DEN70FXA11Accident · No injuriesClosedStinson 108-2 · Casper, WYMay 17, 1970 · N9505K · Substantial damage NTSB SEA70DXM05Accident · Serious injuriesClosedStinson 108 · Rexburg, IDFeb 22, 1970 · N9527K · Substantial damage NTSB LAX70FUA08Accident · Minor injuriesClosedStinson 108 · Fullerton, CAJan 30, 1970 · N946D · Substantial damage NTSB FTW70D0282Accident · No injuriesClosedStinson 108-2 · Fayetteville, AROct 27, 1969 · N444C · Substantial damage NTSB LAX70F0165Accident · No injuriesClosedStinson 108-2 · Saugus, CASep 27, 1969 · N9614K · Destroyed NTSB OAK70F0103Accident · Serious injuriesClosedStinson 108-2 · Stockton, CASep 1, 1969 · N9305K · Substantial damage NTSB SEA70F0057Accident · Minor injuriesClosedStinson 108-2 · Donnelly, IDAug 18, 1969 · N9664K · Substantial damage NTSB DIA70F0047Accident · Minor injuriesClosedStinson 108 · Alexandria, VAJul 26, 1969 · N9594K · Destroyed NTSB MKC70D0043Accident · Minor injuriesClosedStinson 108-2 · Papillion, NEJul 3, 1969 · N9447K · Substantial damage NTSB NYC70D0005Accident · Minor injuriesClosedStinson 108-2 · Red Bank, NJMay 30, 1969 · N9344K · Substantial damage NTSB CHI70F0018Accident · No injuriesClosedStinson 108-2 · Peoria, ILMay 21, 1969 · N130C · Substantial damage NTSB SEA69D0261Accident · No injuriesClosedStinson 108-2 · Bellevue, WAMay 15, 1969 · N9714K · Substantial damage NTSB CHI69D0628Accident · No injuriesClosedStinson 108-2 · Lombard, ILApr 30, 1969 · N9837K · Substantial damage NTSB NYC69D0382Accident · No injuriesClosedStinson 108 · Ogdensburg, NYMar 24, 1969 · N9453K · Substantial damage NTSB NYC69F0347Accident · Minor injuriesClosedStinson 108-2 · Hampden, MEMar 15, 1969 · N391C · Substantial damage