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 OAK67D0031Accident · No injuriesClosedCessna 150 · Concord, CAJul 8, 1966 · N6849F · Substantial damage NTSB MKC67D0064Accident · No injuriesClosedCessna 150 · Ft.Len.Wood, MOJul 5, 1966 · N8769G · Substantial damage NTSB MIA67F0011Accident · No injuriesClosedCessna 150 · Clinton, NCJul 5, 1966 · N7030F · Substantial damage NTSB FTW67D0084Accident · No injuriesClosedCessna 150 · Blue Mound, TXJul 5, 1966 · N7896E · Substantial damage NTSB FTW67D0055Accident · No injuriesClosedCessna 150 · Waurtka, OKJul 5, 1966 · N8399G · Substantial damage NTSB SEA67F0084Accident · No injuriesClosedCessna 150 · Cottage Grove, ORJul 4, 1966 · N6604T · Substantial damage NTSB MKC67D0030Accident · No injuriesClosedCessna 150 · Lawrence, KSJul 4, 1966 · N1140Y · Substantial damage NTSB MIA67A0001Accident · 2 fatalClosedCessna 150E · Dania, FLJul 4, 1966 · N2585J · Destroyed NTSB NYC67F0120Accident · No injuriesClosedCessna 150 · Atlantic City, NJJul 3, 1966 · N2583J · 2 aircraft · Substantial damage NTSB NYC67F0048Accident · Minor injuriesClosedCessna 150D · Plainvile, CTJul 3, 1966 · N4209U · Substantial damage NTSB NYC67F0055Accident · No injuriesClosedCessna 150 · Richmond, VAJul 2, 1966 · N8672G · Substantial damage NTSB OAK67D0131Accident · No injuriesClosedCessna 150 · San Carlos, CAJun 28, 1966 · N7918F · Substantial damage NTSB MIA67D0049Accident · No injuriesClosedCessna 150 · Fayetteville, GAJun 27, 1966 · N7181X · Substantial damage NTSB LAX67D0052Accident · No injuriesClosedCessna 150 · Acton, CAJun 27, 1966 · N5739E · Substantial damage NTSB SEA67F0052Accident · No injuriesClosedCessna 150 · Leavenworth, WAJun 26, 1966 · N8801S · Substantial damage NTSB FTW67D0044Accident · No injuriesClosedCessna 150 · Cordell, OKJun 26, 1966 · N7825E · Substantial damage NTSB FTW67F0025Accident · Serious injuriesClosedCessna 150 · Bogalusa, LAJun 25, 1966 · N8036S · Substantial damage NTSB NYC67D0021Accident · No injuriesClosedCessna 150 · Collegeville, PAJun 23, 1966 · N6167T · Substantial damage NTSB CHI67F0099Accident · No injuriesClosedCessna 150 · East St.Louis, ILJun 23, 1966 · N7973F · Substantial damage NTSB MIA66D0631Accident · No injuriesClosedCessna 150 · Humacao, PRJun 20, 1966 · N4108U · Substantial damage NTSB MIA66D0611Accident · No injuriesClosedCessna 150 · Palmdale, FLJun 19, 1966 · N6444F · Substantial damage NTSB SEA67D0014Accident · No injuriesClosedCessna 150 · Richland, WAJun 18, 1966 · N7794E · Substantial damage NTSB CHI67F0042Accident · No injuriesClosedCessna 150F · E St Louis, ILJun 14, 1966 · N7944F · Substantial damage NTSB MIA66F0572Accident · No injuriesClosedCessna 150 · Statesville, NCJun 13, 1966 · N3996U · Substantial damage NTSB MKC67F0070Accident · No injuriesClosedCessna 150 · Creve Coeur, MOJun 12, 1966 · N6959F · Substantial damage NTSB SEA67D0048Accident · No injuriesClosedCessna 150 · Renton, WAJun 11, 1966 · N7807F · Substantial damage NTSB CHI67F0018Accident · No injuriesClosedChampion 7EC · Columbus, OHJun 8, 1966 · N9584S · Substantial damage NTSB FTW66D0701Accident · No injuriesClosedCessna 150C · Ben Wheeler, TXJun 7, 1966 · N2067Z · Substantial damage NTSB OAK67D0072Accident · No injuriesClosedCessna 150 · Las Vegas, NVJun 5, 1966 · N5638E · Substantial damage NTSB NYC67D0006Accident · No injuriesClosedCessna 150 · Huntingdon, PAJun 5, 1966 · N6806F · Substantial damage NTSB MIA66D0614Accident · No injuriesClosedCessna 150 · Thomaston, GAJun 5, 1966 · N6033T · Substantial damage NTSB NYC67D0012Accident · Minor injuriesClosedCessna 150 · New City, NYJun 4, 1966 · N6592F · Substantial damage NTSB LAX66F0371Accident · No injuriesClosedCessna 150 · Lompoc, CAJun 2, 1966 · N7161X · Substantial damage NTSB LAX66F0354Accident · No injuriesClosedCessna 150F · Chino, CAJun 1, 1966 · N8914S · Substantial damage NTSB LAX66F0377Accident · No injuriesClosedCessna 150 · Santa Ana, CAMay 30, 1966 · N4027U · Substantial damage NTSB DEN67D0020Accident · No injuriesClosedCessna 150 · Denver, COMay 28, 1966 · N7997Z · Substantial damage NTSB SEA67F0056Accident · No injuriesClosedCessna 150 · Portland, ORMay 26, 1966 · N3576L · Substantial damage NTSB NYC66F0669Accident · No injuriesClosedCessna 150 · West Mifflin, PAMay 26, 1966 · N7944Z · Substantial damage NTSB MKC67D0023Accident · No injuriesClosedAeronca 7ECA · Hutchinson, MNMay 26, 1966 · N2527F · Substantial damage NTSB MIA66A0137Accident · 2 fatalClosedCessna 150 · Lake City, FLMay 25, 1966 · N8701G · Destroyed NTSB NYC66F0712Accident · No injuriesClosedCessna 150 · Friendly, MDMay 24, 1966 · N8759S · Substantial damage NTSB CHI66F0757Accident · No injuriesClosedCessna 150 · Lansing, MIMay 22, 1966 · N2506J · Substantial damage NTSB FTW66F0677Accident · Minor injuriesClosedCessna 150F · Greenville, TXMay 21, 1966 · N8323G · Substantial damage NTSB MIA66F0594Accident · No injuriesClosedCessna 150F · Crescent Beach, SCMay 20, 1966 · N8479G · Substantial damage NTSB LAX67D0002Accident · No injuriesClosedCessna 150 · San Fernando, CAMay 20, 1966 · N6284T · Substantial damage NTSB CHI66F0735Accident · No injuriesClosedCessna 150 · Milwauke, WIMay 19, 1966 · N6765F · Substantial damage NTSB OAK66F0291Accident · Minor injuriesClosedChampion 7ECA · Mendota, CAMay 18, 1966 · N2586F · Substantial damage NTSB MKC66D0594Accident · No injuriesClosedCessna 150 · Emporia, KSMay 18, 1966 · N6063T · Substantial damage NTSB LAX66A0089Accident · No injuriesClosedPiper PA-28 · Santa Ynez, CAMay 18, 1966 · N5914W · 2 aircraft · Minor damage NTSB SEA67F0043Accident · No injuriesClosedCessna 150 · Chehalis, WAMay 17, 1966 · N5972E · Substantial damage