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 LAX79FUD01Accident · Minor injuriesClosedCessna 150 · Santa Monica, CAAug 31, 1979 · N3628V · Substantial damage NTSB LAX79FA072Accident · Minor injuriesClosedCessna 150 · Palos Verdes, CAAug 30, 1979 · N66134 · Substantial damage NTSB FTW79FPA27Accident · No injuriesClosedCessna 150F · Rowlett, TXAug 26, 1979 · N8881S · Substantial damage NTSB LAX79DUK18Accident · Minor injuriesClosedCessna 150 · Page, AZAug 24, 1979 · N6142G · Substantial damage NTSB MKC79FCG74Accident · No injuriesClosedCessna 150E · Pleasant Hill, MOAug 21, 1979 · N4070U · Substantial damage NTSB IAD79DA071Accident · No injuriesClosedCessna 150 · Oakland, MDAug 20, 1979 · N5344Q · Destroyed NTSB MKC79DCG72Accident · No injuriesClosedCessna 150 · Odessa, MOAug 19, 1979 · N16025 · Substantial damage NTSB IAD79FIG13Accident · No injuriesClosedCessna 150 · Westminster, MDAug 15, 1979 · N7930U · Destroyed NTSB MKC79FA048Accident · 1 fatalClosedCessna 150J · Pleasant Hill, MOAug 14, 1979 · N60677 · Destroyed NTSB LAX79DUK06Accident · No injuriesClosedCessna 150 · Sunflower, AZAug 13, 1979 · N3196X · Substantial damage NTSB MIA79FKG59Accident · Minor injuriesClosedChampion 7ECA · Social Circle, GAAug 10, 1979 · N2550F · Destroyed NTSB MKC79FCG70Accident · No injuriesClosedCessna 150L · Bonner Springs, KSAug 9, 1979 · N19030 · Substantial damage NTSB FTW79DRD48Accident · No injuriesClosedCessna 150 · New Roads, LAAug 9, 1979 · N63342 · Substantial damage NTSB NYC79FHJ28Accident · No injuriesClosedFlybaby 1B · Shirley, NYAug 8, 1979 · N78FP · Substantial damage NTSB MKC79FCG66Accident · No injuriesClosedCessna 150 · Ozark, MOAug 1, 1979 · N4065V · Substantial damage NTSB NYC79FNA26Accident · No injuriesClosedCessna 150 · North Andover, MAJul 30, 1979 · N10796 · Substantial damage NTSB NYC79FA070Accident · No injuriesClosedCessna 172L · Simsbury, CTJul 30, 1979 · N4324Q · 2 aircraft · Substantial damage NTSB MIA79DKT81Accident · No injuriesClosedCessna 150H · Miami, FLJul 30, 1979 · N714KY · Substantial damage NTSB MKC79FCQ38Accident · No injuriesClosedCessna 150H · Columbus, KSJul 28, 1979 · N5131G · Substantial damage NTSB LAX79DUK08Accident · No injuriesClosedCessna 150 · Marana, AZJul 28, 1979 · N11841 · Substantial damage NTSB MIA79DLA41Accident · No injuriesClosedCessna 150 · Camilla, GAJul 27, 1979 · N50635 · Substantial damage NTSB LAX79DUJ96Accident · Minor injuriesClosedCessna 150 · Yuma, AZJul 24, 1979 · N1456Q · Substantial damage NTSB NYC79FGM35Accident · No injuriesClosedCessna 150 · Zelienople, PAJul 17, 1979 · N19138 · Substantial damage NTSB MKC79DER54Accident · No injuriesClosedCessna 150 · St Cloud, MNJul 17, 1979 · N714MP · Substantial damage NTSB IAD79FLQ20Accident · No injuriesClosedCessna 172 · Louisville, KYJul 17, 1979 · N18171 · Substantial damage NTSB CHI79FEE67Accident · No injuriesClosedFriling Variez · Plainfield, ILJul 17, 1979 · N28JF · Substantial damage NTSB ANC79DAA23Accident · No injuriesClosedCessna 150H · Fairbanks, AKJul 16, 1979 · N50296 · Substantial damage NTSB MIA79DLA38Accident · No injuriesClosedCessna 150 · Waycross, GAJul 14, 1979 · N18646 · Substantial damage NTSB IAD79FGN34Accident · Minor injuriesClosedCessna 150 · Moundsville, WVJul 14, 1979 · N1614Q · Substantial damage NTSB FTW79FPD28Accident · No injuriesClosedCessna 150L · Weatherford, TXJul 14, 1979 · N7930G · Substantial damage NTSB DEN79DTE60Accident · No injuriesClosedCessna 150 · La Jara, COJul 13, 1979 · N6018G · Substantial damage NTSB NYC79FNA21Accident · No injuriesClosedCessna 150M · Middleboro, MAJul 10, 1979 · N66349 · Substantial damage NTSB DEN79FTE55Accident · Minor injuriesClosedCessna 150 · Sedalia, COJul 7, 1979 · N45324 · Substantial damage NTSB CHI79FEP52Accident · Minor injuriesClosedDavis DA-3 · Burlington, WIJul 3, 1979 · N19MD · Substantial damage NTSB NYC79FHA16Accident · No injuriesClosedCessna 150G · Slatington, PAJul 1, 1979 · N8397J · Substantial damage NTSB NYC79FGM30Accident · No injuriesClosedCessna 150 · Kittanning, PAJun 27, 1979 · N18077 · Substantial damage NTSB MKC79FTG08Accident · No injuriesClosedCessna 150M · Mercer, NDJun 27, 1979 · N45232 · Substantial damage NTSB ANC79FAA16Accident · No injuriesClosedCessna 150 · Fairbanks, AKJun 16, 1979 · N23225 · Substantial damage NTSB CHI79DEC33Accident · Serious injuriesClosedCessna 150M · Utica, MIJun 15, 1979 · N66427 · Substantial damage NTSB OAK79DVG52Accident · No injuriesClosedCessna 150 · Chico, CAJun 12, 1979 · N6752S · Substantial damage NTSB MIA79DLA30Accident · Minor injuriesClosedCessna 150 · Mayday, GAJun 10, 1979 · N6577F · Substantial damage NTSB FTW79FPM10Accident · No injuriesClosedCessna 150 · Vinita, OKJun 10, 1979 · N50254 · Substantial damage NTSB SEA79DYP27Accident · No injuriesClosedCessna 150 · Garfield, WAJun 7, 1979 · N3312J · Substantial damage NTSB OAK79DVA40Accident · No injuriesClosedCessna 150 · Reedley, CAJun 7, 1979 · N10531 · Substantial damage NTSB NYC79FA048Accident · 1 fatalClosedCessna 150H · Dalton, NHJun 3, 1979 · N7052S · Destroyed NTSB CHI79FEC29Accident · Minor injuriesClosedCessna 150 · Napoleon, MIJun 3, 1979 · N9101U · Substantial damage NTSB DEN79FTE42Accident · No injuriesClosedCessna 150L · Broomfield, COJun 1, 1979 · N19077 · Substantial damage NTSB ANC79DAG58Accident · No injuriesClosedTaylorcraft F-19 · Anchorage, AKJun 1, 1979 · N3571T · Substantial damage NTSB NYC79FGM28Accident · No injuriesClosedCessna 150 · Waterford, PAMay 31, 1979 · N21974 · Substantial damage NTSB LAX79DUG40Accident · No injuriesClosedCessna 150M · 29 Palms, CAMay 28, 1979 · N704WY · Substantial damage