NTSB investigations: Luscombe 8A, NC
16 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 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1974 | 2 |
| 1977 | 2 |
| 1978 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 1988 | 1 |
| 1996 | 1 |
| 2005 | 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\" = 'NC' 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" = 'NC' 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 ATL05CA057Accident · No injuriesData collectionFinal reportLuscombe 8A · Lexington, NCThe pilot's excessive braking during landing roll, which resulted in a nose-over. A factor was the tailwind.NTSB MIA97LA029Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Charlotte, NCfailure of the pilot maintain directional control of the aircraft, while landing. The proximity of trees was a related factor.NTSB ATL88FA199Accident · 1 fatalField investigationFinal reportLuscombe 8A · Horse Shoe, NCA witness reported that he was irrigating a newly cultivated corn field with a spray irrigation machine. He heard and then observed the accident airplane fly through or just over a gap in the trees at the northeast end of the field. The airplane proceeded to…NTSB ATL83FA071Accident · Serious injuriesField investigationFinal reportLuscombe 8A · Apex, NCThe Luscombe had departed the e-w rwy in an easterly direction, had reversed course & was on a straight-in apch to rwy 27. The PA-22 entered the arpt traffic via a standard left downwind & base pattern. During final the PA-22 ended up above & slightly behind…NTSB IAD80DKM07Accident · No injuriesClosedLuscombe 8A · Franklin, NCNTSB IAD78FA083Accident · 1 fatalClosedLuscombe 8A · Fairfield, NCNTSB IAD78DKM03Accident · No injuriesClosedLuscombe 8F · Charlotte, NCNTSB IAD77DLJ07Accident · No injuriesClosedLuscombe 8A · Apex, NCNTSB IAD75A1031|IAD75AI031Accident · 1 fatalClosedLuscombe 8A · Polkton, NCNTSB IAD74DLJ27Accident · No injuriesClosedLuscombe 8A · Jacksonville, NCNTSB IAD71DKM15Accident · No injuriesClosedLuscombe 8A · Waxhaw, NCNTSB IAD70F0100Accident · No injuriesClosedLuscombe 8A · Durham, NCNTSB DIA68D0112Accident · No injuriesClosedLuscombe 8A · Thomasville, NCNTSB MIA66F0424Accident · Minor injuriesClosedLuscombe 8A · Raleigh, NCNTSB UNK64X3302Accident · No injuriesClosedLuscombe 8A · Statesville, NCNTSB UNK64X3149Accident · No injuriesClosedLuscombe 8A · Sanford, NC