NTSB investigations: Continental O-470 series, CO
6 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “Hard landing”. 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 |
|---|---|
| 1984 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 2000 | 1 |
| 2007 | 1 |
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\" = 'CO' 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\" = 200))
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" = 'CO' 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" = 200))
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 DEN07CA121Accident · No injuriesData collectionFinal reportCessna 180 · Marble, COThe pilot misjudging his altitude and his failure to maintain control of the airplane, resulting in a hard landing. Factors contributing to the accident were the excessive descent rate, and the pilot's improper recovery from a bounced landing.NTSB DEN00LA138Accident · No injuriesLimited investigationFinal reportCessna 182P · Broomfield, COThe pilot's inaccurate recovery from a bounced landing. Factors were lack of total pilot experience and lack of pilot experience in aircraft make and model.NTSB FTW94LA314Accident · No injuriesLimited investigationFinal reportCessna 182N · Cortez, COThe pilot's improper recovery from a bounced landing.NTSB DEN91LA084Accident · No injuriesLimited investigationFinal reportCessna 182Q · Lafayette, COThe pic's abrupt touchdown. Factors were: approach reference speed not maintained, proper descent rate not maintained by the PIC and inattention by the designated examiner.NTSB DEN84LA244Accident · No injuriesLimited investigationFinal reportCessna 182 · Pagosa Springs, COWhile turning the base leg, the plt viewed a hot air balloon near the final apch corridor. The plt elected to make a short final to avoid the balloon. The acft bounced during touchdown. The plt added power to recover and the acft veered off the left side of…NTSB DEN83LA063Accident · No injuriesLimited investigationFinal reportCessna 182 · Salida, COThe acft collapsed the nose gear and damaged the propeller during a landing. The pilot was practicing cross-wind landings when the acft started to porpoise. The nose gear and the propeller struck the rwy several time before the acft was stopped.