NTSB investigations: Continental 0-200 series, 1978
209 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.
Cases, newest first
Query with SQL
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 year(c.\"eventDate\") = 1978
AND 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 year(c."eventDate") = 1978
AND 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" DESCRun 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 FTW78FRD56Accident · No injuriesClosedCessna 150 · Lake Charles, LANTSB CHI78DEE67Accident · No injuriesClosedCessna 150 · Wheeling, ILNTSB FTW78FQG50Accident · No injuriesClosedCessna 150L · Dalhart, TXNTSB FTW78DPJ38Accident · No injuriesClosedCessna 150 · Tuttle, OKNTSB NYC78FHM28Accident · No injuriesClosedCessna 150 · West Milford, NJNTSB NYC78FA089Accident · 2 fatalClosedCessna 150M · Millbury, MANTSB CHI78FEP66Accident · No injuriesClosedCessna 150 · Kenosha, WINTSB NYC79FHD23Accident · No injuriesClosedCessna 150L · Robinsville, NJNTSB IAD78FA105Accident · 2 fatalClosedCessna 150 · Louisville, KYNTSB FTW78FRJ32Accident · Minor injuriesClosedCessna 150J · Mooringsport, LANTSB LAX78FUQ42Accident · Serious injuriesClosedCessna 150J · Santa Barbara, CANTSB MIA78DLD72Accident · No injuriesClosedCessna 150 · Ft Pierce, FLNTSB OAK78DVG75Accident · No injuriesClosedCessna 150 · Placerville, CANTSB CHI78DEP62Accident · No injuriesClosedCessna 150 · Milwaukee, WINTSB CHI78DEP60Accident · No injuriesClosedCessna 150K · Kenosha, WINTSB NYC78FGM45Accident · No injuriesClosedCessna 150 · Franklin, PANTSB CHI78FEM32Accident · Minor injuriesClosedCessna 150L · Lansing, MINTSB ANC78DAH67Accident · No injuriesClosedCessna 150 · Tyonek, AKNTSB DEN78FQD29Accident · No injuriesClosedCessna 150 · Vado, NMNTSB MIA78FKT68Accident · Serious injuriesClosedCessna 150 · Pahokee, FLNTSB IAD78FLT09Accident · No injuriesClosedCessna 150 · Covington, KYNTSB MKC78FCQ36Accident · 1 fatalClosedVari-Eze · Liberal, KSNTSB MIA78FKG70Accident · No injuriesClosedCessna 150 · Savannah, GANTSB LAX78FUQ41Accident · Serious injuriesClosedCessna 150A · Pacoima, CANTSB CHI78FA052Accident · 2 fatalClosedPiper PA-22 · East Moline, ILNTSB MKC78DER87Accident · No injuriesClosedCessna 150G · Lester Prairie, MNNTSB ANC78DAG90Accident · No injuriesClosedCessna 150L · Wasilla, AKNTSB MKC78FCA40Accident · Minor injuriesClosedCessna 150 · St Charles, MONTSB FTW78DPG70Accident · No injuriesClosedCessna 150 · Lakeview, ARNTSB LAX78DVA68Accident · No injuriesClosedCessna 150 · Bakersfield, CANTSB CHI78FE130Accident · No injuriesClosedCessna 150F · Northfield, OHNTSB IAD78DKM15Accident · No injuriesClosedCessna 150 · Lucia, NCNTSB FTW78FPD25Accident · No injuriesClosedCessna 150G · Grand Prairie, TXNTSB FTW78DPD26Accident · Minor injuriesClosedCessna 150J · Iowa Park, TXNTSB MIA78FKG64Accident · Minor injuriesClosedCessna 150 · Athens, GANTSB IAD78FLJ17Accident · No injuriesClosedCessna 150 · Washington, NCNTSB CHI78DEE66Accident · No injuriesClosedCessna 150 · Aperville, ILNTSB CHI78FEK26Accident · No injuriesClosedCessna 150F · Marysville, OHNTSB CHI78FEG14Accident · No injuriesClosedCessna 150M · Cleves, OHNTSB CHI78FEK24Accident · 1 fatalClosedCessna 150M · Urbana, OHNTSB SEA78DTA16Accident · No injuriesClosedCessna 150 · Miles City, MTNTSB FTW78FRG62Accident · No injuriesClosedCessna 150 · Sandia, TXNTSB ANC78FA052Accident · 1 fatalClosedCessna 150M · Cantwell, AKNTSB DEN78FQA38Accident · No injuriesClosedCessna 150G · Albuquerque, NMNTSB DEN78DTE72Accident · No injuriesClosedCessna 150 · Sterling, CONTSB SEA78DYM43Accident · No injuriesClosedCessna 150 · Vancouver, WANTSB NYC78FHJ19Accident · No injuriesClosedCessna 150 · Islip, NYNTSB CHI78FEV44Accident · No injuriesClosedCessna 150 · Peoria, ILNTSB NYC78FGT11Accident · No injuriesClosedVari-Eze 1 · Lewisberry, PANTSB OAK78DXQ32Accident · Minor injuriesClosedCessna 182 · Minden, NV