Skip to content

NTSB investigations: Luscombe 8A, IN

20 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" = 'IN' 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\" = 'IN' 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" = 'IN' 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 CEN21LA400Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8A · Fort Wayne, INThe total loss of engine power after takeoff due to the formation of carburetor ice while on the ground and the pilot’s failure to apply carburetor heat immediately before takeoff.Sep 4, 2021 · N2071K · Substantial damage NTSB GAA16CA307Accident · No injuriesData collectionFinal reportLuscombe 8 · Valparaiso, INThe pilot's improper descent rate during landing, which resulted in a bounced landing, failure of the tailwheel suspension leaf spring, a ground loop, and substantial damage to the left wing.Jun 12, 2016 · N2850K · Substantial damage NTSB CEN11CA661Accident · No injuriesData collectionFinal reportLuscombe 8A · Huntington, INThe failure of the right main landing gear strut due to internal corrosion.Sep 10, 2011 · N71212 · Substantial damage NTSB CHI07CA156Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Elwood, INThe commercial pilot's failure to maintain adequate altitude and airspeed which resulted in the airplane mushing into the terrain during the simulated forced landing along with the CFI's failure to adequately supervise the commercial pilot's actions.May 25, 2007 · N2897K · Substantial damage NTSB CHI94LA008Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Bristol, INthe pilot's abrupt maneuver (intentional swerve) and main gear collapse during the landing roll on a short grass strip.Oct 7, 1993 · N71492 · Substantial damage NTSB CHI85LA313Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Valparaiso, INThe acft nosed over during landing. The plt said that he made a wheel lndg and after the acft slowed to 20 mph the tail lifted and the acft nosed over.Jul 25, 1985 · N2071K · Substantial damage NTSB CHI84LA296Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Madison, INThe pilot stated after the accident that he performed a preflight inspection of the acft and did an engine run-up before takeoff. During climbout, at an altitude of 150 feet the plt experienced an engine failure. An emergency landing was made in trees. The…Jul 16, 1984 · N1187B · Substantial damage NTSB CHI79DEX42Accident · No injuriesClosedLuscombe 8A · Brownsburg, INJul 15, 1979 · N1364K · Substantial damage NTSB CHI79DEX11Accident · No injuriesClosedLuscombe 8A · Greenwood, INNov 30, 1978 · N71897 · Substantial damage NTSB CHI72FET30Accident · No injuriesClosedLuscombe 8A · Auburn, INMay 29, 1972 · N71898 · Substantial damage NTSB CHI72DET20Accident · No injuriesClosedLuscombe 8A · Auburn, INMar 19, 1972 · N71823 · Substantial damage NTSB CHI72FET08Accident · Minor injuriesClosedLuscombe 8A · Elkhart, INSep 16, 1971 · N71375 · Substantial damage NTSB CHI70DBA13Accident · Minor injuriesClosedLuscombe 8A · Anderson, INMar 7, 1970 · N45811 · Substantial damage NTSB CHI70DBA07Accident · No injuriesClosedLuscombe 8A · Sullivan, INFeb 14, 1970 · N28543 · Substantial damage NTSB CHI70F0058Accident · No injuriesClosedLuscombe 8E · Southport, INJun 17, 1969 · N39013 · Substantial damage NTSB CHI68F0641Accident · No injuriesClosedLuscombe 8A · Gary, INMar 10, 1968 · N71435 · Substantial damage NTSB CHI68F0337Accident · No injuriesClosedLuscombe 8A · Muncie, INSep 23, 1967 · N2136K · Substantial damage NTSB CHI68D0250Accident · No injuriesClosedLuscombe 8A · Richmond, INSep 5, 1967 · N77841 · Substantial damage NTSB CHI66F0405Accident · No injuriesClosedLuscombe 8A · Kempton, INNov 7, 1965 · N77826 · Substantial damage NTSB UNK65X0704Accident · No injuriesClosedLuscombe 8A · Elkhart, INNov 14, 1964 · N45801 · Substantial damage