Skip to content

NTSB investigations: Continental A&C65 series, MS

23 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 per year

19642026

Where

Latest cases

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" = 'MS' 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\" = 'MS' 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" = 'MS' 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 ERA14CA267Accident · No injuriesData collectionFinal reportChampion Aeronca 7AC · Port Gibson, MSThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was sun glare.Apr 19, 2014 · N82206 · Substantial damage NTSB ERA09CA543Accident · No injuriesData collectionFinal reportPiper J3C-65 · Rosedale, MSThe failure of the pilots to maintain airspeed following a reported partial loss of engine power.Jun 28, 2008 · N42156 · Substantial damage NTSB MIA05LA059Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Brookhaven, MSThe pilot's inadequate compensation for wind and his failure to maintain control of the airplane during landing, which resulted in the airplane ground looping.Feb 16, 2005 · N39057 · Substantial damage NTSB ATL00LA067Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Tylertown, MSLoss of directional control due to separation of the tail-wheel spring assembly. A factor was the ditch which run adjacent to the runway.Jun 23, 2000 · N85861 · Substantial damage NTSB MIA92LA097Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · Church Hill, MSThe pilot's failure to clear his engine during descent resulting in the spark plugs becoming fouled which resulted in loss of engine power.Feb 6, 1992 · N88380 · Substantial damage NTSB ATL82FA243Accident · 1 fatalField investigationFinal reportAeronca 7AC · Greenwood, MSPilot was flying to spot deer. When deer were spotted pilot banked steeply to get better look, stalled and only had time to level wings before ground impact.Aug 23, 1982 · N67JH · Destroyed NTSB ATL80DKQ11Accident · No injuriesClosedAeronca 7AC · Leland, MSJun 27, 1980 · N2942E · Substantial damage NTSB MIA77KK019Accident · No injuriesClosedLuscombe 8A · Louisville, MSJun 14, 1977 · N71127 · Destroyed NTSB MIA77FKQ06Accident · Minor injuriesClosedAeronca 7AC · Madison, MSJan 22, 1977 · N1956E · Substantial damage NTSB MIA76DKQ17Accident · No injuriesClosedAeronca 7AC · Hollandale, MSSep 14, 1975 · N83946 · Substantial damage NTSB MIA71FKQ34Accident · Minor injuriesClosedPiper J3C · Minter City, MSMay 14, 1971 · N33598 · Substantial damage NTSB MIA71FKQ04Accident · Minor injuriesClosedAeronca 7AC · Pascagoula, MSAug 6, 1970 · N85083 · Substantial damage NTSB MIA70F0080Accident · Minor injuriesClosedPiper J3C · Bentonia, MSAug 1, 1969 · N92191 · Substantial damage NTSB MIA69F0169Accident · Serious injuriesClosedAeronca 7AC · Schlater, MSOct 2, 1968 · N82181 · Substantial damage NTSB MIA68F0308Accident · No injuriesClosedPiper J-3 · Prentiss, MSDec 2, 1967 · N3235N · Substantial damage NTSB MIA68D0293Accident · No injuriesClosedPiper J3C-65 · Benoit, MSNov 26, 1967 · N6681H · Substantial damage NTSB MIA68F0148Accident · Serious injuriesClosedPiper J3C-65 · Hollandale, MSAug 23, 1967 · N7009H · Destroyed NTSB MIA67F0188Accident · No injuriesClosedPiper J-3 · Clarksdale, MSOct 1, 1966 · N92627 · Substantial damage NTSB MIA67D0165Accident · No injuriesClosedPiper J3C · Shelby, MSAug 31, 1966 · N78405 · Substantial damage NTSB MIA66F0610Accident · No injuriesClosedLuscombe 8A · Meridian, MSJun 20, 1966 · N1057K · Substantial damage NTSB MIA65F0061Accident · Serious injuriesClosedAeronca 7AC · Bay St.Louis, MSApr 17, 1965 · N82527 · Substantial damage NTSB UNK65X1482Accident · Serious injuriesClosedPiper J3 · Belzoni, MSApr 5, 1965 · N30352 · Destroyed NTSB UNK64X2073Accident · No injuriesClosedAeronca 7AC · Mantee, MSJun 2, 1964 · N3600E · Substantial damage