NTSB investigations: Luscombe 8A
9 cases on aircraft the registry lists as Luscombe 8A, where the sequence of events included Landing gear collapse. 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.
Cases per year
| 2009 | 2 |
|---|---|
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2016 | 1 |
| 2018 | 2 |
| 2024 | 1 |
Where
Open the mapLatest cases
Query with SQL
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8190104', '8190111')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '094' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8190104', '8190111')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '094' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ERA24LA396Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Elyria, OHThe pilot's failure to maintain directional control during the landing roll with a direct crosswind.NTSB GAA18CA244Accident · No injuriesData collectionFinal reportLuscombe 8 · Eunice, LAThe pilot’s failure to maintain clearance from a tree while on approach to land.NTSB GAA18CA205Accident · No injuriesData collectionFinal reportLuscombe 8 · Vernon, TXThe pilot’s failure to maintain directional control during landingNTSB GAA16CA269Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Midland, TXThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a ground-loop, main landing gear collapse and collision with terrain.NTSB ERA12CA140Accident · No injuriesData collectionFinal reportLuscombe 8A · Umatilla, FLA failure of the left main landing gear due to a preexisting crack and corrosion, which resulted in a loss of directional control during landing.NTSB CEN11CA661Accident · No injuriesData collectionFinal reportLuscombe 8A · Huntington, INThe failure of the right main landing gear strut due to internal corrosion.NTSB ERA10LA121Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Madison, GAThe pilot’s failure to maintain directional control while landing with a tailwind.NTSB ERA09LA520Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Arcadia, FLThe pilot's bounced takeoff roll, which resulted in a collapsed landing gear. Contributing to the accident was the airplane's overweight condition.NTSB WPR09LA390Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Eatonville, WAThe loss of engine power due to fuel starvation as a result of the pilot's inadequate in-flight fuel management. Contributing to the accident was the airplane's lack of an interconnected fuel vent system.