NTSB investigations: Luscombe 8E, FL

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, FL per year, 1964–2026: 8 cases
1964	1
1965	1
1966	1
1969	1
1971	1
1974	1
1994	1
2021	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" = 'FL' 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\" = 'FL' 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" = 'FL' 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 ERA21FA142Accident · 1 fatalClass 3 · FieldFinal reportLuscombe 8E · Jupiter, FLThe pilot’s exceedance of the airplane’s critical angle of attack, which led to an aerodynamic stall and loss of control. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane, resulting in an unsecured engine cowl that…Feb 28, 2021 · N2960K · Substantial damage NTSB MIA94LA140Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Deland, FLCorrosion and subsequent failure of the left main landing gear strut.May 14, 1994 · N71128 · Substantial damage NTSB MIA75DLD42Accident · No injuriesClosedLuscombe 8E · Brandon, FLNov 24, 1974 · N2721K · Substantial damage NTSB MIA72FLA10Accident · No injuriesClosedLuscombe 8E · Jacksonville, FLSep 6, 1971 · N1520B · Substantial damage NTSB MIA70F0263Accident · Minor injuriesClosedLuscombe 8E · Largo, FLDec 11, 1969 · N1399B · Substantial damage NTSB MIA66F0575Accident · No injuriesClosedLuscombe 8E · Eau Gallie, FLMay 15, 1966 · N1915K · Substantial damage NTSB MIA66F0140Accident · No injuriesClosedLuscombe 8E · Miami, FLJul 13, 1965 · N1662K · Destroyed NTSB UNK64X3559Accident · Minor injuriesClosedLuscombe 8E · Orlando, FLAug 23, 1964 · N2480K · Substantial damage