Skip to content

NTSB investigations: Continental A&C75 series, MO

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

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

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

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 CHI98LA248Accident · Serious injuriesLimited investigationFinal reportForney 415-C · Laurie, MOthe jammed aileron and elevator controls for undetermined reasons.Jul 12, 1998 · N99294 · Destroyed NTSB MKC88LA157Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Springfield, MOWhile attempting to depart a 1600 ft sod runway, the PIC said he was unable to get airborne and elected to abort the takeoff. Unable to stop, he went through a fence, substantially damaging both wings. The plt recommended not trying to takeoff from a short…Aug 13, 1988 · N93437 · Substantial damage NTSB MKC88LA113Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Florence, MOWhile on a personal flight, PIC said he began to lose engine power. He elected to make a precautionary ldg in a farm field, and during the roll out, the nose wheel struck a ditch. Post flt examination failed to reveal any cause for the partial power loss.Jun 19, 1988 · N94045 · Substantial damage NTSB MKC86LA087Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · St. Louis, MOThe plt reports that a wind squall passed over the arpt as he was landing. He said the acft encountered windshear at about 100 ft AGL on final apch and began to sink. The plt added pwr but could not stop the sink and the acft landed in a plowed field about 20…Apr 12, 1986 · N2578H · Substantial damage NTSB MKC85LA221Accident · Minor injuriesLimited investigationFinal reportLon J. Mcknight Flybaby 1A · Lebanon, MOAfter washing his aircraft the plt dptd the airport for a LCL flight. The flight lasted for approx. 30 min. When the plt stated the end began running rough. A precautionary landing was made to the airport. The acft stalled impacting the ground short of the…Sep 21, 1985 · N3826 · Substantial damage NTSB MKC85LA143Accident · Minor injuriesLimited investigationFinal reportShindler Special Great Lakes · Gentry, MOThe plt became disoriented on a cross-country flight from manhattan, Kansas, to marysville, Missouri. Flying off course for a short time, the plt regained his directions to his fueling stop. While returning to his intended fuel stop the acft eng stopped and a…Jun 29, 1985 · N8727 · Substantial damage NTSB MKC82DA117Accident · No injuriesFinal reportStinson HWW-75 · St. Louis, MOAccording to the pilot the fuel tank gauges indicated about one-eight full prior to a takeoff for a flight around the traffic pattern. After takeoff the engine quit and a forced landing was made in a soybean field. The aircraft nosed over during the landing…Jul 5, 1982 · N23710 · Substantial damage NTSB MKC78DCA49Accident · No injuriesClosedErco 415-C · Sullivan, MOSep 5, 1978 · N2400H · Substantial damage NTSB MKC76FCA19Accident · Minor injuriesClosedErco 415-C · Campbell, MOMar 28, 1976 · N93986 · Substantial damage NTSB MKC70DCG33Accident · No injuriesClosedLuscombe 8E · Amsterdam, MOJun 23, 1970 · N2541K · Substantial damage NTSB MKC69F0150Accident · Serious injuriesClosedErcoupe 415-C · New London, MOAug 3, 1968 · N2989H · Destroyed NTSB MKC68F0508Accident · No injuriesClosedErco 415-CD · Kansas City, MOApr 5, 1968 · N3904H · Substantial damage NTSB MKC65A0070Accident · 1 fatalClosedErcoupe 415CD · Savannah, MOJun 1, 1965 · N94696 · Destroyed NTSB MKC65F0131Accident · No injuriesClosedErcoupe 415CD · Osceola, MOApr 24, 1965 · N2786H · Substantial damage