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 UNK64X3518Accident · No injuriesClosedCessna 150 · Midland, TXAug 21, 1964 · N4169U · Substantial damage NTSB UNK64X3512Accident · No injuriesClosedCessna 150 · Mountain Home, IDAug 21, 1964 · N6653T · Substantial damage NTSB UNK64X3452Accident · No injuriesClosedCessna 150 · Denver, COAug 18, 1964 · N7758E · Substantial damage NTSB UNK64X3424Accident · No injuriesClosedCessna 150 · Lauerne, CAAug 16, 1964 · N4270U · Substantial damage NTSB UNK64X3418Accident · No injuriesClosedCessna 150 · Jamestown, NDAug 16, 1964 · N2074Z · Substantial damage NTSB UNK64X3389Accident · No injuriesClosedCessna 150 · Bowlus, MNAug 15, 1964 · N7379X · Substantial damage NTSB UNK64X3337Accident · Minor injuriesClosedCessna 150 · St Charles, MOAug 12, 1964 · N4310U · Destroyed NTSB UNK64X3299Accident · No injuriesClosedCessna 150 · Columbia, TNAug 9, 1964 · N4291U · Substantial damage NTSB UNK64X3293Accident · No injuriesClosedCessna 150 · Asbury Park, NJAug 9, 1964 · N5708E · Substantial damage NTSB UNK64X3247Accident · No injuriesClosedCessna 170 · San Jose, CAAug 6, 1964 · N4273V · 2 aircraft · Minor damage NTSB UNK64X2907Accident · No injuriesClosedCessna 150 · Oslo, MNJul 18, 1964 · N7336X · Substantial damage NTSB UNK64X2724Accident · No injuriesClosedCessna 150 · Minerva, OHJul 9, 1964 · N7990E · Substantial damage NTSB UNK64X2710Accident · No injuriesClosedCessna 150 · Rhinebeck, NYJul 8, 1964 · N6680T · Substantial damage NTSB UNK64X2699Accident · No injuriesClosedCessna 150 · El Monte, CAJul 7, 1964 · N7091X · Substantial damage NTSB UNK64X2666Accident · No injuriesClosedCessna 150 · Santa Susana, CAJul 5, 1964 · N7827E · Substantial damage NTSB UNK64X2644Accident · No injuriesClosedCessna 150 · Pacoima, CAJul 4, 1964 · N5668E · Substantial damage NTSB UNK64X2577Accident · No injuriesClosedCessna 150B · Schenectady, NYJun 30, 1964 · N7370X · Destroyed NTSB UNK64X2400Accident · No injuriesClosedCessna 150 · Denver, COJun 20, 1964 · N7064X · Substantial damage NTSB UNK64X2395Accident · No injuriesClosedCessna 150 · Dayton, OHJun 20, 1964 · N5994E · Substantial damage NTSB UNK64X2318Accident · No injuriesClosedCessna 150 · Butler, GAJun 16, 1964 · N7204X · Substantial damage NTSB UNK64X2315Accident · No injuriesClosedCessna 150 · Fenton, MIJun 16, 1964 · N1247Y · Substantial damage NTSB UNK64X2291Accident · No injuriesClosedCessna 150 · Roswell, NMJun 14, 1964 · N7790E · Substantial damage NTSB UNK64X2171Accident · No injuriesClosedCessna 150 · Las Vegas, NVJun 7, 1964 · N1169Y · Substantial damage NTSB UNK64X2127Accident · No injuriesClosedCessna 150 · Sussex, NJJun 5, 1964 · N5739E · Substantial damage NTSB UNK64X2067Accident · Minor injuriesClosedCessna 150C · Medora, KSJun 2, 1964 · N7882Z · Substantial damage NTSB UNK64X1968Accident · No injuriesClosedChampion 402 · Friendly, MDMay 27, 1964 · N9954Y · Substantial damage NTSB UNK64X1883Accident · No injuriesClosedCessna 150 · Northhampton, MAMay 22, 1964 · N6492T · Substantial damage NTSB UNK64X1867Accident · No injuriesClosedCessna 150 · Taplin, WVMay 21, 1964 · N7267X · Substantial damage NTSB UNK64X1846Accident · No injuriesClosedCessna 150 · Walnut Grove, CAMay 19, 1964 · N2068Z · Substantial damage NTSB UNK64X1845Accident · No injuriesClosedCessna 150 · W Carrollton, OHMay 19, 1964 · N7958E · Substantial damage NTSB UNK64X1771Accident · No injuriesClosedCessna 150 · Clarkrange, TNMay 15, 1964 · N7302X · Substantial damage NTSB UNK64X1699Accident · Minor injuriesClosedCessna 140 · Glenwood, ILMay 10, 1964 · N89671 · Substantial damage NTSB UNK64X1682Accident · No injuriesClosedCessna 150 · Chattanooga, OKMay 9, 1964 · N5965E · Substantial damage NTSB UNK64X1602Accident · No injuriesClosedCessna 150 · St Meinrad, INMay 3, 1964 · N7115X · Substantial damage NTSB UNK64X1598Accident · No injuriesClosedCessna 150 · Clayton, INMay 3, 1964 · N5517E · Substantial damage NTSB UNK64X1592Accident · Minor injuriesClosedCessna 150 · Santa Rosa, CAMay 3, 1964 · N7879Z · 2 aircraft · Destroyed NTSB UNK64X1566Accident · No injuriesClosedCessna 150A · Boca Raton, FLMay 2, 1964 · N6638T · Substantial damage NTSB UNK64X1497Accident · No injuriesClosedCessna 172 · Santa Ana, CAApr 28, 1964 · N3879S · Substantial damage NTSB UNK64X1455Accident · No injuriesClosedCessna 150 · Milwaukee, WIApr 25, 1964 · N6529T · Substantial damage NTSB UNK64X1420Accident · No injuriesClosedCessna 150 · Samsula, FLApr 23, 1964 · N2078Z · Substantial damage NTSB UNK64X1301Accident · No injuriesClosedCessna 150 · Dallas, TXApr 13, 1964 · N5667E · Substantial damage NTSB UNK64X1290Accident · 1 fatalClosedCessna 150 · Solon Springs, WIApr 12, 1964 · N7829Z · Destroyed NTSB UNK64X1281Accident · No injuriesClosedCessna 150 · Midland, TXApr 12, 1964 · N4169U · Substantial damage NTSB UNK64X1210Accident · No injuriesClosedCessna 150 · Medina, OHApr 7, 1964 · N4121U · Substantial damage NTSB UNK64X1115Accident · No injuriesClosedCessna 150 · Ft Scott, KSMar 31, 1964 · N7938Z · Substantial damage NTSB UNK64X1040Accident · No injuriesClosedCessna 150 · Wray, COMar 26, 1964 · N6688T · Destroyed NTSB UNK64X0961Accident · No injuriesClosedCessna 150 · Pearland, TXMar 17, 1964 · N5864E · Substantial damage NTSB UNK64X0941Accident · No injuriesClosedCessna 150 · Capistrano, CAMar 15, 1964 · N7827E · Substantial damage NTSB UNK64X0925Accident · No injuriesClosedCessna 150C · Bonner Spgs, KSMar 15, 1964 · N7952Z · Substantial damage NTSB UNK64X0840Accident · Serious injuriesClosedCessna 150 · Bristol, VTMar 7, 1964 · N6508T · No damage