Skip to content

NTSB investigations: Luscombe 8A, AZ

30 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" = 'AZ' 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\" = 'AZ' 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" = 'AZ' 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 GAA19CA568Accident · No injuriesData collectionFinal reportLuscombe 8 · Prescott, AZThe pilot's loss of directional control and subsequent overapplication of rudder pedal, which resulted in a runway excursion and the right wing striking the ground.Aug 30, 2019 · N25100 · Substantial damage NTSB GAA19CA127Accident · Serious injuriesData collectionFinal reportLuscombe 8 · Casa Grande, AZThe pilot's failure to maintain yaw control and his exceedance of the airplane’s critical angle of attack during an aborted landing, which resulted in an aerodynamic stall.Jan 5, 2019 · N71155 · Substantial damage NTSB GAA18CA338Accident · No injuriesData collectionFinal reportLuscombe 8 · Phoenix, AZThe pilot’s improper landing flare and subsequent failure to maintain directional control during landing.Jun 12, 2018 · N2094B · Substantial damage NTSB WPR16LA017Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Prescott, AZThe pilot's failure to maintain directional control during landing, and his inability to recover due to a malfunction of the tailwheel.Oct 24, 2015 · N25100 · Substantial damage NTSB WPR14CA266Accident · No injuriesData collectionFinal reportLuscombe 8A · Tucson, AZThe student pilot's use of excessive brakes during taxi, which resulted in a loss of aircraft control.Jun 23, 2014 · N77917 · Substantial damage NTSB LAX05CA256Accident · No injuriesData collectionFinal reportLuscombe 8A · Benson, AZthe non-certificated pilot's failure to maintain directional control during the landing roll.Aug 2, 2005 · N71780 · Substantial damage NTSB LAX90LA295Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Tucson, AZThe pilot to maintain proper pitch attitude and airspeed to avoid an aerodynamic stall.Aug 19, 1990 · N71330 · Substantial damage NTSB LAX84LA059Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Casa Grande, AZDuring a local flt, the acft collide with terrain while the aircrew were performing low alt maneuvers. One of the occupants was an instructor plt (CFI) & the other was a private plt. Neither claimed to be the plt in command, but the private plt was the…Nov 12, 1983 · N1186B · Destroyed NTSB LAX84LA018Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Casa Grande, AZThe aircraft was equipped with brakes only on the left side. During a dual instructional flt, the student was landing the acft from the left seat. On the 4th landing, the acft encountered a reported right quartering gust of wind from the rear. The acft veered…Oct 18, 1983 · N2041B · Substantial damage NTSB LAX80DUJ72Accident · No injuriesClosedLuscombe 8A · Chandler, AZJun 25, 1980 · N28494 · Substantial damage NTSB LAX77FUJ79Accident · No injuriesClosedLuscombe 8A · Scottsdale, AZAug 9, 1977 · N77881 · Substantial damage NTSB LAX77DUJ51Accident · No injuriesClosedLuscombe 8A · Glendale, AZMay 19, 1977 · N71413 · Substantial damage NTSB LAX76FUJ70Accident · No injuriesClosedLuscombe 8A · Chandler, AZApr 24, 1976 · N1153B · Substantial damage NTSB LAX76DUJ63Accident · No injuriesClosedLuscombe 8A · Mesa, AZFeb 24, 1976 · N45694 · Substantial damage NTSB LAX72DUJ53Accident · No injuriesClosedLuscombe 8A · Mesa, AZSep 20, 1971 · N1153B · Substantial damage NTSB LAX72DUJ06Accident · No injuriesClosedLuscombe 8A · Congress, AZJun 8, 1971 · N20654 · Substantial damage NTSB LAX71DUJ67Accident · No injuriesClosedLuscombe 8A · Marana, AZMar 14, 1971 · N45675 · Substantial damage NTSB LAX71DUJ22Accident · No injuriesClosedLuscombe 8A · Quartzsite, AZApr 26, 1970 · N28488 · Substantial damage NTSB LAX70DUJ18Accident · No injuriesClosedLuscombe 8A · Huachuca Cy, AZMar 3, 1970 · N45675 · Substantial damage NTSB LAX69D0221Accident · No injuriesClosedLuscombe 8A · Willcox, AZOct 21, 1968 · N2146K · Substantial damage NTSB LAX68D0171Accident · No injuriesClosedLuscombe 8A · Dateland, AZOct 8, 1967 · N1186B · Substantial damage NTSB LAX67D0269Accident · No injuriesClosedLuscombe 8A · Sierra Vista, AZFeb 21, 1967 · N45675 · Substantial damage NTSB LAX67F0226Accident · No injuriesClosedLuscombe 8A · Phoenix, AZNov 28, 1966 · N45694 · Substantial damage NTSB LAX67D0108Accident · No injuriesClosedLuscombe 8A · Happy Jack, AZSep 2, 1966 · N45538 · Substantial damage NTSB DEN66D0351Accident · Minor injuriesClosedLuscombe 8A · Mesa, AZMay 8, 1966 · N45738 · Destroyed NTSB DEN66D0250Accident · No injuriesClosedLuscombe 8A · Mesa, AZFeb 23, 1966 · N77881 · Substantial damage NTSB DEN66D0181Accident · Minor injuriesClosedLuscombe 8A · Chandler, AZDec 5, 1965 · N45738 · Substantial damage NTSB UNK64X4123Accident · No injuriesClosedLuscombe 8A · Kingman, AZSep 24, 1964 · N1911B · Substantial damage NTSB UNK64X3681Accident · Minor injuriesClosedLuscombe 8A · Laveen, AZAug 30, 1964 · N25211 · Substantial damage NTSB UNK64X2775Accident · No injuriesClosedLuscombe 8A · Phoenix, AZJul 12, 1964 · N1186B · Substantial damage