NTSB investigations: Continental E225 series, MO
18 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
| 1965 | 3 |
|---|---|
| 1966 | 4 |
| 1967 | 1 |
| 1970 | 1 |
| 1973 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1979 | 2 |
| 1987 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2017 | 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\" = 'MO' 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" = 'MO' 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 CEN17LA097Accident · Serious injuriesLimited investigationFinal reportBeech BE35 · Ozark, MOThe pilot's failure to adequately monitor the environment and to maintain sufficient altitude to clear power lines.NTSB CHI00LA238Accident · No injuriesLimited investigationFinal reportBeech BE-A35 · Poplar Bluff, MOthe pilot exceeded the VNE speed restriction of 144 MPH. Factors included the ruddervator flutter and the out of balance ruddervators.NTSB FTW97FA292Accident · 2 fatalField investigationFinal reportBeech F35 · Richards, MOThe pilot's continued flight into adverse weather and the loss of aircraft control which resulted in the aircraft exceeding its design stress limits. Factors were the pilot's failure to obtain a weather briefing and the adverse weather.NTSB MKC87FA163Accident · Serious injuriesField investigationFinal reportBeech 35 · Excelsior Spgs, MOAccording to witnesses, the pilot declared an emergency over the radio stating that the eng was losing power and that she was attempting an emerg lndg at Excelsior springs arpt. The pilot stated that she initiated a go-around, after the rwy was assured, due…NTSB MKC79FCG68Accident · Minor injuriesClosedBeech F35 · Theodosia, MONTSB MKC79FCG42Accident · Serious injuriesClosedNavion A · Carthage, MONTSB MKC78FCA24Accident · Minor injuriesClosedBeech F35 · West Plains, MONTSB MKC76FCG65Accident · No injuriesClosedBeech F35 · St Joseph, MONTSB MKC73DCG49Accident · No injuriesClosedN.American Navion · Independence, MONTSB MKC70DCA21Accident · No injuriesClosedBeech G35 · St Charles, MONTSB MKC68F0427Accident · No injuriesClosedBeech E35 · Springfield, MONTSB MKC67F0236Accident · No injuriesClosedBeech G35 · St.Louis, MONTSB MKC67F0087Accident · No injuriesClosedBeech C35 · Kansas City, MONTSB MKC67F0102Accident · No injuriesClosedBeech G35 · Fenton, MONTSB MKC66D0517Accident · No injuriesClosedBeech 35 · St Joseph, MONTSB MKC66F0389Accident · No injuriesClosedBeech E35 · Kansas City, MONTSB MKC66F0134Accident · No injuriesClosedBeech F35 · Knob Noster, MONTSB MKC65F0148Accident · No injuriesClosedBeechcraft E35 · Kansas City, MO