NTSB investigations: Luscombe 8F, ID

6 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

19702026

NTSB investigations: Luscombe 8F, ID per year, 1970–2026: 6 cases
1970	1
1974	1
1981	1
1997	1
1999	1
2011	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" = 'ID' 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\" = 'ID' 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" = 'ID' 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 WPR11CA271Accident · No injuriesData collectionFinal reportLuscombe 8F · McCall, IDThe pilot's failure to maintain adequate airspeed that resulted in a stall/mush. Contributing to the accident was the pilot's failure to maintain an adequate spacing from the aircraft ahead of him.Jun 21, 2011 · N1459B · Substantial damage NTSB SEA99LA096Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Nampa, IDDirectional control was not maintained. Diverted attention was a factor.Jun 26, 1999 · N1895B · Substantial damage NTSB SEA98LA010Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Boise, IDThe student pilot's failure to maintain directional control due to excessive taxispeed. Pressure perceived by the student pilot to expedite clearing the runway after landing in order to facilitate an aircraft departure was a contributing factor.Nov 4, 1997 · N1895B · Substantial damage NTSB SEA82DYA02Accident · Minor injuriesClosedLuscombe 8F · Howe, IDOct 15, 1981 · N9018Y · Substantial damage NTSB SEA74DYA22Accident · No injuriesClosedLuscombe 8F · Cascade, IDFeb 9, 1974 · N1391B · Substantial damage NTSB SEA71DWG26Accident · No injuriesClosedLuscombe 8F · Lewiston, IDOct 3, 1970 · N831B · Substantial damage