NTSB investigations: Lycoming 0-540 series, 1969
110 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\") = 1969
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") = 1969
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 FTW70F0114Accident · Serious injuriesClosedPiper PA-25 · Nazareth, TXNTSB MKC70D0098Accident · Minor injuriesClosedPiper PA-25 · La Plata, MONTSB MIA70F0044Accident · No injuriesClosedPiper PA-25 · Cleveland, MSNTSB CHI70D0095Accident · No injuriesClosedPiper PA-25 · Suring, WINTSB MKC70F0074Accident · No injuriesClosedPiper PA-24 · Sarcoxie, MONTSB DEN70D0033Accident · No injuriesClosedPiper PA-24 · Cedar City, UTNTSB DEN70D0060Accident · No injuriesClosedPiper PA-24 · Lake City, CONTSB CHI70A0003Accident · No injuriesClosedPiper PA-32 · Madison, INNTSB FTW70D0040Accident · No injuriesClosedPiper PA-25 · Wynne, ARNTSB LAX70F0031Accident · No injuriesClosedPiper PA-23 · Redlands, CANTSB CHI70D0123Accident · No injuriesClosedCallair A-9 · Hobart, INNTSB NYC70F0064Accident · No injuriesClosedPiper PA-24 · Ridgeway, PANTSB MIA69A0093Accident · No injuriesClosedPiper PA-18 · Flora, MSNTSB CHI70F0055Accident · No injuriesClosedPiper PA-32 · Chicago, ILNTSB NYC70F0046Accident · No injuriesClosedPiper PA-24 · White Plains, NYNTSB MKC70D0025Accident · No injuriesClosedPiper PA-24 · Dora Lake, MNNTSB FTW70F0056Accident · No injuriesClosedPiper PA-25 · Texarkana, ARNTSB FTW70D0058Accident · No injuriesClosedPiper PA-25 · Guymon, OKNTSB MKC70D0060Accident · No injuriesClosedPiper PA-28 · Olathe, KSNTSB DIA70F0023Accident · No injuriesClosedPiper PA-24 · Laytonsville, MDNTSB MKC70D0017Accident · No injuriesClosedPiper PA-25 · Burlington, KSNTSB FTW70D0049Accident · No injuriesClosedPiper PA-24 · Lubbock, TXNTSB FTW69D0542Accident · Minor injuriesClosedPiper PA-25 · Bay, ARNTSB NYC69F0455Accident · No injuriesClosedPiper PA-23 · Andover, NJNTSB LAX70D0009Accident · No injuriesClosedPiper PA-24 · Safford, AZNTSB FTW70D0030Accident · Minor injuriesClosedPiper PA-28 · Kingsland, TXNTSB FTW70D0006Accident · No injuriesClosedPiper PA-25 · Amagon, ARNTSB FTW69D0512Accident · No injuriesClosedCallair A-9 · Doole, TXNTSB MKC70D0030Accident · No injuriesClosedPiper PA-25 · Wilsonville, NENTSB DEN69D0238Accident · No injuriesClosedPiper PA-25 · Logan, UTNTSB FTW70D0074Accident · No injuriesClosedPiper PA-25 · Roby, TXNTSB FTW69D0544Accident · Serious injuriesClosedPiper PA-25 · Morganza, LANTSB FTW69A0083Accident · 1 fatalClosedPiper PA-32 · Keller, TXNTSB OAK69F0302Accident · No injuriesClosedPiper PA-25 · Stockton, CANTSB NYC69F0456Accident · No injuriesClosedPiper PA-22 · Gratz, PANTSB SEA69F0250Accident · No injuriesClosedCallair A-9 · St.Xavier, MTNTSB MKC69F0446Accident · No injuriesClosedCallair A-9 · Kadoka, SDNTSB FTW69D0508Accident · No injuriesClosedPiper PA-25 · Cisco, TXNTSB CHI70F0007Accident · Minor injuriesClosedCallair A-9 · Bronson, MINTSB DIA69D0201Accident · No injuriesClosedPiper PA-24 · Asheboro, NCNTSB CHI69F0623Accident · No injuriesClosedPiper PA-24 · Napoleon, OHNTSB NYC69F0434Accident · Minor injuriesClosedPiper PA-23 · Schenectady, NYNTSB CHI69F0594Accident · No injuriesClosedPiper PA-24 · Marysville, MINTSB CHI69D0576Accident · No injuriesClosedPiper PA-24 · Greenwood, INNTSB OAK69D0301Accident · No injuriesClosedPiper PA-28 · Santa Rosa, CANTSB DIA69F0171Accident · No injuriesClosedPiper PA-32 · New Kent, VANTSB DIA69F0170Accident · Minor injuriesClosedPiper PA-28 · Bower, MDNTSB FTW69F0412Accident · No injuriesClosedPiper PA-32 · Sarepta, LANTSB CHI69D0567Accident · No injuriesClosedPiper PA-23 · Drummond, MINTSB FTW69F0455Accident · No injuriesClosedPiper PA-32 · San Antonio, TX