NTSB investigations: Stinson 108-3, TX
16 cases on aircraft the registry lists as Stinson 108-3. 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
| 1964 | 1 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1970 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1984 | 1 |
| 1987 | 2 |
| 1996 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2013 | 1 |
Where
Open the mapLatest 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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9230408'))
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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9230408'))
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 CEN13LA305Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Beaumont, TXThe lack of a forward clamp on the carburetor heat box rubber boot, which allowed the boot to be ingested into the inlet of the carburetor heat box, restricting the airflow and leading to a subsequent partial loss of engine power.NTSB CEN09LA384Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Llano, TXThe pilot's inability to maintain aircraft control due to the failure of the left main landing gear wheel, which resulted in the separation of the wheel from the aircraft.NTSB DFW08LA144Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Roanoke, TXThe departing pilot's inadequate visual lookout resulting in his airplane colliding with the landing airplane. Contributing to the accident was the trees/visual obstructions along the runway's approach path.NTSB FTW97LA035Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Tyler, TXa loss of engine power due to failure of the crankshaft. A factor was the lack of suitable terrain for the forced landing.NTSB FTW87LA187Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Hereford, TXThe acft was taking off from a state hwy with a truck blocking traffic at the end of a 2,500 foot stretch. The plt elected to tkof toward the truck, however, during the tkof run, he realized that he could not clear the truck and pulled up sharply. Drng the…NTSB FTW87FA179Accident · 1 fatalField investigationFinal reportStinson 108-3 · Kirbyville, TXThe pilot approached the Kirbyville airport in preparation for landing, witnesses stated that smoke was observed coming from the engine area. The aircraft impacted 30 foot pine trees, & control was lost. The aircraft struck a large tree approximately 5 feet…NTSB FTW84LA173Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Blanco, TXAccording to the plt, the acft was standing unattended with the eng running at 1000 RPM when an inexperienced person attempted to shut down the eng. He reportedly pushed the throttle in, instead of pulling it out & the acft jumped the chocks. According to 2…NTSB FTW80FRG73Accident · Minor injuriesClosedStinson 108-3 · Junction, TXNTSB FTW79FRG16Accident · Serious injuriesClosedStinson 108 · Taft, TXNTSB FTW78DRJ09Accident · No injuriesClosedStinson 108-3 · Portland, TXNTSB FTW76DPD39Accident · No injuriesClosedStinson 108-3 · Vernon, TXNTSB FTW75FQG33Accident · Minor injuriesClosedStinson 108-3 · Plains, TXNTSB FTW71FPA20Accident · No injuriesClosedStinson 108-3 · Midlothian, TXNTSB FTW67F0580Accident · Serious injuriesClosedStinson 108-3 · Whitney, TXNTSB FTW67D0336Accident · No injuriesClosedStinson 108-3 · Houston, TXNTSB UNK64X3726Accident · No injuriesClosedStinson 108-3 · Fabens Tex, TX