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 DEN68D0058Accident · No injuriesClosedCessna 150 · Springer, NMAug 8, 1967 · N8228F · Substantial damage NTSB FTW68D0149Accident · No injuriesClosedCessna 150 · Pearland, TXAug 6, 1967 · N6722F · Substantial damage NTSB CHI68D0315Accident · No injuriesClosedCessna 150 · Freeport, ILAug 6, 1967 · N3286J · Substantial damage NTSB MKC68D0220Accident · Minor injuriesClosedCessna 150 · Neosho, MOAug 5, 1967 · N8740S · Destroyed NTSB MIA68D0238Accident · No injuriesClosedCessna 150 · Jackson, SCAug 5, 1967 · N7722E · Substantial damage NTSB OAK68D0141Accident · No injuriesClosedCessna 150 · Mountain City, NVAug 2, 1967 · N6406F · Substantial damage NTSB DEN68D0057Accident · Minor injuriesClosedCessna 150 · Aurora, COAug 2, 1967 · N4613X · Substantial damage NTSB NYC68F0063Accident · No injuriesClosedCessna 150G · Collegeville, PAAug 1, 1967 · N8307J · Substantial damage NTSB LAX68D0100Accident · No injuriesClosedBeech E18S · Phoenix, AZAug 1, 1967 · N301V · 2 aircraft · Substantial damage NTSB LAX68F0085Accident · No injuriesClosedCessna 150F · Hawthorne, CAJul 31, 1967 · N8657S · Substantial damage NTSB CHI68F0112Accident · No injuriesClosedCessna 150 · Ann Arbor, MIJul 31, 1967 · N8299S · Substantial damage NTSB MIA68D0075Accident · No injuriesClosedCessna 150 · Clarksville, TNJul 29, 1967 · N2938S · Substantial damage NTSB LAX68D0145Accident · No injuriesClosedCessna 150 · Palm Sprngs, CAJul 28, 1967 · N6440F · Substantial damage NTSB OAK68D0219Accident · No injuriesClosedCessng 150 · Reno, NVJul 27, 1967 · N6742F · Substantial damage NTSB NYC68F0097Accident · No injuriesClosedCessna 150F · Marilla, NYJul 26, 1967 · N8176F · Substantial damage NTSB NYC68F0096Accident · No injuriesClosedCessna 150 · Medford, NJJul 26, 1967 · N2779S · Substantial damage NTSB CHI68F0191Accident · Serious injuriesClosedCessna 150 · Waynesville, OHJul 26, 1967 · N6248S · Substantial damage NTSB FTW68F0098Accident · No injuriesClosedCessna 150F · Wynnewood, OKJul 25, 1967 · N8284S · Substantial damage NTSB FTW68F0181Accident · Minor injuriesClosedCessna 150 · Dallas, TXJul 24, 1967 · N6268T · Substantial damage NTSB MIA68D0089Accident · No injuriesClosedCessna 150 · Miami, FLJul 23, 1967 · N8531G · Substantial damage NTSB FTW68F0097Accident · No injuriesClosedCessna 150 · Dumas, ARJul 23, 1967 · N6217R · Substantial damage NTSB MKC68F0318Accident · No injuriesClosedCessna 150 · Ft Leonrd Wood, MOJul 22, 1967 · N8835S · Substantial damage NTSB MIA68F0082Accident · No injuriesClosedCessna 150 · Hialeah, FLJul 22, 1967 · N7700F · Substantial damage NTSB DEN68D0035Accident · No injuriesClosedCessna 150 · Broomfield, COJul 22, 1967 · N6640F · Substantial damage NTSB SEA68D0054Accident · No injuriesClosedCessna 150 · Missoula, MTJul 21, 1967 · N3130J · Substantial damage NTSB DIA68D0038Accident · Minor injuriesClosedCessna 150 · Little River, SCJul 21, 1967 · N8479G · Destroyed NTSB SEA68D0118Accident · No injuriesClosedCessna 150F · Sutherlin, ORJul 16, 1967 · N6533F · Substantial damage NTSB NYC68F0082Accident · No injuriesClosedCougar I · Minersville, PAJul 16, 1967 · N1112Y · Substantial damage NTSB CHI68F0076Accident · Minor injuriesClosedCessna 150 · Hillsdale, MIJul 13, 1967 · N7920F · Destroyed NTSB NYC68A0006Accident · 1 fatalClosedChampion 7ECA · Holley, NYJul 12, 1967 · N9521S · Destroyed NTSB MKC68D0079Accident · No injuriesClosedCessna 150 · Cedar Rapids, IAJul 12, 1967 · N8802S · Substantial damage NTSB FTW68D0092Accident · No injuriesClosedCessna 150 · Arlington, TXJul 12, 1967 · N7220X · Substantial damage NTSB NYC68D0060Accident · No injuriesClosedCessna 150 · Shirley, MAJul 11, 1967 · N3099X · Destroyed NTSB FTW68F0046Accident · No injuriesClosedCessna 150F · Pearland, TXJul 7, 1967 · N6456F · 2 aircraft · Substantial damage NTSB FTW68D0029Accident · No injuriesClosedCessna 150 · Fort Worth, TXJul 6, 1967 · N8595G · Substantial damage NTSB LAX68D0037Accident · No injuriesClosedCessna 150 · Van Nuys, CAJul 5, 1967 · N4035J · Substantial damage NTSB DEN68F0012Accident · Serious injuriesClosedCessna 150 · Watkins, COJul 5, 1967 · N7140F · Substantial damage NTSB MIA68D0041Accident · No injuriesClosedCessna 150 · Lithonia, GAJul 3, 1967 · N8607J · Substantial damage NTSB LAX68F0054Accident · No injuriesClosedCessna 172 · Arcadia, CAJul 2, 1967 · N3879S · Substantial damage NTSB MKC68D0200Accident · Minor injuriesClosedCessna 150 · Bennington, KSJul 1, 1967 · N4780X · Substantial damage NTSB FTW68D0060Accident · No injuriesClosedCessna 150 · Bowie, TXJun 30, 1967 · N3131X · Substantial damage NTSB OAK68D0103Accident · No injuriesClosedCessna 150 · Minden, NVJun 29, 1967 · N8286S · Substantial damage NTSB MIA68D0070Accident · Minor injuriesClosedCessna 150 · Ft.Meyers, FLJun 28, 1967 · N3773J · Substantial damage NTSB CHI68D0101Accident · No injuriesClosedCessna 150 · Northbrook, ILJun 27, 1967 · N8602G · Substantial damage NTSB NYC68F0032Accident · No injuriesClosedCessna 150 · Pittstown, NJJun 26, 1967 · N6608T · Substantial damage NTSB OAK68D0024Accident · No injuriesClosedCessna 150 · Placerville, CAJun 25, 1967 · N6138T · Substantial damage NTSB MIA68D0068Accident · No injuriesClosedCessna 150 · Brunswick, GAJun 25, 1967 · N6615F · Substantial damage NTSB DEN68F0030Accident · Minor injuriesClosedCessna 150 · Silver City, NMJun 25, 1967 · N8677S · Substantial damage NTSB CHI68D0240Accident · Minor injuriesClosedCessna 150 · Canal Fulton, OHJun 25, 1967 · N6714F · Destroyed NTSB CHI68D0091Accident · No injuriesClosedCessna 150 · Black R.Fall, WIJun 25, 1967 · N3679J · Substantial damage