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.
Cases, newest first
Query with SQL
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" DESCRun 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 ANC85LA087Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Chugiak, AKWhile landing with a gusty x-wind, the acft bounced, the left wing dragged the ground & the acft went off the rwy. The plt stated that due to the x-wind & his foot slipping off of the rudder pedal, he was unable to maintain directional control.NTSB ANC84FA169Accident · 1 fatalField investigationFinal reportStinson 108 · Hayes River, AKThe plt was on a low level flt to spot wild game when the acft crashed on a gravel drainage bar. A witness stated the acft was flying 5 to 6 ft AGL when the accident occurred.NTSB SEA84FA111Accident · 4 fatalField investigationFinal reportStinson 108-3 · Portland, ORThe plt was briefed on the weather along his intended route of flt & VFR flt was not recommended. The acft departed vancouver, WA, and flew to tigard, OR. It was observed to depart tigard at about 1810 PDT. Numerous witnesses reported that at about 1815, they…NTSB ANC84LA069Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Soldotna, AKThe acft was established in normal cruise when the engine quit. The pilot attempted restarts with negative results. The acft made a forced landing and collided with trees. Post accident examination revealed water in the fuel tanks & lines.NTSB DEN84LA135Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Mcville, NDThe acft collided with the ground, left wing 1st, during an apch to land. The plt stated that the acft apparently stalled. A patrolman noted an odor of alcohol in the plt's breath. A blood/alcohol test showed an alcohol level of 0.19%. The plt's last medical…NTSB FTW84LA173Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Blanco, TXAccording to the plt, the acft was standing unattended with the eng running at 1000 RPM when an inexperienced person attempted to shut down the eng. He reportedly pushed the throttle in, instead of pulling it out & the acft jumped the chocks. According to 2…NTSB CHI84LA066Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · La Porte, INThe acft veered off the rwy, hit a ditch and nosed over during takeoff. The plt reported that he lost control of the acft during the takeoff roll and it ran off the side of the rwy into an open field and nosed over.NTSB DEN83LA112Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Buffalo, WYThe plt reported that he attempted to takeoff on rwy 30 with a left x-wind from 210 deg at 25, gusting 30 KTS. At aprx 45 mph, after he had raised the tail of the acft into the takeoff attitude, a gust of wind was encountered & the acft weathervaned to the…NTSB SEA83FA018Accident · 2 fatalField investigationFinal reportStinson 108-3 · Lynnwood, WAThe eng failed approaching the arpt at low altitude. The acft struck trees during a descending turn toward a power company right-of-way. Investigation revealed that the impulse drive springs on both magnetos had failed in fatigue. The springs are not assigned…NTSB ATL83LA023Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Exmore, VADuring flight, the pilot noticed a decrease in oil pressure and elected to land at an alternate airport. While en route, a complete loss of oil pressure occurred and the pilot executed an emergency landing in an open field. While on the landing roll, the…NTSB SEA82FA093Accident · Serious injuriesField investigationFinal reportStinson 108-3 · Lopez Island, WAThe aircraft engine stopped at 400 feet AGL during climbout. The pilot executed a turn at minimum airspeed and landed the aircraft on a golf course. The landing gear and engine mounts failed. Investigation revealed the aircraft's fuel tanks were empty.NTSB FTW82DRD04Accident · No injuriesClosedStinson 108-3 · Thibodaux, LANTSB CHI81DEM19Accident · Minor injuriesClosedStinson 108-3 · Midland, MINTSB ANC81DAA04Accident · Serious injuriesClosedStinson 108-3 · Nenana, AKNTSB FTW80FRG73Accident · Minor injuriesClosedStinson 108-3 · Junction, TXNTSB CHI80FEV29Accident · No injuriesClosedStinson 108-3 · Chester, ILNTSB MKC80DCJ19Accident · Minor injuriesClosedStinson 108-3 · Minden, NENTSB SEA80DYM35Accident · No injuriesClosedStinson 108-3 · Dayton, ORNTSB ANC80DAD06Accident · Minor injuriesClosedStinson 108-3 · Wrangell, AKNTSB ANC80DAA09Accident · Serious injuriesClosedStinson 108-3 · Kevinjik Lk, AKNTSB IAD80FKM05Accident · Minor injuriesClosedStinson 108-3 · Hendersonville, NCNTSB SEA79DYK17Accident · No injuriesClosedStinson 108-3 · Malin, ORNTSB SEA79DYK13Accident · Minor injuriesClosedStinson 108-3 · Ashland, ORNTSB LAX79FVW14Accident · Minor injuriesClosedStinson 108-2 · Glendale, NVNTSB FTW79FRG16Accident · Serious injuriesClosedStinson 108 · Taft, TXNTSB SEA79DYM10Accident · No injuriesClosedStinson 108-3 · Dallesport, WANTSB OAK79FVM05Accident · No injuriesClosedStinson 108-3 · San Carlos, CANTSB OAK78DVD06Accident · No injuriesClosedStinson 108-3 · Concord, CANTSB SEA78FYE36Accident · No injuriesClosedStinson 108-3 · Neah Bay, WANTSB SEA78DYA25Accident · No injuriesClosedStinson 108-3 · Boise, IDNTSB LAX78FUA25Accident · No injuriesClosedStinson 108-3 · Long Beach, CANTSB MKC78FTK31Accident · No injuriesClosedStinson 108-3 · Miller, SDNTSB MKC78FCJ30Accident · Minor injuriesClosedStinson 108-3 · Mccook, NENTSB SEA78FYM45Accident · No injuriesClosedStinson 108-3 · The Dalles, ORNTSB LAX78DUJ57Accident · Minor injuriesClosedStinson 108-3 · Camp Verde, AZNTSB DEN78DDQ15Accident · No injuriesClosedStinson 108-3 · Las Cruces, NMNTSB OAK78DVM13Accident · Minor injuriesClosedStinson 108-3 · Carmel Valley, CANTSB CHI78FEC19Accident · No injuriesClosedStinson 108-3 · Fraser, MINTSB FTW78DRJ09Accident · No injuriesClosedStinson 108-3 · Portland, TXNTSB NYC77FNC55Accident · No injuriesClosedStinson 108-3 · Saco, MENTSB MIA77FK030Accident · No injuriesClosedStinson 108-3 · Quitman, MSNTSB NYC77FNA30Accident · No injuriesClosedStinson 108-3 · Marshfield, MANTSB IAD78FA010Accident · 1 fatalClosedStinson 108-3 · Knoxville, TNNTSB ANC77DAA37Accident · No injuriesClosedStinson 108 · Kotzebue, AKNTSB LAX77FUA13Accident · Serious injuriesClosedStinson 108-3 · Santa Ana, CANTSB CHI77FEM23Accident · No injuriesClosedStinson 108-3 · Birch Run, MINTSB ANC77DAA16Accident · No injuriesClosedStinson 108-3 · Fairbanks, AKNTSB ANC77DAG16Accident · Serious injuriesClosedStinson 108-3 · Aleknagik, AKNTSB MIA77FLD13Accident · Serious injuriesClosedStinson 108-3 · Brandon, FLNTSB DEN76FQA64Accident · Minor injuriesClosedStinson 108-3 · Albuquerque, NM