Universal Stinson 108-1
NTSB investigations · 25
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 ('9230414')
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 ('9230414')
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 ERA15LA201Accident · No injuriesLimited investigationFinal reportUniversal Stinson 108-1 · Macon, MSA partial loss of engine power for reasons that could not be determined based on the available information.NTSB ERA13CA422Accident · No injuriesData collectionFinal reportUniversal Stinson 108 1 · Lawrenceville, GAThe pilot's failure to maintain directional control during the landing, resulting in a ground loop, runway excursion, and structural damage to the right wing.NTSB CEN13CA412Accident · No injuriesData collectionFinal reportUniversal Stinson 108-1 · Hector, MNThe pilot’s inadvertent application of the brakes and failure to main directional control of the airplane during the takeoff roll, which resulted in the airplane nosing over.NTSB ATL07CA059Accident · No injuriesData collectionFinal reportStinson 108 · Lawrenceville, GAThe pilot's failure to maintain directional control on landing roll out resulting in a ground loop.NTSB SEA98LA177Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Spray, ORA partial loss of engine power, and the pilot's subsequent misjudgment of clearance with a transmission wire during a precautionary landing approach. The reason for the power loss was not determined; however, the pilot reported that it was not of a mechanical…NTSB ANC90LA140Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Fareweel, AKThe pilot's decision to takeoff downwind.NTSB DEN89LA226Accident · Minor injuriesLimited investigationFinal reportUniversal Stinson 108-1 · Hudson, COPartial loss of engine power for an unknown reason. A factor related to the accident was: the alfalfa crop.NTSB MKC89LA052Accident · No injuriesLimited investigationFinal reportStinson 108-1 · South St. Paul, MNThe failure of the pilot to maintain directional control of the airplane. Contributing to the accident were the crosswind conditions.NTSB DEN86LA035Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Beulah, NDDuring a landing at dusk on a snow covered rwy, the acft encountered deep snow and nosed over onto its back. The plt stated that after touchdown, he realized that there was aprx one ft of snow on the rwy and was unable to make a go-around.NTSB DEN84LA246Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Bountiful, UTFollowing an uneventful runup the pilot took off and was climbing through 400 ft AGL when the engine began to lose power. The pilot then turned on the carburetor heat, but it did not alleviate the engine problem. He then made an emergency landing in a field,…NTSB NYC82DA070Accident · No injuriesFinal reportStinson 108-1 · Factoryville, PAThe pilot was practicing landings in gusty wind conditions. He reported that the first landing was uneventful, but the second landing was aborted due to gusty turbulence. He stated that the third landing was made in relatively calm wind conditions until just…NTSB SEA79DYP07Accident · No injuriesClosedStinson 108-1 · Pritchard, IDNTSB CHI76FET50Accident · No injuriesClosedStinson 108-1 · Woodburn, INNTSB NYC75FHA19Accident · No injuriesClosedStinson 108-1 · Berwick, PANTSB NYC75FNE04Accident · Serious injuriesClosedStinson 108-1 · W Springfld, MANTSB OAK74FXQ25Accident · No injuriesClosedStinson 108-1 · Fallon, NVNTSB NYC74AN053Accident · Serious injuriesClosedStinson 108-1 · Amityville, NYNTSB MIA72FLA03Accident · No injuriesClosedStinson 108-1 · Pensacola, FLNTSB ANC71DAG53Accident · No injuriesClosedStinson 108-1 · Egegik, AKNTSB FTW70F0167Accident · Minor injuriesClosedStinson 108-1 · Saginaw, TXNTSB CHI69D0298Accident · No injuriesClosedStinson 108-1 · Northfield, OHNTSB CHI68D0072Accident · No injuriesClosedStinson 108-1 · N.Philadelph, OHNTSB NYC67F0237Accident · No injuriesClosedStinson 108-1 · Clinton, MDNTSB SEA67F0104Accident · No injuriesClosedStinson 108-3 · Portland, ORNTSB MKC66F0204Accident · No injuriesClosedStinson 108-1 · Derby, KS
Back to Universal Stinson 108-1