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 NYC77FFJ22Accident · No injuriesClosedStinson 108-1 · Newark, NYMay 18, 1977 · N8193K · Substantial damage NTSB CHI77DEE14Accident · No injuriesClosedStinson 108-1 · Rockford, ILApr 3, 1977 · N8863K · Substantial damage NTSB ANC77DAG43Accident · No injuriesClosedStinson 108-1 · Twin Lakes, AKMar 18, 1977 · N8578K · Substantial damage NTSB MIA77FLD34Accident · Serious injuriesClosedStinson 108-1 · Winter Haven, FLMar 13, 1977 · N9078K · Destroyed NTSB MIA77DKJ19Accident · No injuriesClosedStinson 108-1 · Bay Minette, ALFeb 20, 1977 · N9183K · Substantial damage NTSB ANC77DAG27Accident · Minor injuriesClosedStinson 108-1 · Kenai, AKJan 29, 1977 · N97884 · Substantial damage NTSB NYC77DNC19Accident · Minor injuriesClosedStinson 108-1 · Salem, NHJan 23, 1977 · N8874K · Substantial damage NTSB CHI77FEP08Accident · No injuriesClosedStinson 108-1 · Burlington, WINov 25, 1976 · N97849 · Substantial damage NTSB OAK76FVD54Accident · Minor injuriesClosedStinson 108-1 · Antioch, CAAug 31, 1976 · N8456K · Destroyed NTSB ANC76FAH40Accident · Minor injuriesClosedStinson 108 · Palmer, AKJul 24, 1976 · N97905 · Substantial damage NTSB FTW76FRG56Accident · No injuriesClosedStinson 108-1 · Killeen, TXJun 6, 1976 · N9197K · Substantial damage NTSB SEA76AS051Accident · 4 fatalClosedStinson 108-1 · Burley, IDMay 23, 1976 · N8480K · Destroyed NTSB CHI76FEC42Accident · No injuriesClosedStinson 108-1 · Pontiac, MIMay 21, 1976 · N8300K · Substantial damage NTSB MKC76DCA26Accident · No injuriesClosedStinson 108-1 · Creve Coeur, MOMay 9, 1976 · N8614K · Substantial damage NTSB NYC76DFJ19Accident · No injuriesClosedStinson 108-1 · Perry, NYMar 26, 1976 · N9015K · Substantial damage NTSB NYC76DGM18Accident · No injuriesClosedStinson 108 · Listonburg, PADec 6, 1975 · N8212K · Substantial damage NTSB DEN76FTE38Accident · No injuriesClosedStinson 108-1 · Peyton, CONov 4, 1975 · N97962 · Substantial damage NTSB OAK76DVD04Accident · No injuriesClosedStinson 108-1 · Concord, CAAug 17, 1975 · N9092K · Substantial damage NTSB CHI76FEI02Accident · No injuriesClosedStinson 108-1 · East Liverpool, OHJul 5, 1975 · N8145K · Substantial damage NTSB CHI75DEP71Accident · No injuriesClosedStinson 108-1 · Montello, WIJun 27, 1975 · N8784K · Substantial damage NTSB IAD75FIG14Accident · No injuriesClosedStinson 108-1 · Edgewater, MDFeb 22, 1975 · N8721K · Substantial damage NTSB ANC75DAG69Accident · No injuriesClosedStinson 108-1 · Talkeetna, AKFeb 9, 1975 · N8578K · Substantial damage NTSB NYC75DHA26Accident · No injuriesClosedStinson 108-1 · Spring City, PADec 31, 1974 · N8854K · Substantial damage NTSB LAX75D4G23Accident · No injuriesClosedStinson 108-1 · Rubidoux, CADec 1, 1974 · N8358K · Substantial damage NTSB ANC75FAG03Accident · Minor injuriesClosedStinson 108-1 · Big Lake, AKJul 21, 1974 · N362BS · Substantial damage NTSB NYC74FNA43Accident · Minor injuriesClosedStinson 108-1 · Bourne, MAJun 9, 1974 · N97154 · Substantial damage NTSB ANC74FAG99Accident · No injuriesClosedStinson 108-1 · Cantwell, AKApr 15, 1974 · N8489K · Substantial damage NTSB FTW74FPG48Accident · No injuriesClosedStinson 108-1 · N.Little Rock, ARMar 2, 1974 · N8213K · Substantial damage NTSB SEA74DYC34Accident · Minor injuriesClosedStinson 108-1 · Wilsonville, ORJan 8, 1974 · N8651K · Substantial damage NTSB MIA74DLA29Accident · No injuriesClosedStinson 108-1 · Pensacola, FLDec 23, 1973 · N8869K · Substantial damage NTSB CHI74DEE43Accident · No injuriesClosedStinson 108 · Kewanee, ILDec 20, 1973 · N8546K · Substantial damage NTSB FTW74DPD32Accident · No injuriesClosedStinson 108 · Mineral Wells, TXDec 12, 1973 · N8406K · Substantial damage NTSB NYC74FFA10Accident · No injuriesClosedStinson 108 · Albany, NYSep 9, 1973 · N97954 · Substantial damage NTSB ANC74DAG45Accident · No injuriesClosedStinson 108 · Aniak, AKSep 9, 1973 · N97942 · Substantial damage NTSB NYC73FGM31Accident · No injuriesClosedStinson 108-1 · Meadville, PAMay 5, 1973 · N9014K · Substantial damage NTSB LAX73FUG51Accident · Serious injuriesClosedStinson 108-1 · B.Bear City, CAApr 26, 1973 · N8579K · Destroyed NTSB SEA73DYC25Accident · No injuriesClosedStinson 108 · The Dalles, ORApr 21, 1973 · N9019K · Substantial damage NTSB NYC73FNE26Accident · No injuriesClosedStinson 108-1 · Somers, CTMar 28, 1973 · N8485K · Substantial damage NTSB MIA73AM041Accident · 2 fatalClosedStinson 108-1 · Ocala, FLOct 16, 1972 · N8529K · Destroyed NTSB ANC73FAG46Accident · Serious injuriesClosedStinson 108 · Kenai, AKSep 21, 1972 · N9136K · Substantial damage NTSB CHI73FEV09Accident · Minor injuriesClosedStinson 108-1 · Virginia, ILSep 4, 1972 · N9009K · Substantial damage NTSB MIA73DLD12Accident · No injuriesClosedSt1nson 108 · Orlando, FLAug 23, 1972 · N9078K · Substantial damage NTSB CHI73DEV02Accident · Minor injuriesClosedStinson 108-1 · Clinton, ILJul 16, 1972 · N97104 · Substantial damage NTSB SEA72FYE36Accident · No injuriesClosedStinson 108 · Seattle, WAJul 7, 1972 · N97909 · Substantial damage NTSB DEN72FTE76Accident · Serious injuriesClosedStinson 108-1 · Castle Rock, COJun 8, 1972 · N8862K · Substantial damage NTSB CHI72DEM71Accident · No injuriesClosedStinson 108-1 · Traverse Cty, MIMay 28, 1972 · N8874K · Substantial damage NTSB MKC72FTG21Accident · Serious injuriesClosedStinson 108-1 · Williston, NDMay 21, 1972 · N8639K · Substantial damage NTSB NYC72FHD30Accident · No injuriesClosedPiper PA-22 · Medford, NJMar 4, 1972 · N2930Z · 2 aircraft · Substantial damage NTSB SEA72DYI13Accident · No injuriesClosedStinson 108-1 · Brookings, ORFeb 2, 1972 · N97782 · Substantial damage NTSB NYC72FHJ14Accident · No injuriesClosedStinson 108-1 · Deer Park, NYJan 12, 1972 · N8803K · Substantial damage