NTSB investigations: Continental E225 series, OK
11 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 |
| 1967 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1978 | 1 |
| 1981 | 1 |
| 1984 | 1 |
| 1999 | 2 |
| 2010 | 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\" = 'OK' 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" = 'OK' 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 CEN10LA440Accident · No injuriesLimited investigationFinal reportBeech F35 · Enid, OKA loss of engine power for undetermined reasons.NTSB FTW00LA044Accident · Minor injuriesLimited investigationFinal reportBeech F35 · Elk City, OKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA266Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Lone Grove, OKThe pilot's selection of an unsuitable takeoff area. Factors were the fences struck during the takeoff, the tall grass, rising terrain, and a tailwind.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 FTW81FA074Accident · 4 fatalClosedBeech E35 · Fay, OKNTSB FTW78FPJ30Accident · No injuriesClosedBeech 35 · Tecumseh, OKNTSB FTW70DPJ24Accident · No injuriesClosedBeech E35 · Enid, OKNTSB FTW70D0171Accident · No injuriesClosedBeech 35 · Hooker, OKNTSB FTW67F0521Accident · No injuriesClosedBeech G35 · Tulsa, OKNTSB FTW66F0166Accident · Serious injuriesClosedPiper PA-25 · Hough, OKNTSB UNK64X0965Accident · No injuriesClosedBeechcraft E35 · Wagoner, OK