NTSB investigations: Continental A&C75 series, PA
14 cases on aircraft whose registry engine model is Continental A&C75 series. 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
| 1964 | 2 |
|---|---|
| 1965 | 1 |
| 1967 | 1 |
| 1968 | 2 |
| 1973 | 1 |
| 1977 | 2 |
| 1981 | 1 |
| 1982 | 1 |
| 2013 | 1 |
| 2017 | 2 |
Where
Open the mapLatest 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\" = 'PA' 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 ('17005'))
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" = 'PA' 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 ('17005'))
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 ERA18LA007Accident · No injuriesLimited investigationFinal reportErcoupe 415 · Centre Hall, PAThe partial loss of engine power due to the No. 2 cylinder exhaust valve being stuck.NTSB GAA17CA552Accident · No injuriesData collectionFinal reportHencken William Pietenpol AIR Camper · Franklin, PAThe failure of the weld that connects the left main landing gear and the axle during the takeoff roll.NTSB ERA13LA406Accident · No injuriesLimited investigationFinal reportEngineering & Research 415-D · Beaver Falls, PAThe owner/pilot’s failure to follow engine manufacturer recommendations for engine oil changes and spark plug cleaning and rotating when operating the airplane with 100 low lead fuel, which resulted in carbon buildup in the engine and the total loss of engine…NTSB NYC83LA023Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Prospectville, PAPrior to departure the pilot performed a run-up and engine check. All indications were normal. The pilot stated that the takeoff was normal until 100 feet when an engine power loss was experienced. He attempted to land on the remaining runway, however was…NTSB NYC81FGM26Accident · No injuriesClosedPiper J3C-65 · Mt Pleasant, PANTSB NYC78FGM04Accident · No injuriesClosedTaylorcraft L-2M · Finleyville, PANTSB NYC77FGM45Accident · Serious injuriesClosedMiniplane DS · Ebensburg, PANTSB NYC74FGM12Accident · No injuriesClosedErco 415-C · West Middlesex, PANTSB NYC69D0110Accident · Minor injuriesClosedErco 415-C · Tarentum, PANTSB NYC69D0024Accident · No injuriesClosedErcoupe 415-C · Tunkhannock, PANTSB NYC67F0679Accident · No injuriesClosedPiper J3C-65 · Friedens, PANTSB NYC65F0239Accident · No injuriesClosedErcoupe 415C · Clearfield, PANTSB UNK64X3032Accident · No injuriesClosedPiper J3 · Bridgeville, PANTSB UNK64X1286Accident · No injuriesClosedErcoupe 415C · Oxford, PA