NTSB investigations: Luscombe 8F, CA

9 cases on aircraft the registry lists as Luscombe 8F. 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 8F, CA per year, 1964–2026: 9 cases
1964	1
1965	1
1967	3
1969	1
1986	1
1988	1
2003	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" = 'CA' 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 ('8190114')) 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\" = 'CA' 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 ('8190114'))
  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" = 'CA' 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 ('8190114'))
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 LAX04LA009Accident · Minor injuriesLimited investigationFinal reportLuscombe 8F · Murrieta, CAThe pilot's inadequate evaluation of the weather which resulted in VFR flight into IMC, and his failure to maintain terrain clearance. Fog and rising terrain were contributing factors.Oct 11, 2003 · N1918B · Substantial damage NTSB LAX88LA139Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Lompoc, CADuring the landing roll with a crosswind of 15-20 knots, the pilot lost control of the aircraft, collided with the terrain and, approximately 200 yards off the runway, the aircraft nosed over.Mar 27, 1988 · N1374B · Substantial damage NTSB LAX86LA096Accident · Minor injuriesLimited investigationFinal reportLuscombe 8F · Half Moon Bay, CAThe plt reported that on approach he was 'a little high & hot' for the 5000-FT-long rwy. He said that at midfield he was 100 ft. AGL & he decided to go around. Upon applying power only 700 RPM was obtained, so he then attempted to land the acft at the end of…Jan 24, 1986 · N1507B · Substantial damage NTSB LAX70D0066Accident · No injuriesClosedLuscombe 8F · San Frnando, CAAug 10, 1969 · N1372B · Substantial damage NTSB LAX68F0212Accident · No injuriesClosedLuscombe 8F · Santa Monic, CANov 30, 1967 · N1867B · Substantial damage NTSB LAX68F0003Accident · Minor injuriesClosedLuscombe 8F · Chino, CAJun 5, 1967 · N2137B · Destroyed NTSB LAX67F0317Accident · No injuriesClosedLuscombe 8F · Santa Ynez, CAFeb 16, 1967 · N1920B · Substantial damage NTSB LAX66D0101Accident · No injuriesClosedLuscombe 8F · Torrance, CAAug 10, 1965 · N1453B · Substantial damage NTSB UNK64X1461Accident · Serious injuriesClosedLuscombe 8F · Calistoga, CAApr 25, 1964 · N1879B · Destroyed