NTSB investigations: Continental O-470 series, NC

107 cases on aircraft whose registry engine model is Continental O-470 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, newest first

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\" = 'NC' 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 ('17026'))
  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.

NTSB ATL88LA169Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Raeford, NCThe airplane lost power shortly after takeoff, at 100-200 ft AGL. A witness reported hearing the engine backfire several times before it lost power completely. The airplane crashed shortly thereafter, as the pilot was attempting to return to the arpt. Exam of…May 10, 1988 · N5678B · Substantial damageNTSB ATL86FA025Accident · 2 fatalField investigationFinal reportCessna 182Q · Edenton, NCThe aircraft crashed into the abermarle sound and sank in 18 ft of water. The pilot was reportedly on an NDB approach and descended below mda. Witnesses stated that the aircraft circled over head about 15 minutes prior to the accident. Witnesses also stated…Nov 14, 1985 · N735SS · Substantial damageNTSB ATL84LA283Accident · No injuriesLimited investigationFinal reportCessna 182B · Kannapolis, NCThe plt reported that because of grnd fog in wilkersboro, NC, he diverted to Kannapolis, NC. Upon arriving over enochuille airport, he observed that grnd fog was present on the lake which is located adjacent to the arpt. Due to the fog, the plt elected to…Sep 8, 1984 · N7198E · Substantial damageNTSB ATL84LA156Accident · No injuriesLimited investigationFinal reportCessna 182 · Burlington, NCThe acft nosed over during a forced landing after the engine lost power. The plt said the fuel gauges were reading 1/4 to 1/2 full just before the engine quit. No fuel was found in the acft after the accident. The engine performed normally after refueling.May 1, 1984 · N6128B · Substantial damageNTSB ATL83LA258Accident · No injuriesLimited investigationFinal reportCessna 182L · Charlotte, NCThe acft ran off the departure end of the rwy during landing. The wind was light and variable to calm. The plt used aerodynamic braking until it was too late to go around. When he applied the brakes he found that they were spongy and ineffectual. An after…Jul 7, 1983 · N70517 · Substantial damageNTSB ATL82FA212Accident · 4 fatalField investigationFinal reportCessna 182A · Louisburg, NCWitnesses observed the takeoff roll as being unusually long. The acft never climbed much above 100-200 ft AGL, & struck trees 1/2 mi off the end of the rwy. The flaps were observed up during takeoff. Normal takeoff flap setting used by the club for carrying…Jul 25, 1982 · N5188D · DestroyedNTSB ATL81FA054Accident · 2 fatalClosedCessna 182P · Jefferson, NCMar 12, 1981 · N1301R · DestroyedNTSB ATL81DLJ03Accident · Serious injuriesClosedCessna 182G · Apex, NCDec 9, 1980 · N2116R · No damageNTSB ATL80FKM24Accident · Minor injuriesClosedCessna 150 · Bryson City, NCAug 7, 1980 · N60556 · Substantial damageNTSB IAD80FA041Accident · 2 fatalClosedCessna 182 · Waynesville, NCMay 31, 1979 · N618WC · DestroyedNTSB IAD78FA062Accident · 1 fatalClosedCessna 182Q · Linville, NCMay 12, 1978 · N735MB · DestroyedNTSB IAD77DKM17Accident · No injuriesClosedCessna 180 · Kernersville, NCMar 7, 1977 · N180V · Substantial damageNTSB IAD77DKM07Accident · No injuriesClosedCessna 182 · Hickory, NCDec 9, 1976 · N42116 · Substantial damageNTSB IAD77DKM04Accident · No injuriesClosedCessna 182 · Gastonia, NCOct 29, 1976 · N3463F · Substantial damageNTSB IAD76AI080Accident · 1 fatalClosedCessna 182M · Beaufort, NCJul 3, 1976 · N71432 · DestroyedNTSB IAD76FLJ20Accident · No injuriesClosedCessna 182 · Louisburg, NCApr 10, 1976 · N5188D · Substantial damageNTSB IAD76DKM15Accident · No injuriesClosedCessna 182K · Horseshoe, NCOct 30, 1975 · N3207S · Substantial damageNTSB IAD76DKM09Accident · No injuriesClosedCessna 182 · Midland, NCSep 21, 1975 · N5175D · Substantial damageNTSB IAD76FLJ02Accident · No injuriesClosedCessna 182P · Raeford, NCJul 21, 1975 · N21508 · Substantial damageNTSB IAD75DKM31Accident · No injuriesClosedCessna 182 · Charlotte, NCMay 6, 1975 · N2017X · Substantial damageNTSB IAD75DKM18Accident · No injuriesClosedCessna 182 · Hickory, NCApr 26, 1975 · N92422 · Substantial damageNTSB IAD74DKM59Accident · No injuriesClosedCessna 182 · Statesville, NCJun 23, 1974 · N2357X · Substantial damageNTSB IAD74FKM60Accident · No injuriesClosedBellanca 14-192 · Wallberg, NCJun 19, 1974 · N7603E · Substantial damageNTSB IAD74DLJ35Accident · No injuriesClosedCessna 182 · Jacksonville, NCMar 24, 1974 · N42603 · Substantial damageNTSB IAD74DKM46Accident · No injuriesClosedCessna 182 · Asheville, NCMar 4, 1974 · N2493Q · Substantial damageNTSB IAD74DLJ29Accident · No injuriesClosedCessna 305A · Lumberton, NCJan 12, 1974 · N64835 · Substantial damageNTSB IAD74DKM16Accident · No injuriesClosedCessna 182 · Hickory, NCSep 7, 1973 · N7379Q · Substantial damageNTSB IAD74AI013Accident · 1 fatalClosedCessna 188B · Swan Quarter, NCAug 17, 1973 · N21689 · 2 aircraft · Minor damageNTSB IAD73DKM51Accident · Minor injuriesClosedCessna 182 · Brevard, NCJun 29, 1973 · N5322B · Substantial damageNTSB IAD73DLJ27Accident · No injuriesClosedCessna 205 · Engelhard, NCApr 17, 1973 · N8125Z · Substantial damageNTSB NYC73FCJ12Incident · No injuriesClosedCessna 182P · Morrisville, NCOct 14, 1972 · N21067 · Minor damageNTSB NYC73DKM15Accident · No injuriesClosedCessna 182J · Brevard, NCSep 29, 1972 · N3413F · Substantial damageNTSB NYC72FLJ31Accident · Minor injuriesClosedCessna 182 · Morrisville, NCApr 13, 1972 · N3071Q · Substantial damageNTSB NYC72DKM15Accident · Minor injuriesClosedCessna 182A · Statesville, NCDec 19, 1971 · N5060D · Substantial damageNTSB NYC72FLJ12Accident · Serious injuriesClosedCessna 182 · Rocky Mount, NCOct 8, 1971 · N9926B · No damageNTSB IAD72DLJ03Accident · No injuriesClosedCessna 182D · Cameron, NCJul 25, 1971 · N8802X · Substantial damageNTSB IAD71DKM24Accident · No injuriesClosedCessna 180 · Denver, NCJan 11, 1971 · N674M · Substantial damageNTSB IAD71DKM17Accident · No injuriesClosedCessna 180B · Denver, NCOct 9, 1970 · N674M · Substantial damageNTSB IAD71DLJ13Accident · Minor injuriesClosedCessna 182 · Whiteville, NCSep 10, 1970 · N71471 · Substantial damageNTSB DIA69F0062Accident · No injuriesClosedCessna 182 · Weddington, NCSep 14, 1968 · N42525 · Substantial damageNTSB DIA68F0120Accident · No injuriesClosedCessna 182E · Asheboro, NCNov 5, 1967 · N3302Y · Substantial damageNTSB DIA68D0069Accident · No injuriesClosedCessna 188 · Wagram, NCAug 21, 1967 · N9777V · Substantial damageNTSB DIA68D0003Accident · No injuriesClosedCessna 182 · Bethel, NCJun 8, 1967 · N3463F · Substantial damageNTSB DIA67D0057Accident · No injuriesClosedCessna 180B · Wilkesboro, NCMar 22, 1967 · N5127E · Substantial damageNTSB DIA67D0034Accident · No injuriesClosedCessna 182H · Archdale, NCFeb 14, 1967 · N2023X · Substantial damageNTSB MIA67D0238Accident · No injuriesClosedCessna 182J · Wallace, NCSep 30, 1966 · N2916F · Substantial damageNTSB MIA67D0001Accident · No injuriesClosedCessna 182A · Lake Lure, NCJul 2, 1966 · N4785D · Substantial damageNTSB MIA66F0553Accident · No injuriesClosedCessna 182 · Scotland Neck, NCMay 23, 1966 · N3249Y · Substantial damageNTSB MIA66F0403Accident · No injuriesClosedCessna 182E · Raleigh, NCJan 20, 1966 · N2854Y · Substantial damageNTSB MIA66F0328Accident · No injuriesClosedCessna 180 · Charlotte, NCNov 14, 1965 · N4684B · Substantial damage