NTSB investigations: Luscombe 8E, PA

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

19642026

NTSB investigations: Luscombe 8E, PA per year, 1964–2026: 8 cases
1964	1
1966	2
1968	1
1970	1
1971	1
2012	1
2018	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" = 'PA' 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\" = 'PA' 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" = 'PA' 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 GAA18CA456Accident · No injuriesData collectionFinal reportLuscombe 8 · Pottsville, PAThe pilot’s failure to maintain directional control during landing.Jul 30, 2018 · N2022K · Substantial damage NTSB ERA12CA403Accident · No injuriesData collectionFinal reportLuscombe 8E · Selinsgrove, PAThe pilot's failure to maintain airplane control during the takeoff.Jun 9, 2012 · N2052K · Substantial damage NTSB NYC71FGM29Accident · Serious injuriesClosedLuscombe 8E · Dubois, PAJan 31, 1971 · N1808K · Substantial damage NTSB NYC71FHD15Accident · Minor injuriesClosedLuscombe 8E · Phoenixville, PAAug 16, 1970 · N1663K · Substantial damage NTSB NYC69A0004Accident · 2 fatalClosedLuscombe 8E · Sunbury, PAJul 4, 1968 · N2717K · Destroyed NTSB NYC67F0438Accident · No injuriesClosedLuscombe 8E · Aliquippa, PADec 25, 1966 · N2527K · Destroyed NTSB NYC67D0044Accident · Minor injuriesClosedLuscombe 8E · Matamoras, PAJun 21, 1966 · N77944 · Substantial damage NTSB UNK64X4220Accident · No injuriesClosedLuscombe 8E · Butler, PASep 30, 1964 · N2527K · Substantial damage