NTSB investigations: Continental A&C65 series, 1986
7 cases on aircraft whose registry engine model is Continental A&C65 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 | 5 |
|---|---|
| 1983 | 2 |
| 1984 | 7 |
| 1985 | 4 |
| 1986 | 7 |
| 1987 | 3 |
| 1988 | 4 |
| 1989 | 7 |
| 1990 | 4 |
| 1991 | 1 |
| 1993 | 3 |
| 1994 | 2 |
| 1995 | 6 |
| 1996 | 1 |
| 1997 | 1 |
| 2000 | 3 |
| 2001 | 1 |
| 2004 | 3 |
| 2005 | 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 year(c.\"eventDate\") = 1986
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17003')
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") = 1986
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17003')
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 LAX87LA031Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Half Moon Bay, CAThe acft collided with the terrain during a forced landing following a loss of engine power. The plt indicated that he retarded the throttle and applied the carburetor heat to descend from 3,000 to 2,000 ft when the engine quit. He was unable to restart the…NTSB MIA87LA010Accident · No injuriesLimited investigationFinal reportBuhl LA-1 · Belleview, FLThe plt stated that he had reached an alt of about 50 ft when the eng quit. He stated that while he was attempting to determine the cause of the problem, he stopped flying the acft & permitted a high sink rate to develop which was not arrested prior to the…NTSB MKC87LA001Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Tribune, KSThe PIC rptd eng failure while in cruise flt. The student PIC suspected carb icing as the cause of the eng failure. No mechanical pblm was discovered during the eng inspection. The icing probability charts indicated that carburetor icing was likely in the…NTSB ANC86FA085Accident · No injuriesField investigationFinal reportPiper L-4H · Anchorage, AKThe pilot/mechanic stated the engine oil pressure gauge began flickering, so he elected to land and during the descent the engine failed. He landed downwind in 20 knot winds and during the landing roll, across tundra/mud the airplane's wheels struck a large…NTSB ATL86LA159Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Fayetteville, GAThe plt reported that while on downwind the engine started to run rough. The plt applied carburetor heat and the engine quit. A turn toward a landing area was made; however, the acft collided with trees. Weather conditions at the time were favorable for…NTSB DEN86LA088Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Santa Rosa, NMAccording to the plt, the eng quit during the initial climbout and the acft was substantially damaged during the subsequent forced landing. Post accident inspection disclosed the gascolator was broken which resulted in fuel starvation to the engine.NTSB LAX86LA132Accident · No injuriesLimited investigationFinal reportAeronca 11-AC · Standfield, AZAn Aeronca chief collided with a telephone pole on landing roll on a dirt road after a forced landing due to fuel exhaustion. The pilot reported that he was delayed approximately 45 minutes awaiting takeoff clearance by ground control with the engine running.…