NTSB investigations: Luscombe 8A, NV

9 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

19652026

NTSB investigations: Luscombe 8A, NV per year, 1965–2026: 9 cases
1965	2
1966	1
1970	2
1971	1
1976	1
1986	1
1989	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" = 'NV' 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\" = 'NV' 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" = 'NV' 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 SEA89LA084Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Battle Mountain, NVInadequate compensation for wind condition by the pilot. Contributing to the accident were wind gusts encountered during landing flare.May 13, 1989 · N2943K · Substantial damage NTSB SEA86LA043Accident · 2 fatalLimited investigationFinal reportLuscombe 8A · Sloan, NVAcft was observed performing low-level aerobatics, failed to complete pull-out from second consecutive overhead maneuver, striking ground in 20-30 degree nose-low attitude. No evidence of pre-impact mechanical failure or malfunction found in acft structure,…Jan 19, 1986 · N41926 · Destroyed NTSB OAK76FVW24Accident · No injuriesClosedLuscombe 8A · Boulder City, NVMay 8, 1976 · N77874 · Substantial damage NTSB OAK72FXQ15Accident · No injuriesClosedLuscombe 8A · Reno, NVOct 10, 1971 · N28629 · Substantial damage NTSB OAK71DXQ22Accident · No injuriesClosedLuscombe 8A · Winnemucca, NVOct 13, 1970 · N2060B · Substantial damage NTSB OAK70FVW02Accident · No injuriesClosedLuscombe 8A · N Las Vegas, NVMar 1, 1970 · N71366 · Substantial damage NTSB LAX66F0337Accident · No injuriesClosedLuscombe 8B · Wellington, NVMay 1, 1966 · N39091 · Substantial damage NTSB LAX66F0056Accident · No injuriesClosedLuscombe 8A · Las Vegas, NVJun 25, 1965 · N1942B · Substantial damage NTSB LAX65F0015Accident · Serious injuriesClosedLuscombe 8A · Centerville, NVMar 5, 1965 · N1148B · Destroyed