NTSB investigations: Stinson 108
186 cases on aircraft the registry lists as Stinson 108. 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 ('9230402'))
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 ('9230402'))
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 NYC87LA130Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Rumford Point, MEWhile circling a pond, the plt failed to switch fuel tanks and the engine lost power. He attempted to switch from the right to the left tank but was forced to set the acft down in a nearby field. The left wing, fuselage, landing gear, prop, and engine mounts…NTSB LAX87LA194Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Healdsburg, CADuring what was supposed to be a taxi test, the plt decided to takeoff when he lost control of the acft. The acft veered to the right off the rwy and collided with the terrain. The plt had flown the acft for the first time with the owner the day before the…NTSB LAX87LA148Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Rio Vista, CAThe aircraft nosed over in soft soil after a forced landing. The aircraft's engine failed during the departure climb and the pilot was unable to restart it. The pilot accomplished a forced landing to a field. The aircraft nosed over when the nose gear became…NTSB NYC87LA077Accident · No injuriesLimited investigationFinal reportStinson 108 · Wildwood, NJThe plt rprtd that prior to takeoff, he taxied thru svrl puddles of water from melting snow. The temp at that time was rprtd as 25 deg. He rprtd that when he landed at Wildwood, the wind was from 290 deg at 15 gusting 20 KTS & the temp was 30 deg. He said…NTSB SEA86FA034Accident · 2 fatalField investigationFinal reportStinson 108 · Hoquiam, WAThe acft contacted terrain 680 ft north of rwy 06 at bowerman airfield. The acft departed elma arpt, ocean shores, WA, sometime around 2330 PST, on 12-29-85. Prior to the departure the passenger stated to persons they were waiting for the fog to clear for…NTSB CHI85LA260Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Roseau, MNThe plt intentionally ground looped the acft during a forced landing to avoid obstacles following a loss of power en route. Aprx 1 1/2 hrs into the flt the plt noticed an engine roughness followed by an increase in oil temp which returned to normal shortly…NTSB LAX85FA038Accident · 1 fatalField investigationFinal reportStinson Voyager 150 · Meadow Vista, CAThe acft collided with terrain while maneuvering northeast of auburn airport during a VFR personal flt. The plt advised sacramento TRACON that he had auburn arpt in sight. However, TRACON observed N97638 fly over & pass auburn arpt in a northerly direction &…NTSB FTW85LA033Accident · No injuriesLimited investigationFinal reportStinson 108 · Sandia, TXThe plt was attempting a night landing at an unlighted airport. Plt stated he elecuted a low angle approach, knowing of elevated and wooded terrain off the end of the runway. On sighting trees to his left, he initiated a go-around but struck other trees…NTSB LAX84LA365Accident · No injuriesLimited investigationFinal reportStinson 108 · Camarillo, CAA prospective buyer in the left seat was initiating a takeoff in a tail wheel acft when the acft ground looped and the right main landing gear collapsed. The owner in the right seat was unable to correct the situation in time. The buyer had professed…NTSB SEA84FA032Accident · 1 fatalField investigationFinal reportStinson 108-1 · Vashon, WAJust after taking off in IMC at night, the acft crashed near the departure end of rwy 36. According to a witness, the acft climbed after takeoff to about 200 ft above the trees, then entered a descent & disappeared behind a tree line. After crashing, the acft…NTSB ANC84LA015Accident · No injuriesLimited investigationFinal reportStinson 108 · Skwentna, AKAfter takeoff the eng lost 50% of its power & a forced landing was made in trees. The plt believed the eng failure was due to water/ice in fuel.NTSB MKC84FA016Accident · Serious injuriesField investigationFinal reportStinson 108 · Angora, NEThe plt reported that the eng began running rough, then quit while he was flying over an area of rough terrain. He reported that as he was making a forced landing, the acft came in contact with a washed out ditch, cartwheeled & hit a fence. An exam of the eng…NTSB ANC83FA174Accident · No injuriesField investigationFinal reportStinson 108-1 · Anchorage, AKThe acft struck a dirt bank while landing on a sandbar on the yentna river. The plt stated he was pre-occupied at the sight of a moose near the landing area and did not excercise adequate care in selecting landing path. There was about 2000 ft of good landing…NTSB CHI83LA146Accident · No injuriesLimited investigationFinal reportStinson 108 · Rochester, INThe acft collided with a snow bank and nosed over during landing. The weather was VMC and the wind was from 210 degrees at 5 KTS. The pilot reported his right foot slipped off the the rudder pedal and 'attributes this to stinsons and many other acft were not…NTSB ANC83LA002Accident · No injuriesLimited investigationFinal reportRockwell International Stinson 108 · Near Sparrevohn, AKThe pilot stated that after shooting a moose in the morning, quartering the animal and carrying the meat to the an unimproved landing/takeoff area he walked back to his cabin for his aircraft. Upon his return, he landed and loaded 2 quarters into the back…NTSB ANC82DAG29Accident · Serious injuriesFinal reportStinson 181 · Talkeetna, AKThe pilot made a forced landing after a spark plug blew out of the engine. During the landing the aircraft collided with a tree.NTSB CHI81FEI26Accident · Minor injuriesClosedStinson 108-1 · Chardon, OHNTSB LAX81FJA11Accident · No injuriesClosedStinson 108 · Kaunakakai, HINTSB ATL81FLJ04Accident · Minor injuriesClosedStinson 108 · Havelock, NCNTSB MIA81FLD08Accident · Minor injuriesClosedStinson 108-2 · Clearwater, FLNTSB NYC80DHD06Accident · No injuriesClosedStinson 108-2 · Toms River, NJNTSB ANC80DAG13Accident · No injuriesClosedStinson 108-3 · Skwentna, AKNTSB DEN79FTC12Accident · No injuriesClosedStinson 108 · Point Of Rocks, WYNTSB SEA79FTA12Accident · No injuriesClosedStinson 108-2 · Sidney, MTNTSB CHI79DEG07Accident · No injuriesClosedStinson 108 · Cincinnati, OHNTSB MIA79DKT05Accident · Serious injuriesClosedStinson 108-1 · Delray Beach, FLNTSB SEA78DYP11Accident · No injuriesClosedStinson 108 · Mead, WANTSB ANC77DAH01Accident · Serious injuriesClosedStinson 108 · Anchorage, AKNTSB ANC77FAG70Accident · No injuriesClosedStinson 108-1 · Anchorage, AKNTSB LAX77DUJ60Accident · No injuriesClosedStinson 108 · Mesa, AZNTSB SEA77DYM38Accident · No injuriesClosedStinson 108 · Long Creek, ORNTSB OAK77DVD33Accident · No injuriesClosedStinson 108-1 · Healdsburg, CANTSB IAD77FID02Accident · No injuriesClosedStinson 108 · Newport News, VANTSB SEA77DYA01Accident · No injuriesClosedStinson 108 · Soda Springs, IDNTSB FTW76FRD63Accident · No injuriesClosedStinson 108 · Baton Rouge, LANTSB IAD76FLJ32Accident · No injuriesClosedStinson 108 · Durham, NCNTSB CHI76DEG15Accident · Minor injuriesClosedStinson 108 · Cincinnati, OHNTSB NYC76FFA35Accident · No injuriesClosedStinson 108-1 · Johnstown, NYNTSB ANC76AAG71Accident · Minor injuriesClosedStinson 108 · Port Alsworth, AKNTSB OAK76DVD13Accident · No injuriesClosedStinson 108 · Willets, CANTSB LAX76DUJ09Accident · No injuriesClosedStinson 108 · Prescott, AZNTSB OAK76DVG08Accident · No injuriesClosedStinson 108 · Vacaville, CANTSB CHI76DEG02Accident · No injuriesClosedStinson 108 · Batavia, OHNTSB NYC75DGM35Accident · No injuriesClosedStinson 108 · Clarion, PANTSB ANC75DAG74Accident · No injuriesClosedStinson 108-1 · Iliamna, AKNTSB MKC75DER37Accident · No injuriesClosedStinson 108 · Vermillion, MNNTSB NYC75DFA11Accident · Minor injuriesClosedStinson 108 · Andes, NYNTSB LAX75DUJ28Accident · Minor injuriesClosedStinson 108-2 · Rillito, AZNTSB LAX74FUQ33Accident · Serious injuriesClosedStinson 108 · Santa Paula, CANTSB SEA74FYG27Accident · Minor injuriesClosedStinson 108-1 · Tekoa, WA