NTSB investigations: Continental E185 series, NJ
16 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 | 4 |
|---|---|
| 1965 | 3 |
| 1966 | 2 |
| 1969 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 2000 | 1 |
| 2005 | 1 |
| 2016 | 2 |
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\" = 'NJ' 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" = 'NJ' 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 ERA17FA052Accident · 1 fatalField investigationFinal reportRyan Navion · New Gretna, NJThe pilot's inadequate preflight weather planning and in-flight weather evaluation, which resulted in an encounter with a strong cold front and the pilot's subsequent loss of airplane control.NTSB ERA17LA042Accident · 1 fatalLimited investigationFinal reportNorth American Navion · Blairstown, NJThe pilot's improper engine start procedure, which resulted in a loss of control on the ground and collision with a tree.NTSB IAD05LA082Accident · No injuriesLimited investigationFinal reportBeech C35 · West Milford, NJThe pilot's failure to maintain directional control during landing, which resulted in a collision with a drainage ditch.NTSB NYC01LA032Accident · Serious injuriesLimited investigationFinal reportNavion A · Lumberton, NJThe pilot's misjudgment of altitude and distance to the runway while performing a forced landing after an engine failure. Factors related to the accident were the pilot's inadequate rebuilding procedures and maintenance inspection, which resulted in…NTSB NYC74FHD13Accident · No injuriesClosedBeech C35 · Rio Grand, NJNTSB NYC71DHD37Accident · No injuriesClosedRyan Navion · Hammonton, NJNTSB NYC69D0362Accident · No injuriesClosedBeech D35 · Lakewood, NJNTSB NYC67F0220Accident · No injuriesClosedNavion A · Carlstadt, NJNTSB NYC67F0175Accident · No injuriesClosedBeech 35 · Colts Neck, NJNTSB NYC66F0381Accident · No injuriesClosedBeechcraft F35 · Fairchild, NJNTSB NYC66F0050Accident · Serious injuriesClosedNavion A · Bridgeport, NJNTSB UNK65X1226Accident · No injuriesClosedNavion NAV4 · Hanover, NJNTSB UNK64X3608Accident · Minor injuriesClosedNavion Ryan · Atlantic City, NJNTSB UNK64X2654Accident · No injuriesClosedNavion Navy · Pitman, NJNTSB UNK64X1196Accident · 2 fatalClosedBeechcraft 35 · West Milford, NJNTSB UNK64X0231Accident · No injuriesClosedNavion A · Lumberton, NJ