NTSB investigations: Stinson 108-1, AK
23 cases on aircraft the registry lists as Stinson 108-1. 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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 2 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 2 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 4 |
| 1983 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 2003 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2021 | 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\" = 'AK' 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 ('9230404'))
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" = 'AK' 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 ('9230404'))
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 ANC21LA068Accident · No injuriesClass 3 · LimitedFinal reportStinson 108-1 · Sterling, AKInsufficient available power as a result of low compression in three engine cylinders. Contributing to the accident was the pilot’s decision to takeoff with a slight quartering tailwind.NTSB ANC10CA051Accident · No injuriesData collectionFinal reportStinson 108-1 · Galena, AKThe pilot's failure to maintain directional control during takeoff, resulting in a ground-loop, and collapse of the right main landing gear.NTSB ANC10CA010Accident · No injuriesData collectionFinal reportStinson 108-1 · Selawik, AKThe pilot's failure to maintain a proper descent rate during landing, resulting in a hard landing.NTSB ANC03LA028Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Sitka, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground loop, and the collapse of the right main landing gear.NTSB ANC98LA117Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Delta Junction, AKThe pilot's selection of an unsuitable takeoff area. Factors associated with the accident were willow trees, and rising terrain.NTSB ANC94LA117Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Anchorage, AKThe binding in the mechanical fuel selector valve, and lack of suitable terrain for a forced landing.NTSB ANC83LA117Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Nenana, AKThe acft nose gear failed during a forced landing after the engine lost power during climbout. The plt rptd the engine began to run intermittently then quit completely. The acft had just been serviced with 36 gallons of 80/87 octane fuel. The student pilot…NTSB ANC77DAA36Accident · No injuriesClosedStinson 108 · Northway, AKNTSB ANC77DAG64Accident · No injuriesClosedStinson 108-1 · Kenai, AKNTSB ANC77DAG43Accident · No injuriesClosedStinson 108-1 · Twin Lakes, AKNTSB ANC77DAG27Accident · Minor injuriesClosedStinson 108-1 · Kenai, AKNTSB ANC76FAH40Accident · Minor injuriesClosedStinson 108 · Palmer, AKNTSB ANC75DAG69Accident · No injuriesClosedStinson 108-1 · Talkeetna, AKNTSB ANC75FAG03Accident · Minor injuriesClosedStinson 108-1 · Big Lake, AKNTSB ANC74FAG99Accident · No injuriesClosedStinson 108-1 · Cantwell, AKNTSB ANC74DAG45Accident · No injuriesClosedStinson 108 · Aniak, AKNTSB ANC73FAG46Accident · Serious injuriesClosedStinson 108 · Kenai, AKNTSB ANC72DAA19Accident · No injuriesClosedStinson 108-1 · Black Rapids, AKNTSB ANC72DAG52Accident · Minor injuriesClosedStinson 108 · Willow, AKNTSB ANC70D0073Accident · No injuriesClosedStinson 108-1 · Delta Junctn, AKNTSB ANC69D0064Accident · No injuriesClosedStinson 108-1 · Fairbanks, AKNTSB ANC67D0064Accident · No injuriesClosedStinson 108-1 · King Salmon, AKNTSB ANC66D0036Accident · No injuriesClosedStinson 108-1 · Klukwan, AK