Final NTSB investigations: Luscombe 8B
9 cases on aircraft the registry lists as Luscombe 8B. 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
| 1968 | 1 |
|---|---|
| 1969 | 1 |
| 1975 | 2 |
| 1979 | 1 |
| 1986 | 2 |
| 2014 | 1 |
| 2016 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8190106'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8190106'))
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 GAA17CA021Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Huntingburg, INThe pilot’s delayed crosswind correction during the landing roll with a gusting left crosswind, which resulted in the airplane weathervaning and nosing over.NTSB CEN14CA282Accident · No injuriesData collectionFinal reportLuscombe 8B · Galion, OHThe pilot's misapplication of brakes after landing, which resulted in the airplane nosing over.NTSB CHI86FA120Accident · 2 fatalField investigationFinal reportLuscombe 8B · Pittsford, MIThe pilot overshot final approach due to a 10-15 kt tailwind on base leg. According to a pilot friend on the ground he put the acft into a 60 degree bank to in an attempt to realign himself with the final approach course. During this steep turn the aircraft…NTSB NYC86LA063Accident · No injuriesLimited investigationFinal reportLuscombe 8B · Turin, NYThe personal flight from oswego, NY to Turin, NY was uneventful and without problems. However while landing in soft snow, the right ski dug into the soft snow. The landing gear failed and the aircraft nosed over onto its back and was substantially damaged.…NTSB MKC79DCG30Accident · No injuriesClosedLuscombe 8A · Trenton, MONTSB FTW76DPJ15Accident · No injuriesClosedLuscombe 8A · Waukomis, OKNTSB SEA75DYC30Accident · No injuriesClosedLuscombe 8A · The Dalles, ORNTSB NYC70F0078Accident · Serious injuriesClosedLuscombe 8B · Nisbet, PANTSB CHI68F0738Accident · Serious injuriesClosedLuscombe 8B · Wadsworth, OH