NTSB investigations: Luscombe 8E, WA
13 cases on aircraft the registry lists as Luscombe 8E. 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 | 2 |
| 1970 | 4 |
| 1972 | 2 |
| 1974 | 1 |
| 1982 | 1 |
| 2003 | 1 |
| 2012 | 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\" = 'WA' 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 ('8190112'))
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" = 'WA' 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 ('8190112'))
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 WPR12CA159Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Westport, WAThe pilot’s inadequate crosswind compensation, which resulted in a loss of directional control during the landing roll.NTSB SEA04LA008Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · Spanaway, WAThe pilot's misjudgment of distance and altitude resulting in an undershoot of the runway and collision with a fence. A fence was a factor in the accident.NTSB SEA82DA040Accident · No injuriesFinal reportLuscombe 8E · Blaine, WAUpon arrival the pilot observed the wind to be 90 degrees to the runway with an estimated velocity of 5 to 7 knots. A low pass was completed followed by a landing on runway 32. During the rollout the aircraft drifted right, the landing gear encountered…NTSB SEA74DYE33Accident · No injuriesClosedLuscombe 8E · Bellevue, WANTSB SEA72DYG38Accident · No injuriesClosedLuscombe 8E · Pullman, WANTSB SEA72DVC26Accident · No injuriesClosedLuscombe 8E · Orchards, WANTSB SEA71AS009Accident · 1 fatalClosedLuscombe 8E · Orting, WANTSB SEA71DWG04Accident · No injuriesClosedLuscombe 8E · Pullman, WANTSB SEA70DWG18Accident · Minor injuriesClosedLuscombe 8E · Okanogan, WANTSB SEA70FWD10Accident · No injuriesClosedLuscombe 8A · Kent, WANTSB SEA67D0070Accident · No injuriesClosedLuscombe 8E · Puyallup, WANTSB SEA66F0262Accident · No injuriesClosedLuscombe 8E · Vancouver, WANTSB UNK65X0143Accident · No injuriesClosedLuscombe 8E · Selah, WA