NTSB investigations: Continental IO-346 series

224 cases on aircraft whose registry engine model is Continental IO-346 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 ('17033'))
  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 MIA93LA116Accident · No injuriesLimited investigationFinal reportBeech A23A · Fort Myers, FLTotal loss of engine power due to fuel exhaustion and poor preflight planning/preparation by the pilot in command. Contributing to the accident was the pilot's failure to request winds aloft during the weather briefing.May 4, 1993 · N2312W · Substantial damageNTSB ATL91LA097Accident · No injuriesLimited investigationFinal reportBeech 23 · Dothan, ALThe failure of the cylinder head because of previous overheated operations. Factors in the accident were the pilot's inaccurate approach which resulted in the loss of directional control and subsequent swerve into the fence.May 18, 1991 · N3549R · Substantial damageNTSB ATL91LA022Accident · No injuriesLimited investigationFinal reportBeech A23A · Franklin, NCThe pilots failure to maintain directional control during landing. The presence of gusting crosswinds was a factor in the accident.Nov 29, 1990 · N3696Q · Substantial damageNTSB FTW90DPJ11Accident · No injuriesFinal reportDooley Mustang MII · Cashion, OKThe separation of a 14 inch section of one propeller blade due to previous damage.Sep 15, 1990 · N7015A · DestroyedNTSB MKC90LA066Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Fordyce, ARThe passenger's intentional interference with the flight by seizing the controls and shutting off the engine.Mar 17, 1990 · N3520R · Substantial damageNTSB LAX90LA037Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Reedley, CAPilot's improper recovery from a bounce landing.Nov 18, 1989 · N3551R · Substantial damageNTSB ATL90LA018Accident · No injuriesLimited investigationFinal reportBeech A23A · Roopville, GAThe pilot's disregard for a tailwind during landing, his delay in executing a go around when he noted excessive speed during the landing roll, and improper go around procedures.Oct 29, 1989 · N6929Q · Substantial damageNTSB MKC87LA177Accident · Minor injuriesLimited investigationFinal reportBeech A23A · Wentzville, MOThe airplane became airborne after 1000 feet. A witness stated that after climbing to abt 10 feet, the right wing dropped almost to the ground. The acft then pulled up sharply to almost vertical and stalled at abt 75 feet above the ground and collided with a…Sep 23, 1987 · N6958Q · Substantial damageNTSB BFO87LA035Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Ravenswood, WVThe pilot was providing free promotional rides for a flight school. He was on the fourth flight of the day, on final approach, in a nose high attitude when the aircraft's left wing struck small trees. The aircraft impacted the ground 250FEET short of the…May 9, 1987 · N3543R · DestroyedNTSB MIA87LA109Accident · No injuriesLimited investigationFinal reportBeech A23 · Palatka, FLThe pilot stated that he 'had to make downwind landing due to traffic & direction from UNICOM operator. Landing was fast due to downwind, but not hard. Nose wheel collapsed during rollout with stall warning blowing. Plane gently nosed over & stopped at the…Mar 15, 1987 · N8883M · Substantial damageNTSB ATL86FA082Accident · 2 fatalField investigationFinal reportBeech A23 · Russellville, ALOutboard half of one propeller blade separated during cruise flight. During the subsequent forced landing attempt the acft struck trees, severing the right wing, and crashed inverted. Front occupant seats separated from seat tracks. Examination of propeller…Feb 27, 1986 · N3536R · Substantial damageNTSB CHI86LA072Accident · No injuriesLimited investigationFinal reportBeech A23A · Hastings, MIThe pilot estimated he had 13 gallons of fuel on board for the estimated fifty minute flight. He estimated his fuel burn at nine gallons per hour giving him an hour and twenty five minute fuel endurance. He ran out of fuel an hour and twenty five minutes…Jan 18, 1986 · N6900Q · Substantial damageNTSB NYC84LA299Accident · No injuriesLimited investigationFinal reportBeech A23A · Mansfield, MAAfter a night landing, the plt went to the end of the rwy, then started a 180 deg turn to the right onto a parallel taxiway. He intended to head the opposite direction on the taxiway, which was not lighted. As he turned, the landing light (installed on the…Sep 2, 1984 · N613AW · Substantial damageNTSB NYC84LA183Accident · No injuriesLimited investigationFinal reportBeech A23 · Matawan, NJLanding long at night to avoid unseen obstructions, the pilot misjudged his touchdown point and ran off the end of the rwy, colliding with brushy vegitation.May 23, 1984 · N1404L · Substantial damageNTSB ATL83FKG01Accident · 1 fatalFinal reportBeech A23 · Junnel Hill, GADuring takeoff, the engine lost power at about 700 ft AGL. A forced landing was made in a pasture that was hilly with a gully running through it. During the landing, the aircraft first contacted the top of a small Hill in the pasture, then became airborne a…Nov 8, 1982 · N3513R · Substantial damageNTSB CHI82DA287Accident · No injuriesFinal reportBeech A23A · Grantsburg, WIThe pilot could not start the aircraft with the mixture in the normal (rich) position. The mixture was set to lean and the engine started. During takeoff, the engine lost power and the pilot landed off the end of the runway. This was the first flight since an…Jul 31, 1982 · N3683Q · Substantial damageNTSB DEN82DA135Accident · No injuriesFinal reportBeech A23 · Oakes, NDDuring a night landing, the aircraft touched down about 220 ft short of the approach end of the runway. Reportedly, the wheels struck a "washout" and the plane was substantially damaged.Jul 16, 1982 · N8878M · Substantial damageNTSB CHI81FER53Accident · No injuriesClosedBeech A23 · Superior, WIJul 25, 1981 · N1470L · Substantial damageNTSB CHI81FEI24Accident · No injuriesClosedBeech A23 · Wooster, OHJun 29, 1981 · N3554R · Substantial damageNTSB SEA80DYE44Accident · No injuriesClosedBeech A23 · Morton, WAJul 18, 1980 · N1466L · DestroyedNTSB CHI80FEI19Accident · No injuriesClosedBeech A-23 · New Phila, OHMay 3, 1980 · N3528R · Substantial damageNTSB MKC80FTK06Accident · No injuriesClosedBeech A23 · Tea, SDDec 9, 1979 · N3580R · Substantial damageNTSB NYC80FGM03Accident · Minor injuriesClosedBeech A23 · Bradford, PAOct 22, 1979 · N8865M · Substantial damageNTSB NYC78FFJ31Accident · No injuriesClosedBeech B23 · Reading Center, NYJul 25, 1978 · N1427L · Substantial damageNTSB MIA78FLG02Accident · No injuriesClosedBeech A23-A · Iva, SCOct 30, 1977 · N2308W · Substantial damageNTSB IAD77FIG28Accident · No injuriesClosedBeech 23 · Gaithersburg, MDJul 23, 1977 · N6VT · Substantial damageNTSB OAK77FXQ27Accident · Serious injuriesClosedBeech A23A · Lake Tahoe, CAJul 16, 1977 · N2362W · Substantial damageNTSB FTW77DQG40Accident · No injuriesClosedBeech B-23 · Dumas, TXJul 16, 1977 · N3585R · Substantial damageNTSB MKC77DER21Accident · No injuriesClosedBeech A-23 · Goodland, MNFeb 20, 1977 · N3580R · Substantial damageNTSB NYC76FGM43Accident · No injuriesClosedBeech A-23 · Somerset, PAAug 10, 1976 · N3557R · Substantial damageNTSB MKC76DTK32Accident · No injuriesClosedBeech A23A · Prairie City, SDAug 10, 1976 · N3541R · Substantial damageNTSB CHI76FEV08Accident · No injuriesClosedBeech A23 · Maquon, ILAug 4, 1975 · N8878M · Substantial damageNTSB IAD75DHD55Accident · No injuriesClosedBeech A23A · Wyoming, DEJun 24, 1975 · N2310W · Substantial damageNTSB FTW75FPD40Accident · No injuriesClosedBeech A23A · Fort Worth, TXMay 14, 1975 · N2312W · Substantial damageNTSB FTW75FPA23Accident · Minor injuriesClosedBeech A23A · Plano, TXMar 30, 1975 · N2327W · DestroyedNTSB NYC75DNJ29Accident · No injuriesClosedBeech A23 · White Plains, NYMar 6, 1975 · N1477L · Substantial damageNTSB NYC75DHM06Accident · No injuriesClosedBeech A23A · Colts Neck, NJAug 30, 1974 · N3696Q · Substantial damageNTSB CHI74FEI43Accident · No injuriesClosedBeech A23 · Tiffin, OHJun 11, 1974 · N1433L · Substantial damageNTSB MKC74DER52Accident · No injuriesClosedBeech A23 · Sleepy Eye, MNJun 3, 1974 · N3560R · Substantial damageNTSB DEN74FQA29Accident · No injuriesClosedBeech A23 · Santa Rosa, NMFeb 23, 1974 · N3529R · Substantial damageNTSB OAK74FVG23Accident · No injuriesClosedBeech A23A · Fair Oaks, CAJan 23, 1974 · N8893M · Substantial damageNTSB IAD74DLQ07Accident · No injuriesClosedBeech A23 · Owensboro, KYSep 9, 1973 · N3524R · Substantial damageNTSB FTW74FPG03Accident · No injuriesClosedBeech A23A · N.Little Rock, ARJul 18, 1973 · N4797J · Substantial damageNTSB CHI73DET18Accident · No injuriesClosedBeech A23 · Griffith, INMar 18, 1973 · N3533R · Substantial damageNTSB CHI73AEM41Accident · No injuriesClosedBeech A23A · Allegan, MIFeb 19, 1973 · N2344W · Substantial damageNTSB NYC73DNC51Incident · No injuriesClosedBeech A23A · Claremont, NHFeb 4, 1973 · N202GS · Minor damageNTSB FTW73FPA18Accident · No injuriesClosedBeech A23 · Lancaster, TXNov 16, 1972 · N3590R · Substantial damageNTSB FTW73FPD15Accident · No injuriesClosedBeech A23 · Roanoke, TXNov 9, 1972 · N1473L · Substantial damageNTSB NYC73FHJ07Accident · No injuriesClosedBeech A23 · Central Islip, NYAug 31, 1972 · N3696Q · Substantial damageNTSB MIA72DKJ65Accident · No injuriesClosedBeech A23 · Catherine, ALJun 28, 1972 · N3532R · Substantial damage