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 CHI66F0598Accident · No injuriesClosedCessna 150 · Pontiac, MIMar 5, 1966 · N6471F · Substantial damage NTSB FTW66D0549Accident · No injuriesClosedCessna 150 · Slidell, LAMar 1, 1966 · N3521L · Substantial damage NTSB MKC66F0452Accident · No injuriesClosedCessna 150 · Newton, KSFeb 28, 1966 · N3554J · Substantial damage NTSB LAX66F0258Accident · No injuriesClosedCessna 150 · Reno, NVFeb 28, 1966 · N6624F · Substantial damage NTSB NYC66F0528Accident · No injuriesClosedCessna 150E · Deer Park, NYFeb 27, 1966 · N6164T · Substantial damage NTSB NYC66D0572Accident · No injuriesClosedCessna 150 · Totowa, NJFeb 27, 1966 · N8160S · Substantial damage NTSB NYC66D0533Accident · No injuriesClosedCessna 150 · Friendly, MDFeb 26, 1966 · N5954T · Substantial damage NTSB CHI66D0648Accident · No injuriesClosedCessna 150 · Terre Haute, INFeb 26, 1966 · N6427F · Substantial damage NTSB NYC66F0644Accident · No injuriesClosedCessna 150 · Bedford, MAFeb 22, 1966 · N8366G · Substantial damage NTSB FTW66F0543Accident · No injuriesClosedCessna 150C · Spade, TXFeb 20, 1966 · N1944Z · Substantial damage NTSB DEN66F0252Accident · No injuriesClosedCessna 150 · Broomfield, COFeb 20, 1966 · N7064X · Substantial damage NTSB CHI66D0626Accident · No injuriesClosedCessna 150 · E St Louis, ILFeb 20, 1966 · N3988U · Substantial damage NTSB MIA66D0421Accident · No injuriesClosedCessna 150 · Anniston, ALFeb 19, 1966 · N3987U · Substantial damage NTSB FTW66D0542Accident · No injuriesClosedCessna 150 · Corpus Christ, TXFeb 19, 1966 · N8979S · Substantial damage NTSB CHI66F0589Accident · No injuriesClosedCessna 150 · Winnebago, ILFeb 19, 1966 · N8783S · Substantial damage NTSB MKC66D0411Accident · No injuriesClosedCessna 150 · Bethany, MOFeb 14, 1966 · N6254R · Substantial damage NTSB CHI66F0606Accident · Minor injuriesClosedCessna 150B · Millstadt, ILFeb 13, 1966 · N7334X · Substantial damage NTSB NYC66F0508Accident · No injuriesClosedCessna 150 · New Cumberland, PAFeb 12, 1966 · N7842E · Substantial damage NTSB NYC66D0507Accident · No injuriesClosedCessna 150 · Gaithersburg, MDFeb 12, 1966 · N8716S · Substantial damage NTSB MKC66D0440Accident · No injuriesClosedCessna 150 · Coates, MNFeb 12, 1966 · N4142U · Substantial damage NTSB LAX66F0242Accident · No injuriesClosedCessna 150 · Lompoc, CAFeb 12, 1966 · N7161X · Substantial damage NTSB MKC66F0465Accident · No injuriesClosedCessna 150 · Springfield, MOFeb 7, 1966 · N8835S · Substantial damage NTSB NYC66F0538Accident · No injuriesClosedCessna 150 · Amityville, NYFeb 4, 1966 · N8766S · 2 aircraft · Substantial damage NTSB CHI66F0582Accident · No injuriesClosedCessna 150E · E St Louis, ILFeb 4, 1966 · N3984U · Substantial damage NTSB OAK66F0201Accident · No injuriesClosedCessna 150 · Sacramento, CAFeb 2, 1966 · N8720S · Substantial damage NTSB MKC66F0409Accident · No injuriesClosedCessna 150 · Emporia, KSFeb 2, 1966 · N8778G · Substantial damage NTSB MKC66D0384Accident · No injuriesClosedChampion 7ECA · Olathe, KSFeb 2, 1966 · N9510S · Substantial damage NTSB MIA66D0418Accident · Minor injuriesClosedCessna 150 · Homestead, FLFeb 2, 1966 · N5768E · Substantial damage NTSB NYC66D0554Accident · No injuriesClosedCessna 150 · Newport, RIJan 29, 1966 · N4404U · Substantial damage NTSB NYC66D0447Accident · No injuriesClosedCessna 150B · Pittstown, NJJan 29, 1966 · N1153Y · Substantial damage NTSB NYC66F0446Accident · No injuriesClosedCessna 150 · Bernardsville, NJJan 22, 1966 · N6223R · Substantial damage NTSB NYC66F0442Accident · No injuriesClosedCessna 172 · Houlton, MEJan 22, 1966 · N5400T · Substantial damage NTSB LAX66F0231Accident · No injuriesClosedCessna 150F · W Los Angeles, CAJan 22, 1966 · N8661G · Substantial damage NTSB SEA66D0206Accident · No injuriesClosedCessna 150 · Scappoose, ORJan 18, 1966 · N7024X · Substantial damage NTSB LAX66D0224Accident · No injuriesClosedCessna 150 · Piru, CAJan 18, 1966 · N4240U · Substantial damage NTSB MKC66F0451Accident · No injuriesClosedCessna 150E · St.James, MNJan 16, 1966 · N6169T · Substantial damage NTSB LAX66D0210Accident · No injuriesClosedCessna 150 · Santa Paula, CAJan 16, 1966 · N7774E · Substantial damage NTSB CHI66F0558Accident · No injuriesClosedCessna 150 · Lombard, ILJan 15, 1966 · N3514J · Substantial damage NTSB NYC66D0433Accident · No injuriesClosedCessna 150 · Ambler, PAJan 14, 1966 · N8425G · Substantial damage NTSB MKC66F0420Accident · No injuriesClosedCessna 150 · Fenton, MOJan 14, 1966 · N8834S · Substantial damage NTSB CHI66D0524Accident · No injuriesClosedCessna 150 · Terre Haute, INJan 14, 1966 · N8534G · Substantial damage NTSB ANC66A0085Accident · Minor injuriesClosedCessna 150 · Anchorage, AKJan 14, 1966 · N7085X · Substantial damage NTSB SEA66D0191Accident · No injuriesClosedCessna 150 · Pullman, WAJan 11, 1966 · N8974S · Substantial damage NTSB CHI66F0622Accident · No injuriesClosedCessna 150 · Jacksonville, ILJan 11, 1966 · N8220S · Substantial damage NTSB SEA66F0198Accident · No injuriesClosedCessna 150 · Renton, WAJan 10, 1966 · N8226S · Substantial damage NTSB MKC66F0401Accident · No injuriesClosedCessna 150F · St Louis, MOJan 8, 1966 · N8310G · Substantial damage NTSB CHI66F0527Accident · No injuriesClosedCessna 150 · E Alton, ILJan 4, 1966 · N3988U · Substantial damage NTSB MKC66D0306Accident · No injuriesClosedCessna 150 · Cohasset, MNJan 2, 1966 · N4489U · Substantial damage NTSB SEA66F0193Accident · No injuriesClosedCessna 150 · Ellensburg, WADec 30, 1965 · N7718E · Substantial damage NTSB MKC66F0345Accident · No injuriesClosedCessna 150 · Lincoln, NEDec 30, 1965 · N7236X · Substantial damage