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 UNK64X2009Accident · No injuriesClosedCessna 172D · Koehn Dry Lke, CAMay 29, 1964 · N2331U · Substantial damage NTSB UNK64X1954Accident · No injuriesClosedCessna 172D · St James, MNMay 25, 1964 · N2447U · Substantial damage NTSB UNK64X1941Accident · No injuriesClosedCessna 172 · Edgartown, MAMay 24, 1964 · N2484U · Substantial damage NTSB UNK64X1940Accident · No injuriesClosedCessna 170A · Rosehill, KSMay 24, 1964 · N9055A · Substantial damage NTSB UNK64X1936Accident · No injuriesClosedCessna 172E · Wheeling, ILMay 24, 1964 · N3742S · Substantial damage NTSB UNK64X1923Accident · No injuriesClosedCessna 172D · Pratt, KSMay 23, 1964 · N2420U · Substantial damage NTSB UNK64X1918Accident · No injuriesClosedCessna 175 · Brunswick, GAMay 23, 1964 · N8341T · Substantial damage NTSB UNK64X1914Accident · No injuriesClosedCessna 172 · Eagles Mere, PAMay 23, 1964 · N5424T · Substantial damage NTSB UNK64X1879Accident · No injuriesClosedCessna 172 · Alachua, FLMay 22, 1964 · N4245F · Substantial damage NTSB UNK64X1860Accident · No injuriesClosedCessna 172 · Clovis, NMMay 20, 1964 · N6657A · Substantial damage NTSB UNK64X1817Accident · No injuriesClosedCessna 172 · Gramercy, LAMay 18, 1964 · N8362X · Substantial damage NTSB UNK64X1805Accident · No injuriesClosedCessna 170B · Tompkinsville, KYMay 17, 1964 · N4308B · Substantial damage NTSB UNK64X1804Accident · No injuriesClosedCessna 172D · Livingston, MTMay 17, 1964 · N2800U · Substantial damage NTSB UNK64X1763Accident · No injuriesClosedCessna 172 · Mt Vernon, INMay 14, 1964 · N5328T · Substantial damage NTSB UNK64X1702Accident · No injuriesClosedCessna 172 · Pe Ell, WAMay 10, 1964 · N8724B · Substantial damage NTSB UNK64X1652Accident · No injuriesClosedCessna 172 · Arco, IDMay 7, 1964 · N7564X · Substantial damage NTSB UNK64X1650Accident · No injuriesClosedCessna 172 · Helena, MTMay 7, 1964 · N7856X · Substantial damage NTSB UNK64X1643Accident · No injuriesClosedCessna 172A · Garden City, KSMay 7, 1964 · N7452T · Substantial damage NTSB UNK64X1639Accident · No injuriesClosedCessna 172 · Muskegon, MIMay 6, 1964 · N2890U · Substantial damage NTSB UNK64X1630Accident · No injuriesClosedCessna 172C · Niobrara, NEMay 5, 1964 · N1841Y · Substantial damage NTSB UNK64X1610Accident · No injuriesClosedCessna 172 · Ambler, PAMay 4, 1964 · N3057U · Substantial damage NTSB UNK64X1538Accident · No injuriesClosedCessna 172 · Belle Glade, FLApr 30, 1964 · N7446X · Substantial damage NTSB UNK64X1528Accident · No injuriesClosedCessna 172 · Harrisonville, MOApr 30, 1964 · N8455X · Substantial damage NTSB UNK64X1507Accident · No injuriesClosedCessna 172 · Picayune, MSApr 29, 1964 · N3980S · Substantial damage NTSB UNK64X1453Accident · No injuriesClosedCessna 172 · Circle Pines, MNApr 25, 1964 · N9146B · Substantial damage NTSB UNK64X1419Accident · Minor injuriesClosedCessna 172E · Lancaster, OHApr 23, 1964 · N3702S · Substantial damage NTSB UNK64X1401Accident · No injuriesClosedCessna 172 · Strongsville, OHApr 21, 1964 · N2419Y · Substantial damage NTSB UNK64X1363Accident · No injuriesClosedPiper PA23 · Santa Ana, CAApr 18, 1964 · N1317P · 2 aircraft · No damage NTSB UNK64X1357Accident · Minor injuriesClosedCessna 172 · Munday, TXApr 18, 1964 · N8280B · Destroyed NTSB UNK64X1352Accident · No injuriesClosedCessna 172 · Woodstock, CTApr 17, 1964 · N7660X · Substantial damage NTSB UNK64X1351Accident · No injuriesClosedCessna 172 · Bronte, TXApr 17, 1964 · N1534Y · Substantial damage NTSB UNK64X1323Accident · No injuriesClosedCessna 172 · Quitaque, TXApr 15, 1964 · N6479E · Substantial damage NTSB UNK64X1259Accident · Minor injuriesClosedCessna 172 · Cairo, NYApr 11, 1964 · N2414U · Substantial damage NTSB UNK64X1167Accident · No injuriesClosedCessna 172 · Russell Spgs, KYApr 4, 1964 · N8198X · Substantial damage NTSB UNK64X1102Accident · Serious injuriesClosedCessna 172 · Wilmington, OHMar 29, 1964 · N7488X · Destroyed NTSB UNK64X1093Accident · No injuriesClosedCessna 172 · Honesdale, PAMar 29, 1964 · N9884T · Substantial damage NTSB UNK64X1088Accident · No injuriesClosedCessna 172D · Wellington, KSMar 29, 1964 · N3835S · Substantial damage NTSB UNK64X1072Accident · No injuriesClosedCessna 172 · Elizabethville, PAMar 28, 1964 · N8750B · Substantial damage NTSB UNK64X1071Accident · No injuriesClosedCessna 172 · Crossville, TNMar 28, 1964 · N3942S · Substantial damage NTSB UNK64X1036Accident · No injuriesClosedCessna 172B · Winona, MNMar 25, 1964 · N7621T · Substantial damage NTSB UNK64X1024Accident · No injuriesClosedCessna 172 · Boulder City, NVMar 23, 1964 · N8118B · Substantial damage NTSB UNK64X1011Accident · No injuriesClosedCessna 172 · Lawrence, KSMar 21, 1964 · N3788S · Substantial damage NTSB UNK64X1004Accident · No injuriesClosedCessna 172B · Gallup, NMMar 21, 1964 · N7668X · Substantial damage NTSB UNK64X1000Accident · No injuriesClosedCessna 170B · Beckworth, CAMar 21, 1964 · N2932D · Substantial damage NTSB UNK64X0997Accident · Minor injuriesClosedCessna 172D · El Rosario, MexicoMar 21, 1964 · N2757U · Substantial damage NTSB UNK64X0957Accident · No injuriesClosedCessna 172S · Los Angeles, CAMar 16, 1964 · N3758S · Substantial damage NTSB UNK64X0952Accident · Minor injuriesClosedCessna 172 · Lima, OHMar 16, 1964 · N8478X · Destroyed NTSB UNK64X0949Accident · No injuriesClosedCessna 172 · Moorehead, KYMar 16, 1964 · N8342B · Destroyed NTSB UNK64X0939Accident · No injuriesClosedCessna 170B · Palo Alto, CAMar 15, 1964 · N3484C · Destroyed NTSB UNK64X0938Accident · No injuriesClosedCessna 172 · Murrieta, CAMar 15, 1964 · N7149T · Substantial damage