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 MKC66F0446Accident · No injuriesClosedCessna 172B · St.Louis, MOMar 19, 1966 · N8080X · Substantial damage NTSB MKC66D0530Accident · No injuriesClosedCessna 172 · Poplar Bluff, MOMar 16, 1966 · N1647Y · Substantial damage NTSB MIA66D0496Accident · No injuriesClosedCessna 172 · Morristown, TNMar 13, 1966 · N7883U · Substantial damage NTSB FTW66D0528Accident · No injuriesClosedCessna 172 · Franklin, LAMar 12, 1966 · N5757A · Substantial damage NTSB MIA66D0456Accident · No injuriesClosedCessna 172 · Villa Rica, GAMar 9, 1966 · N8595U · Substantial damage NTSB MKC66F0486Accident · No injuriesClosedCessna 172 · Dexter, MNMar 8, 1966 · N5100A · Substantial damage NTSB MKC66D0445Accident · No injuriesClosedCessna 172 · Macon, MOMar 6, 1966 · N2975U · Substantial damage NTSB MIA66F0509Accident · Minor injuriesClosedCessna 172 · Athens, GAMar 4, 1966 · N2586U · Substantial damage NTSB NYC66A0097Accident · No injuriesClosedCessna 172C · East Boston, MAMar 2, 1966 · N1486Y · Substantial damage NTSB NYC66F0499Accident · No injuriesClosedCessna 172 · West Mifflin, PAMar 1, 1966 · N5439R · Substantial damage NTSB NYC66D0523Accident · No injuriesClosedCessna 172 · Poughkeepsie, NYMar 1, 1966 · N2601U · Substantial damage NTSB MKC66D0513Accident · No injuriesClosedCessna 172 · Wichita, KSMar 1, 1966 · N9869T · Substantial damage NTSB FTW66F0550Accident · No injuriesClosedCessna 172 · Amarillo, TXMar 1, 1966 · N8136U · Substantial damage NTSB DEN66F0231Accident · No injuriesClosedCessna 172B · Gunlock, UTFeb 28, 1966 · N6849X · Substantial damage NTSB DEN66D0238Accident · No injuriesClosedCessna 172 · Zuni, NMFeb 26, 1966 · N3789L · Substantial damage NTSB OAK66D0199Accident · No injuriesClosedCessna 172 · Fremont, CAFeb 22, 1966 · N9896T · Substantial damage NTSB LAX66F0252Accident · No injuriesClosedCessna 172 · Bakersfield, CAFeb 22, 1966 · N5720T · Substantial damage NTSB MKC66D0425Accident · No injuriesClosedCessna 172 · Springfield, MOFeb 19, 1966 · N2852U · Substantial damage NTSB MKC66F0495Accident · No injuriesClosedCessna 172 · S. St Paul, MNFeb 16, 1966 · N7824U · Substantial damage NTSB FTW66F0514Accident · No injuriesClosedCessna 172C · Houston, TXFeb 11, 1966 · N8416X · Substantial damage NTSB NYC66D0502Accident · No injuriesClosedCessna 172A · Hampton, VAFeb 10, 1966 · N7585T · Substantial damage NTSB CHI66D0562Accident · No injuriesClosedCessna 172 · Mt Vernon, OHFeb 9, 1966 · N5660R · Substantial damage NTSB DEN66D0313Accident · No injuriesClosedCessna 172 · San Simon, AZFeb 8, 1966 · N5942A · Substantial damage NTSB OAK66D0210Accident · No injuriesClosedCessna 172 · Sacramento, CAFeb 7, 1966 · N5571R · Substantial damage NTSB NYC66D0532Accident · No injuriesClosedCessna 172 · Warwick, NYFeb 6, 1966 · N8508B · Substantial damage NTSB SEA66D0219Accident · No injuriesClosedCessna 170B · Center Islnd, WAFeb 5, 1966 · N3495C · Substantial damage NTSB MIA66F0416Accident · Minor injuriesClosedCessna 172 · San Juan, PRFeb 5, 1966 · N8523U · Substantial damage NTSB LAX66F0247Accident · Minor injuriesClosedCessna 172 · Chiriaco Sut, CAFeb 2, 1966 · N5660T · Substantial damage NTSB LAX66F0225Accident · Minor injuriesClosedCessna 172 · Apple Valley, CAJan 31, 1966 · N8480X · Destroyed NTSB DEN66D0241Accident · No injuriesClosedCessna 172 · Nunn, COJan 30, 1966 · N6221E · Substantial damage NTSB CHI66D0566Accident · No injuriesClosedCessna 172 · Chicago, ILJan 27, 1966 · N2112Y · Substantial damage NTSB SEA66F0204Accident · No injuriesClosedMaule M-4 · Beaverton, ORJan 25, 1966 · N12016 · Substantial damage NTSB CHI66D0539Accident · No injuriesClosedCessna 172 · Wellington, OHJan 25, 1966 · N7759T · Substantial damage NTSB NYC66D0439Accident · No injuriesClosedCessna 172 · Jamaica, NYJan 24, 1966 · N8052X · Substantial damage NTSB LAX66F0320Accident · No injuriesClosedCessna 172 · Las Vegas, NVJan 18, 1966 · N5773A · Substantial damage NTSB LAX66D0215Accident · No injuriesClosedCessna 172E · Van Nuys, CAJan 16, 1966 · N5661T · Substantial damage NTSB FTW66F0474Accident · No injuriesClosedCessna 172 · Baton Rouge, LAJan 16, 1966 · N8260X · Substantial damage NTSB FTW66D0436Accident · No injuriesClosedCessna 172D · Dallas, TXJan 16, 1966 · N2497Y · Substantial damage NTSB CHI66F0513Accident · Minor injuriesClosedCessna 172 · Greenville, MIJan 16, 1966 · N7053A · Substantial damage NTSB FTW66D0467Accident · No injuriesClosedCessna 172 · Conway, ARJan 9, 1966 · N6876A · Substantial damage NTSB DEN66D0210Accident · Minor injuriesClosedCessna 172 · Bowie, AZJan 9, 1966 · N7513T · Destroyed NTSB NYC66F0440Accident · No injuriesClosedCessna 172F · Baltimore, MDJan 8, 1966 · N7950U · Substantial damage NTSB MKC66D0373Accident · No injuriesClosedCessna 170B · Kirksville, MOJan 2, 1966 · N1695D · Substantial damage NTSB ANC66D0080Accident · Minor injuriesClosedCessna 172F · Palmer, AKJan 2, 1966 · N5309R · Substantial damage NTSB MKC66D0365Accident · No injuriesClosedCessna 172 · Trimont, MNJan 1, 1966 · N7694T · Substantial damage NTSB ANC66D0086Accident · No injuriesClosedCessna 172 · Port Heiden, AKDec 31, 1965 · N8269X · Substantial damage NTSB NYC66D0698Accident · Minor injuriesClosedCessna 172 · Charleston, WVDec 30, 1965 · N2413U · Substantial damage NTSB CHI66F0511Accident · No injuriesClosedCessna 172G · Streator, ILDec 26, 1965 · N3605L · Substantial damage NTSB FTW66D0452Accident · No injuriesClosedCessna 172 · Altus, OKDec 24, 1965 · N5950R · Substantial damage NTSB NYC66F0427Accident · No injuriesClosedCessna 172 · Lewiston, MEDec 23, 1965 · N8197B · Substantial damage