NTSB investigations: Continental O-470 series, 1982
8 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\") = 1982
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") = 1982
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 MIA83LA049Accident · No injuriesLimited investigationFinal reportCessna 182Q · Ocoee, FLPlt approached with a higher than normal airspeed. The acft touched down nose wheel first about 1/3 down the rwy collapsing the nose gear causing the propeller to strike the rwy.NTSB SEA83LA010Accident · No injuriesLimited investigationFinal reportCessna 182B · Redmond, ORThe pilot stated that during landing, the aircraft was hit with a 40 knot crosswind, which forced the aircraft into the runway. The nose gear collapsed causing structural damage T0 the aircraft.NTSB SEA82DA168Accident · No injuriesFinal reportCessna C-180J · 18nm Ese Ketchi, AKThe pilot stated that he circled the lake prior to landing. There was no wind and the lake surface was glassy. During the final approach, the pilot encountered sun glare off the lake. The aircraft landed hard and the wing tips contacted the water.NTSB LAX82DA277Accident · No injuriesFinal reportCessna 180 · Goodyear, AZThe left main landing gear of the aircraft broke off during a touch and go landing and the aircraft was damaged further on a subsequent landing. The weather was VMC and no flight plan was filed. The landing gear bolts failed in overload and showed no evidence…NTSB NYC82DA165Accident · No injuriesFinal reportCessna 305A · Sagaponack, NYThe pilot reported that he was landing to the southeast on an 1800 ft grass strip with a crosswind from the northeast at 10 to 15 KTS. He stated that when he was on final approach with full flaps, he was distracted by four people with model aircraft near the…NTSB FTW82FRG23Accident · Minor injuriesFinal reportCessna 180 · San Antonio, TXThe pilot stated that during the touchdown the aircraft bounced and made a second touchdown approximately 200 feet beyond the first. Corrective action was attempted but the left wing contacted the ground and the aircraft nosed over. The wind was reported to…NTSB LAX82DA191Accident · No injuriesFinal reportCessna 182 · Huron, CAWhile attempting to extend glide over a flooded portion of the runway the aircraft lost airspeed. After dropping onto the runway the aircraft bounced and the pilot added power. The aircraft was then flown back to king city, CA where the gear collapsed upon…NTSB SEA82DA073Accident · No injuriesFinal reportCessna 182QII · Cove, ORThe pilot stated that he landed heavy and was not quite straight. When the aircraft bounced the pilot attempted a go-around but the nose gear contacted a fence and the aircraft nosed over.