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.
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" 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 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB ATL81FA054Accident · 2 fatalClosedCessna 182P · Jefferson, NCNTSB ATL81DLJ03Accident · Serious injuriesClosedCessna 182G · Apex, NCNTSB ATL80FKM24Accident · Minor injuriesClosedCessna 150 · Bryson City, NCNTSB IAD80FA041Accident · 2 fatalClosedCessna 182 · Waynesville, NCNTSB IAD78FA062Accident · 1 fatalClosedCessna 182Q · Linville, NCNTSB IAD77DKM17Accident · No injuriesClosedCessna 180 · Kernersville, NCNTSB IAD77DKM07Accident · No injuriesClosedCessna 182 · Hickory, NCNTSB IAD77DKM04Accident · No injuriesClosedCessna 182 · Gastonia, NCNTSB IAD76AI080Accident · 1 fatalClosedCessna 182M · Beaufort, NCNTSB IAD76FLJ20Accident · No injuriesClosedCessna 182 · Louisburg, NCNTSB IAD76DKM15Accident · No injuriesClosedCessna 182K · Horseshoe, NCNTSB IAD76DKM09Accident · No injuriesClosedCessna 182 · Midland, NCNTSB IAD76FLJ02Accident · No injuriesClosedCessna 182P · Raeford, NCNTSB IAD75DKM31Accident · No injuriesClosedCessna 182 · Charlotte, NCNTSB IAD75DKM18Accident · No injuriesClosedCessna 182 · Hickory, NCNTSB IAD74DKM59Accident · No injuriesClosedCessna 182 · Statesville, NCNTSB IAD74FKM60Accident · No injuriesClosedBellanca 14-192 · Wallberg, NCNTSB IAD74DLJ35Accident · No injuriesClosedCessna 182 · Jacksonville, NCNTSB IAD74DKM46Accident · No injuriesClosedCessna 182 · Asheville, NCNTSB IAD74DLJ29Accident · No injuriesClosedCessna 305A · Lumberton, NCNTSB IAD74DKM16Accident · No injuriesClosedCessna 182 · Hickory, NCNTSB IAD74AI013Accident · 1 fatalClosedCessna 188B · Swan Quarter, NCNTSB IAD73DKM51Accident · Minor injuriesClosedCessna 182 · Brevard, NCNTSB IAD73DLJ27Accident · No injuriesClosedCessna 205 · Engelhard, NCNTSB NYC73FCJ12Incident · No injuriesClosedCessna 182P · Morrisville, NCNTSB NYC73DKM15Accident · No injuriesClosedCessna 182J · Brevard, NCNTSB NYC72FLJ31Accident · Minor injuriesClosedCessna 182 · Morrisville, NCNTSB NYC72DKM15Accident · Minor injuriesClosedCessna 182A · Statesville, NCNTSB NYC72FLJ12Accident · Serious injuriesClosedCessna 182 · Rocky Mount, NCNTSB IAD72DLJ03Accident · No injuriesClosedCessna 182D · Cameron, NCNTSB IAD71DKM24Accident · No injuriesClosedCessna 180 · Denver, NCNTSB IAD71DKM17Accident · No injuriesClosedCessna 180B · Denver, NCNTSB IAD71DLJ13Accident · Minor injuriesClosedCessna 182 · Whiteville, NCNTSB DIA69F0062Accident · No injuriesClosedCessna 182 · Weddington, NCNTSB DIA68F0120Accident · No injuriesClosedCessna 182E · Asheboro, NCNTSB DIA68D0069Accident · No injuriesClosedCessna 188 · Wagram, NCNTSB DIA68D0003Accident · No injuriesClosedCessna 182 · Bethel, NCNTSB DIA67D0057Accident · No injuriesClosedCessna 180B · Wilkesboro, NCNTSB DIA67D0034Accident · No injuriesClosedCessna 182H · Archdale, NCNTSB MIA67D0238Accident · No injuriesClosedCessna 182J · Wallace, NCNTSB MIA67D0001Accident · No injuriesClosedCessna 182A · Lake Lure, NCNTSB MIA66F0553Accident · No injuriesClosedCessna 182 · Scotland Neck, NCNTSB MIA66F0403Accident · No injuriesClosedCessna 182E · Raleigh, NCNTSB MIA66F0328Accident · No injuriesClosedCessna 180 · Charlotte, NC