Skip to content

NTSB investigations: Continental 0-300 series

3,125 cases on aircraft whose registry engine model is Continental 0-300 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 ('17022')) 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 ('17022'))
  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 ('17022'))
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 SEA67F0134Accident · No injuriesClosedMaule M-4 · Oledo, ORJul 28, 1966 · N12016 · Substantial damage NTSB MKC67F0145Accident · Minor injuriesClosedCessna 172 · Madison, MNJul 28, 1966 · N6332E · 2 aircraft · Substantial damage NTSB OAK67F0052Accident · No injuriesClosedCessna 172 · Alturas, CAJul 24, 1966 · N3624L · Substantial damage NTSB NYC67F0074Accident · No injuriesClosedCessna 172F · Reading, PAJul 24, 1966 · N8691U · Substantial damage NTSB LAX67A0011Accident · 2 fatalClosedGlobe GC-1B · El Toro, CAJul 24, 1966 · N3786K · Destroyed NTSB FTW67F0110Accident · No injuriesClosedCessna 172 · Amarillo, TXJul 24, 1966 · N8368U · Substantial damage NTSB DEN67D0047Accident · No injuriesClosedCessna 172 · Quemado, NMJul 23, 1966 · N8182B · Destroyed NTSB NYC67D0105Accident · No injuriesClosedCessna 172 · Madison, CTJul 17, 1966 · N3597S · Substantial damage NTSB NYC67D0115Accident · No injuriesClosedCessna 172 · Walden, NYJul 16, 1966 · N3813L · Substantial damage NTSB LAX67D0066Accident · No injuriesClosedCessna 172 · Van Nuys, CAJul 15, 1966 · N2931U · Substantial damage NTSB MIA67F0057Accident · Minor injuriesClosedCessna 172 · Lamar, MSJul 14, 1966 · N6744A · Substantial damage NTSB OAK67A0009Accident · 2 fatalClosedCessna 172 · San Carlos, CAJul 12, 1966 · N7484T · Destroyed NTSB NYC67D0052Accident · Minor injuriesClosedCessna 172 · Waterbury, CTJul 10, 1966 · N6013R · Substantial damage NTSB CHI67F0084Accident · Minor injuriesClosedCessna 172 · Circleville, OHJul 4, 1966 · N6462B · Substantial damage NTSB CAN F0404Accident · No injuriesClosedCessna 172 · St.Laurent, CanadaJul 4, 1966 · N2382U · Substantial damage NTSB NYC67D0194Accident · No injuriesClosedCessna 170 · Alexandria, VAJul 3, 1966 · N1827Y · Substantial damage NTSB OAK67D0038Accident · Serious injuriesClosedCessna 172 · Monache Medow, CAJul 2, 1966 · N8903B · Destroyed NTSB SEA67D0055Accident · No injuriesClosedCessna 172 · Kalispell, MTJul 1, 1966 · N3733L · Substantial damage NTSB MKC67D0063Accident · No injuriesClosedCessna 172F · Kennett, MOJun 30, 1966 · N7871U · Substantial damage NTSB DEN67D0027Accident · Minor injuriesClosedCessna 172G · Albuquerque, NMJun 28, 1966 · N5932R · Destroyed NTSB CHI67D0080Accident · No injuriesClosedCessna 172 · Richland Cntr, WIJun 24, 1966 · N6202E · Destroyed NTSB MKC67D0152Accident · No injuriesClosedCessna 172 · Piedmont, MOJun 22, 1966 · N4408L · Substantial damage NTSB MIA67D0068Accident · No injuriesClosedMaule M-4 · Decatur, ALJun 22, 1966 · N9814M · Substantial damage NTSB MIA66D0612Accident · No injuriesClosedCessna 172 · High Point, NCJun 21, 1966 · N7315T · Substantial damage NTSB MIA67D0535Accident · No injuriesClosedCessna 172 · Brewton, ALJun 20, 1966 · N4021F · Substantial damage NTSB OAK67D0022Accident · No injuriesClosedCessna 172C · Petaluma, CAJun 18, 1966 · N7966U · Substantial damage NTSB SEA67D0025Accident · No injuriesClosedCessna 172 · Atomic City, IDJun 17, 1966 · N3826L · Substantial damage NTSB MKC67F0028Accident · No injuriesClosedCessna 172 · Berger, MOJun 17, 1966 · N7287A · Substantial damage NTSB CHI67F0056Accident · No injuriesClosedCessna 172G · Columbia, ILJun 14, 1966 · N3969L · Substantial damage NTSB LAX66F0384Accident · No injuriesClosedCessna 170B · Bakersfield, CAJun 13, 1966 · N4595C · Substantial damage NTSB OAK66A0056Accident · 2 fatalClosedCessna 172 · Seigler Sprgs, CAJun 11, 1966 · N7204A · Destroyed NTSB FTW67D0037Accident · No injuriesClosedCessna 172 · Alba, TXJun 11, 1966 · N5621A · Substantial damage NTSB OAK67F0238Accident · Minor injuriesClosedCessna 172A · Milpitas, CAJun 9, 1966 · N9896T · Substantial damage NTSB NYC67D0020Accident · No injuriesClosedCessna 172 · Ansonia, CTJun 9, 1966 · N3813L · Substantial damage NTSB FTW67F0022Accident · No injuriesClosedCessna 172F · Bethany, OKJun 5, 1966 · N5327R · Substantial damage NTSB LAX66F0380Accident · Serious injuriesClosedCessna 172G · Fullerton, CAJun 4, 1966 · N3768L · Substantial damage NTSB MIA66F0563Accident · Minor injuriesClosedCessna 172 · Hendersonville, NCJun 2, 1966 · N5498R · Substantial damage NTSB MKC66F0575Accident · No injuriesClosedCessna 172G · Park Rapids, MNMay 31, 1966 · N5942R · Substantial damage NTSB DEN67D0001Accident · No injuriesClosedCessna 170 · Deming, NMMay 31, 1966 · N4302B · Substantial damage NTSB LAX66D0368Accident · No injuriesClosedCessna 172 · Apple Valley, CAMay 29, 1966 · N8863U · Destroyed NTSB SEA67D0062Accident · No injuriesClosedCessna 172 · Gold Beach, ORMay 28, 1966 · N3942L · Substantial damage NTSB MKC67D0069Accident · No injuriesClosedCessna 172 · St.Charles, MOMay 28, 1966 · N5643A · Substantial damage NTSB MKC66F0591Accident · No injuriesClosedCessna 172 · Pierre, SDMay 28, 1966 · N8239X · Substantial damage NTSB NYC66D0705Accident · No injuriesClosedCessna 172 · Penn Yan, NYMay 27, 1966 · N6197E · Substantial damage NTSB LAX66A0093Accident · 2 fatalClosedCessna 172E · Wendover, NVMay 26, 1966 · N3887S · Destroyed NTSB CHI66D0777Accident · Minor injuriesClosedCessna 172 · Middleton, WIMay 26, 1966 · N8795B · Substantial damage NTSB SEA66A0060Accident · 3 fatalClosedCessna 172 · Metaline Fls, WAMay 24, 1966 · N7230A · Substantial damage NTSB MIA66D0558Accident · No injuriesClosedCessna 172B · Davie, FLMay 23, 1966 · N7776X · Substantial damage NTSB MKC66D0585Accident · No injuriesClosedCessna 172 · Camdenton, MOMay 21, 1966 · N5597R · Substantial damage NTSB MKC66D0545Accident · No injuriesClosedCessna 172 · Worthington, MNMay 19, 1966 · N7040T · Substantial damage