Skip to content

NTSB investigations: Continental C85 series

2,292 cases on aircraft whose registry engine model is Continental C85 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17008')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17008'))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17008'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 OAK67D0089Accident · No injuriesClosedCessna 140 · Las Vegas, NVJun 4, 1966 · N3588V · Substantial damage NTSB LAX66F0375Accident · Minor injuriesClosedCessna 140 · San Diego, CAMay 31, 1966 · N3135N · Substantial damage NTSB CHI66F0764Accident · No injuriesClosedLuscombe 8E · Cahokia, ILMay 29, 1966 · N1829K · Substantial damage NTSB FTW66F0704Accident · No injuriesClosedCessna 120 · Odessa, TXMay 26, 1966 · N1873N · Substantial damage NTSB MKC66F0583Accident · No injuriesClosedCessna 120 · Rosemount, MNMay 21, 1966 · N1922N · Substantial damage NTSB OAK67D0023Accident · No injuriesClosedCessna 140 · Angels Camp, CAMay 19, 1966 · N2370V · Substantial damage NTSB MIA67F0052Accident · Serious injuriesClosedCessna 140 · Beaufort, SCMay 18, 1966 · N73023 · Substantial damage NTSB CAN F0393Accident · No injuriesClosedCessna 120 · Yukon Territy, CanadaMay 16, 1966 · N2041V · Substantial damage NTSB MIA67D0051Accident · No injuriesClosedCessna 140 · Statesville, NCMay 14, 1966 · N3156N · Substantial damage NTSB MIA66F0560Accident · No injuriesClosedCessna 140 · Auburndale, FLMay 12, 1966 · N76430 · Substantial damage NTSB SEA66D0269Accident · No injuriesClosedCessna 120 · Boise, IDMay 10, 1966 · N76892 · Substantial damage NTSB CHI66D0752Accident · No injuriesClosedLuscombe 8E · Northfield, OHMay 7, 1966 · N1816K · Substantial damage NTSB FTW66D0655Accident · No injuriesClosedErcoupe 415-C · Abilene, TXMay 4, 1966 · N99073 · Substantial damage NTSB NYC66F0690Accident · No injuriesClosedAeronca 7BCM · Morrisville, VTMay 1, 1966 · N2035A · Substantial damage NTSB MIA66D0530Accident · Minor injuriesClosedCessna 140 · Eupora, MSMay 1, 1966 · N76653 · Substantial damage NTSB SEA67F0007Accident · No injuriesClosedCessna 140 · Medford, ORApr 27, 1966 · N2172V · Substantial damage NTSB MKC67D0031Accident · No injuriesClosedPiper PA-11 · Stratford, IAApr 26, 1966 · N4688M · Substantial damage NTSB SEA67D0002Accident · No injuriesClosedCessna 140 · Crane Island, WAApr 24, 1966 · N77086 · Substantial damage NTSB CHI66F0666Accident · No injuriesClosedCessna 140 · Milwaukee, WIApr 16, 1966 · N89523 · Substantial damage NTSB CHI66F0657Accident · No injuriesClosedErco 415-C · Dayton, OHApr 9, 1966 · N99919 · Substantial damage NTSB SEA66F0262Accident · No injuriesClosedLuscombe 8E · Vancouver, WAApr 8, 1966 · N1717K · Substantial damage NTSB CHI66D0679Accident · No injuriesClosedCessna 120 · Canton, OHApr 6, 1966 · N1694V · Substantial damage NTSB CHI66F0730Accident · No injuriesClosedCessna 140 · Springfield, ILApr 3, 1966 · N77365 · Substantial damage NTSB OAK66F0234Accident · No injuriesClosedCessna 120 · Lincoln, NEMar 31, 1966 · N1799N · Substantial damage NTSB OAK66F0238Accident · No injuriesClosedLuscombe 8E · Chico, CAMar 22, 1966 · N1003K · Substantial damage NTSB OAK66D0229Accident · No injuriesClosedAeronca 7AC · Davis, CAMar 22, 1966 · N1660E · Substantial damage NTSB NYC66D0568Accident · No injuriesClosedCessna 140 · Corry, PAMar 21, 1966 · N89404 · Substantial damage NTSB MIA66F0489Accident · No injuriesClosedErco 415-C · Punta Gorda, FLMar 20, 1966 · N87292 · Substantial damage NTSB MKC66F0480Accident · Minor injuriesClosedCessna 140 · St Joseph, MOMar 18, 1966 · N89555 · Substantial damage NTSB FTW66F0538Accident · No injuriesClosedCessna 140 · Sulphur Sps, TXMar 15, 1966 · N3180N · Substantial damage NTSB LAX66A0066Accident · 2 fatalClosedPiper J5A · Mc Farland, CAMar 6, 1966 · N54460 · Destroyed NTSB DEN66D0281Accident · No injuriesClosedTaylorcraft BC12-D · Seely, WYMar 6, 1966 · N95051 · Substantial damage NTSB FTW66F0574Accident · Minor injuriesClosedCessna 140 · Houston, TXMar 5, 1966 · N76962 · Substantial damage NTSB MKC66D0491Accident · Minor injuriesClosedCessna 140 · Coffeyvill, KSFeb 28, 1966 · N76152 · Destroyed NTSB CHI66F0623Accident · No injuriesClosedLuscombe 8A · Manistique, MIFeb 28, 1966 · N1858K · Substantial damage NTSB NYC66F0543Accident · No injuriesClosedAeronca 7BCM · Cumberland, MDFeb 20, 1966 · N4064A · Substantial damage NTSB NYC66F0520Accident · No injuriesClosedCessna 120 · Waldo, MEFeb 19, 1966 · N2773N · Substantial damage NTSB MIA66D0477Accident · No injuriesClosedCessna 140 · Merritt Is, FLFeb 19, 1966 · N2458N · Substantial damage NTSB NYC66D0535Accident · Minor injuriesClosedPiper J3 · Cherry Hill, NJFeb 7, 1966 · N6384H · Substantial damage NTSB MIA66F0424Accident · Minor injuriesClosedLuscombe 8A · Raleigh, NCFeb 6, 1966 · N1331B · Substantial damage NTSB CHI66D0612Accident · No injuriesClosedCessna 140 · Flora, INFeb 5, 1966 · N89361 · Substantial damage NTSB CHI66F0580Accident · No injuriesClosedCessna 140 · Sycamore, ILFeb 4, 1966 · N81093 · Substantial damage NTSB FTW66F0507Accident · No injuriesClosedCessna 140A · Ardmore, OKFeb 3, 1966 · N1152D · Substantial damage NTSB CHI66D0557Accident · No injuriesClosedCessna 120 · Wooster, OHFeb 3, 1966 · N72783 · Substantial damage NTSB NYC66F0473Accident · No injuriesClosedPiper J3C · Chesapeake, VAJan 25, 1966 · N6443H · Substantial damage NTSB MKC66F0454Accident · Serious injuriesClosedPiper PA-11 · Tolstoy, SDJan 25, 1966 · N78820 · Substantial damage NTSB FTW66D0496Accident · No injuriesClosedCessna 140 · Arlington, TXJan 23, 1966 · N90110 · Substantial damage NTSB MIA66F0404Accident · Minor injuriesClosedCessna 120 · Hollywood, FLJan 10, 1966 · N72536 · Substantial damage NTSB MKC66D0385Accident · No injuriesClosedCessna 120 · Des Moines, IAJan 9, 1966 · N72715 · Substantial damage NTSB CHI66F0494Accident · Minor injuriesClosedCessna 120 · Greenville, MIJan 1, 1966 · N2946N · Substantial damage