NTSB investigations: Lycoming O-320-A2B, 1984
2 cases on aircraft whose registry engine model is Lycoming O-320-A2B. 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 | 4 |
|---|---|
| 1965 | 3 |
| 1966 | 1 |
| 1967 | 3 |
| 1968 | 1 |
| 1969 | 2 |
| 1971 | 1 |
| 1976 | 2 |
| 1978 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 1 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2009 | 2 |
| 2010 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 3 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 3 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 2 |
| 2023 | 3 |
| 2025 | 3 |
| 2026 | 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\") = 1984
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('42101'))
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") = 1984
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('42101'))
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 ANC85LA010Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Port Heiden, AKAccording to a state police report, the plt assaulted his wife, then loaded his two children into the acft and flew to a refueling area. He refueled the acft, then tookoff & crashed aprx 1 mile north of the departure rwy. A witness reported that after the…NTSB DEN84LA228Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Meeteetse, WYPlt reported flt was being conducted in mountainous terrain with fog patches in the area. Conditions conducive to carb ice existed. Calculated temp at flight altitude of 9000 ft MSL: 62 degs. Plt's estimate of temp: 50 degs. Closest reported dew pt: 57 degs.…