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 DEN77DQA11Accident · No injuriesClosedCessna 172 · Lordsburg, NMFeb 18, 1977 · N5733R · Substantial damage NTSB SEA77DYPI9Accident · No injuriesClosedCessna 172 · Kennewick, WAFeb 16, 1977 · N8493U · Substantial damage NTSB MKC77FTG02Accident · No injuriesClosedCessna 172F · Driscoll, NDFeb 11, 1977 · N8358U · Substantial damage NTSB MKC77DCJ10Accident · No injuriesClosedCessna 172H · Grand Island, NEFeb 4, 1977 · N3779F · Substantial damage NTSB CHI77DER02Accident · No injuriesClosedCessna 172F · Glenwood City, WIFeb 3, 1977 · N8121U · Substantial damage NTSB OAK77DVG18Accident · Serious injuriesClosedCessna 172 · Dunsmuir, CAJan 22, 1977 · N19FD · Destroyed NTSB OAK77DVD11Accident · No injuriesClosedCessna 172 · Lodi, CAJan 22, 1977 · N7459X · Substantial damage NTSB MKC77FER14Accident · No injuriesClosedCessna 172G · Rutledge, MNJan 15, 1977 · N4680L · Substantial damage NTSB MKC77FER12Accident · Minor injuriesClosedCessna 172 · Morris, MNDec 30, 1976 · N7834U · Substantial damage NTSB MIA77FLG05Accident · No injuriesClosedCessna 172 · Columbia, SCDec 29, 1976 · N5529T · Substantial damage NTSB CHI77FEC07Accident · No injuriesClosedCessna 172 · Detroit, MIDec 29, 1976 · N2791L · Substantial damage NTSB IAD77FID08Accident · No injuriesClosedCessna 172 · Richmond, VADec 16, 1976 · N4291L · Substantial damage NTSB CHI77DEV07Accident · No injuriesClosedCessna 172 · Benton, ILDec 5, 1976 · N6815A · Substantial damage NTSB FTW77FPJ01Accident · No injuriesClosedCessna 172 · Oklahoma City, OKNov 25, 1976 · N5473R · Substantial damage NTSB MKC77DCQ06Accident · Minor injuriesClosedCessna 172 · Fort Scott, KSNov 16, 1976 · N6640A · Substantial damage NTSB SEA77DYC06Accident · No injuriesClosedCessna 172F · Baker, ORNov 14, 1976 · N8787U · Substantial damage NTSB IAD77DID06Accident · No injuriesClosedCessna 172H · Lynchburg, VANov 14, 1976 · N3252L · 2 aircraft · Substantial damage NTSB SEA77FTI02Accident · No injuriesClosedCessna 172 · Whitefish, MTNov 7, 1976 · N8746B · Substantial damage NTSB LAX77FUG07Accident · No injuriesClosedCessna 172 · Perris, CANov 7, 1976 · N5794A · Substantial damage NTSB OAK77DVD04Accident · No injuriesClosedCessna 172 · Petaluma, CANov 5, 1976 · N4185F · Substantial damage NTSB ANC77DA002Accident · No injuriesClosedCessna 172 · Lower Kalskag, AKOct 18, 1976 · N9123B · Substantial damage NTSB CHI77DEC09Incident · No injuriesClosedCessna 172 · Detroit, MIOct 11, 1976 · N1895Y · Minor damage NTSB OAK77DVG02Accident · No injuriesClosedCessna 172 · Cedarville, CAOct 8, 1976 · N8073X · Substantial damage NTSB SEA77FYG04Accident · Serious injuriesClosedCessna 172 · Grangeville, IDOct 2, 1976 · N1641F · No damage NTSB MIA76DLG54Accident · No injuriesClosedCessna 172 · Landrum, SCSep 26, 1976 · N5895R · Substantial damage NTSB LAX76FUK10Accident · No injuriesClosedCessna 172F · Chandler, AZSep 14, 1976 · N8749U · Substantial damage NTSB MIA76DLG39Accident · No injuriesClosedCessna 172 · Neeses, SCAug 29, 1976 · N6482E · Substantial damage NTSB CHI76FEC57Accident · No injuriesClosedCessna 172 · Flint, MIAug 29, 1976 · N8285U · Substantial damage NTSB FTW76FPH06Accident · No injuriesClosedCessna 172 · Ola, ARAug 27, 1976 · N6800A · Substantial damage NTSB MIA76FKG98Accident · Serious injuriesClosedCessna 172 · Shannon, GAAug 23, 1976 · N8494X · Substantial damage NTSB CHI76FEK27Accident · No injuriesClosedCessna 172G · London, OHAug 20, 1976 · N5786R · Substantial damage NTSB DEN76FQA59Accident · Minor injuriesClosedCessna 172 · Albuquerque, NMAug 7, 1976 · N8031L · Substantial damage NTSB FTW76DPG94Accident · No injuriesClosedCessna 172 · Augusta, ARAug 5, 1976 · N7468A · Substantial damage NTSB FTW76DRG80Accident · No injuriesClosedCessna 172H · Lowake, TXJul 31, 1976 · N3251L · Substantial damage NTSB NYC76FNE27Accident · Serious injuriesClosedGlobe GC-1B · Gardner, MAJul 5, 1976 · N78315 · Destroyed NTSB IAD76FIG19Accident · Minor injuriesClosedCessna 172 · Laurel, MDJun 26, 1976 · N6315E · Substantial damage NTSB CHI76FET39Accident · No injuriesClosedCessna 172 · Gary, INJun 11, 1976 · N3830L · Substantial damage NTSB NYC76FHM29Accident · No injuriesClosedCessna 172H · Mahopac, NYJun 10, 1976 · N2460L · Substantial damage NTSB LAX76DUJ82Accident · No injuriesClosedCessna 170 · Carefree, AZJun 6, 1976 · N3482D · Substantial damage NTSB ANC76AA100Accident · 1 fatalClosedCessna 170 · Talkeetna, AKJun 6, 1976 · N228F · Destroyed NTSB NYC76FFA34Accident · No injuriesClosedCessna 172 · Albany, NYJun 5, 1976 · N7408X · Substantial damage NTSB FTW76DPD43Accident · No injuriesClosedCessna 170 · Weatherford, TXJun 4, 1976 · N9557A · Substantial damage NTSB CHI76FEC43Accident · No injuriesClosedCessna 172H · Flushing, MIMay 27, 1976 · N2673L · Substantial damage NTSB CHI76FEK16Accident · No injuriesClosedCessna 172 · Sidney, OHMay 26, 1976 · N131MT · Substantial damage NTSB CHI76FEM43Accident · No injuriesClosedCessna 172 · Alpena, MIMay 25, 1976 · N8553U · Substantial damage NTSB OAK76AP053Accident · 3 fatalClosedCessna 172H · Hollister, CAMay 16, 1976 · N3744R · Destroyed NTSB LAX76AL075Accident · 1 fatalClosedCessna 172E · Kingman, AZMay 15, 1976 · N3658R · Destroyed NTSB FTW76FPM22Accident · 1 fatalClosedCessna 172F · Jenks, OKMay 14, 1976 · N8656U · No damage NTSB MKC76DER62Accident · No injuriesClosedCessna 172A · Hadley, MNApr 26, 1976 · N7399T · Substantial damage NTSB FTW76FPG47Accident · No injuriesClosedCessna 172 · Brinkley, ARApr 26, 1976 · N8697B · Substantial damage