NTSB investigations: Lycoming 0-145B series, 1978

8 cases on aircraft whose registry engine model is Lycoming 0-145B 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

NTSB investigations: Lycoming 0-145B series, 1978 per year, 1964–2026: 169 cases
1964	10
1965	8
1966	5
1967	13
1968	10
1969	3
1970	7
1971	4
1972	6
1973	6
1974	5
1975	6
1976	3
1977	5
1978	8
1979	4
1980	2
1981	5
1982	3
1983	4
1984	1
1985	3
1986	3
1987	2
1988	3
1990	3
1991	2
1993	1
1994	2
1995	1
1998	3
2000	1
2001	1
2004	1
2006	2
2007	2
2008	3
2009	2
2010	2
2011	2
2013	2
2014	1
2015	2
2016	1
2018	2
2021	1
2022	1
2023	1
2026	1

Where

Open the map

Latest cases

Query with SQL

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") = 1978 AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41502')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\") = 1978
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41502'))
  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") = 1978
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41502'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 FTW79DA008Accident · 1 fatalClosedMooney M18LA · Wilson, TXOct 29, 1978 · N4086 · Destroyed NTSB CHI78FEM35Accident · Minor injuriesClosedTaylorcraft BL-65 · Grand Haven, MIAug 17, 1978 · N27427 · Substantial damage NTSB ANC78DAH06Accident · No injuriesClosedPiper PA-18 · Farewell, AKAug 14, 1978 · N38762 · Substantial damage NTSB FTW78FRJ16Accident · Serious injuriesClosedW Pusher WAS 2 · Marksville, LAApr 26, 1978 · N73549 · Substantial damage NTSB OAK78DVG31Accident · No injuriesClosedTaylorcraft BL65 · Redding, CAApr 23, 1978 · N20429 · Substantial damage NTSB LAX78FUG24Accident · Serious injuriesClosedBantom W3 · Corona, CAApr 22, 1978 · N2258B · Substantial damage NTSB CHI78FEP19Accident · No injuriesClosedTaylorcraft BL-65 · Hartford, WIFeb 25, 1978 · N29504 · Substantial damage NTSB IAD78DKM04Accident · No injuriesClosedPiper PA-15 · Cherokee, NCJan 5, 1978 · N4659H · Destroyed