NTSB investigations: Continental E225 series, NM
10 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 |
| 1969 | 1 |
| 1971 | 2 |
| 1977 | 1 |
| 1984 | 1 |
| 1996 | 1 |
| 2009 | 1 |
| 2025 | 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\" = 'NM' 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" = 'NM' 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 WPR25FA205Accident · 1 fatalClass 3 · FieldPreliminary reportBeech F35 · Eagle Nest, NMOn July 6, 2025, about 1345 mountain daylight time, a Beech F35, N5009B, was destroyed when it was involved in an accident near Eagle Nest, New Mexico. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB CEN09CA223Accident · No injuriesData collectionFinal reportBeech D35 · Taos, NMThe failure of the student pilot to complete the before landing checklist. Contributing to the accident was his failure to lower the landing gear before landing.NTSB FTW96LA284Accident · No injuriesLimited investigationFinal reportBeech B35 · Portales, NMfailure by maintenance personnel to perform proper maintenance on the aircraft during an annual inspection, and failure to comply with an airworthiness directive.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 DEN77DQA34Accident · No injuriesClosedBeech C35 · Reserve, NMNTSB DEN72FQD02Accident · No injuriesClosedBeech 35 · Carlsbad, NMNTSB DEN71FQA56Accident · Minor injuriesClosedBeech C35 · Albuquerque, NMNTSB DEN70A0039Accident · 1 fatalClosedBeech B35 · Tucumcari, NMNTSB UNK65X1391Accident · Minor injuriesClosedBeechraft G35 · Grants, NMNTSB UNK64X2397Accident · No injuriesClosedBeechcraft 35 · Alamogordo, NM