NTSB investigations: Continental E185 series, GA
11 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
| 1969 | 2 |
|---|---|
| 1974 | 1 |
| 1976 | 2 |
| 1978 | 1 |
| 1996 | 1 |
| 2000 | 1 |
| 2008 | 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\" = 'GA' 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" = 'GA' 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 ERA22LA146Accident · No injuriesClass 3 · LimitedFinal reportBeech A35 · Waco, GAThe failure of the fuel pressure indicator line due to corrosion that was not detected during the last annual inspection, which resulted in a total loss of engine power.NTSB ERA22LA074Accident · No injuriesClass 4 · LimitedFinal reportBeech C35 · Perry, GAThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with a parked airplane.NTSB NYC08FA174Accident · 3 fatalField investigationFinal reportBeech A35 · Americus, GAThe pilot's failure to maintain control during the initial climb for undetermined reasons.NTSB MIA00LA157Accident · Serious injuriesLimited investigationFinal reportNavion L-17B · Sharpsburg, GATotal loss of engine power due to debris (aluminum) from an undetermined source found in the engine-driven fuel pump cavity resulting in the shearing of the hollow pump fuel shaft, and subsequent forced landing to none suitable terrain.NTSB ATL97LA027Accident · No injuriesLimited investigationFinal reportBeech 35 · Lafayette, GAfailure of maintenance personnel to balance the ruddervator assemblies after they had been reskinned and painted, which resulted in flutter and subsequent damage to the empennage.NTSB MIA78FKQ18Accident · Serious injuriesClosedBeech 35 · Stone Mountain, GANTSB MIA76FKG74Accident · No injuriesClosedBeech B35 · Mcrae, GANTSB MIA76FKG39Accident · Minor injuriesClosedBeech B35 · Atlanta, GANTSB MIA74FKG56Accident · No injuriesClosedStarduster II · Brooks, GANTSB MIA70A0035Accident · 1 fatalClosedBeech 35 · Thomasville, GANTSB MIA70A0022Accident · 1 fatalClosedNavion A · Williamson, GA