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.
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" DESCRun 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 SEA74DYA04Accident · Serious injuriesClosedPiper PA-28 · Ironside, ORNTSB MKC74DER02Accident · No injuriesClosedPiper PA-28 · Eden Prairie, MNNTSB MIA74FLD16Accident · No injuriesClosedPiper PA-28 · Tampa, FLNTSB DEN74FQA07Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMNTSB NYC74FHM02Accident · Minor injuriesClosedPiper PA-28 · Marboro, NJNTSB CHI74AC005Accident · No injuriesClosedPiper PA-28 · Elgin, ILNTSB LAX74DUJ09Accident · No injuriesClosedCessna 177A · Sierra Vsta, AZNTSB MIA74FLD04Accident · No injuriesClosedPiper PA-28 · Ormond Beach, FLNTSB FTW74FRG02Accident · No injuriesClosedMooney M20 · Corpus Chrsti, TXNTSB NYC73FNA53Accident · No injuriesClosedBeech B23 · Danvers, MANTSB LAX73DUQ41Accident · Minor injuriesClosedBeech 23 · Van Nuys, CANTSB CHI73DEM74Accident · No injuriesClosedCessna 172K · St.Ignace, MINTSB IAD73FIQ35Accident · No injuriesClosedGreat Lakes 2T-1R · Louisville, KYNTSB MKC73FCJ49Accident · Minor injuriesClosedMooney M20A · Bassett, NENTSB NYC73FGT13Accident · No injuriesClosedPiper PA-28 · State College, PANTSB LAX74AL002Accident · 1 fatalClosedPiper PA-28 · Banning, CANTSB FTW73FRJ38Accident · Minor injuriesClosedBeech B23 · Monroe, LANTSB CHI73FET22Accident · Minor injuriesClosedHughes 269A · Gary, INNTSB SEA73DYC29Accident · No injuriesClosedCessna 172H · Battleground, WANTSB MIA73DKT98Accident · Minor injuriesClosedMooney M20G · Tavernier, FLNTSB CHI73FEI41Accident · Serious injuriesClosedBeech B23 · Kent, OHNTSB ANC73DAG91Accident · No injuriesClosedCessna 170B · Yakutat, AKNTSB MKC73DCA23Accident · No injuriesClosedLake LA-4 · St Charles, MONTSB FTW73FRD19Accident · Minor injuriesClosedBeech B23 · St.Francisvlle, LANTSB NYC73FHA73Accident · Minor injuriesClosedCessna 177B · Pottstown, PANTSB MIA73DKG74Accident · No injuriesClosedMooney M20C · Villa Rica, GANTSB NYC73FHM29Accident · No injuriesClosedPiper PA-28 · Clark, NJNTSB MKC73FTK13Accident · No injuriesClosedPiper PA-24 · Mud Butte, SDNTSB NYC73FFJ21Accident · Serious injuriesClosedPiper PA-28 · Fulton, NYNTSB IAD73FLJ25Accident · Serious injuriesClosedPiper PA-28 · Bolton, NCNTSB IAD73AI011Accident · 2 fatalClosedPiper PA-24 · Orange, VANTSB MIA73DKG66Accident · No injuriesClosedPiper PA-28 · Cornelia, GANTSB CHI73FEC29Accident · No injuriesClosedPiper PA-24 · Lapeer, MINTSB MIA73DKT76Accident · No injuriesClosedMooney M20C · Ft Lauderdale, FLNTSB NYC73DNC65Accident · No injuriesClosedPiper PA-28 · Bangor, MENTSB LAX73DUJ63Accident · No injuriesClosedMooney MK-20 · Grand Canyn, AZNTSB FTW73DRG61Accident · No injuriesClosedCessna 177 · Port Lavaca, TXNTSB MIA73DKJ48Accident · Serious injuriesClosedMooney M20-C · Bay Minette, ALNTSB CHI73FEI34Accident · No injuriesClosedPiper PA-24 · Wadsworth, OHNTSB CHI73DEE47Accident · No injuriesClosedPiper PA-24 · Roselle, ILNTSB FTW73AF051Accident · 2 fatalClosedPiper PA-28 · Douglas, TXNTSB MKC73FER44Accident · No injuriesClosedMooney M20A · Duluth, MNNTSB LAX73DUJ53Accident · No injuriesClosedPiper PA-28 · Skull Vly, AZNTSB NYC73FHA16Accident · No injuriesClosedPiper PA-28 · Pittstown, NJNTSB MKC73DER40Accident · No injuriesClosedBeech B23 · Thief R Fall, MNNTSB CHI73 EE45Accident · No injuriesClosedPiper PA-28 · Freeport, ILNTSB FTW73DRG51Accident · No injuriesClosedPiper PA-24 · Uvalde, TXNTSB NYC73FGT07Accident · No injuriesClosedBeech 95 · Montoursville, PANTSB CHI73FEP39Accident · No injuriesClosedMooney M20C · Middleton, WINTSB DEN73FTM18Accident · No injuriesClosedPiper PA-24 · Bountiful, UT