Fatal NTSB investigations: Lycoming O&VO-360 series, 1979

19 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
Fatal NTSB investigations: Lycoming O&VO-360 series, 1979 per year, 1964–2026: 576 cases
19642
19652
19668
19675
19689
19695
19706
19714
19722
19735
19757
19764
19777
197826
197919
198020
198120
198215
19839
198414
19858
19868
198717
19889
19898
19906
19913
19928
19939
199411
19957
19965
199711
19986
19995
20006
200117
200221
200325
200418
200514
200611
20076
20089
200911
20109
20118
201213
20136
201411
20152
20167
201713
20189
201916
20205
20214
20224
20237
20244
20253
20267

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\") = 1979
    AND c.\"highestInjuryLevel\" = 'Fatal'
    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 IAD80FA016Accident · 1 fatalClosedPiper PA-23 · Knoxville, TNDec 14, 1979 · N3242P · DestroyedNTSB DEN80FTE12Accident · 2 fatalClosedDelta Dyke · Broomfield, CODec 13, 1979 · N99DD · Substantial damageNTSB SEA80FAMS1Accident · 4 fatalClosedPiper PA-24 · Missing AircraftDec 11, 1979 · N6171P · DestroyedNTSB SEA80FA047Accident · 4 fatalClosedPiper PA-24 · White Pass, WADec 11, 1979 · N6171P · DestroyedNTSB LAX80FA020Accident · 3 fatalClosedPiper PA-24 · Alturas, CANov 24, 1979 · N5664P · DestroyedNTSB MIA79FA126Accident · 2 fatalClosedPiper PA-28 · Hartsville, SCSep 20, 1979 · N5137S · DestroyedNTSB MIA79FA122Accident · 2 fatalClosedPiper PA-28 · Alma, GASep 16, 1979 · N15029 · DestroyedNTSB CHI79FEP76Accident · 2 fatalClosedTom Story WD-6 · Janesville, WISep 2, 1979 · N274WD · DestroyedNTSB SEA79FA050Accident · 4 fatalClosedBeech B23 · Neihart, MTAug 24, 1979 · N7635R · DestroyedNTSB DEN99FA057Accident · 4 fatalClosedPiper PA-28 · Fairview, UTAug 22, 1979 · N6445J · Substantial damageNTSB CHI79FA061Accident · 1 fatalClosedMooney M20C · Brocton, ILJul 26, 1979 · N6217U · DestroyedNTSB MIA79FA093Accident · 1 fatalClosedBeech 95 · Leesburg, FLJun 6, 1979 · N2032C · DestroyedNTSB MIA79FKG41Accident · 1 fatalClosedPitts Spec S-1 · Warner Robins, GAMay 15, 1979 · N42R · DestroyedNTSB NYC79FA045Accident · 2 fatalClosedBeech C-23 · Saltsburg, PAMay 5, 1979 · N6550R · Substantial damageNTSB NYC79FA040Accident · 1 fatalClosedLake LA-4 · Jonesboro, MEApr 20, 1979 · N7639L · DestroyedNTSB CHI79FA045Accident · 2 fatalClosedPiper PA-28 · Veedersburg, INApr 17, 1979 · N1895T · 2 aircraft · DestroyedNTSB OAK79FAMS4Accident · 1 fatalClosedPiper PA-28 · Missing AircraftMar 9, 1979 · N8875J · DestroyedNTSB NYC79FA027Accident · 1 fatalClosedPiper PA-28 · Newark, NJMar 4, 1979 · N6630J · DestroyedNTSB OAK79AA020Accident · 4 fatalClosedBeech 95 · Elko, NVMar 3, 1979 · N644SE · Destroyed