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 FTW68D0056Accident · No injuriesClosedCessna 150 · Morrilton, ARJun 24, 1967 · N7187F · Substantial damage NTSB OAK68D0044Accident · No injuriesClosedCessna 150 · San Jose, CAJun 23, 1967 · N2878S · 2 aircraft · Minor damage NTSB MKC68F0014Accident · No injuriesClosedCessna 150G · Goddard, KSJun 22, 1967 · N2698J · Substantial damage NTSB FTW68D0042Accident · No injuriesClosedCessna 150 · Abilene, TXJun 22, 1967 · N8892G · Substantial damage NTSB CHI68D0049Accident · No injuriesClosedCessna 150 · Franklin, WIJun 21, 1967 · N3876J · Substantial damage NTSB MKC68F0293Accident · No injuriesClosedCessna 150 · St Louis, MOJun 20, 1967 · N3031X · Substantial damage NTSB MKC68D0047Accident · No injuriesClosedCessna 150 · Red Oak, IAJun 19, 1967 · N8106S · Substantial damage NTSB FTW67F0019Accident · No injuriesClosedCessna 150 · Houma, LAJun 19, 1967 · N7150F · Substantial damage NTSB LAX68D0114Accident · No injuriesClosedCessna 150 · Compton, CAJun 18, 1967 · N8231F · Substantial damage NTSB SEA68F0072Accident · No injuriesClosedPiper J-3 · Bellevue, WAJun 17, 1967 · N7291H · Substantial damage NTSB NYC68D0073Accident · No injuriesClosedCessna 150 · Presque Isle, MEJun 17, 1967 · N8208F · Substantial damage NTSB MIA67F0574Accident · No injuriesClosedCessna 150 · Springfield, TNJun 17, 1967 · N8685G · Substantial damage NTSB MIA68D0049Accident · No injuriesClosedCessna 150 · Linden, ALJun 15, 1967 · N4608X · Substantial damage NTSB ANC68F0022Accident · No injuriesClosedCessna 150 · Anchorage, AKJun 15, 1967 · N8805S · Substantial damage NTSB MKC68F0017Accident · No injuriesClosedCessna 150G · St.Paul, MNJun 11, 1967 · N4669X · Substantial damage NTSB MIA68D0099Accident · No injuriesClosedCessna 150 · Bay Minette, ALJun 11, 1967 · N7811Z · Substantial damage NTSB SEA68D0056Accident · No injuriesClosedCessna 150 · Renton, WAJun 9, 1967 · N8799S · Substantial damage NTSB NYC68F0038Accident · Minor injuriesClosedCessna 150G · Shirley, NYJun 8, 1967 · N3176X · Substantial damage NTSB MKC68D0240Accident · No injuriesClosedCessna 150G · Portge D Sioux, MOJun 8, 1967 · N2635J · Substantial damage NTSB FTW68D0012Accident · No injuriesClosedCessna 150F · Geronimo, OKJun 6, 1967 · N3579L · Destroyed NTSB NYC68F0008Accident · No injuriesClosedCessna 150 · Wappinger Fall, NYJun 3, 1967 · N8712G · Substantial damage NTSB OAK67D0339Accident · No injuriesClosedCessna 150 · San Luis Ob, CAJun 2, 1967 · N6744F · Substantial damage NTSB MIA68D0021Accident · No injuriesClosedCessna 150 · Clewiston, FLJun 2, 1967 · N2934J · Substantial damage NTSB DEN68D0010Accident · No injuriesClosedCessna 150 · Briggsdale, COJun 2, 1967 · N3089J · Substantial damage NTSB CHI68D0310Accident · No injuriesClosedCessna 150 · East Alton, ILJun 2, 1967 · N6547F · Substantial damage NTSB LAX68D0023Accident · No injuriesClosedCessna 150 · Torrance, CAJun 1, 1967 · N6267T · Substantial damage NTSB MIA68F0012Accident · No injuriesClosedCessna 150 · Hollywood, FLMay 31, 1967 · N6254T · Substantial damage NTSB LAX67D0439Accident · No injuriesClosedCessna 150 · Avalon, CAMay 31, 1967 · N8634S · Substantial damage NTSB MIA67D0559Accident · No injuriesClosedCessna 150F · Ashland, ALMay 30, 1967 · N3081X · Substantial damage NTSB DIA68F0002Accident · Minor injuriesClosedCessna 150 · Michellville, MDMay 29, 1967 · N8692S · Substantial damage NTSB CHI68D0484Accident · No injuriesClosedCessna 150 · Lawrenceville, ILMay 27, 1967 · N3748J · Substantial damage NTSB LAX67D0456Accident · Minor injuriesClosedCessna 150 · Santa Ana, CAMay 26, 1967 · N3205X · Substantial damage NTSB FTW68D0050Accident · No injuriesClosedCessna 150 · Palacios, TXMay 26, 1967 · N2591J · Substantial damage NTSB CHI67F0671Accident · No injuriesClosedCessna 150 · Columbus, OHMay 25, 1967 · N6201T · Substantial damage NTSB MKC68F0254Accident · No injuriesClosedCessna 150 · Taylor, MOMay 24, 1967 · N6519F · Substantial damage NTSB FTW67F0624Accident · No injuriesClosedCessna 150 · Addison, TXMay 24, 1967 · N2778S · Substantial damage NTSB CHI68F0032Accident · No injuriesClosedCessna 150 · Freeland, MIMay 24, 1967 · N8687G · Substantial damage NTSB MIA67D0575Accident · No injuriesClosedCessna 150 · Fairburn, GAMay 23, 1967 · N3585J · Substantial damage NTSB DIA67F0110Accident · No injuriesClosedCessna 150G · Sandston, VAMay 23, 1967 · N4629X · Substantial damage NTSB NYC67D0661Accident · No injuriesClosedCessna 150 · Colts Neck, NJMay 21, 1967 · N6215T · Substantial damage NTSB SEA68F0011Accident · No injuriesClosedCessna 150E · Medford, ORMay 20, 1967 · N2502J · Substantial damage NTSB OAK68D0007Accident · No injuriesClosedCessna 150 · Tulare, CAMay 20, 1967 · N6540F · Substantial damage NTSB OAK67D0303Accident · No injuriesClosedCessna 150 · Olancha, CAMay 20, 1967 · N6645F · Substantial damage NTSB MKC67D0600Accident · No injuriesClosedCessna 150 · Carrollton, MOMay 19, 1967 · N7343X · Substantial damage NTSB FTW67D0620Accident · No injuriesClosedCessna 150 · Anneta, TXMay 19, 1967 · N6238R · Substantial damage NTSB OAK67D0317Accident · No injuriesClosedCessna 150 · Susanville, CAMay 18, 1967 · N3587J · Substantial damage NTSB MIA68D0098Accident · No injuriesClosedCessna 150G · Mobile, ALMay 16, 1967 · N3383J · Substantial damage NTSB LAX67D0406Accident · No injuriesClosedCessna 150 · Huntingtn B, CAMay 12, 1967 · N7086F · Substantial damage NTSB NYC67D0681Accident · No injuriesClosedCessna 150 · Plainville, CTMay 11, 1967 · N3790J · Substantial damage NTSB OAK68D0006Accident · No injuriesClosedCessna 150 · Fresno, CAMay 9, 1967 · N8688S · Substantial damage