Fatal NTSB investigations: Luscombe 8C
6 cases on aircraft the registry lists as Luscombe 8C. 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 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1983 | 1 |
| 1986 | 1 |
| 2009 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8190108'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8190108'))
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 CEN09LA466Accident · 1 fatalLimited investigationFinal reportLuscombe 8C · Mount Carmel, ILThe reason for this accident was not determined.NTSB ATL86FA242Accident · 1 fatalField investigationFinal reportLuscombe 8C · Lavonia, GAThe pilot had been diagnosed as having a brain tumor and was taking 300 mg of dilantin daily for the giloma. He suffered a grand mal seizure about two months before the accident. His mother stated that the pilot told her during a telephone conversation that…NTSB FTW83FA407Accident · 2 fatalField investigationFinal reportLuscombe 8C · Post, TXThe acft had impacted in a steep right wing down, nose low attitude. No preimpact, mechanical malfunction or failure was found. The plt's blood alcohol level was 0.054%. There were no entries in the plt's log book for previous flts in Luscombe acft.NTSB MIA68A0044Accident · 1 fatalClosedLuscombe 8C · Temple Terrac, FLNTSB MIA67A0031Accident · 2 fatalClosedLuscombe 8C · Zephrhills, FLNTSB UNK64X3953Accident · 1 fatalClosedLuscombe 8C · Marquette, WI