NTSB investigations: Luscombe 8A, AR
12 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
| 1971 | 3 |
|---|---|
| 1973 | 1 |
| 1976 | 5 |
| 1981 | 1 |
| 1982 | 1 |
| 2022 | 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\" = 'AR' 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" = 'AR' 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 CEN22LA174Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Paragould, ARThe student pilot’s failure to maintain directional control during landing which resulted in a ground loop.NTSB FTW82FPG13Accident · 1 fatalFinal reportLuscombe 8A · Parkin, ARThe pilot departed presidents isle, TN with about 1/4 tank of fuel (3.5 gal) and proceeded en route with a planned stop at wynne, AR for fuel. Prior to reaching wynne, heavy rain was encountered and a landing was made at a private airport near Parkin, AR. The…NTSB FTW81FA123Accident · 2 fatalClosedLuscombe 8A · N Little Rock, ARNTSB FTW76DPH05Accident · No injuriesClosedLuscombe 8A · Little Rock, ARNTSB FTW76FPG84Accident · No injuriesClosedLuscombe 8A · Mountain Home, ARNTSB FTW76AF098Accident · 2 fatalClosedLuscombe 8A · Cabot, ARNTSB FTW76DPG64Accident · No injuriesClosedLuscombe 8A · Van Buren, ARNTSB FTW76FPG43Accident · No injuriesClosedLuscombe 8A · Conway, ARNTSB FTW74FPG21Accident · No injuriesClosedLuscombe 8A · Van Buren, ARNTSB FTW72DPG31Accident · No injuriesClosedLuscombe 8A · Humnoke, ARNTSB FTW71FPG53Accident · No injuriesClosedLuscomb 8A · Hackett, ARNTSB FTW71FPG39Accident · Serious injuriesClosedLuscombe 8A · Hunter, AR