NTSB investigations: Luscombe 8A, IA
18 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 | 2 |
|---|---|
| 1967 | 1 |
| 1968 | 2 |
| 1969 | 1 |
| 1970 | 1 |
| 1972 | 1 |
| 1974 | 1 |
| 1975 | 2 |
| 1978 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1993 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2015 | 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\" = 'IA' 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" = 'IA' 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 GAA15CA193Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Oxford, IAThe pilot's selection of unsuitable terrain for takeoff based on the runway and density altitude conditions, which resulted in a runway excursion and impact with terrain.NTSB CHI03LA295Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Maquoketa, IAThe pilot's excessive use of the brake system, which resulted in directional control not being maintained during the landing. A factor to the accident was the crosswind.NTSB CHI01FA026Accident · 1 fatalField investigationFinal reportLuscombe 8A · Des Moines, IAThe pilot not maintaining aircraft control during the final turn, and the pilot's improper decision to fly the tight pattern to the closer runway. Factors relating to the accident were the pilot's inadequate distance/altitude in the traffic pattern and the…NTSB CHI93LA100Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Mason City, IAExcessive braking by the dual student.NTSB MKC81DCD24Accident · No injuriesClosedLuscombe 8A · Muscatine, IANTSB MKC80FCD06Accident · No injuriesClosedLuscombe 8A · Winterset, IANTSB MKC78FCD18Accident · No injuriesClosedLuscombe 8A · 0ttumwa, IANTSB MKC76FCD20Accident · Minor injuriesClosedLuscombe 8A · Missouri Vally, IANTSB MKC76IK010Incident · No injuriesClosedCessna 150 · Runnells, IANTSB MKC75FCD28Accident · No injuriesClosedLuscombe 8A · Rockwell Cty, IANTSB MKC72DCD72Accident · No injuriesClosedLuscombe 8A · Missouri Vly, IANTSB MKC70DCD23Accident · No injuriesClosedLuscombe 8A · Jefferson, IANTSB MKC70D0031Accident · No injuriesClosedLuscombe 8A · Rock Rapids, IANTSB MKC69F0118Accident · Minor injuriesClosedLuscombe 8A · Anita, IANTSB MKC69D0012Accident · No injuriesClosedLuscombe 8A · Dike, IANTSB MKC68F0119Accident · No injuriesClosedLuscombe 8A · Grimes, IANTSB UNK64X1443Accident · Minor injuriesClosedLuscombe 8A · Toledo, IANTSB UNK64X0781Accident · No injuriesClosedLuscombe 8A · Mapleton, IA