Skip to content

NTSB investigations: Luscombe 8A, NY

22 cases on aircraft the registry lists as Luscombe 8A. 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

Where

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" = 'NY' 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 ('8190104', '8190111')) 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\" = 'NY' 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 ('8190104', '8190111'))
  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" = 'NY' 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 ('8190104', '8190111'))
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 ERA22LA345Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8A · Ephratah, NYA loss of engine power for undetermined reasons.Jul 30, 2022 · N1358K · Substantial damage NTSB ERA21LA231Accident · Minor injuriesClass 4 · LimitedFinal reportLuscombe 8A · Skaneateles, NYThe pilot’s failure to maintain directional control during the takeoff roll which resulted in a runway excursion and nose-over event.May 24, 2021 · N1331K · Substantial damage NTSB ERA17FA226Accident · 1 fatalField investigationFinal reportLuscombe 8 · Remsen, NYThe pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall at an altitude too low for him to recover.Jul 4, 2017 · N45851 · Substantial damage NTSB NYC89LA170Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Ithaca, NYA loss of control on takeoff due to improper takeoff techniques.Jul 18, 1989 · N71793 · Substantial damage NTSB NYC85LA197Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Coventryville, NYDuring a local flt over Coventryville, NY, the plt decided to overfly and observe a building. The plt made one pass and was about to make another when the eng began to lose pwr. While planning to land in a nearby fld, the eng regained pwr and the plt…Jul 28, 1985 · N45564 · Substantial damage NTSB NYC78DFJ04Accident · No injuriesClosedLuscombe 8A · La Fayette, NYOct 30, 1977 · N515SF · Substantial damage NTSB NYC75FFA31Accident · Minor injuriesClosedLuscombe 8A · Duanesburg, NYMar 15, 1975 · N71790 · Substantial damage NTSB NYC75DFA15Accident · No injuriesClosedLuscombe 8A · Wurtsboro, NYSep 30, 1974 · N2033B · Substantial damage NTSB NYC74FFJ16Accident · No injuriesClosedLuscombe 8A · Leroy, NYOct 24, 1973 · N77892 · Substantial damage NTSB NYC73DFA07Accident · No injuriesClosedLuscombe 8A · Cooperstown, NYJul 31, 1972 · N71738 · Substantial damage NTSB NYC71FHJ23Accident · No injuriesClosedLuscombe 8E · Amityville, NYMar 7, 1971 · N72039 · Substantial damage NTSB NYC71DFA24Accident · No injuriesClosedLuscombe 8A · Plattsburgh, NYOct 25, 1970 · N77894 · Substantial damage NTSB NYC70A0004Accident · 1 fatalClosedLuscombe 8A · Skaneateles, NYJul 4, 1969 · N45758 · Destroyed NTSB NYC69D0247Accident · No injuriesClosedLuscombe 8A · Glens Falls, NYOct 13, 1968 · N22094 · Substantial damage NTSB NYC69F0151Accident · Minor injuriesClosedLuscombe 8A · Patchogue, NYAug 10, 1968 · N1939B · Substantial damage NTSB NYC67D0238Accident · No injuriesClosedLuscombe 8A · Spring Valley, NYSep 2, 1966 · N71280 · Substantial damage NTSB NYC67D0164Accident · No injuriesClosedLuscombe 8A · Franklinville, NYJul 31, 1966 · N1936B · Substantial damage NTSB NYC66F0101Accident · No injuriesClosedLuscombe 8A · Tupper Lake, NYAug 1, 1965 · N77861 · Substantial damage NTSB NYC65A0136Accident · 2 fatalClosedLuscombe 8A · Fire Isld Pine, NYMay 4, 1965 · N45955 · Destroyed NTSB NYC65F0218Accident · No injuriesClosedLuscombe 8A · Ithaca, NYApr 24, 1965 · N71465 · Substantial damage NTSB UNK64X0932Accident · Serious injuriesClosedLuscombe 8A · Bronx, NYMar 15, 1964 · N71137 · Destroyed NTSB UNK64X0452Accident · No injuriesClosedLuscombe 8A · Poughkeepsie, NYFeb 3, 1964 · N2367K · Substantial damage