Final NTSB investigations: Continental R-975 series
14 cases on aircraft whose registry engine model is Continental R-975 series. 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
| 1976 | 1 |
|---|---|
| 1981 | 1 |
| 1984 | 3 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2006 | 1 |
| 2009 | 1 |
Where
Open the mapLatest 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17037'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17037'))
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 WPR10LA048Accident · 3 fatalLimited investigationFinal reportPiasecki/Pike PV-18 · Adelanto, CAThe pilot’s failure to maintain clearance from powerlines during en route flight.NTSB DEN06CA081Accident · Minor injuriesData collectionFinal reportGrumman G-164B · Dighton, KSThe broken rocker arm boss causing the number 1 cylinder exhaust valve to stay closed and subsequently the engine failed. A factor contributing to the accident was the soft field the airplane set down in.NTSB FTW02LA132Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Gillett, ARthe pilot's failure to maintain directional control on landing. A contributing factor was the high vegetation.NTSB DEN01LA163Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Parowan, UTthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/mush into terrain. Contributing factors were the pilot's diverted attention, the rising terrain, and the high density altitude weather condition.NTSB FTW98LA164Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Tuckerman, ARThe pilot's failure to maintain aircraft control. Factors were the wet and soft runway conditions.NTSB FTW92LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Mamou, LAThe engine failure for undetermined reasons. A factor was the lack of suitable terrain onto which the ensuing forced landing could be executed.NTSB CHI90LA219Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Columbus, NEStanding water on the approach end of the runway.NTSB FTW89DRA06Accident · No injuriesFinal reportGrumman G-164B · Lissie, TXA bird strike which resulted in foreign object damage to the engine compressor. A berm and the lack of suitable terrain for a forced landing were contributing factors.NTSB SEA87LA067Accident · No injuriesLimited investigationFinal reportGrumman G164B · Reubens, IDDuring takeoff run the aircraft veered to the right of the runway, struck a ditch, and then nosed over inverted. The pilot found that the right dowel pin on the right main gear had broken. The reason for the failure could not be determined.NTSB LAX84LA474Accident · No injuriesLimited investigationFinal reportGrumman 164A · Goodyear, AZPlt reported pwr loss occurred during night aerial application. Acft nosed over during forced landing in crop field. Investigation failed to reveal any evidence of a mechanical failure/malfunction. Engine was test run to extent permitted by damage and no…NTSB MKC84LA255Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Marianna, ARThe landing gear contacted the bean crop which was being sprayed with sodium chlorate and the acft nosed over.NTSB SEA84LA133Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B-450 · Pullman, WAAfter making a swath run, the acft entered a steep turn with an airspeed of about 75 mph. According to two witnesses, the eng lost power & then the acft crashed. The plt was unable to remember what had happened from the time he entered the turn until he…NTSB FTW81DRJ13Accident · No injuriesClosedGrumman G-164B · Mer Rouge, LANTSB OAK76DVG70Accident · Minor injuriesClosedGrumman G-164A · Butte City, CA