NTSB investigations: Continental O-470 series, WA
11 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “Loss of control - on ground/water”. 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 |
|---|---|
| 1990 | 2 |
| 1994 | 1 |
| 1995 | 2 |
| 2000 | 2 |
| 2001 | 1 |
| 2003 | 1 |
| 2007 | 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.engine_model_code IN ('17026')
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\" = 260))
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.engine_model_code IN ('17026')
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" = 260))
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 LAX07CA265Accident · No injuriesData collectionFinal reportCessna 182P · Fall City, WAThe pilot's failure to maintain directional control.NTSB SEA03LA071Accident · No injuriesLimited investigationFinal reportCessna 180 · Pasco, WAThe pilot's inadequate remedial action when his aircraft began to veer during the landing roll, and his ultimate failure to maintain directional control which resulted in a ground loop. Factors include the pilot's momentary diversion of his attention during…NTSB SEA01LA136Accident · No injuriesLimited investigationFinal reportCessna 180K · Quincy, WAThe pilot's failure to maintain directional control during the landing roll. Factors include an encounter with a dust devil/whirlwind.NTSB SEA00LA171Accident · No injuriesLimited investigationFinal reportCessna 180H · Roche Harbor, WAThe pilot's failure to adequately compensate for wind conditions during landing.NTSB SEA00LA060Accident · No injuriesLimited investigationFinal reportCessna 180K · Silverdale, WAThe pilot's inadequate compensation for winds. Factors include gusty, shifting winds, crosswinds, and an earthen berm near the edge of the runway.NTSB CHI96LA009Accident · No injuriesLimited investigationFinal reportCessna 180R · Seattle, WAthe pilot's failure to maintain control of the airplane during the landing roll. A factor in the accident was the gusty wind conditions.NTSB SEA95LA049Accident · No injuriesLimited investigationFinal reportCessna 180 · Camas, WAInadequate remedial action by the flight instructor after the student lost directional control.NTSB SEA94LA173Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Ione, WAThe pilot's failure to maintain directional control. Factors include the pilot's fatigue, and trees near the side of the runway.NTSB SEA91LA035Accident · No injuriesLimited investigationFinal reportCessna 182-E · Anacortes, WAThe poor inflight decision by the PIC to land on a short grass airstrip in strong gusty tailwind conditions.NTSB SEA90LA179Accident · No injuriesLimited investigationFinal reportCessna 182P · Lummi Island, WAThe pilot's failure to maintain directional control while applying brakes after landing.NTSB SEA84LA077Accident · No injuriesLimited investigationFinal reportCessna 180-A · Garfield, WAThe acft was landed in a soft stubble field. The landing gear mired and the acft ground looped breaking the right main landing gear.