NTSB investigations: Continental 0-300 series, 1973

87 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.

Cases, newest first

Query with SQL
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 year(c.\"eventDate\") = 1973
    AND 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.

NTSB MKC73DCD57Accident · No injuriesClosedCessna 172 · Winterset, IAApr 22, 1973 · N1478F · Substantial damageNTSB FTW73DPD33Accident · Minor injuriesClosedCessna 172 · Abilene, TXApr 21, 1973 · N3718F · Substantial damageNTSB IAD73FKM34Accident · No injuriesClosedCessna 172H · Burnsville, NCApr 20, 1973 · N3872R · Substantial damageNTSB MKC73DCG38Accident · No injuriesClosedCessna 172 · Leavenworth, KSApr 19, 1973 · N7733T · Substantial damageNTSB LAX73DUJ79Accident · No injuriesClosedCessna 172 · Maricopa, AZApr 19, 1973 · N5564R · Substantial damageNTSB NYC73FHA24Accident · No injuriesClosedCessna 172 · Basking Ridge, NJApr 17, 1973 · N3636S · Substantial damageNTSB NYC73DGM28Accident · No injuriesClosedCessna 172 · Wattsburg, PAApr 16, 1973 · N5360R · Substantial damageNTSB FTW73DPG44Accident · No injuriesClosedCessna 172A · Ft.Smith, ARApr 12, 1973 · N7480T · Substantial damageNTSB DEN73DQD15Accident · No injuriesClosedCessna 172D · Animas, NMApr 9, 1973 · N2154Y · Substantial damageNTSB CHI73FEI37Accident · Serious injuriesClosedCessna 172F · Swanton, OHApr 7, 1973 · N8472U · Substantial damageNTSB SEA73DYG26Accident · No injuriesClosedCessna 172 · Othello, WAApr 5, 1973 · N7021T · Substantial damageNTSB SEA73DYE30Accident · Serious injuriesClosedCessna 172 · Chehalis, WAApr 3, 1973 · N6718A · Substantial damageNTSB LAX73FUJ66Accident · Serious injuriesClosedCessna 172E · Peoria, AZApr 3, 1973 · N3658R · Substantial damageNTSB MIA73AM097Accident · 1 fatalClosedCessna 172 · Missing AircraftMar 28, 1973 · N7050T · DestroyedNTSB FTW73DPA28Accident · No injuriesClosedCessna 172 · Dallas, TXMar 24, 1973 · N8151L · Substantial damageNTSB DEN73DTM23Accident · Minor injuriesClosedCessna 170B · Bryce Canyon, UTMar 19, 1973 · N8017A · Substantial damageNTSB OAK73DVA47Accident · No injuriesClosedCessna 172D · Patterson, CAMar 16, 1973 · N2693U · Substantial damageNTSB CHI73DEI36Accident · No injuriesClosedCessna 172E · N.Jackson, OHMar 16, 1973 · N5336T · Substantial damageNTSB MIA73DKJ46Accident · No injuriesClosedCessna 172 · Daleville, ALMar 15, 1973 · N8721U · Substantial damageNTSB CHI73FEC24Accident · No injuriesClosedCessna 172G · Romulus, MIMar 15, 1973 · N3793L · Substantial damageNTSB IAD73FI620Accident · No injuriesClosedCessna 172B · Berkely Spgs, WVMar 11, 1973 · N7764X · Substantial damageNTSB FTW73FPA26Accident · No injuriesClosedCessna 172F · Trenton, TXMar 11, 1973 · N1117T · Substantial damageNTSB CHI73AEK17Accident · No injuriesClosedCessna 172 · Lancaster, OHMar 11, 1973 · N4205F · Substantial damageNTSB ANC73FAD05Accident · No injuriesClosedCessna 170B · Wrangell, AKMar 10, 1973 · N2961D · Substantial damageNTSB IAD73AI005Accident · 2 fatalClosedCessna 172F · Mcclellanville, SCMar 9, 1973 · N5310R · DestroyedNTSB MKC73FCA18Accident · Serious injuriesClosedCessna 172 · Cuba, MOFeb 25, 1973 · N5662R · Substantial damageNTSB OAK73DVM23Accident · No injuriesClosedCessna 172 · Salinas, CAFeb 18, 1973 · N7613T · Substantial damageNTSB SEA73FYE26Accident · Serious injuriesClosedCessna 172G · Bellevue, WAFeb 17, 1973 · N4126L · No damageNTSB DEN73FQA27Accident · No injuriesClosedCessna 172G · Moriarty, NMFeb 17, 1973 · N4226L · Substantial damageNTSB CHI73DEI28Accident · No injuriesClosedCessna 172 · Elyria, OHFeb 13, 1973 · N8605U · Substantial damageNTSB MIA73DKT62Accident · No injuriesClosedCessna 172 · Ft.Lauderdale, FLFeb 10, 1973 · N5770R · Substantial damageNTSB DEN73DTM19Accident · No injuriesClosedCessna 172 · Vernal, UTFeb 10, 1973 · N7022A · Substantial damageNTSB OAK73FXQ22Accident · No injuriesClosedCessna 172 · Yerington, NVFeb 8, 1973 · N8073X · Substantial damageNTSB CHI73FEM43Accident · Serious injuriesClosedCessna 172H · Mcbain, MIFeb 2, 1973 · N2400L · DestroyedNTSB FTW73DRG44Accident · No injuriesClosedCessna 172 · Eagle Pass, TXJan 27, 1973 · N3263L · Substantial damageNTSB DEN73DQA24Accident · No injuriesClosedCessna 172 · Tanner, NMJan 21, 1973 · N3931F · Substantial damageNTSB CHI73DEM36Accident · Minor injuriesClosedCessna 172B · Gwinn, MIJan 21, 1973 · N7802X · Substantial damage