NTSB investigations: Continental A&C75 series, AL
8 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
| 1965 | 1 |
|---|---|
| 1967 | 1 |
| 1968 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1987 | 1 |
| 2005 | 1 |
| 2006 | 1 |
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\" = 'AL' 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" = 'AL' 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 ATL06LA049Accident · No injuriesLimited investigationFinal reportErcoupe E · Wetumpka, ALThe failure of the No. 2 exhaust, and intake valves for undetermined reasons, which resulted in a loss of engine power during cruise flight and damage to the airplane during the subsequent forced landing.NTSB ATL05CA080Accident · No injuriesData collectionFinal reportPiper J4E · Akron, ALThe pilot's premature liftoff and his failure to attain adequate airspeed which resulted in a stall/mush. Also causal was the pilot's delay in aborting the takeoff.NTSB ATL87LA090Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-D · Cottondale, ALThe plt performed a touch-and-go after takeoff. During the takeoff phase of the touch-and-go, the acft eng quit. The acft was force landed in tree. Post accident inspection failed to reveal any failure/malfunction.NTSB MIA76DKJ11Accident · No injuriesClosedPiper PA-28 · Camden, ALNTSB MIA74DKJ04Accident · Serious injuriesClosedPiper J3C · Guntersville, ALNTSB MIA69D0025Accident · Minor injuriesClosedPiper J-5 · Brownsboro, ALNTSB MIA68F0044Accident · No injuriesClosedErco 415-C · Bessemer, ALNTSB MIA66D0273Accident · No injuriesClosedErcoupe 415-C · Sylacauga, AL