NTSB investigations: Lycoming 0-540 series, 1980

82 cases on aircraft whose registry engine model is Lycoming 0-540 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\") = 1980
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41532'))
  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 FTW80DQG29Accident · No injuriesClosedPiper PA-28 · Robert Lee, TXJul 5, 1980 · N56612 · Substantial damageNTSB LAX80DUJ78Accident · No injuriesClosedPiper PA-25 · Maricopa, AZJun 30, 1980 · N9182T · Substantial damageNTSB CHI80DEM30Accident · No injuriesClosedPiper PA-25 · South Haven, MIJun 21, 1980 · N7278Z · Substantial damageNTSB FTW80FQD09Accident · No injuriesClosedCessna TR182 · El Paso, TXJun 18, 1980 · N4461R · Substantial damageNTSB LAX80DUJ71Accident · No injuriesClosedPiper PA-24 · Kingman, AZJun 15, 1980 · N6151P · Substantial damageNTSB SEA80FYA14Accident · No injuriesClosedPiper PA-25 · Burley, IDJun 5, 1980 · N6486Z · Substantial damageNTSB MIA80FKT42Accident · Minor injuriesClosedPiper PA-28 · W.Palm Beach, FLJun 5, 1980 · N8087D · Substantial damageNTSB SEA80DYE34Accident · No injuriesClosedPiper PA-25 · Sequim, WAJun 4, 1980 · N7763Z · Substantial damageNTSB LAX80FJA16Accident · No injuriesClosedPiper PA-24 · Kamuela, HIJun 1, 1980 · N7084P · Substantial damageNTSB DEN80FTG09Accident · Minor injuriesClosedPiper PA-25 · Davenport, NDMay 23, 1980 · N4860Y · Substantial damageNTSB FTW80FPD29Accident · No injuriesClosedPiper PA-24 · Fort Worth, TXMay 14, 1980 · N5709P · Substantial damageNTSB MIA80FLD66Accident · Minor injuriesClosedPiper PA-32 · Tampa, FLMay 8, 1980 · N7722J · Substantial damageNTSB ATL80FKG01Accident · No injuriesClosedPiper PA-25 · Irwinville, GAMay 5, 1980 · N4682Y · Substantial damageNTSB MIA80DLD61Accident · No injuriesClosedPiper PA-24 · Lakeland, FLApr 21, 1980 · N5949P · Substantial damageNTSB FTW80DQG14Accident · No injuriesClosedCessna R182 · Vega, TXApr 17, 1980 · N400BT · Substantial damageNTSB MIA80DLD55Accident · No injuriesClosedPiper PA-28 · Useppa Island, FLMar 28, 1980 · N2223V · Substantial damageNTSB LAX80FVA27Accident · 1 fatalClosedPitts 6-260 · Frazier Park, CAMar 25, 1980 · N7JY · Substantial damageNTSB LAX80FA071Accident · 1 fatalClosedPiper PA-24 · Tehachapi, CAMar 25, 1980 · N7358P · DestroyedNTSB MIA80DLD56Accident · No injuriesClosedPiper PA-24 · Lake Wales, FLMar 22, 1980 · N7953P · Substantial damageNTSB LAX80DXQ23Accident · No injuriesClosedCessna 182RG · Bridgeport, CAMar 22, 1980 · N739VH · Substantial damageNTSB FTW80FPD20Accident · No injuriesClosedHiller UH-12E · Mineral Wells, TXMar 22, 1980 · N9740C · Substantial damageNTSB SEA80DYM23Accident · Serious injuriesClosedPiper PA-25 · Antelope, ORMar 18, 1980 · N7077Z · DestroyedNTSB MIA80FA046Accident · 3 fatalClosedPiper PA-28 · Florence, SCMar 10, 1980 · N1438X · DestroyedNTSB SEA80FYM16Accident · Minor injuriesClosedPiper PA-24 · Newport, ORFeb 22, 1980 · N5275P · DestroyedNTSB MIA80FA033Accident · 4 fatalClosedPtper PA-32 · Cedar Key, FLFeb 15, 1980 · N5558J · DestroyedNTSB SEA80FYK05Accident · Serious injuriesClosedPiper PA-24 · Allegany, ORFeb 9, 1980 · N5628P · Substantial damageNTSB MIA80DKJ18Accident · No injuriesClosedMaule M5 · Foley, ALFeb 8, 1980 · N9235E · Substantial damageNTSB MIA80FLD36Accident · No injuriesClosedPiper PA-24 · Clearwater, FLFeb 3, 1980 · N7697P · Substantial damageNTSB SEA80DYP08Accident · Minor injuriesClosedCessna 182RG · Moses Lake, WAJan 26, 1980 · N2244T · Substantial damageNTSB LAX80DVG13Accident · No injuriesClosedPiper PA-28 · Vacaville, CAJan 19, 1980 · N8908W · Substantial damageNTSB MIA80DKT24Accident · No injuriesClosedPiper PA-23 · Islamorida, FLJan 18, 1980 · N5134Y · DestroyedNTSB IAD80FKW05Accident · No injuriesClosedPiper PA-28 · Carryville, TNJan 15, 1980 · N9216W · Substantial damage