NTSB investigations: Continental C85 series, 1995
7 cases on aircraft whose registry engine model is Continental C85 series, where the first occurrence was “Loss of control - on ground/water”. 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
| 1982 | 5 |
|---|---|
| 1983 | 7 |
| 1984 | 11 |
| 1985 | 1 |
| 1986 | 10 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 4 |
| 1990 | 6 |
| 1991 | 6 |
| 1992 | 4 |
| 1993 | 6 |
| 1994 | 6 |
| 1995 | 7 |
| 1996 | 3 |
| 1997 | 6 |
| 1998 | 5 |
| 1999 | 6 |
| 2000 | 4 |
| 2001 | 8 |
| 2002 | 4 |
| 2003 | 5 |
| 2004 | 2 |
| 2005 | 4 |
| 2006 | 6 |
| 2007 | 4 |
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\") = 1995
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\" = 260))
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") = 1995
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" = 260))
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 CHI95LA321Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Boyne Falls, MIthe pilot's failure to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve.NTSB BFO95LA086Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Batavia, OHwas the the second pilot's loss of directional control during the takeoff roll, and the flight instructor/pilot-in-command's inadequate supervision of the flight instructor/second pilot. A related factor was the flight instructor/second pilot's lack of total…NTSB CHI95LA228Accident · Serious injuriesLimited investigationFinal reportReed RS15 · Ames, IAThe glider pilot's inadequate preflight of the glider by failing to properly secure a push-pull tube to the glider's right ruddervator; and failure of both the glider pilot and the tow pilot to release the tow rope, which led to a stall of the tow airplane.NTSB LAX95LA247Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Columbia, CAthe pilot's inadequate compensation for the gusty crosswind condition and failure to maintain directional control.NTSB FTW95LA236Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Farmington, NMFailure by the pilot to maintain directional control.NTSB SEA95LA067Accident · No injuriesLimited investigationFinal reportCessna 140 · Ogden, UTDirectional control was not maintained. Factors to the accident were a lack of total experience in type of aircraft and crosswind.NTSB LAX95LA115Accident · No injuriesLimited investigationFinal reportSkov-Papworth Q2 · Hollister, CAthe pilot's failure to maintain directional control of the aircraft during the takeoff ground roll. The pilot's lack of recent experience is a factor in the accident.