NTSB investigations: Continental C85 series, AZ
8 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
| 1984 | 1 |
|---|---|
| 1986 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1994 | 2 |
| 2003 | 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 c.\"eventStateOrRegion\" = 'AZ' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'AZ' AND c."eventCountry" = 'USA'
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 LAX04CA036Accident · No injuriesData collectionFinal reportR. James Thorne Nieuport 12 · Chandler, AZthe pilot's failure to maintain directional control of the airplane during landing.NTSB FTW94LA153Accident · No injuriesLimited investigationFinal reportCessna 120 · Goodyear, AZThe pilot's failure to maintain directional control. A factor was the gusty crosswind.NTSB LAX94LA161Accident · No injuriesLimited investigationFinal reportLuscombe 8EZ · Prescott, AZthe flying pilot's inadequate compensation for the existing crosswind condition, his failure to maintain directional control, and the inadvertent entry into a ground loop. A factor in the accident was the flying pilot's lack of experience in conventional…NTSB LAX91LA122Accident · No injuriesLimited investigationFinal reportCessna 140 · Flagstaff, AZThat the pilot improperly used the flight controls and brakes. Contributing to this accident was an existing cross/tailwind.NTSB LAX90LA342Accident · No injuriesLimited investigationFinal reportPiper J-3C-115 · Wickenburg, AZThe pilot's failure to maintain directional control.NTSB LAX90LA154Accident · No injuriesLimited investigationFinal reportCessna 120 · Phoenix, AZThe pilot failed to maintain directional control by improperly using the rudders/tall wheel steering.NTSB LAX86LA298Accident · No injuriesLimited investigationFinal reportCessna 140 · Flagstaff, AZA Cessna 140 lost control on takeoff ground run from rwy 21 and collapsed the right main landing gear. On the takeoff roll the acft veered to the right and as the acft approached the end of the rwy 21, it veered sharply back to the left collapsing the right…NTSB LAX84LA368Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Tucson, AZThe student pilot lost directional control during the landing roll. The instructor pilot was unable to regain control to prevent a ground loop. Subsequently, the acft veered off the rwy & was damaged on rough terrain.