NTSB investigations: Continental E225 series, AZ
15 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 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 3 |
| 1969 | 1 |
| 1972 | 1 |
| 1979 | 1 |
| 1984 | 1 |
| 1995 | 1 |
| 2006 | 1 |
| 2016 | 1 |
| 2021 | 1 |
| 2022 | 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\" = 'AZ' 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" = 'AZ' 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 WPR22FA215Accident · 2 fatalClass 3 · FieldFinal reportBeech E35 · Buckeye, AZThe pilots’ failure to climb and complete a normal traffic pattern after making a low approach and their failure to extend the flaps for reasons that could not be determined, and the flight instructor’s failure to ensure adequate airspeed and bank control…NTSB WPR21LA134Accident · No injuriesClass 4 · LimitedFinal reportBeech G35 · Tucson, AZThe pilot’s distraction in the cockpit which interrupted his pre-landing checklist which resulted in his failure to configure the landing gear prior to touchdown.NTSB WPR16FA102Accident · 1 fatalField investigationFinal reportBeech G35 · Surprise, AZThe mechanic's failure to properly secure the bolt connecting the throttle cable to the carburetor during the installation of the carburetor, which resulted in a loss of engine power.NTSB LAX06CA139Accident · No injuriesData collectionFinal reportBeech G35 · Flagstaff, AZthe pilot's failure to maintain an adequate clearance with obstructions while taxiing.NTSB LAX95LA209Accident · No injuriesLimited investigationFinal reportBeech E35 · Tucson, AZthe pilot's failure to maintain adequate clearance from a taxiway sign while taxiing clear of the runway.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 LAX79FUJ47Accident · No injuriesClosedBeech 35 · Maricopa, AZNTSB LAX73DUJ12Accident · No injuriesClosedBeech F35 · Bllhead Cty, AZNTSB LAX70F0210Accident · Serious injuriesClosedBeech F35 · Tucson, AZNTSB LAX68D0230Accident · Minor injuriesClosedBeech F35 · Peach Spring, AZNTSB LAX68D0031Accident · No injuriesClosedBeech B35 · Bullhead Cty, AZNTSB LAX67D0322Accident · No injuriesClosedNavion A · Safford, AZNTSB LAX67D0063Accident · No injuriesClosedBeech E35 · Prescott, AZNTSB DEN66D0082Accident · No injuriesClosedBeechcraft G-35 · Phoenix, AZNTSB UNK64X0393Accident · No injuriesClosedBeechcraft G35 · Phoenix, AZ