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.

NTSB LAX92FA211Accident · 2 fatalField investigationFinal reportTaylorcraft BL · Chandler, AZAn excessive pull-up during departure and a failure of the pilot to maintain adequate airspeed, resulting in an inadvertent stall/spin. Contributing to the accident was continued flight operations with known airworthiness deficiencies.May 19, 1992 · N26535 · Substantial damageNTSB ATL92LA081Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Elgin, SCThe improperly installed spark plug by an unknown person. The lack of suitable terrain for a forced landing was a factor.Apr 16, 1992 · N2901E · Substantial damageNTSB SEA92LA060Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Vancouver, WAThe pilot's failure to maintain the proper rate of descent.Mar 15, 1992 · N1127B · Substantial damageNTSB ATL92LA056Accident · Serious injuriesLimited investigationFinal reportJR. Ace E · Statesville, NCThe pilot's failure to maintain altitude during a steep turn at low level.Mar 8, 1992 · N1337M · Substantial damageNTSB NYC92LA066Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Gibson Island, MDThe pilot's failure to maintain proper altitude and clearance with water, which resulted in an in flight collision with water. Contributing to the accident was the pilot allowed the airplane to descend while making a right turn.Feb 23, 1992 · N96023 · Substantial damageNTSB CHI92LA097Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Alpena, MIThe student pilot's failure to attain the proper touchdown point. Related factors are his misjudged approach and failure to take remedial action.Feb 21, 1992 · N1405K · Substantial damageNTSB ANC92LA037Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Sitka, AKThe pilot/flight instructor's loss of directional control during the landing roll and the subsequent ground loop/swerve. Contributing to the accident was the gusty crosswind condition.Feb 17, 1992 · N82380 · Substantial damageNTSB NYC92LA060Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-20 · Isle Au Haut, MEFuel system icing and contamination which resulted in a loss of engine power and subsequent stall and loss of control during a forced landing.Feb 15, 1992 · N36142 · Substantial damageNTSB SEA92LA043Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-65 · West Jordan, UTThe pilot in command's failure to maintain control of the aircraft. A factor contributing to the accident was gusty wind conditions.Feb 8, 1992 · N50659 · Substantial damageNTSB 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 damageNTSB LAX92T#A02Accident · No injuriesClass 3Final reportPiper J3 · San Carlos, AZJan 30, 1992 · N2BM · Substantial damageNTSB SEA92LA038Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Chehalis, WAThe failure of the pilot to attain the proper touchdown point for landing. A factor relating to the accident was the poor braking conditions on the wet grass strip.Jan 18, 1992 · N39298 · Substantial damageNTSB ATL92LA036Accident · Serious injuriesLimited investigationFinal reportMosley HS GN-1 · Cullman, ALThe pilot's failure to maintain a safe flying speed.Jan 11, 1992 · N3202F · Substantial damageNTSB FTW92LA037Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Southlake, TXThe pilots failure to maintain directional control of the airplane. A factor was improper airspeed prior to touchdown which resulted in a hard landing.Dec 7, 1991 · N45722 · Substantial damageNTSB CHI92LA049Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Decorah, IAInadequate compensation for wind conditions, which resulted in a loss of directional control. Factors related to the accident were: the unfavorable wind conditions, snow covered runway, and snowbanks adjacent to the runway.Nov 27, 1991 · N44061 · Substantial damageNTSB NYC92FA026Accident · 2 fatalField investigationFinal reportPiper L-3 · Plymouth, MAThe improper decision by the non-instrument-rated pilot to attempt VFR flight in instrument meteorological conditions, at a low altitude, which resulted in a collision with the water. Factors related to the accident were: the overconfidence of the pilot in…Nov 3, 1991 · N6AN · DestroyedNTSB NYC92LA008Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12D · Townshend, VTThe pilot allowed the speed of the airplane to get too slow, resulting in inadvertent stall at too low an altitude to allow recovery.Oct 14, 1991 · N5014M · Substantial damageNTSB SEA92LA009Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Rawlins, WYAn inadequate weather evaluation. Factors to the accident were: gusts and crosswind.Oct 11, 1991 · N2015B · Substantial damageNTSB CHI91LA298Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Sunset Hills, MOA blocked fuel system line and inadequate maintenance of the airplane by other maintenance personnel.Sep 26, 1991 · N96905 · Substantial damageNTSB NYC91LA231Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC/2D · Rangeley, MEImproper takeoff planning by the pilot which resulted in an inflight collision with trees during initial climb. A factor related to the accident was the pilot's decision not to use the full lake surface available for takeoff.Sep 8, 1991 · N95123 · Substantial damageNTSB ATL91LA167Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Calhoun, GAThe pilot's failure to maintain directional control during the go-around attempt. Factor(s) in this accident were: the excessive airspeed at touchdown, and the pilot's lack of experience in this model of airplane.Sep 1, 1991 · N43LT · Substantial damageNTSB MIA91FA209Accident · 2 fatalField investigationFinal reportAeronca 7AC · Dawson, GAThe pilot in command's failure to maintain altitude while maneuvering.Aug 28, 1991 · N84216 · DestroyedNTSB ATL91LA159Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Newton, GAThe failure of the pilot-in-command to maintain an adequate visual lookout for obstacles.Aug 15, 1991 · N84692 · Substantial damageNTSB NYC91LA201Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · Westerly, RIEngine failure for an undetermined reason. A factor was the pilot misjudging the clearance over a fence during an attempted forced landing.Aug 6, 1991 · N30837 · Substantial damageNTSB ATL91LA154Accident · No injuriesLimited investigationFinal reportPiper J3C · Middlesex, NCThe pilot's failure to maintain airspeed while maneuvering in a turn on initial climb out resulting in a stall.Aug 5, 1991 · N2139M · Substantial damageNTSB MIA91LA191Accident · No injuriesLimited investigationFinal reportAeronca 65-LB · Hilliard, FLFailure of the pilot to maintain a proper glidepath during final approach resulting in the inflight collision with trees then the ground.Jul 26, 1991 · N31864 · Substantial damageNTSB CHI91LA229Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Lake Geneva, WIAircraft control was not maintained by the pilot. Factors related to the accident were a quartering tailwind.Jul 25, 1991 · N28580 · Substantial damageNTSB ATL91FA138Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Mobile, ALThe failure of the pilot to maintain airspeed and his subsequent inadvertent stall during his attempt to return to the departure runway. A factor was the loss of engine power for undetermined reasons.Jul 20, 1991 · N96802 · DestroyedNTSB SEA91LA162Accident · Minor injuriesLimited investigationFinal reportAeronca 65-CA · West Jordan, UTThe pilot's delayed switching of the fuel tank selector, the engine failure from fuel starvation and the unsuitable terrain for a forced landing.Jul 7, 1991 · N36831 · Substantial damageNTSB SEA91FA156Accident · 2 fatalField investigationFinal reportChampion 7AC · Burns, ORImproper inflight planning/decision by the student pilot (pilot-in-command), and his failure to maintain adequate airspeed, which resulted in a stall. Factors related to the accident were: physical impairment of the student pilot/owner/operator from carbon…Jul 6, 1991 · N3006E · Substantial damageNTSB MIA91LA174Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Brooker, FLFailure of the noncertificated pilot to obtain a weather briefing before departure & failure to maintain directional control after the precautionary landing. Contributing to the accident was lack of suitable terrain.Jun 29, 1991 · N98337 · Substantial damageNTSB LAX91LA237Accident · No injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Antioch, CAThat the pilot's preflight was improper; that he departed with the carburetor heat on; failed to abort when it became evident that the airplane was not going to take off; and abruptly lifting the airplane so that it became airborne in ground effect, but then…Jun 1, 1991 · N49173 · Substantial damageNTSB LAX91LA215Accident · No injuriesLimited investigationFinal reportTaylorcraft DC12-D · Las Vegas, NVThe failure of the pilot to maintain directional control of the aircraft. A factor in the accident was the pilot's lack of total experience in this type of aircraft.May 16, 1991 · N49368 · Substantial damageNTSB ATL91LA092Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Statesboro, GAFailure of both pilots to perform a visual lookout sufficiently adequate to avoid a collision at an uncontrolled airport. Factors related to the accident were: failure of the pilot of N95170 to communicate on the common traffic advisory frequency (CTAF) and…May 11, 1991 · N95170 · 2 aircraft · Substantial damageNTSB LAX91LA201Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Madera, CAThat the pilot failed to properly recover from a bounced landing. Contributing to this accident was the pilot's lack of experience in the airplane.May 6, 1991 · N86295 · Substantial damageNTSB MIA91LA130Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Leesburg, FLThe failure of the pilot to maintain directional control during the landig roll, and his failure to maintain airspeed during the attempted go-around which resulted in a descent and collision with two parked airplanes. Contributing to the accident was the…Apr 28, 1991 · N84986 · Substantial damageNTSB NYC91LA117Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Whitefield, NHInadequate compensation for wind conditions by the pilot which resulted in a loss of directional control. A factor contributing to the accident was the gusty wind conditions.Apr 16, 1991 · N1303E · Substantial damageNTSB LAX91LA153Accident · No injuriesLimited investigationFinal reportPiper J3 · Arbuckle, CAThat the pilot used excessive brakes during the landing roll-out.Mar 31, 1991 · N42257 · Substantial damageNTSB LAX91LA145Accident · Serious injuriesLimited investigationFinal reportAeronca 7-AC · No. Las Vegas, NVThe pilot's failure to maintain airspeed.Mar 25, 1991 · N84025 · DestroyedNTSB ATL91LA058Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Union Springs, ALThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground swerve.Feb 16, 1991 · N85880 · Substantial damageNTSB NYC91LA072Accident · Minor injuriesLimited investigationFinal reportPiper J-3-C · Hamilton, OHThe failure of the pilot-in-command to touchdown in a suitable area after he experienced a power loss. A factor related to the accident was the improperly maintained carburetor.Feb 4, 1991 · N6337H · Substantial damageNTSB LAX91LA077Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Bakersfield, CAThat the pilot failed to properly compensate for the wind conditions. Contributing to this accident was the existing crosswind.Jan 19, 1991 · N71745 · Substantial damageNTSB MIA91LA052Accident · Serious injuriesLimited investigationFinal reportAeronca L-3C · Brooksville, FLTotal loss of engine power due to undetermined reasons.Dec 23, 1990 · N52350 · Substantial damageNTSB CHI91DEM02Accident · 1 fatalFinal reportTaylorcraft BC12-D1 · North Muskegon, MIThe pilot-in-command's not maintaining sufficient airspeed and entering into an inadvertent stall. Factors related to this accident were fuel starvation and the pilot-in-command's not selecting a proper fuel tank selector position.Dec 11, 1990 · N44350 · Substantial damageNTSB FTW91LA022Accident · No injuriesLimited investigationFinal reportTaylorcraft DC-65 · Boerne, TXThe pilot's inability to climb over obstacles due to encountering a downdraft which exceeded the climb capability of the airplane. Factors in the accident were the gusty wind conditions and the downdraft.Dec 9, 1990 · N61080 · Substantial damageNTSB FTW91DRD02Accident · 2 fatalFinal reportPiper PA-J3C-65 · Mer Rouge, LAAn inadvertent stall at an altitude too low to allow for recovery.Nov 24, 1990 · N6100H · DestroyedNTSB CHI91LA005Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Ashland, KSThe pilot-in-command's exceeding the proper climb rate of the aircraft, and his not maintaining control of the aircraft to prevent a stall.Oct 6, 1990 · N45606 · Substantial damageNTSB FTW90LA184Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Fort Worth, TXThe pilot in command's failure to maintain directional control. The crosswind was a factor.Sep 22, 1990 · N67631 · Substantial damageNTSB ANC90FA167Accident · 2 fatalField investigationFinal reportTaylorcraft DCO-75 · Mckinley Park, AKFailure of both pilots to maintain adequate visual lookout to see-and-avoid other aircraft.Sep 8, 1990 · N49032 · 2 aircraft · DestroyedNTSB LAX90DUJ09Accident · 1 fatalFinal reportStits SA6B · Tucson, AZThe failure of the pilot to maintain aircraft control.Aug 23, 1990 · N4203 · Substantial damage