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 OAK67F0194Accident · No injuriesClosedCessna 150 · Minden, NVDec 11, 1966 · N6770F · Substantial damage NTSB MKC67D0354Accident · No injuriesClosedCessna 150F · Warren, MNDec 11, 1966 · N7199F · Substantial damage NTSB MIA67D0375Accident · Minor injuriesClosedCessna 150F · Opa Locka, FLDec 11, 1966 · N1115T · Substantial damage NTSB CHI67F0386Accident · No injuriesClosedCessna 150 · Plymouth, MIDec 11, 1966 · N3178X · Substantial damage NTSB MKC67F0498Accident · No injuriesClosedCessna 150G · Bogue, KSDec 10, 1966 · N3953J · Substantial damage NTSB MIA67D0345Accident · No injuriesClosedCessna 150 · Arcadia, FLDec 8, 1966 · N7315X · Substantial damage NTSB DEN67D0179Accident · No injuriesClosedCessna 150 · Montrose, CODec 5, 1966 · N8804S · Substantial damage NTSB MKC67D0342Accident · No injuriesClosedCessna 150 · Olathe, KSDec 3, 1966 · N8080F · Substantial damage NTSB MKC67D0341Accident · No injuriesClosedCessna 150 · Springfield, MODec 3, 1966 · N4154U · Substantial damage NTSB MIA67D0306Accident · No injuriesClosedCessna 150 · Agricola, MSDec 3, 1966 · N7860Z · Substantial damage NTSB FTW67D0320Accident · No injuriesClosedCessna 150G · Beaumont, TXNov 29, 1966 · N2463J · Substantial damage NTSB MKC67F0355Accident · No injuriesClosedCessna 150F · Hopkins, MNNov 26, 1966 · N3520L · Substantial damage NTSB CHI67F0378Accident · No injuriesClosedCessna 150 · Angola, INNov 26, 1966 · N6497T · Destroyed NTSB MIA67D0292Accident · No injuriesClosedCessna 150 · Hollywood, FLNov 25, 1966 · N8274S · Substantial damage NTSB SEA67D0201Accident · No injuriesClosedCessna 150 · Colton, WANov 22, 1966 · N8974S · Substantial damage NTSB NYC67D0399Accident · No injuriesClosedCessna 150 · Lincoln Park, NJNov 22, 1966 · N8990S · Substantial damage NTSB LAX67F0128Accident · No injuriesClosedCessna 150 · Pacoima, CANov 21, 1966 · N7166F · Substantial damage NTSB MKC67D0334Accident · No injuriesClosedCessna 150F · Jefferson, IANov 19, 1966 · N7996F · Substantial damage NTSB DEN67F0153Accident · No injuriesClosedCessna 150 · Albuquerque, NMNov 19, 1966 · N7931F · Substantial damage NTSB OAK67D0170Accident · No injuriesClosedCessna 150E · Palo Alto, CANov 18, 1966 · N6138T · Substantial damage NTSB MIA67D0332Accident · No injuriesClosedCessna 150G · Melbourne, FLNov 18, 1966 · N3859J · Substantial damage NTSB DEN67D0155Accident · No injuriesClosedCessna 150 · Aurora, CONov 14, 1966 · N8056F · Substantial damage NTSB SEA67D0175Accident · No injuriesClosedCessna 150 · Spokane, WANov 13, 1966 · N8647G · Substantial damage NTSB NYC67D0376Accident · No injuriesClosedCessna 150 · Burlington, CTNov 13, 1966 · N3992U · Substantial damage NTSB NYC67D0362Accident · No injuriesClosedCessna 150 · Lower Marlboro, MDNov 13, 1966 · N2553J · Substantial damage NTSB OAK67F0213Accident · No injuriesClosedCessna 150E · Concord, CANov 12, 1966 · N3050J · 2 aircraft · Substantial damage NTSB MIA67F0277Accident · No injuriesClosedCessna 150 · Somerville, TNNov 12, 1966 · N8135F · Substantial damage NTSB CHI67F0294Accident · No injuriesClosedCessna 150 · Lewis, INNov 12, 1966 · N3769J · Substantial damage NTSB MIA67F0272Accident · No injuriesClosedCessna 150 · Icksburg, MSNov 10, 1966 · N7044F · Substantial damage NTSB NYC67F0377Accident · No injuriesClosedCessna 150 · Hiladelphia, PANov 8, 1966 · N8517G · Substantial damage NTSB FTW67F0328Accident · No injuriesClosedCessna 150E · Mannsville, OKNov 8, 1966 · N6251T · Substantial damage NTSB MIA67D0309Accident · No injuriesClosedCessna 150 · Homestead, FLNov 7, 1966 · N5957T · Substantial damage NTSB OAK67F0165Accident · No injuriesClosedCessna 150 · Merced, CANov 6, 1966 · N4543U · 2 aircraft · Substantial damage NTSB SEA67D0177Accident · No injuriesClosedCessna 150 · Twin Falls, IDNov 5, 1966 · N8800S · Substantial damage NTSB MKC67F0358Accident · Minor injuriesClosedCessna 150A · Tioga, NDNov 5, 1966 · N7114X · Substantial damage NTSB FTW67D0327Accident · No injuriesClosedCessna 150 · Addison, TXNov 5, 1966 · N1201Y · Substantial damage NTSB DEN67A0031Accident · 2 fatalClosedCessna 150F · Erie, CONov 5, 1966 · N7981F · Destroyed NTSB SEA67D0178Accident · Minor injuriesClosedCessna 150 · Wayan, IDNov 2, 1966 · N4800X · Substantial damage NTSB MIA67F0334Accident · No injuriesClosedCessna 150F · Gainesville, FLNov 2, 1966 · N8758G · Substantial damage NTSB LAX67F0193Accident · No injuriesClosedCessna 150F · Long Beach, CANov 1, 1966 · N7086F · Substantial damage NTSB MIA67D0283Accident · No injuriesClosedCessna 150 · Eufaula, ALOct 30, 1966 · N8312G · Substantial damage NTSB MIA67D0271Accident · No injuriesClosedCessna 150 · Avon Park, FLOct 29, 1966 · N6016T · Substantial damage NTSB OAK67D0149Accident · No injuriesClosedCessna 150 · Minden, NVOct 26, 1966 · N6793F · Substantial damage NTSB FTW67F0265Accident · No injuriesClosedCessna 150 · Houston, TXOct 26, 1966 · N6211R · Substantial damage NTSB MIA67F0276Accident · No injuriesClosedCessna 150 · Mobile, ALOct 22, 1966 · N7752F · Substantial damage NTSB CHI67D0342Accident · Minor injuriesClosedCessna 150D · London, KYOct 21, 1966 · N4145U · Substantial damage NTSB CHI67F0256Accident · No injuriesClosedCessna 150 · Ypsilanti, MIOct 20, 1966 · N1929Z · Substantial damage NTSB FTW67F0276Accident · No injuriesClosedCessna 150 · Portland, TXOct 16, 1966 · N8724G · Substantial damage NTSB NYC67D0312Accident · No injuriesClosedCessna 150 · Franklin, NJOct 15, 1966 · N8122F · Substantial damage NTSB NYC67D0288Accident · No injuriesClosedCessna 150 · Croton-Hudson, NYOct 15, 1966 · N2562J · Substantial damage