Skip to content

NTSB investigations: Continental 0-200 series

6,416 cases on aircraft whose registry engine model is Continental 0-200 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 ('17020')) 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 ('17020'))
  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 ('17020'))
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 LAX66D0015Accident · Minor injuriesClosedCessna 150 · Van Nuys, CAJun 30, 1965 · N3982U · Substantial damage NTSB NYC66D0058Accident · No injuriesClosedCessna 150 · Friendly, MDJun 29, 1965 · N6193T · Substantial damage NTSB MKC66F0124Accident · No injuriesClosedCessna 150 · Hatton, NDJun 27, 1965 · N2074Z · Substantial damage NTSB DEN66D0023Accident · No injuriesClosedCessna 150 · Carefree Ariz, AZJun 26, 1965 · N3032J · Substantial damage NTSB FTW66D0115Accident · No injuriesClosedCessna 150 · Merit, TXJun 25, 1965 · N7762E · Substantial damage NTSB FTW66F0111Accident · No injuriesClosedCessna 150 · Pearland, TXJun 22, 1965 · N1985Z · Destroyed NTSB FTW66F0106Accident · Minor injuriesClosedCessna 150C · Gilmer, TXJun 21, 1965 · N2002Z · Substantial damage NTSB UNK65X1504Accident · No injuriesClosedChampion 7FC · Lake Wales, FLJun 20, 1965 · N7582E · Substantial damage NTSB CHI66F0054Accident · No injuriesClosedChampion 7ECA · East Tawas, MIJun 19, 1965 · N11045 · Substantial damage NTSB CHI66D0045Accident · No injuriesClosedCessna 150 · Mansfield, OHJun 17, 1965 · N3556J · Substantial damage NTSB DEN66D0010Accident · No injuriesClosedCessna 182 · Mountain View, WYJun 12, 1965 · N8805S · Substantial damage NTSB LAX66F0028Accident · No injuriesClosedCessna 150 · Torrance, CAJun 10, 1965 · N3507J · Substantial damage NTSB UNK65X1498Accident · No injuriesClosedCessna 150 · Cincinnati, OHJun 9, 1965 · N3014J · Substantial damage NTSB ANC66D0004Accident · No injuriesClosedCessna 150 · Northway, AKJun 9, 1965 · N7101X · Substantial damage NTSB ANC65D0016Accident · No injuriesClosedCessna 150 · Nenana, AKJun 5, 1965 · N7116X · Substantial damage NTSB NYC65F0236Accident · No injuriesClosedCessna 150 · Newburg, PAMay 23, 1965 · N3075J · Destroyed NTSB MKC66F0023Accident · No injuriesClosedCessna 150 · Eureka, KSMay 22, 1965 · N3057J · Substantial damage NTSB LAX66F0034Accident · Minor injuriesClosedCessna 150 · Laverne, CAMay 22, 1965 · N7386X · Substantial damage NTSB FTW66D0073Accident · Minor injuriesClosedCessna 150 · Osceola, ARMay 18, 1965 · N1267Y · Destroyed NTSB MKC66F0072Accident · Minor injuriesClosedCessna 150 · Leawood, KSMay 15, 1965 · N4334U · Destroyed NTSB OAK65F0045Accident · Minor injuriesClosedCessna 150 · Fresno, CAMay 13, 1965 · N3966U · Substantial damage NTSB DEN65D0078Accident · No injuriesClosedCessna 150B · Wheatland, WYMay 10, 1965 · N1134Y · Substantial damage NTSB NYC66F0038Accident · No injuriesClosedCessna 150 · Tewksbury, MAMay 8, 1965 · N3963U · Substantial damage NTSB CHI65D0158Accident · Minor injuriesClosedCessna 182 · Fostoria, OHMay 8, 1965 · N3835D · Substantial damage NTSB DEN66F0008Accident · Serious injuriesClosedCessna 150 · Montrose, COMay 6, 1965 · N4148U · Substantial damage NTSB FTW66F0034Accident · Minor injuriesClosedCessna 150 · Norman, OKMay 4, 1965 · N7989Z · Substantial damage NTSB MKC66F0007Accident · Minor injuriesClosedCessna 150 · Pine Bend, MNApr 30, 1965 · N4142U · Destroyed NTSB LAX65F0056Accident · No injuriesClosedCessna 150 · Compton, CAApr 29, 1965 · N4226U · Substantial damage NTSB MIA65F0058Accident · No injuriesClosedCessna 150 · Crystal Sprgs, FLApr 26, 1965 · N5676E · Destroyed NTSB CHI65F0133Accident · No injuriesClosedChampion 7ECA · Flushing, MIApr 26, 1965 · N11083 · Substantial damage NTSB MIA66F0032Accident · 1 fatalClosedChampion 7ECA-3 · Melbourne, FLApr 21, 1965 · N11020 · Substantial damage NTSB OAK65D0046Accident · No injuriesClosedCessna 150 · Palo Alto, CAApr 19, 1965 · N6185T · Substantial damage NTSB NYC66F0008Accident · No injuriesClosedCessna 150 · Huntington, WVApr 17, 1965 · N3031J · Substantial damage NTSB NYC65F0176Accident · No injuriesClosedCessna 150 · Williamsburg, VAApr 16, 1965 · N1166Y · Substantial damage NTSB DEN65F0063Accident · Minor injuriesClosedCessna 150 · Phoenix, AZApr 14, 1965 · N4544U · Destroyed NTSB MIA65F0051Accident · No injuriesClosedCessna 150 · Ft Lauderdale, FLApr 13, 1965 · N2554J · Substantial damage NTSB MKC66F0003Accident · Minor injuriesClosedCessna 150 · Columbia, MOApr 12, 1965 · N6006T · Substantial damage NTSB MKC65F0145Accident · No injuriesClosedCessna 150 · Hopkins, MNApr 7, 1965 · N5529E · Substantial damage NTSB MKC65D0072Accident · No injuriesClosedCessna 150A · Audubon, IAApr 6, 1965 · N6654T · Substantial damage NTSB NYC65F0240Accident · No injuriesClosedCessna 150B · Marlton, NJApr 4, 1965 · N1284Y · Substantial damage NTSB MIA65F0012Accident · No injuriesClosedCessna 150E · Griffin, GAApr 4, 1965 · N3080J · Substantial damage NTSB MKC65F0094Accident · No injuriesClosedCessna 150D · Kenosha, WIApr 2, 1965 · N6020T · Substantial damage NTSB MIA65D0022Accident · No injuriesClosedCessna 150 · Ft Brasinger, FLMar 27, 1965 · N1935Z · Substantial damage NTSB LAX65D0082Accident · No injuriesClosedCessna 150 · Long Beach, CAMar 25, 1965 · N3935U · Substantial damage NTSB CHI65D0132Accident · No injuriesClosedChampion 7ECA · Wheeling, ILMar 21, 1965 · N11039 · Substantial damage NTSB NYC65F0093Accident · No injuriesClosedCessna 150 · Ware, MAMar 16, 1965 · N4209U · Substantial damage NTSB NYC65F0080Accident · No injuriesClosedCessna 150 · Hanover, NJMar 13, 1965 · N3511J · Substantial damage NTSB CHI65D0045Accident · No injuriesClosedCessna 150 · Arrollton, KYMar 12, 1965 · N5738E · Substantial damage NTSB MKC65D0071Accident · No injuriesClosedCessna 150 · Holcomb, MOMar 11, 1965 · N4271U · Substantial damage NTSB CHI65D0079Accident · No injuriesClosedCessna 150 · Lansing, MIMar 7, 1965 · N2525J · Substantial damage