NTSB investigations: Continental A&C75 series, WI
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
| 1965 | 1 |
|---|---|
| 1971 | 1 |
| 1972 | 1 |
| 1975 | 1 |
| 1982 | 1 |
| 1995 | 2 |
| 1999 | 2 |
| 2010 | 1 |
| 2015 | 1 |
| 2019 | 1 |
| 2023 | 1 |
| 2025 | 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\" = 'WI' 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" = 'WI' 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 CEN26LA047Accident · No injuriesClass 4 · LimitedFinal reportEngineering & Research 415 · Sheboygan Falls, WIThe flight instructor’s failure to arrest the airplane’s descent rate during a takeoff simulated engine failure which resulted in a hard landing.NTSB CEN23FA369Accident · 1 fatalClass 3 · FieldFinal reportPiper J5A · Iola, WIThe pilot’s failure to maintain control of the airplane after landing on a grass taxiway with a tailwind, which resulted in a nose over.NTSB CEN19LA243Accident · Serious injuriesClass 3 · LimitedFinal reportCulver LCA · Viroqua, WIA total loss of engine power due to fuel exhaustion.NTSB GAA16CA067Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12 65 · New Lisbon, WIThe pilot's exceedance of the airplane's critical angle of attack, resulting in an inadvertent aerodynamic stall and impact with terrain.NTSB CEN10CA094Accident · Minor injuriesData collectionFinal reportEngineering & Research Ercoupe 415-CD · New London, WIThe pilot's decision to land with a tailwind on the snow- and ice-covered runway.NTSB CHI99LA242Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Bristol, WIthe pilot's failure to perform a proper recovery from the bounced landing, resulting in the airplane's nose gear striking the runway. A factor relating to the accident was the excessive airspeed maintained during the landing.NTSB CHI99LA109Accident · No injuriesLimited investigationFinal reportPiper J5A · Wausau, WIthe loss of engine power for undetermined reasons and the lack of suitable terrain for landing. A factor to the accident was the aircraft owner not performing necessary maintenance to the aircraft.NTSB CHI95LA194Accident · No injuriesLimited investigationFinal reportPiper J-5A · Wausau, WIthe pilot's misjudgment of the clearance between the airplane and the fuel pumps.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 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.NTSB CHI76DEP08Accident · No injuriesClosedAeronca 11AC · Holmen, WINTSB CHI72FEP51Accident · Minor injuriesClosedPiper J3C-65 · Fond Du Lac, WINTSB CHI71DER07Accident · No injuriesClosedPiper J3C · Star Prairie, WINTSB CHI66F0497Accident · No injuriesClosedCulver LCA · Superior, WI