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 OAK76DVG51Accident · No injuriesClosedCessna 150 · Redding, CAMar 9, 1976 · N10663 · Substantial damage NTSB OAK76FVM25Accident · No injuriesClosedCessna 150 · San Jose, CAMar 7, 1976 · N8373M · Substantial damage NTSB CHI76DEC30Accident · No injuriesClosedCessna 150B · Caro, MIMar 7, 1976 · N1258Y · Substantial damage NTSB LAX76DUG42Accident · No injuriesClosedErco 415-C · Palm Springs, CAMar 4, 1976 · N94135 · Substantial damage NTSB LAX76DUM20Accident · No injuriesClosedCessna 150 · Agua Caliente, CAFeb 28, 1976 · N19346 · Substantial damage NTSB DEN76DTC25Accident · No injuriesClosedCessna 150L · Jackson, WYFeb 24, 1976 · N11261 · Substantial damage NTSB MIA76DKG43Accident · No injuriesClosedCessna 150M · Chamblee, GAFeb 21, 1976 · N3104V · Substantial damage NTSB CHI76FEC28Accident · No injuriesClosedCessna 150G · Petersburg, MIFeb 20, 1976 · N3412J · Substantial damage NTSB IAD76FIA10Accident · Minor injuriesClosedCessna 150M · College Park, MDFeb 15, 1976 · N2978V · Substantial damage NTSB DEN76FTE42Accident · No injuriesClosedDavenport BD-2 · Broomfield, COFeb 14, 1976 · N5131 · 2 aircraft · Substantial damage NTSB NYC76DFJ16Accident · No injuriesClosedCessna 150 · West Monroe, NYFeb 12, 1976 · N2985S · Substantial damage NTSB CHI76FEC26Accident · No injuriesClosedCessna 150L · Westland, MIFeb 12, 1976 · N1528Q · Substantial damage NTSB FTW76DQD12Accident · Minor injuriesClosedCessna 150 · Coyanosa, TXFeb 10, 1976 · N2816S · Substantial damage NTSB FTW76AF064Accident · No injuriesClosedCessna 150H · La Porte, TXFeb 8, 1976 · N22163 · 2 aircraft · Minor damage NTSB MKC76DCD26Accident · No injuriesClosedCessna 150L · New Sharon, IAFeb 7, 1976 · N16132 · Substantial damage NTSB CHI76FET26Accident · No injuriesClosedCessna 150L · Goshen, INFeb 7, 1976 · N19209 · Substantial damage NTSB CHI76FEK10Accident · No injuriesClosedCessna 150 · Lima, OHFeb 7, 1976 · N19079 · Substantial damage NTSB NYC76FHJ14Accident · No injuriesClosedCessna 150 · Edwards, NYFeb 4, 1976 · N19593 · Substantial damage NTSB MIA76FKG41Accident · No injuriesClosedCessna 150J · Tifton, GAFeb 4, 1976 · N50886 · Substantial damage NTSB ANC76DAG86Accident · No injuriesClosedCessna 150 · Anchorage, AKFeb 1, 1976 · N3936U · Substantial damage NTSB IAD76FIG08Accident · Minor injuriesClosedCessna 150 · Baltimore, MDJan 28, 1976 · N60489 · Substantial damage NTSB OAK76FVG44Accident · No injuriesClosedCessna 150 · Sacramento, CAJan 25, 1976 · N3567V · Substantial damage NTSB MIA76FLG25Accident · Minor injuriesClosedCessna A150L · Bath, SCJan 24, 1976 · N6032J · Substantial damage NTSB IAD76DKM28Accident · No injuriesClosedCessna 150 · Denton, NCJan 23, 1976 · N6088G · Substantial damage NTSB NYC76FFA26Accident · No injuriesClosedCessna 150G · Cadyville, NYJan 21, 1976 · N3274J · Substantial damage NTSB CHI76DEE39Accident · No injuriesClosedCessna 150 · Lockport, ILJan 18, 1976 · N6818G · Substantial damage NTSB FTW76FPD26Accident · No injuriesClosedCessna 150 · Eastland, TXJan 16, 1976 · N1912Z · Substantial damage NTSB MKC76DCG44Accident · No injuriesClosedCessna 150 · Springfield, MOJan 14, 1976 · N7731G · Substantial damage NTSB MKC76FCG42Accident · No injuriesClosedCessna 150L · Point Lookout, MOJan 8, 1976 · N6552G · Substantial damage NTSB CHI76FEC19Accident · No injuriesClosedChampion 7ECA · Plymouth, MIJan 8, 1976 · N2595F · Substantial damage NTSB LAX76FUD07Accident · No injuriesClosedCessna 150L · Hawthorne, CAJan 4, 1976 · N17003 · Substantial damage NTSB DEN76DTE47Accident · No injuriesClosedCessna 150 · Craig, COJan 4, 1976 · N2956J · Substantial damage NTSB FTW76FRA19Accident · No injuriesClosedCessna 150F · Morgan'S Point, TXJan 1, 1976 · N8817G · Substantial damage NTSB OAK76AP039Accident · 1 fatalClosedCessna A150K · Oakland, CADec 29, 1975 · N8430M · Destroyed NTSB NYC76DHD15Accident · No injuriesClosedCessna 150L · West Chester, PADec 28, 1975 · N1240Q · 2 aircraft · Substantial damage NTSB LAX76FUQ19Accident · No injuriesClosedCessna 150 · Lancaster, CADec 23, 1975 · N7314X · Substantial damage NTSB MIA76FKT37Accident · Minor injuriesClosedCessna 150 · Miami, FLDec 22, 1975 · N50312 · Substantial damage NTSB NYC76DHD07Accident · No injuriesClosedCessna 150 · West Chester, PADec 20, 1975 · N1410Q · Substantial damage NTSB MKC76DCJ20Accident · No injuriesClosedCessna 150 · Omaha, NEDec 19, 1975 · N7959F · Substantial damage NTSB LAX76FUQ18Accident · No injuriesClosedCessna 150L · Morthridge, CADec 19, 1975 · N18020 · Substantial damage NTSB CHI76FEI16Accident · No injuriesClosedCessna 150 · Elyria, OHDec 17, 1975 · N51306 · Substantial damage NTSB IAD76FKW18Accident · No injuriesClosedCessna 150 · Knoxville, TNDec 16, 1975 · N10878 · Substantial damage NTSB FTW76DPJ17Accident · No injuriesClosedTaylorcraft 19 · Oklahoma City, OKDec 14, 1975 · N3551T · Substantial damage NTSB NYC76FHM16Accident · No injuriesClosedCessna 150 · Wayne Township, NJDec 8, 1975 · N3386V · Substantial damage NTSB OAK76FJA06Accident · No injuriesClosedCessna 150J · Hilo, HIDec 1, 1975 · N5130G · Substantial damage NTSB SEA76DYC25Accident · No injuriesClosedCessna 150 · Vancouver, WANov 25, 1975 · N7719E · Substantial damage NTSB LAX76DUG26Accident · No injuriesClosedCessna 150 · Apple Valley, CANov 16, 1975 · N6223T · Substantial damage NTSB CHI76FCA04Accident · No injuriesClosedCessna 150M · Alton, ILNov 16, 1975 · N63556 · Substantial damage NTSB ANC76DAG68Accident · No injuriesClosedCessna 150 · Karluk, AKNov 16, 1975 · N51355 · Substantial damage NTSB LAX76DVA29Accident · Minor injuriesClosedCessna 150 · Pixley, CANov 15, 1975 · N8640S · Substantial damage