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 MIA76DLA58Accident · No injuriesClosedCessna 150 · Pensacola, FLJul 25, 1976 · N8402J · Destroyed NTSB FTW76DRJ34Accident · No injuriesClosedCessna 150M · Oil City, LAJul 24, 1976 · N66127 · Substantial damage NTSB CHI76FEV54Accident · Minor injuriesClosedCessna 150L · Okawville, ILJul 24, 1976 · N10774 · Substantial damage NTSB NYC76FNC58Accident · No injuriesClosedCessna 150L · Westminster, VTJul 22, 1976 · N5237Q · Substantial damage NTSB MKC76DCA37Accident · No injuriesClosedCessna 150 · Cuba, MOJul 22, 1976 · N63199 · Substantial damage NTSB DEN76FQA56Accident · Minor injuriesClosedCessna 150 · Tucumcari, NMJul 22, 1976 · N18155 · Substantial damage NTSB MIA76DLD71Accident · No injuriesClosedCessna 150 · Arcadia, FLJul 21, 1976 · N8360U · Destroyed NTSB MIA76DKJ88Accident · No injuriesClosedCessna 150 · Hazel Green, ALJul 19, 1976 · N5297Q · Substantial damage NTSB NYC76FNE29Accident · No injuriesClosedCessna 150J · Southbridge, MAJul 18, 1976 · N60412 · Substantial damage NTSB IAD76DKW36Accident · No injuriesClosedCessna 150 · Lawrenceburg, TNJul 18, 1976 · N5747G · Substantial damage NTSB OAK76DVD45Accident · No injuriesClosedCessna 150 · Novato, CAJul 17, 1976 · N5330Q · Substantial damage NTSB CHI76FEK22Accident · No injuriesClosedCessna 150L · Celina, OHJul 17, 1976 · N1357Q · Substantial damage NTSB CHI76FC079|CHI76AC079Accident · 5 fatalClosedCessna 150M · Rockford, ILJul 17, 1976 · N66375 · 2 aircraft · Destroyed NTSB NYC76FHJ26Accident · No injuriesClosedCessna 150H · Montauk, NYJul 15, 1976 · N50357 · Substantial damage NTSB SEA76FTI32Accident · No injuriesClosedCessna 150D · Lincoln, MTJul 14, 1976 · N19422 · Substantial damage NTSB DEN76DTM40Accident · No injuriesClosedCessna 150H · Howell, UTJul 13, 1976 · N22590 · Substantial damage NTSB NYC76FNC56Accident · No injuriesClosedPiper J5A · Camden, MEJul 11, 1976 · N38633 · Substantial damage NTSB MKC76DER78Accident · No injuriesClosedCessna 150L · Carlton, MNJul 10, 1976 · N1601Q · Substantial damage NTSB MIA76FKQ37Accident · No injuriesClosedCessna A188B · Hollandale, MSJul 9, 1976 · N6694G · Substantial damage NTSB MIA76FLG37Accident · No injuriesClosedCessna 150 · Rock Hill, SCJul 8, 1976 · N18019 · Substantial damage NTSB LAX76DUG61Accident · No injuriesClosedCessna 150 · Chino, CAJul 7, 1976 · N61221 · Substantial damage NTSB SEA76FYG63Accident · No injuriesClosedCessna 150 · Mead, WAJul 5, 1976 · N5962E · Substantial damage NTSB MKC76DCQ64Accident · No injuriesClosedCessna 150G · Oxford, KSJul 5, 1976 · N3221J · Substantial damage NTSB IAD76AI081Accident · 3 fatalClosedCessna 150 · Elkhorn City, KYJul 4, 1976 · N9238U · Substantial damage NTSB FTW76FRA50Accident · Minor injuriesClosedCessna 150 · Huffman, TXJul 4, 1976 · N3801V · Substantial damage NTSB IAD76DLQ25Accident · No injuriesClosedCessna 150 · Hodgenville, KYJul 3, 1976 · N10660 · Substantial damage NTSB FTW76DRG73Accident · No injuriesClosedCessna 150 · Port Mansfield, TXJul 3, 1976 · N1690Q · Substantial damage NTSB DEN76FTC38Accident · Minor injuriesClosedCessna 150L · Rock Springs, WYJul 3, 1976 · N6710G · Substantial damage NTSB DEN76DKG80Accident · Minor injuriesClosedCessna 150 · Statesboro, GAJun 29, 1976 · N2462J · Substantial damage NTSB MKC76DCG81Accident · No injuriesClosedCessna 150 · Springfield, MOJun 26, 1976 · N10107 · Substantial damage NTSB FTW76FPD48Accident · No injuriesClosedCessna 150 · Pottsville, TXJun 26, 1976 · N18021 · Substantial damage NTSB SEA76FYC60Accident · No injuriesClosedCessna 150L · Oregon City, ORJun 25, 1976 · N10297 · Substantial damage NTSB IAD76FID30Accident · No injuriesClosedCessna 150 · Williamsburg, VAJun 25, 1976 · N7790F · Substantial damage NTSB OAK76DXQ51Accident · No injuriesClosedCessna 150 · Reno, NVJun 20, 1976 · N3078S · Substantial damage NTSB LAX76FUD13Accident · No injuriesClosedCessna 150 · Van Nuys, CAJun 20, 1976 · N5804E · Substantial damage NTSB MIA76DLG35Accident · No injuriesClosedCitabria 7ECA · Summerton, SCJun 19, 1976 · N11066 · Substantial damage NTSB MIA76DKJ75Accident · No injuriesClosedChampion 7ECA · Goodway, ALJun 17, 1976 · N2543F · Substantial damage NTSB IAD76FKW34Accident · Serious injuriesClosedCessna 150 · Murfreesboro, TNJun 17, 1976 · N50196 · Destroyed NTSB ANC76DAH21Accident · No injuriesClosedCessna 150 · Anchorage, AKJun 15, 1976 · N10917 · Substantial damage NTSB LAX76FUJ84Accident · Minor injuriesClosedCessna 150 · Tucson, AZJun 10, 1976 · N2790J · Destroyed NTSB FTW76DRG58Accident · No injuriesClosedCessna 150 · Cuero, TXJun 10, 1976 · N6722F · Destroyed NTSB OAK76DVM44Accident · No injuriesClosedCessna 150 · Palo Alto, CAJun 9, 1976 · N10615 · Substantial damage NTSB MKC76DCQ60Accident · No injuriesClosedCessna 150 · Colby, KSJun 9, 1976 · N16025 · Substantial damage NTSB CHI76FEA43Accident · No injuriesClosedCessna 150 · Charlestown, INJun 9, 1976 · N18171 · Substantial damage NTSB NYC76FNE24Accident · Minor injuriesClosedCessna 150G · Westboro, MAJun 7, 1976 · N8347G · Substantial damage NTSB CHI76DET42Accident · No injuriesClosedCessna 150 · Woodburn, INJun 6, 1976 · N6044G · Substantial damage NTSB NYC76DHA35Accident · No injuriesClosedCessna 150 · Tunkhannock, PAJun 5, 1976 · N3092V · Substantial damage NTSB NYC76DFJ23Accident · No injuriesClosedCessna 150 · Elmira, NYJun 3, 1976 · N18717 · 2 aircraft · Substantial damage NTSB FTW76DPM25Accident · Serious injuriesClosedCessna 150 · Chelsea, OKJun 3, 1976 · N3579L · No damage NTSB MKC76FCQ54Accident · No injuriesClosedCessna A150M · Wichita, KSMay 28, 1976 · N9842J · Substantial damage