NTSB investigations: Lycoming O&VO-360 series, 1973

112 cases on aircraft whose registry engine model is Lycoming O&VO-360 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 ('41514'))
  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 SEA74DYA04Accident · Serious injuriesClosedPiper PA-28 · Ironside, ORJul 20, 1973 · N7259W · Substantial damageNTSB MKC74DER02Accident · No injuriesClosedPiper PA-28 · Eden Prairie, MNJul 20, 1973 · N8378W · Substantial damageNTSB MIA74FLD16Accident · No injuriesClosedPiper PA-28 · Tampa, FLJul 14, 1973 · N3682R · Substantial damageNTSB DEN74FQA07Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMJul 13, 1973 · N9602J · Substantial damageNTSB NYC74FHM02Accident · Minor injuriesClosedPiper PA-28 · Marboro, NJJul 12, 1973 · N7747N · Substantial damageNTSB CHI74AC005Accident · No injuriesClosedPiper PA-28 · Elgin, ILJul 12, 1973 · N1226T · Substantial damageNTSB LAX74DUJ09Accident · No injuriesClosedCessna 177A · Sierra Vsta, AZJul 10, 1973 · N30404 · Substantial damageNTSB MIA74FLD04Accident · No injuriesClosedPiper PA-28 · Ormond Beach, FLJul 8, 1973 · N7140W · Substantial damageNTSB FTW74FRG02Accident · No injuriesClosedMooney M20 · Corpus Chrsti, TXJul 3, 1973 · N6536B · Substantial damageNTSB NYC73FNA53Accident · No injuriesClosedBeech B23 · Danvers, MAJun 28, 1973 · N7617R · Substantial damageNTSB LAX73DUQ41Accident · Minor injuriesClosedBeech 23 · Van Nuys, CAJun 28, 1973 · N6120N · Substantial damageNTSB CHI73DEM74Accident · No injuriesClosedCessna 172K · St.Ignace, MIJun 27, 1973 · N78130 · Substantial damageNTSB IAD73FIQ35Accident · No injuriesClosedGreat Lakes 2T-1R · Louisville, KYJun 24, 1973 · N3290 · Substantial damageNTSB MKC73FCJ49Accident · Minor injuriesClosedMooney M20A · Bassett, NEJun 23, 1973 · N8134E · Substantial damageNTSB NYC73FGT13Accident · No injuriesClosedPiper PA-28 · State College, PAJun 22, 1973 · N7462W · Substantial damageNTSB LAX74AL002Accident · 1 fatalClosedPiper PA-28 · Banning, CAJun 14, 1973 · N4806L · DestroyedNTSB FTW73FRJ38Accident · Minor injuriesClosedBeech B23 · Monroe, LAMay 30, 1973 · N6102N · Substantial damageNTSB CHI73FET22Accident · Minor injuriesClosedHughes 269A · Gary, INMay 28, 1973 · N8790F · Substantial damageNTSB SEA73DYC29Accident · No injuriesClosedCessna 172H · Battleground, WAMay 27, 1973 · N8044L · Substantial damageNTSB MIA73DKT98Accident · Minor injuriesClosedMooney M20G · Tavernier, FLMay 18, 1973 · N3657N · Substantial damageNTSB CHI73FEI41Accident · Serious injuriesClosedBeech B23 · Kent, OHMay 18, 1973 · N6139N · Substantial damageNTSB ANC73DAG91Accident · No injuriesClosedCessna 170B · Yakutat, AKMay 12, 1973 · N3545D · Substantial damageNTSB MKC73DCA23Accident · No injuriesClosedLake LA-4 · St Charles, MOMay 11, 1973 · N1118L · Substantial damageNTSB FTW73FRD19Accident · Minor injuriesClosedBeech B23 · St.Francisvlle, LAMay 3, 1973 · N7614R · Substantial damageNTSB NYC73FHA73Accident · Minor injuriesClosedCessna 177B · Pottstown, PAApr 29, 1973 · N34231 · 2 aircraft · Substantial damageNTSB MIA73DKG74Accident · No injuriesClosedMooney M20C · Villa Rica, GAApr 29, 1973 · N9256M · Substantial damageNTSB NYC73FHM29Accident · No injuriesClosedPiper PA-28 · Clark, NJApr 22, 1973 · N4433T · Substantial damageNTSB MKC73FTK13Accident · No injuriesClosedPiper PA-24 · Mud Butte, SDApr 18, 1973 · N6574P · Substantial damageNTSB NYC73FFJ21Accident · Serious injuriesClosedPiper PA-28 · Fulton, NYApr 14, 1973 · N9326J · Substantial damageNTSB IAD73FLJ25Accident · Serious injuriesClosedPiper PA-28 · Bolton, NCApr 13, 1973 · N511RF · Substantial damageNTSB IAD73AI011Accident · 2 fatalClosedPiper PA-24 · Orange, VAApr 13, 1973 · N6273P · DestroyedNTSB MIA73DKG66Accident · No injuriesClosedPiper PA-28 · Cornelia, GAApr 3, 1973 · N7989W · Substantial damageNTSB CHI73FEC29Accident · No injuriesClosedPiper PA-24 · Lapeer, MIApr 2, 1973 · N8164P · Substantial damageNTSB MIA73DKT76Accident · No injuriesClosedMooney M20C · Ft Lauderdale, FLApr 1, 1973 · N2749W · Substantial damageNTSB NYC73DNC65Accident · No injuriesClosedPiper PA-28 · Bangor, MEMar 27, 1973 · N9513J · Substantial damageNTSB LAX73DUJ63Accident · No injuriesClosedMooney MK-20 · Grand Canyn, AZMar 25, 1973 · N9184V · Substantial damageNTSB FTW73DRG61Accident · No injuriesClosedCessna 177 · Port Lavaca, TXMar 24, 1973 · N30670 · Substantial damageNTSB MIA73DKJ48Accident · Serious injuriesClosedMooney M20-C · Bay Minette, ALMar 21, 1973 · N6797U · Substantial damageNTSB CHI73FEI34Accident · No injuriesClosedPiper PA-24 · Wadsworth, OHMar 19, 1973 · N8298P · Substantial damageNTSB CHI73DEE47Accident · No injuriesClosedPiper PA-24 · Roselle, ILMar 18, 1973 · N6607P · Substantial damageNTSB FTW73AF051Accident · 2 fatalClosedPiper PA-28 · Douglas, TXMar 17, 1973 · N16342 · DestroyedNTSB MKC73FER44Accident · No injuriesClosedMooney M20A · Duluth, MNMar 10, 1973 · N8142E · Substantial damageNTSB LAX73DUJ53Accident · No injuriesClosedPiper PA-28 · Skull Vly, AZFeb 25, 1973 · N9215J · Substantial damageNTSB NYC73FHA16Accident · No injuriesClosedPiper PA-28 · Pittstown, NJFeb 24, 1973 · N1432T · Substantial damageNTSB MKC73DER40Accident · No injuriesClosedBeech B23 · Thief R Fall, MNFeb 23, 1973 · N6084N · Substantial damageNTSB CHI73 EE45Accident · No injuriesClosedPiper PA-28 · Freeport, ILFeb 22, 1973 · N6556J · Substantial damageNTSB FTW73DRG51Accident · No injuriesClosedPiper PA-24 · Uvalde, TXFeb 15, 1973 · N6211P · Substantial damageNTSB NYC73FGT07Accident · No injuriesClosedBeech 95 · Montoursville, PAFeb 14, 1973 · N4511L · Substantial damageNTSB CHI73FEP39Accident · No injuriesClosedMooney M20C · Middleton, WIFeb 8, 1973 · N6520U · Substantial damageNTSB DEN73FTM18Accident · No injuriesClosedPiper PA-24 · Bountiful, UTFeb 5, 1973 · N6594P · Substantial damage