Skip to content

NTSB investigations: Luscombe 8A, WI

28 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" = 'WI' 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\" = 'WI' 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" = 'WI' 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 CHI07CA101Accident · No injuriesData collectionFinal reportLuscombe 8A · Chippewa Falls, WIThe pilot intentionally leaving the airplane unoccupied during the engine start, which resulted in the unoccupied airplane traversing into a cornfield. A factor was the rough/uneven cornfield.Apr 15, 2007 · N28428 · Substantial damage NTSB CHI04CA189Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Merrill, WIThe dual student's failure to maintain directional control during the initial climb after takeoff and the flight instructor's delayed remedial action. A contributing factor was that all available runway was not used for takeoff due to the touch-and-go…Jul 21, 2004 · N45628 · Substantial damage NTSB CHI03LA093Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Sturtevant, WIThe student pilot's abrupt liftoff resulting in his failure to maintain adequate airspeed followed by a stall. Also causal was the instructor's inadequate supervision.Mar 30, 2003 · N45799 · Substantial damage NTSB CHI91LA229Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Lake Geneva, WIAircraft control was not maintained by the pilot. Factors related to the accident were a quartering tailwind.Jul 25, 1991 · N28580 · Substantial damage 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…Mar 21, 1987 · N25333 · Substantial damage NTSB CHI83FA016Accident · 1 fatalField investigationFinal reportLuscombe 8A · Delavan, WIThe airport manager stated that the aircraft had been flying for about 45 min when it returned to the airport. He reported that the pilot made a low pass over the runway, as if he was checking the wind for landing. He saw the pilot start to climb and enter a…Oct 15, 1982 · N1094K · Destroyed NTSB CHI81DEP39Accident · No injuriesClosedLuscombe 8A · Egg Harbor, WIJul 19, 1981 · N21996 · Substantial damage NTSB CHI76FEP31Accident · Serious injuriesClosedLuscombe 8A · West Bend, WIMay 24, 1976 · N1037K · Destroyed NTSB CHI76FEP01Accident · Serious injuriesClosedLuscombe 8A · Montello, WIJul 4, 1975 · N77887 · Substantial damage NTSB CHI75FEP46Accident · Minor injuriesClosedLuscombe 8A · Burlington, WIJun 14, 1975 · N45974 · Substantial damage NTSB CHI75DEP48Accident · No injuriesClosedLuscombe 8A · Hales Corners, WIMar 13, 1975 · N2704K · Substantial damage NTSB CHI73FEP59Accident · No injuriesClosedLuscombe 8A · Middleton, WIMay 20, 1973 · N71318 · Substantial damage NTSB CHI73DEP25Accident · No injuriesClosedLuscombe 8A · Waunakee, WISep 22, 1972 · N71318 · Substantial damage NTSB CHI72DEP26Accident · No injuriesClosedLuscombe 8A · Wilmot, WINov 24, 1971 · N45676 · Substantial damage NTSB CHI72FEP21Accident · Serious injuriesClosedLuscombe 8A · Stevens Pt., WINov 10, 1971 · N45431 · Substantial damage NTSB CHI72DEP15Accident · No injuriesClosedLuscombe 8A · Lyons, WISep 11, 1971 · N1323B · Substantial damage NTSB CHI71FDJ13Accident · No injuriesClosedLuscombe 8E · Cottage Grove, WIAug 19, 1970 · N39028 · Substantial damage NTSB CHI70DDJ14Accident · No injuriesClosedLuscombe 8A · Sheboygan Fls, WIMar 28, 1970 · N71170 · Substantial damage NTSB CHI69D0590Accident · No injuriesClosedLuscombe 8A · Hazel Green, WIFeb 15, 1969 · N71467 · Substantial damage NTSB CHI69D0573Accident · No injuriesClosedLuscombe 8A · West Bend, WIFeb 9, 1969 · N72041 · Substantial damage NTSB CHI69D0113Accident · No injuriesClosedLuscombe 8A · Green Bay, WIJul 12, 1968 · N21996 · Substantial damage NTSB CHI68F0414Accident · No injuriesClosedLuscombe 8A · Arlington, WIOct 21, 1967 · N1343B · Substantial damage NTSB CHI67F0565Accident · No injuriesClosedLuscombe 8A · Superior, WIApr 9, 1967 · N25394 · Substantial damage NTSB CHI67D0035Accident · Minor injuriesClosedLuscombe 8A · Montello, WIJul 2, 1966 · N71350 · Destroyed NTSB CHI67D0121Accident · No injuriesClosedLuscombe 8A · Mukwonago, WIJun 19, 1966 · N71157 · Substantial damage NTSB CHI65D0081Accident · No injuriesClosedLuscombe 8A · Janesville, WIFeb 26, 1965 · N37024 · Substantial damage NTSB UNK64X3963Accident · No injuriesClosedLuscombe 8A · Wis Rapids, WISep 13, 1964 · N2704K · Substantial damage NTSB UNK64X2549Accident · No injuriesClosedLuscombe 8A · Cushing, WIJun 28, 1964 · N2943K · Substantial damage