NTSB investigations: Continental A&C65 series
3,024 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, 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 ('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."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 FTW96LA150Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Salado, TXthe pilot's failure to maintain altitude/clearance from the power line.NTSB LAX96FA120Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Elk Grove, CAthe pilot's failure to see and avoid the obstruction.NTSB SEA96LA057Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Puyallup, WAthe owner's failure to comply with requirements for annual inspections of the airplane, and the debonding of the right brake lining and subsequent jamming of the lining into the right main wheel.NTSB CHI96LA078Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Mount Horeb, WIfailure of the pilot to see-and-avoid the pedestrian. Factors relating to the accident were: the pilot's inadequate preflight preparation, his landing on a closed airstrip, and the snow covered terrain.NTSB CHI96LA069Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12 · Winner, SDthe pilot's failure to maintain airspeed during takeoff. A factor was the pilot's diversion of his attention to a perceived engine problem.NTSB NYC96LA043Accident · No injuriesLimited investigationFinal reportPiper J3F · Westerly, RIthe pilot's inadequate compensation for the wind condition, which subsequently resulted in the aircraft nosing over. The gusty crosswind condition was a related factor.NTSB NYC96LA030Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Kutztown, PAthe pilot's improper use of brakes during the landing roll resulting in the airplane nosing over.NTSB CHI96LA023Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Lapeer, MIfuel exhaustion resulting in engine failure, the inadvertant stall, and improper decision by the pilot to attempt a large heading change at low altitude and airspeed. A factor relating to this accident is no fuel quantity gage installed in the airplane.NTSB ATL95LA167Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Mooresville, NCThe pilot's improper use of the carburetor heat resulting in the formation of carburetor ice and subsequent loss of engine power.NTSB NYC95LA208Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Andover, NJThe flight instructor's inadequate preflight which failed to detect an inadequate fuel supply which subsequently resulted in fuel exhaustion and the loss of engine power.NTSB BFO95LA083Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Warren, OHa loss of engine power/performance for undetermined reasons. Related factors were: the pilot exceeding the airplane's maximum takeoff weight, carburetor icing conditions, a tailwind, and high temperature.NTSB FTW95LA351Accident · Serious injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Abilene, TXThe pilot's inadvertent stall as result of an abrupt maneuver. A factor was the loss of engine power for undetermined reasons.NTSB CHI95LA277Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · New Prague, MNthe failure of the pilot to maintain adequate airspeed to permit control of the aircraft and to prevent an inadvertent stall. Contributing factors include gusty wind conditions and turbulence.NTSB FTW95LA312Accident · No injuriesLimited investigationFinal reportPiper J3C · Englewood, COA partial power loss due to a stuck number four exhaust valve. A factor was the lack of suitable terrain for a forced landing.NTSB CHI95FA212Accident · 1 fatalField investigationFinal reportTaylorcraft BC-65 · Plato Center, ILthe pilot not maintaining an adequate fuel supply, and not maintaining airspeed.NTSB NYC95LA151Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · North Benton, OHFuel starvation for an unknown reason, resulting in a loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB NYC95LA141Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Smoketown, PAfailure of the pilot to follow the recommended starting procedures.NTSB NYC95LA177Accident · No injuriesLimited investigationFinal reportPincince Corbin Baby ACE · Palmer, MAcontamination in the carburetor which resulted in fuel starvation, a total loss of engine power and forced landing.NTSB CHI95LA203Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Hampshire, ILthe pilot's failure to attain liftoff speed. A factor in the accident was the ditch.NTSB NYC95LA133Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Yellow Springs, OHinadequate visual lookout by the pilot which resulted in the airplane striking the tower.NTSB SEA95LA115Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Medford, ORAn unreliable fuel quantity gage and an inadequate preflight. The tall vegetation in the landing area was a factor.NTSB ATL95LA102Accident · Serious injuriesLimited investigationFinal reportBurchfield Rose Parakeet · Tuscaloosa, ALThe pilot's inadequate preflight. Factors in the accident were the previous wing damage, and the obstruction of air flow over the aileron.NTSB NYC95LA131Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12 · Geneseo, NYThe pilot's inadequate preflight inspection, which failed to detect water-contaminated fuel which resulted in the loss of engine power. Also causal was the pilot's failure to maintain airspeed during the forced landing, which resulted in the inadvertent…NTSB NYC95LA118Accident · Serious injuriesLimited investigationFinal reportAeronca O-58B · Moscow, PAThe pilot's inadequate compensation for a cross wind and his failure to maintain adequate obstacle clearance. A factor is the crosswind.NTSB SEA95LA098Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Vancouver, WACarburetor heat was not used and aircraft control was not maintained. Factors to the accident were: the flight instructor's diverted attention, and carburetor icing conditions.NTSB FTW95LA190Accident · Serious injuriesLimited investigationFinal reportGrunska Earl J Baby ACE D · Paris, ARThe pilot's failure to maintain minimum required airspeed for flight, resulting in an inadvertent stall. A factor was the partial loss of power for undetermined reasons.NTSB CHI95LA127Accident · No injuriesLimited investigationFinal reportPiper J3C · Poplar Grove, ILThe student pilot's excessive throttle control and the certified flight instructor's inadequate supervision of the student. A factor in the accident was the gusty wind conditions.NTSB SEA95FA072Accident · 1 fatalField investigationFinal reportAeronca 7AC · Brush Prairie, WAUndetermined.NTSB LAX95LA150Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · El Cajon, CAa loss of engine power due to an in-flight separation of the fuel system gascolator glass bowl resulting in a premature fuel exhaustion. The rough/uneven terrain is a factor in this accident.NTSB BFO95LA037Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Zanesville, OHthe pilot's failure to maintain control of the airplane while taxiing after landing. Related factors were the unfavorable (gusty) wind condition, and the pilot's improper compensation for wind conditions.NTSB ATL95LA071Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Dauphin Island, ALThe pilot's improper use of the rudder control which resulted in a stall, and improper use of the elevator control, in that he maintained back pressure after the stall entry, keeping the airplane in a stalled conditions.NTSB CHI95LA084Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Kenosha, WIthe student's failure to maintain directional control during the landing roll.NTSB LAX95LA093Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Big Bear City, CAThe pilot's improper recovery FR0M a bounced landing, and his failure to attain adequate airspeed in unfavorable wind conditions for an attempted go-around (aborted landing), which resulted in a stall/mush and a dragged wingtip. Factors related to the…NTSB BFO95LA018Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Sabinsville, PAThe pilot's inadequate visual lookout during cruise flight which resulted in inflight collision with wires.NTSB FTW95LA026Accident · Serious injuriesLimited investigationFinal reportGeorge Spacewalker 1 · Mountain View, OKThe pilot's failure to maintain minimum required airspeed for flight.NTSB CHI94DET02Accident · Minor injuriesFinal reportSimcox Sport Trainer · Laporte, INThe pilot's continued operation with a known power deficiency. The loss of engine power was a factor in the accident.NTSB SEA94LA239Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Nampa, IDDirectional control was not maintained. A factor to the accident was: inadequate supervision.NTSB MIA94LA202Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12-D · Punta Gorda, FLThe failure of the pilot-in-command to tiedown the airplane prior to attempting an engine start by hand propping. Contributing to the accident was the pilot's complacency.NTSB BFO94LA142Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Leesburg, OHThe pilot misjudged his altitude and airspeed during landing resulting in an overrun and collision with a fence. A related factor was the wet runway.NTSB NYC94LA141Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT-13 · Readington, NJThe failure of both pilots to maintain adequate visual lookout.NTSB NYC94LA140Accident · Serious injuriesLimited investigationFinal reportAces High Cuby B · Waterbury, CTA loss of engine power for undetermined reasons.NTSB LAX94LA295Accident · No injuriesLimited investigationFinal reportPiper J-3C-65 · Jackson, CAthe pilot's inadequate compensation for the gust of wind and subsequent loss of directional control.NTSB FTW94LA252Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Waller, TXThe pilot's failure to maintain proper clearance during takeoff.NTSB MIA94LA180Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Lutz, FLThe certified flight instructor's improper supervision of the student pilot during a wheel landing resulting in an on ground loss of control (inadvertent ground loop). Contributing to the accident was the student pilot's improper use of flight controls and…NTSB SEA94FA163Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Seeley Lake, MTThe pilot in command's failure to maintain flying airspeed.NTSB FTW94LA215Accident · No injuriesLimited investigationFinal reportPiper J4A · Granite Shoals, TXFuel system starvation due to the pilot's failure to secure the engine fuel primer. A factor was the lack of suitable terrain for the forced landing.NTSB CHI94LA199Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Clear Lake, MNthe private pilot's failure to maintain directional control during the landing roll. Related factors are the rough/uneven terrain, and excessive brake application.NTSB CHI94LA194Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Peoria, ILthe pilot's misjudged landing flare. A factor associated with the accident is the pilot allowing the airplane to descend at an excessive rate.NTSB ANC94LA066Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Naknek, AKThe pilot's failure to maintain airspeed above the stall speed during maneuvering flight.NTSB CHI94LA158Accident · Minor injuriesLimited investigationFinal reportAeronca 11AC · Montello, WIthe pilot's inadequate compensation for the wind conditions. A factor related to the accident was the crosswind.