NTSB investigations: Continental O-470 series, MO
10 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
| 1983 | 1 |
|---|---|
| 1986 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2003 | 2 |
Where
Latest 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\" = 'MO' 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" = 'MO' 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 CHI03LA312Accident · Minor injuriesLimited investigationFinal reportCessna 182P · St. Louis, MOThe pilot's failure to maintain directional control during the landing rollout.NTSB CHI03LA081Accident · No injuriesLimited investigationFinal reportCessna 180K · St Charles, MOThe pilot's inadequate compensation for wind and his failure to maintain directional control resulting in a ground loop. A factor was the crosswind.NTSB CHI00LA016Accident · No injuriesLimited investigationFinal reportCessna 180J · Pleasant Hills, MOThe pilot's loss of directional control during an aborted takeoff.NTSB CHI98LA137Accident · No injuriesLimited investigationFinal reportCessna 305 · Fredricktown, MOthe pilot's failure to maintain aircraft control after landing. Factors contributing to this accident were the embankment, and the soft , muddy soil making up the embankment.NTSB CHI97LA082Accident · No injuriesLimited investigationFinal reportCessna 182 · Kirksville, MOthe pilot failed to adequately compensate for the wind conditions on the runway during landing roll. Factors included the crosswind and gusts.NTSB CHI94LA141Accident · No injuriesLimited investigationFinal reportCessna 182P · Kahoka, MOThe pilot's failure to determine the wind conditions before attempting to land in conditions which exceeded the performance capability of the airplane.NTSB CHI92LA057Accident · No injuriesLimited investigationFinal reportCessna 182 · Point Lookout, MOFailure of the pilot to attain the proper touchdown Point and maintain directional control of the aircraft. A factor related to the accident was: a go-around was not performed by the pilot.NTSB MKC90LA035Accident · No injuriesLimited investigationFinal reportCessna 180 · St. Louis, MOThe pilot's failure to adequately compensate for the wind. The gusty, crosswind condition is considered a contributing factor to the accident.NTSB MKC86LA200Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Lexington, MOThe student plt had taken the acft without the owner's permission & taxied onto a sod rwy. He rprtd that the acft almost became mired in mud on the sod rwy, so he added full power. The acft accelerated forward rapidly and the student lost control. The acft…NTSB MKC83LA050Accident · No injuriesLimited investigationFinal reportCessna 182P · Maryville, MOAircraft ran off runway during takeoff. Pilot said he was unable to control veer and the aircraft continued off into soft terrain and nosed down.