NTSB investigations: Continental A&C75 series
8 cases on aircraft whose registry engine model is Continental A&C75 series, where the first occurrence was “In flight collision with terrain/water”. 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 |
|---|---|
| 1983 | 1 |
| 1986 | 1 |
| 1995 | 1 |
| 2000 | 2 |
| 2001 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17005')
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\" = 230))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17005')
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" = 230))
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 NYC07LA008Accident · 1 fatalLimited investigationFinal reportFlynn William Pazmany PL-4 · Fredricksburg, VAThe pilot's intentional low altitude maneuvering, which resulted in an inadvertent collision with terrain.NTSB FTW01LA077Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Houston, TXthe pilot's failure to execute a go-around after becoming low on a visual approach.NTSB LAX00LA174Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Healdsburg, CAFailure of the flight review pilot to compensate for the crosswind and maintain flying speed during takeoff.NTSB FTW00LA129Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-D · Lindsay, TXThe student pilot's inadequate compensation for wind conditions. A factor was the downdraft wind condition.NTSB CHI95LA133Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Elk Creek, WIthe pilot's failure to maintain clearance with the trees. Factors in the accident include the trees, the tailwind condition, and the pilot's lack of proper certification.NTSB NYC86FNE02Accident · No injuriesFinal reportFolsom Sonerai II · Middlebury, CTThe plt reported that the acft was slow to climb after takeoff and had reached an alt of only 100' AGL at the end of the 5000' lond rwy. The plt continued to state the acft was unable to clear rising terrain aprx 1/2 mile from the arpt. The acft contacted the…NTSB LAX83FA397Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Kernville, CAThe acft crashed in rising terrain 6 mi west of the departure arpt at 5,000 ft MSL. The alta sierra pass is 6,500 ft mslwith mountain tops at 8,320 ft MSL. The plt was issued a student certificate on 8/22/80 which was not renewed.NTSB SEA82DA157Accident · No injuriesFinal reportErcoupe 415C · Kingston, WAPilot thought he could not clear power lines and trees after takeoff so he aborted takeoff & slid 250 ft off the runway, nosing over. The pilot mentioned that it was hot & there was a slight tailwind. This was the first time the pilot has used the airstrip.