NTSB investigations: Continental 0-200 series, 1981
118 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\") = 1981
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") = 1981
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 CHI81FEM33Accident · 3 fatalClosedVarieze RAF · Holland, MINTSB MIA81DKT86Accident · No injuriesClosedCessna 150 · Key West, FLNTSB LAX81DUJ82Accident · No injuriesClosedCessna 150M · Pearce, AZNTSB CHI81FEC26Accident · No injuriesClosedCessna 150 · Monroe, MINTSB MKC81DCG52Accident · No injuriesClosedCessna 150 · Lees Summit, MONTSB SEA81FA048Accident · 2 fatalClosedCessna 150H · Blue River, ORNTSB LAX81FA109Accident · 1 fatalClosedCessna 150J · Yuma, AZNTSB SEA81DYK13Accident · No injuriesClosedCessna 150G · Medford, ORNTSB FTW81DRJ22Accident · No injuriesClosedVari-Eze 01 · Natchitoches, LANTSB LAX81FVD33Accident · No injuriesClosedCessna 140 · San Rafael, CANTSB NYC81FGT07Accident · Minor injuriesClosedCessna 150 · Columbia, PANTSB LAX81FVG50Accident · No injuriesClosedCessna 150 · Georgetown, CANTSB DEN81FTE52Accident · No injuriesClosedCessna 150G · Hudson, CONTSB LAX81FA099Accident · 3 fatalClosedPiper PA-28 · Sherman Oaks, CANTSB LAX81DUJ69Accident · No injuriesClosedCessna 150L · Bullhead City, AZNTSB CHI81DEE45Accident · No injuriesClosedCessna 150 · Morris, ILNTSB FTW81DA107Accident · Minor injuriesClosedCessna 150 · Angleton, TXNTSB ATL81DLJ08Accident · No injuriesClosedCessna 150 · Knightdale, NCNTSB NYC81FHD28Accident · Minor injuriesClosedCessna 150 · Hamilton Sq, NJNTSB ATL81FIJ10Accident · No injuriesClosedCessna 150 · Hurricane, WVNTSB FTW81FPJ27Accident · Minor injuriesClosedCessna 150 · Guthrie, OKNTSB ATL81DLG10Accident · No injuriesClosedCessna 150 · North, SCNTSB MKC81DCG38Accident · No injuriesClosedCessna 150L · Tiff City, MONTSB MIA81DKT49Accident · No injuriesClosedCessna 150 · Key Largo, FLNTSB NYC81DHA14Accident · No injuriesClosedCessna 150H · Tobyhanna, PANTSB DEN81FTE42Accident · No injuriesClosedCessna 150 · La Junta, CONTSB ATL81FLT09Accident · Minor injuriesClosedCessna 150 · Bolivar, TNNTSB CHI81DEP18Accident · No injuriesClosedCessna 150K · La Crosse, WINTSB ATL81FKG19Accident · No injuriesClosedCessna 150 · Williamson, GANTSB MIA81FLD41Accident · Serious injuriesClosedCessna 150 · Ft.Myers, FLNTSB FTW81DQD21Accident · No injuriesClosedCessna 150 · Van Horn, TXNTSB NYC81FHA10Accident · Minor injuriesClosedCessna 150G · Stroudsburg, PANTSB LAX81DUQ19Accident · No injuriesClosedCessna 150 · Inyokern, CANTSB FTW81DPG21Accident · No injuriesClosedCessna 150 · Marshall, ARNTSB FTW81FPD19Accident · Minor injuriesClosedChampion 402 · Roanoke, TXNTSB CHI81FEV13Accident · No injuriesClosedCessna 150M · Williamsville, ILNTSB LAX81FUJ51Accident · No injuriesClosedCessna 150 · Globe, AZNTSB CHI81DEP16Accident · No injuriesClosedCessna 150E · Palmyra, WINTSB FTW81FPJ20Accident · Minor injuriesClosedCessna 150 · Dover, OKNTSB LAX81DVA34Accident · No injuriesClosedCessna 150M · Planada, CANTSB NYC81FNE15Accident · Minor injuriesClosedCessna 150 · Belchertown, MANTSB NYC81FNE13Accident · No injuriesClosedCessna 150 · Mansfield, CTNTSB MIA81DKT35Accident · No injuriesClosedCessna 150 · Port Largo, FLNTSB ATL81FKJ16Accident · No injuriesClosedCessna 150 · Ozark, ALNTSB ANC81FAD04Accident · No injuriesClosedTaylorcraft F19 · Wht Sulphr Spg, AKNTSB ANC81FA030Accident · 1 fatalClosedTaylorcraft F-19 · Susitna Lake, AKNTSB CHI81FER27Accident · No injuriesClosedCessna 150F · St Paul, MNNTSB ATL81FKW12Accident · No injuriesClosedCessna 150F · Lebanon, TNNTSB ANC81FA024Accident · No injuriesClosedCessna 150 · Chugiak, AKNTSB ATL81FKQ05Accident · Minor injuriesClosedCessna 150 · Poplarville, MS