Skip to content

NTSB investigations: Luscombe 8A, PA

25 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" = 'PA' 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\" = 'PA' 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" = 'PA' 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 ERA22LA289Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Palmyra, PAThe pilot’s failure to maintain a proper glide path to the runway.Jun 25, 2022 · N1476K · Substantial damage NTSB GAA20CA090Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Brogue, PAThe pilot's failure to see and avoid wires during approach to landing.Nov 19, 2019 · N71707 · Substantial damage NTSB GAA16CA248Accident · No injuriesData collectionFinal reportLuscombe 8 · Blue Bell, PAThe pilot's failure to maintain directional control during the takeoff roll and the flight instructor's delayed remedial action, which resulted in runway excursion, and collision with a ditch.May 19, 2016 · N62925 · Substantial damage NTSB ERA12CA269Accident · No injuriesData collectionFinal reportLuscombe 8A · Pittsburgh, PAThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.Apr 3, 2012 · N71479 · Substantial damage NTSB NYC96LA030Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Kutztown, PAthe pilot's improper use of brakes during the landing roll resulting in the airplane nosing over.Nov 25, 1995 · N1109K · Substantial damage NTSB NYC88LA228Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Doylestown, PAThe CFI and student plt took off from a 2330 ft turf rwy. Witnesses said the wind was calm and it was hot. The pilots both said that everything seemed normal until the acft reached about 200 ft AGL at which time they lost lift due to either a power loss or…Aug 24, 1988 · N1203K · Destroyed NTSB NYC81FGM03Accident · No injuriesClosedLuscombe 8A · Belle Vernon, PAOct 27, 1980 · N1190K · Substantial damage NTSB NYC80FA046Accident · 1 fatalClosedLuscombe 8A · Fairview, PAJun 16, 1980 · N71667 · Destroyed NTSB NYC79FA067Accident · 1 fatalClosedLuscombe 8A · Clarion, PAJul 28, 1979 · N1159B · Destroyed NTSB NYC79FGM32Accident · Minor injuriesClosedLuscombe 8A · Albion, PAJul 8, 1979 · N45922 · Substantial damage NTSB NYC77FGM11Accident · No injuriesClosedLuscombe 8A · Slippery Rock, PAJan 13, 1977 · N2907K · Substantial damage NTSB NYC76FHA33Accident · No injuriesClosedLuscombe 8A · Skippack, PAMay 17, 1976 · N77832 · Substantial damage NTSB NYC75FGM47Accident · Minor injuriesClosedLuscombe 8A · Leechburg, PAJun 21, 1975 · N1544K · Substantial damage NTSB NYC70FGM02Accident · No injuriesClosedLuscombe 8A · Bridgeville, PAJan 13, 1970 · N45596 · Substantial damage NTSB NYC69D0397Accident · No injuriesClosedLuscombe 8E · Wellsboro, PAApr 13, 1969 · N1976B · Substantial damage NTSB NYC68A0040Accident · 2 fatalClosedLuscombe 8A · Morgan, PASep 2, 1967 · N77955 · Destroyed NTSB NYC67F0702Accident · Minor injuriesClosedLuscombe 8A · Monroeville, PAJun 6, 1967 · N71666 · Substantial damage NTSB NYC67F0060Accident · Minor injuriesClosedLuscombe 8A · Welsh Run, PAJul 5, 1966 · N71666 · Substantial damage NTSB NYC66F0567Accident · No injuriesClosedLuscombe 8A · Tarentum, PAFeb 20, 1966 · N45825 · Substantial damage NTSB NYC66F0165Accident · No injuriesClosedLuscombe 8A · Dallastown, PAAug 8, 1965 · N1225B · Substantial damage NTSB NYC65F0022Accident · No injuriesClosedLuscombe 8A · Selinsgrove, PAFeb 13, 1965 · N1094K · Substantial damage NTSB NYC65F0003Accident · No injuriesClosedLuscombe 8A · West Chester, PAJan 21, 1965 · N1129B · Substantial damage NTSB UNK64X2023Accident · No injuriesClosedLuscombe 8A · Shippensburg, PAMay 30, 1964 · N45480 · Destroyed NTSB UNK64X1623Accident · No injuriesClosedLuscombe 8A · Carmichaels, PAMay 5, 1964 · N71932 · Substantial damage NTSB UNK64X0675Accident · No injuriesClosedLuscombe 8A · Allentown, PAFeb 23, 1964 · N22096 · Substantial damage