NTSB investigations: Lycoming 0-320 series, 1971, 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, 1971, 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\") = 1971
    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 NYC72FGM23Accident · No injuriesClosedCessna 172L · West Mifflin, PADec 10, 1971 · N2853Q · Substantial damageNTSB NYC72DGM22Accident · No injuriesClosedPiper PA-28 · Valencia, PANov 6, 1971 · N7140R · Substantial damageNTSB NYC72FGM19Accident · Minor injuriesClosedPiper PA-28 · Franklin, PAOct 4, 1971 · N6097W · Substantial damageNTSB NYC72FHA17Accident · No injuriesClosedCessna 172 · Kempton, PASep 23, 1971 · N7558G · Substantial damageNTSB NYC72FGM14Accident · No injuriesClosedPiper PA-22 · Prospect, PASep 8, 1971 · N7348D · Substantial damageNTSB NYC72DHA12Accident · No injuriesClosedCessna 172 · Collegeville, PAAug 23, 1971 · N7227G · Substantial damageNTSB NYC72DHA11Accident · No injuriesClosedPiper PA-28 · Prospectville, PAAug 23, 1971 · N7307J · Substantial damageNTSB NYC72DHA06Accident · No injuriesClosedCessna 172I · Berwick, PAAug 1, 1971 · N46315 · Substantial damageNTSB NYC72DGM06Accident · No injuriesClosedCessna 172I · Franklin, PAJul 23, 1971 · N8424L · Substantial damageNTSB NYC71AN114Accident · 1 fatalClosedPiper PA-28 · Reading, PAMay 26, 1971 · N1697T · Substantial damageNTSB NYC71FGM45Accident · No injuriesClosedCessna 172 · Beaver Falls, PAMay 1, 1971 · N35723 · Substantial damageNTSB NYC71FGM43Accident · No injuriesClosedPiper PA-28 · New Castle, PAApr 28, 1971 · N9850W · Substantial damageNTSB NYC71DHA30Accident · No injuriesClosedPiper PA-28 · Easton, PAJan 17, 1971 · N95414 · Substantial damageNTSB NYC71DGM24Accident · No injuriesClosedPiper PA-22 · Johnstown, PAJan 1, 1971 · N2393P · Substantial damage