NTSB investigations: Lycoming IO-320 series, Outside the U.S.
9 cases on aircraft whose registry engine model is Lycoming IO-320 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 per year
| 1967 | 1 |
|---|---|
| 1987 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2009 | 1 |
| 2013 | 1 |
| 2021 | 2 |
| 2022 | 1 |
Latest cases
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 c.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41509'))
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 c."eventCountry" <> 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41509'))
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 GAA22WA121Accident · No injuriesClass 5 · ForeignPiper PA-30 · Sandown, United KingdomNTSB GAA21WA263Accident · No injuriesClass 5 · ForeignPiper PA-30 · Saint-Honorat, FranceNTSB GAA21WA137Accident · No injuriesClass 4 · ForeignPiper PA-30 · Courcelles-sur-Viosnes, FranceNTSB CEN13WA301Accident · 1 fatalForeign investigationPiper PA-39 · Wolfsbehringen, GermanyNTSB ERA09WA291Accident · 2 fatalForeign investigationPiper PA-30 · Port Sudan, SudanOn May 10, 2009, at 0530 universal coordinated time (0830 local time), a Piper PA-30, N502TC, was destroyed when it impacted mountainous terrain about 26 nautical miles northwest of Port Sudan, Sudan. The two Yemani pilots onboard were fatally injured. The…NTSB DEN07WA147Accident · 2 fatalForeign investigationPiper PA-39 · Vannes, FranceNTSB DEN07WA028Accident · 1 fatalForeign investigationYoakley Glasair · Rieden, GermanyNTSB LAX87WA216Accident · Minor injuriesForeign investigationPiper PA-30 · Mexicali, MexicoNTSB MIA68D0318Accident · No injuriesClosedPiper PA-30 · Hawks Nest, Burkina Faso