Fatal NTSB investigations: Lycoming IO-540 series, 1983
3 cases on aircraft whose registry engine model is Lycoming IO-540 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
| 1971 | 1 |
|---|---|
| 1978 | 2 |
| 1979 | 2 |
| 1981 | 2 |
| 1982 | 2 |
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 5 |
| 1986 | 5 |
| 1987 | 1 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 5 |
| 1993 | 4 |
| 1994 | 5 |
| 1995 | 5 |
| 1996 | 1 |
| 1997 | 6 |
| 1998 | 4 |
| 1999 | 7 |
| 2000 | 4 |
| 2001 | 10 |
| 2002 | 21 |
| 2003 | 12 |
| 2004 | 10 |
| 2005 | 11 |
| 2006 | 11 |
| 2007 | 11 |
| 2008 | 13 |
| 2009 | 7 |
| 2010 | 13 |
| 2011 | 8 |
| 2012 | 5 |
| 2013 | 4 |
| 2014 | 9 |
| 2015 | 5 |
| 2016 | 3 |
| 2017 | 7 |
| 2018 | 6 |
| 2019 | 9 |
| 2020 | 3 |
| 2021 | 3 |
| 2022 | 3 |
| 2023 | 7 |
| 2024 | 3 |
| 2025 | 2 |
| 2026 | 3 |
Where
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 year(c.\"eventDate\") = 1983
AND c.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41530', '41585'))
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") = 1983
AND c."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41530', '41585'))
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 NYC83FA254Accident · 3 fatalField investigationFinal reportBellanca 17-31ATC · Provincetown, MAThe acft crashed in cape cod bay during a night x-country flt. Two sections of wooden wing identified as from the same make and model as the missing acft were recovered from the bay during the 3 days following the flt of the acft. Other identified parts of…NTSB MIA83FA202Accident · 5 fatalField investigationFinal reportRockwell 114A · Ebro, FLShortly after takeoff the plt advised departure control that he was going around clouds & that there was no activity on his onboard storm scope. Several minutes later radar contact was lost. The acft had broke up in flight. Although VMC prevailed at the…NTSB NYC83FA087Accident · 6 fatalField investigationFinal reportPiper PA-32RT-300 · Wellsville, NYJust prior to this flt, the plt had flown from hornell, NY to Wellsville, NY. Before departing hornell, he radioed that the vacuum annunciator light was on, & during a run-up, the suction gauge read zero. Ground personnel advised that with this problem, the…