NTSB investigations: Lycoming 0-320 series, 1971
396 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\") = 1971
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") = 1971
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 MIA72FLA13Accident · No injuriesClosedPiper PA-28 · Hastings, FLNTSB SEA72DYC20Accident · No injuriesClosedPiper PA-22 · Oregon City, ORNTSB SEA72DYA14Accident · No injuriesClosedCessna 172K · Mtn Home, IDNTSB MKC72DER24Accident · No injuriesClosedBeech 19A · Blue Earth, MNNTSB CHI72DEI20Accident · No injuriesClosedBeech A23-19 · Northfield, OHNTSB CHI72AC033Accident · Minor injuriesClosedPiper PA-28 · Urbana, ILNTSB MIA72DLD15Accident · No injuriesClosedPiper PA-28 · Englewood, FLNTSB FTW72FPG44Accident · No injuriesClosedCessna 172 · El Dorado, ARNTSB CHI72FLQ16Accident · Minor injuriesClosedChampion 7GCBC · Independence, KYNTSB NYC72FGM19Accident · Minor injuriesClosedPiper PA-28 · Franklin, PANTSB MKC72DCJ29Accident · No injuriesClosedPiper PA-28 · Glenvil, NENTSB MIA72FLD14Accident · Serious injuriesClosedCessna 172L · Orlando, FLNTSB MIA72DKG46Accident · No injuriesClosedPiper PA-28 · Waycross, GANTSB CHI72FEC15Accident · No injuriesClosedPiper PA-28 · S Rockwood, MINTSB LAX72DUJ48Accident · No injuriesClosedCessna 172 · Sprngrville, AZNTSB MIA72FKW06Accident · No injuriesClosedPiper PA-28 · Fayetteville, TNNTSB CHI72DEP17Accident · No injuriesClosedMooney M20 · Hayward, WINTSB MIA72DLG13Accident · No injuriesClosedBeech B23 · Florence, SCNTSB NYC72FHA17Accident · No injuriesClosedCessna 172 · Kempton, PANTSB DEN72DTE25Accident · Minor injuriesClosedPiper PA-23 · Aspen, CONTSB ANC72DAG59Accident · No injuriesClosedPiper PA-18 · Chitina, AKNTSB MIA72FLD12Accident · No injuriesClosedPiper PA-23 · Lakeland, FLNTSB ANC72DAG66Accident · No injuriesClosedPiper PA-18 · Kukalkek, AKNTSB NYC72FHM11Accident · No injuriesClosedPiper PA-22 · Marlboro, NJNTSB MIA72DKG39Accident · No injuriesClosedPiper PA-22 · Loganville, GANTSB MKC72FER20Accident · No injuriesClosedPiper PA-28 · Duluth, MNNTSB NYC72FLJ10Accident · Minor injuriesClosedPiper PA-22 · Clinton, NCNTSB NYC72DIA05Accident · No injuriesClosedCessna 177 · Manassas, VANTSB MKC72FCJ24Accident · No injuriesClosedCessna 177 · Omaha, NENTSB NYC72FGM14Accident · No injuriesClosedPiper PA-22 · Prospect, PANTSB MIA72FLT08Accident · No injuriesClosedPiper PA-18 · Ramer, TNNTSB LAX72FUQ21Accident · No injuriesClosedPiper PA-28 · Santa Paula, CANTSB NYC72FLJ11Accident · No injuriesClosedPiper PA-28 · Holly Ridge, NCNTSB MKC72FTK07Accident · Serious injuriesClosedPiper PA-18 · Philip, SDNTSB NYC72FKM04Accident · No injuriesClosedCessna 172 · Indian Trail, NCNTSB MKC72DCD33Accident · No injuriesClosedPiper PA-28 · Osage, IANTSB MIA72FLA09Accident · Minor injuriesClosedCessna 177 · Destin, FLNTSB NYC72FNE10Accident · Minor injuriesClosedPiper PA-28 · Plainville, CTNTSB MKC72FCD28Accident · No injuriesClosedCessna 172 · Blakesburg, IANTSB DEN72FQA16Accident · Minor injuriesClosedCessna 172K · Santa Fe, NMNTSB MIA72DKQ15Accident · No injuriesClosedPiper PA-18 · Edwards, MSNTSB ANC72AA015Accident · No injuriesClosedPiper PA-14 · Homer, AKNTSB DEN72FTE27Accident · No injuriesClosedTemco D-16 · Trinidad, CONTSB CHI72DEE24Accident · No injuriesClosedPiper PA-28 · Clearing, ILNTSB FTW72FPD07Accident · No injuriesClosedHafe CH-1 · Mineral Wells, TXNTSB FTW72FPA05Accident · No injuriesClosedPiper PA-25 · Rockwall, TXNTSB FTW72FPJ12Accident · Serious injuriesClosedPitts Spcl S1C · Cushing, OKNTSB CHI72FEI14Accident · No injuriesClosedPiper PA-22 · Richmond Hts, OHNTSB CHI72DEA13Accident · No injuriesClosedPiper PA-28 · Delphi, INNTSB NYC72FLJ09Accident · No injuriesClosedCessna 177 · Coats, NC