NTSB investigations: Continental O-470 series, 1983
7 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
| 1982 | 8 |
|---|---|
| 1983 | 7 |
| 1984 | 8 |
| 1985 | 5 |
| 1986 | 2 |
| 1987 | 4 |
| 1988 | 7 |
| 1989 | 8 |
| 1990 | 8 |
| 1991 | 10 |
| 1992 | 5 |
| 1993 | 5 |
| 1994 | 4 |
| 1995 | 5 |
| 1996 | 7 |
| 1997 | 6 |
| 1998 | 7 |
| 1999 | 5 |
| 2000 | 9 |
| 2001 | 6 |
| 2002 | 11 |
| 2003 | 5 |
| 2004 | 9 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 6 |
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 year(c.\"eventDate\") = 1983
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 year(c."eventDate") = 1983
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 LAX84LA039Accident · No injuriesLimited investigationFinal reportCessna 182 · Winnemucca, NVThe plt reported that during a landing, he rounded out hi & allowed the acft to make a bounced landing. During the landing, the prop struck the rwy & the firewall & fuselage skin were damaged. After the hard landing, the plt taxied clear of the rwy & acft.NTSB LAX83LA426Accident · No injuriesLimited investigationFinal reportCessna 182L · Santa Paula, CAThe plt reported that during the landing, he 'came in too fast & sharp, bounced 5 times, did a go-around & landed.' After the landing, he taxied to a fuel pump, then found that the acft was damaged. The acft had porpoised to such an extent that both propeller…NTSB SEA83LA144Accident · No injuriesLimited investigationFinal reportCessna 180 · Salmon, IDThe pilot said he encountered a high sink rate during the approach. Directional control was lost after the pilot failed to arrest the sink rate and made a hard landing. The acft left the runway and collided with a fence before coming to rest.NTSB NYC83LA170Accident · No injuriesLimited investigationFinal reportCessna 182F · New Paltz, NYAccording to the plt, just prior to landing, the acft encountered wind shear, and subsequently, a hard landing occurred. The firewall, cowling, propeller & belly skin were damaged during the landing.NTSB LAX83LA202Accident · No injuriesLimited investigationFinal reportCessna 180 · Long Beach, CAAccording to an on-duty, air traffic controller, the plt was practicing takeoffs & landings. After completing several landings, the plt made an apch to rwy 16R. During the landing, the acft reportedly pitched downward, and after touchdown became airborne…NTSB NYC83LA097Accident · No injuriesLimited investigationFinal reportCessna 182 · Rochester, NYThe acft went off the runway in strong gusty winds and nosed down in mud. The pilot stated that he bounced on landing and came down about 35 degrees to the centerline. He judged it too risky to try to realign so he continued to land off the runway. The acft…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.