NTSB investigations: Continental A&C65 series, WY
14 cases on aircraft whose registry engine model is Continental A&C65 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
| 1966 | 1 |
|---|---|
| 1967 | 1 |
| 1969 | 1 |
| 1971 | 3 |
| 1973 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 2026 | 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\" = 'WY' 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 ('17003'))
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" = 'WY' 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 ('17003'))
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 WPR26LA250Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Buffalo, WYThe pilot’s improper flare and subsequent failure to maintain directional control of the airplane during the aborted landing.NTSB SEA94LA007Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Shoshoni, WYFuel exhaustion and the pilot in command's failure to refuel the aircraft.NTSB SEA92LA009Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Rawlins, WYAn inadequate weather evaluation. Factors to the accident were: gusts and crosswind.NTSB DEN85LTM05Accident · Serious injuriesFinal reportInterstate S-1A · Rock Springs, WYWhile on a x-country flt, the acft encountered turbulence & downdrafts. The plt stated that at 1st, he was not concerned, but then it became apparent that the acft may impact the ground. The acft had limited power (75 HP) & the terrain elevation in that area…NTSB DEN77FTC26Accident · No injuriesClosedLuscombe 8A · Gillette, WYNTSB DEN76DTC24Accident · No injuriesClosedAeronca 7AC · Lander, WYNTSB DEN76FTC22Accident · Serious injuriesClosedPiper J-3 · Gillette, WYNTSB DEN74DTC07Incident · No injuriesClosedTaylorcraft DC12D · Evanston, WYNTSB DEN72DTC10Accident · No injuriesClosedAeronca 65-TL · Recluse, WYNTSB DEN72FTC03Accident · Serious injuriesClosedPiper J3C-65 · Midwest, WYNTSB DEN71DXA16Accident · No injuriesClosedTaylorcraft BC1265 · Wheatland, WYNTSB DEN69D0207Accident · No injuriesClosedPiper J-3 · Greybull, WYNTSB DEN68D0131Accident · No injuriesClosedPiper J-3 · Edgerton, WYNTSB DEN67D0111Accident · No injuriesClosedPiper J-3 · Riverton, WY