Lycoming O-360 series
NTSB investigations · 308
Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.engine_model_code IN ('41575')
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.engine_model_code IN ('41575')
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 MIA71DLA35Accident · No injuriesClosedPiper PA-18 · Perry, FLNTSB DEN70D0042Accident · No injuriesClosedCessna 150G · Longmont, CONTSB CHI68D0708Accident · Minor injuriesClosedCessna 172 · Salem, INNTSB MIA68F0208Accident · No injuriesClosedCessna 172 · Mcdonough, GANTSB DEN67D0167Accident · No injuriesClosedCessna 150 · Logmont, CONTSB FTW66D0311Accident · No injuriesClosedPiper PA-18 · Slidell, LANTSB LAX65F0093Accident · No injuriesClosedPiper PA-18 · Carson City, NVNTSB OAK66D0033Accident · No injuriesClosedPiper PA-18 · Tahoe Valley, CA
Back to Lycoming O-360 series