NTSB investigations: Lycoming O&VO-360 series, 1978, CA

17 cases on aircraft whose registry engine model is Lycoming O&VO-360 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 O&VO-360 series, 1978, CA per year, 1964–2026: 547 cases
196421
196521
196628
196726
196813
196912
197011
197118
197210
19737
197412
19759
19769
197710
197817
197911
198012
198111
198210
198310
198410
198513
198613
198710
19885
19897
19905
19915
19922
19937
19944
19957
19966
19974
19988
19996
200010
20017
200210
200313
200410
200515
200615
20075
20089
20092
20106
20113
20124
20137
20142
20155
20166
20172
20188
20192
20203
20211
20222
20234
20241
20254
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\") = 1978
    AND c.\"eventStateOrRegion\" = 'CA' 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 ('41514'))
  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 OAK79FA004Accident · 1 fatalClosedPiper PA-28 · Galt, CAOct 23, 1978 · N8472F · DestroyedNTSB OAK78DVD58Accident · No injuriesClosedCessna 172 · Santa Rosa, CASep 29, 1978 · N3758F · 2 aircraft · Substantial damageNTSB OAK78DA046Accident · 1 fatalClosedPiper PA-28 · Fort Ross, CASep 4, 1978 · N55002 · DestroyedNTSB OAK78DA045Accident · No injuriesClosedPiper PA-28 · Markleeville, CAAug 29, 1978 · N1601S · Substantial damageNTSB OAK78FVM40Accident · No injuriesClosedBeech C23 · San Jose, CAAug 11, 1978 · N9759L · Substantial damageNTSB OAK78FVA69Accident · Serious injuriesClosedRockwell 112TC · Hanford, CAAug 2, 1978 · N777TP · Substantial damageNTSB OAK78FVM35Accident · No injuriesClosedBeech C23 · Soledad, CAJul 30, 1978 · N2246L · Substantial damageNTSB LAX78FUQ39Accident · No injuriesClosedPitts S-1S · Santa Paula, CAJul 30, 1978 · N100Q · 2 aircraft · Substantial damageNTSB LAX78FUQ38Accident · No injuriesClosedPiper PA-28 · Quartz Hill, CAJul 21, 1978 · N5183S · Substantial damageNTSB LAX78FUG36Accident · Serious injuriesClosedPiper PA-28 · Redlands, CAJun 16, 1978 · N8090W · Substantial damageNTSB OAK78DVG44Accident · No injuriesClosedPiper PA-24 · Bangor, CAMay 29, 1978 · N23BM · Substantial damageNTSB OAK78DVG40Accident · No injuriesClosedBellanca 8GCBC · Vacaville, CAMay 25, 1978 · N8599V · Substantial damageNTSB OAK78FVD36Accident · No injuriesClosedPiper PA-28 · Richmond, CAMay 14, 1978 · N4895L · Substantial damageNTSB OAK78FXQ21Accident · No injuriesClosedBeech C23 · Truckee, CAMay 10, 1978 · N9783L · Substantial damageNTSB OAK78FVD33Accident · Minor injuriesClosedMooney M20A · Santa Rosa, CAMay 2, 1978 · N8110E · Substantial damageNTSB OAK78DVW11Accident · Minor injuriesClosedPiper PA-28 · Lone Pine, CAFeb 19, 1978 · N5993F · Substantial damageNTSB LAX78FA018Accident · 4 fatalClosedBeech C-23 · Mojave, CAJan 2, 1978 · N9723L · Destroyed