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 FTW66D0065Accident · No injuriesClosedCessna 172 · Baton Rouge, LAJun 10, 1965 · N7902U · Substantial damage NTSB MIA66D0038Accident · No injuriesClosedCessna 172E · Bamberg, SCJun 6, 1965 · N3650S · Substantial damage NTSB FTW66F0046Accident · No injuriesClosedPiper PA-22 · Okmulgee, OKJun 6, 1965 · N56892 · 2 aircraft · Substantial damage NTSB ANC66F0009Accident · Minor injuriesClosedMaule M-4 · Valdez, AKJun 4, 1965 · N4721T · Substantial damage NTSB LAX66D0006Accident · No injuriesClosedCessna 172 · Lancaster, CAMay 31, 1965 · N7900U · Substantial damage NTSB LAX66D0043Accident · No injuriesClosedCessna 172 · Apple Valley, CAMay 30, 1965 · N7781U · Substantial damage NTSB DEN65F0097Accident · Minor injuriesClosedCessna 172 · Sundance, WYMay 30, 1965 · N4077F · Substantial damage NTSB CHI66F0025Accident · No injuriesClosedCessna 172C · Ft Wayne, INMay 30, 1965 · N8442X · Substantial damage NTSB DEN65F0111Accident · No injuriesClosedCessna 172 · Albuquerque, NMMay 29, 1965 · N6668A · Substantial damage NTSB CHI66F0019Accident · No injuriesClosedCessna 172 · Georgetown, KYMay 29, 1965 · N3921S · Destroyed NTSB LAX66F0012Accident · No injuriesClosedCessna 172 · Montello, NVMay 25, 1965 · N3616S · Substantial damage NTSB NYC66D0018Accident · No injuriesClosedCessna 172 · Hillsboro, WVMay 24, 1965 · N8774B · Substantial damage NTSB SEA65D0066Accident · No injuriesClosedCessna 172 · Yakima, WAMay 23, 1965 · N2134Y · Substantial damage NTSB DEN65D0104Accident · No injuriesClosedCessna 172 · Cedar City, UTMay 22, 1965 · N3778S · Substantial damage NTSB CHI65D0167Accident · No injuriesClosedCessna 172 · Lafayette, INMay 19, 1965 · N7475A · Substantial damage NTSB MIA65F0105Accident · Minor injuriesClosedCessna 172 · Mcbee, SCMay 16, 1965 · N8288B · Substantial damage NTSB CHI65F0148Accident · No injuriesClosedCessna 172 · Ionia, MIMay 14, 1965 · N7897T · Substantial damage NTSB DEN65D0084Accident · No injuriesClosedCessna 172D · Tucson, AZMay 9, 1965 · N2533U · Substantial damage NTSB FTW66F0036Accident · Minor injuriesClosedCessna 172 · Poth, TXMay 8, 1965 · N7724X · Substantial damage NTSB SEA66D0041Accident · No injuriesClosedCessna 172 · Knobs, MTMay 6, 1965 · N7082T · Substantial damage NTSB NYC65F0145Accident · Minor injuriesClosedCessna 172 · Westboro, MAMay 4, 1965 · N1497Y · Substantial damage NTSB MIA65D0093Accident · No injuriesClosedCessna 172 · Vieques Is, PRMay 4, 1965 · N5408T · Substantial damage NTSB MKC65F0110Accident · No injuriesClosedCessna 172 · Sioux Falls, SDMay 2, 1965 · N3898S · Substantial damage NTSB DEN65D0072Accident · No injuriesClosedCessna 170 · La Sal, UTMay 2, 1965 · N2936D · Substantial damage NTSB NYC66D0063Accident · No injuriesClosedCessna 172 · Montgomery, NYMay 1, 1965 · N7497X · Substantial damage NTSB FTW65F0038Accident · No injuriesClosedCessna 172 · Alvin, TXApr 25, 1965 · N7959B · Substantial damage NTSB FTW65F0037Accident · No injuriesClosedCessna 170 · Corpus Christi, TXApr 25, 1965 · N5567C · Substantial damage NTSB MKC65D0100Accident · No injuriesClosedCessna 172 · Ogallala, NEApr 21, 1965 · N5828A · Substantial damage NTSB FTW65F0052Accident · Minor injuriesClosedCessna 172 · Smithfield, TXApr 21, 1965 · N5382T · Substantial damage NTSB OAK65D0040Accident · No injuriesClosedCessna 170B · Merced, CAApr 20, 1965 · N4538C · Substantial damage NTSB NYC65F0131Accident · No injuriesClosedCessna 172A · Westminster, MDApr 12, 1965 · N9787T · Substantial damage NTSB MKC66F0058Accident · Minor injuriesClosedCessna 172 · Murray, IAApr 11, 1965 · N5749A · Substantial damage NTSB MKC65F0109Accident · No injuriesClosedCessna 172 · Hutchinson, KSApr 11, 1965 · N7712X · Substantial damage NTSB MIA65F0057Accident · No injuriesClosedCessna 172E · St Cloud, FLApr 11, 1965 · N7753U · Substantial damage NTSB UNK65X1483Accident · No injuriesClosedCessna 172 · Andros Is, Burkina FasoApr 10, 1965 · N8779B · Substantial damage NTSB NYC65D0175Accident · No injuriesClosedCessna 172 · Blackwood, NJApr 10, 1965 · N6049A · Substantial damage NTSB CHI65D0077Accident · No injuriesClosedCessna 172 · Cleveland, OHApr 9, 1965 · N7861U · Destroyed NTSB MIA65D0049Accident · No injuriesClosedCessna 172 · Anderson, SCApr 8, 1965 · N3744S · Substantial damage NTSB MIA66F0012Accident · No injuriesClosedCessna 172 · Tampa, FLApr 7, 1965 · N2372U · Substantial damage NTSB OAK65F0053Accident · No injuriesClosedCessna 172 · San Jose, CAApr 4, 1965 · N7337A · Substantial damage NTSB MIA65F0039Accident · No injuriesClosedCessna 172 · Charleston, MSApr 4, 1965 · N2535Y · Substantial damage NTSB CHI65F0063Accident · No injuriesClosedCessna 172 · Lebanon, OHApr 3, 1965 · N5628T · Substantial damage NTSB CHI65F0108Accident · No injuriesClosedCessna 172 · South Haven, MIMar 31, 1965 · N8934B · Destroyed NTSB NYC65D0119Accident · No injuriesClosedCessna 172 · Middletown, NYMar 28, 1965 · N7402A · Substantial damage NTSB UNK65X1480Accident · No injuriesClosedCessna 172 · Andros Is, Burkina FasoMar 27, 1965 · N2056Y · Substantial damage NTSB NYC65F0125Accident · No injuriesClosedCessna 172F · Ambler, PAMar 27, 1965 · N8432U · Substantial damage NTSB FTW66F0206Accident · No injuriesClosedCessna 172 · San Antonio, TXMar 26, 1965 · N7795T · Substantial damage NTSB CHI65F0109Accident · Serious injuriesClosedCessna 172D · Battle Creek, MIMar 25, 1965 · N2349U · Substantial damage NTSB NYC65D0108Accident · No injuriesClosedCessna 172 · Potsdam, NYMar 22, 1965 · N8429U · Substantial damage NTSB NYC65D0120Accident · No injuriesClosedCessna 172 · Woodstock, NYMar 20, 1965 · N6141E · Substantial damage