Skip to content

NTSB investigations: Luscombe 8A, CO

23 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" = 'CO' 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\" = 'CO' 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" = 'CO' 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 CEN09CA001Accident · No injuriesData collectionFinal reportLuscombe 8A · Greeley, COThe pilot's failure to maintain directional control during the landing roll resulting in a ground loop. Contributing to the accident was the lack of remedial action from the flight instructor.Oct 3, 2008 · N25342 · Substantial damage NTSB FTW94LA313Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Byers, COFailure by the pilot to maintain a proper descent rate during approach to landing. A factor was lack of experience in make, model, and type of aircraft.Sep 24, 1994 · N71245 · Substantial damage NTSB DEN91LA115Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Parker, COPhysical impairment of the pilot in command for unknown reasons.Aug 17, 1991 · N2253K · Substantial damage NTSB DEN86LA186Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Salida, COAccording to the plt, upon entering the mountain pass, the acft he was piloting encountered downdrafts from which he was unable to recover. The plt stated he bled off airspeed until contact with the trees. A local flt instructor who witnessed the accident…Jul 9, 1986 · N1272K · Substantial damage NTSB DEN83LA004Accident · No injuriesLimited investigationFinal reportLuscombe 8A · La Junta, COThe student pilot elected to practice touch-and-go landings on runway 12. He reported that after landing, he began to set the trim and prepare to takeoff, when the tail popped up and he could hear the wind whistling. Reportedly, he applied full power, but the…Oct 7, 1982 · N2935K · Substantial damage NTSB DEN81FTE63Accident · Minor injuriesClosedLuscombe 8A · Byers, COAug 13, 1981 · N77810 · Substantial damage NTSB DEN77DTE65Accident · No injuriesClosedLuscombe 8E · Colorado Sprgs, COJul 10, 1977 · N1130B · Substantial damage NTSB DEN77FTE54Accident · No injuriesClosedLusgombe 8A · Littleton, COJun 4, 1977 · N45779 · Substantial damage NTSB DEN76AD045Accident · 2 fatalClosedLuscombe 8A · Atwood, COMar 27, 1976 · N1004K · Destroyed NTSB DEN74DTE90Accident · Serious injuriesClosedLuscombe 8A · Grant, COJun 23, 1974 · N77883 · Substantial damage NTSB DEN73FTE86Accident · No injuriesClosedLuscombe 8A · Boulder, COJun 11, 1973 · N71680 · Substantial damage NTSB DEN73DTE07Accident · No injuriesClosedLuscombe 8A · Canon City, COJul 14, 1972 · N2611K · Substantial damage NTSB DEN73DTE03Accident · No injuriesClosedLuscombe 8A · Englewood, COJul 8, 1972 · N2010B · Substantial damage NTSB DEN70DXD41Accident · No injuriesClosedLuscombe 8A · Littleton, COMay 23, 1970 · N71245 · Substantial damage NTSB DEN70FXD02Accident · No injuriesClosedLuscombe 8A · Englewood, COJan 24, 1970 · N71245 · Substantial damage NTSB DEN70D0129Accident · No injuriesClosedLuscombe 8A · Aurora, CONov 9, 1969 · N1220K · 2 aircraft · Substantial damage NTSB DEN69F0206Accident · No injuriesClosedLuscombe 8A · Sedalia, COMar 15, 1969 · N1993B · Substantial damage NTSB DEN67D0174Accident · Minor injuriesClosedLuscombe 8A · Greeley, CODec 1, 1966 · N77831 · Substantial damage NTSB DEN67F0102Accident · No injuriesClosedLuscombe 8A · Littleton, COAug 28, 1966 · N1095K · Substantial damage NTSB DEN66F0037Accident · No injuriesClosedLuscombe 8A · Akron, COJun 15, 1966 · N1434B · Substantial damage NTSB DEN66F0113Accident · Minor injuriesClosedLuscombe 8A · Greely, COAug 25, 1965 · N45709 · Substantial damage NTSB UNK64X3301Accident · No injuriesClosedLuscombe 8E · Colo Springs, COAug 9, 1964 · N2944K · Substantial damage NTSB UNK64X1089Accident · No injuriesClosedLuscombe 8A · Littleton, COMar 29, 1964 · N25291 · Substantial damage