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 LAX67D0271Accident · No injuriesClosedCessna 172 · Agua Dulce, CAJan 15, 1967 · N5609R · Substantial damage NTSB CHI67D0506Accident · No injuriesClosedCessna 172 · Port Clinton, OHJan 12, 1967 · N2144Y · Substantial damage NTSB NYC67F0419Accident · No injuriesClosedCessna 172E · Lakeville, PAJan 8, 1967 · N3790S · Substantial damage NTSB MIA67D0359Accident · Minor injuriesClosedCessna 172 · Sanford, FLJan 7, 1967 · N2611U · Substantial damage NTSB FTW67F0366Accident · No injuriesClosedCessna 172 · Dallas, TXJan 6, 1967 · N8627U · Substantial damage NTSB NYC67F0426Accident · No injuriesClosedCessna 172 · Readington, NJJan 2, 1967 · N441TS · Substantial damage NTSB NYC67D0465Accident · No injuriesClosedCessna 172 · Middletown, NYJan 2, 1967 · N5506T · Substantial damage NTSB FTW67D0400Accident · No injuriesClosedCessna 172 · Lawton, OKJan 2, 1967 · N3693S · Substantial damage NTSB CHI67D0451Accident · No injuriesClosedCessna 172 · Chagrin Fall, OHDec 31, 1966 · N3880R · Substantial damage NTSB NYC67D0494Accident · No injuriesClosedCessna 172 · Moorestown, NJDec 30, 1966 · N5563T · Substantial damage NTSB DIA67F0016Accident · No injuriesClosedCessna 172 · Richmond, VADec 30, 1966 · N8556U · Substantial damage NTSB MIA67D0367Accident · No injuriesClosedCessna 172 · Duncan Town, Burkina FasoDec 29, 1966 · N1352Y · Substantial damage NTSB FTW67D0378Accident · No injuriesClosedCessna 170B · Texarkana, ARDec 29, 1966 · N8009A · Substantial damage NTSB DIA67D0004Accident · No injuriesClosedCessna 172 · Long Beach, NCDec 26, 1966 · N8062B · Substantial damage NTSB CHI67D0417Accident · No injuriesClosedCessna 172 · Bloomingdale, INDec 26, 1966 · N2558U · Substantial damage NTSB FTW67D0394Accident · No injuriesClosedCessna 172G · Florien, LADec 24, 1966 · N4477L · Substantial damage NTSB FTW67F0347Accident · Minor injuriesClosedCessna 172G · Pearland, TXDec 19, 1966 · N3728L · Substantial damage NTSB CHI67A0081Accident · 4 fatalClosedCessna 172 · Ashtabula, OHDec 19, 1966 · N2347U · Destroyed NTSB LAX67D0248Accident · No injuriesClosedCessna 172 · Shafter, CADec 15, 1966 · N6228E · Substantial damage NTSB OAK67F0203Accident · No injuriesClosedCessna 175 · Fair Oaks, CADec 14, 1966 · N8170T · Substantial damage NTSB FTW67D0357Accident · No injuriesClosedCessna 172 · Odessa, TXDec 12, 1966 · N1459F · Substantial damage NTSB FTW67A0062Accident · 2 fatalClosedCessna 172 · Franklin, ARDec 6, 1966 · N1131F · Destroyed NTSB CHI67D0412Accident · No injuriesClosedCessna 172G · Mt.Carroll, ILDec 6, 1966 · N6088R · Substantial damage NTSB ANC67D0078Accident · No injuriesClosedCessna 170B · Cordova, AKDec 5, 1966 · N3444D · Substantial damage NTSB SEA67D0199Accident · No injuriesClosedCessna 172 · Dubois, IDDec 4, 1966 · N1691F · Substantial damage NTSB MIA67D0324Accident · Minor injuriesClosedCessna 172 · Lakeland, GADec 3, 1966 · N7752X · Substantial damage NTSB CHI67F0403Accident · No injuriesClosedCessna 172 · Boyne Falls, MIDec 2, 1966 · N6041R · Substantial damage NTSB MKC67D0314Accident · No injuriesClosedCessna 172 · Rapid City, SDNov 29, 1966 · N7004A · Substantial damage NTSB FTW67D0305Accident · No injuriesClosedCessna 172 · Jenks, OKNov 23, 1966 · N1422F · Substantial damage NTSB NYC67F0378Accident · No injuriesClosedMaule M4 · Mt Pleasant, PANov 20, 1966 · N4724T · Substantial damage NTSB FTW67D0319Accident · No injuriesClosedCessna 172 · Norman, OKNov 20, 1966 · N5950R · Substantial damage NTSB MIA67D0331Accident · No injuriesClosedCessna 172 · Venice, FLNov 19, 1966 · N1761F · Substantial damage NTSB LAX67D0211Accident · No injuriesClosedCessna 172 · Burbank, CANov 18, 1966 · N7460T · Substantial damage NTSB MKC67F0313Accident · No injuriesClosedCessna 172H · Fargo, NDNov 17, 1966 · N1633F · Substantial damage NTSB LAX67F0197Accident · No injuriesClosedCessna 172H · Santa Monica, CANov 12, 1966 · N1419F · Substantial damage NTSB FTW67F0267Accident · Minor injuriesClosedCessna 172 · Fort Worth, TXNov 11, 1966 · N2320U · Substantial damage NTSB LAX67D0223Accident · Minor injuriesClosedCessna 172 · Crestline, CANov 6, 1966 · N2775U · Substantial damage NTSB DEN67D0183Accident · No injuriesClosedCessna 172 · Aurora, CONov 5, 1966 · N3147X · Substantial damage NTSB MIA67D0311Accident · No injuriesClosedCessna 172 · Ft-Bassinger, FLNov 4, 1966 · N3582S · Substantial damage NTSB OAK67D0163Accident · No injuriesClosedCessna 172 · Wendover, NVNov 3, 1966 · N8613B · Substantial damage NTSB MKC67A0033Accident · 1 fatalClosedCessna 172G · Venango, NENov 3, 1966 · N3646L · Destroyed NTSB MKC67D0329Accident · No injuriesClosedCessna 172 · Topeka, KSOct 29, 1966 · N5947A · Substantial damage NTSB FTW67D0298Accident · No injuriesClosedCessna 172 · Tahoka, TXOct 29, 1966 · N6191E · Substantial damage NTSB NYC67D0336Accident · No injuriesClosedCessna 172 · Charleston, WVOct 20, 1966 · N6272E · Substantial damage NTSB CHI67D0636Accident · No injuriesClosedCessna 172 · Pittsfield, ILOct 20, 1966 · N3891L · Substantial damage NTSB MIA67F0314Accident · No injuriesClosedGlobe GC-1B · Crestview, FLOct 19, 1966 · N3283K · Substantial damage NTSB MIA67D0282Accident · No injuriesClosedCessna 172 · Jasper, ALOct 19, 1966 · N5372R · Substantial damage NTSB SEA67D0165Accident · No injuriesClosedCessna 172 · Chinook, MTOct 16, 1966 · N7327T · Substantial damage NTSB DEN67F0169Accident · No injuriesClosedCessna 172 · Panguitch, UTOct 14, 1966 · N3659L · Substantial damage NTSB LAX67D0168Accident · No injuriesClosedCessna 172G · Winslow, AZOct 13, 1966 · N5917R · Substantial damage