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

13 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, 1970, 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\") = 1970
    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 NYC71FHA40Accident · No injuriesClosedPiper PA-28 · Perkasie, PADec 8, 1970 · N5281S · Substantial damageNTSB NYC71FGM19Accident · No injuriesClosedBeech 23 · Washington, PAOct 23, 1970 · N2328L · Substantial damageNTSB NYC71FGM17Accident · Serious injuriesClosedPiper PA-28 · Washington, PAOct 18, 1970 · N8702N · Substantial damageNTSB NYC71DGM18Accident · Minor injuriesClosedCessna 172K · Russell, PAOct 14, 1970 · N79150 · Substantial damageNTSB NYC71DHA08Accident · No injuriesClosedPiper PA-28 · Quakertown, PAJul 17, 1970 · N6362R · Substantial damageNTSB NYC70FGM20Accident · No injuriesClosedBeech A23-19 · New Castle, PAMay 31, 1970 · N5763V · Substantial damageNTSB NYC70DHD27Accident · Minor injuriesClosedPiper PA-28 · West Chester, PAMay 23, 1970 · N8201N · Substantial damageNTSB NYC70FHG06Accident · Minor injuriesClosedPiper PA-28 · Reamstown, PAMay 14, 1970 · N8817N · DestroyedNTSB NYC70FGM17Accident · No injuriesClosedPiper PA-28 · Finleyville, PAMay 10, 1970 · N4626R · Substantial damageNTSB NYC70FHA07Accident · No injuriesClosedPiper PA-28 · Wyoming, PAMar 15, 1970 · N7304J · Substantial damageNTSB NYC70DHD10Accident · No injuriesClosedPiper PA-28 · Torresdale, PAMar 7, 1970 · N5714F · Substantial damageNTSB NYC70DHA04Accident · No injuriesClosedPiper PA-28 · Mount Pocono, PAFeb 1, 1970 · N95414 · Substantial damageNTSB NYC70FGM03Accident · No injuriesClosedPiper PA-28 · Monroeville, PAJan 15, 1970 · N3552K · Substantial damage