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 FTW67D0269Accident · No injuriesClosedCessna 182A · Brideport, TXSep 2, 1966 · N2145G · Substantial damage NTSB LAX67F0119Accident · No injuriesClosedCessna 180 · Imperial, CAAug 30, 1966 · N5214D · Substantial damage NTSB FTW67D0190Accident · No injuriesClosedCessna 182 · Brownfield, TXAug 30, 1966 · N3183Y · Substantial damage NTSB UNK66X0167Accident · No injuriesClosedCessna 182 · Williams Lak, CanadaAug 28, 1966 · N6446A · Substantial damage NTSB NYC67F0197Accident · No injuriesClosedCessna 182J · Coxsackie, NYAug 28, 1966 · N3471F · Destroyed NTSB DEN67D0096Accident · No injuriesClosedCessna 180 · Kemmerer, WYAug 28, 1966 · N3642C · Substantial damage NTSB ANC67D0042Accident · No injuriesClosedCessna 180 · Port Alswrth, AKAug 27, 1966 · N9689B · Substantial damage NTSB CHI67D0229Accident · No injuriesClosedCessna 150 · Northbrook, ILAug 23, 1966 · N6130T · 2 aircraft · Substantial damage NTSB SEA67F0158Accident · No injuriesClosedCessna 310 · Hillsboro, ORAug 21, 1966 · N3028D · Substantial damage NTSB SEA67D0098Accident · No injuriesClosedCessna 180 · Pendleton, ORAug 21, 1966 · N1681C · Substantial damage NTSB OAK67D0085Accident · No injuriesClosedCessna 182 · Elko, NVAug 21, 1966 · N3303Y · Substantial damage NTSB CHI67F0207Accident · No injuriesClosedBeech H35 · Frankfort, MIAug 20, 1966 · N8208D · Substantial damage NTSB SEA67F0112Accident · No injuriesClosedCessna 182-A · Crescent Lke, ORAug 19, 1966 · N5878B · Substantial damage NTSB MKC67D0184Accident · No injuriesClosedCessna 182E · Mediapolis, IAAug 18, 1966 · N9348X · Substantial damage NTSB LAX67F0118Accident · Minor injuriesClosedCessna 310B · Ontario, CAAug 18, 1966 · N5380A · Substantial damage NTSB FTW67D0137Accident · No injuriesClosedCessna 180 · Westwego, LAAug 18, 1966 · N2786X · Substantial damage NTSB MKC67A0012Accident · Minor injuriesClosedCessna 182C · Underwood, MNAug 17, 1966 · N8819T · Substantial damage NTSB MKC67D0177Accident · No injuriesClosedCessna 182J · Minden, NEAug 15, 1966 · N2852F · Substantial damage NTSB MIA67D0135Accident · No injuriesClosedCessna 310 · Tifton, GAAug 14, 1966 · N4875B · Substantial damage NTSB SEA67D0124Accident · No injuriesClosedCessna 182 · Tacoma, WAAug 12, 1966 · N2371R · Substantial damage NTSB FTW67D0174Accident · No injuriesClosedCessna 182 · Edmond, OKAug 11, 1966 · N3366Y · Substantial damage NTSB OAK67F0046Accident · No injuriesClosedCessna 182S · Woodland, CAAug 10, 1966 · N3160S · Substantial damage NTSB LAX67D0264Accident · No injuriesClosedCessna 210 · Long Beach, CAAug 10, 1966 · N9562T · Substantial damage NTSB FTW67D0158Accident · No injuriesClosedCessna 310 · Addison, TXAug 10, 1966 · N3014D · Substantial damage NTSB LAX67D0050Accident · No injuriesClosedCessna 182 · Williams, AZAug 9, 1966 · N8999T · Substantial damage NTSB CHI67D0244Accident · No injuriesClosedCessna 180 · Arlington Hts, ILAug 7, 1966 · N1787C · Substantial damage NTSB FTW67D0150Accident · No injuriesClosedCessna 182 · Katy, TXAug 6, 1966 · N3023Y · Substantial damage NTSB FTW67D0325Accident · No injuriesClosedCessna 182 · El Paso, TXAug 5, 1966 · N3495S · Substantial damage NTSB SEA67D0102Accident · No injuriesClosedCessna 180 · W.Yellowstone, MTAug 3, 1966 · N5156E · Substantial damage NTSB SEA67D0094Accident · No injuriesClosedCessna 182 · Caldwell, IDAug 2, 1966 · N9940B · Substantial damage NTSB MKC67F0146Accident · Minor injuriesClosedCessna 182A · Mason City, IAAug 2, 1966 · N5183D · Substantial damage NTSB CHI67D0110Accident · No injuriesClosedCessna 310B · Milwaukee, WIAug 1, 1966 · N5396A · Substantial damage NTSB NYC67F0155Accident · No injuriesClosedCessna 182 · Red Hook, NYJul 31, 1966 · N2680F · Substantial damage NTSB MKC67D0222Accident · No injuriesClosedCessna 182 · Leawood, KSJul 31, 1966 · N3187Y · Substantial damage NTSB MIA67F0107Accident · No injuriesClosedCessna 310 · Atlanta, GAJul 25, 1966 · N3684D · Substantial damage NTSB DEN67D0040Accident · No injuriesClosedCessna 182 · Colorado Sprg, COJul 24, 1966 · N2450R · Substantial damage NTSB ANC67A0013Accident · No injuriesClosedCessna 205 · Healy, AKJul 24, 1966 · N1898Z · No damage NTSB SEA67D0206Accident · No injuriesClosedCessna 182 · Georgetown, WAJul 22, 1966 · N182Y · Substantial damage NTSB NYC67D0101Accident · No injuriesClosedCessna 182J · Rock Hall, MDJul 22, 1966 · N2899F · Substantial damage NTSB OAK67D0116Accident · No injuriesClosedCessna 182 · Reno, NVJul 17, 1966 · N1809X · Substantial damage NTSB LAX67D0083Accident · No injuriesClosedCessna 310 · Burbank, CAJul 17, 1966 · N3634D · Substantial damage NTSB CHI67F0131Accident · No injuriesClosedCessna 180 · Sparta, ILJul 17, 1966 · N9371T · Destroyed NTSB FTW67D0097Accident · No injuriesClosedCessna 182E · Umbarger, TXJul 16, 1966 · N3330Y · Substantial damage NTSB ANC67A0007Accident · Minor injuriesClosedCessna 180 · Kodiak, AKJul 16, 1966 · N9737B · Destroyed NTSB FTW67D0070Accident · No injuriesClosedCessna 180 · St Martin, LAJul 14, 1966 · N9541B · Substantial damage NTSB CHI67A0006Accident · No injuriesClosedCessna 180A · Detroit, MIJul 11, 1966 · N9764B · Substantial damage NTSB SEA67D0036Accident · No injuriesClosedCessna 182 · Riggins, IDJul 10, 1966 · N3401S · Substantial damage NTSB DEN66F0044Accident · No injuriesClosedCessna 182 · Sandy, UTJul 10, 1966 · N4968D · Substantial damage NTSB FTW67D0091Accident · No injuriesClosedCessna 182 · Lufkin, TXJul 9, 1966 · N9046T · Substantial damage NTSB CAN F0406Accident · No injuriesClosedEssna 182 · Tsuniah Lake, CanadaJul 9, 1966 · N6253A · Substantial damage