NTSB investigations: Lycoming 0-320 series, 1966
427 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\") = 1966
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") = 1966
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 OAK67F0152Accident · No injuriesClosedPiper PA-28 · Honolulu, HINTSB SEA67D0222Accident · No injuriesClosedPiper PA-18 · Fossil, ORNTSB MKC67D0312Accident · No injuriesClosedBeech A23 · Garden City, KSNTSB MKC67F0298Accident · No injuriesClosedPiper PA-28 · Lincoln, NENTSB CHI67D0341Accident · No injuriesClosedPiper PA-23 · Racine, WINTSB NYC67A0070Accident · No injuriesClosedPiper PA-23 · Trenton, NJNTSB DIA67D0008Accident · No injuriesClosedMorrisey 2150A · New Castle, VANTSB SEA67F0170Accident · No injuriesClosedPiper PA-18 · Weiser, IDNTSB MKC67F0270Accident · Minor injuriesClosedPiper PA-18 · Eli, NENTSB MKC67F0266Accident · No injuriesClosedPiper PA22 · Lisbon, NDNTSB FTW67D0368Accident · No injuriesClosedPiper PA-28 · Corpus Chrsti, TXNTSB MKC67D0331Accident · No injuriesClosedMooney M20 · Ottawa, KSNTSB CHI67F0314Accident · No injuriesClosedPiper PA28 · Troy, MINTSB CHI67D0357Accident · No injuriesClosedPiper PA-28 · Logansport, INNTSB NYC67D0321Accident · No injuriesClosedPiper PA-28 · Milford, NHNTSB MKC67F0296Accident · No injuriesClosedPiper PA-28 · St.Charles, MONTSB SEA66D0166Accident · No injuriesClosedPiper PA-25 · Pasco, WANTSB OAK67D0145Accident · No injuriesClosedPiper PA-22 · Milpitas, CANTSB MKC67F0300Accident · No injuriesClosedBeech 23 · Burden, KSNTSB CHI67F0327Accident · No injuriesClosedPiper PA-28 · Delafield, WINTSB ANC67D0059Accident · No injuriesClosedPiper PA-18 · Aleknagik, AKNTSB OAK67D0222Accident · No injuriesClosedChampion 7GCAA · Petaluma, CANTSB MIA67F0257Accident · No injuriesClosedPiper PA-28 · Miami, FLNTSB SEA67D0186Accident · No injuriesClosedPiper PA-28 · Billings, MTNTSB OAK67F0132Accident · No injuriesClosedPiper PA-28 · Fresno, CANTSB MKC67D0255Accident · No injuriesClosedPiper PA-22 · De Witt, IANTSB LAX67F0148Accident · No injuriesClosedPiper PA-28 · Santa Ana, CANTSB SEA67D0145Accident · No injuriesClosedPiper PA-18 · Coulee City, WANTSB CHI67F0269Accident · No injuriesClosedPiper PA-28 · Sycamore, ILNTSB MIA67F0187Accident · No injuriesClosedPiper PA-28 · Chattanooga, TNNTSB NYC67D0334Accident · No injuriesClosedBeech A23-19 · New Castle, DENTSB MKC67D0252Accident · No injuriesClosedBeech A23-19 · St.Joseph, MONTSB NYC67F0297Accident · No injuriesClosedPiper PA-28 · Ocean City, NJNTSB NYC67D0269Accident · No injuriesClosedPiper PA-28 · College Park, MDNTSB MIA67F0285Accident · No injuriesClosedPiper PA-18A · Jay, FLNTSB CHI67D0255Accident · No injuriesClosedPiper PA-28 · Vandalia, OHNTSB CHI67D0345Accident · No injuriesClosedPiper PA-28 · Stow, OHNTSB CHI67F0307Accident · No injuriesClosedPiper PA-22 · Somerset, KYNTSB MKC67F0245Accident · No injuriesClosedPiper PA-28 · Dodge City, KSNTSB CHI67F0204Accident · Minor injuriesClosedPiper PA-28 · Columbus, OHNTSB MKC67D0225Accident · No injuriesClosedPiper PA-22 · Lebanon, IANTSB DEN67F0175Accident · No injuriesClosedPiper PA-22 · Greeley, CONTSB CHI67F0198Accident · No injuriesClosedPiper PA-28 · Adrian, MINTSB OAK67D0167Accident · No injuriesClosedPiper PA-23 · Reno, NVNTSB NYC67D0272Accident · No injuriesClosedPiper PA-28 · Plainville, CTNTSB CHI67D0338Accident · No injuriesClosedPiper PA-28 · Medina, OHNTSB NYC67F0251Accident · Minor injuriesClosedAeronca 7GCA · Warwick, NJNTSB OAK67F0105Accident · No injuriesClosedPiper PA-23 · Honolulu, HINTSB SEA67A0026Accident · 4 fatalClosedPiper PA-28 · Alberton, MTNTSB LAX67D0122Accident · No injuriesClosedPiper PA-28 · Acton, CA