Lycoming AEIO-360 series
NTSB investigations · 210
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 ('41522', '41601')
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 ('41522', '41601')
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 LAX78DVM14Accident · No injuriesClosedGR Lakes 2T-1A · Santa Maria, CANTSB LAX78FUJ30Accident · No injuriesClosedPitts S-1S · Marana, AZNTSB LAX78FUQ11Accident · No injuriesClosedGreat Lakes 2T-1A2 · Van Nuys, CANTSB OAK78DVD02Accident · No injuriesClosedGreat Lakes 2THA2 · Oakland, CANTSB NYC77FGM47Accident · No injuriesClosedPitts Spcl · Franklin, PANTSB FTW77DA003Accident · 1 fatalClosedPitts Spcl S-1S · Durant, OKNTSB OAK76DVG99Accident · No injuriesClosedGreat Lakes Baby · Chico, CANTSB OAK74FVA56Accident · No injuriesClosedCallair A-6 · Kerman, CANTSB FTW68A0019Accident · 4 fatalClosedBell 206A · Morgan City, LANTSB SEA66D0001Accident · No injuriesClosedRawdon T1 · Oakesdale, WA
Back to Lycoming AEIO-360 series