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 FTW67D0476Accident · No injuriesClosedCessna 150 · Jacksboro, TXFeb 6, 1967 · N8712S · Substantial damage NTSB NYC67D0542Accident · No injuriesClosedCessna 150 · Jackson Mills, NJFeb 5, 1967 · N4214U · Substantial damage NTSB NYC67D0481Accident · No injuriesClosedCessna 150 · Bethel, PAFeb 5, 1967 · N7721F · Substantial damage NTSB MIA67D0393Accident · No injuriesClosedCessna 150 · Copeland, FLFeb 5, 1967 · N3711S · Substantial damage NTSB LAX67D0287Accident · No injuriesClosedChampion 7ECA · Hoenix, AZFeb 5, 1967 · N2515F · Substantial damage NTSB NYC67F0497Accident · No injuriesClosedCessna 150 · Tyrone, PAFeb 4, 1967 · N3446J · Destroyed NTSB CHI67D0586Accident · No injuriesClosedCessna 150 · Peoria, ILFeb 4, 1967 · N3829J · Substantial damage NTSB OAK67D0312Accident · No injuriesClosedCessna 150 · Minden, NVFeb 3, 1967 · N6770F · Substantial damage NTSB LAX67F0268Accident · Serious injuriesClosedCessna 150F · Huntington B, CAFeb 1, 1967 · N8910S · 2 aircraft · Substantial damage NTSB LAX67D0385Accident · No injuriesClosedCessna 150 · 29 Palms, CAFeb 1, 1967 · N3203X · Substantial damage NTSB DEN67D0196Accident · Minor injuriesClosedCessna 150F · Longmont, COJan 31, 1967 · N8701S · Substantial damage NTSB MKC67F0418Accident · No injuriesClosedCessna 150 · Lawrence, KSJan 29, 1967 · N8550G · Substantial damage NTSB MIA67D0537Accident · Minor injuriesClosedCessna 150G · Winnsboro, SCJan 28, 1967 · N4095J · Substantial damage NTSB FTW67D0414Accident · No injuriesClosedCessna 150 · Mesquite, TXJan 28, 1967 · N7130F · Substantial damage NTSB OAK67F0204Accident · No injuriesClosedCessna 150 · Sacramento, CAJan 25, 1967 · N3171X · Substantial damage NTSB MIA67D0384Accident · No injuriesClosedCessna 150 · Orlando, FLJan 25, 1967 · N4627X · Substantial damage NTSB MIA67F0353Accident · No injuriesClosedCessna 150 · Opa Locka, FLJan 24, 1967 · N35375 · 2 aircraft · Substantial damage NTSB DIA67D0032Accident · No injuriesClosedCessna 150 · Hagerstown, MDJan 24, 1967 · N8098S · Substantial damage NTSB DIA67D0031Accident · No injuriesClosedCessna 150F · Gaithersburg, MDJan 24, 1967 · N8716S · Substantial damage NTSB NYC67F0468Accident · No injuriesClosedCessna 150 · Deer Park, NYJan 23, 1967 · N8412G · Substantial damage NTSB CHI67F0585Accident · No injuriesClosedCessna 150G · Camp Grove, ILJan 23, 1967 · N3621J · Substantial damage NTSB NYC67D0489Accident · No injuriesClosedCessna 150 · Sewell, NJJan 22, 1967 · N3976J · 2 aircraft · Substantial damage NTSB DEN67F0195Accident · No injuriesClosedCessna 150G · Loveland, COJan 21, 1967 · N2224J · Substantial damage NTSB NYC67F0473Accident · No injuriesClosedCessna 150 · Ronkonkoma, NYJan 18, 1967 · N3689J · Substantial damage NTSB NYC67D0464Accident · No injuriesClosedCessna 150 · Milton, VTJan 18, 1967 · N6995F · Substantial damage NTSB FTW67F0411Accident · Minor injuriesClosedCessna 150 · Jenks, OKJan 15, 1967 · N3635J · Substantial damage NTSB MKC67D0379Accident · No injuriesClosedCessna 150 · Hopkins, MNJan 12, 1967 · N6960F · Substantial damage NTSB SEA67D0286Accident · No injuriesClosedCessna 150 · Broadus, MTJan 11, 1967 · N4190U · Substantial damage NTSB CHI67D0448Accident · No injuriesClosedCessna 150A · Newport, INJan 11, 1967 · N7012X · Substantial damage NTSB OAK67D0220Accident · No injuriesClosedCessna 150 · Reno, NVJan 9, 1967 · N6965F · Substantial damage NTSB NYC67D0466Accident · No injuriesClosedCessna 150 · Wallkill, NYJan 2, 1967 · N8572G · Substantial damage NTSB MIA67F0381Accident · No injuriesClosedChampion 7ECA · Bainbridge, GADec 31, 1966 · N2570F · Substantial damage NTSB NYC67D0455Accident · No injuriesClosedCessna 150 · Sheffield, MADec 30, 1966 · N8663G · Substantial damage NTSB NYC67D0453Accident · No injuriesClosedCessna 150 · White Plains, NYDec 30, 1966 · N7950Z · Substantial damage NTSB FTW67F0399Accident · Minor injuriesClosedCessna 150 · Palo Pinto, TXDec 30, 1966 · N7320X · Substantial damage NTSB OAK67D0180Accident · No injuriesClosedCessna 150 · Vallejo, CADec 29, 1966 · N4781X · Substantial damage NTSB MIA67D0344Accident · Minor injuriesClosedCessna 150 · Miami, FLDec 28, 1966 · N4709X · Substantial damage NTSB OAK67D0200Accident · No injuriesClosedCessna 150 · Ely, NVDec 27, 1966 · N3915U · Substantial damage NTSB MKC67D0370Accident · No injuriesClosedCessna 150F · Alta Vista, IADec 24, 1966 · N2431J · Substantial damage NTSB NYC67F0444Accident · No injuriesClosedCessna 150 · Broadbrook, CTDec 23, 1966 · N5558E · Substantial damage NTSB NYC67D0474Accident · No injuriesClosedCessna 150 · Morristown, NJDec 23, 1966 · N3516J · Substantial damage NTSB FTW67D0374Accident · No injuriesClosedCessna 150B · Enid, OKDec 23, 1966 · N7390X · Substantial damage NTSB MKC67F0344Accident · No injuriesClosedCessna 150 · Cleveland, NDDec 22, 1966 · N5912E · Substantial damage NTSB CHI67F0431Accident · No injuriesClosedCessna 150D · Deerfield, ILDec 22, 1966 · N4429U · Substantial damage NTSB NYC67D0432Accident · No injuriesClosedCessna 150 · White Plains, NYDec 18, 1966 · N3190X · Substantial damage NTSB NYC67D0425Accident · No injuriesClosedCessna 150 · Norwood, MADec 18, 1966 · N3078X · Substantial damage NTSB MKC67F0351Accident · No injuriesClosedCessna 150 · Columbia, MODec 17, 1966 · N3131X · Substantial damage NTSB NYC67D0447Accident · No injuriesClosedCessna 150 · West Caldwell, NJDec 16, 1966 · N8224F · Substantial damage NTSB MKC67F0420Accident · Minor injuriesClosedCessna 150 · Goddard, KSDec 15, 1966 · N2213J · Substantial damage NTSB MKC67F0422Accident · No injuriesClosedCessna 150G · Manhattan, KSDec 13, 1966 · N3805J · Substantial damage