NTSB investigations: Lycoming 0-320 series, 1966, IN

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, 1966, IN per year, 1964–2026: 258 cases
19647
19657
196613
196712
196810
196910
19706
19718
19728
19736
19743
19759
19763
19776
197813
19799
19806
19816
19824
19832
19843
19852
19862
19876
19886
19893
19906
19914
19922
19935
19943
19963
19973
19984
19993
20002
20013
20022
20032
20044
20053
20061
20083
20093
20103
20124
20134
20143
20151
20161
20172
20181
20192
20203
20211
20222
20232
20241
20251
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\") = 1966
    AND c.\"eventStateOrRegion\" = 'IN' 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 CHI67F0406Accident · No injuriesClosedPiper PA-23 · Middlebury, INNov 28, 1966 · N4054P · Substantial damageNTSB CHI67D0357Accident · No injuriesClosedPiper PA-28 · Logansport, INOct 25, 1966 · N4563R · Substantial damageNTSB CHI67D0105Accident · Minor injuriesClosedPiper PA-22 · Decatur, INJul 11, 1966 · N8942D · Substantial damageNTSB CHI67F0036Accident · Minor injuriesClosedPiper PA25 · New Carlisle, INJun 14, 1966 · N6276Z · Substantial damageNTSB CHI67D0019Accident · No injuriesClosedPiper PA-22 · Lake Village, INMay 23, 1966 · N9605D · Substantial damageNTSB CHI66F0763Accident · No injuriesClosedPiper PA-23 · Michigan City, INMay 18, 1966 · N2189P · Substantial damageNTSB CHI66F0769Accident · Serious injuriesClosedPiper PA-28 · Richmond, INApr 18, 1966 · N6507W · Substantial damageNTSB CHI66F0697Accident · No injuriesClosedPiper PA-28 · Logansport, INApr 17, 1966 · N6371W · Substantial damageNTSB CHI66D0701Accident · No injuriesClosedPiper PA-28 · Cambridge Cty, INApr 8, 1966 · N5783W · Substantial damageNTSB CHI66F0629Accident · No injuriesClosedMooney M20 · Indianapolis, INMar 20, 1966 · N5279B · Substantial damageNTSB CHI66D0615Accident · No injuriesClosedPiper PA-28 · Richmond, INFeb 26, 1966 · N5792W · Substantial damageNTSB CHI66F0581Accident · No injuriesClosedBeechcraft 23 · Wabash, INFeb 13, 1966 · N2324Z · Substantial damageNTSB CHI66D0563Accident · Minor injuriesClosedPiper PA-28 · Muncie, INJan 28, 1966 · N4563R · Substantial damage