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.
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" 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 FTW80DQG29Accident · No injuriesClosedPiper PA-28 · Robert Lee, TXNTSB LAX80DUJ78Accident · No injuriesClosedPiper PA-25 · Maricopa, AZNTSB CHI80DEM30Accident · No injuriesClosedPiper PA-25 · South Haven, MINTSB FTW80FQD09Accident · No injuriesClosedCessna TR182 · El Paso, TXNTSB LAX80DUJ71Accident · No injuriesClosedPiper PA-24 · Kingman, AZNTSB SEA80FYA14Accident · No injuriesClosedPiper PA-25 · Burley, IDNTSB MIA80FKT42Accident · Minor injuriesClosedPiper PA-28 · W.Palm Beach, FLNTSB SEA80DYE34Accident · No injuriesClosedPiper PA-25 · Sequim, WANTSB LAX80FJA16Accident · No injuriesClosedPiper PA-24 · Kamuela, HINTSB DEN80FTG09Accident · Minor injuriesClosedPiper PA-25 · Davenport, NDNTSB FTW80FPD29Accident · No injuriesClosedPiper PA-24 · Fort Worth, TXNTSB MIA80FLD66Accident · Minor injuriesClosedPiper PA-32 · Tampa, FLNTSB ATL80FKG01Accident · No injuriesClosedPiper PA-25 · Irwinville, GANTSB MIA80DLD61Accident · No injuriesClosedPiper PA-24 · Lakeland, FLNTSB FTW80DQG14Accident · No injuriesClosedCessna R182 · Vega, TXNTSB MIA80DLD55Accident · No injuriesClosedPiper PA-28 · Useppa Island, FLNTSB LAX80FVA27Accident · 1 fatalClosedPitts 6-260 · Frazier Park, CANTSB LAX80FA071Accident · 1 fatalClosedPiper PA-24 · Tehachapi, CANTSB MIA80DLD56Accident · No injuriesClosedPiper PA-24 · Lake Wales, FLNTSB LAX80DXQ23Accident · No injuriesClosedCessna 182RG · Bridgeport, CANTSB FTW80FPD20Accident · No injuriesClosedHiller UH-12E · Mineral Wells, TXNTSB SEA80DYM23Accident · Serious injuriesClosedPiper PA-25 · Antelope, ORNTSB MIA80FA046Accident · 3 fatalClosedPiper PA-28 · Florence, SCNTSB SEA80FYM16Accident · Minor injuriesClosedPiper PA-24 · Newport, ORNTSB MIA80FA033Accident · 4 fatalClosedPtper PA-32 · Cedar Key, FLNTSB SEA80FYK05Accident · Serious injuriesClosedPiper PA-24 · Allegany, ORNTSB MIA80DKJ18Accident · No injuriesClosedMaule M5 · Foley, ALNTSB MIA80FLD36Accident · No injuriesClosedPiper PA-24 · Clearwater, FLNTSB SEA80DYP08Accident · Minor injuriesClosedCessna 182RG · Moses Lake, WANTSB LAX80DVG13Accident · No injuriesClosedPiper PA-28 · Vacaville, CANTSB MIA80DKT24Accident · No injuriesClosedPiper PA-23 · Islamorida, FLNTSB IAD80FKW05Accident · No injuriesClosedPiper PA-28 · Carryville, TN