NTSB investigations: Luscombe 8A
9 cases on aircraft the registry lists as Luscombe 8A, where the first occurrence was “Loss of engine power”. 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
| 1982 | 1 |
|---|---|
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1995 | 1 |
| 2001 | 1 |
| 2006 | 1 |
| 2007 | 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 CHI07LA126Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Fruitport, MIThe flight instructor failed to use carburetor heat during takeoff in icing conditions. A factor was the power line pole.NTSB CHI06LA165Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Bowling Green, MOThe loss of engine power due to fatigue fracture of the number two cylinder exhaust valve during initial climb after takeoff. A contributing factor was the unsuitable terrain (cornfield) encountered during the forced landing.NTSB FTW02LA055Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Haltom City, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB ATL96FA006Accident · 2 fatalField investigationFinal reportLuscombe 8E · Picayune, MSa worn left magneto distributor gear, which resulted in a loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall and collision with the ground.NTSB CHI87LA102Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Merrill, WIAircraft lost power on takeoff and plt made a forced landng in a rough field. The left main gear collapsed and substantial damage to the outer two feet of the right wing was sustained. Inspection of the aircraft after the accident did not disclose cause of…NTSB NYC86LA210Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Nantucket, MAThe pilot made a precautionary landing on a beach shortly after takeoff when the engine stopped running. However during engine examination, nothing was found to determine malfunction or failure.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…NTSB SEA85LA179Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Yamhill, ORThe eng ceased operating at aprx 40 ft AGL during initial takeoff climb. Investigation disclosed the acft had been fueled with a mixture of automotive fuel and 80/87 avgas. The acft had sat on the ground for over 4 hrs with a surface tem of 95 degs f. a…NTSB LAX82DA217Accident · Serious injuriesFinal reportLuscombe 8A · Delano, CAThe pilot and his daughter were on a cross-country flight when the engine lost power. During a forced landing approach to a highway, the pilot noticed some powerlines which he went under. He avoided the powerlines, but hit a truck. The crash site was located…