Skip to content

NTSB investigations: Luscombe 8A, GA

20 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

19652026

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" = 'GA' 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\" = 'GA' 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" = 'GA' 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 ERA12FA017Accident · 1 fatalField investigationFinal reportLuscombe 8A · Dixie, GAMaintenance personnel’s improper installation of the No. 2 cylinder’s connecting rod, which resulted in the disconnection of the rod and a subsequent loss of engine power.Oct 8, 2011 · N41907 · Substantial damage NTSB ERA10LA164Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Savannah, GAThe pilot's failure to maintain airspeed and inadvertent stall after takeoff.Mar 5, 2010 · N45976 · Substantial damage NTSB ERA10LA121Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Madison, GAThe pilot’s failure to maintain directional control while landing with a tailwind.Jan 19, 2010 · N2750K · Substantial damage NTSB ATL01FA082Accident · 2 fatalField investigationFinal reportLuscombe 8A · Resaca, GAThe certificated flight instructor's failure to maintain control of the airplane during a turning maneuver, which resulted in an inadvertent stall and subsequent collision with terrain. A factor was the loading of the airplane over maximum gross weight.Jul 12, 2001 · N71917 · Substantial damage NTSB ATL95LA125Accident · No injuriesLimited investigationFinal reportLuscombe 8A/E · Williamson, GAThe pilot in command's failure to compensate for wind conditions which resulted in a failure to maintain control of the aircraft when a windshear was encountered.Jul 2, 1995 · N2853K · Substantial damage NTSB ATL86LA213Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Ringgold, GAThe pilot reported he attempted to make a 180 degree turn because he realized he was getting too close to an airport while on a cross country flight. A highway patrolman said the pilot told him he became disoriented during the turn, cut the power to land, and…Jul 26, 1986 · N71713 · Substantial damage NTSB ATL86LA091Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Hampton, GADuring landing roll the pilot was unable to keep the tailwheel on the ground and the aircraft nosed over. Post crash examination of the wreckage disclosed that the brake pads were worn down to the rivets.Mar 8, 1986 · N71633 · Substantial damage NTSB ATL85LA104Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Suches, GAAfter takeoff in mountainous terrain pilot used shallow climb on course. Pilot stated he failed to climb to a suitable altitude. When first ridge was cleared a downdraft was encountered. Pilot made 180 degree turn but was unable to climb above terrain.Feb 28, 1985 · N71877 · Substantial damage NTSB MIA77DKG26Accident · No injuriesClosedLuscombe 8A · Dalton, GAApr 27, 1977 · N1448K · Substantial damage NTSB MIA74DKG53Accident · No injuriesClosedLuscombe 8A · Valdosta, GAFeb 23, 1974 · N71648 · Substantial damage NTSB MIA74FKG83Accident · No injuriesClosedLuscombe 8A · Fairburn, GAJun 18, 1973 · N2329K · Substantial damage NTSB MIA73DKG32Accident · No injuriesClosedLuscombe 8A · Macon, GAJul 11, 1972 · N71990 · Substantial damage NTSB MIA72FKH15Accident · No injuriesClosedLuscomb 8A · Stone Mountain, GAJun 13, 1972 · N7789K · Substantial damage NTSB MIA72AM119Accident · 1 fatalClosedLuscombe 8A · Nashville, GAMay 9, 1972 · N28901 · Destroyed NTSB MIA72FKG79Accident · Serious injuriesClosedLuscombe 8A · St Simons Is, GAMar 12, 1972 · N45557 · Substantial damage NTSB MIA71FKG24Accident · No injuriesClosedLuscombe 8A · Perry, GAAug 21, 1970 · N45452 · Substantial damage NTSB MIA70AM064Accident · 1 fatalClosedLuscombe 8A · Brookfield, GAFeb 2, 1970 · N45505 · Destroyed NTSB MIA70F0093Accident · No injuriesClosedLuscombe 8A · Lithonia, GAMay 4, 1969 · N2345K · Substantial damage NTSB MIA66F0483Accident · Serious injuriesClosedLuscombe 8A · Griffin, GAMar 19, 1966 · N2160B · Substantial damage NTSB MIA66F0172Accident · No injuriesClosedLuscombe 8A · Macon, GAAug 20, 1965 · N1706K · Substantial damage