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 SEA66D0283Accident · No injuriesClosedCessna 150C · Orofino, IDMay 16, 1966 · N1964Z · Substantial damage NTSB MKC66F0562Accident · No injuriesClosedCessna 150 · Kansas City, KSMay 12, 1966 · N6725F · Substantial damage NTSB CHI66D0771Accident · No injuriesClosedCessna 150 · East St.Louis, ILMay 8, 1966 · N8391G · Substantial damage NTSB MKC66D0568Accident · No injuriesClosedCessna 150F · Cape Girardeau, MOMay 7, 1966 · N8809S · Substantial damage NTSB CHI66F0719Accident · No injuriesClosedCessna 150F · Rockford, ILMay 7, 1966 · N8331G · Substantial damage NTSB FTW67F0002Accident · Minor injuriesClosedCessna 150 · Arren, ARMay 6, 1966 · N7170X · Substantial damage NTSB MIA66D0541Accident · No injuriesClosedCessna 150 · Sebring, FLMay 4, 1966 · N7315X · Substantial damage NTSB FTW66F0657Accident · No injuriesClosedCessna 150 · Dallas, TXMay 4, 1966 · N7941E · Substantial damage NTSB FTW66D0650Accident · Minor injuriesClosedCessna 150 · Hammod, LAMay 1, 1966 · N6595F · Destroyed NTSB DEN66D0347Accident · No injuriesClosedCessna 150 · Trinidad, COMay 1, 1966 · N7729F · Substantial damage NTSB CHI66F0708Accident · No injuriesClosedCessna 150 · Rockford, ILMay 1, 1966 · N6630F · Substantial damage NTSB MKC66D0564Accident · No injuriesClosedCessna 150 · Houston, MOApr 27, 1966 · N1922Z · Destroyed NTSB LAX66D0346Accident · No injuriesClosedCessna 150 · Temecula, CAApr 25, 1966 · N8840S · Substantial damage NTSB SEA66D0298Accident · No injuriesClosedCessna 150E · Mulino, ORApr 22, 1966 · N3012J · Substantial damage NTSB FTW66F0634Accident · No injuriesClosedCessna 150F · San Antonio, TXApr 19, 1966 · N8925S · Substantial damage NTSB OAK66F0231Accident · Minor injuriesClosedCessna 150 · Richvale, CAApr 18, 1966 · N8340G · Substantial damage NTSB FTW66F0636Accident · No injuriesClosedCessna 150 · Arlington, TXApr 18, 1966 · N8726G · Substantial damage NTSB NYC66F0636Accident · No injuriesClosedCessna 150 · Bedford, MAApr 17, 1966 · N8171S · Substantial damage NTSB NYC66F0630Accident · No injuriesClosedCessna 150 · Richmond, VAApr 15, 1966 · N8046S · Substantial damage NTSB FTW66F0613Accident · No injuriesClosedCessna 150; · Pearland, TXApr 14, 1966 · N8635G · Substantial damage NTSB LAX66D0313Accident · No injuriesClosedCessna 150 · Santa Monica, CAApr 13, 1966 · N3572J · Substantial damage NTSB OAK66D0247Accident · No injuriesClosedCessna 150 · Palo Alto, CAApr 11, 1966 · N8496G · Substantial damage NTSB SEA66F0274Accident · No injuriesClosedCessna 150 · Albany, ORApr 9, 1966 · N6767F · Substantial damage NTSB MKC66D0572Accident · No injuriesClosedCessna 150 · Bonner Sprng, KSApr 8, 1966 · N4008U · Substantial damage NTSB LAX66D0297Accident · No injuriesClosedCessna 150 · Palm Springs, CAApr 8, 1966 · N6053T · Substantial damage NTSB FTW66D0621Accident · No injuriesClosedCessna 150 · Port Mansfild, TXApr 8, 1966 · N4083U · Substantial damage NTSB SEA66F0258Accident · No injuriesClosedCessna 150 · Mount Vernon, WAApr 4, 1966 · N8004S · Substantial damage NTSB LAX66F0288Accident · No injuriesClosedCessna 150 · Van Nuys, CAApr 2, 1966 · N6414T · Substantial damage NTSB FTW66F0590Accident · No injuriesClosedCessna 150F · Lubbock, TXApr 2, 1966 · N8596G · Substantial damage NTSB LAX66D0286Accident · No injuriesClosedCessna 150 · San Diego, CAMar 31, 1966 · N8322G · Substantial damage NTSB MIA66F0490Accident · No injuriesClosedCessna 150 · Ormond Beach, FLMar 30, 1966 · N3001J · Substantial damage NTSB OAK66D0244Accident · No injuriesClosedCessna 150 · San Jose, CAMar 27, 1966 · N8345G · Substantial damage NTSB DEN66D0288Accident · No injuriesClosedCessna 150 · Wickenburg, AZMar 26, 1966 · N4448U · Substantial damage NTSB MKC65F0485Accident · No injuriesClosedCessna 150D · Kennett, MOMar 21, 1966 · N4303U · Substantial damage NTSB LAX66F0285Accident · No injuriesClosedCessna 150 · Sna Pedro, CAMar 21, 1966 · N6260R · Substantial damage NTSB SEA66F0233Accident · No injuriesClosedCessna 150 · Boise, IDMar 16, 1966 · N8324G · Substantial damage NTSB OAK66F0245Accident · Minor injuriesClosedCessna 150 · Honolulu, HIMar 16, 1966 · N6473T · Substantial damage NTSB NYC66D0559Accident · Minor injuriesClosedCessna 150 · Deer Park, NYMar 15, 1966 · N6495F · Substantial damage NTSB MIA66F0450Accident · No injuriesClosedCessna 150F · Titusville, FLMar 15, 1966 · N8861G · Substantial damage NTSB FTW66D0593Accident · No injuriesClosedCessna 150 · Houston, TXMar 15, 1966 · N8758S · Substantial damage NTSB MKC66D0526Accident · No injuriesClosedCessna 150 · Hibbing, MNMar 14, 1966 · N5999T · Substantial damage NTSB DEN66F0721Accident · Serious injuriesClosedCessna 150 · Las Cruces, NMMar 14, 1966 · N6592T · Destroyed NTSB CHI66D0634Accident · No injuriesClosedCessna 150 · Strongsville, OHMar 13, 1966 · N4344U · Substantial damage NTSB NYC66D0601Accident · No injuriesClosedCessna 150 · Manassas, VAMar 12, 1966 · N2558J · Substantial damage NTSB MIA66F0457Accident · No injuriesClosedCessna 150 · Opa Locka, FLMar 11, 1966 · N8568G · Substantial damage NTSB NYC66F0582Accident · No injuriesClosedCessna 150 · Montgomery, NYMar 9, 1966 · N8507G · Substantial damage NTSB NYC66F0529Accident · No injuriesClosedCessna 150 · West Mifflin, PAMar 9, 1966 · N3977U · Substantial damage NTSB DEN66D0270Accident · No injuriesClosedCessna 150 · Phoenix, AZMar 9, 1966 · N8087S · Substantial damage NTSB CHI66F0675Accident · No injuriesClosedCessna 150 · Northbrook, ILMar 7, 1966 · N2570J · Substantial damage NTSB FTW66D0525Accident · No injuriesClosedCessna 172 · Oklahoma City, OKMar 5, 1966 · N5747T · Substantial damage