Skip to content

Universal Stinson 108

NTSB investigations · 22

Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('9230412') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('9230412')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('9230412')
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 CEN25FA194Accident · 2 fatalClass 3 · FieldPreliminary reportUniversal Stinson 108 · Farmington, NCOn June 3, 2025, about 1145 eastern daylight time, a Universal Stinson 108 airplane, N40518 was destroyed when it was involved in an accident near Farmington, North Carolina. The pilot and one passenger were fatally injured, and one passenger was seriously…Jun 3, 2025 · N40158 · Substantial damage NTSB ANC16LA035Accident · Minor injuriesLimited investigationFinal reportUniversal Stinson 108 · Big Lake, AKA total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the airframe and engine revealed no mechanical malfunctions or failures that would have precluded normal operation.Jun 26, 2016 · N9063K · Substantial damage NTSB ERA16LA173Accident · No injuriesLimited investigationFinal reportUniversal Stinson 108 · Calverton, NYThe pilot's failure to maintain directional control during the landing roll.Apr 30, 2016 · N8660K · Substantial damage NTSB ERA12LA411Accident · 1 fatalLimited investigationFinal reportUniversal Stinson 108 · Portland, MEA fatigue failure of the No. 3 piston skirt, which resulted in a total loss of engine power and the subsequent ditching in the ocean.Jun 24, 2012 · N39443 · Substantial damage NTSB ERA10LA442Accident · 1 fatalLimited investigationFinal reportStinson 108 · Andrews, SCLoss of engine power due to fuel exhaustion, and the student pilot's failure to adequately preflight the airplane prior to takeoff.Aug 25, 2010 · N97316 · Substantial damage NTSB MIA97LA144Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Smithfield, NCa fracture in the crankshaft, which resulted in a total loss of engine power, a forced landing, and a nose over.Apr 19, 1997 · N9063K · Substantial damage NTSB ANC92LA059Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Mccarthy, AKThe pilot's failure to maintain directional control of the airplane. Contributing to the accident were the snow berm and the pilot's lack of total experience in the type of operation (ski equipped airplanes).Apr 8, 1992 · N97421 · Substantial damage NTSB FTW85FA152Accident · 1 fatalField investigationFinal reportUniversal Stinson 108 · Emhouse, TXWitnesses observed the student plt making repeated low passes near his friend's house. While maneuvering, the acft collided with a power line, then crashed to the ground inverted. The student held a student plt certificate that was dated 10/17/62. No record…Mar 17, 1985 · N953D · Substantial damage NTSB NYC82FGT06Accident · No injuriesClosedStinson 108 · Brogue, PADec 12, 1981 · N97206 · Substantial damage NTSB MKC80DCG35Accident · No injuriesClosedStinson 108 · Liberty, MOJul 23, 1980 · N97350 · Substantial damage NTSB MIA80FKJ17Accident · Serious injuriesClosedStinson 108-1 · Irvington, ALFeb 6, 1980 · N8537K · Destroyed NTSB NYC77FHJ08Accident · No injuriesClosedStinson 108 · Amityville, NYMar 2, 1978 · N97371 · Substantial damage NTSB ANC75DAG06Accident · No injuriesClosedStinson 108-2 · Anchorage, AKJul 28, 1974 · N97612 · Substantial damage NTSB CHI74DEM42Accident · Minor injuriesClosedStinson 108 · Grant, MIMar 19, 1974 · N97226 · Substantial damage NTSB NYC71DFA18Accident · No injuriesClosedStinson 108-2 · Heuvelton, NYOct 13, 1970 · N97230 · Substantial damage NTSB DIA68F0095Accident · Minor injuriesClosedStinson 108-2 · Morganton, NCOct 8, 1967 · N6433M · Destroyed NTSB NYC67D0529Accident · No injuriesClosedStinson 108 · Deer Park, NYMar 12, 1967 · N97371 · Substantial damage NTSB CHI66F0215Accident · No injuriesClosedStinson 108 · St Helen, MIAug 30, 1965 · N97226 · Substantial damage NTSB LAX65A0074Accident · 2 fatalClosedStinson 108 · Lebec, CAMar 14, 1965 · N39463 · Destroyed NTSB UNK65X0792Accident · No injuriesClosedStinson 108 · Emporia, KSNov 22, 1964 · N97350 · Substantial damage NTSB UNK64X0530Accident · No injuriesClosedStinson 108 · Yucca Valle, CAFeb 10, 1964 · N40157 · Substantial damage NTSB UNK64X0359Accident · Minor injuriesClosedStinson 108 · Hammond, LAJan 26, 1964 · N97131 · Substantial damage

Back to Universal Stinson 108