NTSB investigations: Lycoming I0360 series, 1968
73 cases on aircraft whose registry engine model is Lycoming I0360 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\") = 1968
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41515'))
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") = 1968
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41515'))
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 OAK69D0021Accident · Minor injuriesClosedMooney M20F · Lodi, CANTSB SEA68D0311Accident · No injuriesClosedHughes 269B · Tigard, ORNTSB FTW68F0520Accident · Minor injuriesClosedMooney M20F · Many, LANTSB NYC68F0456Accident · No injuriesClosedMooney M20E · Salem, NHNTSB MKC68D0517Accident · No injuriesClosedBeech A23-24 · Leon, IANTSB OAK68F0333Accident · No injuriesClosedPiper PA-28 · Fair Oaks, CANTSB MKC68F0506Accident · No injuriesClosedHughes 269B · St Paul, MNNTSB SEA68A0059Accident · No injuriesClosedHughes 269B · Walla Walla, WANTSB CHI68F0692Accident · No injuriesClosedMooney M20F · Oshkosh, WINTSB MKC68F0499Accident · No injuriesClosedMooney M20E · Thief R.Flls, MNNTSB CHI68A0077Accident · Serious injuriesClosedHughes 269B · Sinking Spgs, OHNTSB OAK68F0326Accident · No injuriesClosedTaylorcraft BC12-D · San Jose, CANTSB CHI68D0624Accident · No injuriesClosedBeech A23-24 · Owensboro, KYNTSB MIA68F0428Accident · No injuriesClosedMooney M20E · Gadsden, ALNTSB LAX68A0076Accident · No injuriesClosedHughes 269B · Hawain Grdn, CANTSB DIA68F0177Accident · No injuriesClosedMooney M20F · Concord, NCNTSB FTW68A0077Accident · No injuriesClosedHughes 269A · San Antonio, TXNTSB MIA68F0472Accident · No injuriesClosedMooney M20C · Florence, SCNTSB FTW68D0439Accident · No injuriesClosedMooney M20F · Webber Falls, OKNTSB MKC68F0414Accident · No injuriesClosedMooney M20E · Wichita, KSNTSB MIA68A0065Accident · 2 fatalClosedBeech B95 · Marion, ALNTSB DEN68A0034Accident · No injuriesClosedHughes 269B · Sundance, WYNTSB SEA68A0049Accident · Minor injuriesClosedHughes 269B · Wyola, MT