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 FTW66D0002Accident · No injuriesClosedCessna 150 · Ardmore, OKMar 3, 1965 · N2578J · Substantial damage NTSB SEA65F0062Accident · No injuriesClosedCessna 150 · Mulino, ORFeb 28, 1965 · N7970E · Substantial damage NTSB MKC65D0149Accident · No injuriesClosedCessna 150 · Kansas City, MOFeb 27, 1965 · N3040J · Substantial damage NTSB NYC65F0087Accident · No injuriesClosedCessna 150 · Nedrow, NYFeb 23, 1965 · N7793E · Substantial damage NTSB LAX65F0013Accident · No injuriesClosedCessna 150 · Newhall, CAFeb 20, 1965 · N4382U · Substantial damage NTSB FTW66D0001Accident · No injuriesClosedCessna 150 · Washburn, TXFeb 18, 1965 · N4437U · Destroyed NTSB UNK65X1431Accident · No injuriesClosedCessna 150 · Homestead, FLFeb 17, 1965 · N1947Z · Substantial damage NTSB LAX65D0016Accident · No injuriesClosedCessna 150 · San Diego, CAFeb 13, 1965 · N6105T · Substantial damage NTSB UNK65X1388Accident · No injuriesClosedCessna 150 · Opa Locka, FLFeb 3, 1965 · N3076J · Substantial damage NTSB NYC65F0039Accident · No injuriesClosedCessna 150 · Hanover, NJJan 31, 1965 · N6504T · Substantial damage NTSB CHI65D0025Accident · No injuriesClosedCessna 150 · New Holstein, WIJan 31, 1965 · N7910E · Substantial damage NTSB UNK65X1366Accident · No injuriesClosedCessna 150D · Ft Worth, TXJan 28, 1965 · N4502U · Substantial damage NTSB CHI65F0010Accident · No injuriesClosedCessna 150 · Wadsworth, OHJan 28, 1965 · N7061X · Substantial damage NTSB UNK65X1341Accident · Minor injuriesClosedCessna 150 · Sacramento, CAJan 24, 1965 · N4396U · Substantial damage NTSB UNK65X1320Accident · No injuriesClosedCessna 150 · Zuni, NMJan 20, 1965 · N2530J · Substantial damage NTSB UNK65X1308Accident · No injuriesClosedCessna 150 · Fabens, TXJan 18, 1965 · N5576E · Substantial damage NTSB UNK65X1298Incident · No injuriesClosedCessna 182B · Mineral Wells, TXJan 17, 1965 · N2427G · 2 aircraft · Minor damage NTSB UNK65X1260Accident · No injuriesClosedCessna 150 · Mattituck, NYJan 9, 1965 · N7950Z · Substantial damage NTSB UNK65X1252Accident · No injuriesClosedCessna 150 · Ellensburg, WAJan 8, 1965 · N7718E · Substantial damage NTSB UNK65X1232Accident · No injuriesClosedCessna 150 · Homestead, FLJan 5, 1965 · N1943Z · Substantial damage NTSB UNK65X1075Accident · 1 fatalClosedCessna 150 · Odessa, TXDec 20, 1964 · N5966E · Destroyed NTSB UNK65X1056Accident · No injuriesClosedCessna 150 · San Carlos, CADec 19, 1964 · N5973E · 2 aircraft · Substantial damage NTSB UNK65X0975Accident · No injuriesClosedCessna 150 · Blue Springs, MODec 11, 1964 · N4122U · Substantial damage NTSB UNK65X0965Accident · No injuriesClosedCessna 150 · Lima, OHDec 10, 1964 · N5879E · Substantial damage NTSB UNK65X0953Accident · No injuriesClosedCessna 150 · Ypsilanti, MIDec 8, 1964 · N5673E · Substantial damage NTSB UNK65X0882Accident · No injuriesClosedCessna 150 · San Bernardino, CANov 29, 1964 · N7965E · Substantial damage NTSB UNK65X0830Accident · Minor injuriesClosedCessna 150C · Santa Monica, CANov 25, 1964 · N1992Z · 2 aircraft · Minor damage NTSB UNK65X0747Accident · No injuriesClosedCessna 150 · Detroit, MINov 17, 1964 · N1222Y · Substantial damage NTSB UNK65X0631Accident · No injuriesClosedCessna 150 · Fredericksburg, VANov 9, 1964 · N1199Y · Substantial damage NTSB UNK65X0619Accident · No injuriesClosedCessna 150 · San Carlos, CANov 8, 1964 · N6055T · Substantial damage NTSB UNK65X0589Accident · No injuriesClosedCessna 150 · Hopewell Jct, NYNov 7, 1964 · N5621E · Destroyed NTSB UNK65X0564Accident · No injuriesClosedCessna 150 · Jonesboro, GANov 5, 1964 · N1148Y · Substantial damage NTSB UNK65X0532Accident · No injuriesClosedCessna 150 · Hawthorne, CANov 2, 1964 · N7771E · Substantial damage NTSB UNK65X0530Accident · No injuriesClosedCessna 150 · San Carlos, CANov 2, 1964 · N6065T · Substantial damage NTSB UNK65X0474Accident · Minor injuriesClosedCessna 150 · Medical Lake, WAOct 29, 1964 · N7942E · Destroyed NTSB UNK65X0466Accident · Serious injuriesClosedCessna 150 · Schneider, INOct 28, 1964 · N6235T · Destroyed NTSB UNK65X0435Accident · No injuriesClosedCessna 150 · Clarion, PAOct 25, 1964 · N7766E · Substantial damage NTSB UNK65X0389Accident · No injuriesClosedMorrow II · Hobbs, NMOct 23, 1964 · N75281 · Substantial damage NTSB UNK65X0221Accident · No injuriesClosedCessna 150 · Hanson, MAOct 10, 1964 · N7728E · Substantial damage NTSB UNK65X0218Accident · No injuriesClosedCessna 150 · San Jose, CAOct 10, 1964 · N7374X · Substantial damage NTSB UNK65X0154Accident · No injuriesClosedCessna 150 · Allentown, PAOct 5, 1964 · N6560T · Substantial damage NTSB UNK64X4094Accident · No injuriesClosedCessna 150 · Hanover, NJSep 22, 1964 · N4491U · Substantial damage NTSB UNK64X4068Accident · No injuriesClosedCessna 150B · Tucson, AZSep 20, 1964 · N7364X · Substantial damage NTSB UNK64X4021Accident · No injuriesClosedCessna 172A · Beverly, MASep 17, 1964 · N9712T · Minor damage NTSB UNK64X4009Accident · No injuriesClosedCessna 150 · Hanover, NJSep 16, 1964 · N7791E · Substantial damage NTSB UNK64X3942Accident · No injuriesClosedCessna 140 · Bloom, KSSep 12, 1964 · N1806V · Substantial damage NTSB UNK64X3860Accident · No injuriesClosedCessna 150D · Boulder City, NVSep 7, 1964 · N901SW · Substantial damage NTSB UNK64X3842Accident · No injuriesClosedCessna 150 · San Jose, CASep 7, 1964 · N7310X · Substantial damage NTSB UNK64X3823Accident · No injuriesClosedCessna 150 · Houston, TXSep 6, 1964 · N1195Y · Substantial damage NTSB UNK64X3571Accident · No injuriesClosedCessna 150 · Lacombe, LAAug 23, 1964 · N377E · No damage