Skip to content

NTSB investigations: Continental 0-200 series

6,416 cases on aircraft whose registry engine model is Continental 0-200 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 ('17020')) 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 ('17020'))
  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 ('17020'))
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 OAK67D0075Accident · No injuriesClosedCessna 150 · Minden, NVAug 23, 1966 · N8286S · Substantial damage NTSB MKC67D0164Accident · No injuriesClosedCessna 150F · Boone, IAAug 23, 1966 · N6999F · Substantial damage NTSB CHI67D0229Accident · No injuriesClosedCessna 150 · Northbrook, ILAug 23, 1966 · N6130T · 2 aircraft · Substantial damage NTSB NYC67F0224Accident · No injuriesClosedCessna 150 · Ronkonkoma, NYAug 21, 1966 · N6991F · Substantial damage NTSB NYC67F0204Accident · Minor injuriesClosedCessna 150B · Rye, NYAug 18, 1966 · N1285T · Substantial damage NTSB SEA67D0110Accident · No injuriesClosedCessna 150F · Belgrade, MTAug 16, 1966 · N8024S · Substantial damage NTSB FTW67D0138Accident · No injuriesClosedCessna 150 · Freemason Isle, LAAug 16, 1966 · N8459G · Substantial damage NTSB NYC67D0177Accident · No injuriesClosedCessna 150F · Hurlock, MDAug 13, 1966 · N8946S · Substantial damage NTSB OAK67D0069Accident · No injuriesClosedCessna 150 · S.Luis Obispo, CAAug 11, 1966 · N8805G · Substantial damage NTSB MKC67D0154Accident · No injuriesClosedCessna 150 · Davenport, IAAug 11, 1966 · N6292T · Substantial damage NTSB FTW67D0144Accident · No injuriesClosedCessna 150B · Sterling City, TXAug 10, 1966 · N7370X · Substantial damage NTSB OAK67D0066Accident · No injuriesClosedCessna 150 · Fresno, CAAug 8, 1966 · N8688S · Substantial damage NTSB MIA67F0216Accident · Minor injuriesClosedCessna 150D · No. Charleston, SCAug 8, 1966 · N5975T · Substantial damage NTSB MIA67F0111Accident · Serious injuriesClosedCessna 150 · Hernando, MSAug 6, 1966 · N7978Z · Substantial damage NTSB FTW67D0172Accident · Minor injuriesClosedCessna 150 · Corsicana, TXAug 6, 1966 · N6802F · Substantial damage NTSB CHI67D0346Accident · No injuriesClosedCessna 150 · Chicago, ILAug 6, 1966 · N3047X · Substantial damage NTSB DEN67D0072Accident · No injuriesClosedCessna 150 · Jal, NMAug 5, 1966 · N8208S · Substantial damage NTSB MKC67F0141Accident · No injuriesClosedCessna 150F · Columbus, NEAug 2, 1966 · N6813F · Substantial damage NTSB MKC67D0163Accident · No injuriesClosedCessna 150 · El Dorado, KSAug 2, 1966 · N8101F · Substantial damage NTSB FTW67D0132Accident · No injuriesClosedCessna 150 · Fort Worth, TXAug 2, 1966 · N7344X · No damage NTSB MKC67F0210Accident · No injuriesClosedCessna 150E · St Louis, MOAug 1, 1966 · N3584J · Substantial damage NTSB ANC67F0039Accident · No injuriesClosedCessna 150F · Anchorage, AKJul 31, 1966 · N8805S · Substantial damage NTSB MKC67D0107Accident · No injuriesClosedCessna 150 · Norwood, MNJul 30, 1966 · N6988F · Substantial damage NTSB DEN67D0089Accident · No injuriesClosedCessna 150 · Las Cruces, NMJul 30, 1966 · N8006F · Substantial damage NTSB CHI67D0153Accident · No injuriesClosedCessna 150 · Bloomington, INJul 30, 1966 · N8289F · Substantial damage NTSB CHI67D0124Accident · No injuriesClosedCessna 150 · Rockford, ILJul 30, 1966 · N8021S · Substantial damage NTSB OAK67F0070Accident · No injuriesClosedCessna 150 · Minden, NVJul 29, 1966 · N3054X · 2 aircraft · Substantial damage NTSB MIA67D0093Accident · No injuriesClosedCessna 172 · Birmingham, ALJul 28, 1966 · N3823L · Substantial damage NTSB NYC67D0131Accident · No injuriesClosedCessna 150 · Meriden, CTJul 27, 1966 · N4569U · Substantial damage NTSB NYC67F0293Accident · No injuriesClosedCessna 150 · Endicott, NYJul 25, 1966 · N4308U · 2 aircraft · Substantial damage NTSB FTW67D0126Accident · No injuriesClosedCessna 150D · Giddings, TXJul 25, 1966 · N4340U · Substantial damage NTSB DEN67D0079Accident · No injuriesClosedCessna 150 · Denver, COJul 25, 1966 · N8023S · Substantial damage NTSB LAX67F0030Accident · No injuriesClosedCessna 150 · Van Nuys, CAJul 24, 1966 · N6222R · Substantial damage NTSB MIA67D0387Accident · Minor injuriesClosedCessna 150 · Phil Campbell, ALJul 23, 1966 · N6211T · Substantial damage NTSB LAX67F0099Accident · No injuriesClosedCessna 150 · San Diego, CAJul 23, 1966 · N8862S · Substantial damage NTSB DEN67D0053Accident · No injuriesClosedCessna 150 · Roosevelt, UTJul 23, 1966 · N2079Z · Substantial damage NTSB MKC67F0105Accident · No injuriesClosedCessna 150 · Waldron, MOJul 19, 1966 · N7898Z · Substantial damage NTSB MKC67D0121Accident · No injuriesClosedCessna 150 · Red Oak, IAJul 18, 1966 · N8106S · Substantial damage NTSB NYC67F0073Accident · No injuriesClosedCessna 150 · Scarboro, MEJul 17, 1966 · N6508T · Substantial damage NTSB FTW67F0096Accident · No injuriesClosedCessna 150F · Bogalusa, LAJul 16, 1966 · N8457G · Substantial damage NTSB OAK67A0006Accident · 2 fatalClosedCessna 150 · Minden, NVJul 15, 1966 · N8702S · Destroyed NTSB OAK67D0041Accident · No injuriesClosedChampion 7EC · Yuba City, CAJul 14, 1966 · N9571S · Substantial damage NTSB MIA67F0059Accident · No injuriesClosedCessna 150 · St Petersburg, FLJul 14, 1966 · N3578J · Substantial damage NTSB FTW67D0072Accident · No injuriesClosedCessna 150 · Ardmore, OKJul 14, 1966 · N8191S · Substantial damage NTSB NYC67D0167Accident · No injuriesClosedCessna 150 · New City, NYJul 13, 1966 · N8128F · Substantial damage NTSB FTW67D0093Accident · No injuriesClosedCessna 150 · Austin, TXJul 13, 1966 · N6421T · Substantial damage NTSB NYC67D0102Accident · No injuriesClosedCessna 150 · Gaithersburg, MDJul 12, 1966 · N7811E · Substantial damage NTSB CHI67D0104Accident · No injuriesClosedCessna 150 · Indianapolis, INJul 10, 1966 · N6518F · Substantial damage NTSB CHI67F0161Accident · No injuriesClosedCessna 150 · Kankakee, ILJul 9, 1966 · N1146Y · 2 aircraft · Substantial damage NTSB OAK67D0033Accident · No injuriesClosedChampion 7ECA · Riverdale, CAJul 8, 1966 · N2558F · Substantial damage