Skip to content

NTSB investigations: Continental O-470 series

6,204 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.

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

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 MKC66D0539Accident · No injuriesClosedCessna 180 · Trenton, MOMay 5, 1966 · N3624C · Substantial damage NTSB MIA66D0544Accident · No injuriesClosedCessna 182 · Little River, SCMay 4, 1966 · N8607T · Substantial damage NTSB DEN66D0328Accident · No injuriesClosedCessna 182 · Bagdad, AZMay 1, 1966 · N2092G · Substantial damage NTSB OAK66D0295Accident · No injuriesClosedCessna 182H · Monterey, CAApr 30, 1966 · N2702F · Substantial damage NTSB MIA66D0591Accident · No injuriesClosedCessna 182 · Atlanta, GAApr 30, 1966 · N3513Y · Substantial damage NTSB DEN66F0300Accident · No injuriesClosedCessna 182 · Albuquerque, NMApr 30, 1966 · N2793F · Substantial damage NTSB DEN66D0307Accident · No injuriesClosedCessna 182 · Big Piney, WYApr 30, 1966 · N5047D · Substantial damage NTSB MIA66D0568Accident · No injuriesClosedCessna 180E · Clewiston, FLApr 28, 1966 · N2670Y · Substantial damage NTSB FTW66D0630Accident · No injuriesClosedCessna 180 · Hastings, OKApr 28, 1966 · N2755X · Substantial damage NTSB LAX66D0350Accident · No injuriesClosedCessna 182 · Rancho Mirage, CAApr 24, 1966 · N3560Y · Substantial damage NTSB UNK66X0138Accident · No injuriesClosedCessna 182 · Mulege Baja Calif, MexicoApr 19, 1966 · N2464R · Substantial damage NTSB NYC66F0617Accident · No injuriesClosedCessna 182 · Osceola, PAApr 18, 1966 · N3135U · Substantial damage NTSB NYC66F0627Accident · No injuriesClosedBellanca 14-19 · Palmer, MAApr 15, 1966 · N7697B · Substantial damage NTSB FTW66F0614Accident · Minor injuriesClosedCessna 182 · Donna, TXApr 14, 1966 · N2472R · Substantial damage NTSB FTW66F0619Accident · No injuriesClosedPiper PA-25 · Cleo Springs, OKApr 11, 1966 · N6073Z · Substantial damage NTSB OAK66D0260Accident · No injuriesClosedCessna 180 · Olancha, CAApr 10, 1966 · N9339C · Substantial damage NTSB DEN66D0290Accident · No injuriesClosedCessna 182 · Douglas, AZApr 9, 1966 · N2616F · Substantial damage NTSB FTW66F0622Accident · No injuriesClosedBellanca 14-19 · Floydada, TXApr 8, 1966 · N7600E · Substantial damage NTSB DEN66D0279Accident · No injuriesClosedCessna 180 · Broomfield, COApr 8, 1966 · N3682C · Substantial damage NTSB LAX66F0292Accident · No injuriesClosedCessna 310 · Santa Monica, CAApr 6, 1966 · N5273A · Substantial damage NTSB SEA66D0251Accident · No injuriesClosedCessna 182G · Port Angeles, WAApr 5, 1966 · N2181R · Substantial damage NTSB DEN66F0277Accident · No injuriesClosedCessna 182A · Salt Lake City, UTApr 5, 1966 · N2120G · Substantial damage NTSB FTW66F0564Accident · No injuriesClosedCessna 182 · New Orleans, LAApr 3, 1966 · N2402X · Substantial damage NTSB FTW66D0687Accident · No injuriesClosedCessna 182E · San Antonio, TXApr 3, 1966 · N2889Y · Substantial damage NTSB CHI66F0652Accident · No injuriesClosedCessna 182 · Cincinnati, OHApr 1, 1966 · N2636F · Substantial damage NTSB NYC66D0590Accident · No injuriesClosedCessna 182 · Medford, NJMar 31, 1966 · N5648B · Substantial damage NTSB MIA66F0484Accident · No injuriesClosedBeech H35 · Tampa, FLMar 27, 1966 · N5497D · Substantial damage NTSB LAX66D0329Accident · No injuriesClosedCessna 182 · Rancho Mirage, CAMar 27, 1966 · N8424S · Substantial damage NTSB OAK66D0265Accident · No injuriesClosedCessna 180 · Lone Pine, CAMar 26, 1966 · N5231E · Substantial damage NTSB OAK66D0248Accident · No injuriesClosedCessna 182F · Coalinga, CAMar 26, 1966 · N3653U · Substantial damage NTSB MIA66D0478Accident · No injuriesClosedCessna 182 · Florence, ALMar 25, 1966 · N8503T · Substantial damage NTSB LAX66F0316Accident · No injuriesClosedCessna 182 · Tonapah, NVMar 25, 1966 · N5616B · Substantial damage NTSB CHI66F0640Accident · No injuriesClosedCessna 305A · South Haven, MIMar 25, 1966 · N10442 · Substantial damage NTSB FTW66F0580Accident · No injuriesClosedCessna 310 · New Orleans, LAMar 23, 1966 · N4877B · Substantial damage NTSB MIA66D0480Accident · No injuriesClosedCessna 182 · Florence, ALMar 20, 1966 · N2195G · Substantial damage NTSB MKC66D0472Accident · No injuriesClosedCessna 182A · Marshall, MOMar 18, 1966 · N5922B · Substantial damage NTSB NYC66F0571Accident · No injuriesClosedCessna 182 · Camillus, NYMar 17, 1966 · N8524S · Substantial damage NTSB FTW66F0559Accident · No injuriesClosedCessna 182 · Dalhart, TXMar 17, 1966 · N2675F · Substantial damage NTSB FTW66F0594Accident · No injuriesClosedCessna 182 · Angleton, TXMar 16, 1966 · N3279U · Substantial damage NTSB SEA66D0229Accident · No injuriesClosedCessna 310 · Troutdale, ORMar 15, 1966 · N3028D · Substantial damage NTSB OAK66D0206Accident · No injuriesClosedCessna 180 · Esparto, CAMar 13, 1966 · N181ST · Substantial damage NTSB MIA66A0105Accident · No injuriesClosedCessna 310F · San Juan, PRMar 13, 1966 · N6763X · Substantial damage NTSB FTW66F0555Accident · No injuriesClosedCessna 182H · Morton, TXMar 10, 1966 · N1816X · Substantial damage NTSB MIA66D0482Accident · No injuriesClosedCessna 180 · Griffin, GAMar 8, 1966 · N2388C · Substantial damage NTSB FTW66D0553Accident · No injuriesClosedCessna 182 · Eldordo, TXMar 5, 1966 · N5114D · Substantial damage NTSB UNK66X0127Accident · No injuriesClosedCessna 180 · El Socorro, MexicoMar 4, 1966 · N1584C · Substantial damage NTSB NYC66D0574Accident · No injuriesClosedCessna 182 · Toms River, NJMar 2, 1966 · N2384G · Substantial damage NTSB MIA66F0445Accident · Minor injuriesClosedCessna 182 · Pelahatchie, MSMar 1, 1966 · N8356S · Substantial damage NTSB ANC66A0035Accident · No injuriesClosedCessna 180 · Dillingham, AKFeb 28, 1966 · N9651B · Substantial damage NTSB FTW67F0001Accident · No injuriesClosedCessna 182 · Little Rock, ARFeb 25, 1966 · N3123Y · Substantial damage