NTSB investigations: Continental E225 series
513 cases on aircraft whose registry engine model is Continental E225 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 ('17015'))
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 ('17015'))
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 CHI86FEM08Accident · Serious injuriesFinal reportBeech B35 · Paw Paw, MIOn takeoff at approx 100' the engine began to falter. The pilot did a 180 deg turn and landed about 1/2 way down the runway. After bouncing twice and seeing that he would probably run off the end, he performed a go-around. At a point near the end of the…NTSB MIA86LA019Accident · No injuriesLimited investigationFinal reportBeech G35 · Destin, FLThe acft veered off rwy 14 and struck a rwy light and small trees during an attempted x-wind takeoff. The plt stated that he thought the x-wind was from the right, however, the surface winds were reported as 050 at 9 KTS with gusts 12 to 15 KTS, a left x-wind.NTSB MIA85LA204Accident · No injuriesLimited investigationFinal reportNorth American Navion · Cooper City, FLThe plt reported that the eng lost power during a descent about 5 mi from the arpt. Subsequently, the left wing & left main gear were damaged during a forced landing on a highway ramp area that was being built. An exam of the acft revealed that the fuel tanks…NTSB LAX85FA100Accident · 4 fatalField investigationFinal reportBeech B-35 · Death Valley, CAThe plt got an extended wx fcst the day prior to departure which indicated bkn to ovc clouds based at about 8,000 ft for the first part of the trip & sct to bkn clouds for the last half. Mountain areas were predicted to be obscured. Plt was encouraged to call…NTSB LAX85FA067Accident · Serious injuriesField investigationFinal reportBeech G35 · Lakeport, CAAt aprx 150 ft AGL the acft's lost pwr & plt made a tail first hard landing off side of rwy. Acft skidded 60 ft before stopping when it hit a fence. Fuel selector was found in 'aux' position. Plt said he took off on left tank and was moving selector to rt…NTSB CHI84LA397Accident · No injuriesLimited investigationFinal reportBeech D 35 · Alexandria, MNThe acft was started with the throttle open after refueling. The plt said the acft collided with a gas hose before he could get the throttle reduced.NTSB DEN84FA202Accident · 2 fatalField investigationFinal reportBeech 35 · Albuquerque, NMAccording to arpt personnel the plt was known to perform maintenance on his acft. The plt was not a licensed A&P. According to witnesses, the acft tookoff and climbed to aprx 200 to 250 ft and the eng quit. The acft climbed 'a little more', then made a left…NTSB LAX84LA322Accident · No injuriesLimited investigationFinal reportBeech S35 · Kayenta, AZThe plt reported that during takeoff, he raised the nose, the acft began climbing and immediately thereafter, the stall warning horn sounded. He then lost control, the acft descended & crashed into terrain south of the rwy. The plt said that he over rotated…NTSB SEA84LA121Accident · No injuriesLimited investigationFinal reportNavion A · Noti, ORAt about 4,000 ft MSL, the eng began to run rough. The plt made a 180 deg turn to return to his departure arpt. The eng then quit. He turned the fuel boost pump on, applied carburetor heat, leaned the mixture & checked the mags. The eng started & ran for…NTSB FTW84FA237Accident · 1 fatalField investigationFinal reportBeech G35 · Tulsa, OKA witness stated it appeared as though the plt was attempting to perform a precautionary landing on a highway. As the acft reached the highway, the witness heard the engine accelerate to 'full power' and saw the acft pull up. The acft contacted the top static…NTSB DEN84LA140Accident · No injuriesLimited investigationFinal reportBeech F35 · Moab, UTDuring takeoff, the eng lost power at about 100 ft AGL. The plt decided to land the acft back on the rwy to avoid rough terrain beyond the end. The acft was landed with the gear up. During an investigation, fuel was found in the main tanks & the right…NTSB LAX84FA048Accident · No injuriesField investigationFinal reportBeech B35 · Long Beach, CAThe plt reported that as he raised the landing gear during takeoff, the eng simultaneously lost power. He initiated an emergency landing on the remaining portion of the rwy. Acccording to him, the acft stalled while he was holding it in a nose high attitude &…NTSB DEN83LA174Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Salida, COThe acft crashed into a mountain in a controlled crash situation with full flaps and full power at the 11,312 ft level the density alt was computed to be 12,370 ft MSL. The plt was aware that the weather was questionable in some areas of his route and the…NTSB LAX83FA205Accident · Serious injuriesField investigationFinal reportBeech A36 · Hawthorne, CAAs the acft was climbing thru about 400 to 500 ft AGL, after takeoff, the eng began losing power. The plt turned on the fuel boost pump & started a turn back toward the arpt. When he realized that he could not reach the rwy, he elected to land on a street.…NTSB DEN83LA013Accident · No injuriesLimited investigationFinal reportBeech G35 · Cut Bank, MTThe pilot started to takeoff on runway 31 with a wind from 270 deg at 20 KTS. During the takeoff roll, the aircraft veered and went off the left side of the runway. The pilot stated that after about 400 to 500 ft in the takeoff roll, the "plane veered right…NTSB CHI82DA254Accident · No injuriesFinal reportBeech C35 · Hamilton, OHDuring arrival, the pilot observed a thunderstorm just southof the airport with visible lighting. As the pilot continued his approach to runway 29, he noticed that the wind gusts had picked up. During the flare, a gust lifted his left wing and the right wing…NTSB ATL82FKM05Accident · Serious injuriesFinal reportBeech F35 · Franklin, NCThe pilot made his initial approach to runway 07 at mason county airport. The approach seemed high to the pilot, so he executed a go-around and decided to land on runway 25. During the second approach, he extended the flaps, but not thelanding gear. When the…NTSB CHI82DA148Accident · No injuriesFinal reportBeech C35 · Dillsboro, INThe aircraft operated normally during taxi, run-up, takeoff, and climb to 3500 ft MSL. About 17 miles from the departureairport, the engine stopped running. During a forced landing in a dirt field, one of the main gear failed. The propellerseparated and the…NTSB LAX82FUM06Accident · 3 fatalFinal reportNavion A · Ramona, CAThe accident occurred during the final leg of a "share the expenses" commuting flight from hawthorne to romona, CA, when the aircraft collided with the southwest face of mount woodson. Marginal VFR conditions prevailed over the route of flight. During the…NTSB CHI82FEC04Accident · No injuriesClosedBeech G-35 · Pontiac, MINTSB ATL81DLQ21Accident · No injuriesClosedBeech G35 · Lexington, KYNTSB LAX81FVG55Accident · No injuriesClosedBeech C35 · Napa, CANTSB DEN81DTM36Accident · No injuriesClosedBeech F35 · Laketown, UTNTSB LAX81FA103Accident · 1 fatalClosedBeech F35 · Carson City, NVNTSB DEN81FTM31Accident · No injuriesClosedNavion A · West Jordan, UTNTSB FTW81FA074Accident · 4 fatalClosedBeech E35 · Fay, OKNTSB CHI81FA047Accident · 1 fatalClosedNavion A · Platteville, ILNTSB MIA81FA040Accident · 1 fatalClosedBeech G35 · St.Petersburg, FLNTSB MKC81FA012Accident · No injuriesClosedBeech F35 · Paris, TNNTSB FTW81FA010Accident · 2 fatalClosedBeech A35 · Rock Springs, TXNTSB ATL81FKW04Accident · Minor injuriesClosedBeech E35 · Chattanooga, TNNTSB DEN80DTE64Accident · No injuriesClosedBeech 35 · Elbert, CONTSB CHI80FET17Accident · No injuriesClosedBeech G35 · Syracuse, INNTSB NYC80FGM18Accident · No injuriesClosedBeech A35 · Zelienople, PANTSB MIA80FKT21Accident · Minor injuriesClosedBeech G35 · Pompano, FLNTSB FTW80FPD19Accident · No injuriesClosedBeech 35 · Keene, TXNTSB FTW79FA111Accident · 3 fatalClosedBeech C35 · Ranger, TXNTSB LAX79FUG55Accident · No injuriesClosedBeech F35 · El Monte, CANTSB MKC79FCG68Accident · Minor injuriesClosedBeech F35 · Theodosia, MONTSB OAK79DVG56Accident · No injuriesClosedBeech F-35 · Napa, CANTSB SEA79DYP19Accident · No injuriesClosedBeech G-35 · Mattawa, WANTSB MKC79FCG42Accident · Serious injuriesClosedNavion A · Carthage, MONTSB CHI79FEE49Accident · No injuriesClosedBeech E-35 · Deer Grove, ILNTSB NYC79FGT10Accident · No injuriesClosedNavion A · New Cumberland, PANTSB LAX79FUJ47Accident · No injuriesClosedBeech 35 · Maricopa, AZNTSB DEN79FTE13Accident · No injuriesClosedBeech 35 · Greeley, CONTSB FTW78FPA05Accident · No injuriesClosedBeech 35 · Rockwall, TXNTSB NYC78FGT16Accident · No injuriesClosedBeech F35 · White Pine, PANTSB SEA78DYK20Accident · No injuriesClosedBeech 35 · Crescent Lake, ORNTSB FTW78FPJ30Accident · No injuriesClosedBeech 35 · Tecumseh, OK