NTSB investigations: Lycoming 0-320 series, 1965, PA

14 cases on aircraft whose registry engine model is Lycoming 0-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

19642026
NTSB investigations: Lycoming 0-320 series, 1965, PA per year, 1964–2026: 377 cases
19649
196514
196612
196717
19689
196914
197013
197114
19727
19739
197411
197512
197614
197711
197815
19798
19808
19816
19829
19838
19847
19854
19865
198710
19886
19895
19903
19918
19925
19935
19945
19956
19961
19975
19985
19992
20002
20013
20024
20047
20053
20063
20076
20084
20097
20102
20112
20124
20133
20141
20154
20164
20174
20182
20192
20202
20224
20241
20261

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\") = 1965
    AND c.\"eventStateOrRegion\" = 'PA' 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 ('41508'))
  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.

NTSB NYC66D0362Accident · No injuriesClosedPiper PA-28 · Langhorne, PANov 23, 1965 · N6523W · Substantial damageNTSB NYC66D0345Accident · No injuriesClosedPiper PA-22 · Butler, PAOct 17, 1965 · N4318A · 2 aircraft · Substantial damageNTSB NYC66F0254Accident · Serious injuriesClosedPiper PA-28 · Philadelphia, PASep 28, 1965 · N6378W · Substantial damageNTSB NYC66F0199Accident · No injuriesClosedPiper PA-28 · Morrisville, PASep 5, 1965 · N6142W · Substantial damageNTSB NYC66D0198Accident · No injuriesClosedPiper PA-22 · State College, PAAug 31, 1965 · N6164D · Substantial damageNTSB NYC66D0150Accident · No injuriesClosedPiper PA-28 · West Mifflin, PAJul 28, 1965 · N6613W · Substantial damageNTSB NYC66F0127Accident · No injuriesClosedPiper PA-22 · Bethel Park, PAJul 4, 1965 · N4518A · Substantial damageNTSB NYC66F0080Accident · No injuriesClosedPiper PA-23 · Ambler, PAJun 19, 1965 · N1325P · Substantial damageNTSB NYC65D0235Accident · No injuriesClosedPiper PA-28 · Bethel, PAJun 3, 1965 · N6088W · Substantial damageNTSB NYC66D0022Accident · No injuriesClosedPiper PA-28 · Hazleton, PAMay 14, 1965 · N5376W · Substantial damageNTSB NYC65D0210Accident · No injuriesClosedPiper PA-28 · Port Allegany, PAApr 24, 1965 · N5329W · Substantial damageNTSB NYC65F0137Accident · No injuriesClosedPiper PA-28 · Lake Ariel, PAApr 20, 1965 · N5207W · Substantial damageNTSB NYC65D0237Accident · No injuriesClosedPiper PA-22 · Distant, PAApr 20, 1965 · N3046Z · Substantial damageNTSB UNK65X1375Accident · No injuriesClosedMooney M20 · Butler, PAJan 30, 1965 · N5257B · Minor damage