NTSB investigations: Continental C85 series, 1983
6 cases on aircraft whose registry engine model is Continental C85 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1983 | 6 |
|---|---|
| 1984 | 4 |
| 1985 | 3 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 7 |
| 1989 | 5 |
| 1990 | 1 |
| 1991 | 3 |
| 1992 | 4 |
| 1995 | 4 |
| 1996 | 4 |
| 1998 | 1 |
| 1999 | 3 |
| 2000 | 1 |
| 2001 | 3 |
| 2002 | 1 |
| 2003 | 4 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 4 |
| 2007 | 1 |
Where
Latest 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\") = 1983
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17008')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
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") = 1983
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17008')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
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 NYC83LA232Accident · No injuriesLimited investigationFinal reportCessna 120 · Punxsutawney, PAAccording to the pilot when he entered the aircraft he found that the master switch had been left on and the battery wasdown. He flew around the airport for about 45 min, to recharge the battery prior to departing for his destination. He arrived at his…NTSB SEA83LA185Accident · Serious injuriesLimited investigationFinal reportCessna 140 · College Place, WAThe acft collided with power line poles during an emergency landing. The pilot reported a power loss during takeoff and witnesses reported that the engine was sputtering during takeoff and quit during climb out. Post accident investigation showed the acft…NTSB SEA83LA152Accident · No injuriesLimited investigationFinal reportCessna 120 · Tenakee Springs, AKThe acft nosed over during a forced landing on a rocky beach at night. The pilot did not use carburetor heat during the engine restart attempts.NTSB MKC83LA101Accident · No injuriesLimited investigationFinal reportCessna C-140 · Mt. Pleasant, IAThe pilot stated he did not make a visual check of his fuel supply prior to flight. After a 45 minute solo flight he landed at a private strip and picked up a passenger. The right fuel tank was selected and the guage was indicating in the lower red 1/4 red,…NTSB FTW83LA206Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Prague, OKAfter purchasing the acft, the new owner (a student plt) had asked his uncle (reportedly an experienced plt) to fly his acft home. During the flt, the eng lost power shortly after the plt leveled off at 4000 ft MSL (aprx 3000 ft AGL). There was no suitable…NTSB NYC83LA089Accident · No injuriesLimited investigationFinal reportPiper J3C-85 · Spencer, MAThe pilot was warming the eng for a compression check and oil change in preparation for an annual inspection. He stated that he decided to fly the aircraft rather than run the engine on the ground. On tkof a high rate of climb was obtained and at 150 MSL the…