NTSB investigations: Stinson 108-2
9 cases on aircraft the registry lists as Stinson 108-2, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 2002 | 1 |
| 2004 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9230406')
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\" = 353))
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 ('9230406')
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" = 353))
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 CHI05LA013Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Indian River, MILoss of engine power during initial climb after takeoff for undetermined reasons. A contributing factor was the unsuitable terrain for a forced landing encountered by the pilot and the airplane's low altitude at the time engine power was lost.NTSB ATL02LA037Accident · Serious injuriesLimited investigationFinal reportConsolidated-Vultee 108-M · Bayou La Batre, ALThe loss of engine power for undetermined reasons.NTSB FTW96LA202Accident · No injuriesLimited investigationFinal reportStinson 108-2 · El Paso, TXthe pilot's improper inflight planning/decision, which resulted in fuel exhaustion and a subsequent forced landing. A factor relating to the accident was: the unfavorable en route wind.NTSB CHI94LA163Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Kettle River, MNThe pilot's improper use of carburetor heat and the lack of suitable terrain for a forced landing. The carburetor icing weather condition was a factor.NTSB ATL88LA180Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Avon, OHThe acft was on initial climb out when the eng quit. The acft was at an estimated altitude of 100 ft and over trees at the time of the power loss. The plt attempted to return to the airstrip. The acft landed hard in a nose down position off to the side of the…NTSB ATL87LA140Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Huntersville, NCThe plt reported that he closed the throttle to simulate an engine failure after takeoff from rwy 06, at about 400-500 ft AGL. He subsequently made a 180 degree turn back toward the arpt to practice a simulated forced ldg, and the acft sink rate increased to…NTSB ATL85LA203Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Lewisburg, WVAcft lost power in cruise flight shortly after takeoff. Descent was begun to a field followed by engine quitting. During the turn to final, pilot said, left wing stalled resulting in hard landing on left wheel and left wing. Later, fuel cap vents were found…NTSB CHI83LA189Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Greencastle, INThe acft experienced power loss at about 300 feet AGL after takeoff. The pilot landed in a cornfield after attempting a restart of the engine. The pilot had put 5 gallons of fuel in the right tank on the day of the accident in preparation for a test flight.…NTSB CHI83LA046Accident · No injuriesLimited investigationFinal reportStinson 108 · Milan, MIWhile on downwind the pilot stated he "pulled the carburator heat on and almost immediately reduced the power." At this point the engine stopped. Although he attempted to restart the engine while executing emergency procedures, the engine failed to respond.…