NTSB investigations: Luscombe 8A, MT

8 cases on aircraft the registry lists as Luscombe 8A. 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

19642026

NTSB investigations: Luscombe 8A, MT per year, 1964–2026: 8 cases
1964	2
1966	1
1967	1
1974	1
1977	1
1978	1
1982	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" = 'MT' 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 ('8190104', '8190111')) 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\" = 'MT' 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 ('8190104', '8190111'))
  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" = 'MT' 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 ('8190104', '8190111'))
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 DEN82DA123Accident · No injuriesFinal reportLuscombe 8A · Laurel, MTDuring the landing roll, the pilot applied heavy braking and the aircraft nosed over, this occurred after he had landed longer than normal and was slowing to gain access to a taxiway. The temperature was 85 degrees fahrenheit and the asphalt runway was hot,…Jun 19, 1982 · N45564 · Substantial damage NTSB SEA78FTI09Accident · No injuriesClosedLuscombe 8A · Hamilton, MTMar 19, 1978 · N45564 · Substantial damage NTSB SEA78DTI01Accident · No injuriesClosedLuscombe 8AC · Boulder, MTNov 13, 1977 · N1041K · Substantial damage NTSB SEA74DTI24Accident · No injuriesClosedLuscombe 8A · Wise River, MTJun 13, 1974 · N45831 · Substantial damage NTSB SEA68F0139Accident · No injuriesClosedLuscombe 8A · Missoula, MTSep 16, 1967 · N45564 · Substantial damage NTSB SEA67F0078Accident · 1 fatalClosedLuscombe 8A · Chinook, MTJul 27, 1966 · N2978K · Destroyed NTSB UNK64X2847Accident · Minor injuriesClosedLuscombe 8A · Lookout Pass, MTJul 15, 1964 · N71491 · Destroyed NTSB UNK64X0371Accident · Minor injuriesClosedLuscombe 8A · Missoula Mont, MTJan 26, 1964 · N1344K · Substantial damage