NTSB investigations: Luscombe 8A, KS
16 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1967 | 2 |
| 1968 | 1 |
| 1972 | 2 |
| 1974 | 2 |
| 1977 | 1 |
| 1978 | 1 |
| 1982 | 1 |
| 1990 | 1 |
| 2013 | 1 |
| 2019 | 1 |
| 2021 | 1 |
Where
Open the mapLatest cases
Query with SQL
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\" = 'KS' 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" = 'KS' 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" DESCRun 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 CEN22LA079Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Ellinwood, KSThe pilot's improper brake application during the landing roll, which resulted in a nose-over.NTSB CEN20LA029Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8A · Baldwin City, KSThe pilot's failure to maintain directional control during takeoff, and the flight instructor's delayed remedial action, which resulted in a runway excursion and nose over.NTSB CEN13CA453Accident · No injuriesData collectionFinal reportLuscombe 8A · Ellinwood, KSThe pilot failed to maintain directional control during takeoff.NTSB CHI91LA005Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Ashland, KSThe pilot-in-command's exceeding the proper climb rate of the aircraft, and his not maintaining control of the aircraft to prevent a stall.NTSB MKC82FCQ09Accident · 2 fatalFinal reportLuscombe 8A · Fredonia, KSThe aircraft crashed after taking off on a test flight. A witness reported that the aircraft was in a steep angle of climb, and the nose pitched down as the pilot was making a left turn. The witness reported that the pilot had been adjusting the magnetos…NTSB MKC78FCQ39Accident · Serious injuriesClosedLuscombe 8A · Baxter Springs, KSNTSB MKC77DCQ35Accident · No injuriesClosedLuscombe 8A · Colby, KSNTSB MKC74FCQ45Accident · Minor injuriesClosedLuscombe 8A · Furley, KSNTSB MKC74DCQ33Accident · No injuriesClosedLuscombe 8A · St George, KSNTSB MKC72AK059Accident · 1 fatalClosedLuscombe 8A · Council Grve, KSNTSB MKC72FCQ46Accident · No injuriesClosedLuscombe 8A · Hutchinson, KSNTSB MKC69D0206Accident · Minor injuriesClosedLuscombe 8A · Bonner Sprgs, KSNTSB MKC68A0040Accident · 1 fatalClosedLuscombe 8A · Lyons, KSNTSB MKC68D0218Accident · No injuriesClosedLuscombe 8A · Atwood, KSNTSB MKC66D0310Accident · No injuriesClosedLuscombe 8A · Coffeyville, KSNTSB UNK64X0152Accident · No injuriesClosedLuscombe 8A · Bonner Sprgs, KS