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

26 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, 1978 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\") = 1978
    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 IAD79FA026Accident · 2 fatalClosedCessna 177B · Charlotte, NCDec 31, 1978 · N19580 · DestroyedNTSB LAX79FA022Accident · 4 fatalClosedPiper PA-24 · Springerville, AZDec 20, 1978 · N5734P · DestroyedNTSB FTW79FA022Accident · 1 fatalClosedPiper PA-28 · Hempstead, TXDec 6, 1978 · N3436M · DestroyedNTSB IAD79FA020Accident · 3 fatalClosedPiper PA-24 · Marlinton, WVNov 23, 1978 · N5022P · DestroyedNTSB OAK79FA004Accident · 1 fatalClosedPiper PA-28 · Galt, CAOct 23, 1978 · N8472F · DestroyedNTSB IAD78FIA19Accident · 1 fatalClosedPiper PA-28 · Indian Head, MDSep 23, 1978 · N5179F · DestroyedNTSB SEA78FA066Accident · 4 fatalClosedPiper PA-28 · Hall, MTSep 19, 1978 · N8359C · DestroyedNTSB CHI78FA066Accident · 1 fatalClosedBrantley B-2B · Brook, INSep 11, 1978 · N2284U · DestroyedNTSB OAK78DA046Accident · 1 fatalClosedPiper PA-28 · Fort Ross, CASep 4, 1978 · N55002 · DestroyedNTSB IAD78FA105Accident · 2 fatalClosedCessna 150 · Louisville, KYSep 2, 1978 · N18123 · 2 aircraft · DestroyedNTSB ANC79FA051Accident · 1 fatalClosedBrantly B2-B · Nome, AKJul 14, 1978 · N2281U · Substantial damageNTSB FTW78FPJ29Accident · 1 fatalClosedBellanca 8GCBC · Hinton, OKJul 1, 1978 · N86899 · DestroyedNTSB DEN78FA050Accident · 4 fatalClosedPiper PA-28 · Silverton, COJun 11, 1978 · N9669J · DestroyedNTSB NYC78FA063Accident · 1 fatalClosedBeech 95 · Waterford, CTJun 8, 1978 · N2714Y · Substantial damageNTSB MKC78FA046Accident · 1 fatalClosedPiper PA-28 · Omaha, NEJun 4, 1978 · N1790H · DestroyedNTSB MIA78FA091Accident · 3 fatalClosedMooney M20C · Jackson, ALMay 26, 1978 · N7813V · DestroyedNTSB SEA78FA034Accident · 2 fatalClosedPiper PA-28 · Bremerton, WAMay 21, 1978 · N1914T · DestroyedNTSB IAD78FA061Accident · 1 fatalClosedBeech C23 · The Plains, VAMay 13, 1978 · N24617 · DestroyedNTSB DEN78FA042Accident · 2 fatalClosedBellanca 8GCBC · Nunn, COMay 13, 1978 · N8658V · Substantial damageNTSB MIA78FA063Accident · 1 fatalClosedPiper PA-28 · St.Petersburg, FLApr 8, 1978 · N4731F · DestroyedNTSB SEA78FA023Accident · 4 fatalClosedPiper PA-28 · Milton Frwtr, ORMar 18, 1978 · N1844T · DestroyedNTSB IAD78FA051Accident · 3 fatalClosedPiper PA-28 · Wilmington, DEMar 18, 1978 · N55645 · DestroyedNTSB DEN78FA023Accident · 1 fatalClosedPiper PA-24 · Pojoaque, NMFeb 10, 1978 · N6000D · Substantial damageNTSB DEN78FA021Accident · 4 fatalClosedCessna 177B · Salt Lake City, UTJan 22, 1978 · N18133 · Substantial damageNTSB NYC78FA024Accident · 1 fatalClosedTemco GC1B · Newport, RIJan 14, 1978 · N2406B · DestroyedNTSB LAX78FA018Accident · 4 fatalClosedBeech C-23 · Mojave, CAJan 2, 1978 · N9723L · Destroyed