NTSB investigations: Lycoming 0-320 series, 1969, 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, 1969, 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\") = 1969
    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 NYC70D0212Accident · Minor injuriesClosedPiper PA-28 · Coudersport, PASep 26, 1969 · N4542R · Substantial damageNTSB NYC70A0027Accident · 1 fatalClosedPiper PA-22 · Langhorne, PAAug 24, 1969 · N3339Z · DestroyedNTSB NYC70D0141Accident · No injuriesClosedPiper PA-28 · Clarion, PAAug 2, 1969 · N8013N · Substantial damageNTSB NYC70D0062Accident · No injuriesClosedCessna 172 · Montgomeryvile, PAJul 14, 1969 · N84371 · Substantial damageNTSB NYC70D0048Accident · No injuriesClosedPiper PA-28 · Bridgeville, PAJun 26, 1969 · N3584K · Substantial damageNTSB NYC70F0020Accident · No injuriesClosedPiper PA-28 · Philadelphia, PAJun 10, 1969 · N1822J · Substantial damageNTSB NYC70F0007Accident · No injuriesClosedPiper PA-22 · Allentown, PAJun 6, 1969 · N2522P · Substantial damageNTSB NYC70D0022Accident · No injuriesClosedBeech 23 · Hastings, PAMay 23, 1969 · N2321L · Substantial damageNTSB NYC69F0428Accident · Minor injuriesClosedPiper PA-22 · Titusville, PAApr 13, 1969 · N7733D · Substantial damageNTSB NYC69D0395Accident · No injuriesClosedPiper PA-28 · Orwigsburg, PAApr 12, 1969 · N1750J · Substantial damageNTSB NYC69F0407Accident · No injuriesClosedCessna 177 · Connellsville, PAMar 23, 1969 · N3339T · Substantial damageNTSB NYC69D0358Accident · No injuriesClosedPiper PA-28 · Easton, PAMar 6, 1969 · N5779F · Substantial damageNTSB NYC69F0317Accident · No injuriesClosedPiper PA-28 · Ambler, PAFeb 17, 1969 · N7307J · Substantial damageNTSB NYC69F0300Accident · No injuriesClosedPiper PA-28 · Hershey, PAJan 26, 1969 · N9980W · Substantial damage