NTSB investigations: Stinson 108-3
19 cases on aircraft the registry lists as Stinson 108-3, where the first occurrence was “Loss of control - on ground/water”. 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 per year
| 1983 | 2 |
|---|---|
| 1989 | 2 |
| 1990 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 3 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 2 |
Where
Latest cases
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 ('9230408')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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 ('9230408')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 DEN03LA131Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Vernal, UTthe pilot's improper recovery from a bounced landing, and his failure to maintain directional control during landing that resulted in an inadvertent ground loop/swerve.NTSB LAX03CA219Accident · No injuriesData collectionFinal reportStinson 108-3 · St. Johns, AZthe pilot's inadequate compensation for the gusting and shifting wind conditions, which resulted in a failure to maintain directional control and a ground loop. The gusting and shifting wind conditions were factors in the accident.NTSB DEN02LA062Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Falcon, COthe pilot's failure to maintain aircraft control during the takeoff roll and subsequent abort. Factors relating to the accident were the gusting crosswinds and the unsuitable terrain encountered when the airplane departed the runway.NTSB ATL02LA098Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Tuscaloosa, ALThe pilots loss of directional control during landing roll, and subsequent inadvertent ground loop.NTSB CHI01LA333Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Duluth, MNThe pilots failure to maintain directional control during the landing. Factors were the crosswind and the soft terrain.NTSB NYC01LA093Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Falmouth, MAThe pilot's failure to maintain directional control while landing. Factors were the pilot's inadequate weather evaluation and a tailwind.NTSB ANC00LA032Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Fairbanks, AKThe pilot's inadvertent ground loop.NTSB LAX00LA008Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Yuma, AZThe pilot's inadequate compensation for the existing crosswind conditions.NTSB CHI96LA138Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Pontiac, MIfailure of the pilot to maintain control of the airplane during the landing roll. A factor relating to the accident was: the crosswind condition.NTSB ANC96LA048Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Soldotna, AKThe pilot's inadequate compensation for wind conditions. The gusty/crosswind condition was a related factor.NTSB CHI96LA085Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Sandstone, MNthe pilot's selection of an ice-covered runway for takeoff. A factor was the icy runway.NTSB CHI95LA299Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Tribune, KSthe pilot's use of excessive braking during the landing roll. A factor associated with the accident was the pilot's failure to maintain directional control of the airplane during the landing roll.NTSB SEA94LA173Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Ione, WAThe pilot's failure to maintain directional control. Factors include the pilot's fatigue, and trees near the side of the runway.NTSB CHI94LA208Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Warren, MNthe pilot's improper use of the parking brake.NTSB NYC90LA109Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Warehouse Point, CTThe pilot failed to maintain directional control during a landing with a gusty crosswind.NTSB DEN89LA107Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Aurora, COThe inadequate compensation for wind conditions by the pilot. Lack of recent experience in the type of aircraft is considered a contributing factor.NTSB LAX89LA153Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Livermore, CADirectional control not maintained by the pilot. Unfavorable wind, high wind, and gusts were contributing factors.NTSB CHI84LA066Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · La Porte, INThe acft veered off the rwy, hit a ditch and nosed over during takeoff. The plt reported that he lost control of the acft during the takeoff roll and it ran off the side of the rwy into an open field and nosed over.NTSB DEN83LA112Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Buffalo, WYThe plt reported that he attempted to takeoff on rwy 30 with a left x-wind from 210 deg at 25, gusting 30 KTS. At aprx 45 mph, after he had raised the tail of the acft into the takeoff attitude, a gust of wind was encountered & the acft weathervaned to the…