NTSB investigations: Continental A&C65 series, ND
16 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
| 1965 | 1 |
|---|---|
| 1966 | 2 |
| 1967 | 3 |
| 1969 | 1 |
| 1972 | 1 |
| 1977 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1990 | 2 |
| 2001 | 1 |
| 2018 | 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\" = 'ND' 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" = 'ND' 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 GAA18CA241Accident · No injuriesData collectionFinal reportAeronca 65 LB · Carrington, NDThe pilot’s failure to maintain directional control and his subsequent excessive brake application during landing, which resulted in a nose-over.NTSB CHI01LA201Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · West Fargo, NDthe pilot's inadequate preflight planning and the unsuitable landing area selected by the pilot. Additional factors were the uneven terrain and the failed float assembly in overload.NTSB DEN90LA128Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Wahpeton, NDInadequate compensation for the wind conditions by the pilot. A factor was a strong cross wind, with gusts.NTSB DEN90DTG01Accident · No injuriesFinal reportAdams Boredom Fighter · Finley, NDA power loss due to fuel exahustion and the pilot's inadequate fuel planning. A factor was the ditch in which touchdown occurred.NTSB DEN85LTG07Accident · No injuriesFinal reportAeronca 058B · Mott, NDWhile departing a stubble field, the aircraft's tire ran into a soft spot in the ground and the aircraft turned and struck the shoulder of a road. The right gear broke and the right wing tip struck the ground, the right strut broke, the tail wheel and rudder…NTSB DEN84FTG01Accident · No injuriesFinal reportLee M. Brown Taterbug SB-1 · Sawyer, NDThe plt switched from main tank to aux tank, & about 10 minutes later, the eng began losing power switching back to the main tank did not help. The engine continued running but at greatly reduced power. A forced landing was made in a frozen stubble field. The…NTSB DEN82DA047Accident · No injuriesFinal reportTaylorcraft BC-12D · Lisbon, NDThe pilot stated that during the landing on runway 15, at an altitude of approximately 20 to 30 feet, the wind coming over the snowbanks on the sides of the runway caused turbulence that raised the aircraft and pushed it to the left of the runway. The…NTSB MKC77FTG11Accident · No injuriesClosedLuscombe 8A · Reynolds, NDNTSB MKC72DTG15Accident · No injuriesClosedPiper J-3 · Mott, NDNTSB MKC70D0020Accident · No injuriesClosedTaylorcraft BC12-D · Minot, NDNTSB MKC68F0323Accident · No injuriesClosedPiper J-3 · Douglas, NDNTSB MKC68F0303Accident · No injuriesClosedAeronca 65-TC · Langdon, NDNTSB MKC68F0096Accident · No injuriesClosedAeronca 11AC · Grafton, NDNTSB MKC67F0202Accident · No injuriesClosedErcoupe 415-C · Blaisdell, NDNTSB MKC66D0418Accident · No injuriesClosedAeronca 7AC · Kenmare, NDNTSB MKC66D0404Accident · No injuriesClosedLuscombe 8A · Fessenden, ND