NTSB investigations: Lycoming O&VO-360 series, 1982, AL
2 cases on aircraft whose registry engine model is Lycoming O&VO-360 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
| 1964 | 1 |
|---|---|
| 1965 | 4 |
| 1966 | 3 |
| 1967 | 2 |
| 1969 | 1 |
| 1970 | 4 |
| 1971 | 2 |
| 1973 | 2 |
| 1975 | 2 |
| 1976 | 1 |
| 1977 | 6 |
| 1978 | 4 |
| 1979 | 2 |
| 1980 | 1 |
| 1981 | 3 |
| 1982 | 2 |
| 1983 | 3 |
| 1984 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 1996 | 2 |
| 1998 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2011 | 1 |
| 2012 | 3 |
| 2014 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2020 | 1 |
| 2022 | 3 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 1 |
Where
Open the mapLatest 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 year(c.\"eventDate\") = 1982
AND c.\"eventStateOrRegion\" = 'AL' AND 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 ('41514'))
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") = 1982
AND c."eventStateOrRegion" = 'AL' AND 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 ('41514'))
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 ATL83LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Heflin, ALWhile on a pleasure flight the pilot experienced a fluctuation in his alternator indicator. Soon afterwards the alternator panel warning light came on. The pilot assumed his battery had gone dead after his radio lights also ceased to operate. At that point…NTSB ATL82DA271Accident · No injuriesFinal reportGrumman AA-5B · Moulton, ALAccording to the pilot, after touchdown he applied brakes and the right brake seemed to lock intermittently during the roll out. Black marks on the landing surface reveal the aircraft departed the right side and impacted an embankment and steel post. This was…