Universal Stinson 108-3
NTSB investigations · 35
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 ('9230418')
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 ('9230418')
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 ANC00LA113Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Yakutat, AKThe pilot's selection of an unsuitable landing area. Factors associated with the accident were the oil sprayed windshield, the sunglare, and an object in the water which the pilot did not see.NTSB SEA00LA161Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Thompson Lake, MTAn improper flare which lead to a hard landing and subsequent main gear collapse as a result of the overload.NTSB FTW00LA139Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Socorro, NMThe pilot's failure to maintain directional control during the aborted takeoff, which resulted in an inadvertent groundloop.NTSB DEN99LA008Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Jackson Hole, WYThe pilot's inability to maintain adequate airspeed which resulted in an inadvertent stall/mush. Factors contributing to the accident were the unfavorable weather condition, mountain wave and the high density altitude.NTSB SEA96LA052Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Hubbard, ORthe pilot's misjudgment of altitude and distance on short final. A factor was the wet and soft terrain short of the runway threshold.NTSB CHI93LA085Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Omaha, NEThe pilot's failure to maintain directional control.NTSB DEN90LA019Accident · No injuriesLimited investigationFinal reportUniversal Stinson 108-3 · Fort Collins, COInadequate compensation for wind conditons by the pilot which resulted in his failure to maintain directional control. Factors related to the accident were: the unfavorable wind condition and soft terrain.NTSB LAX86LA216Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Riverside, CAThe CFI reported that during the landing roll on runway 24, at fla-bob airport, Riverside, CA, the airplane began to 'drift to the right.' The CFI applied left rudder to correct the excursion but his left foot slipped off the rudder bar and became lodged…NTSB ATL84LA270Accident · Minor injuriesLimited investigationFinal reportUniversal Stinson 108-3 · Reidsville, SCThe accident occurred on a low approach to a sloping airstrip with power lines at the uphill end. A go-around was commenced from a low pass, but insufficient climb performance was available, and a pull-up to clear the obstruction resulted in a stall/mush into…NTSB CHI80DA057Accident · 2 fatalClosedStinson 108-3 · Grattan, MINTSB SEA79DYA05Accident · No injuriesClosedStinson 108-3 · Smiths Prairie, IDNTSB SEA78FA053Accident · 1 fatalClosedStinson 108E · Enumclaw, WANTSB ANC78DAA32Accident · Minor injuriesClosedStinson 108-3 · Fairbanks, AKNTSB SEA77FYK06Accident · No injuriesClosedStinson 108 · Burns, ORNTSB ANC76DAA69Accident · No injuriesClosedStinson 108-3 · Nenana, AKNTSB NYC76AN037Accident · 1 fatalClosedStinson 108-3 · Chenamgo Brg, NYNTSB ANC75DAG81Accident · No injuriesClosedStinson 108-3 · Iliamna, AKNTSB ANC75DAG51Accident · Minor injuriesClosedStinson 108-3 · Skwenta, AKNTSB DEN74DTE29Accident · No injuriesClosedStinson 108-3 · Kiowa, CONTSB MKC74FER19Accident · No injuriesClosedStinson 108-3 · Blaine, MNNTSB MKC73FTK16Accident · No injuriesClosedStinson 108-3 · Pierre, SDNTSB NYC73FFA32Accident · No injuriesClosedStinson 108-3 · Indian Lake, NYNTSB ANC73FAG73Accident · Minor injuriesClosedStinson 108-3 · Soldotna, AKNTSB NYC72FHM26Accident · No injuriesClosedStinson 108 · Morganville, NJNTSB MIA71AM079Accident · 1 fatalClosedStinson 108-3 · W.Palm Beach, FLNTSB NYC71FFJ02Accident · Serious injuriesClosedStinson 108-3 · Jamestown, NYNTSB DEN69D0195Accident · No injuriesClosedStinson 108-3 · Albuquerque, NMNTSB MIA69F0324Accident · No injuriesClosedStinson 108-3 · Gainesville, FLNTSB MIA68F0364Accident · No injuriesClosedStinson 108-3 · Belle Glade, FLNTSB DEN67D0080Accident · Minor injuriesClosedStinson 108-3 · Whites City, NMNTSB MIA66A0143Accident · 5 fatalClosedStinson 108-3 · Bunnell, FLNTSB UNK64X3417Accident · No injuriesClosedStinson 108-3 · New Cuyama, CANTSB UNK64X2261Accident · No injuriesClosedStinson 108-3 · Silver City, NMNTSB UNK64X1822Accident · No injuriesClosedStinson 108-3 · Ogdensburg, NYNTSB UNK64X1387Accident · 6 fatalClosedStinson 108-3 · Camas, WA
Back to Universal Stinson 108-3