NTSB investigations: Continental A&C75 series
8 cases on aircraft whose registry engine model is Continental A&C75 series, where the first occurrence was “Airframe/component/system failure/malfunction”. 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 |
| 1991 | 1 |
| 1998 | 2 |
| 2000 | 1 |
| 2002 | 1 |
| 2007 | 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\" = 130))
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" = 130))
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 SEA07LA090Accident · 1 fatalLimited investigationFinal reportBurton Fly Baby · Arlington, AZThe pilot exceeding the design stress limits of the aircraft while maneuvering in intentional aerobatics.NTSB ATL02FA101Accident · 2 fatalField investigationFinal reportLuscombe LL-8-E · Olar, SCThe in-flight separation of the elevator push-pull control tube that resulted in a loss of flight control and subsequent collision with the ground.NTSB NYC00LA134Accident · 1 fatalLimited investigationFinal reportHing FLY Baby 1A · Keymar, MDAn overload failure of both flying wires, on the underside of the right wing, while the airplane was climbing, due to improper balance between the two flying wires, by unknown person(s).NTSB LAX99LA061Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · San Ysabel, CAA fatigue fracture of the crankshaft and the resulting separation of the propeller.NTSB CHI98LA248Accident · Serious injuriesLimited investigationFinal reportForney 415-C · Laurie, MOthe jammed aileron and elevator controls for undetermined reasons.NTSB CHI91FA305Accident · 1 fatalField investigationFinal reportErcoupe Ercoupe 415-D · Emmett, MIThe pilot's exceeding the design limits of the aircraft, which resulted in an inflight breakup.NTSB ATL86FLQ06Accident · 1 fatalFinal reportBernard Sonerai II · Trenton, KYWitnesses reported seeing the acft spin to ground impact with a section of the right wing hanging. Post accident exam revealed the outboard half (aprx 4 ft) of the right wing was bent aprx 120 degrees to the inside half of the right wing. Monnett experimental…NTSB CHI82DA192Accident · No injuriesFinal reportErcoupe 415-C · Fort Atkinson, WIThe safety bolt on the propeller hub failed allowing the propeller to separate from the aircraft. The pilot landed in a plowed field.