NTSB investigations: Stinson 108-3, FL

10 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

NTSB investigations: Stinson 108-3, FL per year, 1965–2026: 10 cases
1965	1
1967	2
1968	1
1969	1
1973	1
1976	1
2000	1
2003	1
2026	1

Where

Open the map

Latest cases

Query with SQL

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 ('9230408')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('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" = '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 ('9230408'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ERA26LA108Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-3 · Palmetto, FLThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Feb 6, 2026 · N528C · Substantial damage NTSB ATL04LA007Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Lake Placid, FLThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.Oct 5, 2003 · N831C · Substantial damage NTSB MIA00LA071Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Deland, FLThe pilot's evasive maneuver during landing roll due to panic after hearing another pilot report landing on the opposite runway resulting in the pilot losing directional control and nosing over in soft terrain. A factor in the accident was the pilot of the…Jan 22, 2000 · N663C · Substantial damage NTSB MIA77FLD13Accident · Serious injuriesClosedStinson 108-3 · Brandon, FLNov 7, 1976 · N6159M · Destroyed NTSB MIA74DLD01Accident · No injuriesClosedStinson 108-3 · Ft.Pierce, FLJul 4, 1973 · N6954M · Substantial damage NTSB MIA70D0047Accident · No injuriesClosedStinson 108-3 · Venice, FLJun 21, 1969 · N6713M · Substantial damage NTSB MIA69A0028Accident · 2 fatalClosedStinson 108-3 · Ft.Lauderdale, FLNov 28, 1968 · N4174C · Destroyed NTSB UNK67X0159Accident · Minor injuriesClosedStinson 108-3 · Wauchula, FLSep 22, 1967 · N6019M · Substantial damage NTSB MIA67D0564Accident · Minor injuriesClosedStinson 108-3 · Satsuma, FLMay 20, 1967 · N6964M · Substantial damage NTSB MIA65A0070Accident · 1 fatalClosedStinson 108-3 · Bunnell, FLJan 1, 1965 · N525C · Destroyed