NTSB investigations: Lycoming 0-320 series, 1972
335 cases on aircraft whose registry engine model is Lycoming 0-320 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\") = 1972
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508'))
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") = 1972
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508'))
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 CHI73FEI15Accident · No injuriesClosedCessna 172 · Medina, OHNTSB SEA73DYI05Accident · No injuriesClosedAero Comdr 100 · Burns, ORNTSB MKC73FER25Accident · No injuriesClosedPiper PA-28 · Duluth, MNNTSB NYC73FGT04Accident · No injuriesClosedPiper PA-23 · Carlisle, PANTSB LAX73AL019Accident · 1 fatalClosedCessna 172K · Missing AircraftNTSB CHI73FEM19Accident · No injuriesClosedAero Comdr 100 · Greenville, MINTSB MIA73DKJ26Accident · No injuriesClosedAero Comdr 100 · Slocomb, ALNTSB CHI73DEG08Accident · Minor injuriesClosedPiper PA-22 · Mt Sterling, OHNTSB CHI73FEC10Accident · No injuriesClosedPiper PA-22 · Sebewaing, MINTSB OAK73DVG22Accident · No injuriesClosedCessna 172 · Vacaville, CANTSB CHI73FEC11Accident · Minor injuriesClosedCessna 172 · Clinton, MINTSB LAX73DUG19Accident · No injuriesClosedPiper PA-22 · Bg Bear Cty, CANTSB DEN73DQG19Accident · No injuriesClosedPiper PA-23 · Humble City, NMNTSB CHI73FEC09Accident · No injuriesClosedAero Comdr 100 · Laingsburg, MINTSB NYC73DKM13Accident · No injuriesClosedCessna 172 · Maiden, NCNTSB DEN73DTC09Accident · No injuriesClosedPiper PA-18 · Kaycee, WYNTSB LAX73FUM06Accident · No injuriesClosedPiper PA-23 · San Diego, CANTSB NYC73DFJ10Accident · No injuriesClosedPiper PA-22 · Wolcott, NYNTSB CHI73FEK06Accident · No injuriesClosedPiper PA-28 · Gahanna, OHNTSB SEA73FYC10Accident · No injuriesClosedPiper PA-28 · Portland, ORNTSB MIA73FKG37Accident · Minor injuriesClosedPiper PA-28 · Kennesaw, GANTSB CHI73DEG05Accident · No injuriesClosedPiper PA-28 · Proctorville, OHNTSB NYC73FFA15Accident · No injuriesClosedBeech A23 · Albany, NYNTSB NYC73DKM10Accident · Minor injuriesClosedPiper PA-28 · Murphy, NCNTSB MIA73DLG20Accident · No injuriesClosedPiper PA-28 · Johns Island, SCNTSB CHI73FEM17Accident · No injuriesClosedCessna 177 · Grand Rapids, MINTSB OAK73FJA06Accident · No injuriesClosedChampion 7GCBC · Dillng Afb, HINTSB CHI73AC032Accident · 2 fatalClosedBeech 23 · Kenosha, WINTSB OAK73DVD13Accident · Minor injuriesClosedPitts Spec S-1C · Tracey, CANTSB MIA73FLA17Accident · No injuriesClosedPiper PA-28 · Defuniak Spgs, FLNTSB MIA73FKJ22Accident · Serious injuriesClosedPiper PA-22 · Ashland, ALNTSB MIA73DLD15Accident · No injuriesClosedPiper PA-28 · Seminole, FLNTSB ANC73DAD02Accident · No injuriesClosedPiper PA-18 · Haines, AKNTSB DEN73FTE26Accident · Minor injuriesClosedPiper PA-28 · Littleton, CONTSB ANC73FAG42Accident · Serious injuriesClosedPiper PA-18 · Gakona, AKNTSB FTW73FRA10Accident · No injuriesClosedPiper PA-28 · Friendswood, TXNTSB LAX73OL002Accident · No injuriesClosedPiper PA-28 · Culiacan, MexicoNTSB LAX73DUG16Accident · No injuriesClosedPiper PA-12 · Idyllwild, CANTSB FTW73FRJ13Accident · No injuriesClosedCessna 172L · Garrison, TXNTSB SEA73FYC04Accident · No injuriesClosedPiper PA-22 · Mcminville, ORNTSB CHI73FER04Accident · No injuriesClosedPitts SPL S1C · Osceola, WINTSB ANC73DAG39Accident · No injuriesClosedPiper PA-18 · Glenallen, AKNTSB CHI73FEE22Accident · Minor injuriesClosedPiper PA-28 · Rockford, ILNTSB CHI73DEP19Accident · No injuriesClosedPiper PA-28 · Endeavor, WINTSB NYC73FHM10Accident · No injuriesClosedPiper PA-28 · East Hanover, NJNTSB ANC73DAG28Accident · No injuriesClosedPiper PA-18A · Skwentna, AKNTSB FTW73FQD08Accident · Serious injuriesClosedPiper PA-18 · Canutillo, TXNTSB NYC73FFJ05Accident · Minor injuriesClosedPiper PA-28 · Weedsport, NYNTSB NYC73DID07Accident · No injuriesClosedPiper PA-28 · Chesapeake, VANTSB ANC73DAG22Accident · No injuriesClosedPiper PA-18 · Skwetna, AK