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 CHI77FEV10Accident · No injuriesClosedCessna 150 · Manito, ILFeb 3, 1977 · N65981 · Substantial damage NTSB OAK77DXQ05Accident · No injuriesClosedCessna 150 · Jackpot, NVFeb 2, 1977 · N714KM · Substantial damage NTSB DEN77FTM10Accident · No injuriesClosedCessna 150L · Price, UTJan 31, 1977 · N6813G · Substantial damage NTSB MKC77DCG12Accident · No injuriesClosedCessna 150 · Lyndon, KSJan 30, 1977 · N51206 · Substantial damage NTSB DEN77FQA24Accident · No injuriesClosedRose A&M A-4C · Aztec, NMJan 30, 1977 · N12084 · Substantial damage NTSB SEA77FTA10Accident · No injuriesClosedChampion 7GCAA · Hardin, MTJan 29, 1977 · N9558S · Substantial damage NTSB CHI77FEV09Accident · No injuriesClosedCessna 150 · Peoria, ILJan 29, 1977 · N9336U · Substantial damage NTSB CHI77FEG08Accident · No injuriesClosedCessna 150 · Harrison, OHJan 22, 1977 · N8878U · Substantial damage NTSB CHI77DEE09Accident · No injuriesClosedCessna 150L · Joliet, ILJan 22, 1977 · N19188 · Substantial damage NTSB NYC77FHA12Accident · Minor injuriesClosedCessna 150 · Honesdale, PAJan 21, 1977 · N22029 · Substantial damage NTSB NYC77DFA12Accident · No injuriesClosedBellanca 7ECA · Richfield Sprg, NYJan 21, 1977 · N11075 · Substantial damage NTSB SEA77FYE08Accident · Minor injuriesClosedCessna 150 · Langley, WAJan 20, 1977 · N66043 · Substantial damage NTSB MIA77FLA10Accident · No injuriesClosedCessna 150L · Pensacola, FLJan 19, 1977 · N10660 · Substantial damage NTSB OAK77DVA15Accident · No injuriesClosedCessna 150 · Oakhurst, CAJan 16, 1977 · N150SS · Substantial damage NTSB IAD77DID11Accident · No injuriesClosedCessna 150M · Moneta, VAJan 13, 1977 · N9202U · Substantial damage NTSB CHI77FEP16Accident · No injuriesClosedCessna 150 · Mosinee, WIJan 9, 1977 · N63346 · Substantial damage NTSB MIA77FLG06Accident · No injuriesClosedCessna 150M · Isle Of Palms, SCJan 8, 1977 · N8805U · Substantial damage NTSB MKC77FTK05Accident · No injuriesClosedCessna 150 · Holabird, SDJan 2, 1977 · N8433G · Substantial damage NTSB FTW77DPG15Accident · No injuriesClosedCessna 150 · Conway, ARJan 1, 1977 · N4271U · Substantial damage NTSB OAK77FVA13Accident · Minor injuriesClosedCessna 150L · Madera, CADec 31, 1976 · N5419Q · Destroyed NTSB MKC77DCJ07Accident · No injuriesClosedCessna 150 · Omaha, NEDec 29, 1976 · N16210 · Substantial damage NTSB LAX77DUJ16Accident · No injuriesClosedCessna 150 · Bagdad, AZDec 28, 1976 · N6682F · Destroyed NTSB NYC77FGT05Accident · No injuriesClosedCessna 150 · Philipsburg, PADec 25, 1976 · N3788J · Destroyed NTSB MKC77DCQ11Accident · Minor injuriesClosedCessna 150 · Emporia, KSDec 25, 1976 · N6306K · Substantial damage NTSB MIA77DLD20Accident · No injuriesClosedCessna 150 · Vero Beach, FLDec 24, 1976 · N18594 · Substantial damage NTSB MIA77DKG10Accident · No injuriesClosedCessna 150F · Elberton, GADec 24, 1976 · N7804F · Substantial damage NTSB FTW77DPG13Accident · No injuriesClosedCessna 150 · Mt.Home, ARDec 24, 1976 · N66094 · Substantial damage NTSB FTW77DPG14Accident · No injuriesClosedCessna 150 · El Dorado, ARDec 23, 1976 · N8430J · Substantial damage NTSB IAD77DLQ04Accident · Minor injuriesClosedCessna 150 · Trenton, KYDec 22, 1976 · N11269 · Destroyed NTSB FTW77DRG21Accident · Minor injuriesClosedCessna 150 · Mason, TXDec 22, 1976 · N4808X · Substantial damage NTSB MKC77DTG01Accident · No injuriesClosedCessna 150 · Keene, NDDec 18, 1976 · N8563J · Substantial damage NTSB CHI77FEE08Accident · No injuriesClosedCessna 150 · Wayne, ILDec 18, 1976 · N63406 · Substantial damage NTSB LAX77PUJ13Accident · No injuriesClosedCessna 150 · Parker, AZDec 15, 1976 · N1040M · Substantial damage NTSB MIA77DKT10Accident · No injuriesClosedCessna 150 · Ft Lauderdale, FLDec 11, 1976 · N19075 · Substantial damage NTSB DEN77FTE09Accident · No injuriesClosedCessna 150 · Boulder, CODec 11, 1976 · N11961 · Substantial damage NTSB SEA77DYP13Accident · Minor injuriesClosedCessna 150E · Spangle, WADec 8, 1976 · N6286T · Substantial damage NTSB LAX77FUJ11Accident · Minor injuriesClosedCessna 150 · Mesa, AZDec 8, 1976 · N5433Q · Substantial damage NTSB NYC77DFA08Accident · No injuriesClosedCessna 150 · Kingston, NYDec 5, 1976 · N6738G · Substantial damage NTSB CHI77DEE06Accident · No injuriesClosedCessna 150M · Belvidere, ILDec 4, 1976 · N9172U · Substantial damage NTSB CHI77FEI05Accident · No injuriesClosedCessna 150 · Vienna, OHDec 3, 1976 · N8632U · Substantial damage NTSB LAX77FUG11Accident · No injuriesClosedCessna 150D · Riverside, CANov 29, 1976 · N4539U · Substantial damage NTSB CHI77DEV05Accident · No injuriesClosedCessna 150 · Decatur, ILNov 24, 1976 · N8778U · Substantial damage NTSB NYC77DHA06Accident · No injuriesClosedChampion 7ECA · Dalton, PANov 19, 1976 · N2501F · Substantial damage NTSB SEA77FYC07Accident · No injuriesClosedCessna 150 · Sheridan, ORNov 18, 1976 · N3998U · Substantial damage NTSB SEA77DYC09Accident · Minor injuriesClosedCessna 150 · Cornelius, ORNov 7, 1976 · N60855 · Substantial damage NTSB MKC77FER05Accident · No injuriesClosedCessna 150J · Tyler, MNNov 7, 1976 · N60663 · Substantial damage NTSB FTW77DRA03Accident · No injuriesClosedCessna 150 · Texas City, TXNov 7, 1976 · N8018F · Substantial damage NTSB LAX77DUM07Accident · No injuriesClosedCessna 150 · Rancho Snta Fe, CANov 6, 1976 · N6768G · Substantial damage NTSB FTW77FA011Accident · 1 fatalClosedCessna 150 · Denton, TXNov 6, 1976 · N1336Q · 2 aircraft · Destroyed NTSB ANC76DAH09Accident · No injuriesClosedCessna 150 · Summit, AKNov 6, 1976 · N19366 · Substantial damage