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 MKC67D0466Accident · No injuriesClosedCessna 150 · Park Rapids, MNMar 27, 1967 · N3063J · Substantial damage NTSB DIA67D0060Accident · No injuriesClosedCessna 150F · Moncure, NCMar 26, 1967 · N3584L · Substantial damage NTSB SEA67D0328Accident · No injuriesClosedCessna 150 · Grass Valley, ORMar 25, 1967 · N3099J · Substantial damage NTSB NYC67D0614Accident · No injuriesClosedCessna 150 · Totowa, NJMar 25, 1967 · N8947S · Substantial damage NTSB MKC67D0548Accident · No injuriesClosedCessna 150 · Sprg.Lake Pk., MNMar 25, 1967 · N8892G · Substantial damage NTSB NYC67D0573Accident · No injuriesClosedCessna 150F · Franklin, PAMar 24, 1967 · N8040F · Substantial damage NTSB MKC67D0546Accident · No injuriesClosedCessna 150 · Helena, MOMar 23, 1967 · N6451F · Substantial damage NTSB NYC67D0625Accident · No injuriesClosedCessna 150 · Plymouth, MAMar 21, 1967 · N2454J · Substantial damage NTSB FTW67F0506Accident · Minor injuriesClosedCessna 150E · Jacksboro, TXMar 21, 1967 · N4058U · Destroyed NTSB DEN67F0258Accident · No injuriesClosedCessna 150F · Albuquerque, NMMar 21, 1967 · N8228F · Substantial damage NTSB NYC67F0568Accident · No injuriesClosedCessna 150 · Simsbury, CTMar 20, 1967 · N8317J · Substantial damage NTSB NYC67F0552Accident · No injuriesClosedCessna 150 · Teterboro, NJMar 19, 1967 · N7929F · Substantial damage NTSB FTW67D0499Accident · No injuriesClosedCessna 150 · Blytheville, ARMar 19, 1967 · N8025S · Substantial damage NTSB MIA67D0441Accident · No injuriesClosedCessna 150 · Okeelanta, FLMar 18, 1967 · N4674X · Substantial damage NTSB NYC67D0563Accident · No injuriesClosedCessna 150 · Wash-Crossing, PAMar 15, 1967 · N8635S · Substantial damage NTSB LAX67F0331Accident · No injuriesClosedCessna 150F · Simi, CAMar 14, 1967 · N7911F · 2 aircraft · Substantial damage NTSB MIA67D0444Accident · No injuriesClosedCessna 150D · Everglades, FLMar 13, 1967 · N6017T · Substantial damage NTSB MKC67F0475Accident · No injuriesClosedCessna 150 · Eudora, KSMar 12, 1967 · N6224T · Substantial damage NTSB MKC67D0496Accident · No injuriesClosedCessna 150 · Brookville, KSMar 12, 1967 · N2465J · Substantial damage NTSB MIA67D0436Accident · No injuriesClosedCessna 150B · Everglade Cty, FLMar 12, 1967 · N7300X · Substantial damage NTSB NYC67D0541Accident · No injuriesClosedCessna 150F · Farmingdale, NYMar 11, 1967 · N3012X · Substantial damage NTSB CHI67F0558Accident · No injuriesClosedCessna 150 · Ludington, MIMar 11, 1967 · N4395U · Substantial damage NTSB CHI67F0487Accident · No injuriesClosedCessna 150 · Cincinnati, OHMar 10, 1967 · N6752F · Substantial damage NTSB MKC67D0446Accident · No injuriesClosedCessna 150 · Wichita, KSMar 9, 1967 · N7777E · Substantial damage NTSB FTW67F0525Accident · No injuriesClosedCessna 150G · Arlington, TXMar 8, 1967 · N3169X · Substantial damage NTSB FTW67D0482Accident · No injuriesClosedCessna 150 · Granbury, TXMar 4, 1967 · N4623X · Substantial damage NTSB CHI67D0485Accident · No injuriesClosedCessna 150 · Streator, ILMar 3, 1967 · N2440J · Substantial damage NTSB CHI67F0509Accident · No injuriesClosedCessna 150 · Dowagiac, MIFeb 28, 1967 · N3620J · Substantial damage NTSB LAX67F0310Accident · No injuriesClosedCessna 150F · Hawthorne, CAFeb 26, 1967 · N6687F · Substantial damage NTSB LAX67F0308Accident · No injuriesClosedCessna 150 · Long Beach, CAFeb 26, 1967 · N7809E · Substantial damage NTSB MIA67F0394Accident · No injuriesClosedCessna 150D · Madison, MSFeb 23, 1967 · N6031T · Destroyed NTSB SEA67D0282Accident · Minor injuriesClosedCessna 150 · Chemult, ORFeb 22, 1967 · N8431G · Substantial damage NTSB NYC67D0500Accident · Minor injuriesClosedCessna 150 · Princeton, NJFeb 22, 1967 · N6215T · Substantial damage NTSB MIA67F0412Accident · Minor injuriesClosedCessna 150F · Wiggins, MSFeb 22, 1967 · N8500G · Substantial damage NTSB MIA67D0411Accident · No injuriesClosedCessna 150 · Opa Locka, FLFeb 22, 1967 · N3991U · Substantial damage NTSB CHI67F0493Accident · No injuriesClosedCessna 150 · Delaware, OHFeb 22, 1967 · N7159X · Substantial damage NTSB CHI67D0486Accident · No injuriesClosedCessna 150 · Midlothian, ILFeb 22, 1967 · N7967Z · Substantial damage NTSB LAX67F0302Accident · No injuriesClosedCessna 150 · Corona, CAFeb 21, 1967 · N8668S · Substantial damage NTSB FTW67D0471Accident · No injuriesClosedCessna 150 · Sweetwater, TXFeb 21, 1967 · N1152Y · Substantial damage NTSB LAX67A0080Accident · No injuriesClosedCessna 150E · Santa Susana, CAFeb 19, 1967 · N4096U · Minor damage NTSB LAX67D0327Accident · No injuriesClosedCessna 150 · Lompoc, CAFeb 18, 1967 · N6814F · Substantial damage NTSB CHI67F0468Accident · No injuriesClosedCessna 150 · Ypsilanti, MIFeb 18, 1967 · N8018S · Substantial damage NTSB CHI67F0546Accident · No injuriesClosedCessna 150F · Cahokia, ILFeb 16, 1967 · N8279S · Substantial damage NTSB MKC67F0454Accident · No injuriesClosedCessna 150 · Anoka, MNFeb 14, 1967 · N8614G · Substantial damage NTSB NYC67F0504Accident · No injuriesClosedCessna 150 · Whitehouse, NJFeb 12, 1967 · N6559F · Substantial damage NTSB DIA67D0043Accident · No injuriesClosedCessna 150 · College Park, MDFeb 11, 1967 · N8259S · Substantial damage NTSB MIA67D0410Accident · No injuriesClosedCessna 150G · W.Hollywood, FLFeb 10, 1967 · N4675X · Substantial damage NTSB MIA67D0392Accident · No injuriesClosedCessna 150G · Opa Locka, FLFeb 10, 1967 · N4636X · Substantial damage NTSB DIA67F0040Accident · No injuriesClosedChampion 402 · Friendly, MDFeb 10, 1967 · N9954Y · Destroyed NTSB MKC67D0440Accident · No injuriesClosedCessna 150 · St. Charles, MOFeb 6, 1967 · N8558G · Substantial damage