Universal Stinson 108-2
NTSB investigations · 43
Matched to the registry by N-number and event date, 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_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 ('9230416')
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 ('9230416')
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 ANC25LA036Accident · Minor injuriesClass 4 · LimitedFinal reportStinson 108 · North Pole, AKThe pilot's failure to maintain obstacle clearance which resulted in an in-flight collision with a tree. Contributing to the accident was his impairment from the effects of alcohol consumption.NTSB WPR22LA085Accident · No injuriesClass 4 · LimitedFinal reportUniversal Stinson 108-2 · Byron, CAThe pilot’s inadequate flare and loss of directional control during landing which resulted in a runway excursion. Contributing to the accident was the instructor’s delayed remedial action.NTSB WPR20CA236Accident · No injuriesClass 4 · Data collectionFinal reportStinson 108 · Farewell Lakes, AKThe pilot's delayed decision to abort the takeoff roll, which resulted in a runway overrun and airplane nose over.NTSB DEN00LA068Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Las Cruces, NMThe pilot's failure to maintain directional control, resulting in an inadvertent ground loop/swerve. Factors were a burnt and unseated intake valve, and the tail wind.NTSB ANC98LA039Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Chugiak, AKThe pilot's selection of an unsuitable, slush-covered, runway for landing. A factor was the slush-covered runway.NTSB ANC95LA099Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Anchorage, AKThe pilot's loss of directional control, during the takeoff roll, which resulted in an inadvertent swerve, and the pilot's excessive application of brake pressure, which resulted in a nose down condition.NTSB DEN91LA080Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Santa Fe, NMA forward aft pilot seat adjustment locking mechanism failure.NTSB SEA90LA062Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Hillsboro, ORPilot displayed poor starting procedures by proceeding with known deficiencies with the parking brake and the inadequacies of the tie down. The pilot did not attain assistance for this procedure which resulted in the airplane getting away and colliding with…NTSB SEA83FA096Accident · Serious injuriesField investigationFinal reportStinson 108-2 · Quilcene, WAThe acft collided with trees at the 2800 ft level of a mountain after the pilot encountered IMC weather. The weather wasvmc in the area but the mountain ranges had been forecast to be obscured in weather. The pilot had received a weather briefing. The acft…NTSB MKC82FCJ06Accident · Serious injuriesFinal reportStinson 108-2 · Chadron, NEAfter departure, the pilot experienced a loss of power. The pilot made a forced landing in a field approximately one mile from the airport. Examination of the aircraft engine revealed that the mixture control was not attached at the carburetor and that the…NTSB NYC82DA130Accident · No injuriesFinal reportStinson 180-2 · Richland, NYWhile on a local flight, the pilot observed a front moving in, so he decided to return to the airport and land. He reported that there was no turbulence while he was on downwind or base and the wind sock was favoring runway 16. However, on final approach,…NTSB MKC80DCJ33Accident · Minor injuriesClosedUniv Acft 108-2 · Omaha, NENTSB NYC80DNA22Accident · No injuriesClosedStinson 108-2 · Quonset, RINTSB DEN78FTM17Accident · Minor injuriesClosedStinson 108-2 · Vernal, UTNTSB DEN78FA007Accident · 2 fatalClosedStinson 108-2 · Hope, NMNTSB MKC77FCJ29Accident · No injuriesClosedStinson 108-2 · Scotts Bluff, NENTSB CHI76FEI27Accident · No injuriesClosedUniv Acft 108-2 · Thompson, OHNTSB NYC75FFJ08Accident · No injuriesClosedStinson 108-2 · Niagara Falls, NYNTSB FTW74DPG55Accident · No injuriesClosedStinson 108-2 · Schug, ARNTSB ANC73FAG52Accident · Serious injuriesClosedStinson 108-2 · Anchorage, AKNTSB CHI72AC090Accident · 1 fatalClosedStinson 108-2 · Utica, MINTSB MKC72FCJ58Accident · Serious injuriesClosedStinson 108-2 · Seward, NENTSB MIA72AM010Accident · 2 fatalClosedStinson 108-2 · Cartersville, GANTSB SEA71FDA05Accident · Serious injuriesClosedStinson 108-2 · Red Lodge, MTNTSB SEA71DDG02Accident · No injuriesClosedStinson 108-2 · Floweree, MTNTSB ANC70A0025Accident · 2 fatalClosedStinson 108-2 · Kenai, AKNTSB OAK69D0279Accident · No injuriesClosedStinson 108-2 · Clarksburg, CANTSB CHI69F0233Accident · Minor injuriesClosedStinson 108-2 · Baraboo, WINTSB SEA68D0258Accident · No injuriesClosedStinson 108-2 · Seattle, WANTSB FTW68D0351Accident · Minor injuriesClosedStinson 108-2 · Houston, TXNTSB ANC68F0057Accident · No injuriesClosedStinson 108-2 · Homer, AKNTSB SEA68D0035Accident · No injuriesClosedStinson 108 · Challis, IDNTSB OAK67D0146Accident · Minor injuriesClosedStinson 108-2 · Novato, CANTSB ANC67A0030Accident · 1 fatalClosedStinson 108-2 · ZNTSB ANC67F0024Accident · No injuriesClosedStinson 108-2 · Nchorage, AKNTSB OAK67D0029Accident · No injuriesClosedStinson 108-2 · Goodsprings, NVNTSB NYC66F0646Accident · No injuriesClosedStinson 108-2 · Deer Park, NYNTSB SEA65F0073Accident · Minor injuriesClosedStinson 108-2 · Oregon City, ORNTSB CHI65A0070Accident · 1 fatalClosedStinson 108 · Frederic, MINTSB UNK65X1236Accident · No injuriesClosedStinson 108-2 · Tulare, CANTSB UNK65X0476Accident · No injuriesClosedStinson 108 · Panama City, FLNTSB UNK64X3844Accident · No injuriesClosedStinson 108-2 · San Lucas, CANTSB UNK64X0634Accident · No injuriesClosedStinson 108-2 · Federal Way, WA
Back to Universal Stinson 108-2