NTSB investigations: Continental C85 series, 1982
5 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\") = 1982
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") = 1982
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 ANC82DA077Accident · No injuriesFinal reportAeronca 11AC · Soldotna, AKThe student pilot was practicing takeoffs and landings. He stated that during a landing, the aircraft ground looped to the left, went off the runway and went into soft dirt. When the soft dirt was encountered, the landing gear and propeller were damage.NTSB ANC82DA066Accident · No injuriesFinal reportPiper PA-17 · Anchorage, AKWhile landing with a light crosswind, the aircraft veered to the right and the left gear collapsed. There was no evidence of a pre-accident malfunction of failure.NTSB LAX82DA270Accident · Minor injuriesFinal reportLuscombe 8A · Kernville, CADuring roll-out the plt lost directional control. The plt applied hard brakes to prevent the acft from entering the water adjacent to the rwy & the acft flipped over.NTSB MKC82DA090Accident · No injuriesFinal reportLuscombe 8E · Goodland, KSWhile en route, the pilot encountered headwinds and elected to land at Goodland, Kansas to refuel. He landed on runway 12 with a crosswind from 320 degrees at 6 knots. The pilot stated that after touchdown, he got a cramp in his right leg and removed his…NTSB SEA82DA040Accident · No injuriesFinal reportLuscombe 8E · Blaine, WAUpon arrival the pilot observed the wind to be 90 degrees to the runway with an estimated velocity of 5 to 7 knots. A low pass was completed followed by a landing on runway 32. During the rollout the aircraft drifted right, the landing gear encountered…