NTSB investigations: Continental E185 series, PA
15 cases on aircraft whose registry engine model is Continental E185 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 |
|---|---|
| 1967 | 1 |
| 1968 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1974 | 3 |
| 1975 | 2 |
| 1976 | 1 |
| 1977 | 1 |
| 1979 | 1 |
| 1985 | 1 |
| 2016 | 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\" = 'PA' 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 ('17014'))
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" = 'PA' 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 ('17014'))
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 GAA16CA453Accident · No injuriesData collectionFinal reportCessna 150 · Franklin, PAThe student pilot's failure to maintain pitch control resulting in a hard landing and the flight instructor's delayed action to assist the student pilot during the aborted landing, which resulted in a runway excursion, a right main and nose gear collapse, and…NTSB NYC85LA252Accident · No injuriesLimited investigationFinal reportBeech C35 · Wexford, PAAircraft was landing on private grass strip and during landing roll struck a deer with the right wing tip. The grass was wet and the pilot lost directional control. The aircraft impacted trees that bordered the airstrip and was destroyed.NTSB NYC79FGT08Accident · No injuriesClosedN.American NAVI0N · Chambersburg, PANTSB NYC77FGM40Accident · No injuriesClosedNavion A · Belle Vernon, PANTSB NYC76FGM51Accident · Minor injuriesClosedBeech A35 · North East, PANTSB NYC75FGM30Accident · No injuriesClosedNavion A · Huntingdon Twp, PANTSB NYC75FHD31Accident · No injuriesClosedBeech C35 · West Grove, PANTSB NYC75FGM19Accident · No injuriesClosedNavion A · Martinsburg, PANTSB NYC75FHD14Accident · No injuriesClosedBeech 35 · Toughkenoman, PANTSB NYC75FGT02Accident · No injuriesClosedNavion A · Wellsboro, PANTSB NYC73FHD08Accident · No injuriesClosedNavion A · Philadelphia, PANTSB NYC71IN081Incident · No injuriesClosedBeech 35 · Franklin, PANTSB NYC69F0002Accident · No injuriesClosedBeech B35 · Reading, PANTSB NYC68F0305Accident · No injuriesClosedBeech 35R · Prospectville, PANTSB UNK64X2233Accident · No injuriesClosedBeechcraft 35 · West Mifflin, PA