NTSB investigations: Luscombe 8E
6 cases on aircraft the registry lists as Luscombe 8E, where the first occurrence was “Nose over”. 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
| 1984 | 1 |
|---|---|
| 1992 | 1 |
| 1994 | 1 |
| 2001 | 2 |
| 2004 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8190112')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 300))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8190112')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 300))
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 CHI04CA153Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Joliet, ILThe pilot's selection of unsuitable terrain for takeoff and the subsequent failure to maintain aircraft control during the encounter with the standing water. Contributing factors were the standing water and the soft runway condition.NTSB IAD02LA010Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Millbrook, NYpilot's inadvertent activation of the right brake during landing roll-out , which caused the airplane to nose over. A factor was the crosswind.NTSB CHI02LA017Accident · No injuriesLimited investigationFinal reportLuscombe LL-8-E · Bellaire, MIthe unsuitable terrain for landing selected by the pilot. A factor was the soft terrain.NTSB CHI94LA285Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Hettinger, NDthe pilot's improper use of the wheel brakes.NTSB BFO92LA147Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Rochester, MAThe pilot's abrupt application of the brakes which resulted in the airplane nosing over.NTSB ANC84LA111Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Seldovia, AKThe acft nosed over during landing on a 2600 ft gravel rwy nestled in the hills with variable winds. The plt had temporarily traded acft for this trip and had not flown this type of acft for the preceding 90 day period. He normally flew his Cessna 185. He was…