NTSB investigations: Luscombe 8E, IA

8 cases on aircraft the registry lists as Luscombe 8E. 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 8E, IA per year, 1965–2026: 8 cases
1965	1
1967	2
1970	1
1971	1
1972	1
1979	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" = 'IA' 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 ('8190112')) 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\" = 'IA' 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 ('8190112'))
  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" = 'IA' 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 ('8190112'))
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 CHI04LA003Accident · 2 fatalLimited investigationFinal reportLuscombe 8E · Orange City, IAThe pilot's failure to maintain obstacle clearance from the trees while manuevering at a low altitude. A factor was the trees.Oct 3, 2003 · N1909K · Destroyed NTSB MKC79DCD34Accident · No injuriesClosedLuscombe 8E · Oskaloosa, IAAug 28, 1979 · N2518K · Substantial damage NTSB MKC72FCD64Accident · No injuriesClosedLuscombe 8E · Adel, IAMar 25, 1972 · N1306B · Substantial damage NTSB MKC72FCD35Accident · Serious injuriesClosedLuscombe 8E · Osage, IAOct 2, 1971 · N1971K · Destroyed NTSB MKC71DCD15Accident · No injuriesClosedLuscombe 8E · Independence, IAJul 19, 1970 · N2680K · Substantial damage NTSB MKC68D0002Accident · Minor injuriesClosedLuscombe 8E · Grundy Centr, IAMay 31, 1967 · N28612 · Substantial damage NTSB MKC67D0590Accident · No injuriesClosedLuscombe 8E · Creston, IAMay 16, 1967 · N1977K · Substantial damage NTSB MKC65D0138Accident · No injuriesClosedLuscombe 8A · Creston, IAMar 12, 1965 · N1990B · Substantial damage