NTSB investigations: Continental 0-300 series, 1986
9 cases on aircraft whose registry engine model is Continental 0-300 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 | 4 |
|---|---|
| 1983 | 10 |
| 1984 | 4 |
| 1985 | 4 |
| 1986 | 9 |
| 1987 | 4 |
| 1988 | 7 |
| 1989 | 2 |
| 1990 | 5 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 7 |
| 1994 | 4 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 3 |
| 1999 | 5 |
| 2000 | 2 |
| 2001 | 4 |
| 2002 | 6 |
| 2003 | 6 |
| 2004 | 5 |
| 2005 | 2 |
| 2006 | 7 |
| 2007 | 2 |
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\") = 1986
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17022')
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") = 1986
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17022')
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 CHI86LA217Accident · No injuriesLimited investigationFinal reportCessna 172C · Bement, ILOn touchdown the aircraft was not properly aligned with the rwy. While rolling out the left wing caught the full grown corn on the left edge of the rwy and pulled the aircraft into the corn.NTSB MKC86LA178Accident · 1 fatalLimited investigationFinal reportCessna 172 · Emporia, KSThe acft was found stopped in an open field having penetrated the southern boundary of the Emporia airport property. The acft eng was still running when rescuers approached the location. Forced entry was made into the acft to shut the eng down and rescue the…NTSB DEN86LA214Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Albuquerque, NMWhile taxiing for takeoff in strong gusty wind conditions the aircraft was blown into an inverted position on the taxiway.NTSB LAX86LA230Accident · No injuriesLimited investigationFinal reportCessna 172B · Tracy, CAThe acft veered off a rural dirt road being used as an airstrip and nosed over in a farm field. The plt indicated that he was attempting to land on a narrow dirt farm road when the acft veered into a freshly plowed and irrigated tomato field. The nose gear…NTSB SEA86LA103Accident · No injuriesLimited investigationFinal reportCessna 172 · Reno, NVThe student plt lost control of the acft during high gusty wind conditions. The acft then veered to the right of the rwy. The wind at the time of the accident was from 280 degrees at 28 knots gusting to 31 knots.NTSB FTW86LA055Accident · No injuriesLimited investigationFinal reportCessna 172H · Bristow, OKThe pilot reported encountering strong gusty winds while taxiing for departure at jones memorial airport, Bristow, OK. As a result his aircraft was flipped upside down and substantially damaged. The pilot was not injured.NTSB MKC86LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Grain Valley, MOThe PIC was making a roundtrip flt to numerous airports across Kansas and Missouri. The owner of the aircraft was aboard for the trip which was for pleasure. The PIC had obtained weather info and was apprised of the wind conditions for his route of flt. Upon…NTSB CHI86LA095Accident · No injuriesLimited investigationFinal reportCessna 172C · Waupun, WIDrg arrival for a x-wind landing, the plt made a high apch & used full flaps to steepen his dscnt over trees near the apch end of the rwy. He stated that the touchdown was normal, but before he could raise the flaps, the x-wind pushed the plane to the left.…NTSB NYC86LA062Accident · No injuriesLimited investigationFinal reportCessna 172 · Durhamville, NYThe flight was returning from a 4-LEG 300-mile cross country trip. On flare touchdown, the pilot reported severe vibration. As brakes were applied the vibration increased, and the aircraft became uncontrollable. The aircraft pulled to the right and collided…