NTSB investigations: Continental A&C75 series
619 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.
Cases, newest first
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.\"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."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" 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 FTW02LA163Accident · Minor injuriesLimited investigationFinal reportPiper J-5 · Greers Ferry, ARThe loss of engine power for undetermined reasons. A factor was the probability of carburetor ice.NTSB FTW02LA160Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Hinton, OKFuel exhaustion due to a fuel cap leak. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL02FA101Accident · 2 fatalField investigationFinal reportLuscombe LL-8-E · Olar, SCThe in-flight separation of the elevator push-pull control tube that resulted in a loss of flight control and subsequent collision with the ground.NTSB LAX02FA157Accident · Serious injuriesField investigationFinal reportErcoupe 415C · El Cajon, CAfuel starvation due to the mechanic's failure to properly tighten a fuel line fitting on the engine driven fuel pump, which led to a depletion of the fuel in the header tank. The mechanic's self induced pressure to complete the job prior to leaving on…NTSB SEA02LA062Accident · Minor injuriesLimited investigationFinal reportStadden Flybaby · Buhl, IDThe pilot's failure to return the carburetor heat to the OFF (cold) position prior to applying full power following a touch and go landing, which resulted in poor climb performance and the subsequent impact with a fence and collision with the ground. A…NTSB SEA02LA018Accident · No injuriesLimited investigationFinal reportLuscombe 8C · Olympia, WADirectional control not maintained during the landing roll. Factors include main gear overload and standing water on the runway.NTSB IAD02LA010Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Millbrook, NYpilot's inadvertent activation of the right brake during landing roll-out , which caused the airplane to nose over. A factor was the crosswind.NTSB CHI01LA275Accident · Serious injuriesLimited investigationFinal reportSchuetz Miniplane DSA-1 · Michigan City, INAircraft control not being maintained by the pilot. Contributing factors to the accident were the pilot maneuvering at a low airspeed, the encountered stall/spin, and the recovery from the spin at a low altitude, which resulted in altitude/clearance not being…NTSB FTW01FA151Accident · 1 fatalField investigationFinal reportErcoupe 415-CD · McAlester, OKthe inadvertent stall by the pilot-in-command.NTSB CHI01LA125Accident · No injuriesLimited investigationFinal reportPiper J5A · Brussels, ILthe partial loss of engine power for undetermined reasons and the high vegitation encountered during the precautionary landing.NTSB FTW01LA077Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Houston, TXthe pilot's failure to execute a go-around after becoming low on a visual approach.NTSB CHI00LA273Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Parsons, KSthe pilot not maintaining clearance from the fence post and not attaining the proper touchdown point. A factor was the fence post.NTSB CHI00LA162Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Joliet, ILthe engine failure for undetermined reasons. Factors were the low altitude, remedial action not possible by the pilot, and the ditch.NTSB MIA00LA180Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Stockbridge, GAan in-flight collision with trees while maneuvering, which was the result of the pilot not allowing adequate altitude to clear the trees before starting a turn.NTSB NYC00LA134Accident · 1 fatalLimited investigationFinal reportHing FLY Baby 1A · Keymar, MDAn overload failure of both flying wires, on the underside of the right wing, while the airplane was climbing, due to improper balance between the two flying wires, by unknown person(s).NTSB LAX00LA174Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Healdsburg, CAFailure of the flight review pilot to compensate for the crosswind and maintain flying speed during takeoff.NTSB FTW00LA129Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-D · Lindsay, TXThe student pilot's inadequate compensation for wind conditions. A factor was the downdraft wind condition.NTSB FTW00LA124Accident · No injuriesLimited investigationFinal reportLuscombe 8C · Galveston, TXThe pilot's inadequate preflight inspection, which resulted in the pilot attempting to takeoff with the elevator and ailerons locked by the passenger side seatbelt.NTSB NYC00LA087Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Rome, NYThe pilot inadvertently selecting the mixture control to off, resulting in a total loss of engine power.NTSB LAX00LA111Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · San Bernardino, CAthe total failure of the engine number 1 cylinder exhaust valve.NTSB MIA00LA061Accident · No injuriesLimited investigationFinal reportEaa Chapter 229 Zenair 601 · Kissimmee, FLThe pilot's failure to maintain directional control on landing resulting in the airplane going off the side of the runway and colliding with a barricade.NTSB CHI99LA242Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Bristol, WIthe pilot's failure to perform a proper recovery from the bounced landing, resulting in the airplane's nose gear striking the runway. A factor relating to the accident was the excessive airspeed maintained during the landing.NTSB CHI99LA236Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Wahoo, NEThe pilot's improper starting technique which resulted in the inadvertent starting of the engine, with no one in the airplane.NTSB LAX99LA233Accident · No injuriesLimited investigationFinal reportErcoupe E · Winnemucca, NVAn improperly installed and maintained float needle in the carburetor, which would not seat sufficiently to stop fuel flow and caused the engine to run excessively rich, resulting in a complete loss of engine power.NTSB DEN99LA069Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Fort Collins, COThe pilot's inadequate compensation for wind conditions. A factor was the gusty wind conditions.NTSB CHI99LA109Accident · No injuriesLimited investigationFinal reportPiper J5A · Wausau, WIthe loss of engine power for undetermined reasons and the lack of suitable terrain for landing. A factor to the accident was the aircraft owner not performing necessary maintenance to the aircraft.NTSB LAX99LA061Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · San Ysabel, CAA fatigue fracture of the crankshaft and the resulting separation of the propeller.NTSB ANC99WA010Accident · Minor injuriesForeign investigationPiper J3C-65 · Watson Lake, CanadaNTSB SEA98LA180Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Lincoln City, ORThe pilot's inadequate remedial action to correct for a crosswind gust. The crosswind gust was a factor.NTSB CHI98LA248Accident · Serious injuriesLimited investigationFinal reportForney 415-C · Laurie, MOthe jammed aileron and elevator controls for undetermined reasons.NTSB NYC98FA107Accident · 2 fatalField investigationFinal reportErcoupe ERCO-415C · New Lisbon, NYDetonation within the No. 2 cylinder resulting in melting and breaching of the piston, and the pilot's selection of unsuitable terrain for landing. Contributing factors were the uphill terrain encountered during the landing and the visual perception…NTSB MIA98LA004Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Trenton, GAfailure of the pilot to abort the takeoff, when he observed an indication of less than full engine power on the tachometer from the beginning of the takeoff roll. Factors relating to the accident were: the inadequate preflight planning and preparation by the…NTSB LAX97LA323Accident · No injuriesLimited investigationFinal reportNewberg PL-4A · Placerville, CAfailure of the pilot to maintain directional control of the aircraft during the rollout phase of the landing sequence, which resulted in a gound swerve.NTSB MIA97LA234Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Siler City, NCFailure of the pilot to obtain a preflight weather briefing, inaccurate weather evaluation by the pilot, and his poor in-flight planning decision for descending too low to read a road sign.NTSB SEA97LA197Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Elma, WAThe pilot's inadequate compensation for wind conditions while landing. A factor was the crosswind.NTSB NYC97LA146Accident · No injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Charleston, WVthe pilot's inadequate compensation for unfavorable (variable) wind conditions, and his failure to maintain directional control of the airplane. The wind condition and proximity of a hangar were related factors.NTSB ANC97LA079Accident · No injuriesLimited investigationFinal reportPiper J-5 · Wasilla, AKThe loss of engine power for an undetermined reason, and the noncertificated pilot's decision to perform a go-around after a suitable landing site had been attained. A factor associated with the accident was the rough and uneven terrain.NTSB FTW97LA172Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Canon City, COThe pilot's failure to maintain an adequate visual lookout. A factor was the pilot's attention being diverted.NTSB FTW97LA063Accident · No injuriesLimited investigationFinal reportErcoupe 415-D · Amarillo, TXfailure of the #1 exhaust valve, which resulted in loss of engine power and a forced landing on rough/uneven terrain. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB MIA96LA217Accident · No injuriesLimited investigationFinal reportPiper J3 · Aiken, SCthe pilot's improper flare, which resulted in a hard landing; and his loss of directional control, which was followed by impact with trees.NTSB CHI96LA311Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Cambridge, ILThe pilot's failure to maintain control of the airplane while landing. A factor associated with the accident was the downdraft reported by the pilot.NTSB IAD96LA049Accident · Minor injuriesLimited investigationFinal reportKitfox IV-1200 · Saluda, VAa partial loss of engine power due to spark plug failure, and the pilot's evasive maneuver to avoid lights at the end of the runway.NTSB BFO96LA038Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Hurlock, MDinadequate inspection by maintenance personnel which failed to detect a fatigue crack, and resulted in an in-flight crankshaft fracture and propeller assembly separation. A related factor was the deep snow encountered during the subsequent forced landing.NTSB CHI95LA334Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-D · Belleville, ILthe rupture of the oil pressure line which led to oil system exhaustion, the stuck intake valves, and the powerlines.NTSB ATL95LA123Accident · Minor injuriesLimited investigationFinal reportKnosp Corbin JR. ACE-E · Whiteville, NCContamination of the fuel system which resulted in fuel starvation and a total loss of engine power. .NTSB CHI95LA194Accident · No injuriesLimited investigationFinal reportPiper J-5A · Wausau, WIthe pilot's misjudgment of the clearance between the airplane and the fuel pumps.NTSB CHI95LA133Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Elk Creek, WIthe pilot's failure to maintain clearance with the trees. Factors in the accident include the trees, the tailwind condition, and the pilot's lack of proper certification.NTSB FTW95LA089Accident · No injuriesLimited investigationFinal reportInterstate S-1A · Amarillo, TXAn inflight fire, the reason for which was undetermined.NTSB NYC94LA153Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Scriba, NYThe pilot's failure to maintain adequate airspeed which resulted in a stall and inflight collision with trees.NTSB LAX94LA242Accident · Serious injuriesLimited investigationFinal reportHayes/Pietenpol AIR Camper · Blythe, CAThe pilot's unexpected encounter with a downdraft while flying at an improper altitude in mountainous terrain.