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 IAD74FKW05Accident · Minor injuriesClosedCessna 150G · Chattanooga, TNJul 14, 1973 · N4733X · Substantial damage NTSB FTW74DRA05Accident · No injuriesClosedCessna 150L · Dickinson, TXJul 14, 1973 · N17027 · Substantial damage NTSB MIA74FKG04Accident · No injuriesClosedCessna 150 · Dalton, GAJul 12, 1973 · N3796J · Substantial damage NTSB CHI74AEC03Accident · No injuriesClosedCessna 150K · Owosso, MIJul 11, 1973 · N6451G · Substantial damage NTSB MIA74DKG03Accident · No injuriesClosedCessna 150 · Swainsboro, GAJul 7, 1973 · N22558 · Substantial damage NTSB IAD74DLQ05Accident · Minor injuriesClosedCessna 150 · Campbellsville, KYJul 7, 1973 · N4746X · Substantial damage NTSB OAK74FVA01Accident · Minor injuriesClosedCessna 150 · Hanford, CAJul 4, 1973 · N8102F · Substantial damage NTSB IAD73DKW01Accident · No injuriesClosedCessna 150D · Dixon Spring, TNJul 1, 1973 · N4486U · Substantial damage NTSB SEA74DYE16Accident · No injuriesClosedCessna 150 · Aldrwood Mnr, WAJun 30, 1973 · N8606J · Minor damage NTSB MIA73DKJ72Accident · No injuriesClosedCessna 150H · Weaver, ALJun 29, 1973 · N22016 · Substantial damage NTSB NYC73FNE37Accident · No injuriesClosedCessna 150 · Hartford, CTJun 28, 1973 · N6613G · Substantial damage NTSB CHI73DEA40Accident · No injuriesClosedCessna 150F · Mc Cordsville, INJun 24, 1973 · N6427F · Substantial damage NTSB OAK73DVM39Incident · No injuriesClosedCessna 150 · Moss Beach, CAJun 19, 1973 · N17147 · 2 aircraft · Minor damage NTSB IAD73FLT19Accident · No injuriesClosedCessna 150 · Covington, TNJun 18, 1973 · N3918J · Substantial damage NTSB NYC73DFJ27Accident · Minor injuriesClosedCessna 150 · Canandaigua, NYJun 13, 1973 · N4050U · Substantial damage NTSB FTW73DRA36Accident · Minor injuriesClosedCessna 150H · Cleveland, TXJun 11, 1973 · N50362 · Substantial damage NTSB NYC73FHJ20Accident · No injuriesClosedCessna 150 · Aquebogue, NYJun 10, 1973 · N6070G · Substantial damage NTSB IAD73FLQ34Accident · Minor injuriesClosedCessna 150H · Park City, KYJun 9, 1973 · N23168 · Destroyed NTSB CHI73FEK23Accident · No injuriesClosedCessna 150J · Somerset, OHJun 9, 1973 · N50500 · Substantial damage NTSB CHI73DEE65Accident · No injuriesClosedCessna 150 · Joliet, ILJun 9, 1973 · N6798G · Substantial damage NTSB NYC74DFJ05Accident · No injuriesClosedCessna 150 · Dunkirk, NYJun 4, 1973 · N18004 · Substantial damage NTSB IAD73FID24Accident · No injuriesClosedCessna 150 · Blacksburg, VAJun 3, 1973 · N4036U · Substantial damage NTSB OAK73DVM34Accident · No injuriesClosedCessna 150F · Morgan Hill, CAJun 2, 1973 · N8345G · Substantial damage NTSB NYC73DGM33Accident · No injuriesClosedCessna 150G · Erie, PAJun 2, 1973 · N3203J · Substantial damage NTSB MKC73DCJ43Accident · No injuriesClosedCessna 150 · Plattsmouth, NEMay 29, 1973 · N6503S · Substantial damage NTSB FTW73FPJ21Accident · No injuriesClosedCessna 150L · Yukon, OKMay 29, 1973 · N19200 · Substantial damage NTSB SEA73DYC31Accident · No injuriesClosedCessna 150 · Salem, ORMay 28, 1973 · N21986 · Substantial damage NTSB OAK73FVA58Accident · No injuriesClosedCessna 150 · Visalia, CAMay 27, 1973 · N8640S · Substantial damage NTSB CHI73DEE63Accident · Minor injuriesClosedCessna 150L · Frankfort, ILMay 25, 1973 · N18534 · Substantial damage NTSB DEN73DQA42Accident · No injuriesClosedCessna 150F · Albuquerque, NMMay 24, 1973 · N8182F · Substantial damage NTSB FTW73FRJ36Accident · No injuriesClosedCessna 150 · Jefferson, TXMay 22, 1973 · N23081 · Substantial damage NTSB FTW73DRG85Accident · No injuriesClosedRepublic P47D · Harlingen, TXMay 22, 1973 · N47DE · 2 aircraft · Minor damage NTSB FTW73DRD31Accident · No injuriesClosedCessna 150G · Lockport, LAMay 22, 1973 · N4092J · Substantial damage NTSB MIA73DKJ60Accident · Minor injuriesClosedCessna 150H · Hazel Green, ALMay 21, 1973 · N22159 · Substantial damage NTSB CHI73FCA05Accident · Minor injuriesClosedCessna 150 · Cahokia, ILMay 18, 1973 · N6272S · Substantial damage NTSB MKC73FCA26Accident · No injuriesClosedCessna 150J · Rolla, MOMay 16, 1973 · N51120 · Substantial damage NTSB MIA73DKJ59Accident · Serious injuriesClosedCessna 150 · Talledega, ALMay 15, 1973 · N6604G · Destroyed NTSB FTW73FRD24Accident · Minor injuriesClosedCessna 150L · Baton Rouge, LAMay 14, 1973 · N18043 · Substantial damage NTSB NYC73FNE33Accident · No injuriesClosedCessna 150L · Northamton, MAMay 13, 1973 · N18678 · Substantial damage NTSB LAX73FUG52Accident · No injuriesClosedCessna 150H · Joshua Tree, CAMay 12, 1973 · N3901C · Substantial damage NTSB MIA73FKQ28Accident · No injuriesClosedCessna 150 · Wiggins, MSMay 10, 1973 · N7821F · Substantial damage NTSB MIA73DKT92Accident · No injuriesClosedCessna 150 · Ft Lauderdale, FLMay 6, 1973 · N50872 · Substantial damage NTSB CHI73DEP42Accident · No injuriesClosedCessna 150 · Sheboygan, WIMay 3, 1973 · N18690 · Substantial damage NTSB LAX73AL052Accident · No injuriesClosedCessna 150 · Pacoima, CAMay 1, 1973 · N50814 · 2 aircraft · Substantial damage NTSB MIA73DKG73Accident · No injuriesClosedCessna 150L · Stockbridge, GAApr 30, 1973 · N18209 · Substantial damage NTSB OAK73FXQ28Accident · Minor injuriesClosedCessna 150 · Portola, CAApr 26, 1973 · N19346 · Substantial damage NTSB IAD73DLJ29Accident · No injuriesClosedCessna 150K · New Bern, NCApr 22, 1973 · N6387G · Substantial damage NTSB CHI73DEV25Accident · No injuriesClosedCessna 150 · Peoria, ILApr 22, 1973 · N60778 · Substantial damage NTSB NYC73DHD36Accident · No injuriesClosedCessna 150 · Williamstown, NJApr 21, 1973 · N19344 · Substantial damage NTSB LAX73DUJ80Accident · No injuriesClosedCessna 150J · Quartzsite, AZApr 19, 1973 · N60368 · Substantial damage