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.
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" 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 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.NTSB 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.NTSB 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.NTSB FTW90DPJ11Accident · No injuriesFinal reportDooley Mustang MII · Cashion, OKThe separation of a 14 inch section of one propeller blade due to previous damage.NTSB MKC90LA066Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Fordyce, ARThe passenger's intentional interference with the flight by seizing the controls and shutting off the engine.NTSB LAX90LA037Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Reedley, CAPilot's improper recovery from a bounce landing.NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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.NTSB CHI81FER53Accident · No injuriesClosedBeech A23 · Superior, WINTSB CHI81FEI24Accident · No injuriesClosedBeech A23 · Wooster, OHNTSB SEA80DYE44Accident · No injuriesClosedBeech A23 · Morton, WANTSB CHI80FEI19Accident · No injuriesClosedBeech A-23 · New Phila, OHNTSB MKC80FTK06Accident · No injuriesClosedBeech A23 · Tea, SDNTSB NYC80FGM03Accident · Minor injuriesClosedBeech A23 · Bradford, PANTSB NYC78FFJ31Accident · No injuriesClosedBeech B23 · Reading Center, NYNTSB MIA78FLG02Accident · No injuriesClosedBeech A23-A · Iva, SCNTSB IAD77FIG28Accident · No injuriesClosedBeech 23 · Gaithersburg, MDNTSB OAK77FXQ27Accident · Serious injuriesClosedBeech A23A · Lake Tahoe, CANTSB FTW77DQG40Accident · No injuriesClosedBeech B-23 · Dumas, TXNTSB MKC77DER21Accident · No injuriesClosedBeech A-23 · Goodland, MNNTSB NYC76FGM43Accident · No injuriesClosedBeech A-23 · Somerset, PANTSB MKC76DTK32Accident · No injuriesClosedBeech A23A · Prairie City, SDNTSB CHI76FEV08Accident · No injuriesClosedBeech A23 · Maquon, ILNTSB IAD75DHD55Accident · No injuriesClosedBeech A23A · Wyoming, DENTSB FTW75FPD40Accident · No injuriesClosedBeech A23A · Fort Worth, TXNTSB FTW75FPA23Accident · Minor injuriesClosedBeech A23A · Plano, TXNTSB NYC75DNJ29Accident · No injuriesClosedBeech A23 · White Plains, NYNTSB NYC75DHM06Accident · No injuriesClosedBeech A23A · Colts Neck, NJNTSB CHI74FEI43Accident · No injuriesClosedBeech A23 · Tiffin, OHNTSB MKC74DER52Accident · No injuriesClosedBeech A23 · Sleepy Eye, MNNTSB DEN74FQA29Accident · No injuriesClosedBeech A23 · Santa Rosa, NMNTSB OAK74FVG23Accident · No injuriesClosedBeech A23A · Fair Oaks, CANTSB IAD74DLQ07Accident · No injuriesClosedBeech A23 · Owensboro, KYNTSB FTW74FPG03Accident · No injuriesClosedBeech A23A · N.Little Rock, ARNTSB CHI73DET18Accident · No injuriesClosedBeech A23 · Griffith, INNTSB CHI73AEM41Accident · No injuriesClosedBeech A23A · Allegan, MINTSB NYC73DNC51Incident · No injuriesClosedBeech A23A · Claremont, NHNTSB FTW73FPA18Accident · No injuriesClosedBeech A23 · Lancaster, TXNTSB FTW73FPD15Accident · No injuriesClosedBeech A23 · Roanoke, TXNTSB NYC73FHJ07Accident · No injuriesClosedBeech A23 · Central Islip, NYNTSB MIA72DKJ65Accident · No injuriesClosedBeech A23 · Catherine, AL