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 FTW79DRD33Accident · Minor injuriesClosedCessna 150 · Houma, LAMay 27, 1979 · N22113 · Substantial damage NTSB IAD79FKW10Accident · Minor injuriesClosedTaylorcraft F-19 · Elk Valley, TNMay 24, 1979 · N3679T · Substantial damage NTSB MKC79DCG44Accident · No injuriesClosedCessna 150 · Ft Leavenworth, KSMay 23, 1979 · N5545G · Substantial damage NTSB SEA79FYP22Accident · No injuriesClosedCessna 150F · Mead, WAMay 22, 1979 · N3092X · Substantial damage NTSB IAD79FKM14Accident · No injuriesClosedCessna 150 · Charlotte, NCMay 20, 1979 · N5665E · Substantial damage NTSB FTW79DQG42Accident · No injuriesClosedCessna 150M · Midland, TXMay 20, 1979 · N704UN · Substantial damage NTSB IAD79FLQ12Accident · No injuriesClosedCessna 150 · Berea, KYMay 17, 1979 · N4684X · Substantial damage NTSB IAD79FID15Accident · No injuriesClosedCessna 150 · Chesapeake, VAMay 17, 1979 · N8805U · Substantial damage NTSB OAK79FVA32Accident · No injuriesClosedCessna 150J · Fresno, CAMay 15, 1979 · N5588G · Substantial damage NTSB OAK79DVG40Accident · No injuriesClosedCessna 150 · Sacramento, CAMay 12, 1979 · N63353 · Substantial damage NTSB OAK79DVG39Accident · No injuriesClosedCessna 150 · Hornbrook, CAMay 12, 1979 · N6693G · Substantial damage NTSB NYC79FHM19Accident · No injuriesClosedCessna 150 · Fairfield, NJMay 11, 1979 · N66781 · Substantial damage NTSB FTW79FRG29Accident · Minor injuriesClosedCessna 150M · Ft.Hood, TXMay 9, 1979 · N7651U · Substantial damage NTSB SEA79FTA14Accident · No injuriesClosedCessna 150 · Billings, MTMay 5, 1979 · N704JL · Substantial damage NTSB NYC79FHJ10Accident · No injuriesClosedCessna 150L · Islip, NYMay 1, 1979 · N6931G · Substantial damage NTSB MIA79DKJ37Accident · No injuriesClosedCessna 150 · Jacksonville, ALMay 1, 1979 · N6045K · Substantial damage NTSB NYC79FGM36Accident · No injuriesClosedCessna 150 · Northeast, PAApr 25, 1979 · N6474G · Substantial damage NTSB FTW79FRG28Accident · No injuriesClosedCessna 150M · Killeen, TXApr 25, 1979 · N704YV · Substantial damage NTSB DEN79FTE32Accident · Minor injuriesClosedCessna 150 · Boulder, COApr 23, 1979 · N6794F · Substantial damage NTSB OAK79DVM17Accident · No injuriesClosedCessna 150L · Palo Alto, CAApr 22, 1979 · N19304 · Substantial damage NTSB MKC79DCJ15Accident · Minor injuriesClosedCessna 150 · Weeping Water, NEApr 22, 1979 · N8085S · Substantial damage NTSB MKC79DCD17Accident · No injuriesClosedCessna 150 · Omaha, NEApr 22, 1979 · N17033 · Substantial damage NTSB LAX79FUJ64Accident · No injuriesClosedCessna 150 · Willcox, AZApr 22, 1979 · N8204F · Substantial damage NTSB MIA79FKG33Accident · 1 fatalClosedCessna 150 · Hawkinsville, GAApr 21, 1979 · N66550 · No damage NTSB NYC79DFJ14Accident · No injuriesClosedCessna 150L · Orchard Park, NYApr 20, 1979 · N10891 · Substantial damage NTSB LAX79FUG29Accident · Minor injuriesClosedCessna 150M · Corona, CAApr 17, 1979 · N704FA · Substantial damage NTSB IAF79FLT04Accident · No injuriesClosedCessna 150 · Memphis, TNApr 17, 1979 · N6099G · Substantial damage NTSB LAX79FUM10Accident · Serious injuriesClosedCessna 150F · Julian, CAApr 14, 1979 · N8604G · Substantial damage NTSB LAX79DUG30Accident · 1 fatalClosedBarnett J-4 · Adelanto, CAApr 14, 1979 · N68093 · Destroyed NTSB FTW79DPG26Accident · No injuriesClosedCessna 150 · Marked Tree, ARApr 14, 1979 · N6433G · Substantial damage NTSB MIA79FKT53Accident · Minor injuriesClosedCessna 150 · Ft.Lauderdale, FLApr 11, 1979 · N3231X · Destroyed NTSB MIA79FLD56Accident · Minor injuriesClosedCessna 150 · Inverness, FLApr 7, 1979 · N60180 · Destroyed NTSB UNK79X0110Accident · Minor injuriesClosedCessna 150 · Carlsbad, CAApr 3, 1979 · N45705 · Substantial damage NTSB OAK79FVW11Accident · No injuriesClosedCessna 150M · Las Vegas, NVMar 26, 1979 · N4014V · Substantial damage NTSB FTW79DQG23Accident · No injuriesClosedCessna 150 · Sonora, TXMar 26, 1979 · N5573G · Substantial damage NTSB MKC79DCQ17Accident · No injuriesClosedCessna 150 · Benton, KSMar 24, 1979 · N45284 · Substantial damage NTSB CHI79DA034Accident · 1 fatalClosedCessna 150M · Spring Valley, OHMar 16, 1979 · N704ZG · Destroyed NTSB MIA79FKT46Accident · No injuriesClosedCessna 150 · Ft Lauderdale, FLMar 15, 1979 · N3936U · Substantial damage NTSB DEN79DTC10Accident · No injuriesClosedCessna 150 · Afton, WYMar 14, 1979 · N6411K · Substantial damage NTSB CHI79FEV14Accident · No injuriesClosedCessna 150 · Lincoln, ILMar 12, 1979 · N19358 · Substantial damage NTSB FTW79DPG22Accident · No injuriesClosedCessna 150 · Arkadelphia, ARMar 7, 1979 · N2594J · Substantial damage NTSB SEA79DYE16Accident · No injuriesClosedCessna 150 · Seattle, WAMar 3, 1979 · N8529G · Substantial damage NTSB MIA79DLA18Accident · No injuriesClosedCessna 150 · Tallahassee, FLMar 1, 1979 · N66027 · Substantial damage NTSB NYC79FNE09Accident · No injuriesClosedCessna 150 · Simsbury, CTFeb 28, 1979 · N6530F · Substantial damage NTSB MIA79FA055Accident · 1 fatalClosedCessna 150 · Albany, GAFeb 27, 1979 · N11306 · Destroyed NTSB ANC79DAG33Accident · Minor injuriesClosedCessna 150 · Anchorage, AKFeb 27, 1979 · N2467J · Substantial damage NTSB MKC79FCG31Accident · No injuriesClosedCessna 150 · Olathe, KSFeb 26, 1979 · N6063T · Substantial damage NTSB IAD79FKW06Accident · 2 fatalClosedCessna 150F · Bristol, TNFeb 20, 1979 · N8555G · Substantial damage NTSB FTW79FQG18Accident · No injuriesClosedCessna 150 · Lubbock, TXFeb 19, 1979 · N6795S · Substantial damage NTSB CHI79FEK07Accident · No injuriesClosedCessna 150L · Mt Vernon, OHFeb 18, 1979 · N5496Q · Substantial damage