NTSB investigations: Continental E225 series, CA
101 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 per year
| 1964 | 11 |
|---|---|
| 1965 | 10 |
| 1966 | 14 |
| 1967 | 6 |
| 1968 | 6 |
| 1969 | 5 |
| 1970 | 3 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 3 |
| 1975 | 3 |
| 1976 | 3 |
| 1977 | 2 |
| 1979 | 2 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 1 |
| 1990 | 1 |
| 1993 | 2 |
| 1997 | 1 |
| 1998 | 2 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 1 |
| 2005 | 1 |
| 2007 | 2 |
| 2010 | 1 |
| 2012 | 2 |
| 2013 | 1 |
| 2015 | 2 |
| 2017 | 1 |
| 2018 | 1 |
Where
Open the mapLatest cases
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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
AND 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 GAA18CA342Accident · No injuriesData collectionFinal reportBeech D35 · Corona, CAThe pilot’s inadvertent landing gear retraction during the landing roll.NTSB WPR17LA191Accident · No injuriesLimited investigationFinal reportNorth American Navion A · Fortuna, CAA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preaccident mechanical malfunctions or failures that would have that would have precluded normal operation.NTSB WPR16FA007Accident · 2 fatalField investigationFinal reportBeech G35 · South Lake Tahoe, CAThe pilot's inability to maintain airplane control due to an encounter with a downdraft that exceeded the airplane’s climb performance capabilities and resulted in an aerodynamic stall. Contributing to the accident was the pilot’s decision to depart without…NTSB WPR15FA222Accident · 1 fatalField investigationFinal reportBeech F35 · Riverside, CAThe total loss of engine power for reasons that could not be determined during postaccident examination of the airplane and engine. Also causal to the accident was the pilot's decision to attempt to reach the farthest runway and land into the wind instead of…NTSB WPR14CA060Accident · No injuriesData collectionFinal reportBeech G35 · Placerville, CAThe airplane's collision with a deer on the runway during landing.NTSB WPR12LA434Accident · No injuriesLimited investigationFinal reportNavion Navion · Lompoc, CAA total loss of engine power after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12LA396Accident · No injuriesLimited investigationFinal reportBeech G35 · Oceano, CAThe pilot’s exceedance of the design maneuvering speed during descent in turbulence, which resulted in structural damage to the aft fuselage.NTSB WPR10CA226Accident · No injuriesData collectionFinal reportBeech B35 · Burbank, CAThe airplane's encounter with turbulence while at an airspeed above maneuvering airspeed, which exceeded the limit load of the stabilizers and ruddervators.NTSB SEA08LA012Accident · No injuriesLimited investigationFinal reportBeech F35 · San Carlos, CAA total loss of engine power for undetermined reasons. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB LAX07LA118Accident · 2 fatalLimited investigationFinal reportRyan Navion A · Los Banos, CAthe pilot's intentional performance of aerobatic maneuvers that exceeded the design stress limits of the airplane structure. Also causal was the pilot's impairment due to the effects of alcohol consumption. Contributory was the pilot's impairment due to the…NTSB LAX05LA303Accident · Minor injuriesLimited investigationFinal reportNorth American Navion A · Chowchilla, CAthe loss of engine power for undetermined reasons.NTSB LAX03LA082Accident · Minor injuriesLimited investigationFinal reportBeech F35 · Middletown, CAThe pilot's failure to attain an adequate takeoff airspeed and failure to abort the takeoff when the lack of acceleration was apparent.NTSB LAX03LA024Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Santa Ana, CAThe pilot's encounter with wake turbulence resulting in a loss of control. A related factor was insufficient separation by air traffic control.NTSB LAX02FA134Accident · 2 fatalField investigationFinal reportBeech G35 · Willows, CAthe pilot's entry into an abrupt maneuver at an excessive airspeed beyond Va, which resulted in exceeding the aircraft's design stress limits.NTSB LAX01FA234Accident · No injuriesField investigationFinal reportBeech 35A · Linden, CAThe engine lost power for undetermined reasons.NTSB LAX01LA143Accident · No injuriesLimited investigationFinal reportBeech C35 · Fullerton, CAThe premature retraction of the landing gear and the failure of the CFI to properly supervise the flight.NTSB LAX00LA108Accident · No injuriesLimited investigationFinal reportBeech 35 · Desert Center, CAThe pilot's inadequate fuel management, his inaccurate fuel consumption calculations, and his improper use of the fuel selector.NTSB LAX98FA264Accident · 2 fatalField investigationFinal reportNorth American Navion · Salinas, CAthe pilot's attempt to continue visual flight operations into an area of known instrument meteorological conditions resulting in controlled flight into rising terrain.NTSB LAX98LA120Accident · No injuriesLimited investigationFinal reportBeech C35 · Rio Linda, CAthe pilot's inadequate fuel management which led to fuel exhaustion.NTSB LAX97LA115Accident · No injuriesLimited investigationFinal reportRyan Navion · Marina, CAFuel exhaustion due to the pilot's improper preflight inspection and his inaccurate fuel consumption calculations.NTSB LAX93FA315Accident · 2 fatalField investigationFinal reportBeech E35 · Big Bear, CAA loss of engine power due to unporting of the selected main fuel tank at a critical time, which was caused by the pilot's failure to follow the directives in the flight manual regarding prolonged turns or slips with less than 10 gallons in the selected tank.NTSB LAX93LA121Accident · No injuriesLimited investigationFinal reportBeech C35 · Susanville, CAThe pilot's poorly planned approach. Contributing to this accident was the pilot's misjudging his distance and altitude and the prevailing light snow conditions.NTSB LAX91LA011Accident · No injuriesLimited investigationFinal reportBeech C35 · Independence, CAThe pilot's failure to attain an altitude adequate to avoid colliding with ojbects during takeoff.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 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 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 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 LAX81FVG55Accident · No injuriesClosedBeech C35 · Napa, CANTSB LAX79FUG55Accident · No injuriesClosedBeech F35 · El Monte, CANTSB OAK79DVG56Accident · No injuriesClosedBeech F-35 · Napa, CANTSB OAK77DVA31Accident · No injuriesClosedBeech E35 · Turlock, CANTSB LAX77FUQ26Accident · Minor injuriesClosedBeech G35 · Quartz Hill, CANTSB OAK76DVA88Accident · No injuriesClosedBeech F35 · Visalia, CANTSB OAK76FVG79Accident · No injuriesClosedBeech E35 · Jackson, CANTSB LAX76AL055Accident · 1 fatalClosedBeech F35 · Crestline, CANTSB OAK76FXQ11Accident · Minor injuriesClosedBeech G35 · Herlong, CANTSB OAK76DVA02Accident · No injuriesClosedBeech D35 · Sanger, CANTSB OAK75IP040Incident · No injuriesClosedBeech C35 · San Andreas, CANTSB OAK75FVG25Accident · Minor injuriesClosedBeech F35 · Live Oak, CANTSB LAX75DUG06Accident · No injuriesClosedBeech F35 · Laverne, CANTSB OAK74AVA61Accident · No injuriesClosedNavion A · Patterson, CANTSB OAK74AP027Accident · 4 fatalClosedNavion A · Firebaugh, CANTSB OAK74DVD19Accident · Minor injuriesClosedBeech A35 · Stockton, CANTSB OAK72DVD50Accident · No injuriesClosedNavion A · Tracy, CANTSB OAK71DVA57Accident · No injuriesClosedBeech 35 · Fresno, CANTSB OAK71DVM23Accident · No injuriesClosedBeech C35 · Calif Vally, CANTSB OAK70DVD27Accident · No injuriesClosedBeech E35 · Tracy, CANTSB LAX70DUG19Accident · No injuriesClosedBeech E35 · Blythe, CANTSB LAX70D0087Accident · No injuriesClosedBeech C35 · Santa Ana, CA