Skip to content

NTSB investigations: Continental A&C65 series, MI

146 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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" = 'MI' 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

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\" = 'MI' 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" = 'MI' 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

Run 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 CHI84LA033Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Burnips, MIReportedly, the plt had consumed 4 beers after 2200 EDT, while at the bostwick lake inn, then consumed another beer after he left the inn. At aprx 0330 EDT, he & a passenger took off from an unlit arpt. The plt stated that shortly after takeoff, he became…Oct 22, 1983 · N2172E · Substantial damage NTSB CHI83LA127Accident · Minor injuriesLimited investigationFinal reportAeronca Champion 7AC · Newberry, MIThe aircraft collided with a telephone pole while attempting a takeoff on skis. The snow was wet, sparse and sticky and the takeoff was being performed on a taxiway because it had more snow. This was a dual instructional flight with the student at the…Mar 1, 1983 · N84583 · Destroyed NTSB CHI82DA333Accident · No injuriesFinal reportPiper J-3C65 · Bloomfield Hill, MITakeoff was from se end of a lake about 4,000 ft long (se to nw) with a small island in the center. The plt stated that after lift-off he obtained climb speed but the acft would not climb from about 20-30 ft above the water. Severe turbulence was encountered…Sep 2, 1982 · N6544H · Substantial damage NTSB CHI82DA194Accident · Serious injuriesFinal reportAeronca AR-58 · Grand Haven, MIAfter liftoff the pilot lost directional control and crashed in a swamp. The aircraft was substantially damaged.May 30, 1982 · N2563E · Substantial damage NTSB CHI81FEM43Accident · No injuriesClosedAeronca 65-TC · Plainwell, MISep 7, 1981 · N31751 · Substantial damage NTSB CHI81FEC44Accident · 1 fatalClosedLuscombe 8A · Farmington, MISep 6, 1981 · N71993 · Destroyed NTSB CHI81DEM28Accident · No injuriesClosedAeronca 11AC · Elwell, MIJul 17, 1981 · N39578 · Substantial damage NTSB CHI81DEC17Accident · No injuriesClosedLuscombe 8A · New Hudson, MIMar 7, 1981 · N1244B · Substantial damage NTSB CHI81FEM11Accident · Serious injuriesClosedPiper J3C · Grand Haven, MIMar 4, 1981 · N2083M · Substantial damage NTSB CHI81FEC16Accident · No injuriesClosedLuscombe 8A · Owosso, MIFeb 26, 1981 · N77876 · Substantial damage NTSB CHI81FEM07Accident · Minor injuriesClosedPiper J3C-65 · Atlanta, MIJan 20, 1981 · N6658H · Substantial damage NTSB CHI80FET28Accident · Serious injuriesClosedPiper J3C-65 · Jones, MIAug 28, 1980 · N6334H · Substantial damage NTSB CHI80DEC11Accident · Minor injuriesClosedTaylorcraft DCO-65 · Brighton, MIFeb 7, 1980 · N47867 · Substantial damage NTSB CHI79FEC49Accident · No injuriesClosedAeronca 7AC · Deford, MISep 4, 1979 · N85188 · Substantial damage NTSB CHI79FEM33Accident · 2 fatalClosedBreezy FGC100 · Grand Haven, MIAug 5, 1979 · N219TC · 2 aircraft · Minor damage NTSB CHI78FEC48Accident · Minor injuriesClosedAeronca 7AC · Imlay City, MIAug 20, 1978 · N85108 · Destroyed NTSB CHI77FEC28Accident · Minor injuriesClosedLuscombe 8A · Carleton, MIJun 1, 1977 · N45976 · Substantial damage NTSB CHI77FEC27Accident · Minor injuriesClosedTaylorcraft L-2 · Monroe, MIMay 14, 1977 · N50414 · Substantial damage NTSB CHI77FEM16Accident · Serious injuriesClosedTaylorcraft DC-65 · N Muskegon, MIFeb 10, 1977 · N36356 · Substantial damage NTSB CHI77FEM14Accident · Minor injuriesClosedPiper J-3 · Steuben, MIJan 30, 1977 · N98761 · Substantial damage NTSB CHI76FEC61Accident · Minor injuriesClosedAeronca 7AC · Owosso, MISep 12, 1976 · N85749 · Substantial damage NTSB CHI76FET51Accident · Minor injuriesClosedPiper J3C-65 · Dowagiac, MISep 11, 1976 · N87943 · Substantial damage NTSB CHI76FEM49Accident · Serious injuriesClosedTaylorcraft BC12-D · Mancelona, MIJul 6, 1976 · N43873 · Substantial damage NTSB CHI76FEM47Accident · No injuriesClosedLuscombe 8A · Fruitport, MIJun 22, 1976 · N45589 · Substantial damage NTSB CHI76FEM42Accident · Serious injuriesClosedPiper J-3 · Sparta, MIMay 20, 1976 · N98045 · Substantial damage NTSB CHI76FEC33Accident · No injuriesClosedChampion 7FC · Jackson, MIMar 14, 1976 · N9805Y · Substantial damage NTSB CHI76FEM02Accident · Serious injuriesClosedPiper J3-85C · Acme, MIJul 13, 1975 · N7174H · Substantial damage NTSB CHI75FEC54Accident · No injuriesClosedPiper J3 · Ann Arbor, MIJun 8, 1975 · N21647 · Substantial damage NTSB CHI75DEM43Accident · No injuriesClosedLuscombe 8A · Oshtemo, MIMay 23, 1975 · N71101 · Substantial damage NTSB CHI75DEM39Accident · No injuriesClosedLuscombe 8A · Marquette, MIMay 11, 1975 · N1117B · Substantial damage NTSB CHI75DEM32Accident · No injuriesClosedAeronca 11AC · Ontonagon, MIMar 19, 1975 · N85931 · Substantial damage NTSB CHI75FEC24Accident · Serious injuriesClosedPiper J3C-65 · Ypsilanti, MINov 22, 1974 · N2472C · Substantial damage NTSB CHI75FEC17Accident · No injuriesClosedLuscombe 8A · Napoleon, MIOct 9, 1974 · N72011 · Substantial damage NTSB CHI75FEC11Accident · No injuriesClosedTaylorcraft BC12-D · Durand, MIAug 18, 1974 · N96279 · Substantial damage NTSB CHI74FEM55Accident · Minor injuriesClosedAeronca 11AC · Grand Rapids, MIApr 27, 1974 · N9572E · Substantial damage NTSB CHI74DEM50Accident · No injuriesClosedLuscombe 8A · White Cloud, MIMar 31, 1974 · N45475 · Substantial damage NTSB CHI74FEM36Accident · No injuriesClosedAeronca 11AC · Charlotte, MIJan 12, 1974 · N86078 · Substantial damage NTSB CHI74DEM34Accident · No injuriesClosedAeronca 7AC · Ironwood, MIDec 23, 1973 · N83234 · Substantial damage NTSB CHI74DEC22Accident · Minor injuriesClosedTaylorcraft BC12-D · Owosso, MIDec 15, 1973 · N5123M · Substantial damage NTSB CHI74DEM15Accident · No injuriesClosedPiper PA-17 · Charlotte, MIAug 7, 1973 · N4847H · Substantial damage NTSB CHI73DEM59Accident · No injuriesClosedTaylorcraft BC12-D · Allegan, MIMay 10, 1973 · N96723 · Substantial damage NTSB CHI73FEC20Accident · Minor injuriesClosedLuscombe 8A · Belleville, MIDec 31, 1972 · N1468K · Substantial damage NTSB CHI73FEM04Accident · Serious injuriesClosedStewart Hdwnd · Allegan, MIJul 16, 1972 · N1145H · Substantial damage NTSB CHI72FEC29Accident · Minor injuriesClosedAeronca 7AC · Tecumseh, MIMar 11, 1972 · N2687E · Substantial damage NTSB CHI72DEM47Accident · No injuriesClosedLuscombe 8A · Atlanta, MIJan 30, 1972 · N72008 · Substantial damage NTSB CHI72FEM46Accident · No injuriesClosedAeronca 7AC · Kent, MIJan 23, 1972 · N1249E · Substantial damage NTSB CHI72FEC12Accident · No injuriesClosedAeronca 7AC · Millington, MISep 5, 1971 · N84546 · Substantial damage NTSB CHI72DEM25Accident · No injuriesClosedPiper J-3 · Fremont, MISep 4, 1971 · N6840H · Substantial damage NTSB CHI72FEM24Accident · No injuriesClosedPiper J3 · Otsego, MIAug 28, 1971 · N78521 · Substantial damage NTSB CHI71DBJ22Accident · No injuriesClosedAeronca 7AC · Pellston, MISep 5, 1970 · N1608E · Substantial damage