NTSB investigations: Continental I0-470 series, 1982
6 cases on aircraft whose registry engine model is Continental I0-470 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 | 6 |
|---|---|
| 1983 | 4 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 2 |
| 1987 | 4 |
| 1988 | 5 |
| 1989 | 3 |
| 1990 | 2 |
| 1991 | 3 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 6 |
| 1996 | 4 |
| 1997 | 3 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 3 |
| 2002 | 5 |
| 2003 | 6 |
| 2004 | 4 |
| 2005 | 4 |
| 2006 | 3 |
| 2007 | 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 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\" = 353))
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" = 353))
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 SEA83LA004Accident · No injuriesLimited investigationFinal reportBeech J35 · Friday Harbor, WAWhile on the takeoff roll, the engine was slow to accelerate, and just prior to rotation, it coughed and sputtered. The takeoff was abandoned, but the pilot was unable to stop the aircraft on the remaining runway. The aircraft penetrated the perimeter fence…NTSB NYC82FHA10Accident · Serious injuriesFinal reportNavion G · Doylestown, PAAt approximately 75-100 ft the eng quit. The acft landed with the gear up & slid off the end of the rwy approximately 200-300 ft. the plt acknowledged taking off with the fuel selector on the empty left tip tank.NTSB LAX82FVG34Accident · Serious injuriesFinal reportCessna 210 · Placerville, CAPilot states he was descending from 10,000 feet to 8,000 feet when engine quit. Further stated fuel was above red arc-no steep or sharp maneuvers. No mention of rate of descent or deck angle in descent. Forced landing was made circling to right-useable fuel…NTSB LAX82FA290Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Palo Verde, AZThe acft took off from a road near the plt's home. It was observed to go around a pickup truck parked alongside the road & then lift off. The acft climbed, turned right briefly & then went wings level. It then started a right descending turn into the ground.…NTSB CHI82DA173Accident · No injuriesFinal reportCessna 210 · Loganville, WIDuring landing approach the engine lost power and the pilot attempted to land in an open field. The aircraft failed to clear a terrace and the nose gear separated from the airplane. The pilot stated, "while concentrating on the various aspects of operation in…NTSB FTW82DA059Accident · No injuriesFinal reportCessna 310D · Farmerville, LABefore this flight, the aircraft had not been flown for a period of time. The pilot was the owner of a maintenance facility and was preparing to perform an annual inspection of the aircraft. He elected to fly it around the airport to warm up the engines…