NTSB investigations: Continental I0-470 series, 1982
7 cases on aircraft whose registry engine model is Continental I0-470 series, where the first occurrence was “In flight collision with terrain/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
| 1982 | 7 |
|---|---|
| 1983 | 3 |
| 1984 | 2 |
| 1985 | 3 |
| 1986 | 5 |
| 1987 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 2 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 2 |
| 2004 | 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 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 ('17027')
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\" = 230))
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 ('17027')
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" = 230))
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 LAX83LA018Accident · No injuriesLimited investigationFinal reportCessna 210 · Chico, CAThe pilot reported that he failed to extend the landing gear in the traffic pattern. Subsequently, the plane was damaged during a wheels up landing.NTSB CHI82FA329Accident · 1 fatalField investigationFinal reportCessna 310Q · Near Woodruff, WIAt approximately 2050, the acft was cleared for a NDB approach to lakeland arpt. At 2100, the acft crashed into a heavily wooded area 8.5 mi nw of the arpt.NTSB NYC82DA084Accident · No injuriesFinal reportBeech 35-33 · Altoona, PAThe pilot stated that before landing, he performed his cockpit duties and put the gear in the down position. However, he lost sight of another aircraft in the traffic pattern and became preoccupied with trying to locate the aircraft. He was also preoccupied…NTSB MIA82DA112Accident · No injuriesFinal reportBeech 95-B55 · Gainesville, FLThe purpose of the flight was to give dual instruction to the owner/student whose multi-engine rating was limited to centerline thrust models. The student was flying the aircraft on the takeoff roll when the cockpit door became ajar. The aircraft was near…NTSB ATL82FA104Accident · 4 fatalField investigationFinal reportCessna 210-5 · Hendersonville, NCThe aircraft crashed on tree covered/rising terrain after the pilot was cleared for a night ILS approach to runway 34 at the asheville regional airport. The crash occurred about 1 to 2 mi south of the final approach fix while the aircraft was on an outbound…NTSB ANC82DA028Accident · No injuriesFinal reportCessna 310D · Anchorage, AKJust prior to the mishap, maintenance on the aircraft had been performed. This included work on the cabin heater in the nose wheel well area. After takeoff to ferry the plane to a nearby airport, the nose wheel became jammed as the gear was retracted. The…NTSB LAX82DA122Accident · No injuriesFinal reportCessna 310Q · Yuba City, CAThe pilot reported that he forgot to put the gear down before landing.