NTSB investigations: Continental E185 series, 1987
10 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 | 67 |
|---|---|
| 1965 | 63 |
| 1966 | 76 |
| 1967 | 72 |
| 1968 | 34 |
| 1969 | 29 |
| 1970 | 22 |
| 1971 | 27 |
| 1972 | 18 |
| 1973 | 15 |
| 1974 | 20 |
| 1975 | 20 |
| 1976 | 16 |
| 1977 | 14 |
| 1978 | 22 |
| 1979 | 10 |
| 1980 | 13 |
| 1981 | 13 |
| 1982 | 9 |
| 1983 | 10 |
| 1984 | 5 |
| 1985 | 9 |
| 1986 | 7 |
| 1987 | 10 |
| 1988 | 11 |
| 1989 | 8 |
| 1990 | 4 |
| 1991 | 5 |
| 1992 | 5 |
| 1993 | 5 |
| 1994 | 5 |
| 1995 | 9 |
| 1996 | 8 |
| 1997 | 7 |
| 1998 | 9 |
| 1999 | 9 |
| 2000 | 8 |
| 2001 | 6 |
| 2002 | 14 |
| 2003 | 6 |
| 2004 | 2 |
| 2005 | 8 |
| 2006 | 3 |
| 2007 | 7 |
| 2008 | 2 |
| 2009 | 7 |
| 2010 | 6 |
| 2011 | 4 |
| 2012 | 4 |
| 2014 | 3 |
| 2015 | 8 |
| 2016 | 7 |
| 2017 | 3 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 5 |
| 2022 | 5 |
| 2023 | 5 |
| 2024 | 5 |
| 2025 | 4 |
| 2026 | 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 year(c.\"eventDate\") = 1987
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 year(c."eventDate") = 1987
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 LAX88FA071Accident · 2 fatalField investigationFinal reportBeech A35 · Chino Hills, CAFailure of both pilots to see and avoid each other and thus avert the collision.NTSB LAX88LA005Accident · Minor injuriesLimited investigationFinal reportBeech A35 · Wickenburg, AZDuring the takeoff run, the plt realized he had a flt control problem when he was unable to rotate the acft for lift- off. He stated that he contd the takeoff, attempting to overcome the problem with elevator trim. He was unable to establish a climb.…NTSB MKC87LA160Accident · No injuriesLimited investigationFinal reportNorth American Navion · Chillicothe, MOThe PIC was ferrying the navion to a distant location to undergo an annual insp. Abt 20 min into the flt, the PIC rptd experiencing eng pblms. The PIC was able to fly to a nearby arpt for a precautionary lndg. Instead of making the lndg the PIC went around to…NTSB LAX87FA291Accident · Minor injuriesField investigationFinal reportNavion A · Hawthorne, CADuring a pleasure cross country flt, the eng sputtered then regained full pwr. The plt turned toward a nearby arpt and was cleared to land. En route to the arpt the engine lost full power. When the pilot thought he could make the rwy he extended the landing…NTSB FTW87LA188Accident · No injuriesLimited investigationFinal reportBeech 35 · Richwood, TXThe acft impacted a tree after a forced landing to a field near Richwood, Texas. The pilot stated that he was on final approach to the airport when the engine quit due to fuel starvation. The fuel selector was on the right tank at the time of the accident.…NTSB LAX87LA252Accident · No injuriesLimited investigationFinal reportBeech A35 · Santa Rosa, CAThe plt was participating in a cafe-400 (comparative acft flt efficiency) contest over a 400 mi, round robin course. While dscndg fm 7000' at the end of the flt, the plt slowed the acft to 140 mph to observe traffic. When clear, he increased the speed to 160…NTSB FTW87FA142Accident · Serious injuriesField investigationFinal reportBeech 35 · Cookson, OKJust after takeoff smoke was smelled and then observed in the cockpit. The pilot beleived that the smoke source was electrical and turned off the master switch. Just before touchdown flames began burning the pilots left leg. The aircraft was stopped on the…NTSB MIA87LA167Accident · No injuriesLimited investigationFinal reportNorth American Navion · Defuniak Spring, FLThe plt reported that after takeoff, at aprx 500 ft, the eng lost power. He then turned on the electric fuel pump in an attempt to restore it. Unable, he then elected to land the acft, during which, it collided with trees, fell to the ground & came to rest.…NTSB CHI87DEM06Accident · Serious injuriesFinal reportNavion A · Baldwin, MIAfter beginning a level off at aprx 6000 ft, the acft engine stopped. During the forced landing the acft crashed in a heavily wooded area aprx 1/2 mile west of the arpt. An examination of the wreckage revealed that both wing tanks were empty and the…NTSB DEN87LA079Accident · No injuriesLimited investigationFinal reportNorth American Navion · Los Alamos, NMThe instructor plt was giving cross wind instruction to a pre-solo student plt. During a cross wind landing attempt, the acft touched down hard, breaking off the right main landing gear. The winds were observed at the time of touchdown to be 150 degrees at 12…