NTSB investigations: Stinson 108-1, FL
11 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
| 1964 | 1 |
|---|---|
| 1966 | 1 |
| 1968 | 1 |
| 1971 | 1 |
| 1972 | 2 |
| 1973 | 1 |
| 1977 | 1 |
| 1983 | 1 |
| 1987 | 1 |
| 1997 | 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\" = 'FL' 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" = 'FL' 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 MIA97LA068Accident · No injuriesLimited investigationFinal reportStinson 108 · Winter Haven, FLFailure of the pilot to use carburetor heat for descent resulting in engine failure due to carburetor induction icing.NTSB MIA87LA193Accident · No injuriesLimited investigationFinal reportStinson 108-1 · West Palm Beach, FLWhile on an instructional flt during the landing roll the acft began to drift to the right. The student plt corrected the drift with left rudder, however he then added full power. The acft then ground looped to the left, during which the right main gear…NTSB MIA83LA238Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Clermont, FLDuring flt, the eng began running rough & oil began leaking & spreading onto the windshield. The eng subsequently failed & the plt selected an area for a forced landing, during the landing, the acft contacted trees & was damaged. An investigation revealed…NTSB MIA77FLD34Accident · Serious injuriesClosedStinson 108-1 · Winter Haven, FLNTSB MIA74DLA29Accident · No injuriesClosedStinson 108-1 · Pensacola, FLNTSB MIA73AM041Accident · 2 fatalClosedStinson 108-1 · Ocala, FLNTSB MIA73DLD12Accident · No injuriesClosedSt1nson 108 · Orlando, FLNTSB MIA72FLD41Accident · No injuriesClosedStinson 108-1 · Oklawaha, FLNTSB MIA69D0284Accident · Minor injuriesClosedStinson 108 · Fort Myers, FLNTSB MIA66D0472Accident · No injuriesClosedStinson 108 · Merritt Is, FLNTSB UNK65X1025Accident · No injuriesClosedStinson 108-1 · Groveland, FL