NTSB investigations: Continental A&C65 series, CA
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 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1993 | 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 c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
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 LAX07CA145Accident · No injuriesData collectionFinal reportPiper J3C-65 · Redding, CAThe loss of engine power due to fuel exhaustion.NTSB LAX93LA313Accident · 1 fatalLimited investigationFinal reportTaylorcraft BC-12D · Tehachapi, CAFuel starvation due to the pilot's failure to correctly position the fuel selector prior to departure, and his failure to maintain an adequate airspeed margin above stall while attempting to return to the runway. Factors in the accident were: the pilot's…NTSB LAX90LA285Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DC-65 · Morgan Hill, CAFuel exhaustion, due the certified flight instructors improper preflight inspection.NTSB LAX89LA162Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Santa Paula, CAThe pilots improper use of carburetor heat in conditions that were conducive to the formation of carburetor ice.NTSB LAX87DVM02Accident · Serious injuriesFinal reportBowers Flybaby 1A · San Luis Obispo, CADuring a pleasure flt in an experimental acft, during the takeoff roll, the eng sputtered, however, the plt continued the flt. After takeoff at aprx 30 ft the eng sputtered again. The plt made a sharp 45 deg turn which put him on downwind, however, the acft…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 LAX82DA314Accident · No injuriesFinal reportAeronca 65-TC · Mira Loma, CAThe pilot reported that during flight, he ran out of fuel and the plane was damaged during a forced landing. An examination verified there was no preimpact, structural engine failure. Only residual fuel was found in the fuel filter, carburetor, header tank…