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 DEN67D0130Accident · No injuriesClosedCessna 172 · Denver, COOct 13, 1966 · N3905L · Substantial damage NTSB SEA67D0210Accident · No injuriesClosedCessna 172 · Seattle, WAOct 9, 1966 · N8533B · Substantial damage NTSB NYC67D0335Accident · No injuriesClosedCessna 172 · Flushing, NYOct 9, 1966 · N2549Y · Substantial damage NTSB MKC67D0275Accident · No injuriesClosedCessna 172 · Anita, IAOct 9, 1966 · N8799B · Substantial damage NTSB LAX67D0164Accident · No injuriesClosedCessna 172 · Grand Canyon, AZOct 8, 1966 · N1752F · Substantial damage NTSB CHI67D0286Accident · No injuriesClosedCessna 172 · Waukesha, WIOct 4, 1966 · N3896L · Substantial damage NTSB OAK67D0109Accident · No injuriesClosedCessna 172 · Livermore, CAOct 2, 1966 · N5953A · Substantial damage NTSB LAX67D0155Accident · Minor injuriesClosedCessna 172 · Sonoita, AZOct 2, 1966 · N5932R · Destroyed NTSB DEN67D0109Accident · No injuriesClosedCessna 172 · Vernon, UTOct 2, 1966 · N6188E · Substantial damage NTSB CAN66F0421Accident · No injuriesClosedCessna 170B · Tabusintac Rv., CanadaOct 2, 1966 · N3133A · Substantial damage NTSB MKC67F0243Accident · No injuriesClosedCessna 172 · So.St.Paul, MNSep 26, 1966 · N8746B · Substantial damage NTSB NYC67F0262Accident · No injuriesClosedCessna 172D · Leesburg, VASep 24, 1966 · N2486Y · Substantial damage NTSB FTW67D0237Accident · No injuriesClosedCessna 172 · Berryville, ARSep 24, 1966 · N6942X · Substantial damage NTSB MIA67F0212Accident · No injuriesClosedCessna 172E · Tampa, FLSep 20, 1966 · N3685S · Substantial damage NTSB SEA67D0149Accident · No injuriesClosedCessna 172 · Puyallup, WASep 19, 1966 · N5757R · Substantial damage NTSB OAK67F0138Accident · No injuriesClosedCessna 172 · Marysville, CASep 19, 1966 · N7247T · Substantial damage NTSB FTW67D0204Accident · No injuriesClosedCessna 172 · Boyce, LASep 18, 1966 · N8233U · Substantial damage NTSB OAK67D0169Accident · No injuriesClosedCessna 172 · San Carlos, CASep 16, 1966 · N4305L · Substantial damage NTSB DEN67F0104Accident · Minor injuriesClosedCessna 172B · Larkspur, COSep 15, 1966 · N7403X · Substantial damage NTSB MKC67D0230Accident · Minor injuriesClosedCessna 172 · Caldwell, KSSep 14, 1966 · N4392L · Substantial damage NTSB SEA67D0155Accident · No injuriesClosedCessna 172 · Snohomish, WASep 13, 1966 · N5789R · Substantial damage NTSB DEN67F0112Accident · Minor injuriesClosedCessna 172 · Laramie, WYSep 11, 1966 · N7382T · Substantial damage NTSB CHI67D0186Accident · No injuriesClosedCessna 172 · Greenville, OHSep 11, 1966 · N5935R · Substantial damage NTSB CHI67D0312Accident · Serious injuriesClosedCessna 172 · Frankfort, ILSep 10, 1966 · N7279A · No damage NTSB MIA67F0138Accident · No injuriesClosedCessna 172 · Spartanburg, SCSep 4, 1966 · N8070X · Substantial damage NTSB DEN67F0081Accident · No injuriesClosedCessna 172 · Roswell, NMSep 3, 1966 · N4398L · Substantial damage NTSB CHI67A0035Accident · 1 fatalClosedCessna 172 · Detroit, MISep 3, 1966 · N6725A · Destroyed NTSB MIA67D0178Accident · No injuriesClosedCessna 172 · Lithonia, GASep 2, 1966 · N5588R · Substantial damage NTSB FTW67F0195Accident · No injuriesClosedCessna 172F · Lubbock, TXSep 2, 1966 · N7832U · Substantial damage NTSB MIA67D0281Accident · No injuriesClosedCessna 172 · Hazel Green, ALSep 1, 1966 · N5748R · Substantial damage NTSB DEN67D0118Accident · No injuriesClosedCessna 170B · Midvale, UTSep 1, 1966 · N2970D · Substantial damage NTSB NYC67D0243Accident · No injuriesClosedCessna 172 · Sunset, MEAug 31, 1966 · N4213L · Substantial damage NTSB DEN67F0092Accident · No injuriesClosedCessna 172 · Littleton, COAug 30, 1966 · N4624L · Substantial damage NTSB MKC67A0018Accident · 1 fatalClosedCessna 172E · Knox City, MOAug 28, 1966 · N3915S · Destroyed NTSB CHI67D0196Accident · No injuriesClosedCessna 172 · Vestaburg, MIAug 26, 1966 · N8487U · Substantial damage NTSB NYC67F0247Accident · No injuriesClosedCessna 172B · Annville, PAAug 25, 1966 · N8094X · Substantial damage NTSB CHI67D0184Accident · No injuriesClosedCessna 172 · Milwaukee, WIAug 25, 1966 · N6428E · Substantial damage NTSB SEA67F0163Accident · No injuriesClosedGlobe GC-1B · Vancouver, WAAug 21, 1966 · N80649 · Substantial damage NTSB MKC67D0239Accident · No injuriesClosedCessna 172 · Mexico City, MexicoAug 20, 1966 · N4383L · Substantial damage NTSB NYC67F0239Accident · No injuriesClosedCessna 172 · Neptune, NJAug 18, 1966 · N5414T · Substantial damage NTSB CHI67F0284Accident · No injuriesClosedCessna 172C · Canton, OHAug 18, 1966 · N1881Y · Substantial damage NTSB FTW67D0160Accident · Minor injuriesClosedCessna 170B · Waco, TXAug 17, 1966 · N4382B · Substantial damage NTSB FTW67D0175Accident · No injuriesClosedCessna 172 · Apache, OKAug 11, 1966 · N1613Y · Substantial damage NTSB CHI67D0137Accident · No injuriesClosedCessna 172 · Muncie, INAug 6, 1966 · N2558U · Substantial damage NTSB LAX67D0068Accident · No injuriesClosedCessna 172F · Oceanside, CAAug 5, 1966 · N8846U · Substantial damage NTSB MKC67F0128Accident · No injuriesClosedCessna 172 · Gilby, NDJul 31, 1966 · N4124F · Substantial damage NTSB MKC67F0125Accident · No injuriesClosedCessna 172 · Rock Lake, NDJul 31, 1966 · N7423A · Substantial damage NTSB MIA67D0086Accident · No injuriesClosedCessna 172 · Tiptonville, TNJul 30, 1966 · N3794L · Substantial damage NTSB LAX67D0082Accident · Minor injuriesClosedCessna 172 · Santa Ynez, CAJul 30, 1966 · N3946S · Substantial damage NTSB MIA67D0117Accident · No injuriesClosedCessna 172 · Nashville, GAJul 29, 1966 · N3971L · Substantial damage